Skip to content

Home
About Me
Toggle search form
Search for:

Find long Running Transaction Linux/Unix
adding new line after specific pattern using sed Linux/Unix
Goldengate document from Porus Oracle
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
SQL Server: How to see historical transactions SQL Server
How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
RAC with RHEL4 and 11g Oracle
Export Import with QUERY Oracle
crontab syntax Linux/Unix
cur_sql.sql Oracle
Oracle 11g Training on 29JAN1010 Oracle
_B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
Oracle 10g Installation/Applying Patches Tips Oracle
How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
ORA-00064: object is too large to allocate on this O/S during startup 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

runon_allcdbs_find_pdbs.sh Linux/Unix
get_vmstat_linux Oracle
runon_allpdbs_show_conname.sh Oracle
Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
First Entry in RAC Oracle
Jai Shree Ram 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 (150)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (151)
SQL scripts (349)
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.sh23-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

Zip and unzip with tar Linux/Unix
CPU speed on solaris Linux/Unix
SQL_PROFILE – I explaination Oracle
to see when crontab is changed. Linux/Unix
plan10g.sql good Oracle
plan10g.sql good1 Oracle
Key Management in Oracle: The Core Issue: Missing Master Key Oracle
purge_trc.sh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme