-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
|
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
|
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
The following article gives some background on how to stop the transaction log from growing Using the steps below one… READ MORE
Using the steps below one can find the object that is unrecoverable from UNRECOVERABLE_CHANGE# in the v$datafile, one would use… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 