Skip to content

Home
About Me
Toggle search form
Search for:

Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
Implementation of key based authentications Linux/Unix
Korn Shell Arithmatic Linux/Unix
Find All internal Parameters Oracle
The most important Tuning Notes Oracle
SAN Linux/Unix
Kill a session dynanically using execute immediate Oracle
create user with unlimited quota Oracle
oracle fast start failover best practice Oracle
Backup and Recovery Scenarios Oracle
Which environment is used by currently running process ( Very good) Linux/Unix
Finding Oracle Patches with opatch Oracle
dbms_job.submit example Oracle
Privilege to describe the table. Oracle
adding new line after specific pattern using sed Linux/Unix

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

How to see which patches are applied. Oracle
oracle 11g RAC on vmware Oracle
Alter procedure auditing Oracle
sess1.sql Oracle
ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
Oracle Standby Database Library Index from Metalink 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

AWS (1)
Azure (0)
Linux/Unix (148)
Oracle (382)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (6)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (335)
Uncategorized (0)
Videos (0)

Recent Posts

Reading config file from other folder inside class24-Sep-2024
Python class import from different folders22-Sep-2024
Transfer SQL Profiles from One database to other database.05-Sep-2024
Load testing on Oracle 19C RAC with HammerDB18-Jan-2024
Add new columns in dataframe30-Sep-2023
Getting started with notebook30-Sep-2023
Read CSV file using PySpark30-Sep-2023
Read CSV File using Python30-Sep-2023
Creating never expiring DB user accounts in Oracle14-Sep-2023
Convert multiple rows to single column13-Sep-2023

Archives

2024
2023
2010
2009
2008
2007
2006
2005

Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
Implementation of key based authentications Linux/Unix
create a folder in multiple places Linux/Unix
get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
Linux CPU info. Linux/Unix
New OFA for 11g Oracle
ORA-8031 issue and solution if it is occuring due to truncate. Oracle
Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle

Copyright © 2024 pvmehta.com.

Powered by PressBook News WordPress theme