RE: FreeOCP

Meant to send it to the list... So here it is (once again to Jeff) ----- Forwarded by Cindy P Nathan/SWF/Pharma on 12/05/00 10:00 AM -----

	Cindy P Nathan
	12/05/00 09:59 AM
		
		 To: jeff_at_mpv.com_at_MHUB
		 cc: 
		 Subject: RE: FreeOCP

Hey, pardon me for having my feet in both the boats. Although, when I read Rama's impressions/opinions, I quite ageed to it myself, I really loved your attitude very much Jeff.

	jeff_at_mpv.com
	12/05/00 09:54 AM
		 
		 To: ORACLE-L_at_fatcity.com_at_SMTP
		 cc: (bcc: Cindy P Nathan/SWF/Pharma)
		 Subject: RE: FreeOCP

  Every person should be judged on their own individual merits...a veteran DBA without OCP might have a box at home (or at work) where they take the latest and greatest and play with all the new features to figure out how they work and see what kind of advantages they bring. You could have a DBA with lots of years of experience recorded and an OCP that has just been soaking up money in a big contract for a consulting firm somewhere (and not really doing much), but they've had lots of time to take the tests (until they passed them all). There are too many variables in this world to judge a situation without getting all of the details...keeping that in mind, I cannot agree with your viewpoint that an OCP DBA with experience is going to be better than any other DBA--every situation is different. When interviewing other DBAs, I might make initial judgements after reviewing their resume, but (unless that resume is really, really bad) I won't rule them out until I've had a chance to talk with them. The DBA market is a tight market, why rule out any potentially good employee/help based on years of experience or a piece of paper? None of that can tell me exactly what kind of heart, will, intelligence, common sense, personality, or learning ability a person has. OCP and years of experience have definite merits when trying to get HR's attention and jacking prices in contracts, but if the person behind all that isn't really that good...

  Sorry about the rant, but I just couldn't sit back and listen to all this without saying something...

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
Sent: Monday, December 04, 2000 4:51 PM
To: Multiple recipients of list ORACLE-L

Hi friends!
 There is a lots of talk about Paper DBAs on this message board. With due respect to all the veteran DBAs without OCP and new DBAs with OCP, I would like to make few comments from my own personal experience (spanning 9 years+ in USA, Europe and India)

 I have come across lots of long time DBAs with no OCP, who frown on OCP DBAs. Working closely with them, I noticed that these longs really count the hours to bill the clients. To my dismay, I came across 10+ years Oracle DBAs who had no clue about OPS, Partitioning, Snapshots, Stand by etc... They have gained experience over the years only because the client could not find a better alternative.

 At the same time, in the interviews and at work, I come across lots of new OCP DBAs who can do the job, but need lots support and help from the other DBAs. (It is sort of baby sitting).

 I was a DBA without OCP for long time and I had no problem in finding jobs without OCP. After I started preparing for OCP, I came to know of so many things that I did not know before. In my humble opinion, any OCP DBA with experience is lot better than a OCP DBA without experience or an experienced DBA without OCP.

 OCP helped me as a DBA to understand things that I did not know before. It took lots of time, confidence and enthusiasm to be a OCP DBA and change my self in the process.

 Without OCP, I would have been a Pumpkin DBA, doing clueless things in a random and unilateral way. Let's face it... OCP or No OCP is a matter of choice. But it helps to be OCP than be left-out and looking at SOUR GRAPES!!! Rama
OCP DBA with experience!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rama Malladi
  INET: rmalladi_at_inteliant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.com
-- 
Author: Jeffery Stevenson
  INET: jeff_at_mpv.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).




------------------------------

 From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
 Date: Tue, 5 Dec 2000 10:06:02 -0500
 Subject: Re: Off Topic -Happy Ramadhan

I think that good wishes are always welcome. Ruth
----- Original Message ----- 
From: "Rifan Mohammed" <Rifan.Mohammed_at_almarai.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, December 05, 2000 6:40 AM
Subject: RE: Off Topic -Happy Ramadhan




> This is not a place for send Ramadhan greetings, Please strict to Oracle

> Issues.

> 

> Mohammed

> 

> -----Original Message-----

> From: Abdul Aleem [SMTP:abchaudhary-ho_at_beaconhouse.edu.pk]

> Sent: Tuesday, December 05, 2000 9:46 AM

> To: Multiple recipients of list ORACLE-L

> Subject: Off Topic -Happy Ramadhan

> 

> To all observing the month of Ramadhan,

> 

> A very Happy Ramadhan with all its benefits.

> 

> Aleem

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: Abdul Aleem

>   INET: abchaudhary-ho_at_beaconhouse.edu.pk

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing

> Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (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.com

> -- 

> Author: Rifan Mohammed

>   INET: Rifan.Mohammed_at_almarai.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (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).




------------------------------

 From: Jonathan Gennick <jonathan_at_gennick.com>
 Date: Tue, 5 Dec 2000 10:36:00 -0500
 Subject: Re: A Complaint About Tuning  Books and Presentations

Hello Ian,

Doesn't Guy Harrison's book get into this type of thing?
Have you looked at that?

Best regards,

Jonathan                            
mailto:jonathan_at_gennick.com
http://gennick.com

Monday, December 04, 2000, 2:11:31 PM, you wrote:

MIA> I have yet to find a book which gives examples along the following lines.

MIA> Table A and table B  are related as  parent and child.  Table A has 80,000
MIA> rows and table B has 120,000 rows. The average rowsize of table A is twice
MIA> that of table B.

MIA> Table A has unique index  on the column, id; table B has a concatenated
MIA> unique index on id and line_number.   A query is to be written based on the
MIA> value of the item_type column in table B.  A count of each value of
MIA> item_type returns about 50 rows per value.  What index would you build to
MIA> optimize the following query?

MIA> select A.field_non_in_index, B.field_not_in_index
MIA> from table A, TABLE B
MIA> WHERE A.ID = B.ID 
MIA> and B.ITEM_TYPE = 'SOUP'
MIA> /

MIA> Would you  make an index on table B comprised of  id, line_number,
MIA> item_type,  one containing  id and item_type, or
MIA> one with only item_type?


MIA> The index should be placed on item_type.  The reasons are as follows.  The
MIA> restriction and B.ITEM_TYPE = 'SOUP'  returns about 50 rows fromm table B.
MIA> This is tne most restrictive condition in the query.  Once it is applied you
MIA> have a 50 row
MIA> relation, I'll call it B', being joined to  one with 80,000 rows.  The
MIA> number difference in the number of rows indicates a nested loops join with