Skip to content

Home
About Me
Toggle search form
Search for:

create PLAN_TABLE command. Oracle
remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
RAC 11g with vmware Oracle
find the files that are 1 day old. Linux/Unix
How to sort list of files on basis of their sizes. Linux/Unix
Find_planinfo.sql Oracle
Remove duplicate rows from table Oracle
Changing the Global Database Name Oracle
Index Range Scan Oracle
Reading config file from other folder inside class Python/PySpark
send attachment from unix-shell script Linux/Unix
SQL_PLAN.sql for checking real execution plan Oracle
Oracle 10g Installation/Applying Patches Tips Oracle
How to remove blank lines using vi editor command Linux/Unix
Some OS level threshold for performance. 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

Load testing on Oracle 19C RAC with HammerDB Oracle
Disbaling DBA_SCHEDULER_JOBS Oracle
db_status.sql Oracle
pvm_rbs1.sql (to collect rbs info from db) Oracle
Implementing Listener Security Oracle
compile_inv.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 (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
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

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
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

proper cpu stats Linux/Unix
SQL Server: How to see historical transactions SQL Server
get_vmstat_linux Oracle
Export With Query Another Example. Oracle
sess_server.sql Oracle
ORACLE_SID in sqlplus Oracle
Good notes on Oracle Events Oracle
executing Function from SQLPLUS prompt Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme