Skip to content

Home
About Me
Toggle search form
Search for:

Distributed Transaction Troubleshooting. Oracle
Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
Which environment is used by currently running process ( Very good) Linux/Unix
pvm_metric.sql for gathering report from vmstat tables Oracle
Some OS level threshold for performance. Linux/Unix
How to see which patches are applied. Oracle
How to sort list of files on basis of their sizes. Linux/Unix
Find Time Consuming SQL Statements in Oracle 10g Oracle
Reclaim temp tablespace for oracle 8, 8i Oracle
272332.1 CRS 10g Diagnostic Collection Guide Oracle
Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
Changing unix system clock when Oracle database is running. Oracle
Looping for remote servers and find its database from oratab file. Linux/Unix
Monitor Long Running Job Oracle

How to know current SID

Posted on 30-Aug-2006 By Admin No Comments on How to know current SID

SQL> select distinct sid from v$mystat;

SID

———-

1365

Oracle, SQL scripts

Post navigation

Previous Post: Passing from Unix to PLSQL using bind variables

Next Post: sbind.sql Find Bind variable from sql_id sqlid

Related Posts

V$transaction notes for finding XID composition. Oracle
Temporary Tablespace Information and restriction. Oracle
Rename Tablespace Oracle
Good link for LIO in Oracle ( Logical IOs) Oracle
Renaming Oracle Instance Name Oracle
track_autoupgrade_copy_progress.sql Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (150)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (151)
SQL scripts (349)
SQL Server (6)
Uncategorized (5)
Videos (0)

Recent Posts

Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
SAT Mathematics 10 questions and answer at the end.30-Apr-2026
top 10 AI news today30-Apr-2026
runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sh23-Apr-2026
Running PDB on single node in RAC09-Apr-2026
find_arc.sql09-Apr-2026
pvm_pre_change.sql08-Apr-2026
find_encr_wallet.sql08-Apr-2026
find_pdbs.sql08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

upload.html PHP/MYSQL/Wordpress
Histogram information Oracle
Removing Ctrl-M from end of line using vi Linux/Unix
Guide to Linux System Command Mastery Linux/Unix
Locktree.sql Oracle
How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
DBMS_SQL for alter session. Oracle
PLSQL Table Syntax 1 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme