Skip to content

Home
About Me
Toggle search form
Search for:

Oracle 11g Training on 29JAN1010 Oracle
How does one overcome the Unix 2 Gig file limit? Linux/Unix
How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
Jai Shree Ram Oracle
How to find where datafile is created dbf_info.sql Oracle
How to find password change date for user Oracle
Ports used by Oracle Software Oracle
create user with unlimited quota Oracle
find checksum of a file. Linux/Unix
Find Command Linux/Unix
SQL Tracker by SID sqltrackerbysid.sql Oracle
reset Sequence Oracle
Load SPM baseline from AWR Oracle
Running select from V$ views from remote server Linux/Unix
How to see which patches are applied. 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

refre.sql for multitenant Oracle
PLSQL Table Syntax 1 Oracle
SQL_PLAN.sql for checking real execution plan Oracle
get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
Histogram Overview Oracle
Index Range Scan 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 (400)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (348)
SQL Server (6)
Uncategorized (3)
Videos (0)

Recent Posts

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
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

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

move_arch_files.ksh Linux/Unix
Another Tuning Article for subheap of shared pool Oracle
Temporary Tablespace Information and restriction. Oracle
Another export with Query Oracle
setting prompt display with .profile Linux/Unix
oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
eplan9i.sql Oracle
Check Oracle installed products using one command Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme