Skip to content

Home
About Me
Toggle search form
Search for:

Oracle 10g Installation/Applying Patches Tips Oracle
272332.1 CRS 10g Diagnostic Collection Guide Oracle
Zip and unzip with tar Linux/Unix
find_string_in_database.sql Oracle
Absolute file number and relative file number Oracle
Rman Notes -1 Oracle
Rownum with Order by Oracle
Remove duplicate rows from table Oracle
Removing Ctrl-M from end of line using vi Linux/Unix
scp with ssh2 Linux/Unix
useful dg links Oracle
Monitor and Trace Unix processes using truss Linux/Unix
Good link for LIO in Oracle ( Logical IOs) Oracle
Goog notes on X$ tables Oracle
How do I get Oracle to automatically start when my server boots up? 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

Implementing Listener Security Oracle
Jai Shree Ram Oracle
Good Doc 28-JUN-2006 Oracle
load SPM baseline from cursor cache Oracle
segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
How to find password change date for user 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

replace alphabets using sed Linux/Unix
mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
This is im telling Kishore Oracle
Specify the Rollback segment to use in Transaction Oracle
Ports used by Oracle Software Oracle
CPU speed on Linux Linux/Unix
chk_space_SID.ksh Linux/Unix
Remove DOS CR/LFs (^M) Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme