-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Here are some of the windows tools that can be used when working on window internals. Autoruns (autoruns.exe) – http://technet.microsoft.com/en-us/sysinternals/bb963902.aspx… READ MORE
By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of… READ MORE
|
Using the following T-SQL one can create differential backup or make it part of scheduled job. declare @datetimestamp varchar(20) declare… READ MORE
To find the trace file one using oradebug one can find it using the example below: SQL> oradebug mysetpid Statement… READ MORE
Using oradebug unlimit one can set to unlimit the size of the trace file. SQL> oradebug setmypid Statement processed. SQL>… READ MORE
|
To use oradebug one first needs to connect to a session using the process id or ora pid. One can… READ MORE
By calling msdb..sp_get_composite_job_info or msdb.dbo.sp_help_job one can find the current jobs running on SQLServer. Example: exec msdb..sp_get_composite_job_info @execution_status=1 Or exec… READ MORE
http://dioncho.wordpress.com/tag/copy_table_stats/ READ MORE
|
http://www.oracle.com/technology/oramag/oracle/09-jan/o19asktom.html READ MORE
One of the ways to extend the password of an expiring account is to change the profile of the user.… READ MORE
To disable to trigger that are enabled in cases when loading data manually in a particular schema or table can… READ MORE
|
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… READ MORE
The “LEN” function cannot be used to find length of a column of datatype “TEXT” so using function “DATALENGTH” one… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 