Skip to content

Home
About Me
Toggle search form
Search for:

Debugging Shell FIles Linux/Unix
Privilege to describe the table. Oracle
age_alert.ksh aging out alert.log Linux/Unix
shutdown linux Linux/Unix
JSON/XML Types in Oracle Oracle
Unix split command to split files Linux/Unix
database trigger failing Oracle
SQL Server: How to see current transactions or requests SQL Server
Find_table_size.sql Oracle
How can I tell if ASO is installed ? Oracle
Multiple listeners Oracle
Wait.sql Oracle
find_longsql.sql Oracle
Find All internal Parameters Oracle
SQL_PROFILE – I explaination 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

RAC with RHEL4 and 11g Oracle
run this before doing any dbchange pvm_pre_change.sql Oracle
Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
crtgr.sql /* For creating trigger from data dictionary */ Oracle
Jai Shree Ram 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

Roles and Stored Object behaviour Oracle
Oracle Material from OTN Oracle
DBMS_Shared_pool pinning triggers Oracle
Removing Ctrl-M from end of line using vi Linux/Unix
Some useful Unix Commands Linux/Unix
ORA-00064: object is too large to allocate on this O/S during startup Oracle
remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
Histogram Overview Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme