-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
One of the scenario we ran into when one of the data file reported there was block corruption as RMAN… READ MORE
Ksh/Borne/Bash shell $ ls /usr/bin …. # when success value is 0 $ echo $? 0 $ ls /usr/bin/blah ls:… READ MORE
To change the logical name of the SQL Server databse one can follow the steps below to change the logical… READ MORE
|
Using the script one can set the title of a window, one of the reason for doing would be distinguish… READ MORE
|
Using the example below one can view the contents a compress tar file without un-compressing the file. # if the… READ MORE
In 10g, there is a column in V$session called blocking_session to find the session id that is blocking. Session 1)… READ MORE
Using the following SQL one can find the oracle bit version installed: SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process… READ MORE
If one is keeping archive logs available on disk and also have them archived to tape and would like to… READ MORE
Using the following rman command one can setup to keep 2 days of archive log on disk and also archive… READ MORE
In Query analyzer — prints job name, step name, start time and end time of each step in the job… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 