Re: OCP Architecture question
Ah, the Sherlock Holmes method. I've often used the same method on multiple choice tests with meaningless questions and obscure answers. "When you have eliminated the impossible, whatever remains, however improbable, must be the truth" I think this is how I passed the Oracle 7 Beta tests, which were quite long. Jared On Fri, 2003-08-15 at 08:19, Wolfgang Breitling wrote: > A lot of those multiple choice question are best approached from a reverse > standpoint, much like a lot of my recent election experiences. You look at > the choices and cross out the ones which are definitely not it until you > whittled it down to the number of supposedly correct choices you need. If > you don't like any of the choices you have to use those that you least not > like. > > At 05:24 PM 8/14/2003 -0800, you wrote: > >Im using the self test software and here is a question... I dont like the > >answers. Please tell me if Im wrong. > > > >Which Three methods can be used to avoid snapshot too old errors. This is > >for the 8i test. > > > >1. User larger extents > >2. Increase MAXEXTENTS for existing rollback segments > >3. Create rollback segments with higher optimal values > >4. Create rollback segments iwth high minextents > >5. Run long queries when transaction processing is high. > > > >Ruling out 5 is obvious. The test says its. > > > >1,3,4 > > > >How does using large extents help this? What about a higher minextents value? > > Wolfgang Breitling > Oracle7, 8, 8i, 9i OCP DBA > Centrex Consulting Corporation > http://www.centrexcc.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wolfgang Breitling > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: OCP Architecture question
Ryan I have found the actual OCP questions to be clearer. I think it is very hard to develop a good multiple choice exam. And these are tricky because the objective is to test more than simple memorization. You need to administer it to many people and find out which questions aren't clear or are easily misinterpreted. Oracle has the resources to do that, an individual author isn't. My claim is that if you have mastered the material enough to point out flaws with your preparation materials, dude you're ready to pass the exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 15, 2003 6:29 AM To: Multiple recipients of list ORACLE-L yeah thats what i figured... but having these certifications are good for my career. thanks. I figured it was a stupid question. > > From: "Cary Millsap" <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri AM 01:14:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: OCP Architecture question > > With respect to evaluating answer number one, it's a bad question, > because you have know way to know whether the context is supposed to be > > > > a) assume a fixed rollback segment size, but use fewer, larger > extents; or > > b) make the rollback segment larger by using the same number of > larger extents. > > > > In context (a), #1 is a bad answer. In context (b), it's a better > answer, but it's still poor. > > > > The thing that really chaps me about stupid certification questions like > this is that no answer among the choices listed is really the right > thing for you to try to do, which is: > > > > FIX THE QUERY THAT'S TAKING SO LONG TO RUN. > > > > In other words, make queries run quickly enough that they don't require > multiple-hour-old undo blocks to produce read-consistent results. > > > > Jacking around with rollback segments is just a kludge that will produce > results far inferior to what you can achieve by attacking the query > problem at its root. > > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic <http://www.hotsos.com/training/clinic101> 101 in > Sydney > - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004> > March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > -Original Message- > Tim Gorman > Sent: Thursday, August 14, 2003 10:54 PM > To: Multiple recipients of list ORACLE-L > > > > They all allow the RBS to be bigger. More space available for RBS > roughly equals fewer ORA-01555, for most situations... > > > > on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: > > Im using the self test software and here is a question... I dont like > the answers. Please tell me if Im wrong. > > Which Three methods can be used to avoid snapshot too old errors. This > is for the 8i test. > > 1. User larger extents > 2. Increase MAXEXTENTS for existing rollback segments > 3. Create rollback segments with higher optimal values > 4. Create rollback segments iwth high minextents > 5. Run long queries when transaction processing is high. > > Ruling out 5 is obvious. The test says its. > > 1,3,4 > > How does using large extents help this? What about a higher minextents > value? > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP Architecture question
A lot of those multiple choice question are best approached from a reverse standpoint, much like a lot of my recent election experiences. You look at the choices and cross out the ones which are definitely not it until you whittled it down to the number of supposedly correct choices you need. If you don't like any of the choices you have to use those that you least not like. At 05:24 PM 8/14/2003 -0800, you wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Architecture question
1. Maybe, maybe not. To make a point, take it to a ridiculous extreme: Suppose you have a tablespace of 100M with two rollback segments made of 1M extents sizes. Then each segment must use 2M each (minextents must be at least 2) which means either segment could possibly grow to use 98M if needed (but not at the same time). Now make the extent sizes 25M. Then each segment uses 50M with no growth possibility. Now you don't have the ability to extend a segment to 98M; so this could be bad. But neither do you have a case where one segment can extend to 98M leaving the other poor segment stuck at 2M; so this could be good. So "It Depends." 2. I think this addresses a different issue; i.e. "failed to extend..." 3. Essentially same reasoning as #1. 4. Essentially same reasoning as #1. 5. No comment needed. -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Thursday, August 14, 2003 8:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: RE: OCP Architecture question
i have all of it or 8i. this question was in architecture. I havent looked at the sql and pl/sql stuff since the cert test for that was a blowoff. > > From: "Ed Sherman" <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri AM 09:00:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: OCP Architecture question > > Ryan, > > I will research the answer but I have an urgent question. > > Do you have SelfTest Software for the SQL and PL/SQL test or do you have the > Architecure and Administration SelfTest Software? > > Thanks, > Ed > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Ryan > Sent: Thursday, August 14, 2003 9:24 PM > To: Multiple recipients of list ORACLE-L > Subject: OCP Architecture question > > > Im using the self test software and here is a question... I dont like the > answers. Please tell me if Im wrong. > > Which Three methods can be used to avoid snapshot too old errors. This is > for the 8i test. > > 1. User larger extents > 2. Increase MAXEXTENTS for existing rollback segments > 3. Create rollback segments with higher optimal values > 4. Create rollback segments iwth high minextents > 5. Run long queries when transaction processing is high. > > Ruling out 5 is obvious. The test says its. > > 1,3,4 > > How does using large extents help this? What about a higher minextents > value? > > Ryan, I will research the answer but I have an urgent question. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Architecture question
Ryan, I will research the answer but I have an urgent question. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: RE: OCP Architecture question
yeah thats what i figured... but having these certifications are good for my career. thanks. I figured it was a stupid question. > > From: "Cary Millsap" <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri AM 01:14:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: OCP Architecture question > > With respect to evaluating answer number one, it's a bad question, > because you have know way to know whether the context is supposed to be > > > > a) assume a fixed rollback segment size, but use fewer, larger > extents; or > > b) make the rollback segment larger by using the same number of > larger extents. > > > > In context (a), #1 is a bad answer. In context (b), it's a better > answer, but it's still poor. > > > > The thing that really chaps me about stupid certification questions like > this is that no answer among the choices listed is really the right > thing for you to try to do, which is: > > > > FIX THE QUERY THAT'S TAKING SO LONG TO RUN. > > > > In other words, make queries run quickly enough that they don't require > multiple-hour-old undo blocks to produce read-consistent results. > > > > Jacking around with rollback segments is just a kludge that will produce > results far inferior to what you can achieve by attacking the query > problem at its root. > > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic <http://www.hotsos.com/training/clinic101> 101 in > Sydney > - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004> > March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > -Original Message- > Tim Gorman > Sent: Thursday, August 14, 2003 10:54 PM > To: Multiple recipients of list ORACLE-L > > > > They all allow the RBS to be bigger. More space available for RBS > roughly equals fewer ORA-01555, for most situations... > > > > on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: > > Im using the self test software and here is a question... I dont like > the answers. Please tell me if Im wrong. > > Which Three methods can be used to avoid snapshot too old errors. This > is for the 8i test. > > 1. User larger extents > 2. Increase MAXEXTENTS for existing rollback segments > 3. Create rollback segments with higher optimal values > 4. Create rollback segments iwth high minextents > 5. Run long queries when transaction processing is high. > > Ruling out 5 is obvious. The test says its. > > 1,3,4 > > How does using large extents help this? What about a higher minextents > value? > > > > > Title: Re: OCP Architecture question With respect to evaluating answer number one, it’s a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), it’s a better answer, but it’s still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: FIX THE QUERY THAT’S TAKING SO LONG TO RUN. In other words, make queries run quickly enough that they don’t require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004 March 7–10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Architecture question
Title: Re: OCP Architecture question With respect to evaluating answer number one, it’s a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), it’s a better answer, but it’s still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: FIX THE QUERY THAT’S TAKING SO LONG TO RUN. In other words, make queries run quickly enough that they don’t require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004 March 7–10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: OCP Architecture question
Title: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?