Queries
To All,
I have some performance related question.
1 ) Where can i found the below spool file
SQL> conn apps/apps
Connected.
SQL> @/home/oracle/Desktop/bde_chk_cbo.sql
Spool file bde_chk_cbo.html has been generated.
2) Is it better to schedule 'Gather Schema Statistics' or not secondly where this statistic can be use is this possible that we can view this statistics?
3) The following way is correct to take snap of AWR. How we analyze it?
I have some performance related question.
1 ) Where can i found the below spool file
SQL> conn apps/apps
Connected.
SQL> @/home/oracle/Desktop/bde_chk_cbo.sql
Spool file bde_chk_cbo.html has been generated.
2) Is it better to schedule 'Gather Schema Statistics' or not secondly where this statistic can be use is this possible that we can view this statistics?
3) The following way is correct to take snap of AWR. How we analyze it?
sql> @$ORACLE_HOME/rdbms/admin/awrrpt.sql
4) What is purging , which area we need to do this and how ?
5) For monitoring ERP R12.0.6 Server which is the better tool can we use is EM console or some other to achieve this?
Tagged:
0