-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
A quick emergency FRA clean up when archived logs are full. This file contains hidden or bidirectional Unicode text… READ MORE
I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that,… 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
When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis,… 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
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
“Control what I can control”
~ Alex Lima
Alex Lima 