Skip to content

Home
About Me
Toggle search form
Search for:

Privilege to describe the table. Oracle
Updated LCK.SQL file. Oracle
move_arch_files.ksh Linux/Unix
CPU Core related projections AWS
Kernel Parameter setting explaination for Processes Parameter Linux/Unix
Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
SQL_PROFILE – I explaination Oracle
good note for shared pool tunnig Oracle
Sample WW22 listener.ora Oracle
cur_sql.sql Oracle
Btee and Bitmap Plans in Oracle 9i and higher Oracle
Optimizer SORT Operations Oracle
oracle Dba site Oracle
Oracle Support Metalink ID 161818.1 Oracle
Composite Index creation tip from Vivek Oracle

To see how much time or progress of long transaction

Posted on 30-Sep-2009 By Admin No Comments on To see how much time or progress of long transaction

select * from v$session_longops where sid=100;

Oracle, SQL scripts

Post navigation

Previous Post: cp_filesystem.sql

Next Post: replacing ^M character when passing files from Windows to Unix

Related Posts

Facts about SCN and Rollback Segment Oracle
DBMS_STATS Metalinks Notes Oracle
Backup and Recovery Scenarios Oracle
standard Monitoring – 1 Oracle
Rename Oracle Instance Name Oracle
How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, 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 (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
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

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
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

setting prompt display with .profile Linux/Unix
eplan.sql Oracle
CPU speed on Linux Linux/Unix
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
Reading parameter file and printing Linux/Unix
oracle 11g RAC on vmware Oracle
Oracle 11g Environment Setup Oracle
ORA-01220 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme