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
To Find out Transaction in Production Database
Subscribe to:
Post Comments (Atom)
Let us be Friends...
Popular Posts
-
This is great News from oracle, that the new Version of JRE 1.6.0 Update 23 is being certified to use with Oracle EBS. Those who are all w...
-
While upgrading Fusion Applications, After enabling ldapsync between OIM and OID, only a few users orcladmin,public,policyROUser, and Poli...
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
MWA configuration in Oracle Applications Consider these points 1. Check if Enabled Telnet on the server If no.. please do the following step...
-
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...
-
The Following Error was detected while doing Cloning of DB Tier. The actual Fact was: The server was heavily loaded, so the control file cre...
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
This blog speaks about the Login Page Issue on R12.1.1 instance. Suddenly the login page was throwing an error - 404 /OA_HTML/AppsLogin was ...
-
This blog is about Configuring the Apex PDF printing with Apache FOP. You need to download the OC4J from here You move the downloaded file t...
-
In a default configuration of Oracle Applications the user validating and sign on is done at the database level. For this purpose the FND_US...
No comments:
Post a Comment