• Arun Kumar

Find Current Session SID in Oracle

Sometimes when you are connected to Oracle database, you might need to find your own session SID and serial number. Below are the two queries that can help you find SID and serial number of current sessions that you connected with

Find SID in normal database

In a normal standalone database, use below query

select sid from v$mystat where rownum=1;

Find SID in RAC database

In a RAC database, you must also know the details of the instance that you are connected with. Below query will give you SID, serial # along with the instance number

WHERE sid=(select sid from v$mystat where rownum=1); 


Recent Posts

See All

Generate Table DDL Command

The DBMS_METADATA package allows you to generate DDL commands for any of the database objects inside Oracle database. Generate Table DDL Command Generate View DDL Command Generate Materialized View DD

Temp Tablespace Utilization

It is very common that as a DBA you will encounter ‘ORA-1652: unable to extend temp segment’. Handling temporary tablespace is different than permanent tablespaces inside Oracle. On a high level, temp