Skip to content

Home
About Me
Toggle search form
Search for:

Proc code Oracle
On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
Caching sequence in Memory Oracle
How to find where datafile is created dbf_info.sql Oracle
Database logon trigger issue Oracle
284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
Find Time Consuming SQL Statements in Oracle 10g Oracle
Recovering lost SYS password Oracle
Sending email with file attachment. Linux/Unix
find_cons.sql Oracle
Passing from Unix to PLSQL using bind variables Linux/Unix
temp_use.sql diplays usage of temp ts Oracle
plan10g.sql good Oracle
Oracle Internal Good Websites 1 Oracle
How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, 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

Reclaim temp tablespace for oracle 8, 8i Oracle
DB Console Mainenance. Oracle
Rownum with Order by Oracle
Creating never expiring DB user accounts in Oracle Oracle
Index Range Scan Oracle
Proc code 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 (392)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

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
MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
Passing from Unix to PLSQL using bind variables Linux/Unix
v$event_name Oracle
751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
How to check current redo log progress redo_progress.sql Oracle
crtgr.sql /* For creating trigger from data dictionary */ Oracle
Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
Import and export statements Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme