-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this… READ MORE
Using DBA_SCHEDULER_RUNNING_JOBS one can see jobs currently running. In the example below it shows the oracle session id and corresponding… READ MORE
In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table… READ MORE
Depending on tool one can grant access to users if they need access to look at code for store procedure,… READ MORE
Powershell – Powershell is in an interactive shell which supports scripting. You can download this from http://support.microsoft.com/kb/926139 Displays all the… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 