-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
One can disable parallel query at a session level by running the following ALTER SESSION statement. You can use this… READ MORE
‘ANONYMOUS’ — HTTP access to XDB ‘APPQOSSYS’ — QOS system user ‘AUDSYS’ — audit super user ‘BI’ — Business Intelligence… READ MORE
Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to… READ MORE
Commands ggsci> HELP [command] [object] ggsci> help GGSCI Command Summary: Object: Command: SUBDIRS … READ MORE
At times one would want to change properties/attributes of a table so new partitions are affected by change not the… READ MORE
|
Using oradebug one can get a dump of sessions parameters that are modified at session level, like optimization parameters. SQL>… READ MORE
Using the following SQL one can find the current number of processes and sessions connected and also max utilization so… READ MORE
Below are the 2 SQL statements, the first one uses the index AAA_IDX and then second one does a full… READ MORE
Following example shows what happens when locks are disabled on the TABLE. -- disable lock on a table SQL> alter… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 