25 .0640625 .1859375
arts.269.628621093
EM_REP +DATA/dw/datafile/em .25 .0000625 .2499375
_rep.270.628640521
EXAMPLE +DATA/dw/datafile/ex .1 .077375 .022625
ample.265.627433157
SYSAUX +DATA/dw/datafile/sy .7681875 .7145 .0536875
saux.257.627432973
Chapter 6: Monitoring Space Usage 199
SYSTEM +DATA/dw/datafile/sy .77 .7000625 .0699375
stem.256.627432971
UNDOTBS1 +DATA/dw/datafile/un .265 .0155625 .2494375
dotbs1.258.627432975
USERS +DATA/dw/datafile/us .0125 .0111875 .0013125
ers.259.627432977
USERS2 +DATA/dw/datafile/us .1 .0000625 .0999375
ers2.267.627782171
USERS4 +DATA/dw/datafile/us .25 .002 .248
ers4.268.628561597
USERS9 +DATA/dw/datafile/us .01 .0000625 .0099375
ers9.271.628727991
USERS9 +DATA/dw/datafile/us .01 .0000625 .0099375
ers9.272.628729587
USERS9 +DATA/dw/datafile/us .05 .0000625 .0499375
ers9.273.628730561
USERS3 +DATA2/dw/datafile/u .1 .0000625 .0999375
sers3.256.627786775
XPORT /u05/oradata/xport.d .3 .1280625 .1719375
bf
14 rows selected.
Only the USERS9 tablespace has more than one datafile in this database. To include temporary
tablespaces on this report, you can use a union query to combine this query with a similar query
based on V$TEMPFILE.
Automating and Streamlining
the Notification Process
Although any of the scripts and packages presented earlier in this chapter can be executed on
demand, some of them can and should be automated, not only to save time for the DBA but also
to be proactive and catch problems long before they cause a system outage.
Pages:
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357