-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To… READ MORE
Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very… READ MORE
A quick emergency FRA clean up when archived logs are full. This file contains hidden or bidirectional Unicode text… READ MORE
Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing… READ MORE
The Oracle Lifetime Support Policy brochure for tech products has… READ MORE
|
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
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
“Control what I can control”
~ Alex Lima
Alex Lima 