Skip to content

Home
About Me
Toggle search form
Search for:

Temporary tablespace explaination Oracle
ext#.sql Oracle
grep multuple patterns Linux/Unix
Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
Creating a Container Database using dbaascli Uncategorized
sbind.sql Find Bind variable from sql_id sqlid Oracle
Display the top 5 salaries for each department using single SQL Oracle
Remove duplicate rows from table Oracle
How can I tell if ASO is installed ? Oracle
Wait Based Tuning Step by step with SQL statement Oracle
set_env_dba Linux/Unix
scripts to take listener.log backup Linux/Unix
Oracle Material from OTN Oracle
USE_NL and INDEX hints example Oracle
How to Use DBMS_STATS to Move Statistics to a Different Database 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

First Entry in RAC Oracle
Creating never expiring DB user accounts in Oracle Oracle
Rownum with Order by Oracle
Oracle Metalink useful notes Oracle
Order by with ROWNUM Oracle
UNderstand and eliminate Latch contention. 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

AMC10 (0)
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 (6)
Videos (0)

Recent Posts

AMC1020-Sep-2026
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

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

get_aix_vmstat.ksh Oracle
All Hints for Oracle Databases Oracle
How to check current redo log progress redo_progress.sql Oracle
Implementation of key based authentications Linux/Unix
AMC10 Uncategorized
To seee semaphores and shared memory segments in Solaris Linux/Unix
good linux notes Linux/Unix
move_arch_files.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme