-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
To reduce the amount of space used when exporting one can compress the data as creating export file and also… READ MORE
One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index… READ MORE
Using the following command one can pass hostname, port, servicename and SID and connect to a database without having an… READ MORE
By querying V$parameter one can find if the parameter can be modified in session and/or system. If isses_modifiable is true… READ MORE
The datafile for UNDO tablespace can’t be shrunk as we had issue where the datafile was set to unlimited and… READ MORE
Not cleaning up a failed CRS install can cause problems like node reboots. Follow these steps to clean up a… READ MORE
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
|
The following example shows how to find lock on a store procedure, the following store procedure has infinite loop. A… READ MORE
— note this will work when not logged in as SYS, as the session id is the same for all… READ MORE
To make trace files visible to all users, set the parameter _TRACE_FILES_PUBLIC=TRUE, this is undocumented parameter. This parameter requires a… READ MORE
|
Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions… READ MORE
|
Each schema may require a PLAN_TABLE to debug performance so instead of creating the PLAN_TABLE within each schema, one can… READ MORE
Adding the following line before running a SQL Script will terminate the SQL script from running and rollback the change… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 