Skip to content

Home
About Me
Toggle search form
Search for:

My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
create PLAN_TABLE command. Oracle
Very clear article about oracle dataguard Oracle
Good RAC & Standby Notes Oracle
Unix command for system configuration Linux/Unix
Nice notes on wait events Oracle
Running select from V$ views from remote server Linux/Unix
Implementing Listener Security Oracle
online_ts_bkup.sql Oracle
temp_use.sql diplays usage of temp ts Oracle
How can I tell if ASO is installed ? Oracle
good note for shared pool tunnig Oracle
Wait Based Tuning Step by step with SQL statement Oracle
default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
Explain Plan Output 2 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

Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
USE_NL and INDEX hints example Oracle
findinfo.sql (SQL for getting CPU and Active session info) Oracle
GSQ.sql Oracle
Generating XML from SQLPLUS Oracle
find_log_switch.sql Find log switches in graphical manner 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

get_aix_vmstat.ksh Oracle
Processes Parameter decision Oracle
Display the top 5 salaries for each department using single SQL Oracle
Check SQL Server edition SQL Server
DBMS_JOB all example Oracle
Load testing on Oracle 19C RAC with HammerDB Oracle
metalink all dynamic view reference notes. Oracle
Vivek Tuning for Row Locks. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme