-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
' ' script to change computer date ' DIM objShell strComputer = "." ' current host ' get current time… READ MORE
Flash Tip: Running Profiler on a Busy SQL Server http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx READ MORE
There was an issue the other day where the application session ran out of open cursors resulting the following error… READ MORE
|
In v$session the column last_call_et has value which tells us the last time (seconds) ago when the session performed any… READ MORE
|
Explain plan may not relay the correct execution plan optimizer may run, the following link shows an example Explain Plan… READ MORE
C-shell (csh) Example: set prompt=”[%n@%m %c] \! %” oracle@localhost ~] 39 % In this above example sets prompt to display… READ MORE
Using the following script it will find all version of a command in $PATH (from Unix Power Tools) $ cat… READ MORE
By setting trap one can run a logout script when a k-shell is being terminated. The built-in command trap in… READ MORE
|
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… READ MORE
From the following KB article it list couple of store procedures which can be used to send email through SQLServer.… READ MORE
|
Using “oradebug dump errorstack <dump level>” one can dump the call stack of the process after attaching to a running… READ MORE
There can be a scenario where the datatype of the column is VARCHAR or CHAR but values that are suppose… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 