To disable gather_stats_job in 10g:
To disable gather_stats_job (also known as optimizer stats) in 11g:
client_name => 'auto optimizer stats collection',
operation => NULL,
window_name => NULL);
MMON (Memory Monitor) is an Oracle background process that gathers memory statistics (snapshots) and stores this information in the AWR.
MMON is also responsible for issuing alerts for metrics that exceed their thresholds.
MMON is available from Oracle 10g.
The default for recording an AWR snapshot is hourly.
The 11g version of RMAN has a useful feature for diagnosing and repairing any failures.
Find any database failures:
RMAN> list failure;
Determine manual or automatic repair:
RMAN> advise failure;
From the output of the advise, try to manually fix the failure. If this fails to work, then try the repair command:
RMAN> repair failure;
If you wish to know which users have been granted the dba role then you need to query the dba_role_privs in the SYS schema.
This role tells you the grantee, granted_role, whether they have admin option granted, and whether the role is their default role:
SQL> desc dba_role_privs
Name Null? Type
------------ -------- ------------
GRANTED_ROLE NOT NULL VARCHAR2(30)
To find a list of all users with DBA privilege execute the following code:
SQL> select * from dba_role_privs where granted_role='DBA';
GRANTEE GRANTED_ROLE ADM DEF
--------- ------------ --- ---
SYS DBA YES YES
SYSTEM DBA YES YES
To check what auditing has been set on your Oracle database you can query the following:
SQL> SELECT *
If you get the below error message when going to run the installer for fusion middleware 220.127.116.11.0:
Checking Operating System Certification:
Expected result : One of 5300.08, 6100.02
Actual Result: 7100.00
Check Complete: The overall result of this check is Failed <<<<
Problem : This Oracle Software is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
-Checking recommended operating system patches:
Check complete. The overall result of this check is : Not executed
Then you can either ignore the error by pressing continue, or you can quit and run the installer with the following: