Skip to content

Home
About Me
Toggle search form
Search for:

Locktree.sql Oracle
replace alphabets using sed Linux/Unix
sqlnet.ora paramters Oracle
Index Range Scan Oracle
Oracle Statspack survival Guide Oracle
normal maintenance for exp-imp and renaming table Oracle
DBMS_JOB all example Oracle
remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
Good link for LIO in Oracle ( Logical IOs) Oracle
ext#.sql Oracle
fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
get_vmstat.ksh for Solaris Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
Implementation of key based authentications Linux/Unix

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

Multiple listeners Oracle
crtgr.sql /* For creating trigger from data dictionary */ Oracle
find_log_switch.sql Find log switches in graphical manner Oracle
Explain Plan Output 2 Oracle
Proc Compilation Oracle
Recovering lost SYS password 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 (3)
Videos (0)

Recent Posts

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
track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Renaming Oracle Instance Name Oracle
Rman Notes -1 Oracle
send attachment from unix-shell script Linux/Unix
checking redhat linux version Linux/Unix
block_ident.sql Oracle
Finding Oracle Patches with opatch Oracle
Read CSV file using PySpark Python/PySpark
find_encr_wallet.sql Uncategorized

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme