-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
From v$fixed_view_definition one can find the definitions of V$views which may one in understand them. Example: SQL> set pages 0… READ MORE
Using procedures in DBMS_STATS package one can backup statistics and restore them. Assumes the user scott already has access to… READ MORE
Using ALTER SYSTEM RESET one can delete parameter from spfile if the parameter is in the spfile. Example: — shows… READ MORE
In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows… READ MORE
Using the following steps one can create database from command line. Place the following pfile in $ORACLE_HOME/dbs directory and set… READ MORE
SQL> set lines 100 pages 999 SQL> select snap_id, snap_level, to_char(begin_interval_time, ‘dd/mm/yy hh24:mi:ss’) starting 2 from dba_hist_snapshot 3 order by… READ MORE
When doing a incomplete recovery (i.e. database is open with resetlogs) and when running RMAN to backup that database after… READ MORE
Here are some of the options that can be passed to runInstaller -slient – Slient mode -debug – To get… READ MORE
There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message… READ MORE
sed ‘1,10d’ file – doesn’t print the top 10 lines from the file sed ‘5d’ myfile – delete 5th line… READ MORE
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
One of the scenario we ran into when one of the data file reported there was block corruption as RMAN… READ MORE
In 10g, there is a column in V$session called blocking_session to find the session id that is blocking. Session 1)… READ MORE
Using the following SQL one can find the oracle bit version installed: SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 