Questions

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

Questions

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hi I am preparing for the 1z0-033 exam and i have some questions can anyone give me the right answer
1. when is temporary segmetn allocated
a.when instance starts
b.when first sort is performed
2.if there is checkpoint not complete error
a.increase dbwr process
b.increasing lgwr processes
c.increase no of memebrs for each groups
3.why it is not adviceable to create redo logs on raid 5.
thanks
Guest
 

RE: Questions

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

These aren't good questions if you ask me:

1) B - temporary segments are allocated when sort operations are requested.

2) None of these. I would increase either the number of redo log groups or the size of the redo log members. Increasing the number of members for the existing groups will make life worse if anything. See Metalink Doc ID: 147468.1

3) Raid 5 has a write overhead so it's not great for any Oracle files. Saying that, the online redo logs are worst affected as these are sequential files. At least the data files are random access.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE: Questions

Postby Guest » Mon Nov 01, 2004 6:09 pm

thanks. surely helped a lot
Guest
 

RE: Questions

Postby Tim... » Mon Nov 01, 2004 6:09 pm

No problemo!

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE: RE: Questions

Postby Guest » Mon Nov 01, 2004 6:09 pm

Have you passed the exam. You can contact me
Guest
 


Return to Oracle Certification

Who is online

Users browsing this forum: No registered users and 0 guests

cron