Skip to content

Home
About Me
Toggle search form
Search for:

TOP-N Sql to find Nth max or Top N rows Oracle
556976.1 Oracle Clusterware: Components installed Oracle
telnet listening Linux/Unix
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
Query to Generate aggregate on every 30 mins. Oracle
Goog notes on X$ tables Oracle
Some useful Unix Commands Linux/Unix
sess1.sql Oracle
To Find Orphan OS processes. Linux/Unix
restarting network in linux Linux/Unix
handling filenname with space Linux/Unix
online_bkup.sql Oracle
alter database backup controlfile to trace Oracle
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
tar and untar a dolder with all its subfolder. 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

create trigger syntax Oracle
AWR settings- MMON is not taking snapshot. Oracle
Resolving RMAN Hung Jobs Oracle
Multiple listeners Oracle
Histogram information Oracle
Wait.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)
Linux/Unix (149)
MYSQL (5)
Oracle (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (342)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

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
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

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
sid_wise_cursor.sql find open cursor basis on username or SID Oracle
Find Stale DR Physical Standby Oracle
Roles and Stored Object behaviour Oracle
Renaming Global Name GLOBAL_NAME Oracle
get_aix_vmstat.ksh Oracle
Search and replace pattern Linux/Unix
How to sort list of files on basis of their sizes. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme