Re: the ora certified masters cert, yet again

[Don Granaman]

>From my experience with a few DBAs that waved their OCP around like it was a
Nobel prize, some probably should have malpractice insurance.  Lots of it.

Don Granaman
[Certifiable OraSaurus - NOCP]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 1:08 AM


But doctors have malpractice insurance and OCP does not or do/should OCP
have
one too.

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

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[MacGregor, Ian A.]

Perhaps thing have become  lapse, and security does not always  make sense.  Look at 
the employment ads for any contractor wjere such a clearance is desirable, You'll 
never see any mention of the term SCI.  In the military things may be looser, after 
all one's job, or sometimes one's command can give a pretty good clue as to whether 
the person holds such a clearance.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, June 26, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L


That is not my understanding.

FWIW.  Mike

-Original Message-
Sent: Wednesday, June 26, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L


Actually no one who has been holds any SCI tickets can admit to doing so :)
One can say you have been the subject of a Special Backgroud Investigation,
and Extensive Background Investigation, a Full Field Investigation even
though 99. times out of 100 these investigations are done for just such
access.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


I suspect that this position will be at Wright-Patterson Air Force base.

OraStaff wrote:
> 
> Position: Oracle DBA with Top Secret SCI Clearance
>   (Please do not send your resume unless you have the required
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Grant Allen]

Rachel Carmichael[SMTP:[EMAIL PROTECTED]] wrote:
> >this goes back to a thread from maybe a year ago... what sort of
> >questions do you ask on interviews.
> >
> >I may ask other questions based on what we are specifically looking for
> >or building off something the interviewee says but I always include the
> >following questions:
> >
> >1) what was your worst nightmare as a DBA and how did you resolve it
> >2) what are you most proud of doing 
> >3) how do you learn new things about Oracle
> >
> >gee, not ONE multiple choice question among them!
> 
[stops lurking for a change]

I always throw in

"What do you like most about Oracle?" and "What do you hate/find-frustrating
about Oracle?".  Most can answer the first, but you can often get a good
idea of what people have (or haven't!) experienced with their answer to the
second.

Ciao
Fuzzy
:-)

[goes back to lurking]

--
"Woo Hoo!" - H. Simpson
--
The contents of this post are my opinions only
  If swallowed seek medical advice

(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software.  If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments.  If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments.  Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[ltiu]

But doctors have malpractice insurance and OCP does not or do/should OCP have 
one too.

On Wednesday 26 June 2002 22:08, you wrote:
> It takes a lot of time and effort (and money if you pay for lessons) to run
> around the parking lot flapping your arms trying to learn to fly also...
> And I'm SURE that SOMEBODY would sell you a license - for the right price.
> So it must be worthwhile ;-)
>
> I would certainly hope that Doctors aren't educated and tested like OCP
> candidates!  Hmmm...
>
> [62% is a passing score.]
>
> 3) Severe arterial bleeding should be
> a) encouraged
> b) covered by the HMO
> c) stopped
> d) converted to vascular
> e) ignored
>
> 2) What type(s) of leech should be applied for an acute myocardial
> infarction?  (Choose all that apply)
> a) Erpobdella punctata
> b) Macrobdella decora
> c) Pharyngobdellida
> d) Rhyncobdellida
> e) Gnatbobdellida
>
> 3) The third selection from the top on the "Configuration" menu of the
> RunAmok Technologies Defibrillator for Dummies (TM) is:
> a) voltage
> b) amperage
> c) frequency
> d) duration
> e) billing rate
>
> [...]
>
> Don Granaman
> [certifiable OraSaurus - nOCP]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Don Granaman]

The Chauncey certification exam (singular) was a failure because:
1) It didn't parrot/require enough Oracle ILT material
2) Oracle Corp didn't get a big enough cut
3) It was more scenario-based - requiring more understanding and less
"knowledge"

OCP is more like a "learner's permit".  The Chauncey certification was more
like a chauffeur's license.

Don Granaman
[OraSaurus - Just say NO(CP)]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 9:33 AM


Well that explains a lot. In a separate post Rachel also said Oracle
denigrated the prior Chauncey/IOUG tests so it's obvious that Oracle is just
using testing and certification as another source of revenue. Professional
Development of the DBA community is just marketing hype. All the more reason
to avoid the 9i tests.

-Original Message-
Sent: Tuesday, June 25, 2002 7:08 PM
To: Multiple recipients of list ORACLE-L
Importance: High


The original certification program was developed by IOUG when Mike Corey was
president of the group.  I cannot remember if the program ever certified
anyone other than those who built it.   Once Oracle had its own
certification program  the IOUG one withered.

The relationship between ORACLE and its user groups have not always been
friendly.  The OAUG's complaints have made the national press.  If my memory
serves, and its already been shown to be faulty,  the first OOW-Americas was
scheduled to be at the same time as the IOUG-A.   Corey indicated he was
going to see Ellison and explain to him that he couldn't do such a thing,
that OOW-Americas would have to be rescheduled.  Ellison was not moved,
neither was the OOW-Americas conference; the IOUG-A get together was :)

To its credit IOUG-A live is seen as a more credible than the marketing show
known as OOW.  However I doubt the conference would maintain its value if
Oracle sent no one.   If the IOUG had a competing certification program,
Oracle would do its best to snuff it out.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Don Granaman
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Don Granaman]

It takes a lot of time and effort (and money if you pay for lessons) to run
around the parking lot flapping your arms trying to learn to fly also...
And I'm SURE that SOMEBODY would sell you a license - for the right price.
So it must be worthwhile ;-)

I would certainly hope that Doctors aren't educated and tested like OCP
candidates!  Hmmm...

[62% is a passing score.]

3) Severe arterial bleeding should be
a) encouraged
b) covered by the HMO
c) stopped
d) converted to vascular
e) ignored

2) What type(s) of leech should be applied for an acute myocardial
infarction?  (Choose all that apply)
a) Erpobdella punctata
b) Macrobdella decora
c) Pharyngobdellida
d) Rhyncobdellida
e) Gnatbobdellida

3) The third selection from the top on the "Configuration" menu of the
RunAmok Technologies Defibrillator for Dummies (TM) is:
a) voltage
b) amperage
c) frequency
d) duration
e) billing rate

[...]

Don Granaman
[certifiable OraSaurus - nOCP]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 6:25 PM


Work experience is better than certification but ...

Getting certified is hard work. Takes a lot of time and effort (not to
mention money). So it must be worth something. If only for a little bit. It
is definitely not worthless.

Work experience plus certification is the best combination.

Certification is no different from being a doctor. You need to pass exams to
be a doctor too (you need internship to go as well, of course).

As for naming famous Oracle authors, I don't think this is a valid gauge of
your capacity as a DBA. I know some people well versed in Computer
Engineering concepts (from 'great' authors) but can't code. They sound like
experts but can't deliver sh_t.

ltiu

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

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: [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: Summary: sqlplus: Permission denied

[ltiu]

No, actually I ran sqlplus, oemapp and genclntsh and all failed.

I only indicated sqlplus as an example.

Sorry for the confusion.

ltiu
On Wednesday 26 June 2002 20:04, you wrote:
> Now I am curious to know what partition was mounted differently? What did
> it contain? How come only sqlplus was affected?
>
> - Kirti
>
>
> -Original Message-
> From: ltiu [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 10:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Summary: sqlplus: Permission denied
>
>
> OK Guys.
>
> Here's the solution.
>
> Apparently the partition had been mounted by a regular user with the "user"
> flag set in /etc/fstab.
>
> If "user" flag is set, then the partition is automatically mounted
> "noexec".
>
> To enabled "exec", you'd have to EXPLICITLY say so in /etc/fstab.
>
> Too much security is bad !!!
>
> Many thanks to all who helped.
>
> ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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: conferences - IOUG vs OOW

[Don Granaman]

Ditto.  There are some great technical sessions at OOW, but the percentage
is dramatically lower.  Oracle chooses the vast majority of the
presentations at OOW and their motivation is quite different from that of
IOUG.  It seems that every morning at OOW is largely consumed with keynote
(e.g. "pump me up" marketing) sessions.  One per conference is about all I
can take - sometimes even that is too much ;-)  In a way its OK though - you
can usually just sleep in!  [Actually, they seem to have caught on to this
(at both conferences!) and now scatter them throughout the day more].

A huge plus is that the crowd at IOUG-A Live! (nee IOUW) is *MUCH* smaller.
The possibility of becoming roadkill, as in the inter-session stampede at
the Moscone center, doesn't exist at IOUW.  There are more/better chances of
running into and hanging with your homies from the list.  At the IOUG
conference (especially), some of the best technical "sessions" are/were on
the sun deck, in Starbucks, etc.  The roundtables at IOUW are a real plus
also.

One advantage that OOW does have though is that Oracle usually lets some of
their best deep-geeks escape from the bowels of the mothership to go to the
conference.  I always seem to get chances to drag them off for a little
one-on-one time or at least some ad hoc small group discussion.  (Its nice
to have friends in low places!)

Don Granaman
[certifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 4:39 PM


my preference when I have to choose is IOUG over OOW

OOW tends to have a lot more marketing/Oracle employee (so it feels
like marketing) presentations


--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> Having never been to either and wanting to plan for one, am I to
> infer from
> some of this discussion that for real content (as opposed to
> marketing
> fluff), THE conference to attend would be IOUGLive, as opposed to
> Oracle
> Open World?
>
> -bill
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Magaliff, Bill
>   INET: [EMAIL PROTECTED]
>
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Don Granaman
  INET: [EMAIL PROTECTED]

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: [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: Summary: sqlplus: Permission denied

[Deshpande, Kirti]

Now I am curious to know what partition was mounted differently? What did it
contain? How come only sqlplus was affected? 

- Kirti 


-Original Message-
Sent: Wednesday, June 26, 2002 10:49 PM
To: Multiple recipients of list ORACLE-L


OK Guys.

Here's the solution. 

Apparently the partition had been mounted by a regular user with the "user" 
flag set in /etc/fstab.

If "user" flag is set, then the partition is automatically mounted "noexec".

To enabled "exec", you'd have to EXPLICITLY say so in /etc/fstab.
 
Too much security is bad !!!

Many thanks to all who helped.

ltiu

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

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: [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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Joe Testa]

My guess is Wright-Patterson Air Force Base.

I think we should make this a game,
   Whenever Mr Orastaff posts a position, we try to decipher what 
company it is for.

Then Mr Orastaff can come back and tell us we're right OR you can by 
pass him and keep the finders fee for your salary :)

joe


OraStaff wrote:

>Position: Oracle DBA with Top Secret SCI Clearance
>  (Please do not send your resume unless you have the required
>clearance)
>  
>Location: Dayton, Ohio
>
>Salary Range: Depends on experience.
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot be
>considered.
>If you are employed by a consulting company you must have a long term
>project history.
>
>This is a full time staff position so no sub-contractors or third parties
>please.
>
>Responsibilities/Requirements:
>Installation and maintenance of an Oracle database. 
>Perform DBA duties for various projects within the company. 
>Perform design, modeling and implementation of a data warehouse with data
>marts, 
>including writing SQL scripts and stored procedures and using ETL tools. 
>Will use Oracle products, utilities and third party tools. 
>Familiarity with Unix and Windows system administration is required. 
>Must also be capable of installing and configuring related applications and
>utilities. 
>Experience/Education: Candidates should possess a Bachelors degree in
>Computer Science 
>or equivalent field. 
>Requires a minimum of 4 years experience using Oracle products and SQL
>scripting experience.
>
>-Must have an active or recently deactivated TS SCI Clearance
>
>For  immediate consideration, please send your resume as a Word attachment to:
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Please use job code: One/Dayton TS DBA/Mike
>ph: 1-800 -549-8502
>
>All Submissions are handled in confidence.
>
>*We pay referral fees.
>So please contact me if you know of anyone who would be qualified/interested
>in the posiition described above- if it is not a match for your skills.
>Thanks,
>Bill Law
>



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

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Deshpande, Kirti]

That's what I was wondering too! 
Are there any Cram books for this one? 
Wonder if Oracle would offer that test too... some day ;-)) After OCM, they
may need something new :))


-Original Message-
Sent: Wednesday, June 26, 2002 10:34 PM
To: Multiple recipients of list ORACLE-L


Where can I take the " Top Secret clearance" certification exam

At 03:53 PM 6/26/2002 -0800, you wrote:
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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).

Summary: sqlplus: Permission denied

[ltiu]

OK Guys.

Here's the solution. 

Apparently the partition had been mounted by a regular user with the "user" 
flag set in /etc/fstab.

If "user" flag is set, then the partition is automatically mounted "noexec".  
To enabled "exec", you'd have to EXPLICITLY say so in /etc/fstab.
 
Too much security is bad !!!

Many thanks to all who helped.

ltiu

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

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: [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: Difference Between DBMS/RDBMS

[Don Granaman]

  Overlays in
Turbo Pascal

One of the more challenging aspects of writing Pro*C user exit code for
Forms 2.3 on a DOS client running against an Oracle 5 database was trying to
link 1,000 or so C functions (at one function per file for modularity) to
create a large iapx (?correct name for version?) executable within a
segmented 16-bit architecture.  [These young whipper-snappers today have it
SO easy!]

Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 6:20 AM


As I recall, the Dec product was called Rdb, and generally regarded as quite
good. It was subsequently bought by  Oracle.

The old hierarchical and network systems did not require foreign keys,
because all records were explicitly linked via hard-coded pointers. So you
HAD to get your design right before building the data model, otherwise
retrieval would be a nightmare.

Because relational systems allow joins at query time, a major slackness has
crept into database model design. Like not always protecting the integrity
of PKs...

Talking of working on small memory machines - here is a test for your age in
the industry - all those who can remember writing overlays stand up! I
suspect the current crop of PC software engineers have never encountered
overlay programing.

peter
edinburgh

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

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: [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: the ora certified masters cert, yet again

[Karniotis, Stephen]

Greg & Rachel:

   I wish I could help on this one.  I believe this is one of the questions
on the overall evaluation.  I don't have any figures on this.  As far as the
top 10 presentations, those are determined by the overall scores.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, June 26, 2002 10:34 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: the ora certified masters cert, yet again

Greg,

nope, but Stephen Karniotis might, as he is directly involved with IOUG
and the conference itself. I go as a presenter or registrant only. 

Rachel
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> Of all the people who attend the conference, do you happen to know
> how many
> actually go to the trouble of voting for best presentation?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Robert Monical]

Where can I take the " Top Secret clearance" certification exam

At 03:53 PM 6/26/2002 -0800, you wrote:

>I don't understand the large number of positions coming out that require a 
>CURRENT Secret or Top Secret clearance.  How can all these positions be 
>filled unless these company/entities start footing the bill for people 
>getting the clearances?!?
>
>Johnson, Michael wrote:
>
>>That is not my understanding.
>>
>>FWIW.  Mike
>>
>>-Original Message-
>>Sent: Wednesday, June 26, 2002 1:35 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Actually no one who has been holds any SCI tickets can admit to doing so :)
>>One can say you have been the subject of a Special Backgroud Investigation,
>>and Extensive Background Investigation, a Full Field Investigation even
>>though 99. times out of 100 these investigations are done for just such
>>access.
>>
>>Ian MacGregor
>>Stanford Linear Accelerator Center
>>[EMAIL PROTECTED]
>>
>>
>>-Original Message-
>>Sent: Wednesday, June 26, 2002 9:24 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>I suspect that this position will be at Wright-Patterson Air Force base.
>>
>>OraStaff wrote:
>>
>>
>>>Position: Oracle DBA with Top Secret SCI Clearance
>>>  (Please do not send your resume unless you have the required
>>>
>
>--
>Jesse W. Asher
>
>"They that can give up essential liberty to purchase a little temporary
>safety, deserve neither liberty or safety."  - Benjamin Franklin
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse W. Asher
>  INET: [EMAIL PROTECTED]
>
>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: [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.com
-- 
Author: Robert Monical
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Karniotis, Stephen]

Wow.  Knitting.  I will have to watch for that.  At Live, She came late,
stayed a good portion, rah ra'd for a bit and left.  Guess I was real lucky.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, June 26, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: the ora certified masters cert, yet again

You're both lucky! She stayed all the way through mine and never once broke
out her knitting!

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Wednesday, June 26, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L


Matt, she walked out in the middle of your presentation??  

Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
well...

-Original Message-
Sent: Wednesday, June 26, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L


well, if so, I'll finally get to see you present and won't have to walk
out in the middle 


--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Right now, I think Susan has me from 1-2, right after
> lunch, but I'm not sure. The OOUG web site is a 
> little sparse on details.
> 
> 
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> But Mtt... you were always scheduled at either the
> same
> time *I* was presenting (trust me, I'd rather have gone to yours, I
> get
> stage fright) or when at LEAST 2 other presentations I wanted to see
> equally as much were there.
> 
> Um, what time are you presenting at OOUG? My flight home is at 5, I
> have to leave around 2:30 or so
> 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > But Rachel, you never came to any of my 
> > presentations!  (in my best whiney voice)
> > 
> > At least you'll get to see me present in July at OOUG.
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 3:56 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > that's 'cause you present well and have knowledge
> > 
> > or.. to quote one of my favorite shows:
> > 
> > "he has much knowledge. we must build an altar and worship him"
> > 
> > 
> > :)
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > Actually, I had to miss this years (even though I was orginally
> > > schedule
> > > to give two presentations)  due to a medical situation.  I gave
> > four
> > > the
> > > year
> > > before that.  
> > >  
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence? 
> > > 
> > >  
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> to
> > > weed out
> > > the fluff.  If you were at IOUG this year, you should have
> noticed
> > a
> > > significant reduction in the marketing fluff and more technical
> > > content.
> > > Yes, some showmanship is necessary when giving a presentation,
> but
> > > the
> > > content has to be there.
> > > 
> > >  
> > > 
> > > Many people on this forum have submitted presentations to my
> track
> > > and then
> > > complained that they were not accepted.  Let me give you some
> > > concrete
> > > numbers.  This year, we received over 400 abstracts for the DBA
> > track
> > > alone
> > > and accepted only 80.  If one slips through the cracks, it won't
> a
> > > second
> > > time.  Believe me when I say that 2002 was the best
> > content-organized
> > > IOUG.
> > > 
> > > 
> > >  
> > > 
> > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > 
> > >  
> > > 
> > > Thank You
> > > 
> > >  
> > > 
> > > Stephen P. Karniotis
> > > 
> > > Product Architect
> > > 
> > > Compuware Corporation
> > > 
> > > Direct:   (248) 865-4350
> > > 
> > > Mobile:  (248) 408-2918
> > > 
> > > Email:  [EMAIL PROTECTED]
> > > 
> > > Web:www.compuware.com
> > > 
> > >  
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > >  
> > > 
> > > unfortunately, I've seen this to be true at 
> > > many conferences, including the IOUG 
> > > and SEOUC. 
> > > 
> > >  
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > > "Doing linear scans over an associative array is like 
> > > trying to club someone to deat

RE: the ora certified masters cert, yet again

[Karniotis, Stephen]

So Dan.  That means that all of the harassment I gave you outside the
conference center last year worked.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, June 26, 2002 7:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: the ora certified masters cert, yet again

I'd like to see a vote conducted 6 months after the conference. 'Of all the
presentations and papers available at the conference, which are the 5 that
you have found most valuable and useful in your work and/or career?'

The highest compliment I was ever paid was 6 months after my first UG
presentation. A fellow DBA came up and said that he had returned to work
after the conference and used my paper and presentation to audit their
backup & recovery process, identify the outstanding issues and implement a
new process that they tested (not in production) and it worked better than
their old system. 

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Wednesday, June 26, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L


Rachel,

Of all the people who attend the conference, do you happen to know how many
actually go to the trouble of voting for best presentation?

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

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: [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.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

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: [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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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: [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: sqlplus: Permission denied

[Robert Monical]

I think sh expects a shell command script.  Never tried
sending it a binary.
So I just did.
On my Solaris Intel box, it always returns an error :Unexpected '('

Now, when I put my fully qualified sqlplus is a text file say:
shsqlplus
The file has the following string:
/opt/oracle/bin/sqlplus

and then do a sh shsqlplus, sqlplus opens fine.

I think your flavor of Linux is a little more aggressive in protecting
you against sending binaries to the command interpreter. 
Tho one could speculate on some possible interesting results throwing
(essentially) random data at the command interpreter.

At 02:38 PM 6/26/2002 -0800, you wrote:
Hello,

Could someone help me decipher these?

1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission 
denied"

2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter:
Permission denied"

Thanks.

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


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

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: [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: the ora certified masters cert, yet again

[Joe Testa]

oh look now the dba goddess is offended :)

joe


Rachel Carmichael wrote:

>YO! JARED! has this gotten off-topic yet? since when is "picking on
>Rachel" part of the on topic list???
>
>--- Joe Testa <[EMAIL PROTECTED]> wrote:
>  
>
>>Chris, feel blessed, she stays during all of mine and asks bizarre 
>>questions :),
>>
>>like:  If 2 control files are being updated at the same time and one
>>is 
>>on raid-5 and the other on raid 0+1, which one will be finished
>>updating 
>>first.
>>
>>joe
>>
>>
>>Grabowy, Chris wrote:
>>
>>
>>
>>>Matt, she walked out in the middle of your presentation??  
>>>
>>>Your lucky.  She walked out of mine at the beginning, shaking her
>>>  
>>>
>>head.  Oh
>>
>>
>>>well...
>>>
>>>-Original Message-
>>>Sent: Wednesday, June 26, 2002 5:40 PM
>>>To: Multiple recipients of list ORACLE-L
>>>
>>>
>>>well, if so, I'll finally get to see you present and won't have to
>>>  
>>>
>>walk
>>
>>
>>>out in the middle 
>>>
>>>
>>>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
>>>wrote:
>>> 
>>>
>>>  
>>>
Right now, I think Susan has me from 1-2, right after
lunch, but I'm not sure. The OOUG web site is a 
little sparse on details.




Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?

-Original Message-
Sent: Wednesday, June 26, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L


But Mtt... you were always scheduled at either the
same
time *I* was presenting (trust me, I'd rather have gone to yours, I
get
stage fright) or when at LEAST 2 other presentations I wanted to


>>see
>>
>>
equally as much were there.

Um, what time are you presenting at OOUG? My flight home is at 5, I
have to leave around 2:30 or so



--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
   



>But Rachel, you never came to any of my 
>presentations!  (in my best whiney voice)
>
>At least you'll get to see me present in July at OOUG.
>
>
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>We have enough youth.
>How about a fountain of intelligence?
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 3:56 PM
>To: Multiple recipients of list ORACLE-L
>
>
>that's 'cause you present well and have knowledge
>
>or.. to quote one of my favorite shows:
>
>"he has much knowledge. we must build an altar and worship him"
>
>
>:)
>
>
>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
>wrote:
> 
>
>  
>
>>Actually, I had to miss this years (even though I was orginally
>>schedule
>>to give two presentations)  due to a medical situation.  I gave
>>   
>>
>>
>>
>four
> 
>
>  
>
>>the
>>year
>>before that.  
>>
>>
>>
>>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>>We have enough youth.
>>How about a fountain of intelligence? 
>>
>>
>>-Original Message-
>>Sent: Wednesday, June 26, 2002 1:09 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>OK.  As the DBA Focus Area Manager for the IOUG, we do our best
>>   
>>
>>
>>
to
   



>>weed out
>>the fluff.  If you were at IOUG this year, you should have
>>   
>>
>>
>>
noticed
   



>a
> 
>
>  
>
>>significant reduction in the marketing fluff and more technical
>>content.
>>Yes, some showmanship is necessary when giving a presentation,
>>   
>>
>>
>>
but
   



>>the
>>content has to be there.
>>
>>
>>
>>Many people on this forum have submitted presentations to my
>>   
>>
>>
>>
track
   



>>and then
>>complained that they were not accepted.  Let me give you some
>>concrete
>>numbers.  This year, we received over 400 abstracts for the DBA
>>   
>>
>>
>>
>track
> 
>
>  
>
>>alone
>>and accepted only 80.  If one slips through the cracks, it won't
>>   
>>
>>
>>
a
   



>>second
>>time.  Believe me when I say that 2002 was the best
>>   
>>
>>
>>
>content-organized
> 
>
>  
>
>>IOUG.
>>
>>
>>
>>
>>Further comments?  Submit an abstract for 2003 and find out!!!
>>
>>
>>
>>Thank You
>>
>

Re: Career Opportunities Announcement

[KENNETH JANUSZ]

You lost me on this location.  Is it located near Chicago?  I cannot
relocate outside of the Mpls / St. Paul, MN area.

Ken
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 5:23 PM


> Kenneth,
>   250 miles SE(Northern Chicagc suburb).Relative to
> Minneapolis/St Paul..I've a client company whom I could explore
> in your behalf.Re:Oracle clinical.
>   So,...let me know your thoughts,
> Bill Christison
>
> --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote:
> > Any Oracle in Minneapolis / St. Paul, MN?
> >
> > Thanks,
> > Ken Janusz, CPIM
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 26, 2002 1:48 PM
> >
> >
> > > We currently have positions available for Oracle Clinical
> > > specialists with leading pharmaceutical companies and CRO's
> > in
> > > NJ.
> > >
> > > Our associate's established relationship within the
> > > pharmaceutical industry is predicated upon 20 years of
> > providing
> > > career opportunities to Biostatisticians.  This association
> > to
> > > Knowlton Group is to the potential benefit of career minded
> > > Oracle Clinical professionals.
> > >
> > > We currently have full time (only) opportunities as;
> > individual
> > > contributors, project leaders, and managers/supervisors.(NJ
> > &
> > > Chicago).
> > >
> > > Even if you are not currently interested in a position
> > change,
> > > reply to this email in order to have future career options
> > > brought to your attention.
> > >
> > > Our involvement with clients and candidates is established
> > and
> > > long term.
> > >
> > > Bill Christison
> > >
> > > =
> > > Bill Christison
> > > Knowlton Group, LLC
> > > 845-258-5129
> > > www.knowltongroup.com
> > >
> > > __
> > > Do You Yahoo!?
> > > Yahoo! - Official partner of 2002 FIFA World Cup
> > > http://fifaworldcup.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Bill Christison
> > >   INET: [EMAIL PROTECTED]
> > >
> > > 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: [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.com
> > --
> > Author: KENNETH JANUSZ
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [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).
>
>
> =
> Bill Christison
> Knowlton Group, LLC
> 845-258-5129
> www.knowltongroup.com
>
> __
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bill Christison
>   INET: [EMAIL PROTECTED]
>
> 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: [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.com
-- 
Author: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

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: [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 

Re: the ora certified masters cert, yet again

[Rachel Carmichael]

doctors have to take more than a multiple choice test to be certified.

getting certified might be hard work.. but I had a developer who
decided he wanted to be a DBA so he went out and got his certification.
He studied for the tests, took them and passed. Give my choice I
wouldn't have allowed him to work on my development databases, let
alone production. He knew NOTHING about being a DBA.


--- ltiu <[EMAIL PROTECTED]> wrote:
> Work experience is better than certification but ...
> 
> Getting certified is hard work. Takes a lot of time and effort (not
> to 
> mention money). So it must be worth something. If only for a little
> bit. It 
> is definitely not worthless.
> 
> Work experience plus certification is the best combination.
> 
> Certification is no different from being a doctor. You need to pass
> exams to 
> be a doctor too (you need internship to go as well, of course).
> 
> As for naming famous Oracle authors, I don't think this is a valid
> gauge of 
> your capacity as a DBA. I know some people well versed in Computer 
> Engineering concepts (from 'great' authors) but can't code. They
> sound like 
> experts but can't deliver sh_t.
> 
> ltiu
> 
> On Wednesday 26 June 2002 15:23, you wrote:
> > This threads getting to be a lengthy one, and I might as well add
> my two
> > cents to it. I too come from the same school of thought. That you
> are OCP
> > certified holds no water with me. OK. So you are OCP Certified.That
> dont
> > impress me much.
> >
> > One of my first questions, when I am asked to conduct an interview,
> is ask
> > them to name some of the Oracle Gurus they have read about, to name
> some
> > helpful Oracle sites, or some great white papers. The answers,
> almost
> > always, tend to reflect the level of expertise. Jonathan Lewis,
> Steve
> > Adams, Cary Millsap, Craig Shallahamer, Anjo Kolk, Tom Kyte, Kevin
> Loney,
> > Rama Velupuri, Racheal Carmicheal, ..
> >
> > Sadly, my point of view differs from that of most recruiters. I
> know of an
> > OCP who, when told that the developers were running out of
> temporary
> > tablespace, put in a request with the SA to increase the disk space
> for
> > /tmp. I also know of a HR personnel who rejected my resume coz I
> had no 8i
> > experience. Sadly, my resume said 8.1.6, 8.1.7.
> >
> > Raj
> > Not an OCP Certified DBA
> >
> > "Whatever little I know, I owe it to my ignorance".
> >
> >
> >
> >
> >
> > Julia Phu
> >  recipients of
> > list ORACLE-L <[EMAIL PROTECTED]> tmail.com>  cc:
> > Sent by:Subject: Re: the
> ora
> > certified masters cert, yet again [EMAIL PROTECTED]
> >
> >
> > June 26, 2002
> > 05:22 PM
> > Please respond
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> > Sorry, I can't help being quiet.
> >
> > I've no respect for the OCP. I saw MANY people bought
> > the exams from many sources. These people memorize the
> > questions and answers prior the test day. Voila, they
> > pass the tests and still don't understand how to
> > install and configure the database.
> >
> > I learned it on my job and am still learning. I took
> > the 8i exam program and was EXTREMELY disappointed. I
> > learned nothing.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: ltiu
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

YO! JARED! has this gotten off-topic yet? since when is "picking on
Rachel" part of the on topic list???

--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Chris, feel blessed, she stays during all of mine and asks bizarre 
> questions :),
> 
> like:  If 2 control files are being updated at the same time and one
> is 
> on raid-5 and the other on raid 0+1, which one will be finished
> updating 
> first.
> 
> joe
> 
> 
> Grabowy, Chris wrote:
> 
> >Matt, she walked out in the middle of your presentation??  
> >
> >Your lucky.  She walked out of mine at the beginning, shaking her
> head.  Oh
> >well...
> >
> >-Original Message-
> >Sent: Wednesday, June 26, 2002 5:40 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >well, if so, I'll finally get to see you present and won't have to
> walk
> >out in the middle 
> >
> >
> >--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> >wrote:
> >  
> >
> >>Right now, I think Susan has me from 1-2, right after
> >>lunch, but I'm not sure. The OOUG web site is a 
> >>little sparse on details.
> >>
> >>
> >>
> >>
> >>Matt Adams - GE Appliances - [EMAIL PROTECTED]
> >>We have enough youth.
> >>How about a fountain of intelligence?
> >>
> >>-Original Message-
> >>Sent: Wednesday, June 26, 2002 4:50 PM
> >>To: Multiple recipients of list ORACLE-L
> >>
> >>
> >>But Mtt... you were always scheduled at either the
> >>same
> >>time *I* was presenting (trust me, I'd rather have gone to yours, I
> >>get
> >>stage fright) or when at LEAST 2 other presentations I wanted to
> see
> >>equally as much were there.
> >>
> >>Um, what time are you presenting at OOUG? My flight home is at 5, I
> >>have to leave around 2:30 or so
> >>
> >>
> >>
> >>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> >>wrote:
> >>
> >>
> >>>But Rachel, you never came to any of my 
> >>>presentations!  (in my best whiney voice)
> >>>
> >>>At least you'll get to see me present in July at OOUG.
> >>>
> >>>
> >>>Matt Adams - GE Appliances - [EMAIL PROTECTED]
> >>>We have enough youth.
> >>>How about a fountain of intelligence?
> >>>
> >>>-Original Message-
> >>>Sent: Wednesday, June 26, 2002 3:56 PM
> >>>To: Multiple recipients of list ORACLE-L
> >>>
> >>>
> >>>that's 'cause you present well and have knowledge
> >>>
> >>>or.. to quote one of my favorite shows:
> >>>
> >>>"he has much knowledge. we must build an altar and worship him"
> >>>
> >>>
> >>>:)
> >>>
> >>>
> >>>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> >>>wrote:
> >>>  
> >>>
> Actually, I had to miss this years (even though I was orginally
> schedule
> to give two presentations)  due to a medical situation.  I gave
> 
> 
> >>>four
> >>>  
> >>>
> the
> year
> before that.  
>  
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence? 
> 
>  
> -Original Message-
> Sent: Wednesday, June 26, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> 
> 
> >>to
> >>
> >>
> weed out
> the fluff.  If you were at IOUG this year, you should have
> 
> 
> >>noticed
> >>
> >>
> >>>a
> >>>  
> >>>
> significant reduction in the marketing fluff and more technical
> content.
> Yes, some showmanship is necessary when giving a presentation,
> 
> 
> >>but
> >>
> >>
> the
> content has to be there.
> 
>  
> 
> Many people on this forum have submitted presentations to my
> 
> 
> >>track
> >>
> >>
> and then
> complained that they were not accepted.  Let me give you some
> concrete
> numbers.  This year, we received over 400 abstracts for the DBA
> 
> 
> >>>track
> >>>  
> >>>
> alone
> and accepted only 80.  If one slips through the cracks, it won't
> 
> 
> >>a
> >>
> >>
> second
> time.  Believe me when I say that 2002 was the best
> 
> 
> >>>content-organized
> >>>  
> >>>
> IOUG.
> 
> 
>  
> 
> Further comments?  Submit an abstract for 2003 and find out!!!
> 
>  
> 
> Thank You
> 
>  
> 
> Stephen P. Karniotis
> 
> Product Architect
> 
> Compuware Corporation
> 
> Direct:   (248) 865-4350
> 
> Mobile:  (248) 408-2918
> 
=== message truncated ===


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: the ora certified masters cert, yet again

[Rachel Carmichael]

Greg,

nope, but Stephen Karniotis might, as he is directly involved with IOUG
and the conference itself. I go as a presenter or registrant only. 

Rachel
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> Of all the people who attend the conference, do you happen to know
> how many
> actually go to the trouble of voting for best presentation?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

this goes back to a thread from maybe a year ago... what sort of
questions do you ask on interviews.

I may ask other questions based on what we are specifically looking for
or building off something the interviewee says but I always include the
following questions:

1) what was your worst nightmare as a DBA and how did you resolve it
2) what are you most proud of doing 
3) how do you learn new things about Oracle

gee, not ONE multiple choice question among them!

--- [EMAIL PROTECTED] wrote:
> This threads getting to be a lengthy one, and I might as well add my
> two
> cents to it. I too come from the same school of thought. That you are
> OCP
> certified holds no water with me. OK. So you are OCP Certified.That
> dont
> impress me much.
> 
> One of my first questions, when I am asked to conduct an interview,
> is ask
> them to name some of the Oracle Gurus they have read about, to name
> some
> helpful Oracle sites, or some great white papers. The answers, almost
> always, tend to reflect the level of expertise. Jonathan Lewis, Steve
> Adams, Cary Millsap, Craig Shallahamer, Anjo Kolk, Tom Kyte, Kevin
> Loney,
> Rama Velupuri, Racheal Carmicheal, ..
> 
> Sadly, my point of view differs from that of most recruiters. I know
> of an
> OCP who, when told that the developers were running out of temporary
> tablespace, put in a request with the SA to increase the disk space
> for
> /tmp. I also know of a HR personnel who rejected my resume coz I had
> no 8i
> experience. Sadly, my resume said 8.1.6, 8.1.7.
> 
> Raj
> Not an OCP Certified DBA
> 
> "Whatever little I know, I owe it to my ignorance".
> 
> 
> 
> 
>  
>  
> Julia Phu
>  
>  recipients of list ORACLE-L <[EMAIL PROTECTED]>
> tmail.com>  cc:  
>  
> Sent by:Subject: Re: the ora
> certified masters cert, yet again 
> [EMAIL PROTECTED] 
>  
>  
>  
>  
>  
> June 26, 2002
>  
> 05:22 PM 
>  
> Please respond   
>  
> to ORACLE-L  
>  
>  
>  
>  
>  
> 
> 
> 
> 
> Sorry, I can't help being quiet.
> 
> I've no respect for the OCP. I saw MANY people bought
> the exams from many sources. These people memorize the
> questions and answers prior the test day. Voila, they
> pass the tests and still don't understand how to
> install and configure the database.
> 
> I learned it on my job and am still learning. I took
> the 8i exam program and was EXTREMELY disappointed. I
> learned nothing.
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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 me

RE: conferences - IOUG vs OOW

[Rachel Carmichael]

Bill, 

Wait'll you see the agenda for the September meeting. And I've almost
got December's filled.. although I *am* looking for DBA presentations,
anyone interested (please note NYOUG does NOT pay travel expenses) send
me a note off-line with an abstract.

Come to the DBA SIG in two weeks -- since Cary's company Hotsos is
giving a clinic in NYC, we've got two of his partners coming to give a
presentation on using the 10046 trace files.  

Rachel

--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> thanks to both of you, Rachel and Stephen . . . clears it up for me.
> 
> btw I do attend NYOUG meeings (except the last one - couldn't bear
> the
> thought of a NY Harbor cruise in the lousy weather, rocking to and
> fro) and
> do find them pretty interesting - and some nifty giveaway's, too, are
> always
> nice for the kids :-)
> 
> -bill
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 5:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> my preference when I have to choose is IOUG over OOW 
> 
> OOW tends to have a lot more marketing/Oracle employee (so it feels
> like marketing) presentations
> 
> 
> --- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> > Having never been to either and wanting to plan for one, am I to
> > infer from
> > some of this discussion that for real content (as opposed to
> > marketing
> > fluff), THE conference to attend would be IOUGLive, as opposed to
> > Oracle
> > Open World?  
> > 
> > -bill
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Magaliff, Bill
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> 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: [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.com
> -- 
> Author: Magaliff, Bill
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

oh yeah that would be GREAT

I met Kevin Loney because I'd seen him present in '94 at IOUW. I went
home, applied what he had said in his presentation, and a few months
later, after beginning to read the 7.3 DBA Handbook, I wrote to him to
say THANK YOU


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I'd like to see a vote conducted 6 months after the conference. 'Of
> all the
> presentations and papers available at the conference, which are the 5
> that
> you have found most valuable and useful in your work and/or career?'
> 
> The highest compliment I was ever paid was 6 months after my first UG
> presentation. A fellow DBA came up and said that he had returned to
> work
> after the conference and used my paper and presentation to audit
> their
> backup & recovery process, identify the outstanding issues and
> implement a
> new process that they tested (not in production) and it worked better
> than
> their old system. 
> 
> Daniel W. Fink
> Sr. Oracle DBA
> MICROMEDEX
> 303.486.6456
> 
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Rachel,
> 
> Of all the people who attend the conference, do you happen to know
> how many
> actually go to the trouble of voting for best presentation?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
> 
> 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: [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.com
> -- 
> Author: Fink, Dan
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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: RMAN restore hung?

[Reardon, Bruce (CALBBAY)]

Dennis,

What does v$session_wait say for the RMAN sessions (on each database - if using a 
catalog)
Can you connect to the catalog yourself?
Can you connnect nomoun to the target?
I'm sure you've looked but anything in cdump, bdump, udump dir's?

Has your OS process been suspended (not knowing if that can be done on Tru64)?

Bruce Reardon

-Original Message-
Sent: Thursday, 27 June 2002 2:39

I am performing a test restore with RMAN on a test system, and for the past
hour it appears to be hung on the restore. The only detectable activity is
the control file seems to be getting updated. It restored several files, but
is stuck on one. Has anyone hit anything like this? Anything to check for?
Obviously this wouldn't be a good scenario in a real recovery.
Oracle 8.1.6
Compaq Tru64
Restoring a 4-gig. database.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

one last comment before Jared makes me take this to the off-topic list

I never walked out on one of Matt's presentations, I never got to SEE
one of Matt's presentations. He and I will be presenting to the Ohio
Users Group in 2 weeks, I will be able to see his ENTIRE presentation
before I have to leave for the airport.

Not only did I sit through your entire presentation, I even applauded
at the end.

watcha you back, youngster :)

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> Matt, she walked out in the middle of your presentation??  
> 
> Your lucky.  She walked out of mine at the beginning, shaking her
> head.  Oh
> well...
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 5:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> well, if so, I'll finally get to see you present and won't have to
> walk
> out in the middle 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > Right now, I think Susan has me from 1-2, right after
> > lunch, but I'm not sure. The OOUG web site is a 
> > little sparse on details.
> > 
> > 
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 4:50 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > But Mtt... you were always scheduled at either the
> > same
> > time *I* was presenting (trust me, I'd rather have gone to yours, I
> > get
> > stage fright) or when at LEAST 2 other presentations I wanted to
> see
> > equally as much were there.
> > 
> > Um, what time are you presenting at OOUG? My flight home is at 5, I
> > have to leave around 2:30 or so
> > 
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > But Rachel, you never came to any of my 
> > > presentations!  (in my best whiney voice)
> > > 
> > > At least you'll get to see me present in July at OOUG.
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence?
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 3:56 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > that's 'cause you present well and have knowledge
> > > 
> > > or.. to quote one of my favorite shows:
> > > 
> > > "he has much knowledge. we must build an altar and worship him"
> > > 
> > > 
> > > :)
> > > 
> > > 
> > > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > > wrote:
> > > > Actually, I had to miss this years (even though I was orginally
> > > > schedule
> > > > to give two presentations)  due to a medical situation.  I gave
> > > four
> > > > the
> > > > year
> > > > before that.  
> > > >  
> > > > 
> > > > 
> > > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > > We have enough youth.
> > > > How about a fountain of intelligence? 
> > > > 
> > > >  
> > > > -Original Message-
> > > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > 
> > > > 
> > > > 
> > > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> > to
> > > > weed out
> > > > the fluff.  If you were at IOUG this year, you should have
> > noticed
> > > a
> > > > significant reduction in the marketing fluff and more technical
> > > > content.
> > > > Yes, some showmanship is necessary when giving a presentation,
> > but
> > > > the
> > > > content has to be there.
> > > > 
> > > >  
> > > > 
> > > > Many people on this forum have submitted presentations to my
> > track
> > > > and then
> > > > complained that they were not accepted.  Let me give you some
> > > > concrete
> > > > numbers.  This year, we received over 400 abstracts for the DBA
> > > track
> > > > alone
> > > > and accepted only 80.  If one slips through the cracks, it
> won't
> > a
> > > > second
> > > > time.  Believe me when I say that 2002 was the best
> > > content-organized
> > > > IOUG.
> > > > 
> > > > 
> > > >  
> > > > 
> > > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > > 
> > > >  
> > > > 
> > > > Thank You
> > > > 
> > > >  
> > > > 
> > > > Stephen P. Karniotis
> > > > 
> > > > Product Architect
> > > > 
> > > > Compuware Corporation
> > > > 
> > > > Direct:   (248) 865-4350
> > > > 
> > > > Mobile:  (248) 408-2918
> > > > 
> > > > Email:  [EMAIL PROTECTED]
> > > > 
> > > > Web:www.compuware.com
> > > > 
> > > >  
> > > > 
> > > > -Original Message-
> > > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > 
> > > >  
> > > > 
> > > > unfortunately, I've seen this to be true at 
> > > > many conferences, including the IOUG 
> > > > and SEOUC. 
> > > > 
> > > >  
> > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > > > "Doing linear scans over an as

RE: the ora certified masters cert, yet again

[Rachel Carmichael]

ahem last day at OOW last year, DBA panel consisting of Ari Kaplan,
Cary Millsap, Kevin Loney, Grant McAllister (amazon)

and there I am, sitting in the front row and knitting. Knitting keeps
my hands busy but doesn't interfere with my being a smart aleck heckler
 :)

Besides, in YOUR presentation, I was too busy taking notes and saying
"damn, I didn't know that, gotta play with that when I get home" to
knit 


--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> You're both lucky! She stayed all the way through mine and never once
> broke
> out her knitting!
> 
> Daniel W. Fink
> Sr. Oracle DBA
> MICROMEDEX
> 303.486.6456
> 
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:03 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Matt, she walked out in the middle of your presentation??  
> 
> Your lucky.  She walked out of mine at the beginning, shaking her
> head.  Oh
> well...
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 5:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> well, if so, I'll finally get to see you present and won't have to
> walk
> out in the middle 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > Right now, I think Susan has me from 1-2, right after
> > lunch, but I'm not sure. The OOUG web site is a 
> > little sparse on details.
> > 
> > 
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 4:50 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > But Mtt... you were always scheduled at either the
> > same
> > time *I* was presenting (trust me, I'd rather have gone to yours, I
> > get
> > stage fright) or when at LEAST 2 other presentations I wanted to
> see
> > equally as much were there.
> > 
> > Um, what time are you presenting at OOUG? My flight home is at 5, I
> > have to leave around 2:30 or so
> > 
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > But Rachel, you never came to any of my 
> > > presentations!  (in my best whiney voice)
> > > 
> > > At least you'll get to see me present in July at OOUG.
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence?
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 3:56 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > that's 'cause you present well and have knowledge
> > > 
> > > or.. to quote one of my favorite shows:
> > > 
> > > "he has much knowledge. we must build an altar and worship him"
> > > 
> > > 
> > > :)
> > > 
> > > 
> > > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > > wrote:
> > > > Actually, I had to miss this years (even though I was orginally
> > > > schedule
> > > > to give two presentations)  due to a medical situation.  I gave
> > > four
> > > > the
> > > > year
> > > > before that.  
> > > >  
> > > > 
> > > > 
> > > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > > We have enough youth.
> > > > How about a fountain of intelligence? 
> > > > 
> > > >  
> > > > -Original Message-
> > > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > 
> > > > 
> > > > 
> > > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> > to
> > > > weed out
> > > > the fluff.  If you were at IOUG this year, you should have
> > noticed
> > > a
> > > > significant reduction in the marketing fluff and more technical
> > > > content.
> > > > Yes, some showmanship is necessary when giving a presentation,
> > but
> > > > the
> > > > content has to be there.
> > > > 
> > > >  
> > > > 
> > > > Many people on this forum have submitted presentations to my
> > track
> > > > and then
> > > > complained that they were not accepted.  Let me give you some
> > > > concrete
> > > > numbers.  This year, we received over 400 abstracts for the DBA
> > > track
> > > > alone
> > > > and accepted only 80.  If one slips through the cracks, it
> won't
> > a
> > > > second
> > > > time.  Believe me when I say that 2002 was the best
> > > content-organized
> > > > IOUG.
> > > > 
> > > > 
> > > >  
> > > > 
> > > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > > 
> > > >  
> > > > 
> > > > Thank You
> > > > 
> > > >  
> > > > 
> > > > Stephen P. Karniotis
> > > > 
> > > > Product Architect
> > > > 
> > > > Compuware Corporation
> > > > 
> > > > Direct:   (248) 865-4350
> > > > 
> > > > Mobile:  (248) 408-2918
> > > > 
> > > > Email:  [EMAIL PROTECTED]
> > > > 
> > > > Web:www.compuware.com
> > > > 
> > > >  
> > > > 
> > > > -Original Message-
> > > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > > To: Multiple recipients of list O

RE: Deleting large table and the correct log buffer size

[Deshpande, Kirti]

Well, that doesn't help much... log_buffer size looks okay to me. 

If indexes on this table are not required, I would consider dropping them
and re-creating after the deletion is done. 

- Kirti 

-Original Message-
Sent: Wednesday, June 26, 2002 3:35 PM
To: Multiple recipients of list ORACLE-L



Hi kirti,
My responses are embedded in your message.

   Thanks

Vasu



"Deshpande, Kirti" wrote:

> Are the disks housing redo logs contain other 'hot' files? Are these disks
> busy with other tasks (than writing redo logs).

  No. Though there are db files in its disks, they are not that active.
More over, the server where I perform this test is totally quiet.


> Are you committing too
> often?

No. There is only one commit after the delete statement.


> How many log switches are taking place?

 10 or 11 switches


> What is the size of the redo
> log file?

 100MB


> May be increasing it may help.
>
> What is the redo size per commit?
> Use this query to find out RSPC:
> select r.value / decode (c.value, 0, 1, c.value) RSPC
>  from v$sysstat r, v$sysstat c
>  where r.name = 'redo size'
>and c.name = 'user commits';
> You can use RSPC to size log buffer by multiplying it by number of user
> commits per second.
>

1104361.8003

>
> HTH,
>
> - Kirti
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 11:49 AM
> To: Multiple recipients of list ORACLE-L
>
> Hello Gurus,
>   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> the process of conversion. I have a problem in deleting a large number
> of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> complete and sometimes hogs system. It is a simple delete statement,
> delete all rows. We do not want to use truncate statement. I try to find
> why it is taking so much time by checking the wait events. The session
> event wait statistics is provided below.
>
> SIDEVENT
> TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
>

> --
>
> AVERAGE_WAIT  MAX_WAIT
> --
> 27latch
> free
> 1010 20
>2 2
>
> 27log buffer
> space
> 298   271  29267
>   98.2114094   104
>
> 27log file switch
> completion   11
> 10   1069
>   97.1818182   103
>
> 27log file
> sync
> 3 2221
>   73.667   103
>
> 27db file sequential
> read3222
> 0   7695
>   2.38826816   589
>
> 27db file scattered
> read  271
> 0493
>   1.81918819   236
>
> 27file
> open
> 4 0  0
>0 0
>
>The log_buffer_space wait event looks like is the culprit with
> total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> of a second). Are these normal values for this wait event? The log
> buffer init param is set to 20MB. To set up the init params, we took the
> advice of the consultant DBA who worked for a short time (6 months) to
> help us to set up servers. While I was going through the DBA hand books,
> ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> it clearly says that setting higher value will cause trouble. He
> recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> for log_buffer_space just doubles.
>
>Can you please advice me what should be the correct size for log
> buffer?
>Do you see any problem with wait stats provided above?
>
>   If you need further details, let me know please.
>
>Thanks
>
> Vasu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> 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: [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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of ma

RE: Sql query

[Larry Elkins]

Greg,

When the situation is appropriate, and I don't want a correlated approach, I
will typically use the hash aj as illustrated by your second example, the
NOT IN using a hash aj. That's my preference, when correlation is not
appropriate. And I work with some DB's where always_anti_join is set to hash
and don't even have to use the HASH_AJ hint, *if* the conditions for using a
hash aj are met.

And that's where the beauty of the first approach comes in. Suppose the
query is such that you *don't* want it correlated, and the conditions for
using a hash aj *can't* be met, you can use the first approach, and force a
hash join (outer) if required. You will often times get similar performance
as the hash aj. For example, if you forced a hash join via hints in your
first example, the OJNK approach (outer join null key, pronounced "O Junk",
no need for a GNU discussion) might provide very similar results as the hash
aj approach. And that's when I use the OJNK approach, when I want a hash
type of join, but the conditions for using a hash aj can't be met. That is
its real strength. I avoid the OJNK approach otherwise simply because some
will be confused by the coding, not realizing an anti-join is being
performed. And yes, you can include comments saying so, but some folks will
still mistake its purpose ;-)

Anyway, here is an example similar to yours, but I forced a hash join when
using the OJNK approach. But I'm with you, I lean towards using the HASH_AJ,
when appropriate, over the OJNK approach, but mileage varies, not one size
fits all, fill in your favorite cliché here. Just wanted to point out that
the OJNK approach can be a *savior* when the conditions for a hash aj being
used can't be met and a correlated approach is the wrong way to go. The
numbers:

select count(*)
from code_master
where code not in (select /*+ HASH_AJ */ code from code_detail)

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --  --

Parse1  0.03   0.03  0  0  0
0
Execute  2  0.00   0.00  0  0  0
0
Fetch1  2.33  53.23   5855859144
1
--- --   -- -- -- --  --

total4  2.36  53.26   5855859144
1

Rows Row Source Operation
---  ---
  1  SORT AGGREGATE
100   HASH JOIN ANTI
 10INDEX FAST FULL SCAN (object id 67350)
 299600VIEW VW_NSO_1
 299600 INDEX FAST FULL SCAN (object id 69013)




select /*+ ORDERED USE_HASH(cd) */ count(*)
from code_master cm, code_detail cd
where cm.code = cd.code (+)
and cd.code is null

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --  --

Parse1  0.03   0.03  0  0  0
0
Execute  2  0.00   0.00  0  0  0
0
Fetch1  2.39  57.47   5855859144
1
--- --   -- -- -- --  --

total4  2.42  57.50   5855859144
1

Rows Row Source Operation
---  ---
  1  SORT AGGREGATE
100   FILTER
 299700HASH JOIN OUTER
 10 INDEX FAST FULL SCAN (object id 67350)
 299600 INDEX FAST FULL SCAN (object id 69013)

And you don't want to see the numbers for the correlated nested loops
approach, more than an hour.

Okay, OJNK a little slower in this case, but if a hash aj *couldn't* be
used, and a correlated approach was *not* the way to go, the OJNK approach
can save the day and be a nice alternative if you utilize a hash join.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
Sent: Wednesday, June 26, 2002 5:44 PM
To: Multiple recipients of list ORACLE-L


2 versions of SQL + TKPROF excerpts

8.1.6,  Solaris


SQL version #1


select count(*)
  from customers c
 , sales s
 where c.customer_id = s.customer_id(+)
   and s.customer_id is null

   count  cpu elapsed disk  query current rows

total 4  7.337.361 200352   41

RowsRow Source Operation
--- 
1   SORT AGGREGATE
99105FILTER
169049NESTED LOOPS OUTER
10 INDEX FAST FULL SCAN (object id 22199)
69944  INDEX RANGE SCAN (object id 22232)


SQL version #2


select count(*)
  from customers c
 where c.customer_id not in (
 select /*+ hash_aj */
s.customer_id
   from sales s )

   count   cpu elaps

RE: sqlplus: Permission denied

[Deshpande, Kirti]

Just few more basic questions.. sorry. 
Are there any ORA- errors? 
Any OS error numbers? 
What permission mask is set for the shared memory segments of this database?


- Kirti

-Original Message-
Sent: Wednesday, June 26, 2002 7:34 PM
To: Multiple recipients of list ORACLE-L


Hello,

Thanks. for the tip.

No, actually I'm smarter than most Unix people that's why I posted this 
thread on an Oracle email list.

The permissions are 775 for the sqlplus binary.

I own the whole ORA_HOME directory and everything under it.

I am part of the osdba and osoper groups.

Thanks.

ltiu

On Wednesday 26 June 2002 16:42, you wrote:
> Perhaps this question should be posted on a unix group since these are
unix
> file permission errors 8-)  Try this, just for grins:
>
> ls -l /DB/O92iBase/O9iEE/bin/sqlplus
>
> See what the owner, group, and permissions tell you.  If you are not sure
> what the output tells you, consult your unix system administrator.
>
> Kevin Kennedy
> First Point Energy Corporation
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
>
> Could someone help me decipher these?
>
> 1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"
>
> 2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission
> denied"
>
> Thanks.
>
> ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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: sqlplus: Permission denied

[Deshpande, Kirti]

Also, please re-check permissions for 'oracle' binary in $ORACLE_HOME/bin
(those should be -rwsr-s--x) 

- Kirti 

-Original Message-
Sent: Wednesday, June 26, 2002 7:29 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Just few more basic questions.. sorry. 
Are there any ORA- errors? 
Any OS error numbers? 
What permission mask is set for the shared memory segments of this database?


- Kirti

-Original Message-
Sent: Wednesday, June 26, 2002 7:34 PM
To: Multiple recipients of list ORACLE-L


Hello,

Thanks. for the tip.

No, actually I'm smarter than most Unix people that's why I posted this 
thread on an Oracle email list.

The permissions are 775 for the sqlplus binary.

I own the whole ORA_HOME directory and everything under it.

I am part of the osdba and osoper groups.

Thanks.

ltiu

On Wednesday 26 June 2002 16:42, you wrote:
> Perhaps this question should be posted on a unix group since these are
unix
> file permission errors 8-)  Try this, just for grins:
>
> ls -l /DB/O92iBase/O9iEE/bin/sqlplus
>
> See what the owner, group, and permissions tell you.  If you are not sure
> what the output tells you, consult your unix system administrator.
>
> Kevin Kennedy
> First Point Energy Corporation
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
>
> Could someone help me decipher these?
>
> 1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"
>
> 2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission
> denied"
>
> Thanks.
>
> ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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: sqlplus: Permission denied

[ltiu]

Hello,

Thanks. for the tip.

No, actually I'm smarter than most Unix people that's why I posted this 
thread on an Oracle email list.

The permissions are 775 for the sqlplus binary.

I own the whole ORA_HOME directory and everything under it.

I am part of the osdba and osoper groups.

Thanks.

ltiu

On Wednesday 26 June 2002 16:42, you wrote:
> Perhaps this question should be posted on a unix group since these are unix
> file permission errors 8-)  Try this, just for grins:
>
> ls -l /DB/O92iBase/O9iEE/bin/sqlplus
>
> See what the owner, group, and permissions tell you.  If you are not sure
> what the output tells you, consult your unix system administrator.
>
> Kevin Kennedy
> First Point Energy Corporation
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
>
> Could someone help me decipher these?
>
> 1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"
>
> 2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission
> denied"
>
> Thanks.
>
> ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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: report showing free space per tablespace over time

[Jack Silvey]

Kevin,

thanks for the input. Gotta have space over time.

I toyed with the idea of putting this in a webpage so
people would look instead of ask too - just haven't
had time yet. 

what did you use for your graphing tool? 

And you can see how I assigned the dates to the column
headers - kind of clunky, but works. Do you have
another take on how to do this?

thx,

jack




--- kkennedy <[EMAIL PROTECTED]> wrote:
> Hi Jack,
> 
> That looks like a good tool.  Personally, for about
> the last 5 years, I've been using an adaptation of
> the command center database described in the Oracle
> 7(& later) DBA Handbook using cron as my scheduler. 
> The neatest implementation I did was several jobs
> back where I also collected volume space
> information.  Then, I created a web page that
> displayed a graph of volume space, tablespace, and
> free space in living color -- this was in response
> to a PHB that kept asking for a database growth
> projection every few weeks so that he could plan the
> following years hardware purchases.  Once I gave him
> the URL, he quit asking.  He never got the purchases
> right, but that's what happens when you project the
> future by looking in the rear view mirror.
> 
> On my last job, I told my PHB that I wanted to
> implement the CC database right out of the gate.  He
> told me we didn't need it.  I implemented it anyway
> without telling him.  A few months later, he figured
> out why we needed it.
> 
> I can't imagine maintaining a database without
> having an ongoing growth history.
> 
> Kevin Kennedy
> First Point Energy Corporation 
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 1:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Listers,
> 
> Ever been asked how much free space you have in the
> tablespaces over time? I wrote a tool that tracks
> and
> reports on free space per tablespace over time and
> thought I would share it.
> 
> It consists of a simple stored procedure that stores
> values in a holding table and a report that will
> tell
> you how much each tablespace had over the past week
> (you can change the coverage of this report.)
> 
> 1) Here is the stored procedure:
> 
> CREATE OR REPLACE PROCEDURE 
> tablespace_proc AS
> 
>   v_errmsg varchar2(100);
>   v_errcode varchar2(100);
>
> BEGIN
> 
>   delete dbmon.dbmon_tablespace_stats
>   where trunc(record_date) = trunc(sysdate);
> 
> 
> INSERT INTO dbmon.dbmon_tablespace_stats
>   
>   (tablespace_name, 
>   total_space, 
>   megs_free, 
>   max_extent, 
>   autoextend,
>   record_date)
> 
> SELECT
>   fs.tablespace_name,
>   round(df.total_bytes/1024/1024,0),
>   round(fs.bytes_free/1024/1024,0),
>   round(fs.max_bytes/1024/1024,0),
>   decode(a.tablespace_name,null,'No','Yes'),
>   sysdate
> FROM
>   (SELECT
>   tablespace_name,
>   SUM(bytes) bytes_free,
>   max(bytes) max_bytes
>   FROM
>   dba_free_space fs
>   GROUP BY
>   tablespace_name) fs,
>   (SELECT
>   tablespace_name,
>   sum(bytes) total_bytes
>   FROM
>   dba_data_files
>   GROUP BY 
>   tablespace_name) df,
>   (SELECT DISTINCT
>   tablespace_name
>   FROM
>   dba_data_files
>   WHERE
>   autoextensible = 'YES') a,
>   (select tablespace_name
>   from dba_tablespaces) ts
> WHERE
>   df.tablespace_name = fs.tablespace_name(+)
> AND
>   df.tablespace_name = a.tablespace_name(+)
> AND   
>   df.tablespace_name = ts.tablespace_name;
> 
> commit;
> 
> exception
> 
>   when others then
>   
>   v_errmsg := substr(SQLERRM,1,100);
>   v_errcode := SQLCODE;
> 
>   insert into dbmon_activity_log
>   (activity_date,
>   activity_desc,
>   procedure_name,
>   error_code,
>   error_msg,
>   error_date)
>   values
>   (sysdate,
>   'tablespace_proc',
>   'tablespace_proc',
>   v_errcode,
>   v_errmsg,
>   sysdate);
> commit;
> 
> end;
> /
> 
> 
> 
> 2) Here is the code to submit it to the job
> scheduler
> (every day at 5AM):
> 
> variable jobno number
> 
> exec sys.dbms_job.submit(job=>:jobno, what=>'begin
> dbmon.dbmon_tablespace_proc;end;',
>
next_date=>trunc(sysdate+1)+5/24,interval=>'trunc(sysdate+1)+5/24');
> 
> 3)  and here is the report:
> 
> 
> @save_sqlplus_settings
> 
> set term off
> 
> set head off
> 
> spool temp.sql 
> 
> select 'col c'||rownum ||' for 999,999,990 head "'||
> 
> to_char(sysdate+1-rownum,'dd-mon')||'"' 
> from dba_tablespaces where rownum<8; 
> 
> select 'compute sum of c'||rownum ||' on report'
> from dba_tablespaces where rownum<8; 
> 
> select 'break on report' from dual; 
> 
> spool off 
> 
> @temp.sql 
> 
> exec dbmon.dbmon_tablespace_proc;
> 
> set term on
> set

Re: the ora certified masters cert, yet again

[Joe Testa]

Excellent point.

joe


Deshpande, Kirti wrote:

>?? And then Gaja (Mr. Raid) takes over the presentation ;-))
>
>- Kirti
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 5:38 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Chris, feel blessed, she stays during all of mine and asks bizarre 
>questions :),
>
>like:  If 2 control files are being updated at the same time and one is 
>on raid-5 and the other on raid 0+1, which one will be finished updating 
>first.
>
>joe
>
>
>Grabowy, Chris wrote:
>
>  
>
>>Matt, she walked out in the middle of your presentation??  
>>
>>Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
>>well...
>>
>>-Original Message-
>>Sent: Wednesday, June 26, 2002 5:40 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>well, if so, I'll finally get to see you present and won't have to walk
>>out in the middle 
>>
>>
>>
>>

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

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: [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: the ora certified masters cert, yet again

[Orr, Steve]

> Getting certified is hard work. Takes a lot of time and effort...
I'd say it's more like "busy work."

Ever move to another state and have to take another test for your drivers
license? Even though you have been driving for years you may want to study
for the test because the wording is strange and they ask stupid,
off-the-wall questions that are covered on some dumb study sheet. It's
strange having to take time to study for something that you already know how
to do. 

Whine, whine, whine...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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: [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).

DB2 to Oracle

[Steve Johnson]

Hello!

Some had already asked this question. Please advice me
here.

How to import 350 GB from DB2 to Oracle quickly and
what kind of tools are out there to facilitate this
process.

Please help!!



=
Thank You.

Best Regards,
Steve Johnson

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Johnson
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Deshpande, Kirti]

?? And then Gaja (Mr. Raid) takes over the presentation ;-))

- Kirti

-Original Message-
Sent: Wednesday, June 26, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L


Chris, feel blessed, she stays during all of mine and asks bizarre 
questions :),

like:  If 2 control files are being updated at the same time and one is 
on raid-5 and the other on raid 0+1, which one will be finished updating 
first.

joe


Grabowy, Chris wrote:

>Matt, she walked out in the middle of your presentation??  
>
>Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
>well...
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 5:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>well, if so, I'll finally get to see you present and won't have to walk
>out in the middle 
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Jesse W. Asher]

I don't understand the large number of positions coming out that require 
a CURRENT Secret or Top Secret clearance.  How can all these positions 
be filled unless these company/entities start footing the bill for 
people getting the clearances?!?

Johnson, Michael wrote:

>That is not my understanding.
>
>FWIW.  Mike
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 1:35 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Actually no one who has been holds any SCI tickets can admit to doing so :)
>One can say you have been the subject of a Special Backgroud Investigation,
>and Extensive Background Investigation, a Full Field Investigation even
>though 99. times out of 100 these investigations are done for just such
>access.
>
>Ian MacGregor
>Stanford Linear Accelerator Center
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 9:24 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I suspect that this position will be at Wright-Patterson Air Force base.
>
>OraStaff wrote:
>  
>
>>Position: Oracle DBA with Top Secret SCI Clearance
>>  (Please do not send your resume unless you have the required
>>
>>

-- 
Jesse W. Asher

"They that can give up essential liberty to purchase a little temporary
safety, deserve neither liberty or safety."  - Benjamin Franklin



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

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: [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: sqlplus: Permission denied

[ltiu]

Hello,

Thanks for your tip.

Permissions are 775 for the sqlplus binary executable.

I own the sqlplus binaries. In fact I own the whole ORA_HOME.

I am also the member of the osdba and osoper groups.

The ORA_HOME partition is mounted with the exec flag, this means I can 
execute binaries in this partition.

Linux 2.4.18 with glibc-2.2.

Anymore tips?

Thanks.

ltiu


On Wednesday 26 June 2002 15:19, you wrote:
> Look at the file permission for sqlplus file.   ls -ltr on UNIX.  You
> probably are not listed as owner, group or public with proper permissions.
>
> -Original Message-
> From: ltiu [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 6:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: sqlplus: Permission denied
>
>
> Hello,
>
> Could someone help me decipher these?
>
> 1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"
>
> 2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission
> denied"
>
> Thanks.
>
> ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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: conferences - IOUG vs OOW

[Deshpande, Kirti]

I might add that the Oracle Conferences on GeekCruise are very good too. A
lot of tech talk takes place. I was on one last month with Cary Millsap,
Dave Ensor, Ian Abramson and Don Burleson. I wouldn't mind attending more of
such small but highly technical gatherings. At least I have convinced my
boss that there is a lot of learning on the 'big boat'. 

- Kirti 

-Original Message-
Sent: Wednesday, June 26, 2002 5:03 PM
To: Multiple recipients of list ORACLE-L


thanks to both of you, Rachel and Stephen . . . clears it up for me.

btw I do attend NYOUG meeings (except the last one - couldn't bear the
thought of a NY Harbor cruise in the lousy weather, rocking to and fro) and
do find them pretty interesting - and some nifty giveaway's, too, are always
nice for the kids :-)

-bill

-Original Message-
Sent: Wednesday, June 26, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L


my preference when I have to choose is IOUG over OOW 

OOW tends to have a lot more marketing/Oracle employee (so it feels
like marketing) presentations


--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> Having never been to either and wanting to plan for one, am I to
> infer from
> some of this discussion that for real content (as opposed to
> marketing
> fluff), THE conference to attend would be IOUGLive, as opposed to
> Oracle
> Open World?  
> 
> -bill
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Magaliff, Bill
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [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: MTS performance is too bad.

[Johnson, Michael]

Everything I have seen from experience
tells me to avoid using MTS if you can !

FWIW.

Mike

-Original Message-
Sent: Wednesday, June 26, 2002 1:06 PM
To: Multiple recipients of list ORACLE-L


Change back to dedicated servers.

Jared





"Bunyamin Karadeniz" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:MTS performance is too bad.


I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is 
too bad. 
I have 800 MB of shared pool and not setted large_pool_size. 
50 dispathers, 100 processes and 750 max processes. 
 
What can I do ?  Have you got an idea. How can I check the mts 
performance?
 
Bunyamin 


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

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: [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.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

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: [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: Oracle Performance Tuning steps

[Johnson, Michael]

  
For  a 24 X 7 system I would incorporate a hot 
backup strategy
which can be executed without 
taking the system down and
allows for a point in time 
recovery.    There are many scripts
floating around you could "borrow" to set this 
up.
 
Your performance issue is going 
to require some time to
understand and solve.   it cannot be answered 
in a paragraph.
Consider buying 
 Gaja Krishna Vaidyanatha and 
Kirti Deshpande's book "Oracle Performance
Tuning 101" as it has been a big help to me. 
Other things you might find helpful would be 
www.hotsos.com which goes into great detail on the 
10046 event trace and they also have an excellent 
clinic I just went too.
Good Luck and Peace !
Mike

  -Original Message-From: Chetan 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 3:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Performance Tuning steps
  Hi guys ,
  Need some help. Actually we are looking here at a Oracle 8.1.7 db on 
  HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of 
  the appln is running extremely slow. I can not figure what might be the 
  problem. Wanted to track this down asap.
  Here is some information about the db.
  Database size - 20GB
  Optimizer - CHOOSE
  Disk Structure - RAID 1+0
  No. of processors - 4
  Block Size - 8K
  Archivelog mode : ARCHIVELOG
  Please tell me what should be the ideal way I should try to trace the 
  problem. I thought of running UTLBSTAT/UTLESTAT or 
  STATSPACK and asked the user to run that part of the appln. 
  Has anybody worked with STATSPACK before ?
  Can anybody tell me what should accurate and fastest way to hunt down 
  the problem ? I think its something to do with indexes or changes in the 
  queries.
  Also can someone tell me the ideal backup strategy for this 
  database considering the fact that it's a 24x7 system.
  Thanks in advance .
  Chetan Chindarkar
  
  
  Do You Yahoo!?Sign-up 
  for Video Highlights of 2002 FIFA World Cup

bash: ./genclntsh: bad interpreter: Permission denied

[ltiu]

Hello,

Could someone help me decipher the following:

"sh: ./genclntsh: bad interpreter: Permission denied"

Thanks.

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

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: [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: sqlplus: Permission denied

[kkennedy]

Perhaps this question should be posted on a unix group since these are unix file 
permission errors 8-)  Try this, just for grins:

ls -l /DB/O92iBase/O9iEE/bin/sqlplus

See what the owner, group, and permissions tell you.  If you are not sure what the 
output tells you, consult your unix system administrator.

Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Wednesday, June 26, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L


Hello,

Could someone help me decipher these?

1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"

2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission denied"

Thanks.

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

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: [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.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

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: [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: sql difference rounds

[kkennedy]

You might try what I tried.  Put a couple prompts right before the final query to 
display the results before the calculation.  That might give you some insight.  Or 
maybe not.
Kevin Kennedy
First Point Energy Corporation 
-Original Message-
Sent: Wednesday, June 26, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L


Kevin,

Thank you, this works well.  I like it better on one line, too!

I wonder what about my system that the original came out rounded?  I'm on 
the same version of Oracle but 64-bit and Solaris 8 64-bit.

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

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: [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).

bash: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied

[ltiu]

Hello,

Running Oracle 9i release 2 on Linux - Suse 7.2 using glibc 2.2.4.

I'm getting permission errors on the command line when trying to run oracle 
executables.

example:

"bash: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"

Anyone here experienced this before?

Thanks.

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

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: [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: the ora certified masters cert, yet again

[Fink, Dan]

I'd like to see a vote conducted 6 months after the conference. 'Of all the
presentations and papers available at the conference, which are the 5 that
you have found most valuable and useful in your work and/or career?'

The highest compliment I was ever paid was 6 months after my first UG
presentation. A fellow DBA came up and said that he had returned to work
after the conference and used my paper and presentation to audit their
backup & recovery process, identify the outstanding issues and implement a
new process that they tested (not in production) and it worked better than
their old system. 

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Wednesday, June 26, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L


Rachel,

Of all the people who attend the conference, do you happen to know how many
actually go to the trouble of voting for best presentation?

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

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: [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.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[ltiu]

Work experience is better than certification but ...

Getting certified is hard work. Takes a lot of time and effort (not to 
mention money). So it must be worth something. If only for a little bit. It 
is definitely not worthless.

Work experience plus certification is the best combination.

Certification is no different from being a doctor. You need to pass exams to 
be a doctor too (you need internship to go as well, of course).

As for naming famous Oracle authors, I don't think this is a valid gauge of 
your capacity as a DBA. I know some people well versed in Computer 
Engineering concepts (from 'great' authors) but can't code. They sound like 
experts but can't deliver sh_t.

ltiu

On Wednesday 26 June 2002 15:23, you wrote:
> This threads getting to be a lengthy one, and I might as well add my two
> cents to it. I too come from the same school of thought. That you are OCP
> certified holds no water with me. OK. So you are OCP Certified.That dont
> impress me much.
>
> One of my first questions, when I am asked to conduct an interview, is ask
> them to name some of the Oracle Gurus they have read about, to name some
> helpful Oracle sites, or some great white papers. The answers, almost
> always, tend to reflect the level of expertise. Jonathan Lewis, Steve
> Adams, Cary Millsap, Craig Shallahamer, Anjo Kolk, Tom Kyte, Kevin Loney,
> Rama Velupuri, Racheal Carmicheal, ..
>
> Sadly, my point of view differs from that of most recruiters. I know of an
> OCP who, when told that the developers were running out of temporary
> tablespace, put in a request with the SA to increase the disk space for
> /tmp. I also know of a HR personnel who rejected my resume coz I had no 8i
> experience. Sadly, my resume said 8.1.6, 8.1.7.
>
> Raj
> Not an OCP Certified DBA
>
> "Whatever little I know, I owe it to my ignorance".
>
>
>
>
>
> Julia Phu
>  list ORACLE-L <[EMAIL PROTECTED]> tmail.com>  cc:
> Sent by:Subject: Re: the ora
> certified masters cert, yet again [EMAIL PROTECTED]
>
>
> June 26, 2002
> 05:22 PM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Sorry, I can't help being quiet.
>
> I've no respect for the OCP. I saw MANY people bought
> the exams from many sources. These people memorize the
> questions and answers prior the test day. Voila, they
> pass the tests and still don't understand how to
> install and configure the database.
>
> I learned it on my job and am still learning. I took
> the 8i exam program and was EXTREMELY disappointed. I
> learned nothing.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Johnson, Michael]

That is not my understanding.

FWIW.  Mike

-Original Message-
Sent: Wednesday, June 26, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L


Actually no one who has been holds any SCI tickets can admit to doing so :)
One can say you have been the subject of a Special Backgroud Investigation,
and Extensive Background Investigation, a Full Field Investigation even
though 99. times out of 100 these investigations are done for just such
access.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


I suspect that this position will be at Wright-Patterson Air Force base.

OraStaff wrote:
> 
> Position: Oracle DBA with Top Secret SCI Clearance
>   (Please do not send your resume unless you have the required
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Joe Testa]

But Raj, if the temporary tablespace was put on /tmp, that would be ok.

just kidding :)

joe

[EMAIL PROTECTED] wrote:

>This threads getting to be a lengthy one, and I might as well add my two
>cents to it. I too come from the same school of thought. That you are OCP
>certified holds no water with me. OK. So you are OCP Certified.That dont
>impress me much.
>
>One of my first questions, when I am asked to conduct an interview, is ask
>them to name some of the Oracle Gurus they have read about, to name some
>helpful Oracle sites, or some great white papers. The answers, almost
>always, tend to reflect the level of expertise. Jonathan Lewis, Steve
>Adams, Cary Millsap, Craig Shallahamer, Anjo Kolk, Tom Kyte, Kevin Loney,
>Rama Velupuri, Racheal Carmicheal, ..
>
>Sadly, my point of view differs from that of most recruiters. I know of an
>OCP who, when told that the developers were running out of temporary
>tablespace, put in a request with the SA to increase the disk space for
>/tmp. I also know of a HR personnel who rejected my resume coz I had no 8i
>experience. Sadly, my resume said 8.1.6, 8.1.7.
>
>Raj
>Not an OCP Certified DBA
>
>"Whatever little I know, I owe it to my ignorance".
>
>
>
>
>  
> 
>Julia Phu 
> 
>ORACLE-L <[EMAIL PROTECTED]>
>tmail.com>  cc:   
> 
>Sent by:Subject: Re: the ora certified 
>masters cert, yet again 
>[EMAIL PROTECTED]  
> 
>  
> 
>  
> 
>June 26, 2002 
> 
>05:22 PM  
> 
>Please respond
> 
>to ORACLE-L   
> 
>  
> 
>  
> 
>
>
>
>
>Sorry, I can't help being quiet.
>
>I've no respect for the OCP. I saw MANY people bought
>the exams from many sources. These people memorize the
>questions and answers prior the test day. Voila, they
>pass the tests and still don't understand how to
>install and configure the database.
>
>I learned it on my job and am still learning. I took
>the 8i exam program and was EXTREMELY disappointed. I
>learned nothing.
>
>
>
>  
>

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

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: [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: sqlloader tuning

[Nalla Ravi]

Hi,

Beth and Kirti thank you so much for your
clarification.

cheers,
ravi 



--- "Deshpande, Kirti" <[EMAIL PROTECTED]>
wrote: > 1. Review this article by Stephen Andert:
>
http://oracle.oreilly.com/news/oraclesqlload_0401.html
> 2. No. 
> 
> - Kirti 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, June 26, 2002 9:08 AM
> 
> 
> > Hi all,
> > 
> > Can any one please tell me what is the deciding
> factor
> > to specify rows value and bindsize value in
> sqlloader
> > option? 
> > 
> > is there  any option to use direct=true while
> using
> > function in control file?
> > 
> > DB:8.1.7 os:SUN SS
> > thanks for your help.
> > 
> > Cheers,
> > Ravi
> > 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> 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: [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!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Greg Moore]

Rachel,

Of all the people who attend the conference, do you happen to know how many
actually go to the trouble of voting for best presentation?

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

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: [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: Sql query

[Greg Moore]

2 versions of SQL + TKPROF 
excerpts
 
8.1.6,  Solaris
 

SQL version #1


 
select count(*)
  from customers c
 , sales s
 where c.customer_id = 
s.customer_id(+)
   and s.customer_id is 
null
 
       count   cpu 
elapsed disk  query current rows
 
total  4  
7.33    7.36    1 
200352   
41
 
Rows    Row Source 
Operation
--- 

1   SORT 
AGGREGATE 
99105    FILTER 
169049    NESTED LOOPS OUTER 

10 INDEX FAST FULL 
SCAN (object id 22199)
69944  INDEX RANGE 
SCAN (object id 22232)
 


SQL version #2


 
select count(*)
  from customers c
 where c.customer_id not in (
 select 
/*+ hash_aj */
    
s.customer_id
   from 
sales s )
 
   count   
cpu elapsed disk query current rows
 
total  5  
1.17    1.94  159   
356   8    1
 
Rows    Row Source Operation
--- 
--
1   SORT AGGREGATE 

99105    HASH JOIN ANTI 
9 INDEX FAST FULL SCAN 
(object id 22199)
69945 VIEW VW_NSO_1 

69945   INDEX FAST 
FULL SCAN (object id 22232)
 
 

sqlplus: Permission denied

[ltiu]

Hello,

Could someone help me decipher these?

1) "sh: /DB/O92iBase/O9iEE/bin/sqlplus: Permission denied"

2) "sh: /DB/O92iBase/O9iEE/bin/genclntsh: bad interpreter: Permission denied"

Thanks.

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

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: [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: conferences - IOUG vs OOW

[Joe Testa]

Bill, good assumption.

Marketing fluff = OOW
More true technical presentations(like where i say what does and does 
NOT work) = IOUG Live.

joe


Magaliff, Bill wrote:

>Having never been to either and wanting to plan for one, am I to infer from
>some of this discussion that for real content (as opposed to marketing
>fluff), THE conference to attend would be IOUGLive, as opposed to Oracle
>Open World?  
>
>-bill
>  
>

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

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: [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: the ora certified masters cert, yet again

[Joe Testa]

Chris, feel blessed, she stays during all of mine and asks bizarre 
questions :),

like:  If 2 control files are being updated at the same time and one is 
on raid-5 and the other on raid 0+1, which one will be finished updating 
first.

joe


Grabowy, Chris wrote:

>Matt, she walked out in the middle of your presentation??  
>
>Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
>well...
>
>-Original Message-
>Sent: Wednesday, June 26, 2002 5:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>well, if so, I'll finally get to see you present and won't have to walk
>out in the middle 
>
>
>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
>wrote:
>  
>
>>Right now, I think Susan has me from 1-2, right after
>>lunch, but I'm not sure. The OOUG web site is a 
>>little sparse on details.
>>
>>
>>
>>
>>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>>We have enough youth.
>>How about a fountain of intelligence?
>>
>>-Original Message-
>>Sent: Wednesday, June 26, 2002 4:50 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>But Mtt... you were always scheduled at either the
>>same
>>time *I* was presenting (trust me, I'd rather have gone to yours, I
>>get
>>stage fright) or when at LEAST 2 other presentations I wanted to see
>>equally as much were there.
>>
>>Um, what time are you presenting at OOUG? My flight home is at 5, I
>>have to leave around 2:30 or so
>>
>>
>>
>>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
>>wrote:
>>
>>
>>>But Rachel, you never came to any of my 
>>>presentations!  (in my best whiney voice)
>>>
>>>At least you'll get to see me present in July at OOUG.
>>>
>>>
>>>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>>>We have enough youth.
>>>How about a fountain of intelligence?
>>>
>>>-Original Message-
>>>Sent: Wednesday, June 26, 2002 3:56 PM
>>>To: Multiple recipients of list ORACLE-L
>>>
>>>
>>>that's 'cause you present well and have knowledge
>>>
>>>or.. to quote one of my favorite shows:
>>>
>>>"he has much knowledge. we must build an altar and worship him"
>>>
>>>
>>>:)
>>>
>>>
>>>--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
>>>wrote:
>>>  
>>>
Actually, I had to miss this years (even though I was orginally
schedule
to give two presentations)  due to a medical situation.  I gave


>>>four
>>>  
>>>
the
year
before that.  
 


Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence? 

 
-Original Message-
Sent: Wednesday, June 26, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L



OK.  As the DBA Focus Area Manager for the IOUG, we do our best


>>to
>>
>>
weed out
the fluff.  If you were at IOUG this year, you should have


>>noticed
>>
>>
>>>a
>>>  
>>>
significant reduction in the marketing fluff and more technical
content.
Yes, some showmanship is necessary when giving a presentation,


>>but
>>
>>
the
content has to be there.

 

Many people on this forum have submitted presentations to my


>>track
>>
>>
and then
complained that they were not accepted.  Let me give you some
concrete
numbers.  This year, we received over 400 abstracts for the DBA


>>>track
>>>  
>>>
alone
and accepted only 80.  If one slips through the cracks, it won't


>>a
>>
>>
second
time.  Believe me when I say that 2002 was the best


>>>content-organized
>>>  
>>>
IOUG.


 

Further comments?  Submit an abstract for 2003 and find out!!!

 

Thank You

 

Stephen P. Karniotis

Product Architect

Compuware Corporation

Direct:   (248) 865-4350

Mobile:  (248) 408-2918

Email:  [EMAIL PROTECTED]

Web:www.compuware.com

 

-Original Message-
Sent: Wednesday, June 26, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L

 

unfortunately, I've seen this to be true at 
many conferences, including the IOUG 
and SEOUC. 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
"Doing linear scans over an associative array is like 
trying to club someone to death with a loaded Uzi." 
- Larry Wall (creator of Perl) 

-Original Message- 
 ] 
Sent: Wednesday, June 26, 2002 11:54 AM 
To: Multiple recipients of list ORACLE-L 

 

I'll bet a dynamic animated speaker chockful of amusing anecdotes
whose
presentation is technically weak scores better than a plodding
m

RE: sql difference rounds

[Debi]

Kevin,

Thank you, this works well.  I like it better on one line, too!

I wonder what about my system that the original came out rounded?  I'm on 
the same version of Oracle but 64-bit and Solaris 8 64-bit.

Debi


At 12:34 PM 6/26/2002 -0800, kkennedy wrote:
>Hi Debi,
>I ran your script on my system and did not have the rounding problem 
>(sqlplus 8.1.7.0.0 running on W2K against an 8.1.7.3.0 database on Solaris).
>
>Maybe you can try this query instead:
>
>select t.tablespace_name
>, t.total_bytes
>, u.used_bytes
>, t.total_bytes-u.used_bytes space_left
>from (select tablespace_name, sum(bytes) total_bytes
>   from dba_data_files
>   group by tablespace_name) t
>, (select tablespace_name, sum(bytes) used_bytes
>   from dba_extents
>   group by tablespace_name) u
>where t.tablespace_name=u.tablespace_name
>and t.tablespace_name=&1
>/
>
>HTH
>Kevin Kennedy
>First Point Energy Corporation
>-Original Message-
>Sent: Wednesday, June 26, 2002 12:20 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Why is my difference rounded:
>
>'Checking space left in data_ts:'
>
>   TOTAL_BYTES
>
>
>
>18,880,659,456
>
>
>USED_BYTES
>
>
>
>17,796,554,752
>
>   Space
>Left
>
>
> 1,000,000,000
>
>
>Here's my script:
>
>set heading on verify off
>col total_bytes format 999,999,999,999,999 new_value tbytes
>col tbytes format 999,999,999,999,999
>col used_bytes format 999,999,999,999,999 new_value ubytes
>col ubytes format 999,999,999,999,999
>col space_left format 999,999,999,999,999 head 'Space Left'
>
>spool space_left
>prompt
>prompt 'Checking space left in &1:'
>prompt
>select sum(t.bytes) total_bytes
>from dba_data_files t
>where t.tablespace_name = upper('&&1')
>/
>select sum(u.bytes) used_bytes
>from dba_extents u
>where u.tablespace_name = upper('&&1')
>/
>select (&&tbytes) - (&&ubytes) space_left
>from dual
>/
>
>Thanks,
>
>Debi
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Debi
>   INET: [EMAIL PROTECTED]

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

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: [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: the ora certified masters cert, yet again

[Rajesh . Rao]

This threads getting to be a lengthy one, and I might as well add my two
cents to it. I too come from the same school of thought. That you are OCP
certified holds no water with me. OK. So you are OCP Certified.That dont
impress me much.

One of my first questions, when I am asked to conduct an interview, is ask
them to name some of the Oracle Gurus they have read about, to name some
helpful Oracle sites, or some great white papers. The answers, almost
always, tend to reflect the level of expertise. Jonathan Lewis, Steve
Adams, Cary Millsap, Craig Shallahamer, Anjo Kolk, Tom Kyte, Kevin Loney,
Rama Velupuri, Racheal Carmicheal, ..

Sadly, my point of view differs from that of most recruiters. I know of an
OCP who, when told that the developers were running out of temporary
tablespace, put in a request with the SA to increase the disk space for
/tmp. I also know of a HR personnel who rejected my resume coz I had no 8i
experience. Sadly, my resume said 8.1.6, 8.1.7.

Raj
Not an OCP Certified DBA

"Whatever little I know, I owe it to my ignorance".




   

Julia Phu  


tmail.com>  cc:

Sent by:Subject: Re: the ora certified masters 
cert, yet again 
[EMAIL PROTECTED]   

   

   

June 26, 2002  

05:22 PM   

Please respond 

to ORACLE-L

   

   





Sorry, I can't help being quiet.

I've no respect for the OCP. I saw MANY people bought
the exams from many sources. These people memorize the
questions and answers prior the test day. Voila, they
pass the tests and still don't understand how to
install and configure the database.

I learned it on my job and am still learning. I took
the 8i exam program and was EXTREMELY disappointed. I
learned nothing.



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

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: [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: Career Opportunities Announcement

[Bill Christison]

Kenneth,
  250 miles SE(Northern Chicagc suburb).Relative to
Minneapolis/St Paul..I've a client company whom I could explore
in your behalf.Re:Oracle clinical.
  So,...let me know your thoughts,
Bill Christison
  
--- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote:
> Any Oracle in Minneapolis / St. Paul, MN?
> 
> Thanks,
> Ken Janusz, CPIM
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, June 26, 2002 1:48 PM
> 
> 
> > We currently have positions available for Oracle Clinical
> > specialists with leading pharmaceutical companies and CRO's
> in
> > NJ.
> > 
> > Our associate's established relationship within the
> > pharmaceutical industry is predicated upon 20 years of
> providing
> > career opportunities to Biostatisticians.  This association
> to
> > Knowlton Group is to the potential benefit of career minded
> > Oracle Clinical professionals.  
> > 
> > We currently have full time (only) opportunities as;
> individual
> > contributors, project leaders, and managers/supervisors.(NJ
> &
> > Chicago).
> > 
> > Even if you are not currently interested in a position
> change,
> > reply to this email in order to have future career options
> > brought to your attention.
> > 
> > Our involvement with clients and candidates is established
> and
> > long term.
> > 
> > Bill Christison
> > 
> > =
> > Bill Christison
> > Knowlton Group, LLC
> > 845-258-5129
> > www.knowltongroup.com
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Bill Christison
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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.com
> -- 
> Author: KENNETH JANUSZ
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).


=
Bill Christison
Knowlton Group, LLC
845-258-5129
www.knowltongroup.com

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Christison
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Fink, Dan]

You're both lucky! She stayed all the way through mine and never once broke
out her knitting!

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456


-Original Message-
Sent: Wednesday, June 26, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L


Matt, she walked out in the middle of your presentation??  

Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
well...

-Original Message-
Sent: Wednesday, June 26, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L


well, if so, I'll finally get to see you present and won't have to walk
out in the middle 


--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Right now, I think Susan has me from 1-2, right after
> lunch, but I'm not sure. The OOUG web site is a 
> little sparse on details.
> 
> 
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> But Mtt... you were always scheduled at either the
> same
> time *I* was presenting (trust me, I'd rather have gone to yours, I
> get
> stage fright) or when at LEAST 2 other presentations I wanted to see
> equally as much were there.
> 
> Um, what time are you presenting at OOUG? My flight home is at 5, I
> have to leave around 2:30 or so
> 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > But Rachel, you never came to any of my 
> > presentations!  (in my best whiney voice)
> > 
> > At least you'll get to see me present in July at OOUG.
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 3:56 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > that's 'cause you present well and have knowledge
> > 
> > or.. to quote one of my favorite shows:
> > 
> > "he has much knowledge. we must build an altar and worship him"
> > 
> > 
> > :)
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > Actually, I had to miss this years (even though I was orginally
> > > schedule
> > > to give two presentations)  due to a medical situation.  I gave
> > four
> > > the
> > > year
> > > before that.  
> > >  
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence? 
> > > 
> > >  
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> to
> > > weed out
> > > the fluff.  If you were at IOUG this year, you should have
> noticed
> > a
> > > significant reduction in the marketing fluff and more technical
> > > content.
> > > Yes, some showmanship is necessary when giving a presentation,
> but
> > > the
> > > content has to be there.
> > > 
> > >  
> > > 
> > > Many people on this forum have submitted presentations to my
> track
> > > and then
> > > complained that they were not accepted.  Let me give you some
> > > concrete
> > > numbers.  This year, we received over 400 abstracts for the DBA
> > track
> > > alone
> > > and accepted only 80.  If one slips through the cracks, it won't
> a
> > > second
> > > time.  Believe me when I say that 2002 was the best
> > content-organized
> > > IOUG.
> > > 
> > > 
> > >  
> > > 
> > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > 
> > >  
> > > 
> > > Thank You
> > > 
> > >  
> > > 
> > > Stephen P. Karniotis
> > > 
> > > Product Architect
> > > 
> > > Compuware Corporation
> > > 
> > > Direct:   (248) 865-4350
> > > 
> > > Mobile:  (248) 408-2918
> > > 
> > > Email:  [EMAIL PROTECTED]
> > > 
> > > Web:www.compuware.com
> > > 
> > >  
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > >  
> > > 
> > > unfortunately, I've seen this to be true at 
> > > many conferences, including the IOUG 
> > > and SEOUC. 
> > > 
> > >  
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > > "Doing linear scans over an associative array is like 
> > > trying to club someone to death with a loaded Uzi." 
> > > - Larry Wall (creator of Perl) 
> > > 
> > > -Original Message- 
> > >  ] 
> > > Sent: Wednesday, June 26, 2002 11:54 AM 
> > > To: Multiple recipients of list ORACLE-L 
> > > 
> > >  
> > > 
> > > I'll bet a dynamic animated speaker chockful of amusing anecdotes
> > > whose
> > > presentation is technically weak scores better than a plodding
> > > monotonous
> > > one with better information to convey :)  Especialy if the
> aud

RE: conferences - IOUG vs OOW

[Freeman, Robert]

Personally I think the one UKOUG conference I was at was superior to even
IOUGAlive...
S... if you can get your employer to pony up for that baby this year, by
all means
go! :-))

RF

Robert G. Freeman - Oracle8i OCP
Oracle Database Architect
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, June 26, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L


Bill:

  What a loaded question...  For pure technical content, we hope, please
attend local user group events or IOUG-Live.  If you want to hear about new
products being introduced into the market or pure marketing info., then
attend OOW.  It's that simple.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, June 26, 2002 5:15 PM
To: Multiple recipients of list ORACLE-L
Subject:conferences - IOUG vs OOW

Having never been to either and wanting to plan for one, am I to infer from
some of this discussion that for real content (as opposed to marketing
fluff), THE conference to attend would be IOUGLive, as opposed to Oracle
Open World?  

-bill
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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: [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.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Grabowy, Chris]

Matt, she walked out in the middle of your presentation??  

Your lucky.  She walked out of mine at the beginning, shaking her head.  Oh
well...

-Original Message-
Sent: Wednesday, June 26, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L


well, if so, I'll finally get to see you present and won't have to walk
out in the middle 


--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Right now, I think Susan has me from 1-2, right after
> lunch, but I'm not sure. The OOUG web site is a 
> little sparse on details.
> 
> 
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> But Mtt... you were always scheduled at either the
> same
> time *I* was presenting (trust me, I'd rather have gone to yours, I
> get
> stage fright) or when at LEAST 2 other presentations I wanted to see
> equally as much were there.
> 
> Um, what time are you presenting at OOUG? My flight home is at 5, I
> have to leave around 2:30 or so
> 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > But Rachel, you never came to any of my 
> > presentations!  (in my best whiney voice)
> > 
> > At least you'll get to see me present in July at OOUG.
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 3:56 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > that's 'cause you present well and have knowledge
> > 
> > or.. to quote one of my favorite shows:
> > 
> > "he has much knowledge. we must build an altar and worship him"
> > 
> > 
> > :)
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > Actually, I had to miss this years (even though I was orginally
> > > schedule
> > > to give two presentations)  due to a medical situation.  I gave
> > four
> > > the
> > > year
> > > before that.  
> > >  
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence? 
> > > 
> > >  
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> to
> > > weed out
> > > the fluff.  If you were at IOUG this year, you should have
> noticed
> > a
> > > significant reduction in the marketing fluff and more technical
> > > content.
> > > Yes, some showmanship is necessary when giving a presentation,
> but
> > > the
> > > content has to be there.
> > > 
> > >  
> > > 
> > > Many people on this forum have submitted presentations to my
> track
> > > and then
> > > complained that they were not accepted.  Let me give you some
> > > concrete
> > > numbers.  This year, we received over 400 abstracts for the DBA
> > track
> > > alone
> > > and accepted only 80.  If one slips through the cracks, it won't
> a
> > > second
> > > time.  Believe me when I say that 2002 was the best
> > content-organized
> > > IOUG.
> > > 
> > > 
> > >  
> > > 
> > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > 
> > >  
> > > 
> > > Thank You
> > > 
> > >  
> > > 
> > > Stephen P. Karniotis
> > > 
> > > Product Architect
> > > 
> > > Compuware Corporation
> > > 
> > > Direct:   (248) 865-4350
> > > 
> > > Mobile:  (248) 408-2918
> > > 
> > > Email:  [EMAIL PROTECTED]
> > > 
> > > Web:www.compuware.com
> > > 
> > >  
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > >  
> > > 
> > > unfortunately, I've seen this to be true at 
> > > many conferences, including the IOUG 
> > > and SEOUC. 
> > > 
> > >  
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > > "Doing linear scans over an associative array is like 
> > > trying to club someone to death with a loaded Uzi." 
> > > - Larry Wall (creator of Perl) 
> > > 
> > > -Original Message- 
> > >  ] 
> > > Sent: Wednesday, June 26, 2002 11:54 AM 
> > > To: Multiple recipients of list ORACLE-L 
> > > 
> > >  
> > > 
> > > I'll bet a dynamic animated speaker chockful of amusing anecdotes
> > > whose
> > > presentation is technically weak scores better than a plodding
> > > monotonous
> > > one with better information to convey :)  Especialy if the
> audience
> > > is
> > > composed of nascent DBA's :)
> > > 
> > > Ian MacGregor 
> > > Stanford Linear Accelerator Center 
> > > [EMAIL PROTECTED] 
> > > 
> > > -Original Message- 
> > > Sent: Tuesday, June 25, 2002 5:09 PM 
> > > To: Multiple recipients 

RE: conferences - IOUG vs OOW

[Magaliff, Bill]

thanks to both of you, Rachel and Stephen . . . clears it up for me.

btw I do attend NYOUG meeings (except the last one - couldn't bear the
thought of a NY Harbor cruise in the lousy weather, rocking to and fro) and
do find them pretty interesting - and some nifty giveaway's, too, are always
nice for the kids :-)

-bill

-Original Message-
Sent: Wednesday, June 26, 2002 5:40 PM
To: Multiple recipients of list ORACLE-L


my preference when I have to choose is IOUG over OOW 

OOW tends to have a lot more marketing/Oracle employee (so it feels
like marketing) presentations


--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> Having never been to either and wanting to plan for one, am I to
> infer from
> some of this discussion that for real content (as opposed to
> marketing
> fluff), THE conference to attend would be IOUGLive, as opposed to
> Oracle
> Open World?  
> 
> -bill
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Magaliff, Bill
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [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: report showing free space per tablespace over time

[kkennedy]

Hi Jack,

That looks like a good tool.  Personally, for about the last 5 years, I've been using 
an adaptation of the command center database described in the Oracle 7(& later) DBA 
Handbook using cron as my scheduler.  The neatest implementation I did was several 
jobs back where I also collected volume space information.  Then, I created a web page 
that displayed a graph of volume space, tablespace, and free space in living color -- 
this was in response to a PHB that kept asking for a database growth projection every 
few weeks so that he could plan the following years hardware purchases.  Once I gave 
him the URL, he quit asking.  He never got the purchases right, but that's what 
happens when you project the future by looking in the rear view mirror.

On my last job, I told my PHB that I wanted to implement the CC database right out of 
the gate.  He told me we didn't need it.  I implemented it anyway without telling him. 
 A few months later, he figured out why we needed it.

I can't imagine maintaining a database without having an ongoing growth history.

Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Wednesday, June 26, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L


Listers,

Ever been asked how much free space you have in the
tablespaces over time? I wrote a tool that tracks and
reports on free space per tablespace over time and
thought I would share it.

It consists of a simple stored procedure that stores
values in a holding table and a report that will tell
you how much each tablespace had over the past week
(you can change the coverage of this report.)

1) Here is the stored procedure:

CREATE OR REPLACE PROCEDURE 
tablespace_proc AS

v_errmsg varchar2(100);
v_errcode varchar2(100);
   
BEGIN

delete dbmon.dbmon_tablespace_stats
where trunc(record_date) = trunc(sysdate);


INSERT INTO dbmon.dbmon_tablespace_stats

(tablespace_name, 
total_space, 
megs_free, 
max_extent, 
autoextend,
record_date)

SELECT
fs.tablespace_name,
round(df.total_bytes/1024/1024,0),
round(fs.bytes_free/1024/1024,0),
round(fs.max_bytes/1024/1024,0),
decode(a.tablespace_name,null,'No','Yes'),
sysdate
FROM
(SELECT
tablespace_name,
SUM(bytes) bytes_free,
max(bytes) max_bytes
FROM
dba_free_space fs
GROUP BY
tablespace_name) fs,
(SELECT
tablespace_name,
sum(bytes) total_bytes
FROM
dba_data_files
GROUP BY 
tablespace_name) df,
(SELECT DISTINCT
tablespace_name
FROM
dba_data_files
WHERE
autoextensible = 'YES') a,
(select tablespace_name
from dba_tablespaces) ts
WHERE
df.tablespace_name = fs.tablespace_name(+)
AND
df.tablespace_name = a.tablespace_name(+)
AND 
df.tablespace_name = ts.tablespace_name;

commit;

exception

when others then

v_errmsg := substr(SQLERRM,1,100);
v_errcode := SQLCODE;

insert into dbmon_activity_log
(activity_date,
activity_desc,
procedure_name,
error_code,
error_msg,
error_date)
values
(sysdate,
'tablespace_proc',
'tablespace_proc',
v_errcode,
v_errmsg,
sysdate);
commit;

end;
/



2) Here is the code to submit it to the job scheduler
(every day at 5AM):

variable jobno number

exec sys.dbms_job.submit(job=>:jobno, what=>'begin
dbmon.dbmon_tablespace_proc;end;',
next_date=>trunc(sysdate+1)+5/24,interval=>'trunc(sysdate+1)+5/24');

3)  and here is the report:


@save_sqlplus_settings

set term off

set head off

spool temp.sql 

select 'col c'||rownum ||' for 999,999,990 head "'|| 
to_char(sysdate+1-rownum,'dd-mon')||'"' 
from dba_tablespaces where rownum<8; 

select 'compute sum of c'||rownum ||' on report'
from dba_tablespaces where rownum<8; 

select 'break on report' from dual; 

spool off 

@temp.sql 

exec dbmon.dbmon_tablespace_proc;

set term on
set lines 135


prompt
prompt Free space per tablespace:
prompt


select tablespace_name, 
sum(decode(old,7,value)) c7,
sum(decode(old,6,value)) c6,
sum(decode(old,5,value)) c5,
sum(decode(old,4,value)) c4,
sum(decode(old,3,value)) c3,
sum(decode(old,2,value)) c2,
sum(decode(old,1,value)) c1
from
(select tablespace_name, 
megs_free value, 
decode 
(trunc(record_date),
trunc(sysdate),1,
trunc(sysdate)-1,2,
trunc(sysdate)-2,3,
trunc(sysdate)-3,4,
tr

Re: the ora certified masters cert, yet again

[ltiu]

Everyone's got their own way of doing things. I got Sun certified and I am 
using Sun everyday so I am OK when it comes to proficiency with Suns. Now I 
am getting Oracle certified and I am using Oracle everyday too.

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

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

it reminds me of one of the comments (an bad rating) on the DBA 101
book on amazon...

to paraphrase "this book is no good because it doesn't help me cheat
and lie on job interviews"

I consider that HIGH praise


--- Julia Phu <[EMAIL PROTECTED]> wrote:
> Sorry, I can't help being quiet.
> 
> I've no respect for the OCP. I saw MANY people bought
> the exams from many sources. These people memorize the
> questions and answers prior the test day. Voila, they
> pass the tests and still don't understand how to
> install and configure the database. 
> 
> I learned it on my job and am still learning. I took
> the 8i exam program and was EXTREMELY disappointed. I
> learned nothing.
> 
> 
> --- Alexandre Gorbatchev
> <[EMAIL PROTECTED]> wrote:
> > Seems nobody's left quiet. :)
> > Personally, I don't want to be obstinate. I wouldn't
> > avoid certification
> > only because I think (and yes, I do) it's all about
> > the Oracle's revenue and
> > nothing about professional knowledge. Works for
> > Oracle - fine, glad for
> > them. As "side effect" I can have increase in
> > personal revenue and that's
> > what I care about. That's what I count on.
> > Well, that's my point here.
> > 
> > Alexandre
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 26, 2002 4:33 PM
> > 
> > 
> > > Well that explains a lot. In a separate post
> > Rachel also said Oracle
> > > denigrated the prior Chauncey/IOUG tests so it's
> > obvious that Oracle is
> > just
> > > using testing and certification as another source
> > of revenue. Professional
> > > Development of the DBA community is just marketing
> > hype. All the more
> > reason
> > > to avoid the 9i tests.
> > >
> > > -Original Message-
> > > Sent: Tuesday, June 25, 2002 7:08 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Importance: High
> > >
> > >
> > > The original certification program was developed
> > by IOUG when Mike Corey
> > was
> > > president of the group.  I cannot remember if the
> > program ever certified
> > > anyone other than those who built it.   Once
> > Oracle had its own
> > > certification program  the IOUG one withered.
> > >
> > > The relationship between ORACLE and its user
> > groups have not always been
> > > friendly.  The OAUG's complaints have made the
> > national press.  If my
> > memory
> > > serves, and its already been shown to be faulty, 
> > the first OOW-Americas
> > was
> > > scheduled to be at the same time as the IOUG-A.  
> > Corey indicated he was
> > > going to see Ellison and explain to him that he
> > couldn't do such a thing,
> > > that OOW-Americas would have to be rescheduled. 
> > Ellison was not moved,
> > > neither was the OOW-Americas conference; the
> > IOUG-A get together was :)
> > >
> > > To its credit IOUG-A live is seen as a more
> > credible than the marketing
> > show
> > > known as OOW.  However I doubt the conference
> > would maintain its value if
> > > Oracle sent no one.   If the IOUG had a competing
> > certification program,
> > > Oracle would do its best to snuff it out.
> > >
> > > Ian MacGregor
> > > Stanford Linear Accelerator Center
> > > [EMAIL PROTECTED]
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Orr, Steve
> > >   INET: [EMAIL PROTECTED]
> > >
> > > 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: [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.com
> > -- 
> > Author: Alexandre Gorbatchev
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Julia Phu
> 

Re: conferences - IOUG vs OOW

[Rachel Carmichael]

my preference when I have to choose is IOUG over OOW 

OOW tends to have a lot more marketing/Oracle employee (so it feels
like marketing) presentations


--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> Having never been to either and wanting to plan for one, am I to
> infer from
> some of this discussion that for real content (as opposed to
> marketing
> fluff), THE conference to attend would be IOUGLive, as opposed to
> Oracle
> Open World?  
> 
> -bill
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Magaliff, Bill
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

well, if so, I'll finally get to see you present and won't have to walk
out in the middle 


--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Right now, I think Susan has me from 1-2, right after
> lunch, but I'm not sure. The OOUG web site is a 
> little sparse on details.
> 
> 
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 4:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> But Mtt... you were always scheduled at either the
> same
> time *I* was presenting (trust me, I'd rather have gone to yours, I
> get
> stage fright) or when at LEAST 2 other presentations I wanted to see
> equally as much were there.
> 
> Um, what time are you presenting at OOUG? My flight home is at 5, I
> have to leave around 2:30 or so
> 
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > But Rachel, you never came to any of my 
> > presentations!  (in my best whiney voice)
> > 
> > At least you'll get to see me present in July at OOUG.
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence?
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 3:56 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > that's 'cause you present well and have knowledge
> > 
> > or.. to quote one of my favorite shows:
> > 
> > "he has much knowledge. we must build an altar and worship him"
> > 
> > 
> > :)
> > 
> > 
> > --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> > wrote:
> > > Actually, I had to miss this years (even though I was orginally
> > > schedule
> > > to give two presentations)  due to a medical situation.  I gave
> > four
> > > the
> > > year
> > > before that.  
> > >  
> > > 
> > > 
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > > We have enough youth.
> > > How about a fountain of intelligence? 
> > > 
> > >  
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 1:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > 
> > > OK.  As the DBA Focus Area Manager for the IOUG, we do our best
> to
> > > weed out
> > > the fluff.  If you were at IOUG this year, you should have
> noticed
> > a
> > > significant reduction in the marketing fluff and more technical
> > > content.
> > > Yes, some showmanship is necessary when giving a presentation,
> but
> > > the
> > > content has to be there.
> > > 
> > >  
> > > 
> > > Many people on this forum have submitted presentations to my
> track
> > > and then
> > > complained that they were not accepted.  Let me give you some
> > > concrete
> > > numbers.  This year, we received over 400 abstracts for the DBA
> > track
> > > alone
> > > and accepted only 80.  If one slips through the cracks, it won't
> a
> > > second
> > > time.  Believe me when I say that 2002 was the best
> > content-organized
> > > IOUG.
> > > 
> > > 
> > >  
> > > 
> > > Further comments?  Submit an abstract for 2003 and find out!!!
> > > 
> > >  
> > > 
> > > Thank You
> > > 
> > >  
> > > 
> > > Stephen P. Karniotis
> > > 
> > > Product Architect
> > > 
> > > Compuware Corporation
> > > 
> > > Direct:   (248) 865-4350
> > > 
> > > Mobile:  (248) 408-2918
> > > 
> > > Email:  [EMAIL PROTECTED]
> > > 
> > > Web:www.compuware.com
> > > 
> > >  
> > > 
> > > -Original Message-
> > > Sent: Wednesday, June 26, 2002 12:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > >  
> > > 
> > > unfortunately, I've seen this to be true at 
> > > many conferences, including the IOUG 
> > > and SEOUC. 
> > > 
> > >  
> > > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > > "Doing linear scans over an associative array is like 
> > > trying to club someone to death with a loaded Uzi." 
> > > - Larry Wall (creator of Perl) 
> > > 
> > > -Original Message- 
> > >  ] 
> > > Sent: Wednesday, June 26, 2002 11:54 AM 
> > > To: Multiple recipients of list ORACLE-L 
> > > 
> > >  
> > > 
> > > I'll bet a dynamic animated speaker chockful of amusing anecdotes
> > > whose
> > > presentation is technically weak scores better than a plodding
> > > monotonous
> > > one with better information to convey :)  Especialy if the
> audience
> > > is
> > > composed of nascent DBA's :)
> > > 
> > > Ian MacGregor 
> > > Stanford Linear Accelerator Center 
> > > [EMAIL PROTECTED] 
> > > 
> > > -Original Message- 
> > > Sent: Tuesday, June 25, 2002 5:09 PM 
> > > To: Multiple recipients of list ORACLE-L 
> > > 
> > >  
> > > 
> > > one being a marketing venue, the other being a place where you
> can 
> > > learn from ohers experiences. 
> > > 
> > > and to clarify further, if you are a lousy presenter, giving bad 
> > > information, you 

Re: Deleting large table and the correct log buffer size

[Vasu Ramasamy]

Hi Greg,
 Thanks. But we do not want to pay another $ 200K for the partioning
license.

 Vasu

Greg Moore wrote:

> If you have purchased the partitioning option, you may be able to partition
> the table in a way that will allow you to drop the partition that contains
> all the rows you want to delete.  It's much faster to drop a partition
> containing 400K rows than to delete 400K rows.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
>
> 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: [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).


begin:vcard 
n:Ramasamy;Vasu 
tel;fax:650 859 3668
tel;work:650 859 4818
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Principal Database Administrator
fn:Vasu Ramasamy
end:vcard

RE: conferences - IOUG vs OOW

[Karniotis, Stephen]

Bill:

  What a loaded question...  For pure technical content, we hope, please
attend local user group events or IOUG-Live.  If you want to hear about new
products being introduced into the market or pure marketing info., then
attend OOW.  It's that simple.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, June 26, 2002 5:15 PM
To: Multiple recipients of list ORACLE-L
Subject:conferences - IOUG vs OOW

Having never been to either and wanting to plan for one, am I to infer from
some of this discussion that for real content (as opposed to marketing
fluff), THE conference to attend would be IOUGLive, as opposed to Oracle
Open World?  

-bill
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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: [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: Deleting large table and the correct log buffer size

[Vasu Ramasamy]

Hi Denis,
 I tried the same delete in the Sybase  version. To delete the same number
of rows, Sybase took 3 minutes and 10 seconds. Other than the deletes, response
time in Oracle for other statements looks better, when compared to Sybase.
Having said that, I am afraid that I may be comparing apples and oranges. The
(cpu) power of Oracle machine is twice that of the Sybase's. Our developers are
by and large very happy with Oracle performance.

Thanks

Vasu

DENNIS WILLIAMS wrote:

> Good point, Jared. A thought occurs to me. Is it possible the Sybase
> architecture lends itself to deletes more than the Oracle architecture. As
> you study the Oracle architecture you note several places where Oracle is
> tuned for high insert/update performance at the expense of the delete
> performance. Perhaps someone on the list with experience in both Oracle and
> Sybase can comment on whether Sybase is faster at deletes. If that is true,
> I could see a DBA coming from a Sybase background might expect Oracle
> deletes to be much faster, while those of us who have only Oracle experience
> might have a different expectation.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:06 PM
> To: Multiple recipients of list ORACLE-L
>
> Personally, I'd be pretty happy with a 400K row delete
> only taking 10 minutes.
>
> Jared
>
> "Vasu Ramasamy" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/26/2002 09:49 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Deleting large table and the correct log buffer size
>
> Hello Gurus,
>   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> the process of conversion. I have a problem in deleting a large number
> of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> complete and sometimes hogs system. It is a simple delete statement,
> delete all rows. We do not want to use truncate statement. I try to find
> why it is taking so much time by checking the wait events. The session
> event wait statistics is provided below.
>
> SIDEVENT
> TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
> 
> --
>
> AVERAGE_WAIT  MAX_WAIT
> --
> 27latch
> free
> 1010 20
>2 2
>
> 27log buffer
> space
> 298   271  29267
>   98.2114094   104
>
> 27log file switch
> completion   11
> 10   1069
>   97.1818182   103
>
> 27log file
> sync
> 3 2221
>   73.667   103
>
> 27db file sequential
> read3222
> 0   7695
>   2.38826816   589
>
> 27db file scattered
> read  271
> 0493
>   1.81918819   236
>
> 27file
> open
> 4 0  0
>0 0
>
>The log_buffer_space wait event looks like is the culprit with
> total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> of a second). Are these normal values for this wait event? The log
> buffer init param is set to 20MB. To set up the init params, we took the
> advice of the consultant DBA who worked for a short time (6 months) to
> help us to set up servers. While I was going through the DBA hand books,
> ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> it clearly says that setting higher value will cause trouble. He
> recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> for log_buffer_space just doubles.
>
>Can you please advice me what should be the correct size for log
> buffer?
>Do you see any problem with wait stats provided above?
>
>   If you need further details, let me know please.
>
>Thanks
>
> Vasu
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> 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: [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).


begin:vcard 
n:Ramasamy;Vasu 
tel;fax:650 859 3668
tel;work:650 859 4818
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Principal Database Administrator
fn:Vasu Ramasamy
end:vcard

Re: the ora certified masters cert, yet again

[Julia Phu]

Sorry, I can't help being quiet.

I've no respect for the OCP. I saw MANY people bought
the exams from many sources. These people memorize the
questions and answers prior the test day. Voila, they
pass the tests and still don't understand how to
install and configure the database. 

I learned it on my job and am still learning. I took
the 8i exam program and was EXTREMELY disappointed. I
learned nothing.


--- Alexandre Gorbatchev
<[EMAIL PROTECTED]> wrote:
> Seems nobody's left quiet. :)
> Personally, I don't want to be obstinate. I wouldn't
> avoid certification
> only because I think (and yes, I do) it's all about
> the Oracle's revenue and
> nothing about professional knowledge. Works for
> Oracle - fine, glad for
> them. As "side effect" I can have increase in
> personal revenue and that's
> what I care about. That's what I count on.
> Well, that's my point here.
> 
> Alexandre
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, June 26, 2002 4:33 PM
> 
> 
> > Well that explains a lot. In a separate post
> Rachel also said Oracle
> > denigrated the prior Chauncey/IOUG tests so it's
> obvious that Oracle is
> just
> > using testing and certification as another source
> of revenue. Professional
> > Development of the DBA community is just marketing
> hype. All the more
> reason
> > to avoid the 9i tests.
> >
> > -Original Message-
> > Sent: Tuesday, June 25, 2002 7:08 PM
> > To: Multiple recipients of list ORACLE-L
> > Importance: High
> >
> >
> > The original certification program was developed
> by IOUG when Mike Corey
> was
> > president of the group.  I cannot remember if the
> program ever certified
> > anyone other than those who built it.   Once
> Oracle had its own
> > certification program  the IOUG one withered.
> >
> > The relationship between ORACLE and its user
> groups have not always been
> > friendly.  The OAUG's complaints have made the
> national press.  If my
> memory
> > serves, and its already been shown to be faulty, 
> the first OOW-Americas
> was
> > scheduled to be at the same time as the IOUG-A.  
> Corey indicated he was
> > going to see Ellison and explain to him that he
> couldn't do such a thing,
> > that OOW-Americas would have to be rescheduled. 
> Ellison was not moved,
> > neither was the OOW-Americas conference; the
> IOUG-A get together was :)
> >
> > To its credit IOUG-A live is seen as a more
> credible than the marketing
> show
> > known as OOW.  However I doubt the conference
> would maintain its value if
> > Oracle sent no one.   If the IOUG had a competing
> certification program,
> > Oracle would do its best to snuff it out.
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [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.com
> -- 
> Author: Alexandre Gorbatchev
>   INET: [EMAIL PROTECTED]
> 
> 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: [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! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Julia Phu
  INET: [EMAIL PROTECTED]

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: [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 subscrib

Re: Deleting large table and the correct log buffer size

[Vasu Ramasamy]

Hi Kevin,
 What version is your Oracle server? The tablespace in which the table uses
'dictionary managed' or 'locally managed' ?

  Ours is loaclly managed TS -  Oracle 8.1.7

  Thanks

Vasu

Kevin Lange wrote:

> WE had a similar bad response when deleting from a 16 million row table.
> Due to certain circumastances we were unable to truncate ... only delete.
>
> We found 2 things that caused the big slowdown.
>   1) Archiving.  Logging all the delete added a small amount of slowdown.
>   2) Extents.  It turned out that table had 8540 extents (I know ... it was
> one reason were were rebuilding it).  That many extents causes a very big
> strain on things.
>
> We ended up rebuilding it twice.  The first time , the delete litterally
> took hours.   The second time (After the extent problem was taken care of),
> the delete took minutes.
>
> I am curious as to how many extents that table has.
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:35 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi Jared,
>  Our developers are expecting it to be equivalent Sybase response time
> which is less than 2 minutes. We are
> moving from Sybase to Oracle. But Oracle beats Sybase response time in all
> other SQL queries. I was trying to see
> whether any incorrect init params are set.
>
>Thanks
>
> Vasu
>
> [EMAIL PROTECTED] wrote:
>
> > Personally, I'd be pretty happy with a 400K row delete
> > only taking 10 minutes.
> >
> > Jared
> >
> > "Vasu Ramasamy" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 06/26/2002 09:49 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject:Deleting large table and the correct log buffer
> size
> >
> > Hello Gurus,
> >   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> > the process of conversion. I have a problem in deleting a large number
> > of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> > complete and sometimes hogs system. It is a simple delete statement,
> > delete all rows. We do not want to use truncate statement. I try to find
> > why it is taking so much time by checking the wait events. The session
> > event wait statistics is provided below.
> >
> > SIDEVENT
> > TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
> >
> 
> --
> >
> > AVERAGE_WAIT  MAX_WAIT
> > --
> > 27latch
> > free
> > 1010 20
> >2 2
> >
> > 27log buffer
> > space
> > 298   271  29267
> >   98.2114094   104
> >
> > 27log file switch
> > completion   11
> > 10   1069
> >   97.1818182   103
> >
> > 27log file
> > sync
> > 3 2221
> >   73.667   103
> >
> > 27db file sequential
> > read3222
> > 0   7695
> >   2.38826816   589
> >
> > 27db file scattered
> > read  271
> > 0493
> >   1.81918819   236
> >
> > 27file
> > open
> > 4 0  0
> >0 0
> >
> >The log_buffer_space wait event looks like is the culprit with
> > total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> > of a second). Are these normal values for this wait event? The log
> > buffer init param is set to 20MB. To set up the init params, we took the
> > advice of the consultant DBA who worked for a short time (6 months) to
> > help us to set up servers. While I was going through the DBA hand books,
> > ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> > it clearly says that setting higher value will cause trouble. He
> > recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> > for log_buffer_space just doubles.
> >
> >Can you please advice me what should be the correct size for log
> > buffer?
> >Do you see any problem with wait stats provided above?
> >
> >   If you need further details, let me know please.
> >
> >Thanks
> >
> > Vasu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
>
> 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: [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).


begin:vcard 
n:Ramasamy;Vasu 

performance over db links

[Kathy Duret]

Anyone have/know of a good way to check performance over dblinks?

Kathy
I don't know about anyone else, but I am looking forward to the long 4th of July 
weekend.

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Adams, Matthew (GEA, MABG, 088130)]

Title: RE: the ora certified masters cert, yet again





Right now, I think Susan has me from 1-2, right after
lunch, but I'm not sure. The OOUG web site is a 
little sparse on details.





Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: the ora certified masters cert, yet again



But Mtt... you were always scheduled at either the same
time *I* was presenting (trust me, I'd rather have gone to yours, I get
stage fright) or when at LEAST 2 other presentations I wanted to see
equally as much were there.


Um, what time are you presenting at OOUG? My flight home is at 5, I
have to leave around 2:30 or so




--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> But Rachel, you never came to any of my 
> presentations!  (in my best whiney voice)
> 
> At least you'll get to see me present in July at OOUG.
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> that's 'cause you present well and have knowledge
> 
> or.. to quote one of my favorite shows:
> 
> "he has much knowledge. we must build an altar and worship him"
> 
> 
> :)
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > Actually, I had to miss this years (even though I was orginally
> > schedule
> > to give two presentations)  due to a medical situation.  I gave
> four
> > the
> > year
> > before that.  
> >  
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence? 
> > 
> >  
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 1:09 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > OK.  As the DBA Focus Area Manager for the IOUG, we do our best to
> > weed out
> > the fluff.  If you were at IOUG this year, you should have noticed
> a
> > significant reduction in the marketing fluff and more technical
> > content.
> > Yes, some showmanship is necessary when giving a presentation, but
> > the
> > content has to be there.
> > 
> >  
> > 
> > Many people on this forum have submitted presentations to my track
> > and then
> > complained that they were not accepted.  Let me give you some
> > concrete
> > numbers.  This year, we received over 400 abstracts for the DBA
> track
> > alone
> > and accepted only 80.  If one slips through the cracks, it won't a
> > second
> > time.  Believe me when I say that 2002 was the best
> content-organized
> > IOUG.
> > 
> > 
> >  
> > 
> > Further comments?  Submit an abstract for 2003 and find out!!!
> > 
> >  
> > 
> > Thank You
> > 
> >  
> > 
> > Stephen P. Karniotis
> > 
> > Product Architect
> > 
> > Compuware Corporation
> > 
> > Direct:   (248) 865-4350
> > 
> > Mobile:  (248) 408-2918
> > 
> > Email:  [EMAIL PROTECTED]
> > 
> > Web:    www.compuware.com
> > 
> >  
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 12:39 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> >  
> > 
> > unfortunately, I've seen this to be true at 
> > many conferences, including the IOUG 
> > and SEOUC. 
> > 
> >  
> > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > "Doing linear scans over an associative array is like 
> > trying to club someone to death with a loaded Uzi." 
> > - Larry Wall (creator of Perl) 
> > 
> > -Original Message- 
> >  ] 
> > Sent: Wednesday, June 26, 2002 11:54 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> >  
> > 
> > I'll bet a dynamic animated speaker chockful of amusing anecdotes
> > whose
> > presentation is technically weak scores better than a plodding
> > monotonous
> > one with better information to convey :)  Especialy if the audience
> > is
> > composed of nascent DBA's :)
> > 
> > Ian MacGregor 
> > Stanford Linear Accelerator Center 
> > [EMAIL PROTECTED] 
> > 
> > -Original Message- 
> > Sent: Tuesday, June 25, 2002 5:09 PM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> >  
> > 
> > one being a marketing venue, the other being a place where you can 
> > learn from ohers experiences. 
> > 
> > and to clarify further, if you are a lousy presenter, giving bad 
> > information, you get horrible scores and, since the selection
> process
> > 
> > is not blind, don't get asked back to present again. 
> > 
> > So having a list of many presentations, at various conferences, can
> > be 
> > an indicator of knowledge. 
> > 
> >  
> > 
> > --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: 
> > > Let me clarify something.  It was at Oracle O

conferences - IOUG vs OOW

[Magaliff, Bill]

Having never been to either and wanting to plan for one, am I to infer from
some of this discussion that for real content (as opposed to marketing
fluff), THE conference to attend would be IOUGLive, as opposed to Oracle
Open World?  

-bill
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [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: Deleting large table and the correct log buffer size

[Kevin Lange]

WE had a similar bad response when deleting from a 16 million row table.
Due to certain circumastances we were unable to truncate ... only delete.

We found 2 things that caused the big slowdown.
  1) Archiving.  Logging all the delete added a small amount of slowdown.
  2) Extents.  It turned out that table had 8540 extents (I know ... it was
one reason were were rebuilding it).  That many extents causes a very big
strain on things.   

We ended up rebuilding it twice.  The first time , the delete litterally
took hours.   The second time (After the extent problem was taken care of),
the delete took minutes.

I am curious as to how many extents that table has.

-Original Message-
Sent: Wednesday, June 26, 2002 3:35 PM
To: Multiple recipients of list ORACLE-L


Hi Jared,
 Our developers are expecting it to be equivalent Sybase response time
which is less than 2 minutes. We are
moving from Sybase to Oracle. But Oracle beats Sybase response time in all
other SQL queries. I was trying to see
whether any incorrect init params are set.

   Thanks

Vasu

[EMAIL PROTECTED] wrote:

> Personally, I'd be pretty happy with a 400K row delete
> only taking 10 minutes.
>
> Jared
>
> "Vasu Ramasamy" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/26/2002 09:49 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Deleting large table and the correct log buffer
size
>
> Hello Gurus,
>   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> the process of conversion. I have a problem in deleting a large number
> of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> complete and sometimes hogs system. It is a simple delete statement,
> delete all rows. We do not want to use truncate statement. I try to find
> why it is taking so much time by checking the wait events. The session
> event wait statistics is provided below.
>
> SIDEVENT
> TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
>

--
>
> AVERAGE_WAIT  MAX_WAIT
> --
> 27latch
> free
> 1010 20
>2 2
>
> 27log buffer
> space
> 298   271  29267
>   98.2114094   104
>
> 27log file switch
> completion   11
> 10   1069
>   97.1818182   103
>
> 27log file
> sync
> 3 2221
>   73.667   103
>
> 27db file sequential
> read3222
> 0   7695
>   2.38826816   589
>
> 27db file scattered
> read  271
> 0493
>   1.81918819   236
>
> 27file
> open
> 4 0  0
>0 0
>
>The log_buffer_space wait event looks like is the culprit with
> total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> of a second). Are these normal values for this wait event? The log
> buffer init param is set to 20MB. To set up the init params, we took the
> advice of the consultant DBA who worked for a short time (6 months) to
> help us to set up servers. While I was going through the DBA hand books,
> ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> it clearly says that setting higher value will cause trouble. He
> recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> for log_buffer_space just doubles.
>
>Can you please advice me what should be the correct size for log
> buffer?
>Do you see any problem with wait stats provided above?
>
>   If you need further details, let me know please.
>
>Thanks
>
> Vasu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [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: Deleting large table and the correct log buffer size

[Greg Moore]

If you have purchased the partitioning option, you may be able to partition
the table in a way that will allow you to drop the partition that contains
all the rows you want to delete.  It's much faster to drop a partition
containing 400K rows than to delete 400K rows.

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

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: [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:

[Loughmiller, Greg]

the "little red button" is my favorite

-Original Message-
Sent: Wednesday, June 26, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L


try: Ctl-Alt-Del.  Works wonders.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 1:33 AM


> press F1 first, then ask more
> 
> > -Original Message-
> > From: Ravindra B [mailto:[EMAIL PROTECTED]] 
> > Sent: Wednesday, June 26, 2002 8:08 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 
> > 
> > 
> > HELP
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Ravindra B
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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.com
> -- 
> Author: BELOV
>   INET: [EMAIL PROTECTED]
> 
> 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: [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.com
-- 
Author: Sunrise DBA
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Loughmiller, Greg
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

But Mtt... you were always scheduled at either the same
time *I* was presenting (trust me, I'd rather have gone to yours, I get
stage fright) or when at LEAST 2 other presentations I wanted to see
equally as much were there.

Um, what time are you presenting at OOUG? My flight home is at 5, I
have to leave around 2:30 or so



--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> But Rachel, you never came to any of my 
> presentations!  (in my best whiney voice)
> 
> At least you'll get to see me present in July at OOUG.
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence?
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 3:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> that's 'cause you present well and have knowledge
> 
> or.. to quote one of my favorite shows:
> 
> "he has much knowledge. we must build an altar and worship him"
> 
> 
> :)
> 
> 
> --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
> wrote:
> > Actually, I had to miss this years (even though I was orginally
> > schedule
> > to give two presentations)  due to a medical situation.  I gave
> four
> > the
> > year
> > before that.  
> >  
> > 
> > 
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > We have enough youth.
> > How about a fountain of intelligence? 
> > 
> >  
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 1:09 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > OK.  As the DBA Focus Area Manager for the IOUG, we do our best to
> > weed out
> > the fluff.  If you were at IOUG this year, you should have noticed
> a
> > significant reduction in the marketing fluff and more technical
> > content.
> > Yes, some showmanship is necessary when giving a presentation, but
> > the
> > content has to be there.
> > 
> >  
> > 
> > Many people on this forum have submitted presentations to my track
> > and then
> > complained that they were not accepted.  Let me give you some
> > concrete
> > numbers.  This year, we received over 400 abstracts for the DBA
> track
> > alone
> > and accepted only 80.  If one slips through the cracks, it won't a
> > second
> > time.  Believe me when I say that 2002 was the best
> content-organized
> > IOUG.
> > 
> > 
> >  
> > 
> > Further comments?  Submit an abstract for 2003 and find out!!!
> > 
> >  
> > 
> > Thank You
> > 
> >  
> > 
> > Stephen P. Karniotis
> > 
> > Product Architect
> > 
> > Compuware Corporation
> > 
> > Direct:   (248) 865-4350
> > 
> > Mobile:  (248) 408-2918
> > 
> > Email:  [EMAIL PROTECTED]
> > 
> > Web:www.compuware.com
> > 
> >  
> > 
> > -Original Message-
> > Sent: Wednesday, June 26, 2002 12:39 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> >  
> > 
> > unfortunately, I've seen this to be true at 
> > many conferences, including the IOUG 
> > and SEOUC. 
> > 
> >  
> > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > "Doing linear scans over an associative array is like 
> > trying to club someone to death with a loaded Uzi." 
> > - Larry Wall (creator of Perl) 
> > 
> > -Original Message- 
> >  ] 
> > Sent: Wednesday, June 26, 2002 11:54 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> >  
> > 
> > I'll bet a dynamic animated speaker chockful of amusing anecdotes
> > whose
> > presentation is technically weak scores better than a plodding
> > monotonous
> > one with better information to convey :)  Especialy if the audience
> > is
> > composed of nascent DBA's :)
> > 
> > Ian MacGregor 
> > Stanford Linear Accelerator Center 
> > [EMAIL PROTECTED] 
> > 
> > -Original Message- 
> > Sent: Tuesday, June 25, 2002 5:09 PM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> >  
> > 
> > one being a marketing venue, the other being a place where you can 
> > learn from ohers experiences. 
> > 
> > and to clarify further, if you are a lousy presenter, giving bad 
> > information, you get horrible scores and, since the selection
> process
> > 
> > is not blind, don't get asked back to present again. 
> > 
> > So having a list of many presentations, at various conferences, can
> > be 
> > an indicator of knowledge. 
> > 
> >  
> > 
> > --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: 
> > > Let me clarify something.  It was at Oracle Open World, not
> IOUG-A 
> > > Live 
> > > where these presentations were made.  Please do not confuse the
> > two!! 
> > > 
> > > Thank You 
> > > 
> > > Stephen P. Karniotis 
> > > Product Architect 
> > > Compuware Corporation 
> > > Direct:   (248) 865-4350 
> > > Mobile:   (248) 408-2918 
> > > Email:[EMAIL PROTECTED] 
> > > Web:  www.compuware.com 
> > > 
> > >  -Original Message- 
> > > Sent: Tuesday, June 25, 2002 5:41 PM 
> > > To:   Multiple recipients of list ORACLE-L 
> > > Subject

RE: Deleting large table and the correct log buffer size

[Weaver, Walt]

Being a non-certified MySQL DBA, I can assure you that delete performance in
Oracle is VERY disappointing if you've transitioned over from MySQL.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, June 26, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


Good point, Jared. A thought occurs to me. Is it possible the Sybase
architecture lends itself to deletes more than the Oracle architecture. As
you study the Oracle architecture you note several places where Oracle is
tuned for high insert/update performance at the expense of the delete
performance. Perhaps someone on the list with experience in both Oracle and
Sybase can comment on whether Sybase is faster at deletes. If that is true,
I could see a DBA coming from a Sybase background might expect Oracle
deletes to be much faster, while those of us who have only Oracle experience
might have a different expectation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 3:06 PM
To: Multiple recipients of list ORACLE-L


Personally, I'd be pretty happy with a 400K row delete
only taking 10 minutes.

Jared





"Vasu Ramasamy" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Deleting large table and the correct log buffer size


Hello Gurus,
  Ours is  basically a Sybase shop. But moving towards Oracle. We are in
the process of conversion. I have a problem in deleting a large number
of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
complete and sometimes hogs system. It is a simple delete statement,
delete all rows. We do not want to use truncate statement. I try to find
why it is taking so much time by checking the wait events. The session
event wait statistics is provided below.


SIDEVENT
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED

--

AVERAGE_WAIT  MAX_WAIT
--
27latch
free
1010 20
   2 2

27log buffer
space
298   271  29267
  98.2114094   104

27log file switch
completion   11
10   1069
  97.1818182   103

27log file
sync
3 2221
  73.667   103

27db file sequential
read3222
0   7695
  2.38826816   589

27db file scattered
read  271
0493
  1.81918819   236

27file
open
4 0  0
   0 0


   The log_buffer_space wait event looks like is the culprit with
total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
of a second). Are these normal values for this wait event? The log
buffer init param is set to 20MB. To set up the init params, we took the
advice of the consultant DBA who worked for a short time (6 months) to
help us to set up servers. While I was going through the DBA hand books,
( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
it clearly says that setting higher value will cause trouble. He
recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
for log_buffer_space just doubles.

   Can you please advice me what should be the correct size for log
buffer?
   Do you see any problem with wait stats provided above?

  If you need further details, let me know please.

   Thanks

Vasu


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

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: [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.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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: [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: privileges and synonyms and dblinks

[Srinivas]

Hi, 
Can someone please explain what is happening in this
case.

I created link lnkAB from instA to instB, it is a
private db link. with username and password in the
link.

And then I created a synonym syntableX
(not public) on the [EMAIL PROTECTED]

Now I tried desc syntableX at my instanceA, you wont
believe the process hung forever. I couldnt even kill
the the session from system.

I tried created tableXdest as select * from synTableX
(process frozen). Couldnt kill it.

I tried created tableXdest as select * from
[EMAIL PROTECTED] (process frozen). Couldnt kill it.

I found on metalink
create table tableXdest UNRECOVERABLE as select * from
synTableX. Worked fine. No problems.

to do a Desc synTableX I created a view 
"create view tview as select * from synTableX". Do 
Desc tview. Works just fine. 


I couldnt understand what was happening in the above
scenario. Could someone please explain. Using 8.1.7.on
unix


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED]

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: [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).

report showing free space per tablespace over time

[Jack Silvey]

Listers,

Ever been asked how much free space you have in the
tablespaces over time? I wrote a tool that tracks and
reports on free space per tablespace over time and
thought I would share it.

It consists of a simple stored procedure that stores
values in a holding table and a report that will tell
you how much each tablespace had over the past week
(you can change the coverage of this report.)

1) Here is the stored procedure:

CREATE OR REPLACE PROCEDURE 
tablespace_proc AS

v_errmsg varchar2(100);
v_errcode varchar2(100);
   
BEGIN

delete dbmon.dbmon_tablespace_stats
where trunc(record_date) = trunc(sysdate);


INSERT INTO dbmon.dbmon_tablespace_stats

(tablespace_name, 
total_space, 
megs_free, 
max_extent, 
autoextend,
record_date)

SELECT
fs.tablespace_name,
round(df.total_bytes/1024/1024,0),
round(fs.bytes_free/1024/1024,0),
round(fs.max_bytes/1024/1024,0),
decode(a.tablespace_name,null,'No','Yes'),
sysdate
FROM
(SELECT
tablespace_name,
SUM(bytes) bytes_free,
max(bytes) max_bytes
FROM
dba_free_space fs
GROUP BY
tablespace_name) fs,
(SELECT
tablespace_name,
sum(bytes) total_bytes
FROM
dba_data_files
GROUP BY 
tablespace_name) df,
(SELECT DISTINCT
tablespace_name
FROM
dba_data_files
WHERE
autoextensible = 'YES') a,
(select tablespace_name
from dba_tablespaces) ts
WHERE
df.tablespace_name = fs.tablespace_name(+)
AND
df.tablespace_name = a.tablespace_name(+)
AND 
df.tablespace_name = ts.tablespace_name;

commit;

exception

when others then

v_errmsg := substr(SQLERRM,1,100);
v_errcode := SQLCODE;

insert into dbmon_activity_log
(activity_date,
activity_desc,
procedure_name,
error_code,
error_msg,
error_date)
values
(sysdate,
'tablespace_proc',
'tablespace_proc',
v_errcode,
v_errmsg,
sysdate);
commit;

end;
/



2) Here is the code to submit it to the job scheduler
(every day at 5AM):

variable jobno number

exec sys.dbms_job.submit(job=>:jobno, what=>'begin
dbmon.dbmon_tablespace_proc;end;',
next_date=>trunc(sysdate+1)+5/24,interval=>'trunc(sysdate+1)+5/24');

3)  and here is the report:


@save_sqlplus_settings

set term off

set head off

spool temp.sql 

select 'col c'||rownum ||' for 999,999,990 head "'|| 
to_char(sysdate+1-rownum,'dd-mon')||'"' 
from dba_tablespaces where rownum<8; 

select 'compute sum of c'||rownum ||' on report'
from dba_tablespaces where rownum<8; 

select 'break on report' from dual; 

spool off 

@temp.sql 

exec dbmon.dbmon_tablespace_proc;

set term on
set lines 135


prompt
prompt Free space per tablespace:
prompt


select tablespace_name, 
sum(decode(old,7,value)) c7,
sum(decode(old,6,value)) c6,
sum(decode(old,5,value)) c5,
sum(decode(old,4,value)) c4,
sum(decode(old,3,value)) c3,
sum(decode(old,2,value)) c2,
sum(decode(old,1,value)) c1
from
(select tablespace_name, 
megs_free value, 
decode 
(trunc(record_date),
trunc(sysdate),1,
trunc(sysdate)-1,2,
trunc(sysdate)-2,3,
trunc(sysdate)-3,4,
trunc(sysdate)-4,5,
trunc(sysdate)-5,6,
trunc(sysdate)-6,7) old
from 
dbmon.dbmon_tablespace_stats)
group by tablespace_name
order by 1
/ 

good luck,

Jack


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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: [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: sql difference rounds

[kkennedy]

Hi Debi,
I ran your script on my system and did not have the rounding problem (sqlplus 
8.1.7.0.0 running on W2K against an 8.1.7.3.0 database on Solaris).

Maybe you can try this query instead:

select t.tablespace_name
, t.total_bytes
, u.used_bytes
, t.total_bytes-u.used_bytes space_left
from (select tablespace_name, sum(bytes) total_bytes
  from dba_data_files
  group by tablespace_name) t
   , (select tablespace_name, sum(bytes) used_bytes
  from dba_extents
  group by tablespace_name) u
where t.tablespace_name=u.tablespace_name
and t.tablespace_name=&1
/

HTH
Kevin Kennedy
First Point Energy Corporation 
-Original Message-
Sent: Wednesday, June 26, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L


Why is my difference rounded:

'Checking space left in data_ts:'

  TOTAL_BYTES 

 

   18,880,659,456 


   USED_BYTES 

 

   17,796,554,752 

  Space 
Left
 

1,000,000,000 


Here's my script:

set heading on verify off
col total_bytes format 999,999,999,999,999 new_value tbytes
col tbytes format 999,999,999,999,999
col used_bytes format 999,999,999,999,999 new_value ubytes
col ubytes format 999,999,999,999,999
col space_left format 999,999,999,999,999 head 'Space Left'

spool space_left
prompt
prompt 'Checking space left in &1:'
prompt
select sum(t.bytes) total_bytes
from dba_data_files t
where t.tablespace_name = upper('&&1')
/
select sum(u.bytes) used_bytes
from dba_extents u
where u.tablespace_name = upper('&&1')
/
select (&&tbytes) - (&&ubytes) space_left
from dual
/

Thanks,

Debi

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

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: [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.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

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: [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: Deleting large table and the correct log buffer size

[DENNIS WILLIAMS]

Good point, Jared. A thought occurs to me. Is it possible the Sybase
architecture lends itself to deletes more than the Oracle architecture. As
you study the Oracle architecture you note several places where Oracle is
tuned for high insert/update performance at the expense of the delete
performance. Perhaps someone on the list with experience in both Oracle and
Sybase can comment on whether Sybase is faster at deletes. If that is true,
I could see a DBA coming from a Sybase background might expect Oracle
deletes to be much faster, while those of us who have only Oracle experience
might have a different expectation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 3:06 PM
To: Multiple recipients of list ORACLE-L


Personally, I'd be pretty happy with a 400K row delete
only taking 10 minutes.

Jared





"Vasu Ramasamy" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Deleting large table and the correct log buffer size


Hello Gurus,
  Ours is  basically a Sybase shop. But moving towards Oracle. We are in
the process of conversion. I have a problem in deleting a large number
of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
complete and sometimes hogs system. It is a simple delete statement,
delete all rows. We do not want to use truncate statement. I try to find
why it is taking so much time by checking the wait events. The session
event wait statistics is provided below.


SIDEVENT
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED

--

AVERAGE_WAIT  MAX_WAIT
--
27latch
free
1010 20
   2 2

27log buffer
space
298   271  29267
  98.2114094   104

27log file switch
completion   11
10   1069
  97.1818182   103

27log file
sync
3 2221
  73.667   103

27db file sequential
read3222
0   7695
  2.38826816   589

27db file scattered
read  271
0493
  1.81918819   236

27file
open
4 0  0
   0 0


   The log_buffer_space wait event looks like is the culprit with
total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
of a second). Are these normal values for this wait event? The log
buffer init param is set to 20MB. To set up the init params, we took the
advice of the consultant DBA who worked for a short time (6 months) to
help us to set up servers. While I was going through the DBA hand books,
( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
it clearly says that setting higher value will cause trouble. He
recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
for log_buffer_space just doubles.

   Can you please advice me what should be the correct size for log
buffer?
   Do you see any problem with wait stats provided above?

  If you need further details, let me know please.

   Thanks

Vasu


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

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: [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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[MacGregor, Ian A.]

Actually no one who has been holds any SCI tickets can admit to doing so :)  One can 
say you have been the subject of a Special Backgroud Investigation, and Extensive 
Background Investigation, a Full Field Investigation even though 99. times out of 
100 these investigations are done for just such access.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L


I suspect that this position will be at Wright-Patterson Air Force base.

OraStaff wrote:
> 
> Position: Oracle DBA with Top Secret SCI Clearance
>   (Please do not send your resume unless you have the required
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [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: Deleting large table and the correct log buffer size

[Vasu Ramasamy]

Hi Jared,
 Our developers are expecting it to be equivalent Sybase response time which is 
less than 2 minutes. We are
moving from Sybase to Oracle. But Oracle beats Sybase response time in all other SQL 
queries. I was trying to see
whether any incorrect init params are set.

   Thanks

Vasu

[EMAIL PROTECTED] wrote:

> Personally, I'd be pretty happy with a 400K row delete
> only taking 10 minutes.
>
> Jared
>
> "Vasu Ramasamy" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/26/2002 09:49 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Deleting large table and the correct log buffer size
>
> Hello Gurus,
>   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> the process of conversion. I have a problem in deleting a large number
> of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> complete and sometimes hogs system. It is a simple delete statement,
> delete all rows. We do not want to use truncate statement. I try to find
> why it is taking so much time by checking the wait events. The session
> event wait statistics is provided below.
>
> SIDEVENT
> TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
> 
>--
>
> AVERAGE_WAIT  MAX_WAIT
> --
> 27latch
> free
> 1010 20
>2 2
>
> 27log buffer
> space
> 298   271  29267
>   98.2114094   104
>
> 27log file switch
> completion   11
> 10   1069
>   97.1818182   103
>
> 27log file
> sync
> 3 2221
>   73.667   103
>
> 27db file sequential
> read3222
> 0   7695
>   2.38826816   589
>
> 27db file scattered
> read  271
> 0493
>   1.81918819   236
>
> 27file
> open
> 4 0  0
>0 0
>
>The log_buffer_space wait event looks like is the culprit with
> total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> of a second). Are these normal values for this wait event? The log
> buffer init param is set to 20MB. To set up the init params, we took the
> advice of the consultant DBA who worked for a short time (6 months) to
> help us to set up servers. While I was going through the DBA hand books,
> ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> it clearly says that setting higher value will cause trouble. He
> recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> for log_buffer_space just doubles.
>
>Can you please advice me what should be the correct size for log
> buffer?
>Do you see any problem with wait stats provided above?
>
>   If you need further details, let me know please.
>
>Thanks
>
> Vasu


begin:vcard 
n:Ramasamy;Vasu 
tel;fax:650 859 3668
tel;work:650 859 4818
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Principal Database Administrator
fn:Vasu Ramasamy
end:vcard

Re: Deleting large table and the correct log buffer size

[Vasu Ramasamy]

Hi kirti,
My responses are embedded in your message.

   Thanks

Vasu



"Deshpande, Kirti" wrote:

> Are the disks housing redo logs contain other 'hot' files? Are these disks
> busy with other tasks (than writing redo logs).

  No. Though there are db files in its disks, they are not that active.
More over, the server where I perform this test is totally quiet.


> Are you committing too
> often?

No. There is only one commit after the delete statement.


> How many log switches are taking place?

 10 or 11 switches


> What is the size of the redo
> log file?

 100MB


> May be increasing it may help.
>
> What is the redo size per commit?
> Use this query to find out RSPC:
> select r.value / decode (c.value, 0, 1, c.value) RSPC
>  from v$sysstat r, v$sysstat c
>  where r.name = 'redo size'
>and c.name = 'user commits';
> You can use RSPC to size log buffer by multiplying it by number of user
> commits per second.
>

1104361.8003

>
> HTH,
>
> - Kirti
>
> -Original Message-
> Sent: Wednesday, June 26, 2002 11:49 AM
> To: Multiple recipients of list ORACLE-L
>
> Hello Gurus,
>   Ours is  basically a Sybase shop. But moving towards Oracle. We are in
> the process of conversion. I have a problem in deleting a large number
> of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
> complete and sometimes hogs system. It is a simple delete statement,
> delete all rows. We do not want to use truncate statement. I try to find
> why it is taking so much time by checking the wait events. The session
> event wait statistics is provided below.
>
> SIDEVENT
> TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
> 
> --
>
> AVERAGE_WAIT  MAX_WAIT
> --
> 27latch
> free
> 1010 20
>2 2
>
> 27log buffer
> space
> 298   271  29267
>   98.2114094   104
>
> 27log file switch
> completion   11
> 10   1069
>   97.1818182   103
>
> 27log file
> sync
> 3 2221
>   73.667   103
>
> 27db file sequential
> read3222
> 0   7695
>   2.38826816   589
>
> 27db file scattered
> read  271
> 0493
>   1.81918819   236
>
> 27file
> open
> 4 0  0
>0 0
>
>The log_buffer_space wait event looks like is the culprit with
> total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
> of a second). Are these normal values for this wait event? The log
> buffer init param is set to 20MB. To set up the init params, we took the
> advice of the consultant DBA who worked for a short time (6 months) to
> help us to set up servers. While I was going through the DBA hand books,
> ( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
> it clearly says that setting higher value will cause trouble. He
> recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
> for log_buffer_space just doubles.
>
>Can you please advice me what should be the correct size for log
> buffer?
>Do you see any problem with wait stats provided above?
>
>   If you need further details, let me know please.
>
>Thanks
>
> Vasu
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> 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: [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).


begin:vcard 
n:Ramasamy;Vasu 
tel;fax:650 859 3668
tel;work:650 859 4818
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Principal Database Administrator
fn:Vasu Ramasamy
end:vcard

Re:

[Sunrise DBA]

try: Ctl-Alt-Del.  Works wonders.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 1:33 AM


> press F1 first, then ask more
> 
> > -Original Message-
> > From: Ravindra B [mailto:[EMAIL PROTECTED]] 
> > Sent: Wednesday, June 26, 2002 8:08 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 
> > 
> > 
> > HELP
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Ravindra B
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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.com
> -- 
> Author: BELOV
>   INET: [EMAIL PROTECTED]
> 
> 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: [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.com
-- 
Author: Sunrise DBA
  INET: [EMAIL PROTECTED]

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: [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: What Attributes are available to a Trigger

[johanna . doran]

Hi,

This should work.  But I took the messier approach (I have 8i) and created before 
insert/update/delete triggers on the suspect tables.  I am testing in a schema on an 
instance where there is alot of activity on the other schemas.  

BUT, I will look into further for future use.  

Thanks,

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

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: [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: the ora certified masters cert, yet again

[Adams, Matthew (GEA, MABG, 088130)]

Title: RE: the ora certified masters cert, yet again





But Rachel, you never came to any of my 
presentations!  (in my best whiney voice)


At least you'll get to see me present in July at OOUG.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 3:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: the ora certified masters cert, yet again



that's 'cause you present well and have knowledge


or.. to quote one of my favorite shows:


"he has much knowledge. we must build an altar and worship him"



:)



--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Actually, I had to miss this years (even though I was orginally
> schedule
> to give two presentations)  due to a medical situation.  I gave four
> the
> year
> before that.  
>  
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence? 
> 
>  
> -Original Message-
> Sent: Wednesday, June 26, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> OK.  As the DBA Focus Area Manager for the IOUG, we do our best to
> weed out
> the fluff.  If you were at IOUG this year, you should have noticed a
> significant reduction in the marketing fluff and more technical
> content.
> Yes, some showmanship is necessary when giving a presentation, but
> the
> content has to be there.
> 
>  
> 
> Many people on this forum have submitted presentations to my track
> and then
> complained that they were not accepted.  Let me give you some
> concrete
> numbers.  This year, we received over 400 abstracts for the DBA track
> alone
> and accepted only 80.  If one slips through the cracks, it won't a
> second
> time.  Believe me when I say that 2002 was the best content-organized
> IOUG.
> 
> 
>  
> 
> Further comments?  Submit an abstract for 2003 and find out!!!
> 
>  
> 
> Thank You
> 
>  
> 
> Stephen P. Karniotis
> 
> Product Architect
> 
> Compuware Corporation
> 
> Direct:   (248) 865-4350
> 
> Mobile:  (248) 408-2918
> 
> Email:  [EMAIL PROTECTED]
> 
> Web:    www.compuware.com
> 
>  
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 12:39 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> unfortunately, I've seen this to be true at 
> many conferences, including the IOUG 
> and SEOUC. 
> 
>  
> Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> "Doing linear scans over an associative array is like 
> trying to club someone to death with a loaded Uzi." 
> - Larry Wall (creator of Perl) 
> 
> -Original Message- 
>  ] 
> Sent: Wednesday, June 26, 2002 11:54 AM 
> To: Multiple recipients of list ORACLE-L 
> 
>  
> 
> I'll bet a dynamic animated speaker chockful of amusing anecdotes
> whose
> presentation is technically weak scores better than a plodding
> monotonous
> one with better information to convey :)  Especialy if the audience
> is
> composed of nascent DBA's :)
> 
> Ian MacGregor 
> Stanford Linear Accelerator Center 
> [EMAIL PROTECTED] 
> 
> -Original Message- 
> Sent: Tuesday, June 25, 2002 5:09 PM 
> To: Multiple recipients of list ORACLE-L 
> 
>  
> 
> one being a marketing venue, the other being a place where you can 
> learn from ohers experiences. 
> 
> and to clarify further, if you are a lousy presenter, giving bad 
> information, you get horrible scores and, since the selection process
> 
> is not blind, don't get asked back to present again. 
> 
> So having a list of many presentations, at various conferences, can
> be 
> an indicator of knowledge. 
> 
>  
> 
> --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: 
> > Let me clarify something.  It was at Oracle Open World, not IOUG-A 
> > Live 
> > where these presentations were made.  Please do not confuse the
> two!! 
> > 
> > Thank You 
> > 
> > Stephen P. Karniotis 
> > Product Architect 
> > Compuware Corporation 
> > Direct:   (248) 865-4350 
> > Mobile:   (248) 408-2918 
> > Email:    [EMAIL PROTECTED] 
> > Web:  www.compuware.com 
> > 
> >  -Original Message- 
> > Sent: Tuesday, June 25, 2002 5:41 PM 
> > To:   Multiple recipients of list ORACLE-L 
> > Subject:  RE: the ora certified masters cert, yet again 
> > 
> > A tip o' the hat to all authors and presenters.  However writing a 
> > book 
> > makes no one an expert on anything.  There are Oracle books 
> > containing 
> > fabulous stories of what happens when a tablespace is put in backup
> 
> > mode, 
> > and while quite entertaining they do not further a correct 
> > understanding of 
> > Oracle.  Authors take the time to put what they believe to be true
> on 
> > paper. 
> > It's often what they have been told, not what they have learned on 
> > their 
> > own.  Richard Niemiec's sp? tu

Re: Deleting large table and the correct log buffer size

[Jared . Still]

Personally, I'd be pretty happy with a 400K row delete
only taking 10 minutes.

Jared





"Vasu Ramasamy" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Deleting large table and the correct log buffer size


Hello Gurus,
  Ours is  basically a Sybase shop. But moving towards Oracle. We are in
the process of conversion. I have a problem in deleting a large number
of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
complete and sometimes hogs system. It is a simple delete statement,
delete all rows. We do not want to use truncate statement. I try to find
why it is taking so much time by checking the wait events. The session
event wait statistics is provided below.


SIDEVENT
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
--

AVERAGE_WAIT  MAX_WAIT
--
27latch
free
1010 20
   2 2

27log buffer
space
298   271  29267
  98.2114094   104

27log file switch
completion   11
10   1069
  97.1818182   103

27log file
sync
3 2221
  73.667   103

27db file sequential
read3222
0   7695
  2.38826816   589

27db file scattered
read  271
0493
  1.81918819   236

27file
open
4 0  0
   0 0


   The log_buffer_space wait event looks like is the culprit with
total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
of a second). Are these normal values for this wait event? The log
buffer init param is set to 20MB. To set up the init params, we took the
advice of the consultant DBA who worked for a short time (6 months) to
help us to set up servers. While I was going through the DBA hand books,
( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
it clearly says that setting higher value will cause trouble. He
recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
for log_buffer_space just doubles.

   Can you please advice me what should be the correct size for log
buffer?
   Do you see any problem with wait stats provided above?

  If you need further details, let me know please.

   Thanks

Vasu





vasu.ramasamy.vcf
Description: Binary data

Re: MTS performance is too bad.

[Jared . Still]

Change back to dedicated servers.

Jared





"Bunyamin Karadeniz" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:MTS performance is too bad.


I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is 
too bad. 
I have 800 MB of shared pool and not setted large_pool_size. 
50 dispathers, 100 processes and 750 max processes. 
 
What can I do ?  Have you got an idea. How can I check the mts 
performance?
 
Bunyamin 


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

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: [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: the ora certified masters cert, yet again

[Rachel Carmichael]

that's 'cause you present well and have knowledge

or.. to quote one of my favorite shows:

"he has much knowledge. we must build an altar and worship him"


:)


--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> Actually, I had to miss this years (even though I was orginally
> schedule
> to give two presentations)  due to a medical situation.  I gave four
> the
> year
> before that.  
>  
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> We have enough youth.
> How about a fountain of intelligence? 
> 
>  
> -Original Message-
> Sent: Wednesday, June 26, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> OK.  As the DBA Focus Area Manager for the IOUG, we do our best to
> weed out
> the fluff.  If you were at IOUG this year, you should have noticed a
> significant reduction in the marketing fluff and more technical
> content.
> Yes, some showmanship is necessary when giving a presentation, but
> the
> content has to be there.
> 
>  
> 
> Many people on this forum have submitted presentations to my track
> and then
> complained that they were not accepted.  Let me give you some
> concrete
> numbers.  This year, we received over 400 abstracts for the DBA track
> alone
> and accepted only 80.  If one slips through the cracks, it won't a
> second
> time.  Believe me when I say that 2002 was the best content-organized
> IOUG.
> 
> 
>  
> 
> Further comments?  Submit an abstract for 2003 and find out!!!
> 
>  
> 
> Thank You
> 
>  
> 
> Stephen P. Karniotis
> 
> Product Architect
> 
> Compuware Corporation
> 
> Direct:   (248) 865-4350
> 
> Mobile:  (248) 408-2918
> 
> Email:  [EMAIL PROTECTED]
> 
> Web:www.compuware.com
> 
>  
> 
> -Original Message-
> Sent: Wednesday, June 26, 2002 12:39 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> unfortunately, I've seen this to be true at 
> many conferences, including the IOUG 
> and SEOUC. 
> 
>  
> Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> "Doing linear scans over an associative array is like 
> trying to club someone to death with a loaded Uzi." 
> - Larry Wall (creator of Perl) 
> 
> -Original Message- 
>  ] 
> Sent: Wednesday, June 26, 2002 11:54 AM 
> To: Multiple recipients of list ORACLE-L 
> 
>  
> 
> I'll bet a dynamic animated speaker chockful of amusing anecdotes
> whose
> presentation is technically weak scores better than a plodding
> monotonous
> one with better information to convey :)  Especialy if the audience
> is
> composed of nascent DBA's :)
> 
> Ian MacGregor 
> Stanford Linear Accelerator Center 
> [EMAIL PROTECTED] 
> 
> -Original Message- 
> Sent: Tuesday, June 25, 2002 5:09 PM 
> To: Multiple recipients of list ORACLE-L 
> 
>  
> 
> one being a marketing venue, the other being a place where you can 
> learn from ohers experiences. 
> 
> and to clarify further, if you are a lousy presenter, giving bad 
> information, you get horrible scores and, since the selection process
> 
> is not blind, don't get asked back to present again. 
> 
> So having a list of many presentations, at various conferences, can
> be 
> an indicator of knowledge. 
> 
>  
> 
> --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: 
> > Let me clarify something.  It was at Oracle Open World, not IOUG-A 
> > Live 
> > where these presentations were made.  Please do not confuse the
> two!! 
> > 
> > Thank You 
> > 
> > Stephen P. Karniotis 
> > Product Architect 
> > Compuware Corporation 
> > Direct:   (248) 865-4350 
> > Mobile:   (248) 408-2918 
> > Email:[EMAIL PROTECTED] 
> > Web:  www.compuware.com 
> > 
> >  -Original Message- 
> > Sent: Tuesday, June 25, 2002 5:41 PM 
> > To:   Multiple recipients of list ORACLE-L 
> > Subject:  RE: the ora certified masters cert, yet again 
> > 
> > A tip o' the hat to all authors and presenters.  However writing a 
> > book 
> > makes no one an expert on anything.  There are Oracle books 
> > containing 
> > fabulous stories of what happens when a tablespace is put in backup
> 
> > mode, 
> > and while quite entertaining they do not further a correct 
> > understanding of 
> > Oracle.  Authors take the time to put what they believe to be true
> on 
> > paper. 
> > It's often what they have been told, not what they have learned on 
> > their 
> > own.  Richard Niemiec's sp? tuning books have been trashed recently
> 
> > because 
> > they tout buffer hit ratios; however there was a consensus in the 
> > Oracle 
> > community that these were important.  It took Cary Millsap's paper 
> > and a new 
> > tuning paradigm introduced by Gaja Vaidyanatha, Kirtikumar
> Deshpande, 
> > and 
> > John Kostelac Jr. to direct us to something more useful. 
> Personally, 
> > I was 
> > using wait events before Gaja's book, but I was also trying to keep
> 
> > the hit 
> > ratio's high as a part of the "consensus".  If 

Re: What Attributes are available to a Trigger

[Stephane Faroult]

[EMAIL PROTECTED] wrote:
> 
> Hi,
> 
>I know for example, I can access :new values and :old values.  I also thought 
>that I could access the TYPE of ddl that caused the trigger to fire and I am 
>wondering if I have access to the sql that caused the trigger to fire.
> 
> I am looking in the application development PL/SQL manual but I am not seeing a 
>list anywhere.
> 
> Thanks,
> 
> Hannah


OK, Hannah, if you are running 9i there is a function named ora_sql_txt
which returns (as a table of strings) the text of the SQL statement
which fired a trigger when called within that trigger. It is documented
with triggers on DDL but works with 'standard' triggers too. If you are
on 8.1.7 run the following as SYS, it gives you the same functionality.
Prior to 8.1.7 you will not have the 'bulk collect' and the
ora_name_list_t may not be defined, so there should be a bit of
tinkering but basically it's the same. Adapting the query to 7.3
shouldn't be too difficult either, I can't guarantee it's strictly
identical but it's the first Oracle version I wrote this kind of thing
on, so it can be done.

A word of caution when called in a DDL trigger : you can get the text
for some statements (ALTER TABLE, TRUNCATE) but not for others (CREATE
TABLE, CREATE INDEX - I think that 9i returns it in this case, however).
Nevertheless, RTFMing will point you to the functions which return you
command type and object name, then it's just a nice stroll in the data
dictionary to piece the various bits together. Beware also of some DDL
commands (ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY ...) which fire
the trigger twice (once for the constraint,once for the associated
index) - but return the same statement both times.
 

create or replace function orio$sql_txt (sql_text out ora_name_list_t)
return binary_integer
is
begin
  select a.name
  bulk collect into sql_text
  from x$kglna a,
   x$kglcursor b,
   x$kxscc c
  where c.kxsccsta != 0
and c.kxsccflg like '%/TRG'
and c.kxsccfl2 not like '/EOF/%'
and c.inst_id = sys_context('USERENV', 'INSTANCE')
and c.kxsccphd = b.kglhdadr
and c.inst_id = b.inst_id
and b.kglhdpar = a.kglhdadr
and b.kglnahsh = a.kglnahsh
and b.inst_id = a.inst_id
  order by a.piece;
  return(sql_text.count);
exception
  when no_data_found then
return 0;
end;
/


-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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: [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: the ora certified masters cert, yet again

[Adams, Matthew (GEA, MABG, 088130)]

Title: RE: the ora certified masters cert, yet again



Actually, I had to miss this years (even though I was 
orginally schedule
to 
give two presentations)  due to a medical situation.  I gave four the 
year
before 
that.  
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]We have enough youth.How about a fountain of 
intelligence? 
 
-Original Message-From: Karniotis, Stephen 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 
2002 1:09 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: the ora certified masters cert, yet 
again

OK.  As the DBA Focus Area Manager for the 
IOUG, we do our best to weed out the fluff.  If you were at IOUG this year, you 
should have noticed a significant reduction in the marketing fluff and more 
technical content.  Yes, some 
showmanship is necessary when giving a presentation, but the content has to be 
there.
 
Many 
people on this forum have submitted presentations to my track and then 
complained that they were not accepted.  
Let me give you some concrete numbers.  This year, we received over 400 
abstracts for the DBA track alone and accepted only 80.  If one slips through the cracks, it 
won’t a second time.  Believe me 
when I say that 2002 was the best content-organized IOUG.  
 
Further 
comments?  Submit an abstract for 
2003 and find out!!!
 
Thank 
You
 
Stephen 
P. Karniotis
Product 
Architect
Compuware 
Corporation
Direct:   
(248) 865-4350
Mobile:  
(248) 408-2918
Email:  
[EMAIL PROTECTED]
Web:    
www.compuware.com
 
-Original 
Message-From: Adams, 
Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 12:39 
PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: the 
ora certified masters cert, yet again
 
unfortunately, I've seen this 
to be true at 
many conferences, including the IOUG 
and SEOUC. 
 Matt Adams - GE Appliances - 
[EMAIL PROTECTED] "Doing linear scans over an associative 
array is like 
trying to club someone to death with a 
loaded Uzi." 
    - Larry Wall (creator 
of Perl) 
-Original 
Message- 
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 
2002 11:54 AM 
To: Multiple recipients of list 
ORACLE-L 
Subject: RE: the ora certified masters 
cert, yet again 

 
I'll bet a dynamic animated 
speaker chockful of amusing anecdotes whose presentation is technically weak 
scores better than a plodding monotonous one with better information to convey 
:)  Especialy if the audience is composed of nascent DBA's 
:)
Ian 
MacGregor 
Stanford Linear Accelerator 
Center 
[EMAIL PROTECTED] 
-Original 
Message- 
Sent: Tuesday, June 25, 2002 5:09 
PM 
To: Multiple recipients of list 
ORACLE-L 

 
one being a marketing venue, 
the other being a place where you can learn from ohers 
experiences. 

and to clarify further, if 
you are a lousy presenter, giving bad information, you get horrible scores and, 
since the selection process is not blind, don't get asked back to 
present again. 

So having a list of many 
presentations, at various conferences, can be an indicator of 
knowledge. 

 
--- "Karniotis, Stephen" 
<[EMAIL PROTECTED]> wrote: > Let me clarify 
something.  It was at Oracle Open World, not IOUG-A > Live > where these 
presentations were made.  Please do not confuse the 
two!! 
> > Thank You > > Stephen P. 
Karniotis 
> Product Architect > Compuware 
Corporation 
> 
Direct:   (248) 865-4350 > 
Mobile:   (248) 408-2918 > 
Email:    
[EMAIL PROTECTED] > Web:  
www.compuware.com 
> >  -Original 
Message- 
> Sent: Tuesday, June 25, 2002 5:41 
PM 
> To:   Multiple recipients 
of list ORACLE-L 
> 
Subject:  RE: the ora certified masters cert, yet 
again 
> > A tip o' the hat to all authors and 
presenters.  However writing a > book > makes no one an expert 
on anything.  There are Oracle books > containing > fabulous stories of what 
happens when a tablespace is put in backup > mode, > and while quite 
entertaining they do not further a correct > understanding of > Oracle.  Authors 
take the time to put what they believe to be true on > 
paper. 
> It's often what they have been told, 
not what they have learned on > their > own.  Richard 
Niemiec's sp? tuning books have been trashed recently > 
because 
> they tout buffer hit ratios; however 
there was a consensus in the > Oracle > community that these 
were important.  It took Cary Millsap's paper > and a 
new 
> tuning paradigm introduced by Gaja 
Vaidyanatha, Kirtikumar Deshpande, > and > John Kostelac Jr. to 
direct us to something more useful.  Personally, > I was > using wait events before 
Gaja's book, but I was also trying to keep > the hit > ratio's high as a part 
of the "consensus".  If I had written a book > 
before 
> seeing Cary's 
paper! 
> ! > , it > would have touted hit 
ratios.  I don't believe "Oracle 101 > Performance > Tuning" is a perfect 
book;  it doesn't properly address da

Re: Sql query

[Rodd Holman]

Roland, 



Sign up for a FREE membership in Oracle Tech Net at http://otn.oracle.com and then go to the following link.  http://otn.oracle.com/docs/content.html This is where Oracle Corporation posts ALL of their documentation ON-LINE FOR FREE.   Once you get to the documentation, go to the SQL Reference for your version of Oracle.  Then look up how to use the MINUS operator.  It will tell you all you need to do to solve this problem. 



Rodd 



On Wed, 2002-06-26 at 08:13, [EMAIL PROTECTED] wrote: 

Hallo,

anyone whom can give me an example on how to pick out field id and name from table one and get only the id's  that exists in table one doesnt exist in table2.

Thanks in advance

Roland




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

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: [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).




-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
[EMAIL PROTECTED]
(605) 988-1373

sql difference rounds

[Debi]

Why is my difference rounded:

'Checking space left in data_ts:'

  TOTAL_BYTES 

 

   18,880,659,456 


   USED_BYTES 

 

   17,796,554,752 

  Space 
Left
 

1,000,000,000 


Here's my script:

set heading on verify off
col total_bytes format 999,999,999,999,999 new_value tbytes
col tbytes format 999,999,999,999,999
col used_bytes format 999,999,999,999,999 new_value ubytes
col ubytes format 999,999,999,999,999
col space_left format 999,999,999,999,999 head 'Space Left'

spool space_left
prompt
prompt 'Checking space left in &1:'
prompt
select sum(t.bytes) total_bytes
from dba_data_files t
where t.tablespace_name = upper('&&1')
/
select sum(u.bytes) used_bytes
from dba_extents u
where u.tablespace_name = upper('&&1')
/
select (&&tbytes) - (&&ubytes) space_left
from dual
/

Thanks,

Debi

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

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: [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).