Skip to content

Home
About Me
Toggle search form
Search for:

How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
Creating never expiring DB user accounts in Oracle Oracle
Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
Find_stale_dr.sql finding stale physical DR.. Oracle
10g RAC: Troubleshooting CRS Root.sh Problems Oracle
cp_filesystem.sql Oracle
get_vmstat_solaris Oracle
Caching sequence in Memory Oracle
chk_space_SID.ksh Linux/Unix
How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
replacing ^M character when passing files from Windows to Unix Linux/Unix
Roles and Stored Object behaviour Oracle
Deleting first line and lastline of a file using sed Linux/Unix
Recovering lost SYS password Oracle
All About oracle password and security from metalink 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

Wait Based Tuning Step by step with SQL statement Oracle
Good links for x$ tables in oracle. Oracle
How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
v$backup.status information Oracle
Optimizer SORT Operations Oracle
standard Monitoring – 1 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

Guide to Linux System Command Mastery Linux/Unix
How to know Number of CPUs on Sun Box Linux/Unix
Caching sequence in Memory Oracle
Reading config file from other folder inside class Python/PySpark
cur_sql.sql Oracle
Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
Which environment is used by currently running process ( Very good) Linux/Unix
Search and replace pattern Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme