Skip to content

Home
About Me
Toggle search form
Search for:

TRUNCATE Privs Oracle
Passing from Unix to PLSQL using bind variables Linux/Unix
Checking SQL Server Version SQL Server
PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
Finding locked objects Oracle
Find long Running Transaction Linux/Unix
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
get_vmstat.ksh Linux/Unix
proc.sql Oracle
arch_configUOCIOTTO.ora Oracle
executing Function from SQLPLUS prompt Oracle
Histogram Overview Oracle
Identical Dblink Issue… Oracle
Display the top 5 salaries for each department using single SQL Oracle
Wait Based Tuning Step by step with SQL statement 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

Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
Insert cause enqueue locks Oracle
TRUNCATE table and disabling referential constraints. Oracle
get_vmstat_linux Oracle
Finding Oracle Patches with opatch Oracle
load SPM baseline from cursor cache 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

How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
V$transaction notes for finding XID composition. Oracle
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
v$backup.status information Oracle
sess_server.sql Oracle
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
Identical Dblink Issue… Oracle
scripts to take listener.log backup Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme