Alternatively,
you can use the view V$DIAG_INFO to find all diagnostic-related directories for the instance:
SQL> select name, value from v$diag_info;
NAME VALUE
------------------------- ---------------------------------------------
Diag Enabled TRUE
FIGURE 6-4 ADR directory structure
Chapter 6: Monitoring Space Usage 197
ADR Base /u01/app/oracle
ADR Home /u01/app/oracle/diag/rdbms/dw/dw
Diag Trace /u01/app/oracle/diag/rdbms/dw/dw/trace
Diag Alert /u01/app/oracle/diag/rdbms/dw/dw/alert
Diag Incident /u01/app/oracle/diag/rdbms/dw/dw/incident
Diag Cdump /u01/app/oracle/diag/rdbms/dw/dw/cdump
Health Monitor /u01/app/oracle/diag/rdbms/dw/dw/hm
Default Trace File /u01/app/oracle/diag/rdbms/dw/dw/trace/dw_ora
_28810.trc
Active Problem Count 0
Active Incident Count 0
11 rows selected.
OS Space Management
Outside of the Oracle environment, space should be monitored by the system administrator with
a thorough understanding from the DBA as to the parameters in place for autoextending datafiles.
Setting AUTOEXTEND ON with large NEXT values for a tablespace will allow a tablespace to
grow and accommodate more inserts and updates, but this will fail if the server??™s disk volumes
do not have the space available.
Space Management Scripts
In this section, I provide a couple scripts you can run on an as-needed basis, or you can schedule
them to run on a regular basis to proactively monitor the database.
These scripts take the dictionary views and give a more detailed look at a particular structure.
Pages:
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354