Skip to content

Home
About Me
Toggle search form
Search for:

eplan.sql Oracle
Removing Ctrl-M from end of line using vi Linux/Unix
get_vmstat_solaris Oracle
Query to Generate aggregate on every 30 mins. Oracle
Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
Find total file sizes Linux/Unix
276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
Optimizer SORT Operations Oracle
Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
Benefits and Usage of RMAN with Standby Databases Oracle
segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
alter database backup controlfile to trace Oracle
restarting network in linux Linux/Unix
Find Plan Hash value fphv.sql Oracle
Proc code 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

sid_wise_sql.sql Further explaination Oracle
exp syntax in oracle 10g Oracle
556976.1 Oracle Clusterware: Components installed Oracle
Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
online_ts_bkup.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

AWS (2)
Azure (1)
Linux/Unix (149)
Oracle (387)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (336)
Uncategorized (0)
Videos (0)

Recent Posts

SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
How to connect to Oracle Database with Wallet with Python.21-Mar-2025
JSON/XML Types in Oracle18-Mar-2025
CPU Core related projections12-Mar-2025
Exadata Basics10-Dec-2024
Reading config file from other folder inside class24-Sep-2024
Python class import from different folders22-Sep-2024
Transfer SQL Profiles from One database to other database.05-Sep-2024
Load testing on Oracle 19C RAC with HammerDB18-Jan-2024
Add new columns in dataframe30-Sep-2023

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
To see only files and/or folders using LS command Linux/Unix
DBMS_UTILITY.ANALYZE_SCHEMA Oracle
Find All internal Parameters Oracle
Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
Load testing on Oracle 19C RAC with HammerDB Oracle
Adding addidional hard drive and attach it to a linux box. Linux/Unix
ORA-01220 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme