-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When a user name has a profile that has a password verify function set and the user tries to change… READ MORE
Using the steps below one take cold backup using RMAN. As it’s a cold backup the database as the database… READ MORE
To find RMAN catalog version log-in to the catalog through SQL*Plus and query the table rcver will print version. SQL>… READ MORE
1) Create tablespace for example name catalog_tbs 2) Create user for example user rman_catalog and assign catalog_tbs as default tablespace… READ MORE
Using CLEAR one can set the retention policy to default and using NONE have no retention policy. The example below… READ MORE
— shows what options are enabled SQL> select parameter FROM v$option where value = 'TRUE'; PARAMETER —————————————————————- Partitioning Objects Advanced… READ MORE
control_file_record_keep_time – the value indicates number of days before reusable record is overwritten, if set to 0 reusable record is… READ MORE
— backup control file in binary format to a file named /tmp/x.ctl, it will preserve the backup information of the… READ MORE
LogMiner can be used to recover data and audit database, it has 2 packages one of them named “DBMS_LOGMNR_D” to… READ MORE
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is… READ MORE
|
Lesson on learning how to write batch scripts to automate on Windows http://www.allenware.com/icsw/icswidx.htm READ MORE
|
Using the step below one can find the locks on the table by looking for object id. Example: Window 1:… READ MORE
|
http://www.orafaq.com/node/854 SQL from the link above URL to find blocking SQL select s1.username || '@' || s1.machine || ' (… READ MORE
One of the reason why invalid rowid can occur is if there is a truncate that occurs in between when… READ MORE
To display compatibility levels that can be set, 60 – 6.0, 65 – 6.5, 70 – 7.0, 80 – SQL… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 