Skip to content

Home
About Me
Toggle search form
Search for:

Korn Shell Arithmatic Linux/Unix
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
proc.sql Oracle
TOP-N Sql to find Nth max or Top N rows Oracle
findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
Monitor Long Running Job Oracle
My Minimum Tuning Programs Oracle
pvm_rbs1.sql (to collect rbs info from db) Oracle
Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
sesswait.sql Oracle
Find Stale DR Physical Standby Oracle
AWR settings- MMON is not taking snapshot. Oracle
pvm_metric.sql for gathering report from vmstat tables Oracle
eplan9i.sql Oracle
272332.1 CRS 10g Diagnostic Collection Guide 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

db_status.sql Oracle
Find sort details from Db find_sort.sql Oracle
create database syntax Oracle
Benefits and Usage of RMAN with Standby Databases Oracle
Jai Shree Ram Oracle
Oracle Standby Database Library Index from Metalink 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 (397)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (150)
SQL scripts (345)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026
prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026
Complete Git Tutorial for Beginners25-Dec-2025
Postgres DB user and OS user.25-Dec-2025
Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

find_longsql.sql Oracle
Index Range Scan Oracle
Free conference number from http://www.freeconference.com Oracle
find_open_cur.sql Find open cursorts per session Oracle
Shuffle an array PHP/MYSQL/Wordpress
Debugging Shell FIles Linux/Unix
339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
Settting up get_vmstat.sh for colletinf CPU Usage. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme