-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Found this store procedure on Tom Kyte’s site which can be used to print columns in a table row wise,… READ MORE
To take backup manually or when cloning a database using the following SQL one can place the database in backup… READ MORE
After scheduling a task through SQLServer Agent it generated the error below when executing the DTS. The DTS package required… READ MORE
|
Using QSlice one can monitor CPU usage for individual thread on a windows box. Qslice can be downloaded from the… READ MORE
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
When using DBMS_STATS to gather table statics Oracle backups up the statistics before overwriting it. The following example shows how… 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
|
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
Oracle’s Primavera P6 Analytics, released this spring, uses prebuilt business intelligence and analytics to improve project portfolio management and forecasting… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 