tag:blogger.com,1999:blog-22756176550820548612011-11-28T01:49:46.555+01:00Everything what you need from oracle in a clickAngelnoreply@blogger.comBlogger81100tag:blogger.com,1999:blog-2275617655082054861.post-55018505412822032972009-03-02T22:25:00.001+01:002009-03-02T22:27:39.099+01:00

See graphically how to install Oracle Virtual Machine on Linux.Virtual Machine Installation

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-89661585613190814492009-01-28T09:41:00.002+01:002009-01-28T09:43:11.917+01:00

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_name_convert =('old_path', '/RECOVER/')log_file_name_convert=('old_path','/RECOVER/')2) Startup nomount (with same SID, because we will use clone) in

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-53731208312508219302008-12-26T11:52:00.005+01:002008-12-26T18:07:19.665+01:00

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 free account to access.http://asktom.oracle.com: Tom Kyte official site.http://www.jlcomp.demon.co.uk/: Jonathan Lewis official site.http://

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-44906274099486972172008-12-23T11:27:00.002+01:002008-12-23T11:29:51.722+01:00

Really interesting and interactive site to practice:GeekInterview.

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-61660871313634766872008-12-23T10:24:00.006+01:002008-12-23T11:03:21.141+01:00

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 Information and present results in html format.RRDORA: Set of unix shell scripts.DDL Wizard: Generate DDL reading from export file.Pete Finnigan

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-88052766591224181302008-12-22T15:43:00.004+01:002008-12-22T15:46:25.671+01:00

We could estimate table size with this script:SET SERVEROUTPUT ON DECLAREv_used_bytes NUMBER(10);v_Allocated_Bytes NUMBER(10);v_type sys.create_table_cost_columns;BEGINv_Type := sys.create_table_cost_columns(sys.create_table_cost_colinfo('DATE',NULL),sys.create_table_cost_colinfo('VARCHAR2',2),sys.create_table_cost_colinfo('VARCHAR2',3),sys.create_table_cost_colinfo('VARCHAR2',13),

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-75501430016647363272008-12-19T08:47:00.003+01:002008-12-19T09:14:21.796+01:00

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 SYSTEM SET db_create_file_dest='+MIGAS' scope=spfile; - Indicate FRA path: ALTER SYSTEM SET db_recovery_file_dest='+FRAMIG' scope=spfile;2)Startup in

Angelnoreply@blogger.com0tag:blogger.com,1999:blog-2275617655082054861.post-58720655786354464162008-12-19T08:32:00.003+01:002008-12-19T08:40:32.023+01:00

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. It gets statistics from all of this commands: oswiostat, oswmpstat, oswnetstat, oswprvtnet, oswps, oswtop, oswvmstat.With this information

Angelnoreply@blogger.com0