Technology Stack - EBS (MOSC)

MOSC Banner

Queries

edited Aug 20, 2021 11:23AM in Technology Stack - EBS (MOSC) 2 commentsAnswered
 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?

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center