Skip to content

Home
About Me
Toggle search form
Search for:

To find all disk io ( EMC as well as local) Linux/Unix
Logic to chech # of parameters command line parameters Linux/Unix
TRUNCATE table and disabling referential constraints. Oracle
Creating never expiring DB user accounts in Oracle Oracle
My Minimum Tuning Programs Oracle
ipcs -l Linux/Unix
Sequence Resetting Oracle
Very clear article about oracle dataguard Oracle
OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
T-SQL Vs PL/SQL Syntax SQL Server
good note for shared pool tunnig Oracle
telnet listening Linux/Unix
How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
create database syntax Oracle
ORA-00064: object is too large to allocate on this O/S during startup 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

Parallel DML Oracle
All Hints for Oracle Databases Oracle
normal maintenance for exp-imp and renaming table Oracle
Trace a SQL session from another session using ORADEBUG Oracle
Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.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

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

Small sample shell program Linux/Unix
find_cons.sql Oracle
Oracle Data Direct to TAPE Oracle
How to Modify the statistics collection by MMON for AWR repository Oracle
Multiple listeners Oracle
Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme