-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
In 10g one can find the jobs that are currently running by querying the following view SELECT job_name, session_id, running_instance,… READ MORE
|
— One can use the following query to find the name of the trace filename — To find the name… READ MORE
|
Using one of the following you can find your session id (SID). SQL> SELECT sid FROM v$mystat WHERE rownum =… READ MORE
— Set default tablespace for all users, so when users are created without specifying default tablespace it will be user’s… READ MORE
To start the instance: # check status of instance $ $CRS_HOME/bin/crs_stat # seen cases when CRS says OFFLINE but pmon… READ MORE
|
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
|
When using datapump one can run the following query to monitor the progress by running the following SQL. select sid,… READ MORE
|
In certain cases you may want to lock statistics in a table in certain cases, for example if you want… 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
“Control what I can control”
~ Alex Lima
Alex Lima 