-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
— Get process id of current process $ echo $$ 6113 — shows process id $ ps PID TTY TIME… READ MORE
|
sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text,… 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
When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile… 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
Restore spfile through RMAN, here are some scenerios/examples. There are some pre-requites, the database would need to be in nomount… READ MORE
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… READ MORE
Using the debug option one can turn on trace information, this can be used to troubleshoot an issue. Example: $ORACLE_HOME/bin/rman… 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
“Control what I can control”
~ Alex Lima
Alex Lima 