Wednesday, February 25, 2026
Oracle DBA by Example. Code samples, Scripts, Reference.: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure
Oracle DBA by Example. Code samples, Scripts, Reference.: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure: - Info: Automatic optimizer statistics collection gathers optimizer statistics by calling the DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC pr...
Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Autotask - auto space advisor
Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Autotask - auto space advisor: Info: The auto space advisor Calculates stats regarding space usage. The auto space advisor Auto Task in Oracle can be very CPU and I/O i...
Monday, February 16, 2026
Erman Arslan's Oracle Blog: Erman Arslan's Oracle Forum -- May 1, 2025 - Feb 6...
Erman Arslan's Oracle Blog: Erman Arslan's Oracle Forum -- May 1, 2025 - Feb 6...: Question: How much time do you spend/lose? Answer: Well, how much time I gain? :) Remember, you can ask questions and get remote support ...
Minimalistic Oracle: Dropping an audit policy for a specific user
Minimalistic Oracle: Dropping an audit policy for a specific user: You have the following audit policy: CREATE AUDIT POLICY monitor_sys_everything ACTIONS ALL; AUDIT POLICY monitor_sys_everything BY SYS;...
Subscribe to:
Posts (Atom)
-
When a rac database instance fails, a service which is running on this failed instance (configured as preferred) will fail over to the avail...
-
Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory : I want to detach an existing oracle_home from my inventory. No...
-
To see EXADATA machine information of OCI cloud, follow below method. 1) Log in to EXACS/EXACC compute (db server) node with ROOT user. 2)...