subject:"Help\!"

Jonathan,

I successfully use drop tablespace including contents and datafiles
all the time. And a quick check of the docs shows that cascade
constraints is valid but, as Richard said, belongs at the end of the
statement.

As for the second question. DBA_SEGMENTS gives you the total allocated
blocks in a single select, without aggregation. To use DBA_EXTENTS
you'd have to use sum(blocks) in the select. From prior experience with
OCP exams, they tend to go for the simplest way to get an answer. So
DBA_SEGMENTS is the correct answer in their view, although you *can*
get the same information from DBA_EXTENTS.


--- Jonathan Gennick [EMAIL PROTECTED] wrote:
 Hello Prem,
 
 The syntax the question gives for DROP TABLESPACE doesn't
 look right to me. Without looking at the current docsgrin,
 I believe INCLUDING CONTENTS is a valid option, and that the
 others are invalid. Thus, answer B, the statement will fail,
 looks correct. Whoever wrote that test question does not
 appear to have tested their test.
 
 As for question 2, until you asked, I too would have looked
 in DBA_EXTENTS. But as I look at one table in my database, I
 see that DBA_SEGMENTS.BLOCKS reports the same value as
 DBA_EXTENTS.BLOCKS. It may be that DBA_SEGMENTS reports on
 SUM(BLOCKS) for all extents in each segment. Interesting.
 I'll have to read the docs on this, to find out for certain
 what's going on.
 
 One thing to be aware of with respect to question 2 below is
 that in a partitioned table, each partition is a segment.
 Thus, whether you go to DBA_EXTENTS or DBA_SEGMENTS, you do
 need to be sure to consider all partitions of the table in
 question.
 
 Best regards,
 
 Jonathan Gennick --- Brighten the corner where you are
 http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
 Join the Oracle-article list and receive one
 article on Oracle technologies per month by 
 email. To join, visit
 http://four.pairlist.net/mailman/listinfo/oracle-article, 
 or send email to [EMAIL PROTECTED] and 
 include the word subscribe in either the subject or body.
 
 
 Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J
 ([EMAIL PROTECTED]) wrote:
 PKJ Hi list , sorry to pester you with questions regarding 
 PKJ boson OCP questions . i have scheduled for #1Z0-031 exam
 PKJ and so desperately need help from this list . 
 PKJ please bear with me  for while . look at the 2 questions below .
 
 PKJ
 -
 PKJ QUESTION #1 
 PKJ what happens when you issue the command below .
 PKJ drop tablespace testtbs including contents cascade constraints
 and
 PKJ datafiles;
 
 PKJ A.the tablespace will be dropped , constraints will be droppped
 and the
 PKJ datafiles will be taken out of the o/s.
 
 PKJ B. statement will fail 
 
 PKJ C.you must drop constraints before issuing this command.
 
 PKJ this is what happens when i try on 9.2.0.4 :
 PKJ ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE
 
 PKJ but boson's  choice is A.  i wonder how ???
 PKJ
 -
 PKJ QUESTION #2
 PKJ you need to determine how much space has been allocated for a
 table.
 PKJ which view would give you this information ?
 
 PKJ A. dba_extents 
 PKJ B. dba_ts_quotas 
 PKJ C. dba_segments
 
 PKJ my choice is C . 
 PKJ but boson's choice is A . it says other views cannot give
 PKJ the required details .
 
 PKJ a metalink doc says that dba_segments.blocks gives the
 PKJ total number of blocks  allocated to the table. 
 
 PKJ what will be the choice that you would go for ?
 PKJ
 -
 
 PKJ so now i have the question whether boson is reliable ? 
 PKJ how many in this list have used it ?
 PKJ or am i missing something  : ((
 
 PKJ Regards,
 PKJ Prem.
 
 PKJ -- 
 PKJ Please see the official ORACLE-L FAQ: http://www.orafaq.net
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jonathan Gennick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

Re[2]: another OCP question -- help me guys

2004-01-07 Thread Jonathan Gennick

Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael ([EMAIL PROTECTED]) wrote:
RC I successfully use drop tablespace including contents and datafiles
RC all the time. And a quick check of the docs shows that cascade
RC constraints is valid but, as Richard said, belongs at the end of the
RC statement.

I stand corrected, though I did admit up front to not
having checked the manual. I was eating breakfast at the
time, so forgive me that one lapse.

I liked Richard's point about trusting what you see. He was
spot on with that comment, at least in this context.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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[2]: another OCP question -- help me guys

I didn't mean to scold... you post way more information than I usually
do!

And I answer whilst eating breakfast at times too :)

Richard *is* right, the problem is, the sql statement is misformed but
the answer key says it will work. Which is yet another reason I dislike
the OCP exams.


--- Jonathan Gennick [EMAIL PROTECTED] wrote:
 Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
 ([EMAIL PROTECTED]) wrote:
 RC I successfully use drop tablespace including contents and
 datafiles
 RC all the time. And a quick check of the docs shows that cascade
 RC constraints is valid but, as Richard said, belongs at the end of
 the
 RC statement.
 
 I stand corrected, though I did admit up front to not
 having checked the manual. I was eating breakfast at the
 time, so forgive me that one lapse.
 
 I liked Richard's point about trusting what you see. He was
 spot on with that comment, at least in this context.
 
 Best regards,
 
 Jonathan Gennick --- Brighten the corner where you are
 http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
 Join the Oracle-article list and receive one
 article on Oracle technologies per month by 
 email. To join, visit
 http://four.pairlist.net/mailman/listinfo/oracle-article, 
 or send email to [EMAIL PROTECTED] and 
 include the word subscribe in either the subject or body.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jonathan Gennick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan

A small but growing number of employers want certification. Considering the
job market, I recommend anyone who is not at Rachel's, etc.. level to get
certified as both a developer and a DBA. I'm doing Java also, just to have
it. The java test is a total joke. You only need to get 52% right and its
just one test, but people want it. You really don't even need to know java.
Just object-oriented programming and memorize a bunch of fairly useless
information.

Getting a good salary is more about your resume and how well you speak than
it is about your skill set. I've had alot of technical interviews and they
all seem to ask the same easy questions. They are interested in: years of
experience, degree, where your degree is from, certification, and in some
cases where you worked before. There is some bias in the DC area for 'top 5'
consulting. I think that means Booz Allen, and Ernst and Young. Not sure who
the other 3 happen to be.

People don't seem to be all that interested in whether you can actually do
the job. They just assume your better than someone else if you have a nicer
resume.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:34 AM


 I didn't mean to scold... you post way more information than I usually
 do!

 And I answer whilst eating breakfast at times too :)

 Richard *is* right, the problem is, the sql statement is misformed but
 the answer key says it will work. Which is yet another reason I dislike
 the OCP exams.


 --- Jonathan Gennick [EMAIL PROTECTED] wrote:
  Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
  ([EMAIL PROTECTED]) wrote:
  RC I successfully use drop tablespace including contents and
  datafiles
  RC all the time. And a quick check of the docs shows that cascade
  RC constraints is valid but, as Richard said, belongs at the end of
  the
  RC statement.
 
  I stand corrected, though I did admit up front to not
  having checked the manual. I was eating breakfast at the
  time, so forgive me that one lapse.
 
  I liked Richard's point about trusting what you see. He was
  spot on with that comment, at least in this context.
 
  Best regards,
 
  Jonathan Gennick --- Brighten the corner where you are
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit
  http://four.pairlist.net/mailman/listinfo/oracle-article,
  or send email to [EMAIL PROTECTED] and
  include the word subscribe in either the subject or body.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jonathan Gennick
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).


 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
   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: Ryan
  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[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J

Thanx for your reply Gennick.
..and for your word of caution about partitioned tables.

Cary , sometime back said  that :

Cary
There are always two answers to a question that your 
teacher would ask at school .
First one is the right answer.
Second one is the answer that your teacher would expect.
/Cary

The second answer is the one i mostly fail to find.

Regards,
Prem.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Stefick Ronald S Contr ESC/HRIDA

Title: RE: Re[2]: another OCP question -- help me guys





Uh No one can be at Rachel's level. She's the DBA Goddess






-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: another OCP question -- help me guys



A small but growing number of employers want certification. Considering the job market, I recommend anyone who is not at Rachel's, etc.. level to get certified as both a developer and a DBA. I'm doing Java also, just to have it. The java test is a total joke. You only need to get 52% right and its just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information.

Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be.

People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:34 AM



 I didn't mean to scold... you post way more information than I usually 
 do!

 And I answer whilst eating breakfast at times too :)

 Richard *is* right, the problem is, the sql statement is misformed but 
 the answer key says it will work. Which is yet another reason I 
 dislike the OCP exams.


 --- Jonathan Gennick [EMAIL PROTECTED] wrote:
  Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
  ([EMAIL PROTECTED]) wrote:
  RC I successfully use drop tablespace including contents and
  datafiles
  RC all the time. And a quick check of the docs shows that cascade 
  RC constraints is valid but, as Richard said, belongs at the end 
  RC of
  the
  RC statement.
 
  I stand corrected, though I did admit up front to not having checked 
  the manual. I was eating breakfast at the time, so forgive me that 
  one lapse.
 
  I liked Richard's point about trusting what you see. He was spot on 
  with that comment, at least in this context.
 
  Best regards,
 
  Jonathan Gennick --- Brighten the corner where you are 
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
 
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit 
  http://four.pairlist.net/mailman/listinfo/oracle-article,
  or send email to [EMAIL PROTECTED] and include the 
  word subscribe in either the subject or body.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jonathan Gennick
  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).


 __
 Do you Yahoo!?
 Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes 
 http://hotjobs.sweepstakes.yahoo.com/signingbonus
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
 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: Ryan
 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

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J

Ryan People don't seem to be all that interested in
Ryan whether you can actually do the job.

Ryan , i would change your first line as Some people don't seem to ...

Because some people really DO care about what one can do.

Ryan They just assume your better than someone
Ryan else if you have a nicer resume.

I agree . Because resume is the mirror which reflects an
individual until the interview happens .

Regards,
Prem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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[2]: another OCP question -- help me guys

Michael Abbey once said (I'm paraphrasing here) the resume and OCP get
you in the door. It's your experience that gets you the job and keeps
you there

We've had numerous discussions on this list about interview questions.
I've been on interviews where I spent an entire day (9-4) and talked to
11 different people, both non-technical questions and technical ones in
and out of my area of expertise. and this was AFTER a 90 minute phone
technical interview. I've been on interviews where there was no DBA on
site, so the  technical aspect of the interview was more an informal
consulting session (how would you handle this problem, when I could
tell it was one they were currently having)

I'm not interested in how much you've memorized. Or how well you take
standardized tests. I do ask questions that pertain to skill set and
creative thinking. 

Unfortunately these days, personnel departments do the initial
screening and they use a keyword search on college degree and OCP.
Wherever possible, I try to do the initial search and interview myself
and THEN pass a candidate along to HR. That way I can at least argue
for someone really good, even if their resume doesn't hit the keywords.

Oh yeah -- how does having a college degree in art history make a
person a better DBA? how does my degree, which is in computer science
but which is 28 years old, have anything to do with current programming
and database work?

And while we definitely need people who know a little about everything
(the primary care physician as it were) we still need experts in
specialized areas. I wouldn't necessarily urge people to study lots and
lots of things, that usually ends up meaning they do none of them well.

Okay, can you tell you poked one of my pet peeves? Off the soapbox for
now :)

my $0.02, for what it's worth (which is less and less these days!)

Rachel

--- Ryan [EMAIL PROTECTED] wrote:
 A small but growing number of employers want certification.
 Considering the
 job market, I recommend anyone who is not at Rachel's, etc.. level to
 get
 certified as both a developer and a DBA. I'm doing Java also, just to
 have
 it. The java test is a total joke. You only need to get 52% right and
 its
 just one test, but people want it. You really don't even need to know
 java.
 Just object-oriented programming and memorize a bunch of fairly
 useless
 information.
 
 Getting a good salary is more about your resume and how well you
 speak than
 it is about your skill set. I've had alot of technical interviews and
 they
 all seem to ask the same easy questions. They are interested in:
 years of
 experience, degree, where your degree is from, certification, and in
 some
 cases where you worked before. There is some bias in the DC area for
 'top 5'
 consulting. I think that means Booz Allen, and Ernst and Young. Not
 sure who
 the other 3 happen to be.
 
 People don't seem to be all that interested in whether you can
 actually do
 the job. They just assume your better than someone else if you have a
 nicer
 resume.
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 9:34 AM
 
 
  I didn't mean to scold... you post way more information than I
 usually
  do!
 
  And I answer whilst eating breakfast at times too :)
 
  Richard *is* right, the problem is, the sql statement is misformed
 but
  the answer key says it will work. Which is yet another reason I
 dislike
  the OCP exams.



__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William

Rachel Carmichael  scribbled on the wall in glitter crayon:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current
 programming and database work?

it gets you past the HR department so you actually get to talk to someone.
trust me, i know all about this one having neither a degree or an OCP.  and
having lost jobs to those art history degree holders.  [and yes i have been
asked to go back to those same places as a consultant to fix the mess.  and
no i didn't.]

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

You see, wire telegraph is a kind of a very, very long cat. You pull his
tail in New York and his head is meowing in Los Angeles. Do you understand
this? And radio operates exactly the same way: you send signals here, they
receive them there. The only difference is that there is no cat. - Albert
Einstein, when asked to describe radio
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan

degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp companies offer you
salary based mainly on your resume.

most technical interviews are a joke. I can make more money if I double my
experience level and have a computer science degree from harvard, while at
the same time halving my skillset and performance.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:29 AM


 Rachel Carmichael  scribbled on the wall in glitter crayon:

  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer science
  but which is 28 years old, have anything to do with current
  programming and database work?

 it gets you past the HR department so you actually get to talk to someone.
 trust me, i know all about this one having neither a degree or an OCP.
and
 having lost jobs to those art history degree holders.  [and yes i have
been
 asked to go back to those same places as a consultant to fix the mess.
and
 no i didn't.]

 --
 Bill Shrek Thater ORACLE DBA
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 You see, wire telegraph is a kind of a very, very long cat. You pull his
 tail in New York and his head is meowing in Los Angeles. Do you understand
 this? And radio operates exactly the same way: you send signals here, they
 receive them there. The only difference is that there is no cat. - Albert
 Einstein, when asked to describe radio
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Thater, William
   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: Ryan
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Mladen Gogala


On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current programming
 and database work?

Believe it or not, a college degree in art history really does help in two ways.
First, people exposed to sufficient quantity of art tend to be nobler and more 
spiritual, according to the popular beliefs, then cynical mathematicians and 
computer geeks like me. Being noble and spiritual means that they don't fight 
back but do as they're told which makes them into good corporate drones. Art
history is like an army boot camp for wannabe geeks. Their appearance also tends
to be much more pleasant and polished then an appearance of a hard core computer 
geek.
Second, art history majors make perfect sacrificial lambs. An art history major in 
IT department can be blamed for anything from bad weather, corrupt backup tape to 
stupid application design. My understanding is that you've moved to the management, 
which is the move that I admire and respect. As a manager, you should know the value 
of a sacrificial lamb that can be blamed for anything. If you want to make the next
step in your career, the step from management to damagement, you'll have to learn
how to play the blame shifting game. Art history majors are priceless for that.
--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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[2]: another OCP question -- help me guys

I do understand, and that's why I said that I tried to bring people in
first, before HR (as you know)


--- Thater, William [EMAIL PROTECTED] wrote:
 Rachel Carmichael  scribbled on the wall in glitter crayon:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
  programming and database work?
 
 it gets you past the HR department so you actually get to talk to
 someone.
 trust me, i know all about this one having neither a degree or an
 OCP.  and
 having lost jobs to those art history degree holders.  [and yes i
 have been
 asked to go back to those same places as a consultant to fix the
 mess.  and
 no i didn't.]
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]


 You see, wire telegraph is a kind of a very, very long cat. You pull
 his
 tail in New York and his head is meowing in Los Angeles. Do you
 understand
 this? And radio operates exactly the same way: you send signals here,
 they
 receive them there. The only difference is that there is no cat. -
 Albert
 Einstein, when asked to describe radio
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Thater, William
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William

Rachel Carmichael  scribbled on the wall in glitter crayon:

 I do understand, and that's why I said that I tried to bring people in
 first, before HR (as you know)

yup, but most places don't have a Goddess on staff.;-)  and i'm seeing the
requirement for OCP being listed in consulting postings now.  but then many
of those job requirements are generated by a company's HR and then sent out
by the consulting firms.  and less and less of them are mentioning
experience.  now there's and interesting trend, we don't care how long or
even if you've done the job, just if you have a degree or an OCP.

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

The point is to develop the childlike inclination for play and the childlike
desire for recognition and to guide the child over to important fields for
society. Such a school demands from the teacher that he be a kind of artist
in his province. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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[2]: another OCP question -- help me guys

Now I understand their use, I shall immediately go out and hire an art
history major as the deparmental sacrifical lamb (and dartboard while
we are at it)

I'm still a hands-on DBA, although I have some paperwork
responsibilities as well. Not management, other than my own work :)

Rachel

--- Mladen Gogala [EMAIL PROTECTED] wrote:
 
 On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
 programming
  and database work?
 
 Believe it or not, a college degree in art history really does help
 in two ways.
 First, people exposed to sufficient quantity of art tend to be nobler
 and more 
 spiritual, according to the popular beliefs, then cynical
 mathematicians and 
 computer geeks like me. Being noble and spiritual means that they
 don't fight 
 back but do as they're told which makes them into good corporate
 drones. Art
 history is like an army boot camp for wannabe geeks. Their appearance
 also tends
 to be much more pleasant and polished then an appearance of a hard
 core computer 
 geek.
 Second, art history majors make perfect sacrificial lambs. An art
 history major in 
 IT department can be blamed for anything from bad weather, corrupt
 backup tape to 
 stupid application design. My understanding is that you've moved to
 the management, 
 which is the move that I admire and respect. As a manager, you should
 know the value 
 of a sacrificial lamb that can be blamed for anything. If you want to
 make the next
 step in your career, the step from management to damagement, you'll
 have to learn
 how to play the blame shifting game. Art history majors are priceless
 for that.
 --
 Mladen Gogala
 Oracle DBA
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Mladen Gogala
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Loughmiller, Greg

Title: RE: Re[2]: another OCP question -- help me guys





brutal, absolutely brutal...


Rachel, can ya out-source your sacrificial lamb for our use as well:-)


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: another OCP question -- help me guys



Now I understand their use, I shall immediately go out and hire an art
history major as the deparmental sacrifical lamb (and dartboard while
we are at it)


I'm still a hands-on DBA, although I have some paperwork
responsibilities as well. Not management, other than my own work :)


Rachel


--- Mladen Gogala [EMAIL PROTECTED] wrote:
 
 On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
 programming
  and database work?
 
 Believe it or not, a college degree in art history really does help
 in two ways.
 First, people exposed to sufficient quantity of art tend to be nobler
 and more 
 spiritual, according to the popular beliefs, then cynical
 mathematicians and 
 computer geeks like me. Being noble and spiritual means that they
 don't fight 
 back but do as they're told which makes them into good corporate
 drones. Art
 history is like an army boot camp for wannabe geeks. Their appearance
 also tends
 to be much more pleasant and polished then an appearance of a hard
 core computer 
 geek.
 Second, art history majors make perfect sacrificial lambs. An art
 history major in 
 IT department can be blamed for anything from bad weather, corrupt
 backup tape to 
 stupid application design. My understanding is that you've moved to
 the management, 
 which is the move that I admire and respect. As a manager, you should
 know the value 
 of a sacrificial lamb that can be blamed for anything. If you want to
 make the next
 step in your career, the step from management to damagement, you'll
 have to learn
 how to play the blame shifting game. Art history majors are priceless
 for that.
 --
 Mladen Gogala
 Oracle DBA
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Mladen Gogala
 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).



__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
 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[2]: another OCP question -- help me guys

2004-01-07 Thread Goulet, Dick

Rachel,

A few years ago I was offered a job by a defense contractor in the area who 
was looking for a DBA, but more importantly a DBA with a still active clearance.  Well 
all was well in 90% of that company, except HR.  Simple answer, no degree no job.  I 
don't have the degree so they absolutely would not let the paperwork through, end of 
conversation.  So yes it does matter even when it makes no sense.  BTW: they did fill 
the job a year later with a person who had a degree in English believe it or not.  Her 
clearance was inactive  not current as well.  Guess it's better than no clearance.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 10:29 AM
To: Multiple recipients of list ORACLE-L


Rachel Carmichael  scribbled on the wall in glitter crayon:

 Oh yeah -- how does having a college degree in art history make a
 person a better DBA? how does my degree, which is in computer science
 but which is 28 years old, have anything to do with current
 programming and database work?

it gets you past the HR department so you actually get to talk to someone.
trust me, i know all about this one having neither a degree or an OCP.  and
having lost jobs to those art history degree holders.  [and yes i have been
asked to go back to those same places as a consultant to fix the mess.  and
no i didn't.]

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

You see, wire telegraph is a kind of a very, very long cat. You pull his
tail in New York and his head is meowing in Los Angeles. Do you understand
this? And radio operates exactly the same way: you send signals here, they
receive them there. The only difference is that there is no cat. - Albert
Einstein, when asked to describe radio
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: Goulet, Dick
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Poras, Henry R.

what you lose in worth you gain in self-worth.

Henry


-Original Message-
Ryan
Sent: Wednesday, January 07, 2004 10:55 AM
To: Multiple recipients of list ORACLE-L


degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp companies offer you
salary based mainly on your resume.

most technical interviews are a joke. I can make more money if I double my
experience level and have a computer science degree from harvard, while at
the same time halving my skillset and performance.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:29 AM


 Rachel Carmichael  scribbled on the wall in glitter crayon:

  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer science
  but which is 28 years old, have anything to do with current
  programming and database work?

 it gets you past the HR department so you actually get to talk to someone.
 trust me, i know all about this one having neither a degree or an OCP.
and
 having lost jobs to those art history degree holders.  [and yes i have
been
 asked to go back to those same places as a consultant to fix the mess.
and
 no i didn't.]

 --
 Bill Shrek Thater ORACLE DBA
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 You see, wire telegraph is a kind of a very, very long cat. You pull his
 tail in New York and his head is meowing in Los Angeles. Do you understand
 this? And radio operates exactly the same way: you send signals here, they
 receive them there. The only difference is that there is no cat. - Albert
 Einstein, when asked to describe radio
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Thater, William
   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: Ryan
  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: Poras, Henry R.
  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[2]: another OCP question -- help me guys

I know it makes no sense... but it has something to do with a (very)
antiquated class system and the difference between white-collar
workers and blue-collar workers and salary vs hourly wages

for the non-US, the term white collar worker refers to office staff,
who would wear a white shirt and tie to the office. While blue collar
refers to the people who get their hands dirty, wearing blue denim
shirts.

Always amused me that the IBM field staff had to wear white shirts and
ties while working on machinery that had grease and carbon etc all over
it.


--- Goulet, Dick [EMAIL PROTECTED] wrote:
 Rachel,
 
   A few years ago I was offered a job by a defense contractor in the
 area who was looking for a DBA, but more importantly a DBA with a
 still active clearance.  Well all was well in 90% of that company,
 except HR.  Simple answer, no degree no job.  I don't have the degree
 so they absolutely would not let the paperwork through, end of
 conversation.  So yes it does matter even when it makes no sense. 
 BTW: they did fill the job a year later with a person who had a
 degree in English believe it or not.  Her clearance was inactive 
 not current as well.  Guess it's better than no clearance.
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA
 
 -Original Message-
 Sent: Wednesday, January 07, 2004 10:29 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Rachel Carmichael  scribbled on the wall in glitter crayon:
 
  Oh yeah -- how does having a college degree in art history make a
  person a better DBA? how does my degree, which is in computer
 science
  but which is 28 years old, have anything to do with current
  programming and database work?
 
 it gets you past the HR department so you actually get to talk to
 someone.
 trust me, i know all about this one having neither a degree or an
 OCP.  and
 having lost jobs to those art history degree holders.  [and yes i
 have been
 asked to go back to those same places as a consultant to fix the
 mess.  and
 no i didn't.]
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]


 You see, wire telegraph is a kind of a very, very long cat. You pull
 his
 tail in New York and his head is meowing in Los Angeles. Do you
 understand
 this? And radio operates exactly the same way: you send signals here,
 they
 receive them there. The only difference is that there is no cat. -
 Albert
 Einstein, when asked to describe radio
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Thater, William
   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: Goulet, Dick
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: another OCP question -- help me guys

2004-01-07 Thread bulbultyagi


 Hi list , sorry to pester you with questions regarding
 boson OCP questions . i have scheduled for #1Z0-031 exam
 and so desperately need help from this list .
 please bear with me  for while . look at the 2 questions below .

Don't apologize Prem, who else are you gonna call,  ghostbusters? :)



 -
 QUESTION #1
 what happens when you issue the command below .
 drop tablespace testtbs including contents cascade constraints and
 datafiles;
 but boson's  choice is A.  i wonder how ???


Statement is incorrect, cascade constraints is placed in the end.  Fine that
explains that boson is wrong.  But if you want to prepare for ocp then , you
must also consider the possibility that a novice like me was sitting at
boson preparing these questions.  So the next time you come across a
question whose answer doesn't match yours do the following in the order
specified:

1. Assume boson is right and recheck your answer. Try it out on a test
database. (make sure you get the conditions of the question correctly
implemented).  See the docs.
2. Assume boson is right and read the solution /explanation for the answer,
then tally it with your answer and solution.
3. Still not happy ? Assume boson is right and re-read the question, there
may be one word or a comma or a full stop or a bracket ,etc that is
completly changing the meaning of the question but you may skipped it when
reading the question.  (It happens a lot to me, but then I am dumb :). Now
tally your answer with boson
4. Still not happy ? (there is no pleasing you, is there? :) ok now you can
do two things:
4a.  The question and the solution given by boson are blatantly wrong
(because of a typo or because I had set the question paper ) AND YOU ARE
ABLE TO COMPLETLY REASON OUT out what is so wrong about the question and
answer, what should it have been, what if that part of the question was
changed so , etc etc, ;  then correct the question and answer and move onto
the next one.
4b The question is still blatantly wrong but you have a nagging doubt, then
ask around .  There may be some obscure formula (which works only in OCP
exams) or the answer may be the least of all the evils given .  Either which
way time to mug it up


Now keeping in mind these policies, have another look at the two questions
you have given above and below.


 -
 QUESTION #2
 you need to determine how much space has been allocated for a table.
 which view would give you this information ?

 A. dba_extents
 B. dba_ts_quotas
 C. dba_segments

 my choice is C .
 but boson's choice is A . it says other views cannot give
 the required details .

 a metalink doc says that dba_segments.blocks gives the
 total number of blocks  allocated to the table.

 what will be the choice that you would go for ?
 -

Both A and C are right.  What will really boggle your mind is deciding what
to say if you get the exact same question in the ocp exam and you have to
make a single choice.
But relax ocp exams are not as troublesome, they are much more
professionally prepared.




 so now i have the question whether boson is reliable ?
 how many in this list have used it ?
 or am i missing something  : ((

After reading my letter I hope there is at least one thing you can say :
Boson is not reliable , but it is essential.  Remember , there is a big
difference between studying and studying for an exam .  And the only way to
ace the ocp is to do many question papers like boson.
..

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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[2]: another OCP question -- help me guys

2004-01-07 Thread Niall Litchfield

Rachel writes
 Now I understand their use, I shall immediately go out and 
 hire an art history major as the deparmental sacrifical lamb 
 (and dartboard while we are at it)

Hey I have an *economics* degree, *and* am a part-qualified accountant. I
claim that sacrificial lamb position as my own. Nothing so useful as Art in
my background, just graphs with the axes befuddled. 

Niall

P.S. I can work powerpoint too. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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[2]: another OCP question -- help me guys

you leave me such straight lines :)

which part is qualified as an accountant?

you volunteer to be the sacrificial lamb? Hm, masochist?

Before Jared tries to send everyone over to my list on this topic, I'll
try to bring it at least slightly back on topic.  I really don't care
if someone has a degree or has completed the OCP exams. I want to see
what they have done in practice, or if they are interviewing for a
truly junior position, I want to know how they learn, what they've
played with on their own. 

Two of the smartest men I have ever known never finished college.


--- Niall Litchfield [EMAIL PROTECTED] wrote:
 Rachel writes
  Now I understand their use, I shall immediately go out and 
  hire an art history major as the deparmental sacrifical lamb 
  (and dartboard while we are at it)
 
 Hey I have an *economics* degree, *and* am a part-qualified
 accountant. I
 claim that sacrificial lamb position as my own. Nothing so useful as
 Art in
 my background, just graphs with the axes befuddled. 
 
 Niall
 
 P.S. I can work powerpoint too. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Niall Litchfield
   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).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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: another OCP question -- help me guys

2004-01-07 Thread Naveen, Nahata (IE10)

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 11:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: another OCP question -- help me guys

  Hi list , sorry to pester you with questions regarding
  boson OCP questions . i have scheduled for #1Z0-031 exam
  and so desperately need help from this list .
  please bear with me  for while . look at the 2 questions below .

 Don't apologize Prem, who else are you gonna call,  ghostbusters? :)

there are lot of OCP-busters here :-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen, Nahata (IE10)
  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).

rep-1219 need help

2004-01-04 Thread Rohan Karanjawala



Hi friends
wish u all a very happy new year
i am getting the following error when i run my report
REP-1219:  'Object name' has no size -- length or width is zero.

but when i rebuild the report again it works well
but when i save it and run it next time it again gives the same error
and i have to rebuild it again to get the required report output
can somebody please help me out of this

thanks

regds,

Rohan



From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: starting/stopping trace in session
Date: Fri, 02 Jan 2004 20:24:25 -0800
Folks,

I've noticed -- at least on our 9.2 instances, that it does not seem
possible to generate two trace files from the same session.  Meaning, if I
start a trace in a session, then stop it, use tkprof to run some analysis,
and then erase that trace file, a second start_trace does /not/ generate a
new tracefile.  Is this expected behavior?
Adam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  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).
_
Games, MMS cards, ringtones. Operator logos, picture messages  more. 
http://server1.msn.co.in/sp03/mobilesms/ Jazz up your mobile!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rohan Karanjawala
 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: help with estimate row count from asktom

2003-12-31 Thread Yong Huang

One minor caveat about setting timed_os_statistics. On Solaris, if you set
timed_os_statistics to non-zero, microstate accounting at the OS level is
enabled for the server process. Common practice is to leave it off for
performance reason. But I've never seen experimental data proving the negative
effect of turning it on.

Yong Huang

Tanel Poder wrote:

Hi! Statistics level ALL means TYPICAL + row source execution stats +
timed_os_statistics. If you want to switch to ALL for performance reasons, you
can switch only row source stats on with parameter setting
_rowsource_execution_statistics to true (on session level). But I doubt it'll
help in current case anyway.

Tanel

__
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  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).

help with estimate row count from asktom

I have a very strict SLA and I posted a question on asktom about the best way to get 
the 'estimate' of rows and return it to the user. Im getting 'no data found'. anyone 
have ideas? Im on 9.2, tables are analyzed, and Im in a DBA account. 

my question is at the bottom.

http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: help with estimate row count from asktom

2003-12-30 Thread Wolfgang Breitling

v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level is set to ALL. You can set that at
the session level.
Has anyone done measurements on a busy system to evaluate what the impact
is of setting that system-wide. The impression I have is that it is not
something I want to set in production all the time.

At 08:39 AM 12/30/2003, you wrote:
I have a very strict SLA and I posted a question on asktom about the best
way to get the 'estimate' of rows and return it to the user. Im getting
'no data found'. anyone have ideas? Im on 9.2, tables are analyzed, and Im
in a DBA account.

my question is at the bottom.

http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
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: Re: help with estimate row count from asktom

im concerned about hitting the v$views in production. we have 30,000 users. its either
that or do counts. Its a requirement from the users.

not sure what to do. doesnt tom kyte do this on asktom?

From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row count from asktom

my question is at the bottom.

http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).

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]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]

RE: Re: help with estimate row count from asktom

2003-12-30 Thread Jamadagni, Rajendra

Don't be afraid to access  v$ views, just beware of the bug that throws a ora-600 when 
selecting 'filter_predicates' and 'access_predicates' under 9202. As a workaround, 
don't select those two columns. If I were you, I'd make sure that users are *very* 
clear that the number you are going to get is an 'ESTIMATE' only.

We run with statistics_level=ALL, haven't seen any noticeable difference, YMMV.
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Tuesday, December 30, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L


im concerned about hitting the v$views in production. we have 30,000 users. its either 
that or do counts. Its a requirement from the users. not sure what to do. doesnt tom 
kyte do this on asktom?

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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: help with estimate row count from asktom

2003-12-30 Thread Bobak, Mark

Ryan,

I asked Tom that very question a while ago, here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:8900576360328284797::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3489618933902,

The short answer is that he's using Intermedia for his searching, which has
the 'ctx_query.count_hits' functionality.  It's built-in to Intermedia.

-Mark


-Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:   Tue 12/30/2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: Re: help with estimate row count from asktom
im concerned about hitting the v$views in production. we have 30,000 users. its either 
that or do counts. Its a requirement from the users. 

not sure what to do. doesnt tom kyte do this on asktom?
 
 From: Wolfgang Breitling [EMAIL PROTECTED]
 Date: 2003/12/30 Tue PM 12:09:33 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: help with estimate row count from asktom
 
 v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only 
 have data to show if statistics_level is set to ALL. You can set that at 
 the session level.
 Has anyone done measurements on a busy system to evaluate what the impact 
 is of setting that system-wide. The impression I have is that it is not 
 something I want to set in production all the time.
 
 At 08:39 AM 12/30/2003, you wrote:
 I have a very strict SLA and I posted a question on asktom about the best 
 way to get the 'estimate' of rows and return it to the user. Im getting 
 'no data found'. anyone have ideas? Im on 9.2, tables are analyzed, and Im 
 in a DBA account.
 
 my question is at the bottom.
 
 http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: [EMAIL PROTECTED]
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).
 
 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: [EMAIL PROTECTED]
  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: Bobak, Mark
  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: help with estimate row count from asktom

anyone have a better way to do this? im going to post what you said wolfgang on asktom
and see what he has to say.

From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/12/30 Tue PM 12:09:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: help with estimate row count from asktom

my question is at the bottom.

http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]

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]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]

RE: Re: help with estimate row count from asktom

i could have swarn i read in multiple places that in a high transaction system hitting 
v$views repeatedly kills performance? causes excessive latching? 

ill have to test it to see if this is better than a count. Gonna be ugly either way. 

 From: Jamadagni, Rajendra [EMAIL PROTECTED]
 Date: 2003/12/30 Tue PM 01:29:25 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Re: help with estimate row count from asktom

 Don't be afraid to access  v$ views, just beware of the bug that throws a ora-600 
 when selecting 'filter_predicates' and 'access_predicates' under 9202. As a 
 workaround, don't select those two columns. If I were you, I'd make sure that users 
 are *very* clear that the number you are going to get is an 'ESTIMATE' only.

 We run with statistics_level=ALL, haven't seen any noticeable difference, YMMV.
 Raj

 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !

 -Original Message-
 Sent: Tuesday, December 30, 2003 1:19 PM
 To: Multiple recipients of list ORACLE-L

 im concerned about hitting the v$views in production. we have 30,000 users. its 
 either that or do counts. Its a requirement from the users. not sure what to do. 
 doesnt tom kyte do this on asktom?

 **
 This e-mail message is confidential, intended only for the named recipient(s) above 
 and may contain information that is privileged, attorney work product or exempt from 
 disclosure under applicable law. If you have received this message in error, or are 
 not the named recipient(s), please immediately notify corporate MIS at (860) 
 766-2000 and delete this e-mail message from your computer, Thank you.
 **4
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jamadagni, Rajendra
   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: [EMAIL PROTECTED]
  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: help with estimate row count from asktom

2003-12-30 Thread Tanel Poder

Hi!

Statistics level ALL means TYPICAL + row source execution stats +
timed_os_statistics.
If you want to switch to ALL for performance reasons, you can switch only
row source stats on with parameter setting _rowsource_execution_statistics
to true (on session level).

But I doubt it'll help in current case anyway.

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 9:19 PM


 anyone have a better way to do this? im going to post what you said
wolfgang on asktom and see what he has to say.
 
  From: Wolfgang Breitling [EMAIL PROTECTED]
  Date: 2003/12/30 Tue PM 12:09:33 EST
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: Re: help with estimate row count from asktom
 
  v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
  have data to show if statistics_level is set to ALL. You can set that at
  the session level.
  Has anyone done measurements on a busy system to evaluate what the
impact
  is of setting that system-wide. The impression I have is that it is not
  something I want to set in production all the time.
 
  At 08:39 AM 12/30/2003, you wrote:
  I have a very strict SLA and I posted a question on asktom about the
best
  way to get the 'estimate' of rows and return it to the user. Im getting
  'no data found'. anyone have ideas? Im on 9.2, tables are analyzed, and
Im
  in a DBA account.
  
  my question is at the bottom.
  
 
http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P
8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: [EMAIL PROTECTED]
 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).
 
  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: [EMAIL PROTECTED]
   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: Tanel Poder
  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 help with materialized view question

Im sure its a privilege issue. 

1. I have 3 tables with two different owners
2. I want to create a materialized join view of these tables in a 3rd user account. 
3. I altered the session to enable query rewrite and query_rewrite_integrity=trusted
4. I granted query rewrite enabled to every owner involved. 
5. I can create the materialized view, if I do not join them to one of the owners or 
leave off 'query rewrite enabled.

Here is what I get.

create materialized view test
build immediate
refresh on demand
enable query rewrite
as 
select columns
from user1.table1,
 user1.table2,
 user2.table3
where table1.pk = table2.pk
  and table2.pk = table3.pk

ERROR at line 9:
ORA-00942: table or view does not exist

I have all privileges on this table otherwise. I can do a select, describe, create 
materialized view without query rewrite

I take out 'query rewrite enabled' and it works.

I have granted query rewrite enabled to the user in question 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: please help with materialized view question

I figured it out. 

I have another problem. I create my materialized view. I now want to write a query 
that joins it to a transactional table. I want to use query rewrite. Problem is the 
join is not on the primary key of either table. 

Is it possible to enable query rewrite without that? I have it in trusted mode? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: please help with materialized view question

2003-12-26 Thread Thomas Day


public synonym?



   

  ryan_oracle 

  @cox.netTo:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  Sent by: cc: 

  ml-errorsSubject: please help with materialized 
view question
   

   

  12/26/2003 12:54 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Im sure its a privilege issue.

1. I have 3 tables with two different owners
2. I want to create a materialized join view of these tables in a 3rd user
account.
3. I altered the session to enable query rewrite and
query_rewrite_integrity=trusted
4. I granted query rewrite enabled to every owner involved.
5. I can create the materialized view, if I do not join them to one of the
owners or leave off 'query rewrite enabled.

Here is what I get.

create materialized view test
build immediate
refresh on demand
enable query rewrite
as
select columns
from user1.table1,
 user1.table2,
 user2.table3
where table1.pk = table2.pk
  and table2.pk = table3.pk

ERROR at line 9:
ORA-00942: table or view does not exist

I have all privileges on this table otherwise. I can do a select, describe,
create materialized view without query rewrite

I take out 'query rewrite enabled' and it works.

I have granted query rewrite enabled to the user in question

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
  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: Thomas Day
  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: please help with materialized view question

I figured it out. I need some help with query re-write. Im not sure its possible.

My materialized view joins 3 tables on the primary key/foreign key. I have a query 
that would join that materialized view to a third transactional table, but that join 
is not on any primary key or foreign key. 

I cant get it to re-write my query. My query joins 4 tables. 3 are in the materialized 
view. One is not. 

is this possible? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: please help with materialized view question

2003-12-26 Thread Jared . Still

Warning: I have not actually used query rewrite in this way, so take this
with a grain of salt.

If you're joining the MV directly to a table, what is there to rewrite?

If you were joining the tables that make up the MV, and doing so
on the same key that was used to create the MV, and joining
that result to a transactional table, it would make sense to use
query rewrite.

Based on your statement though, I don't see the need.

Clarification?

Jared

[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/26/2003 10:44 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: please help with materialized view question

I figured it out.

I have another problem. I create my materialized view. I now want to write a query that joins it to a transactional table. I want to use query rewrite. Problem is the join is not on the primary key of either table.

Is it possible to enable query rewrite without that? I have it in trusted mode?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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: please help with materialized view question