V$SYSMETRIC_HISTORY Maintains a historical view of the metrics previously in V$SYSMETRIC. This view is time limited.
Provides a longer-
DBA_OUTSTANDING_ALERTS Contains current database alerts (this view was introduced earlier in this section).
DBA_ALERT_HISTORY Provides a history of threshold alerts that have been resolved, and provides a history of nonthreshold alerts.
DBA_THRESHOLDS Defines the threshold settings for the given instance.
V$ALERT_TYPES Provides information on various alert types.
If you have ever asked yourself, ''How much memory should I allocate to the database buffer cache?" then Automatic Shared Memory Management (ASMM) might just be the thing for you. Of course, if you are a control freak, then you might just not like it at all. Oracle 10
allows you to define the
Regardless of the setting of sga_target , you still need to manually set the following parameters:
The log buffer
The keep buffer pool
The recycle buffer pool
The new streams pool
Also, you must set
to TYPICAL or ALL to use ASMM. Also, if one of the ASMM parameters (e.g.,
) is set to a
parameter is a dynamic parameter, so if you find that you need additional memory allocated to your database while it's up and running, all you need to do is issue an
command and allocate more memory to the database (
The new MMAN (Memory Manager) process controls the automatic allocation of the memory within the SGA. Its job (among other things) is to keep track of the sizes of the memory areas, monitor the database and its workload to ensure that memory distribution is optimal, and redistribute memory
Oracle Database 10
will now self-tune checkpoint operations so that Oracle Database 10
can make the best use of the I/O bandwidth that is available to the system. To enable self-
Oracle Database 10
offers new trace functionality that makes tracing of user sessions much easier. Now, you can enable tracing of all sessions of a specific
Exec - dbms_monitor.client_id_trace_enable(client_id=>'PROD_USER');
This command will result in the generation of a number of trace files. Oracle Database 10
comes with the new
Trcsess output=prod_user.trc clientid='PROD_USER' *.trc
Note that if you have old trace files, they will be included when the
utility is run. So, if you do not wish to include these files, you need to either move them or rename them with a different extension. You can use the optional
procedure to generate wait-
When you enable tracing of a session via the dbms_monitor PL/SQL package, the tracing will appear in the DBA_ENABLED_TRACES view. For example, when we enabled tracing for PROD_USER, the following showed up in the DBA_ENABLED_ TRACES view:
SQL> select trace_type, primary_id, waits, binds from dba_enabled_traces;