-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
|
Received ORA-19571 error when running of archive log process, and found the the parameter control_file_record_keep_time was set to 0 so… READ MORE
One can use the following v$nls_parameters view to find the database LANGUAGE, TERRITORY, and CHARACTER SET. READ MORE
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
“Control what I can control”
~ Alex Lima
