Skip to content

Home
About Me
Toggle search form
Search for:

USE_NL and INDEX hints example Oracle
Korn Shell Arithmatic Linux/Unix
SQL Server: How to see historical transactions SQL Server
Temporary Tablespace Information and restriction. Oracle
tracksqltime.sql Oracle
Mutating Table Error while using database trigger Oracle
upload.html PHP/MYSQL/Wordpress
SQLPLUS COPY command Precautions. Oracle
Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
load SPM baseline from cursor cache Oracle
scripts to take listener.log backup Linux/Unix
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
Proc code Oracle
Another export with Query Oracle
Processes Parameter decision 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

login.sql Oracle
dbinv.sql Oracle
Alter procedure auditing Oracle
ORACLE_SID in sqlplus Oracle
V$ROLLSTAT status is Full Oracle
Mutating Table Error while using database trigger 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 (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 (5)
Videos (0)

Recent Posts

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
find_pdbs.sql08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Oracle Identifiers Oracle
Configure ssh authentications for RAC Oracle
How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
DBMS_UTILITY.ANALYZE_SCHEMA Oracle
339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
lck.sql Oracle
Transfer SQL Profiles from One database to other database. Oracle
chk_space_SID.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme