-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to… READ MORE
|
Move by one character h – Move cursor left j – Move cursor down k – Move cursor up l… READ MORE
|
Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. —… READ MORE
If using SQLDeveloper from Oracle there was an issue we ran into where the user who were granted read access… READ MORE
We had seen case when the DDL timestamp of a procedure was changed in the middle of the night and… READ MORE
Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of… READ MORE
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and… READ MORE
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… READ MORE
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
The following example shows how to setup and cascade works when deleting record from parent table. 1) Shows how DELETE… READ MORE
To start the Oracle Enterprise Manager/Grid Control components in version 11g (11.1.0.1) $ cd /bin; ./emctl start oms $ cd… READ MORE
For SQLServer: — Clears all the procedure cache (works on SQLServer 2005 and SQLServer 2008) DBCC FREEPROCCACHE http://msdn.microsoft.com/en-us/library/ms174283%28v=SQL.90%29.aspx — On… READ MORE
The following document lists step how to install EM GridControl 11GR1 http://www.whopatooli.com/disquisitivedba/library/Joe_Johnson_Installing_EM_Grid_11gR1_11.1.0.1.pdf READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 