Skip to content

Home
About Me
Toggle search form
Search for:

Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
create user with unlimited quota Oracle
Library cahe Latches and internal explaination Oracle
Jai Shree Ram Oracle
sqlnet.ora paramters Oracle
Adding Datafile on Primary Server and Impact on Standby Server Oracle
Changing Instance Name ( No DB_NAME) Oracle
Changing default shell Linux/Unix
Oracle Data Direct to TAPE Oracle
Resolving RMAN Hung Jobs Oracle
Small sample shell program Linux/Unix
shutdown linux Linux/Unix
V$ROLLSTAT status is Full Oracle
logminer and my_lbu Oracle
Identical Dblink Issue… 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

My Test Case On 21-OCT-2005 Oracle
Roles and Stored Procs II Oracle
Find all users who have DML privileges Oracle
Specify the Rollback segment to use in Transaction Oracle
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
FGA Part-I 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 (1)
Azure (0)
Linux/Unix (148)
Oracle (382)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (4)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (335)
Uncategorized (0)
Videos (0)

Recent Posts

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
Getting started with notebook30-Sep-2023
Read CSV file using PySpark30-Sep-2023
Read CSV File using Python30-Sep-2023
Creating never expiring DB user accounts in Oracle14-Sep-2023
Convert multiple rows to single column13-Sep-2023
Find all users who have DML privileges05-Sep-2023
Oracle GoldenGate lag monitoring shell script12-Jun-2023

Archives

2024
2023
2010
2009
2008
2007
2006
2005

sesswait.sql Oracle
database trigger failing Oracle
Backup and Recovery Scenarios Oracle
Absolute file number and relative file number Oracle
Goldengate Tutorial Oracle
Find_table_size.sql Oracle
v$backup.status information Oracle
Generate SSH without password authentication. Linux/Unix

Copyright © 2024 pvmehta.com.

Powered by PressBook News WordPress theme