swsw SW session wait level; all sessions!
swenq SW enqueue details
swenqc SW enqueue details by count
swenqx SW enqueue detail (
)
swname SW event name and display name (
)
-- wait time histogram related scripts and reports, see readmeEventHist.txt
swgettimes Get individual event occurrence times (
)
swEhChart.r Create 2 pages of nice histograms based on OSM report output
swEhVdGet Get v$event_histogram wait times and gen output for swEhChart.r
(
)
swEhAwrGet Get v$event_histgroam times from AWR (DBA_HIST_) and gen output for swEhChart.r
swhist Get v$event_hist bin counts. Output can be used with swEhChart.r (
)
swhistx Get delta v$event_hist bin counts. Output Can be used with swEhChart.r (
)
-- OS CPU Utilization (very old scripts)
oscpux OS CPU consumption
oracpu Oracle CPU breakdown (since startup)
oracpux Oracle CPU breakdown (delta)
timechk x Check Oracle's CPU consumption time (v$sysstat based) reporting (
)
-- Object Details
objloc Object location listing (
)
objfb Object details for a given file and block (
)
bcobjfb Object details for a ... in cache (
)
-- Research Helpers
mkodo Create the odometer (odo) table and indexes.
mkodo_ouch Same, but with a commit after each insert.
cycledb9tx Cycle the current db instance (O 9,10,11,12) - Be careful!
listeventcodes list all the Oracle event codes (
)
OSM Management
osmprep Prepare the OSM Interactive environment
osmtitle Standard OSM Interactive title script (other similar scripts)
osmclear Standard OSM Interactive end of script clear stuff
OraPub System Monitor - Interactive Analysis Menu
(c)1998-2015 OraPub, Inc. - Free use, just keep company and author name
OraPub Online Institute - Because Oracle DBAs need great training NOW.
SQL> @swpct
Enter value for 1:
SP2-0137: DEFINE requires a value following equal sign
Enter value for filter:
from o$event_type
*
ERROR at line 12:
ORA-00942: table or view does not exist
SQL> @dfio
Enter value for osm_title2:
Database: ora11g 21-Apr 02:51am
Report: dfio.sql OSM by OraPub, Inc. Page 1
Oracle DB File I/O Information
Write Blk Bytes Read Blk Bytes
Data File Req(k) Writes(k) Writes(M) Req(k) Reads(k) Reads(M) MBR%
---------------------------------------- ---------- ---------- ---------- ----------- ----------- ----------- -----
Redo Log Files 48 -1 2,066 -1 -1 -1 -1.0
/u01/app/oradata/ora11g/users01.dbf 93 226,706 1,771 43 603 4,710 11.1
/u01/app/oradata/ora11g/sysaux01.dbf 38 80,750 631 399 445 3,478 0.9
/u01/app/oradata/ora11g/undotbs01.dbf 31 80,444 628 0 0 1 0.8
/u01/app/oradata/ora11g/system01.dbf 13 30,732 240 105 191 1,490 1.4
/u01/app/oradata/ora11g/examples.dbf 0 2,259 18 13 16 126 1.0
/u01/app/oradata/ora11g/temp01.dbf 0 1,986 16 0 2 13 10.9
/u01/app/oradata/ora11g/test.dbf 0 5 0 0 0 0 0.8
/u01/app/oradata/ora11g/big.dbf 0 0 0 0 1 10 18.8
9 rows selected.
SQL> @users
Database: ora11g 21-Apr 02:52am
Report: users.sql OSM by OraPub, Inc. Page 1
Basic Oracle Database User Information
Default Temporary
Username Tablespace Tablespace Profile Role (admin,grant)
------------ ------------ ------------ ------------------ ---------------------
APEX_030200 SYSAUX TEMP DEFAULT CONNECT-YN
SYSAUX TEMP DEFAULT RESOURCE-YN
BI EXAMPLE TEMP DEFAULT RESOURCE-NN
CTXSYS SYSAUX TEMP DEFAULT CTXAPP-YN
SYSAUX TEMP DEFAULT RESOURCE-NN
DBSNMP SYSAUX TEMP DEFAULT OEM_MONITOR-NN
ELVIS USERS TEMP DEFAULT DBA-NN
USERS TEMP D |