The Application DBA
home
about AppsDBA
consulting
system management
workload
db admin
checklist
db config
file layout
file naming
constraints
pfile
network
publications
tech info
scripts
apps scripts
sql scripts
xplan scripts
top sessions scripts
sql trace scripts
unix scripts
code snippets
sql snippets
pl/sql snippets
java snippets
scripting snippets
opensource
utilities
workmon
sqlmon
resource profiler
other links
Oracle SQL Top Sessions Scripts
topsess_create.sql
-
Creates the table and a sequence needed for the session snaps.
topsess_snap.sql
-
Takes a snapshot of the current session data. At least two snaps must be taken before a query can be run.
topsess_query.sql
-
Runs the topsession query which shows the delta workload rate between the last two snaps.
Copyright © 1998-2012 AppsDBA Consulting. All Rights Reserved.