-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When starting one of the databases we received the ORA-00353 error. It indicates that archiver process couldn’t archive one of… READ MORE
Using sys.dbms_scheduler.STOP_JOB one can stop scheduled job. SQL> exec sys.dbms_scheduler.STOP_JOB(job_name=>'SYS.ORA$AT_OS_OPT_SY_12856', force=>true); Output: PL/SQL procedure successfully completed. If it can’t find… READ MORE
Few examples of some scenarios of setting intervals for dba_jobs. Note: Updating the interval will not update the NEXT_DATE run… READ MORE
DBMS_JOB allows one to create/manage jobs under user who has logged but using sys.dbms_ijob one can manage jobs all jobs… READ MORE
By querying v$database one can tell if the host is primary or standby For primary testdb> select database_role from v$database;… READ MORE
If you have an issue where the server where standby resides had to be restarted and when you try to… READ MORE
By setting the value of 0 to the parameter “job_queue_processes” one can suspend all jobs from executing in DBA_JOBS. The… READ MORE
Using dba_jobs_running it will show the all jobs executing. SQL> select djr.sid, djr.job, djr.failures, djr.this_date, djr.this_sec, dj.what from dba_jobs_running djr,… READ MORE
Sample code that shows using BULK COLLECT and performance of using different values for LIMIT. declare cursor l_cur is select… READ MORE
In “ALTER SYSTEM” one can include a comment which gets recorded in the spfile and also in v$parameter as shown… READ MORE
The following shows how to add in a table a new column that is NOT NULL when a table already… READ MORE
If AUDIT_TRAIL is not set to NONE then using the following SQL one can find the statements that have auditing… READ MORE
In the view v$session there are columns that can tell if parallel DDL, DML, Query is enabled/disabled. PDML_ENABLED and PDML_STATUS… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 