Skip to content

Home
About Me
Toggle search form
Search for:

Sample WW22 listener.ora Oracle
Privilege to describe the table. Oracle
Identical Dblink Issue… Oracle
Processes parameter and its dependencies on OS kernel parameters Linux/Unix
Paste command syntax Linux/Unix
Building Our Own Namespaces with “Create Context” Oracle
runon_allpdbs_show_conname.sh Oracle
process id based files and processes Linux/Unix
Library cahe Latches and internal explaination Oracle
SYSOPER Mystery Oracle
refre.sql for multitenant Oracle
Monitor Long Running Job Oracle
Histogram information Oracle
How to find password change date for user Oracle
load SPM baseline from cursor cache 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

sbind.sql Find Bind variable from sql_id sqlid Oracle
10g oem configuration Oracle
Find Time Consuming SQL Statements in Oracle 10g Oracle
CTAS with LONG Column for 7.x and 8 and 8i Oracle
Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
eplan.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 (149)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
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.sql23-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

Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
To seee semaphores and shared memory segments in Solaris Linux/Unix
Oracle Material from OTN Oracle
Very Good Oralce Internal Tuning Book Oracle
tblwopk.sql /* Find Tables Without PK */ Oracle
pvm_pre_change.sql Oracle
sid_wise_sql.sql Oracle
When to rebuld B-tree index Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme