3,744 reputation
721
bio website ronr.blogspot.com
location Netherlands
age 49
visits member for 3 years, 2 months
seen 2 hours ago

I am just an oracle - ACE - dba OCM that likes to play with large unix based warehouses. In between I have written a book that is hopefully a useful addition to what is written about Oracle Scheduler, called Mastering Oracle Scheduler In my list of certifications is - Oracle 10g Certified Master - Oracle 11g Tuning Specialist - Oracle Certified Professional 7, 8, 8i, 9i,10g,11g


Follow me in twitter


Apr
9
awarded  Revival
Mar
20
comment Move Complete ORACLE from one system to another
really amazing question .... expect a SA & a dba to be involved, if the data is of any interest.
Mar
9
comment Background process RECO didn't start
start with reading the alertlog.
Feb
26
comment Slowness after migration to RAC 11gr2
were the old statistics up to date? Did the explain plans - rows expected - match the actual rows returned? (in the 10g db) How are the qry's build (lots of stacked view or simple sql?)
Feb
23
comment Recover data from bak Oracle 9i file
Is a logfile available from the creation of the backup? Or, are the backup scripts available?
Feb
18
awarded  Yearling
Feb
14
revised Tips on using SQL access advisor in Oracle
added SQL Access Advisor in Oracle Database url
Feb
14
comment Tips on using SQL access advisor in Oracle
@Deven hmm, that's is quite a bit more complex. Parameters need to be added to the created task. Currently I have no example at hand. Check oracle-base.com/articles/10g/sql-access-advisor-10g.php
Feb
14
comment Tips on using SQL access advisor in Oracle
@a_horse_with_no_name yes, you are right. Thanks for the tip, I edited accordingly.
Feb
14
revised Tips on using SQL access advisor in Oracle
removed ');' from task:= .... line (thanks a_hors_with_no_name)
Feb
14
answered Tips on using SQL access advisor in Oracle
Feb
14
comment Tips on using SQL access advisor in Oracle
what did you already try?
Feb
14
comment ORA-29339: tablespace block size 16384 does not match configured block sizes
Ron, the optimizer does al kinds of calculations about the cost of IO. For this the blocksize is a key factor that is ignored. Try to stick to the 1 blocksize db, if possible.
Feb
13
answered ORA-29339: tablespace block size 16384 does not match configured block sizes
Jan
26
answered oracle active sessions waiting for scheduler
Jan
26
answered Oracle backup and recovery using RMAN
Jan
19
awarded  Critic
Dec
19
answered How to prevent scheduler jobs from running at instance startup
Dec
19
comment How to prevent scheduler jobs from running at instance startup
works from 11gR2. Before that, job_queue_processes = 0 did not help.
Dec
18
awarded  Revival