Latest Blog Posts for Oracle In a Click

• 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.

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment