This post is having a query which estimates the transactions done in a period of time in a database.
sql> alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MM:SS'
session altered
sql> select BEGIN_TIME,END_TIME,TXNCOUNT
,(( END_TIME - BEGIN_TIME ) * 24 * 60 * 60 ) diffsecond
, to_char(( TXNCOUNT / (( END_TIME - BEGIN_TIME ) * 24 * 60 * 60 )),'999999.99') tranxpersecond
from v$undostat where BEGIN_TIME >='&1'
and BEGIN_TIME <='&2'
and ( TXNCOUNT / (( END_TIME - BEGIN_TIME ) * 24 * 60 * 60 )) > 50
order by 1;
Enter date in the format like 30-APR-2010 12:00:00
for Enter value 1 and Value 2
It will give you the approximate transaction from undotablespace.
Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.
You are encouraged to leave a comment.
You are encouraged to leave a comment.
Saturday, May 01, 2010
Subscribe to:
Posts (Atom)
Let us be Friends...
Popular Posts
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
This was a biggest issue we were facing at the point of implementation. We were getting the reports designed in Developer and all are displa...
-
Primary Node: Host name: genius.chainsys.com IP : 192.168.2.236 File locations: apps - /oracle/D1/apps (SHARED) db - /oracle/PROD/db inst - ...
-
1. Installation of the Demantra Base Application or Patches Create a C:/Tmp folder on the machine where the setup.exe will be executed pri...
-
Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profil...
-
Today, I need to blog out my experience with Apex integration with R12 E Business Suite!!! How I did: as follows. As you know how to install...
-
Linux platform migration provides a way to quickly and easily move an existing Oracle Applications middle tier System from any platform to ...
-
Symptom: A MultiException has 6 exceptions. They are: 1. java.lang.AssertionError: Cannot export non clusterable object with jndiName:weblo...
-
In Oracle Application 11i and R12, we have an FND functionality for changing the passwords for either application user, or product schema pa...