|
|
| |
 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 7 -
Application and SQL Management
Task Operations
|
Column |
Description |
|
SID |
Session identifier |
|
SERIAL# |
Session serial number |
|
OPNAME |
Description about the operation |
|
TARGET |
Object on which the operation was
carried out |
|
TARGET_DESC |
Target description |
|
SOFAR |
Work done so far |
|
TOTALWORK |
Total units of work |
|
UNITS |
Unit of measurement |
|
START_TIME |
Starting time of operation |
|
LAST_UPDATE_TIME |
Time of last update for statistics |
|
TIME_REMAINING |
Estimated time remaining (in seconds)
for completing the operation |
|
ELAPSED_SECONDS |
Elapsed seconds from start of
operations |
|
CONTEXT |
Context |
|
MESSAGE |
Statistics summary message |
|
USERNAME |
UserID performing the operation |
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
|
|
