Do I Have To Set Any Oracle Profile Parameters?

1.	Do I Have To Set Any Oracle Profile Parameters?
Answer» Yes, you must set the following PARAMETERS to the values SPECIFIED to ensure that you RECEIVE useful statistics: SQL>show parameter statistics statistics_level=TYPICAL timed_os_statistics=0 timed_statistics=TRUE To automate the generation of STATSPACK snapshots, you must set the parameter job_queue_processes > 0. Yes, you must set the following parameters to the values specified to ensure that you receive useful statistics: SQL>show parameter statistics statistics_level=TYPICAL timed_os_statistics=0 timed_statistics=TRUE To automate the generation of statspack snapshots, you must set the parameter job_queue_processes > 0.

Answer»

Yes, you must set the following PARAMETERS to the values SPECIFIED to ensure that you RECEIVE useful statistics:

SQL>show parameter statistics

statistics_level=TYPICAL

timed_os_statistics=0

timed_statistics=TRUE

To automate the generation of STATSPACK snapshots, you must set the parameter job_queue_processes > 0.

Yes, you must set the following parameters to the values specified to ensure that you receive useful statistics:

SQL>show parameter statistics

statistics_level=TYPICAL

timed_os_statistics=0

timed_statistics=TRUE

To automate the generation of statspack snapshots, you must set the parameter job_queue_processes > 0.

Discussion