Skip to content

Home
About Me
Toggle search form
Search for:

How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
Find total file sizes Linux/Unix
Zip and unzip with tar Linux/Unix
PLSQL Table Syntax 2 Oracle
sess1.sql Oracle
Distributed Transaction Troubleshooting. Oracle
Rename Tablespace Oracle
CTAS with LONG Column for 9i and higher Oracle
oracle fast start failover best practice Oracle
Mutating Table Error while using database trigger Oracle
Exadata Basics Oracle
Find Time Consuming SQL Statements in Oracle 10g Oracle
get_vmstat_solaris Oracle
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
First Entry in RAC 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

find_string_in_database.sql Oracle
Locktree.sql Oracle
Remove duplicate rows from table Oracle
logminer and my_lbu Oracle
oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
CTAS with LONG Column for 9i and higher 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 (402)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
SQL Server (6)
Uncategorized (5)
Videos (0)

Recent Posts

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.sql23-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
Creating a Container Database using dbaascli08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Disbaling DBA_SCHEDULER_JOBS Oracle
sesswait.sql Oracle
Export Import with QUERY Oracle
DBMS_STATS Metalinks Notes Oracle
Rman Notes -1 Oracle
Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
Wait time tuning research Oracle
longtx.sql with the flag whether session is blocking any DML locks or not. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme