Oracle Virtual Machine (VM) Installation
on Mar 2, 2009 in Videos See graphically how to install Oracle Virtual Machine on Linux.Virtual Machine Installation...

Tablespace Point in Time Recovery from Cold Backup
on Jan 28, 2009 in Guidelines The steps to restore a tablespace to a point in time from cold rman backup in another machine is: 1) Copy initdb.ora from production environment to auxiliary node. Change paths to the new location for user_dump_dest ... Include parameters: db_file_n...

Mandatory Oracle Sites to visit
on Dec 26, 2008 in Links In English: http://tahiti.oracle.com: Online documentationhttp://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?redir_type=15: Oracle Learning Paths.http://otn.oracle.com: Free Oracle Software, documentation ... You should create a fre...

Free Oracle Tools
on Dec 23, 2008 in Utilities These are my favourites free oracle tools (inexpensive) : SQL Developer: Fully Oracle supported graphical tool for database development.FabForce: Free data modelling tool.Bugzilla: Free task/bug manager.Advanced Query ToolOraSnap: Gather Performance...

Prepare your Oracle Interview: Questions and Answers
on Dec 23, 2008 in Utilities Really interesting and interactive site to practice: GeekInterview.

DBMS_SPACE Package: Estimate Table and Index Size
on Dec 22, 2008 in Scripts We could estimate table size with this script: SET SERVEROUTPUT ON DECLARE v_used_bytes NUMBER(10); v_Allocated_Bytes NUMBER(10); v_type sys.create_table_cost_columns; BEGIN v_Type := sys.create_table_cost_columns ( sys.create_table_cost_colinfo...

Steps to migrate from File System to ASM
on Dec 19, 2008 in Guidelines For me, this is the easiest way for migrate our Oracle database from File System to ASM: 1)In open state: - Indicanew control file path: ALTER SYSTEM SET control_files='+MIGAS' scope=spfile; - Indicate new file creation path: ALTER

How do you monitor your Oracle servers? Oracle gives you OSWATCHER
on Dec 19, 2008 in Utilities You have performance problem and maybe not collecting operating system and network metrics. Os watcher is probably the easy and better option to take snapshots. Os Watcher is a set of Unix commands that collect operating system and network metrics.