-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Using strace one can trace the system calls being executed by a running process. To stop the strace press control-C… READ MORE
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 the following query one can see the flashback data available. SELECT to_char(sysdate,'YYYY-MM-DD HH24:MI') current_time, to_char(f.oldest_flashback_time, 'YYYY-MM-DD HH24:MI') OLDEST_FLASHBACK_TIME, (sysdate… 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
Using $ORACLE_HOME/rdbms/admin/awrsqrpt.sql one can generate execution plan from AWR by passing start snap id, end snap id and SQL ID.… READ MORE
If you have forgotten the root password and you need to reset it on CentOS, one can reset it by… 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
“Control what I can control”
~ Alex Lima
Alex Lima 