Skip to content

Home
About Me
Toggle search form
Search for:

oracle fast start failover best practice Oracle
process id based files and processes Linux/Unix
How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
Oracle GoldenGate lag monitoring shell script Linux/Unix
find_pdbs.sql Uncategorized
Rename Tablespace Oracle
.profile Linux/Unix
replacing ^M character when passing files from Windows to Unix Linux/Unix
SQLPLUS COPY command Precautions. Oracle
v$backup.status information Oracle
Index Range Scan Oracle
standard Monitoring – 1 Oracle
Resolving RMAN Hung Jobs Oracle
CPU speed on Linux Linux/Unix
My Test Case On 21-OCT-2005 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

Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
Renaming the column name Oracle
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
Oracle Data Direct to TAPE 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 (150)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (151)
SQL scripts (349)
SQL Server (6)
Uncategorized (5)
Videos (0)

Recent Posts

Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
SAT Mathematics 10 questions and answer at the end.30-Apr-2026
top 10 AI news today30-Apr-2026
runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sh23-Apr-2026
Running PDB on single node in RAC09-Apr-2026
find_arc.sql09-Apr-2026
pvm_pre_change.sql08-Apr-2026
find_encr_wallet.sql08-Apr-2026
find_pdbs.sql08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
ORA-3136 Oracle
USE_NL and INDEX hints example Oracle
True Session Wait Activity in Oracle 10g Verygood Oracle
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
MYSQL for Oracle DBA MYSQL
TOP-N Sql to find Nth max or Top N rows Oracle
Formatter Explain plan Output 1 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme