Skip to content

Home
About Me
Toggle search form
Search for:

Oracle Identifiers Oracle
Single character replacement in Unix Linux/Unix
Kernel Parameters for Solaris Linux/Unix
How to analyze statspack or AWR report. Oracle
OEM-troubleshooting on 20-MAY-08 Oracle
FGA Part-I Oracle
ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
findinfo.sql (SQL for getting CPU and Active session info) Oracle
upload.html PHP/MYSQL/Wordpress
ORA-3136 Oracle
Load SPM baseline from AWR Oracle
longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
Pending Transaction Neighbors Script Oracle
tblwopk.sql tablewopk.sql Oracle
Handling LOB data in Oracle 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

ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
arch_configUOCIOTTO.ora Oracle
TRUNCATE table and disabling referential constraints. Oracle
sid_wise_cursor.sql find open cursor basis on username or SID Oracle
New Latest Param.sql for finding all hidden parameters also Oracle
On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) 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

AWS (2)
Azure (1)
Linux/Unix (149)
Oracle (392)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
Uncategorized (0)
Videos (0)

Recent Posts

load SPM baseline from cursor cache05-Jun-2025
Drop all SPM baselines for SQL handle05-Jun-2025
Load SPM baseline from AWR05-Jun-2025
Drop specific SQL plan baseline – spm05-Jun-2025
findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
How to connect to Oracle Database with Wallet with Python.21-Mar-2025
JSON/XML Types in Oracle18-Mar-2025
CPU Core related projections12-Mar-2025
Exadata Basics10-Dec-2024

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Goog notes on X$ tables Oracle
lck.sql Oracle
How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
get_vmstat.ksh for Solaris Oracle
eplan9i.sql Oracle
Find all users who have DML privileges Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme