Skip to content

Home
About Me
Toggle search form
Search for:

get_vmstat_solaris Oracle
good linux notes Linux/Unix
Find average Row Length and other table size calculation. metalink notes Oracle
pvm_rbs1.sql (to collect rbs info from db) Oracle
Add new columns in dataframe Python/PySpark
SQL Server: How to see historical transactions SQL Server
column level grant syntax Oracle
oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
move_arch_files.ksh Linux/Unix
To find all disk io ( EMC as well as local) Linux/Unix
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
How to calculate PROCESSES parameter Oracle
CPU Core related projections AWS
Changing Instance Name ( No DB_NAME) Oracle
Jai Shree Ram 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

fkwoindex.sql /* Find FK without Index */ Oracle
FGA Part-I Oracle
Changing the Global Database Name Oracle
Jai Shree Ram Oracle
Composite Index creation tip from Vivek Oracle
proc.sql 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 (395)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (150)
SQL scripts (343)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026
Complete Git Tutorial for Beginners25-Dec-2025
Postgres DB user and OS user.25-Dec-2025
Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
run this before doing any dbchange pvm_pre_change.sql Oracle
Composite Index creation tip from Vivek Oracle
Difference between SYNC and AFFIRM Oracle
UNderstand and eliminate Latch contention. Oracle
cold backup scripts to copy locally Linux/Unix
FRA Information. Oracle
Mutating Table Error while using database trigger Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme