Skip to content

Home
About Me
Toggle search form
Search for:

How to check current redo log progress redo_progress.sql Oracle
Specify the Rollback segment to use in Transaction Oracle
Updated LCK.SQL file. Oracle
column level grant syntax Oracle
Export With Query Another Example. Oracle
metalink all dynamic view reference notes. Oracle
Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
Btee and Bitmap Plans in Oracle 9i and higher Oracle
Good notes for shared pool Oracle
How to calculate PROCESSES parameter Oracle
How to Modify the statistics collection by MMON for AWR repository Oracle
checking redhat linux version Linux/Unix
Free API credits for AI models Uncategorized
Find long Running Transaction Linux/Unix
Histogram Overview 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

ORA-8031 issue and solution if it is occuring due to truncate. Oracle
CTAS with LONG Column for 7.x and 8 and 8i Oracle
Privilege to describe the table. Oracle
Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
Oracle Material from OTN Oracle
Find average Row Length and other table size calculation. metalink notes 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

AMC10 (0)
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 (9)
Videos (0)

Recent Posts

Tutornet.US — Source of excellent learning14-Oct-2026
OCI Infrastructure Patching14-Oct-2026
Free API credits for AI models14-Oct-2026
AMC1020-Sep-2026
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

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
Roles and Stored Procs II Oracle
adding new line after specific pattern using sed Linux/Unix
catting.sh Linux/Unix
Another Tuning Article for subheap of shared pool Oracle
Reclaim temp tablespace for oracle 8, 8i Oracle
Drop database in Oracle 10g Oracle
Identical Dblink Issue… Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme