date:20020522


Chris

You wrote I just want to call it and get the one value it returns.
I think that procedure does not return values, functions does.
If you want to get value from a procedure you have to pass
a parameter that the procedure will return the value in.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 6:33 AM


 Has anyone done this? Let's say I have a procedure named foo and want to
 call it in a Sitescope monitor. There are no arguments to foo. I just want
 to call it and get the one value it returns. Freshwater doesn't have any
doc
 for this and they've been sitting on my request for information for a
week.

 They do have a document with an example for SQL Server but nothing for
 Oracle. If Oracle were like SQL Server, you'd just put the name of the
 procedure in the query line on a typical database monitor, but I tried
that
 and it doesn't work.

 We're using the jdbc thin driver to a version 8.1.7.2 instance if it makes
 any difference.

 Thanks.

 -Chris

 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Chris McGrail
   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: Yechiel Adar
  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: Changing Internal password

2002-05-22 Thread Deepak Thapliyal


hi chinna.. 

use this -- alter user sys identified by urnewpasswd;

was that not rocket science :) .. kidding .. late
night humor

Deepak


--- Chinna Reddy Kunta [EMAIL PROTECTED]
wrote:
 
  
  Dear Gurus...
 Please can u suggest detail procedure of how to
 change the internal password ..os : Windows NT
 i tried to do with ORADIM utility..but i could not
 do it successfullylooking forward for the answer
 as soon as possible...
  
 Regards
 Chinna
  
 
 
 -
      Yahoo! Autos - everything you wanted to know
 about cars and bikes 


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  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 web application

2002-05-22 Thread Jack van Zanen



Hi Aida,


I've build a oracle monitor/admin website using PHP and Apache and Oracle
repository.It's easy to implement/learn the basics. I had to find out about
OCI and PHP because there was not much examples on that on the internet
(obvious reason PHP=Free APACHE=Free  Oracle= well uhh NOT Free). I only
needed the basic OCI calls though


Jack


   

  Keith Carney   

  kcarney@cox-inteTo:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  rnet.comcc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  Re: Oracle web application

  [EMAIL PROTECTED] 

   

   

  21-05-2002 06:38 

  Please respond to

  ORACLE-L 

   

   




Dennis, thanks for your answer
Have you ever used before PHP and done anything of this kind of application
that I want to accomplish? I need to dig out everything myself this summer.
If you know someone that has done somthing alike please let me know. Thanks
again.
Star wars, right?
Can you guess about me?
Aida
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 10:38 AM


 Aida - Now that you have described your situation more clearly, I would
 second the advice you received from Sean - use PHP if you can. While this
 task can be accomplished with just about any language, with some choices
you
 will spend a lot of time getting everything set up. And you probably
would
 have to use more than one language to accomplish some aspects. PHP was
 pretty much designed for quick Web pages and database interactivity. Some
 people here have been very successful with it. As a bonus, it sounds like
 you are already pretty accomplished in PHP. May the force be with you!
 (guess which movie I saw this weekend).
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Monday, May 20, 2002 10:29 AM
 To: Multiple recipients of list ORACLE-L


 Hi Dennis, my name is Aida, (my fault about this)

 Keith is my husband (I love to bother him).

 Thank you for answering to me, I really appreciate it.

 Let me explain more clear the situation.

 I am a graduate student at Stephen F. Austin State University in computer
 science department.

 I will graduate next summer. As part of my graduation the department has
 assigned me the project

 of Computer Science Programming Contest that is done every year. The way
the
 contest is organized

 is this: There is a web site in which the student can register in teams
of
3
 or 4, they need to give their info

 (first name, last name, phone, class, address, for each member, the name
of
 the team) and a user name

 and password is assigned to each team so they can come back and change it
at
 any time.

 At the contest day, to each time is given their account on TITANS and
 password and directions how

 they can send their answers back by mail form their account to the jury.
 Every team-member can program in

 C, C++ or COBOL (languages that are taught at our university). After the
 e-mail is sent, the judge sends

 back the result of the answer.

 The way that is done until last time is this. A faculty member used the
PHP
 to make the registration and

 humans do all the other part. (this is what they want to avoid mainly and
 this time I think they are

 going to use also UNIX accounts for students)

 I took an oracle class (is the first time that is offered) this spring
and
 they assigned me to do this project using oracle.

 I have learned SQL and PL/SQL and some of the basics of Oracle. I have
 designed

RE: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Stephane Faroult


Dear gurus !
We are facing a severe performance problems here
that i have no idea of how
to address.
There is a C++ program , which uses OCI , that does
the following.
It initiates a long running SQL select statement,
and then fetches the
result set from the DB in buffers of 5000 records.
Now , the problem is that it takes significantly
(exponentially) more time
to fetch each subsequent result set.
I.e. , it takes  a second to bring the first 5000
records, it takes 2
seconds to bring the next 5000 rows , it takes 3
seconds to bring the third
set of 5000 rows and it takes a hour to bring
the 100th set of 5000
rows.
My main question is : what actually happens within
the DB engine when you
execute a huge select and then fetch the results
buffer-by-buffer ?

Thanks a lot !!!


DBAndrey


Hmm, I don't think that the problem is with the OCI. Normally (and that what the 
'cursor' of old meant) you do at execution any processing (sorts included) which may 
be required to determine the result set, then move a kind of pointer forward that 
result set. Not much different from a succession of read() - the size of the buffer, 
performance questions apart, just means more or less moving a pointer.
The behaviour you witness is more typical of a statement which would be executed again 
and again, skipping 0 lines on the first execution, 5000 on the second one, 1 on 
the third one ... so as to always return 5000 lines.
 Wanna bet ?

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  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: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Jonathan Lewis



Can you switch on SQL trace whilst this is running,
or peek into v$sql.

It sounds to me as if your code is fetching
an array by re-opening the cursor, fetching
and discarding all the rows up to the required
point, and then returning the required rows.

To answer your direct question - when doing
array fetching correctly, the time for the Nth
fetch should be constant (although the first fetch
time may include sorts, hashes etc. and therefore
be atypical).  You might expect some slow-down
as time passes if the fetched data is also subject
to update, and increasing amounts of undo have
to be applied as the fetch progresses to preserve
read-consistency, but I wouldn't expect the effect
to be as extreme as your figures indicate.



Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 22 May 2002 10:33


|Dear gurus !
|We are facing a severe performance problems here that i have no idea
of how
|to address.
|There is a C++ program , which uses OCI , that does the following.
|It initiates a long running SQL select statement, and then fetches
the
|result set from the DB in buffers of 5000 records.
|Now , the problem is that it takes significantly (exponentially) more
time
|to fetch each subsequent result set.
|I.e. , it takes  a second to bring the first 5000 records, it takes 2
|seconds to bring the next 5000 rows , it takes 3 seconds to bring the
third
|set of 5000 rows and it takes a hour to bring the 100th set of
5000
|rows.
|My main question is : what actually happens within the DB engine when
you
|execute a huge select and then fetch the results buffer-by-buffer ?
|
|Thanks a lot !!!
|
|
|DBAndrey
|
|* 03-9254520
|* 058-548133
|* mailto:[EMAIL PROTECTED]
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Anjo Kolk


Do you keep the each batch of 5000 rows ? If yes, are you running out of
memory ?


Anjo.


Andrey Bronfin wrote:

 Dear gurus !
 We are facing a severe performance problems here that i have no idea of how
 to address.
 There is a C++ program , which uses OCI , that does the following.
 It initiates a long running SQL select statement, and then fetches the
 result set from the DB in buffers of 5000 records.
 Now , the problem is that it takes significantly (exponentially) more time
 to fetch each subsequent result set.
 I.e. , it takes  a second to bring the first 5000 records, it takes 2
 seconds to bring the next 5000 rows , it takes 3 seconds to bring the third
 set of 5000 rows and it takes a hour to bring the 100th set of 5000
 rows.
 My main question is : what actually happens within the DB engine when you
 execute a huge select and then fetch the results buffer-by-buffer ?

 Thanks a lot !!!

 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   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: Anjo Kolk
  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).

test

2002-05-22 Thread RAJESH DAYAL

Title: test






Testing .

RE: Data Warehouse experts, a simple question for you

2002-05-22 Thread FOX, Simon


Has anyone got that jokey review of a new wonder storage/retrieval format
.book ?


Simon Fox

Room 308, CRH

0161 601 8723


-Original Message-
Sent: 22 May 2002 03:58
To: Multiple recipients of list ORACLE-L


Mladen,

That IS what I do with the documentation CD. But Jack and I were
talking about REAL books here, you know, those things that are made of
paper, have printing on the pages, words, diagrams all that sort of
stuff

Rachel

--- Gogala, Mladen [EMAIL PROTECTED] wrote:
 No, no, no and no! You are supposed to eat your documentation CD,
 preferably with fajitas or spaghetti and lots of Tabasco sauce.
 There are some versions of habanera sauce which can prepare your
 mouth
 to such extent that it becomes impossible to tell oracle
 documentation CD
 and a chicken wing apart. Make sure that you have few gallons of
 water
 at hand, though.
 
  -Original Message-
  From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 21, 2002 4:39 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: Data Warehouse experts, a simple question for you
  
  
  gee, and here I thought all I had to do was put the book under my
  pillow and let the words seep in through osmosis :)
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gogala, Mladen
   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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: FOX, Simon
  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: test

2002-05-22 Thread Mark Leith


Can I have a copy of three or so test result sets that you have compiled? ;P

Thanks!

Mark

-Original Message-
Sent: 22 May 2002 12:43
To: Multiple recipients of list ORACLE-L


Testing . 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: How to drop a datafile from a tablespace quickly


you wrote:
 there to claim his 42 virgins in Paradise?
This is a common mistake.
Read the following to know the truth:

Humor . . . bin Laden's fate?

After getting nailed by a Daisy Cutter, Osama made his way to the Pearly
Gates.

There, he is greeted by George Washington. How dare you attack the
nation I helped conceive! yells Mr.Washington, slapping Osama in the
face.

Patrick Henry comes up from behind. You wanted to end America's
liberty, so they gave you death. Henry punches Osama in the face.

James Madison comes up next and says, This is why we allowed the
federal Government to provide for the common defense and kicks Osama in
the groin.

Osama is the subject to similar beatings from John Randolph of
Roanoke, James Monroe and 67 other people who have the same love for
liberty and America.

As Osama writhes in pain on the ground, Thomas Jefferson picks him up
and hurls him back to the gate to be judged.

As Osama awaits his journey to his final very hot destination, he
screams This is not what I was promised!

An angel replies I told you there would be 72 Virginians waiting for
you.  What did you think I said?


Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 11:13 PM


 I did not know that.

 Didn't Douglas Adams recently adjourn to the right hand of Hubble, there
to
 claim his 42 virgins in Paradise?

 Scott Shafer
 San Antonio, TX
 210-581-6217


  -Original Message-
  From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, May 15, 2002 3:38 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: How to drop a datafile from a tablespace quickly
 
  Scott,
 
  Did you hear that Douglas Adams was asked recently (i.e. a few years
ago)
  how he knew the Hubble Constant was (roughly) 42, back when he wrote
the
  Hitchhiker's Guide To The Galaxy series back in the 60s and 70s?  The
  Hubble Constant (having to do with the rate of expansion of the
universe,
  I
  think) had just been discovered to be 42, sometime in the mid-90s, I
  believe...
 
  His response was something along the lines of Well, actually I didn't
  know,
  of course.  It's just that I needed an answer to the question 'What is
the
  meaning of life, the universe, and everything?' and 42 seemed like an
  appropriate answer.  Just an ordinary, sort of smallish number...
 
  I have to go back and re-read those...
 
  -Tim
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, May 15, 2002 2:03 PM
 
 
   Exactly my point.  The answer is 42.
 
 --
 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: Yechiel Adar
  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 on (Ssshhh NT)

2002-05-22 Thread O'Neill, Sean

 From: Robertson Lee - lerobe [EMAIL PROTECTED]
 Date: Tue, 21 May 2002 15:42:19 +0100
 Subject: RE: Oracle on (Ssshhh NT)

Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even
8i,
don't ask !!!)

As you're stuck with Oracle 8 I'd recommend the following book which I
believe is out of print but which you may be able to find via used books
site:
Oracle8  Windows NT Black Book ISBN: 1-57610-248-3 Published by Coriolis.

Following Oracle8 NT papers may also be of interest:
http://www.nyoug.org/tune8nts.pdf
http://www.nyoug.org/ora8winnt.pdf
http://www.dbatoolbox.com/WP2001/nt2000/tips_techniques.pdf

Following site might also be of use:
http://www.ipass.net/~davesisk/oont_main_menu.htm

HTH,
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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: test

2002-05-22 Thread Thomas, Kevin


very...

-Original Message-
Sent: 22 May 2002 12:43
To: Multiple recipients of list ORACLE-L



Testing . 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  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: I/O EVENTS

2002-05-22 Thread Cherie_Machler



Cary,

Thanks for this meaty example and especially for the analysis afterwards.
Real-life examples like this are so much more revealing and insightful than
any amount of theoretical discussion.

We could learn so much if once a month someone would post the statistics
and output from their performance problem as well as the background story
and then discussed the solution in detail.

I must admit that you guys have impressed the heck out of me with this
story.   I would be very kindly disposed to bringing HOTSOS in to fix a
serious performance problem.

Cherie Machler
Oracle DBA
Gelco Information Network


   
   
Cary Millsap 
   
cary.millsap@h   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
otsos.comcc:  
   
Sent by:  Subject: RE: I/O EVENTS  
   
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
05/21/02 11:08 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




I have an example for you (Anjo, I hope you won't mind). A prospect we
visited once upon a time had been fighting a performance problem with an
Oracle Payroll program. They knew what




-- 
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: oratab file

2002-05-22 Thread Karniotis, Stephen


Stephane:

Yes I have seen this type of operation.  I helped manage a global
services database environment for Oracle Financials where the databases
needed to be started/stopped/etc. in that country's specific time zone.  All
startup files, log files, etc. had to recognize their zone.  We created a
new version of the oratab file and modified the existing one to facilitate
this process.

   Changing the oratab file is not condoned by Oracle as they only use parts
of the file.  As far as your problems with OEM, that is definitely a bug in
the string parser used by the intelligent agent of OEM.

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, May 21, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: oratab file

The oratab is provided by Oracle Corp.

We created our own oratab file to handle more
parameters.


 --- Babu Nagarajan [EMAIL PROTECTED] a écrit : 
All
 
 On one of the database servers we have, the oratab
 file has been changed to include a :parameter
 after each entry and that parameter is used to
 determine whether the database is supposed to be
 shutdown at a certain time. 
 
 It kind of struck me as a odd way to do this... This
 created problems for me when I was trying to get OEM
 discover this database and I had to remove this
 parameter to get OEM discover the database.
 
 So the question is : Have you seen this some where
 else? Is this (editing of oratab) supported?
 
 PS : This is not my database. I had to look into it
 for some other reason and I discovered this.
 
 TIA
 
 Babu
  

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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).

Import help

2002-05-22 Thread Rick_Cale


Hi DBAs,

I have an export file from 8.0.5 that I want to import into 8.1.6 both on
NT.
The import says imported terminated successfully without warnings but I
know nothing got imported.

The preceding messages say the following

Export file created by EXPORT:V08.00.05
import done in WE8ISO8859PI character set and US7ASCII NCHAR character set
import server uses US7ASCII character set (possible charset conversion)

The registry settings for NLS_LANG on both the client and server is
WE8ISO8859PI.

Any ideas on how I can get the import to work.

Thanks
Rick


-- 
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: Statistical sampling and representative stats collection

2002-05-22 Thread Cherie_Machler



Jack,

What version are you on?   Are you able to utilize the gather_stale option.
That way you would not only be optimizing the amount you are estimating but
the interval between analyzing.

Of course, that option of DBMS_STATS is not available on older versions.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Jack Silvey
  
jack_silvey@y   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
ahoo.comcc:   
  
Sent by: Subject: Re: Statistical sampling and 
representative stats  
[EMAIL PROTECTED]collection   
  
om 
  
   
  
   
  
05/21/02 06:19 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hi Rafiq,

We have been using 35 percent on our warehouse, even
on our fact partitions. Now that I have thought about
it for a while, that seems like a lot given the volume
of data. If a representative sample can be gathered
with 10,000 or 50,000 or 100,000 rows, and our fact
partitions have millions of rows each, seems like we
could go 1% on our analyze and it would be within
acceptable tolerances.

/jack


--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
 The most of the list memeber agrees on estimate with
 30%

 Regards
 Rafiq




 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Date: Tue, 21 May 2002 13:43:33 -0800

 Hi all,

 Did some investigation about statistical sampling
 this
 weekend since we are going to optimize our analyze
 process soon, and would like some input from all you
 orabrains on this one.

 I opened a TAR with Oracle asking about the sampling
 algorithm of stats collection, and they assured me
 it
 was random.

 The goal of analyze...estimate is to collect stats
 that are representative of the data population as a
 whole using a given sample set. Since analyzing
 tables
 takes up resources (does sorts to order the data for
 investigation) the fewer rows you use in estimate,
 the
 less system resources you use and the faster the
 analyze will go.

 Since our goal is to get as small a sample as
 possible
 and still have stats that are representative, my
 contention is that we could start by finding what
 the
 margin of error will be for each sample size and
 gauge
 our tolerance for it.

 One standard way to calculate margin of error for a
 given sample is by using this formula:

 M = 1/SQRT(N)

 where:
 M = margin of error
 N=sample size

 So, if we can tolerate stats that have a 1% a margin
 of error (will deviate from representative of the
 whole population by 1%), our sample size should be
 10,000 rows.

 Also, a corollary (not a toyota corollary, though)
 to
 this would be that the more rows you add to your
 sample, the closer to representative your sample
 will
 be. So, in order to test whether your sample is
 representative enough, you could analyze using
 either
 estimate 49% or compute, take a snapshot of the
 stats,
 and then compare the stats from a 10,000 row
 estimate
 to those. Then, add rows to your estimate until you
 are satisfied with the stats.

 This of course is a pie in the sky mathematical
 model,
 but seems like a reasonable place to start with
 testing.

 Input? Input? Buhler? Buhler?


 /jack silvey


 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.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

Re: ok one for you windows/oracle people out there

2002-05-22 Thread Thomas Day



Nope.  Sorry.  I've never seen this message and we've moved on to Win2K.


   

Joe Testa  

jtesta  To: Multiple recipients of list ORACLE-L  

@dmc-it.com [EMAIL PROTECTED]

Sent by: rootcc:   

 Subject: ok one for you windows/oracle 
people 
 out there 

05/21/2002 

05:23 PM   

Please 

respond to 

ORACLE-L   

   

   





Whenever more users logon to the database we get Oracle error 'out of
process memory' and the process fails. It indicates that OS could not
allocate memory for the process. For Windows NT Enterprise Edition a
feature 4 GB Memory Tuning is available.

Anyone know anything about it, does it work, etc?


thanks, joe


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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  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).

9iR2 Install Problem

2002-05-22 Thread Toepke, Kevin M


Hello!

I am having a little difficulty with the 9iR2 install on a SUN Sparc
(Solaris 8) box. The installer completes normally, but when I try to run
anything java (e.g. dbca) I get the following message
Could not locate Java runtime
It looks to me that Oracle's provided jre did not get installed properly

Any suggestions on what I can do to correct this error? 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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 and Delphi

2002-05-22 Thread farkasb




There are several ways to connect to the Oracle 
from Delphi. You can use ODBC and BDE, but i suppose you to usesome kind 
of component collections. For example Direct Oracle Access components can 
connect to the Oracle without BDE and ODBC. One obvious advantage is the speed. 
It uses tnsnames for databases, and you just simply put the session component to 
the form and set the database and connect to it. Anyway they have a very good 
help for all of their components.

You can find it 
here:
http://www.allroundautomations.nl/doa.htm



  - Original Message - 
  From: 
  Santosh 
  Varma 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, May 22, 2002 12:08 
  PM
  Subject: Oracle and Delphi
  
  Hi 
  list,
  
   
  I am developing an application wherein Delphi is the Front-end and Oracle the 
  Back-end. I wanted to know what all are needed to get connected to Oracle 
  Database , i.e - settings,configuration etc..
  
  Thanks and 
  regards,
  Santosh

Re: Statistical sampling and representative stats collection

2002-05-22 Thread Cherie_Machler



Jack,

Isn't the problem with this concept that it doesn't take into consideration
how skewed the data is?   Statistically significance would be relevant to
perfectly distributed data but wouldn't you need a higher percentage of
data for significance in more highly skewed data?

Just something to consider.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Jack Silvey
  
jack_silvey@y   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
ahoo.comcc:   
  
Sent by: Subject: Re: Statistical sampling and 
representative stats  
[EMAIL PROTECTED]collection   
  
om 
  
   
  
   
  
05/21/02 06:19 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hi Rafiq,

We have been using 35 percent on our warehouse, even
on our fact partitions. Now that I have thought about
it for a while, that seems like a lot given the volume
of data. If a representative sample can be gathered
with 10,000 or 50,000 or 100,000 rows, and our fact
partitions have millions of rows each, seems like we
could go 1% on our analyze and it would be within
acceptable tolerances.

/jack


--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
 The most of the list memeber agrees on estimate with
 30%

 Regards
 Rafiq




 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Date: Tue, 21 May 2002 13:43:33 -0800

 Hi all,

 Did some investigation about statistical sampling
 this
 weekend since we are going to optimize our analyze
 process soon, and would like some input from all you
 orabrains on this one.

 I opened a TAR with Oracle asking about the sampling
 algorithm of stats collection, and they assured me
 it
 was random.

 The goal of analyze...estimate is to collect stats
 that are representative of the data population as a
 whole using a given sample set. Since analyzing
 tables
 takes up resources (does sorts to order the data for
 investigation) the fewer rows you use in estimate,
 the
 less system resources you use and the faster the
 analyze will go.

 Since our goal is to get as small a sample as
 possible
 and still have stats that are representative, my
 contention is that we could start by finding what
 the
 margin of error will be for each sample size and
 gauge
 our tolerance for it.

 One standard way to calculate margin of error for a
 given sample is by using this formula:

 M = 1/SQRT(N)

 where:
 M = margin of error
 N=sample size

 So, if we can tolerate stats that have a 1% a margin
 of error (will deviate from representative of the
 whole population by 1%), our sample size should be
 10,000 rows.

 Also, a corollary (not a toyota corollary, though)
 to
 this would be that the more rows you add to your
 sample, the closer to representative your sample
 will
 be. So, in order to test whether your sample is
 representative enough, you could analyze using
 either
 estimate 49% or compute, take a snapshot of the
 stats,
 and then compare the stats from a 10,000 row
 estimate
 to those. Then, add rows to your estimate until you
 are satisfied with the stats.

 This of course is a pie in the sky mathematical
 model,
 but seems like a reasonable place to start with
 testing.

 Input? Input? Buhler? Buhler?


 /jack silvey


 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.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

RE: I/O EVENTS

2002-05-22 Thread S B


Hi Cary,

I also have a same problem but could not solve it yet

I have two m/cs and with identical DB layout etc and
running the 
same pro*C code under same data volume.The top waits
are as follows.

1.oracle-8.0.5 ( 2 processor/RAM 512 MB)

Total run time 45 mins

Event   wait(cs)  %
---
CPU used by this session218625
73.03299471
SQL*Net message from client 37013
12.36441502
db file sequential read 18074
6.037728286
SQL*Net more data to client 8891
2.970091966
write complete waits8341
2.786361161

2.oracle-8.1.7 ( 2 processor/RAM 512 MB)

Total run time 2.2 hrs

Event   wait(cs)  %
---
SQL*Net message from client 463790
61.85186173
CPU used by this session229327
30.5834578
SQL*Net more data to client 32388
4.319321455
db file sequential read 21698
2.893683986
log file sync   1788
0.23845087
SQL*Net message to client   530
0.070681745


See the amount of CPU time is almost same in both m/c
and 
the great diff is being in the SQL*Net message from
client

I have also seen that in both the m/c the program
running 
with (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
i.e
using BEQ.

Question :- 

1. How to reduce wait time for SQL*Net message from
client
2. In the above case,connection is established without
a 
   connect string( i.e tnsnames.ora is not used.), so
   will a change in tnsnames.ora really help ?

Bhulu


--- Cary Millsap [EMAIL PROTECTED] wrote:
 I have an example for you (Anjo, I hope you won't
 mind). A prospect we
 visited once upon a time had been fighting a
 performance problem with an
 Oracle Payroll program. They knew what their
 problem was: very
 clearly, v$system_event was telling them that their
 overwhelmingly
 dominant system performance problem was waits for
 latch free. (Well,
 no it wasn't. It was waits for the Oracle Payroll
 program. ;) )
 
 Actually, the v$system_event view indicated clearly
 that the top wait
 event was SQL*Net message from client (and some
 other SQL*Net %
 stuff), but of course every good DBA knows that you
 have to discard all
 the SQL*Net events because they are idle events.
 
 Three months of trying and failing to fix the
 problem led finally to a
 last-resort, desperation hardware upgrade. Twelve
 700MHz CPUs became
 twelve new 1,024MHz CPUs. (Don't ask why waits for
 latch free was
 translated as need to upgrade CPUs.) And
 unfortunately, the Payroll
 program got *slower*. Not just seemed
 slower--*was* slower.
 
 After the upgrade failed to help, these guys finally
 let us come see
 them. We traced the Payroll process (10046, level
 8), very carefully
 initiating the trace immediately after the
 initiation of the Payroll
 run, and very carefully terminating the trace
 immediately after the
 completion of the Payroll run. The key here is that
 every second of data
 in the trace file was a second of somebody's
 response time.
 
 The result was a really fun story. The thing ran in
 about 33 minutes.
 Here's a summary of what was in the session's trace
 file:
 
 Oracle Kernel Event  Duration   
 CallsAvg
 
 -- --
  --
 SQL*Net message from client   984.01s   49.6%  
 95,161  0.010340s
 SQL*Net more data from client 418.82s   21.1%   
 3,345  0.125208s
 db file sequential read   279.54s   14.1%  
 45,085  0.006200s
 CPU service   248.69s   12.5% 
 222,760  0.001116s
 unaccounted-for27.73s1.4%   
 
 latch free 23.69s1.2%  
 34,695  0.000683s
 log file sync   1.09s0.1%   
   506  0.002154s
 SQL*Net more data to client 0.83s0.0%  
 15,982  0.52s
 log file switch completion  0.28s0.0%   
 3  0.09s
 enqueue 0.25s0.0%   
   106  0.002358s
 SQL*Net message to client   0.24s0.0%  
 95,161  0.03s
 buffer busy waits   0.22s0.0%   
67  0.003284s
 db file scattered read  0.01s0.0%   
 2  0.005000s
 SQL*Net break/reset to client   0.00s0.0%   
 2  0.00s
 -- --
  --
 Total   1,985.40s  100.0%  
 
 Well, waits for latch free accounted for only 1.2%
 of the total
 response time. If the DBAs had been completely
 successful in eliminating
 latch free waits from their system, it would have
 made only a 1.2%
 difference in the runtime of this program. Point 1:
 emphasisThis
 program's bottleneck is not the same as its system's
 system-wide average
 bottleneck./emphasis This happens all the time.
 You can NOT see

Re: 8.1.7.4


I thought that .3 was the final patch.  I guess they found more stuff that
needed fixing.

Ruth


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 8:58 PM


 Has anyone patched up to 8.1.7.4 yet???

 Anything we should be aware of???

 Regards,

 Sujatha
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sujatha Madan
   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: Ruth Gramolini
  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:oratab file

2002-05-22 Thread dgoulet


Babu,

There already is a parameter in oratab to indicate whether or not you
start/stop a database.  Anything else in that vein would be highly custom for
the site.  I Know I use one to tell dbstart  dbshut if there is a listener
and/or name server that should be handled as part of the process.  But I've not
had any OEM problems with it.  Actually OEM should not be able to see that file,
it's just talking to the listener.  Now is editing the file supported by OTS,
that's harder to define.  As for the first three parameters, sid/oracle_home/Y
or N, I believe we can assume they support that since that's whet they were
placed there for.  Outside of that your kind of on your own, although I have not
had a problem with OTS on the matter.

Dick Goulet

Reply Separator
Author: Babu Nagarajan [EMAIL PROTECTED]
Date:   5/21/2002 2:03 PM

All

On one of the database servers we have, the oratab file has been changed to
include a :parameter after each entry and that parameter is used to determine
whether the database is supposed to be shutdown at a certain time. 

It kind of struck me as a odd way to do this... This created problems for me
when I was trying to get OEM discover this database and I had to remove this
parameter to get OEM discover the database.

So the question is : Have you seen this some where else? Is this (editing of
oratab) supported?

PS : This is not my database. I had to look into it for some other reason and I
discovered this.

TIA

Babu

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type content=text/html; charset=iso-8859-1
META content=MSHTML 6.00.2713.1100 name=GENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=#ff
DIVFONT face=Comic Sans MS color=#008000 size=2All/FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2On one of the database 
servers we have, t/FONTFONT face=Comic Sans MS color=#008000 size=2he 
oratab file has been changed to include a :lt;parametergt; after each entry 
and that parameter is used to determine whether the database is supposed to be 
shutdown at a certain time. /FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2It kind of struck me as a 
odd way to do this... This created problems for me when I was trying to get OEM 
discover this database and I had to remove this parameter to get OEM discover 
the database./FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2So the question is : Have 
you seen this some where else? Is this (editing of 
oratab)nbsp;supported?/FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV
DIV
DIVFONT face=Comic Sans MS color=#008000 size=2PS : This is not my 
database. I had to look into it for some other reason and I discovered 
this./FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2TIA/FONT/DIV
DIVFONT face=Comic Sans MS color=#008000 size=2/FONTnbsp;/DIV
DIVFONT face=Comic Sans MS color=#008000 
size=2Babu/FONT/DIV/BODY/HTML

-- 
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: Oracle web application

2002-05-22 Thread SIM/HAOUHACH


Hi, 
Excuse my very bad english:-)
can you be more explicit, is what you seek to better understand the
utilization of  function OCI, because if it is that I can you to send
examples on what I have made,  that will be able surely to help you.  
Therefore reply me rapidly:-)

LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]



 -Message d'origine-
 De:   Jack van Zanen [SMTP:[EMAIL PROTECTED]]
 Date: mercredi 22 mai 2002 11:13
 À:Multiple recipients of list ORACLE-L
 Objet:Re: Oracle web application
 
 
 Hi Aida,
 
 
 I've build a oracle monitor/admin website using PHP and Apache and Oracle
 repository.It's easy to implement/learn the basics. I had to find out
 about
 OCI and PHP because there was not much examples on that on the internet
 (obvious reason PHP=Free APACHE=Free  Oracle= well uhh NOT Free). I only
 needed the basic OCI calls though
 
 
 Jack
 
 
  
 
   Keith Carney
 
   kcarney@cox-inteTo:   Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]   
   rnet.comcc:   (bcc: Jack van
 Zanen/nlzanen1/External/MEY/NL)
   Sent by: Subject:  Re: Oracle web
 application
   [EMAIL PROTECTED]
 
  
 
  
 
   21-05-2002 06:38
 
   Please respond to
 
   ORACLE-L
 
  
 
  
 
 
 
 
 Dennis, thanks for your answer
 Have you ever used before PHP and done anything of this kind of
 application
 that I want to accomplish? I need to dig out everything myself this
 summer.
 If you know someone that has done somthing alike please let me know.
 Thanks
 again.
 Star wars, right?
 Can you guess about me?
 Aida
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, May 20, 2002 10:38 AM
 
 
  Aida - Now that you have described your situation more clearly, I would
  second the advice you received from Sean - use PHP if you can. While
 this
  task can be accomplished with just about any language, with some choices
 you
  will spend a lot of time getting everything set up. And you probably
 would
  have to use more than one language to accomplish some aspects. PHP was
  pretty much designed for quick Web pages and database interactivity.
 Some
  people here have been very successful with it. As a bonus, it sounds
 like
  you are already pretty accomplished in PHP. May the force be with you!
  (guess which movie I saw this weekend).
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Monday, May 20, 2002 10:29 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi Dennis, my name is Aida, (my fault about this)
 
  Keith is my husband (I love to bother him).
 
  Thank you for answering to me, I really appreciate it.
 
  Let me explain more clear the situation.
 
  I am a graduate student at Stephen F. Austin State University in
 computer
  science department.
 
  I will graduate next summer. As part of my graduation the department has
  assigned me the project
 
  of Computer Science Programming Contest that is done every year. The way
 the
  contest is organized
 
  is this: There is a web site in which the student can register in teams
 of
 3
  or 4, they need to give their info
 
  (first name, last name, phone, class, address, for each member, the name
 of
  the team) and a user name
 
  and password is assigned to each team so they can come back and change
 it
 at
  any time.
 
  At the contest day, to each time is given their account on TITANS and
  password and directions how
 
  they can send their answers back by mail form their account to the jury.
  Every team-member can program in
 
  C, C++ or COBOL (languages that are taught at our university). After the
  e-mail is sent, the judge sends
 
  back the result of the answer.
 
  The way that is done until last time is this. A faculty member used the
 PHP
  to make the registration and
 
  humans do all the other part. (this is what they want to avoid mainly
 and
  this time I think they are
 
  going to use also UNIX accounts for students)
 
  I took an oracle class (is the first time that is offered) this spring
 and
  they assigned me to do this project using oracle.
 
  I have learned SQL and PL/SQL and some of the basics of Oracle. I have
  designed some web sites before
 
  with forms, but never any one in interaction with the user and a
 database.
  That's why I need help for basically
 
  everything. (even for the general concept). Should I still use PHP or is
  there any better choice? This is my first
 
  big question right now but to tell you the truth I have everything under
  question mark. But one thing at a time
 
  and I am hunting around to get more comfortable with this problem.
 
  Thank you very

RE: ORA-01595


Gilbert - The oerr utility says the key part is the accompanying message.
Can you forward the accompanying messgage? 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment (string))

I got this error when I tryed to shrink the rollback segment system,

What can I do to solve this problem, optiman does'nt solve it.

thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  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: 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: TOAD S/w

2002-05-22 Thread Rodrigues, Bryan


Try www.quest.com, I believe this is the company's web site.

Bryan

-Original Message-
Sent: Wednesday, May 22, 2002 4:33 AM
To: Multiple recipients of list ORACLE-L



Any Docs , Links ?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  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: Rodrigues, Bryan
  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: System tables for generating the object privileges

2002-05-22 Thread Thomas Day



I just spent 6 months doing, among other things, just this.  DBA_TAB_PRIVS
should probably be more accurately called DBA_OBJ_PRIVS as it has all
objects' privs in it, now just tables.


Here's an example.  It produces spooled output that can be run to recreate
the existing privs.

SELECT 'GRANT '||privilege||' on SCHEMA.'||TABLE_NAME||' TO '||grantee||
 decode(grantable,'YES',' with grant option;',';')
 FROM dba_tab_privs
  WHERE OWNER = 'SCHEMA'

By changing the where clause to select on GRANTEE you can get all objects
across schemae.

select
'grant '||
privilege||
' ON '||owner||'.'||
TABLE_NAME||
' to WHAZZUP? '||
 decode(grantable,'YES',' with grant option;',';')
 from dba_tab_privs where grantee = 'WHAZZUP?'


enjoy



   

Sergey V   

Dolgov dsv  To: Multiple recipients of list ORACLE-L  

@pptus.oilnet[EMAIL PROTECTED]

.ru cc:   

Sent by: rootSubject: Re: System tables for generating 
the 
 object privileges 

   

05/21/2002 

11:08 PM   

Please 

respond to 

ORACLE-L   

   

   





Hello Vasu,

You can find much in dba_tab_privs there is information about
procedures, views, tables, synonyms in it.

Wednesday, May 22, 2002, 9:03:22 AM, you wrote:

VR Hello All,
VRI am trying to generate a script to grant privileges on the DB
VR objects by extracting them from system tables. I know that the
following
VR system tables can be used to get the system, role privileges, and
table
VR and column access privileges. dba_sys_prives
VR dba_roll_prives
VR dba_tab_privs
VR dba_col_privs

VR I am not able to find the system tables to get the privileges assigned
VR to users on stored procedures, views and synonyms etc. Can you please
VR throw some light on this?

VRThanks  for your help.

VR Vasu






--
Best regards,
 Sergeymailto:[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergey V Dolgov
  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: Thomas Day
  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: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Andrey Bronfin


Thanks a lot Jonathan !
I TKPROFed these statements - nothing outstanding, it looks like the cursor
is not getting closed eafter each fetch.
Anyway , i would not expect the 100th fetch to take 100s times more time
than the first one
Also please note that the select contains 'group by' and 'order by' , which
AFAIK forces the engine to construct the whole result set before returning
rows.
Thanks a lot !

DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Wed, May 22, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L



Can you switch on SQL trace whilst this is running,
or peek into v$sql.

It sounds to me as if your code is fetching
an array by re-opening the cursor, fetching
and discarding all the rows up to the required
point, and then returning the required rows.

To answer your direct question - when doing
array fetching correctly, the time for the Nth
fetch should be constant (although the first fetch
time may include sorts, hashes etc. and therefore
be atypical).  You might expect some slow-down
as time passes if the fetched data is also subject
to update, and increasing amounts of undo have
to be applied as the fetch progresses to preserve
read-consistency, but I wouldn't expect the effect
to be as extreme as your figures indicate.



Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 22 May 2002 10:33


|Dear gurus !
|We are facing a severe performance problems here that i have no idea
of how
|to address.
|There is a C++ program , which uses OCI , that does the following.
|It initiates a long running SQL select statement, and then fetches
the
|result set from the DB in buffers of 5000 records.
|Now , the problem is that it takes significantly (exponentially) more
time
|to fetch each subsequent result set.
|I.e. , it takes  a second to bring the first 5000 records, it takes 2
|seconds to bring the next 5000 rows , it takes 3 seconds to bring the
third
|set of 5000 rows and it takes a hour to bring the 100th set of
5000
|rows.
|My main question is : what actually happens within the DB engine when
you
|execute a huge select and then fetch the results buffer-by-buffer ?
|
|Thanks a lot !!!
|
|
|DBAndrey
|
|* 03-9254520
|* 058-548133
|* mailto:[EMAIL PROTECTED]
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: Andrey Bronfin
  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: ORA-01595

2002-05-22 Thread Sherman, Paul R.


Do not take this as a gospel truth, but as far as I understand, there is no
harm done and nothing needs to be done for this error - this is like the dog
that catches his tail while he's chasing it yelp!. However, it's a good
idea to check any trace file that gets generated, and/or look for any
preceding error message that is related to getting the 01595. It's possible
that something needs to be addressed, but I've yet to need to do anything on
a 01595.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 5:58 AM
To: Multiple recipients of list ORACLE-L


ORA-01595 error freeing extent (string) of rollback segment (string))

I got this error when I tryed to shrink the rollback segment system,

What can I do to solve this problem, optiman does'nt solve it.

thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  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: Sherman, Paul R.
  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: 9iR2 Install Problem

2002-05-22 Thread Karniotis, Stephen


Check and see if the jre runtime libraries are in your path for the session.
Otherwise, it will not dynamically find them.

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, May 22, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject:9iR2 Install Problem

Hello!

I am having a little difficulty with the 9iR2 install on a SUN Sparc
(Solaris 8) box. The installer completes normally, but when I try to run
anything java (e.g. dbca) I get the following message
Could not locate Java runtime
It looks to me that Oracle's provided jre did not get installed properly

Any suggestions on what I can do to correct this error? 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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).

EJB Support in Oracle 9iR2

2002-05-22 Thread Steve . Parker


Hi,

Can anyone confirm if EJB support has been removed from Oracle Database Server Release 2 ?

If so, can they point me to a metalink etc article. I am sure I read about this somewhere but 
can't find any reference to it.

If this is correct, then Oracle revenue should go up as everyone buys Application Server

Steve Parker
E Mail: [EMAIL PROTECTED]
 --

RE: ok one for you windows/oracle people out there

2002-05-22 Thread Robertson Lee - lerobe


Correct me if I'm wrong (and I probably am) but isn't this the add a switch
to the startup line in the boot.ini fix.

From Tuning 101.

Windows NT4.0 Enterprise Edition has a feature called 4Gb Ram Tuning (4GT).
This feature makes it possible for applications to use up to 3Gb of memory
space. This increase in avaliable memory space will allow larger SGA sizes
or more connections to the database. To enable this feature, you will have
to add the /3GB switch to the operating system startup line in the
boot.ini file.

[operating system] multi(0)disk(0)rdisk(0)partition(2)\WINNT=Windows NT
Server Version 4.00/3GB

HTH

Regards

Lee


-Original Message-
Sent: 22 May 2002 15:18
To: Multiple recipients of list ORACLE-L



Nope.  Sorry.  I've never seen this message and we've moved on to Win2K.


 

Joe Testa

jtesta  To: Multiple recipients of list
ORACLE-L  
@dmc-it.com [EMAIL PROTECTED]

Sent by: rootcc:

 Subject: ok one for you
windows/oracle people 
 out there

05/21/2002

05:23 PM

Please

respond to

ORACLE-L

 

 





Whenever more users logon to the database we get Oracle error 'out of
process memory' and the process fails. It indicates that OS could not
allocate memory for the process. For Windows NT Enterprise Edition a
feature 4 GB Memory Tuning is available.

Anyone know anything about it, does it work, etc?


thanks, joe


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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  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 information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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[2]: Inline View Query Versus Ordinary Query - Comparison

2002-05-22 Thread dgoulet


The biggest problem I've seen with inline view defs is that they most often
force a resolution of that view into a temporary table which is then not
indexed.  Not a problem if the inline view has only a handful of rows, but when
that inline view returns several thousand rows you can get into a mess.  On the
other hand, the optimizer can take a regular view and merge the SQL from the
view def and your query into one query that does not require a temp object. 
It's a trail and error thing.

Dick Goulet

Reply Separator
Author: Stephane Faroult [EMAIL PROTECTED]
Date:   5/21/2002 3:07 PM

VIVEK_SHARMA wrote:
 
 Query using Inline View Query an Ordinary one ?
 Which is Better w.r.t. Performance  Why ?
 
 EXAMPLE - Following 2 SAMPLE Queries give the SAME Output .
 But which would be better ?
 

Second is better because it accesses half the number of blocks. In this
order of magnitude it matters if you run the query every 10s, not if
it's part of this quarterly report.
-- 
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).
-- 
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).

parametric Views

2002-05-22 Thread Shishir Kumar Mishra




Can anyone of u tell me How to 
create parametric views?? 


thanx in advance..
Shishir Kumar Mishra

e: shared pool

2002-05-22 Thread Sherman, Paul R.


Rafiq,

I ran your query as we have been in the process of tuning our shared pool,
and I have a question. When you see many more loads than executions for a
given table, is it a safe bet that the application in question is executing
queries that have that table in the from clause, but it is not being used by
that query ? For example, a table has 33 loads and 5 executions. Could I say
that 28 loads were caused by a query that had that table referenced, but not
used (and causing a full table scan, because that's what Oracle does when
you reference, but do not use, a table (in the from clause) ?

Thank you,

Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  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: Statistical sampling and representative stats collection

2002-05-22 Thread Jamadagni, Rajendra


Jack,

Nielsen Ratings (the TV Rating company) monitors about 5000 people (and
their TV watching habits) to supply ratings for all the shows on most of the
networks for the whole United States. So, as long as you have a working and
proven statistical model, and a good sample, it works. How do I know, ever
seen anyone challenging Nielsen Ratings for a show? I haven't.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


***1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

RE: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Andrey Bronfin


Stephane , thanks a lot !
actualy , i do not think that this is the case , because it would take
relatively much more time to construct the result set (my SQL contains
massive 'group by' and 'order by' and therefore the whole result set needs
to be constructed before returning even the 1st row), than to skip over
several records ot bring the next 5000 rows...



DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Wed, May 22, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L


Dear gurus !
We are facing a severe performance problems here
that i have no idea of how
to address.
There is a C++ program , which uses OCI , that does
the following.
It initiates a long running SQL select statement,
and then fetches the
result set from the DB in buffers of 5000 records.
Now , the problem is that it takes significantly
(exponentially) more time
to fetch each subsequent result set.
I.e. , it takes  a second to bring the first 5000
records, it takes 2
seconds to bring the next 5000 rows , it takes 3
seconds to bring the third
set of 5000 rows and it takes a hour to bring
the 100th set of 5000
rows.
My main question is : what actually happens within
the DB engine when you
execute a huge select and then fetch the results
buffer-by-buffer ?

Thanks a lot !!!


DBAndrey


Hmm, I don't think that the problem is with the OCI. Normally (and that what
the 'cursor' of old meant) you do at execution any processing (sorts
included) which may be required to determine the result set, then move a
kind of pointer forward that result set. Not much different from a
succession of read() - the size of the buffer, performance questions apart,
just means more or less moving a pointer.
The behaviour you witness is more typical of a statement which would be
executed again and again, skipping 0 lines on the first execution, 5000 on
the second one, 1 on the third one ... so as to always return 5000
lines.
 Wanna bet ?

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  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: Andrey Bronfin
  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 and Delphi

2002-05-22 Thread Steve Gouldstone


I am developing an application wherein Delphi is the Front-end and
Oracle the Back-end. I wanted to know what all are needed to get connected
to Oracle Database , i.e - settings,configuration etc..
Santosh

I have had success with the Direct Oracle Access component set from
AllRound Automations. About $US 120 or I think $299 with source code.
See:

http://www.allroundautomations.nl

These have worked very well for me and I have n bot had a single issue
with them.

Steve
Steve Gouldstone
Langdale Designs Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Gouldstone
  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: patching 8.1.7

2002-05-22 Thread Glenn Travis


I just patched two instances on HP-UX 11 (64bit) to 8.1.7.4.  We are running Oracle 
Apps as well.  I'll let you know if we hit anything.

(we patched to get rid of ORA-00600 errors and subsequent core dumps, on the advice 
from Oracle).

 -Original Message-
 From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 21, 2002 4:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: patching 8.1.7
 
 
 
 
  -Original Message-
  From: Ron Thomas [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 21, 2002 4:14 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: patching 8.1.7
  
  
  
  BTW, looks like 8.1.7.4 has been released for most platforms. 
   Just downloaded HP-UX and linux
  today.
 
 You have a dual boot HP 9000 there? What a wonderful machine 
 for playing
 tetris:)
 Just kidding. I'll download 9.2 for Linux tonight and see how 
 it goes. (God
 bless 
 the inventor of the Motorola SurfBoard 4100 cable modem). I 
 think I know
 what will 
 I be doing over the Memorial Day weekend
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gogala, Mladen
   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: Glenn Travis
  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: TOAD S/w

2002-05-22 Thread Jesse, Rich


http://www.quest.com
http://www.toadsoft.com
http://www.egroups.com/list/toad

Quest is the official site.

Toadsoft is the original site of the freeware (which is still available!).

The TOAD mailing list is run/monitored by Toadman Jim himself, as well as
his wonderfully helpful staff.  EXCELLENT source for feedback and
troubleshooting.

HTH!  GL!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

 -Original Message-
 From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 22, 2002 3:33 AM
 To: Multiple recipients of list ORACLE-L
 Subject: TOAD S/w
 
 
 
 Any Docs , Links ?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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).

Rename Column in 9iR2

2002-05-22 Thread Toepke, Kevin M


Summary: it works!

SQL SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL alter table test_table rename column wrong_name to right_name;

Table altered.

SQL desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Statistical sampling and representative stats collection


Jack, Raj
I agree. The main point I feel is that if you follow statistics
theory, which a good part of our modern technology relies on, you will test
a fixed number of samples, rather than a percentage of the table rows. 
For a small table, you may have to sample the entire table to get
results that work. As a real-life example, you wouldn't sample 10 US
Senators and expect those results to be accurate. No, you would simply
survey each Senator (and hope they don't change their mind). Similarly,
don't just sample 30 percent of a 1,000-row table. Sample all 1,000 rows.
For a large table, sampling a percentage would oversample and be a
wasted effort. If you have a million-row table and a hundred-million-row
table, the same sample size will produce results nearly as accurate for
both. That is why you don't see nearly as many state political polls. It is
nearly as much expense to accurately sample the citizens in a state as it is
to sample all the citizens in the US
Someone asked about skewed data. Well, that is the reason you
perform a RANDOM sample. That is the key point, and what produces many
real-life statistical failures. A classic example is the Truman-Dewey
presidential race in 1948. The pioneer pollsters used random samples of
phone numbers and confidently predicted Dewey's victory. What they neglected
was that wealthier people had telephones in greater proportion than poor
people. So their sample was skewed, which produced bad results. Here, we're
betting on Oracle's statement that the sample is truly random.
Now, if you want a more accurate result, you will sample more. But
you aren't increasing the sample size because the table is larger, but to
increase the accuracy. And to compensate for any other inaccuracies. 
Just a thought, if you're responsible for a data warehouse, you may
want to consider studying some basic statistics. Unfortunately most computer
science curriculums don't require a class in statistics. In fact, since
polls form a lot of our political discussion, it wouldn't hurt to require
all citizens to have some statistical training. It might make it harder for
politicians to mis-construe statistical results. However, it is hard enough
to get people just to vote, so I suppose that one isn't going to fly.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L


Jack,

Nielsen Ratings (the TV Rating company) monitors about 5000 people (and
their TV watching habits) to supply ratings for all the shows on most of the
networks for the whole United States. So, as long as you have a working and
proven statistical model, and a good sample, it works. How do I know, ever
seen anyone challenging Nielsen Ratings for a show? I haven't.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
-- 
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: Data Warehouse experts, a simple question for you

2002-05-22 Thread Thomas Day



Try running:

select 'IT DOES' from dual where 2 = '02';


I guess that SQLPlus is doing an implicit data conversion.



   

Paula_Stankus  

@doh.state.flTo: Multiple recipients of list ORACLE-L  

.us  [EMAIL PROTECTED]

Sent by: rootcc:   

 Subject: RE: Data Warehouse experts, a 
simple 
 question for you  

05/21/2002 

08:28 PM   

Please 

respond to 

ORACLE-L   

   

   







Okay you guys are silly.  I have probably a stupid basic question to ask.
How important is it to store data (let's say state codes, county codes with
leading zeroes as character versus numeric).  What is the standard out
there?  Does '02' mean the same thing as 2 for state code if you are
consistent throughout your warehouse or do we need to consider other
datasets out there that might be linked maybe sometime in the future?  Can
I leave it as is numeric and create materialized views with it padded or
should I bite the bullet and reload into char/varchar2 datatypes?

-Original Message-
Sent: Tuesday, May 21, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L

Yeah, that's a common misconception. You actually have
to prop the book on your forehead since English flows
to the left and downwards. I have heard that Chinese
flows from right to left and upwards or something
though - you might consider taking it up as a new
language if you are set on the underpillow method of
knowledge transfer.

/jack

--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 gee, and here I thought all I had to do was put the
 book under my
 pillow and let the words seep in through osmosis :)


 --- Jack Silvey [EMAIL PROTECTED] wrote:
  I find that if I wrap my books in Saran Wrap, I
 can
  read in the shower. And if you prop the book up on
  your shoulder, you can read it backwards in the
  rearview mirror during drive time. Also, if you
 learn
  to read in your sleep, you can get LOADS of stuff
  done.
 
  ;)
 
  hth,
/jack silvey
 
 
  --- Rachel Carmichael [EMAIL PROTECTED]
 wrote:
   it's cheaper on bookpool :)
  
   especially when Borders is out of stock
  
   you guys are killing my credit card!  I went out
 and
   bought Inmon's
   Building the Data Warehouse, BOTH Kimball books
 and
   and considering the
   Webhouse one as well geez, when do I have
 time
   to READ this stuff?
  
   Rachel
  
   --- [EMAIL PROTECTED] wrote:
Yup, $60, and worth every penny.
   
It may be 4 years old, but the information is
   still pertinent.
   
Jared
   
   
   
   
   
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
   
   
    To: Multiple recipients of list
   ORACLE-L
[EMAIL PROTECTED]
    cc:
    Subject:    Re: Data Warehouse
   experts, a simple question
for you
   
   
looks like published aug of 98 for that book?,
   like $60?
   
joe
   
   
[EMAIL PROTECTED] wrote:
   
Joe,

Add a generated PK to the time dimension.
 The PK
   is stored
as an FK in the fact table.

That way you can select from the time
 dimension
   by year, day, qtr,
whatever,
and easily pick out the correct fact table
 rows.

The Data Warehouse Lifecycle Toolkit
 includes a
   spreadsheet to
generate
the DDL/DML for a very robust time dimension.
  I
   think it has about
20
columns.

Very good book, can't recommend it enough.

Jared






Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L


    To: Multiple recipients of list
   ORACLE-L
[EMAIL PROTECTED]
    cc:
    Subject:    Data Warehouse
 experts, a
   simple question
for you


Ok i'm messing with dimensions.

dm_time to be exact:

create table dm_time
( calendar_date date not null,
  calendar_month number(2) not

New Oracle 9.x Pre-Install Script from Oracle

2002-05-22 Thread David Wagoner

Just saw this todayhavent tried it yet.

Excerpt from MetaLink:

News
Notes

New Script: Pre-Install script which checks your Unix
environment to ensure successful installation of Oracle 9.x version of RDBMS
The Data Server Support team is pleased to release a new
script for Unix RDBMS users. Customers who plan to install Oracle 9.x RDBMS
on an HP, Solaris, Tru64, AIX or Linux server can run this script to verify
that the server is configured according to the Oracle RDBMS installation
guides. The output will report the required tasks that need to be performed to
ensure a successful installation of Oracle 9.x RDBMS.
For more details on how to use and download the Unix InstallPrep Script, see document id 189256.1.
Thank you for using MetaLink.
Data Server Support Team
Oracle Support Services

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency
Parkway, Suite 110

Cary, NC
27511-8582

Office (919)
466-6723

Pager
[EMAIL PROTECTED]

Fax (919)
466-6783

http://www.arsenaldigital.com/

*** NOTICE ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail message
from your computer. Thank you.

Re: Statistical sampling and representative stats collection

2002-05-22 Thread Jack Silvey


Cherie,

Had some problems with DBMS_STATS, but we are making
our way towards it. Just have to be careful, since it
can do quirky things like analyze the dictionary. We
are using dba_tab_modifications to monitor our tables.

Thanks for the input.

Jack


--- [EMAIL PROTECTED] wrote:
 
 Jack,
 
 What version are you on?   Are you able to utilize
 the gather_stale option.
 That way you would not only be optimizing the amount
 you are estimating but
 the interval between analyzing.
 
 Of course, that option of DBMS_STATS is not
 available on older versions.
 
 Cherie Machler
 Oracle DBA
 Gelco Information Network
 
 
 
 

 Jack Silvey 
 

 jack_silvey@y   To:
 Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED] 
 ahoo.comcc:
 

 Sent by: Subject:   
  Re: Statistical sampling and representative stats  

 [EMAIL PROTECTED]collection
 

 om  
 

 
 

 
 

 05/21/02 06:19  
 

 PM  
 

 Please respond  
 

 to ORACLE-L 
 

 
 

 
 

 
 
 
 
 Hi Rafiq,
 
 We have been using 35 percent on our warehouse, even
 on our fact partitions. Now that I have thought
 about
 it for a while, that seems like a lot given the
 volume
 of data. If a representative sample can be gathered
 with 10,000 or 50,000 or 100,000 rows, and our fact
 partitions have millions of rows each, seems like we
 could go 1% on our analyze and it would be within
 acceptable tolerances.
 
 /jack
 
 
 --- Mohammad Rafiq [EMAIL PROTECTED] wrote:
  The most of the list memeber agrees on estimate
 with
  30%
 
  Regards
  Rafiq
 
 
 
 
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Date: Tue, 21 May 2002 13:43:33 -0800
 
  Hi all,
 
  Did some investigation about statistical sampling
  this
  weekend since we are going to optimize our analyze
  process soon, and would like some input from all
 you
  orabrains on this one.
 
  I opened a TAR with Oracle asking about the
 sampling
  algorithm of stats collection, and they assured me
  it
  was random.
 
  The goal of analyze...estimate is to collect stats
  that are representative of the data population as
 a
  whole using a given sample set. Since analyzing
  tables
  takes up resources (does sorts to order the data
 for
  investigation) the fewer rows you use in estimate,
  the
  less system resources you use and the faster the
  analyze will go.
 
  Since our goal is to get as small a sample as
  possible
  and still have stats that are representative, my
  contention is that we could start by finding what
  the
  margin of error will be for each sample size and
  gauge
  our tolerance for it.
 
  One standard way to calculate margin of error for
 a
  given sample is by using this formula:
 
  M = 1/SQRT(N)
 
  where:
  M = margin of error
  N=sample size
 
  So, if we can tolerate stats that have a 1% a
 margin
  of error (will deviate from representative of the
  whole population by 1%), our sample size should be
  10,000 rows.
 
  Also, a corollary (not a toyota corollary, though)
  to
  this would be that the more rows you add to your
  sample, the closer to representative your sample
  will
  be. So, in order to test whether your sample is
  representative enough, you could analyze using
  either
  estimate 49% or compute, take a snapshot of the
  stats,
  and then compare the stats from a 10,000 row
  estimate
  to those. Then, add rows to your estimate until
 you
  are satisfied with the stats.
 
  This of course is a pie in the sky mathematical
  model,
  but seems like a reasonable place to start with
  testing.
 
  Input? Input? Buhler?

RE: ok one for you windows/oracle people out there

2002-05-22 Thread Farnsworth, Dave


I have had these periodically happen but have not yet fixed it.  I'm reading the 
Oracle docs for NT memory management.  Hope to have a solution soon.

Dave

-Original Message-
Sent: Tuesday, May 21, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L


Whenever more users logon to the database we get Oracle error 'out of
process memory' and the process fails. It indicates that OS could not
allocate memory for the process. For Windows NT Enterprise Edition a
feature 4 GB Memory Tuning is available.

Anyone know anything about it, does it work, etc?


thanks, joe


-- 
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  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: ID This Wait stat

2002-05-22 Thread Tom Schruefer



Now that's a truly useful site, someone could make that into one of those
Pocket DBA books.  ;-

Thanks Lots...


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 [EMAIL PROTECTED]
 Sent: Tuesday, May 21, 2002 7:20 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: ID This Wait stat


 You can ignore them.

 See:   http://www.ixora.com.au/q+a/waits.htm





 Tom Schruefer [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 05/21/2002 01:32 PM
 Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc:
 Subject:ID This Wait stat



 You know I could have all the documentation for Oracle printed on my
 brain,
 buy all the books ever written about the subject, but the primary wait
 problem that comes up will never be directly addressed.

 So, what exactly does 'Slave Wait' mean and what can I do about it?


 I am using DBWR Slaves, since it did not seem as though starting
 additional
 DBWR's was appropriate on a Win2000 system.

 Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle
 Performance Tuning 101' book:

 Top 5 Wait Events
 ~ Wait %
 Total
 Event   Waits  Time (cs)   Wt
 Time
   
 -
 --
 slave wait 66,5936,793,939
 88.85
 PX Deq: Execution Msg  28,960  407,167
 5.33
 PX Deq: Table Q Normal 19,864  302,480
 3.96
 PX Deq Credit: send blkd3,685  123,671
 1.62
 PX Deq: Signal ACK  3,2145,294
 .07


 I have a pretty good idea that 2-5 are for parallel query option,
 although
 I
 still have to figure out just what they mean.


 Any help would be greatly appreciated.

 _
 Tom Schruefer - [EMAIL PROTECTED]
 410-313-6825

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tom Schruefer
   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:
   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: Tom Schruefer
  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: Statistical sampling and representative stats collection

2002-05-22 Thread Jamadagni, Rajendra


I remember, in 96/97, I was working on a Oracle 7 database and none of the
this sample() was available. My task was to select x people out of z number
of people randomly. We hired a temp, who took Dallas/Fort Worth dictionary
(I was working in that area) and counted (yes counted) number of people
whose last names started with A and B and so on.

We put this information into a table and then found out percentage of last
names starting with A compared to the whole list for each letter. This
percentage was used as weightage for each letter when choosing random
samples from a list of people. Then I used this weightage and dbms_random to
pick the required number of names from our database. It was fun to
implement, but I feel bad for the temp who had to count the names.

So, compared to that, 8i and 9i built-in features rock !!
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


***1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

Oracle Papers.

2002-05-22 Thread Mark Leith


Hi All,

I'd like to set up a technical papers section on the new iteration of the
Cool-Tools web site, and was wondering if there were any authors of papers
out there (such as Tim Cox's DBA Checklist, and Sean O'Neill's Oracle NT
Config Guide) that wouldn't mind me putting a copy of their documents on an
Oracle (tool) related site.. I'm open to also just linking to the documents
on their own site as well..

If you would like to contact me off the list please feel free.

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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 web application

2002-05-22 Thread Jack van Zanen



Hi,

I only needed basic functionality of the OCI calls and implemented that w/o
much problems. The problem was that there are a zillion examples of PHP 
MySQL but not with OCI on the internet.
If you have some good examples I will gladly have a look at them and file
them for possible future use


TIA


Jack


   

  SIM/HAOUHACH 

  [EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  natrach.dz  cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: Oracle web application

  [EMAIL PROTECTED] 

   

   

  22-05-2002 15:53 

  Please respond to

  ORACLE-L 

   

   




Hi,
Excuse my very bad english:-)
can you be more explicit, is what you seek to better understand the
utilization of  function OCI, because if it is that I can you to send
examples on what I have made,  that will be able surely to help you.
Therefore reply me rapidly:-)

LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]



 -Message d'origine-
 De:Jack van Zanen [SMTP:[EMAIL PROTECTED]]
 Date:mercredi 22 mai 2002 11:13
 À: Multiple recipients of list ORACLE-L
 Objet:   Re: Oracle web application


 Hi Aida,


 I've build a oracle monitor/admin website using PHP and Apache and Oracle
 repository.It's easy to implement/learn the basics. I had to find out
 about
 OCI and PHP because there was not much examples on that on the internet
 (obvious reason PHP=Free APACHE=Free  Oracle= well uhh NOT Free). I only
 needed the basic OCI calls though


 Jack




   Keith Carney

   kcarney@cox-inteTo:   Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]
   rnet.comcc:   (bcc: Jack van
 Zanen/nlzanen1/External/MEY/NL)
   Sent by: Subject:  Re: Oracle web
 application
   [EMAIL PROTECTED]





   21-05-2002 06:38

   Please respond to

   ORACLE-L








 Dennis, thanks for your answer
 Have you ever used before PHP and done anything of this kind of
 application
 that I want to accomplish? I need to dig out everything myself this
 summer.
 If you know someone that has done somthing alike please let me know.
 Thanks
 again.
 Star wars, right?
 Can you guess about me?
 Aida
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, May 20, 2002 10:38 AM


  Aida - Now that you have described your situation more clearly, I would
  second the advice you received from Sean - use PHP if you can. While
 this
  task can be accomplished with just about any language, with some
choices
 you
  will spend a lot of time getting everything set up. And you probably
 would
  have to use more than one language to accomplish some aspects. PHP was
  pretty much designed for quick Web pages and database interactivity.
 Some
  people here have been very successful with it. As a bonus, it sounds
 like
  you are already pretty accomplished in PHP. May the force be with you!
  (guess which movie I saw this weekend).
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Monday, May 20, 2002 10:29 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi Dennis, my name is Aida, (my fault about this)
 
  Keith is my husband (I love to bother him).
 
  Thank you for answering to me, I really appreciate it.
 
  Let me explain more

oracle FTPserver


Good morning everyone,

Please tell me the address for the Oracle FTP server.

Thanks,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Statistical sampling and representative stats collection

2002-05-22 Thread Jack Silvey


That is a very good question. Anyone else know the
answer?

My approach to skewness right now is to compare the
mean and the median of the entire dataset, since if
you have two measures of centrality that are not the
same, you have skewness. 

/jack

--- [EMAIL PROTECTED] wrote:
 
 Jack,
 
 Isn't the problem with this concept that it doesn't
 take into consideration
 how skewed the data is?   Statistically significance
 would be relevant to
 perfectly distributed data but wouldn't you need a
 higher percentage of
 data for significance in more highly skewed data?
 
 Just something to consider.
 
 Cherie Machler
 Oracle DBA
 Gelco Information Network
 
 
 
 

 Jack Silvey 
 

 jack_silvey@y   To:
 Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED] 
 ahoo.comcc:
 

 Sent by: Subject:   
  Re: Statistical sampling and representative stats  

 [EMAIL PROTECTED]collection
 

 om  
 

 
 

 
 

 05/21/02 06:19  
 

 PM  
 

 Please respond  
 

 to ORACLE-L 
 

 
 

 
 

 
 
 
 
 Hi Rafiq,
 
 We have been using 35 percent on our warehouse, even
 on our fact partitions. Now that I have thought
 about
 it for a while, that seems like a lot given the
 volume
 of data. If a representative sample can be gathered
 with 10,000 or 50,000 or 100,000 rows, and our fact
 partitions have millions of rows each, seems like we
 could go 1% on our analyze and it would be within
 acceptable tolerances.
 
 /jack
 
 
 --- Mohammad Rafiq [EMAIL PROTECTED] wrote:
  The most of the list memeber agrees on estimate
 with
  30%
 
  Regards
  Rafiq
 
 
 
 
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Date: Tue, 21 May 2002 13:43:33 -0800
 
  Hi all,
 
  Did some investigation about statistical sampling
  this
  weekend since we are going to optimize our analyze
  process soon, and would like some input from all
 you
  orabrains on this one.
 
  I opened a TAR with Oracle asking about the
 sampling
  algorithm of stats collection, and they assured me
  it
  was random.
 
  The goal of analyze...estimate is to collect stats
  that are representative of the data population as
 a
  whole using a given sample set. Since analyzing
  tables
  takes up resources (does sorts to order the data
 for
  investigation) the fewer rows you use in estimate,
  the
  less system resources you use and the faster the
  analyze will go.
 
  Since our goal is to get as small a sample as
  possible
  and still have stats that are representative, my
  contention is that we could start by finding what
  the
  margin of error will be for each sample size and
  gauge
  our tolerance for it.
 
  One standard way to calculate margin of error for
 a
  given sample is by using this formula:
 
  M = 1/SQRT(N)
 
  where:
  M = margin of error
  N=sample size
 
  So, if we can tolerate stats that have a 1% a
 margin
  of error (will deviate from representative of the
  whole population by 1%), our sample size should be
  10,000 rows.
 
  Also, a corollary (not a toyota corollary, though)
  to
  this would be that the more rows you add to your
  sample, the closer to representative your sample
  will
  be. So, in order to test whether your sample is
  representative enough, you could analyze using
  either
  estimate 49% or compute, take a snapshot of the
  stats,
  and then compare the stats from a 10,000 row
  estimate
  to those. Then, add rows to your estimate until
 you
  are satisfied with the stats.
 
  This of course is a pie in the sky mathematical
  model,
  but seems like a reasonable place to start

[Q] any problem ORACLE 9iR2 and RedHAt 7.3?

2002-05-22 Thread dist cash


Have anyone tried ORACLE 9iR2 with RedHat7.3?

Any problem?

Thanks.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dist cash
  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: shared pool

2002-05-22 Thread Reddy, Madhusudana



Sherman,

I found the following SQL from Tim Gorman's site...

this will create a file , which can be run to pin the objects, It Pins
CURSORS as well as the other objects ( not the tables ).

set tab off echo off feedback off timing off trimout on pause off
set trimspool on pages 0 lines 500 verify off
col instance new_value V_INSTANCE noprint
select  lower(replace(t.instance,chr(0),'')) instance
fromsys.v$threadt,
sys.v$parameter p
where   p.name = 'thread'
and t.thread# = to_number(decode(p.value,'0','1',p.value));
col sort0 noprint
col sort1 noprint
col sort2 noprint
col sort3 noprint
spool run_pin_V_INSTANCE..sql
prompt whenever sqlerror exit failure
prompt set echo on feedback on timing on pagesize 100
prompt spool run_pin_V_INSTANCE
select  decode(kept, 'YES', 'unkeep', 'keep') sort0,
type sort1,
owner sort2,
name sort3,
'exec dbms_shared_pool.' ||
decode(kept, 'YES', 'unkeep', 'keep') || '(''' ||
owner || '.' || name || ''',''' ||
decode(type,'TYPE', 'T',
'TRIGGER', 'R',
'SEQUENCE', 'Q', 'P') || ''');' text
fromsys.v$db_object_cache
where   ((executions = 100 and kept = 'NO')
or   (executions  100 and kept = 'YES'))
and type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION','TYPE',
 'TRIGGER','SEQUENCE')
union
select distinct decode(o.kept, 'YES', 'unkeep', 'keep') sort0,
o.type sort1,
o.owner sort2,
o.name sort3,
'exec dbms_shared_pool.' ||
decode(o.kept, 'YES', 'unkeep', 'keep') || '(''' ||
a.address || ', ' || a.hash_value || ''');' text
fromsys.v$db_object_cache   o,
sys.v$sqlarea   a
where   ((o.executions = 100 and o.kept = 'NO')
or   (o.executions  100 and o.kept = 'YES'))
and o.type in ('CURSOR', 'INVALID TYPE')
and a.sql_text = o.name
order by 1 desc, 2 asc, 3 asc, 4 asc;
prompt spool off
spool off
--/*REM start run_pin_V_INSTANCE*/



Thanks,
Madhu

-Original Message-
Sent: Wednesday, May 22, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


Rafiq,

I ran your query as we have been in the process of tuning our shared pool,
and I have a question. When you see many more loads than executions for a
given table, is it a safe bet that the application in question is executing
queries that have that table in the from clause, but it is not being used by
that query ? For example, a table has 33 loads and 5 executions. Could I say
that 28 loads were caused by a query that had that table referenced, but not
used (and causing a full table scan, because that's what Oracle does when
you reference, but do not use, a table (in the from clause) ?

Thank you,

Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  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: Reddy, Madhusudana
  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).

OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Denham Eva


Hello Listers,

I have what I hope is challenging problem.
I am trying to create a procedure that execs from a trigger on a table.
Simple enough.
But I want to capture the OSUSER value from v$session so that the there is a
history of changes to the table and by whom.
Problem with using USER function is that all the users access the server via
a third party app and therefore have one username.
Pretty pointless for this effort then, as I could update the column in the
history table with that user and be done with it.
But the use of UID also does not work because that brings back a whole list
of all the OSUSER value.

ie 

CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE)
IS
  V_UID NUMBER;
   V_OSUSER
BEGIN
  
   BEGIN
   SELECT UID 
INTO V_UID
   FROM DUAL;
   END;

  BEGIN
   SELECT OSUSER
 INTO V_OSUSER
   FROM V$SESSION
   WHERE OSUSER := V_UID;
  END

rest of procedure.Includes insert etc
END TEST

Now obviously this returns more than one row as all the users use the same
username through  the app.
Any suggestion?

Many TIA
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.


#
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
For more information please visit www.marshalsoftware.com
#
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denham Eva
  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: ITL Deadlock Example?

2002-05-22 Thread Walter K


Thanks for the replies (K,Jonathan,Anjo). I'm getting 
deadlocks to occur but they're not producing the 
deadlock graphs I was expecting to see.

I'm looking to reproduce the scenario that will 
generate the following kind of deadlock graph--where 
it looks like a self-deadlock:

   -Blocker(s)  ---
--Waiter(s)-
Resource Name  process session holds waits  
process session holds waits
TX-00050032-214322  23 
X 22  23   S
session 23: DID 0001-0016-17E7  session 23: 
DID 0001-0016-17E7
Rows waited on:
Session 23: no row

But, the deadlock graph that my testing is generating 
looks like:
  -Blocker(s)  
-Waiter(s)-
Resource Name  process session holds waits  
process session holds waits
TX-00030052-1fb911  11 
X 12  15   X
TX-00040058-23ef12  15 
X 11  11   X
session 11: DID 0001-000B-0002 session 15: DID 
0001-000C-0002
session 15: DID 0001-000C-0002 session 11: DID 
0001-000B-0002
Rows waited on:
Session 15: obj - rowid = 153E - AAABU+AAFLIAAA
Session 11: obj - rowid = 153E - AAABU+AAFACAAA


It is my understanding that the deadlock graph I am 
trying to reproduce is caused by ITL shortage 
deadlocks. I have verified, via 
dbms_rowid.rowid_block_number(), that I am updating 
rows in different blocks.

Thanks again.
-w



It gets more complicated under Oracle 9 because
initrans has a minimum value of 2 on tables; but
under oracle 8, the following should work:

create table t1
initrans 1
maxtrans 1

insert a few dozen rows into t1
so that there are rows in at least 
two blocks, and commit.

session 1
update a row in block 1
session 2
update a row in block 2
session 1
update a row in block 2  -- will wait on a TX/4
session 2
update a row in block 1  -- will wait on a TX/4

After ca, three seconds session 1 will report ORA-
00060.


In Oracle 9, you may get lucky with just two blocks
of data and three concurrent sessions, but for 
consistency you need to have three blocks of data and 
rotate through the sessions updating one row in each 
block from each session in turn.



Jonathan Lewis
http://www.jlcomp.demon.co.uk



|Walter K wrote:
|
| Can someone post an example of how to trigger a
| deadlock (ORA-0060) due to ITL shortage? This is for
| informational/fact-finding purposes.
|
| I've created a test table with MAXTRANS=1 and can
| cause the enqueue waits between two sessions
| contending for the same block but I can't seem to
| cause a deadlock to occur.
|
| Thanks.
| -w
|


-- 
Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: Walter K
  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: ID This Wait stat

2002-05-22 Thread Grabowy, Chris


Pocket book???  I was thinking more like an encyclopedia...the extended
edition...

-Original Message-
Sent: Wednesday, May 22, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L



Now that's a truly useful site, someone could make that into one of those
Pocket DBA books.  ;-

Thanks Lots...


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 [EMAIL PROTECTED]
 Sent: Tuesday, May 21, 2002 7:20 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: ID This Wait stat


 You can ignore them.

 See:   http://www.ixora.com.au/q+a/waits.htm





 Tom Schruefer [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 05/21/2002 01:32 PM
 Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc:
 Subject:ID This Wait stat



 You know I could have all the documentation for Oracle printed on my
 brain,
 buy all the books ever written about the subject, but the primary wait
 problem that comes up will never be directly addressed.

 So, what exactly does 'Slave Wait' mean and what can I do about it?


 I am using DBWR Slaves, since it did not seem as though starting
 additional
 DBWR's was appropriate on a Win2000 system.

 Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle
 Performance Tuning 101' book:

 Top 5 Wait Events
 ~ Wait %
 Total
 Event   Waits  Time (cs)   Wt
 Time
   
 -
 --
 slave wait 66,5936,793,939
 88.85
 PX Deq: Execution Msg  28,960  407,167
 5.33
 PX Deq: Table Q Normal 19,864  302,480
 3.96
 PX Deq Credit: send blkd3,685  123,671
 1.62
 PX Deq: Signal ACK  3,2145,294
 .07


 I have a pretty good idea that 2-5 are for parallel query option,
 although
 I
 still have to figure out just what they mean.


 Any help would be greatly appreciated.

 _
 Tom Schruefer - [EMAIL PROTECTED]
 410-313-6825

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tom Schruefer
   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:
   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: Tom Schruefer
  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: Grabowy, Chris
  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 FTPserver

2002-05-22 Thread Mark Leith


ftp://oracle-ftp.oracle.com/server/patchsets/

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance 
 

-Original Message-
Gramolini
Sent: 22 May 2002 17:04
To: Multiple recipients of list ORACLE-L


Good morning everyone,

Please tell me the address for the Oracle FTP server.

Thanks,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Mark Leith
  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 web application

2002-05-22 Thread Keith Carney


Hi Lynda,

Thank you for answering to me, I really appreciate it.

Let me explain more clear the situation.

I am a graduate student at Stephen F. Austin State University in computer
science department.

I will graduate next summer. As part of my graduation the department has
assigned me the project

of Computer Science Programming Contest that is done every year. The way the
contest is organized

is this: There is a web site in which the student can register in teams of 3
or 4, they need to give their info

(first name, last name, phone, class, address, for each member, the name of
the team) and a user name

and password is assigned to each team so they can come back and change it at
any time.

At the contest day, to each time is given their account on TITANS and
password and directions how

they can send their answers back by mail form their account to the jury.
Every team-member can program in

C, C++ or COBOL (languages that are taught at our university). After the
e-mail is sent, the judge sends

back the result of the answer.

The way that is done until last time is this. A faculty member used the PHP
to make the registration and

humans do all the other part. (this is what they want to avoid mainly and
this time I think they are

going to use also UNIX accounts for students)

I took an oracle class (is the first time that is offered) this spring and
they assigned me to do this project using oracle.

I have learned SQL and PL/SQL and some of the basics of Oracle. I have
designed some web sites before

with forms, but never any one in interaction with the user and a database.
That's why I need help for basically

everything. (even for the general concept). Should I still use PHP or is
there any better choice? This is my first

big question right now but to tell you the truth I have everything under
question mark. But one thing at a time

and I am hunting around to get more comfortable with this problem.

Thank you very much for your time

AIDA

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 7:53 AM


Hi,
Excuse my very bad english:-)
can you be more explicit, is what you seek to better understand the
utilization of  function OCI, because if it is that I can you to send
examples on what I have made,  that will be able surely to help you.
Therefore reply me rapidly:-)

LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]



 -Message d'origine-
 De: Jack van Zanen [SMTP:[EMAIL PROTECTED]]
 Date: mercredi 22 mai 2002 11:13
 À: Multiple recipients of list ORACLE-L
 Objet: Re: Oracle web application


 Hi Aida,


 I've build a oracle monitor/admin website using PHP and Apache and Oracle
 repository.It's easy to implement/learn the basics. I had to find out
 about
 OCI and PHP because there was not much examples on that on the internet
 (obvious reason PHP=Free APACHE=Free  Oracle= well uhh NOT Free). I only
 needed the basic OCI calls though


 Jack




   Keith Carney

   kcarney@cox-inteTo:   Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]
   rnet.comcc:   (bcc: Jack van
 Zanen/nlzanen1/External/MEY/NL)
   Sent by: Subject:  Re: Oracle web
 application
   [EMAIL PROTECTED]





   21-05-2002 06:38

   Please respond to

   ORACLE-L








 Dennis, thanks for your answer
 Have you ever used before PHP and done anything of this kind of
 application
 that I want to accomplish? I need to dig out everything myself this
 summer.
 If you know someone that has done somthing alike please let me know.
 Thanks
 again.
 Star wars, right?
 Can you guess about me?
 Aida
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, May 20, 2002 10:38 AM


  Aida - Now that you have described your situation more clearly, I would
  second the advice you received from Sean - use PHP if you can. While
 this
  task can be accomplished with just about any language, with some choices
 you
  will spend a lot of time getting everything set up. And you probably
 would
  have to use more than one language to accomplish some aspects. PHP was
  pretty much designed for quick Web pages and database interactivity.
 Some
  people here have been very successful with it. As a bonus, it sounds
 like
  you are already pretty accomplished in PHP. May the force be with you!
  (guess which movie I saw this weekend).
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Monday, May 20, 2002 10:29 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi Dennis, my name is Aida, (my fault about this)
 
  Keith is my husband (I love to bother him).
 
  Thank you for answering to me, I really appreciate it.
 
  Let me explain more clear the

9ir2 and rh 7.3

2002-05-22 Thread JOE TESTA




thats a configuration i hope to have tested this weekend.

battling stupid dimensions and query-rewrite or would have done it 
already.

joe

partitioning

2002-05-22 Thread Cunningham, Gerald

Title: Message



Hi 
all,

Does anybody know 
with what version of Oracle partitioning was included at no extra 
cost?


Thanks!

- 
Jerry

Re: Statistical sampling and representative stats collection

2002-05-22 Thread Mohammad Rafiq


Jack
You are right keeping in mind your application and variation of data in 
different tables. I just mentioned 30% as most agreed percentage for 
estimate. I think Dennis gave you a more pracitcial answer yesterday.

Regards
Rafiq





Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 21 May 2002 15:19:31 -0800

Hi Rafiq,

We have been using 35 percent on our warehouse, even
on our fact partitions. Now that I have thought about
it for a while, that seems like a lot given the volume
of data. If a representative sample can be gathered
with 10,000 or 50,000 or 100,000 rows, and our fact
partitions have millions of rows each, seems like we
could go 1% on our analyze and it would be within
acceptable tolerances.

/jack


--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
  The most of the list memeber agrees on estimate with
  30%
 
  Regards
  Rafiq
 
 
 
 
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Date: Tue, 21 May 2002 13:43:33 -0800
 
  Hi all,
 
  Did some investigation about statistical sampling
  this
  weekend since we are going to optimize our analyze
  process soon, and would like some input from all you
  orabrains on this one.
 
  I opened a TAR with Oracle asking about the sampling
  algorithm of stats collection, and they assured me
  it
  was random.
 
  The goal of analyze...estimate is to collect stats
  that are representative of the data population as a
  whole using a given sample set. Since analyzing
  tables
  takes up resources (does sorts to order the data for
  investigation) the fewer rows you use in estimate,
  the
  less system resources you use and the faster the
  analyze will go.
 
  Since our goal is to get as small a sample as
  possible
  and still have stats that are representative, my
  contention is that we could start by finding what
  the
  margin of error will be for each sample size and
  gauge
  our tolerance for it.
 
  One standard way to calculate margin of error for a
  given sample is by using this formula:
 
  M = 1/SQRT(N)
 
  where:
  M = margin of error
  N=sample size
 
  So, if we can tolerate stats that have a 1% a margin
  of error (will deviate from representative of the
  whole population by 1%), our sample size should be
  10,000 rows.
 
  Also, a corollary (not a toyota corollary, though)
  to
  this would be that the more rows you add to your
  sample, the closer to representative your sample
  will
  be. So, in order to test whether your sample is
  representative enough, you could analyze using
  either
  estimate 49% or compute, take a snapshot of the
  stats,
  and then compare the stats from a 10,000 row
  estimate
  to those. Then, add rows to your estimate until you
  are satisfied with the stats.
 
  This of course is a pie in the sky mathematical
  model,
  but seems like a reasonable place to start with
  testing.
 
  Input? Input? Buhler? Buhler?
 
 
  /jack silvey
 
 
  __
  Do You Yahoo!?
  LAUNCH - Your Yahoo! Music Experience
  http://launch.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).
 
 
 
 
  MOHAMMAD RAFIQ
 
 
 
_
  Join the worlds largest e-mail service with MSN
  Hotmail.
  http://www.hotmail.com
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Mohammad Rafiq
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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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:

RE: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread Magaliff, Bill


I, too, have a situation whereby all users access the db via third party app
with single credentials - haven't found a way around it, other then
application-side logging

-bill

-Original Message-
Sent: Wednesday, May 22, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L


Hello Listers,

I have what I hope is challenging problem.
I am trying to create a procedure that execs from a trigger on a table.
Simple enough.
But I want to capture the OSUSER value from v$session so that the there is a
history of changes to the table and by whom.
Problem with using USER function is that all the users access the server via
a third party app and therefore have one username.
Pretty pointless for this effort then, as I could update the column in the
history table with that user and be done with it.
But the use of UID also does not work because that brings back a whole list
of all the OSUSER value.

ie 

CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE)
IS
  V_UID NUMBER;
   V_OSUSER
BEGIN
  
   BEGIN
   SELECT UID 
INTO V_UID
   FROM DUAL;
   END;

  BEGIN
   SELECT OSUSER
 INTO V_OSUSER
   FROM V$SESSION
   WHERE OSUSER := V_UID;
  END

rest of procedure.Includes insert etc
END TEST

Now obviously this returns more than one row as all the users use the same
username through  the app.
Any suggestion?

Many TIA
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.



#
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
For more information please visit www.marshalsoftware.com

#
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denham Eva
  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: oracle FTPserver

2002-05-22 Thread Karniotis, Stephen


   ftp://oracle-ftp.oracle.com



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, May 22, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject:oracle FTPserver

Good morning everyone,

Please tell me the address for the Oracle FTP server.

Thanks,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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 FTPserver


Thanks!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 12:43 PM


ftp://oracle-ftp.oracle.com



 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, May 22, 2002 12:04 PM
 To: Multiple recipients of list ORACLE-L
 Subject: oracle FTPserver

 Good morning everyone,

 Please tell me the address for the Oracle FTP server.

 Thanks,
 Ruth

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ruth Gramolini
   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: Ruth Gramolini
  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).

patchset 8.1.7.3 or 8.1.7.4


Dear List,

What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I
download them?   I looking on the FTP site and on Metalink but I couldn't
tell which was which.

Thanks,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: ORA-2085


At last something that I have experience in.

Just do the following:

On the target database issue the following:
Alter database rename global_name to donot_trigger;

We had the same problem. This solves it.
The global name has no other influence.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 6:08 PM


 Yes, I inherited this, and I am setting up Multimaster
 Advanced Replication, setting global_names=false isn't an
 option.  I have suggested moving the donotfiretrigger logic
 into the trigger, which has some initial support.  For the
 moment, we are changing the code to point to a link with the
 same name as the service name (which has obvious limitations,
 so hopefully a real fix will get done).

 I was really hoping there might be another workaround bandaid
 though, as I really don't want the fix to end up permanent.

 Thanks,

 John P Weatherman
 Database Administrator
 Replacements Ltd.



 -Original Message-
 Sent: Tuesday, May 21, 2002 11:23 AM
 To: Multiple recipients of list ORACLE-L


 My guess is that you inherited an environment
 where the DB-Link was setup that way [link-name different
 from DB-name] . and then, sometime later,
 you set GLOBAL_NAMES=TRUE

 Well you have no choice :
 // *Action: create a database link with the same name as the database it
  //  connects to, or set global_names=false.

 Are you setting up Advanced Replication [MultiMaster]
 or Simple Replication [Snapshots] ?  I believe that
 Simple Replication does not mandate GLOBAL_NAMES=TRUE.


 Hemant K Chitale

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, 21 May, 2002 9:23 PM


  Hi all.
 
  I have recently had to enable global_names in order to set up a
  replicated environment.  The application uses a database link to
  reconnect to the database under a differant user id (I inheirited
  this, I had nothing to do with the design!).  Appearantly,
  global_names has a prblem with this...
 
  SQL  select * from [EMAIL PROTECTED];
  select * from [EMAIL PROTECTED]
 *
  ERROR at line 1:
  ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD
 
  SQL !oerr ORA 2085
  02085, 0, database link %s connects to %s
  // *Cause: a database link connected to a database with a different
name.
  //  The connection is rejected.
  // *Action: create a database link with the same name as the database it
  //  connects to, or set global_names=false.
 
  So, does anybody have any work arounds or ideas how I can get this
  thing working again?
 
  TIA,
 
  John P Weatherman
  Database Administrator
  Replacements Ltd.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: John Weatherman
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: Hemant K Chitale
   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: John Weatherman
   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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle 9i and Tables Owned by SYS

2002-05-22 Thread MacGregor, Ian A.


There is a difference in how privileges are handled in anonymous PL/SQL blocks vs. 
stored procedures, packages etc.  I should have made it more clear that this was not 
from an anonymous block, but from a package.

Ian

-Original Message-
Sent: Wednesday, May 22, 2002 2:38 AM
To: Multiple recipients of list ORACLE-L


mcdonac@cust9 select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.0.1.3.0 -
Production
PL/SQL Release 9.0.1.3.0 - Production
CORE9.0.1.2.0   Production
TNS for Solaris: Version 9.0.1.3.0 - Production
NLSRTL Version 9.0.1.3.0 - Production

mcdonac@cust9 select * from session_roles;

ROLE
--
DBA
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
JAVA_ADMIN
JAVA_DEPLOY

9 rows selected.

mcdonac@cust9 variable a1 number
mcdonac@cust9 variable a2 number
mcdonac@cust9 variable a3 number
mcdonac@cust9 variable a4 number
mcdonac@cust9 variable a5 number
mcdonac@cust9 variable a6 number
mcdonac@cust9 variable a7 number
mcdonac@cust9 begin
  2 
sys.dbms_space.unused_space('SYS','PARTLOB$','TABLE',
  3  :a1, :a2, :a3, :a4, :a5, :a6, :a7 );
  4  end;
  5  /

PL/SQL procedure successfully completed.

mcdonac@cust9 set role none;

Role set.

mcdonac@cust9 begin
  2 
sys.dbms_space.unused_space('SYS','PARTLOB$','TABLE',
  3  :a1, :a2, :a3, :a4, :a5, :a6, :a7 );
  4  end;
  5  /
begin
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SPACE, line 59
ORA-06512: at line 2

mcdonac@cust9 set role DBA;

Role set.

mcdonac@cust9 begin
  2 
sys.dbms_space.unused_space('SYS','PARTLOB$','TABLE',
  3  :a1, :a2, :a3, :a4, :a5, :a6, :a7 );
  4  end;
  5  /

PL/SQL procedure successfully completed.

hth
Connor

 --- MacGregor, Ian A. [EMAIL PROTECTED]
wrote:  I am in the process of moving a small
database to
 Oracle 9.0.1.3.  I have installed my own space
 management spaces.  It  measures growth of objects
 and tablespace usage and works well in Oracle 8i. 
 The package does not work well with the 9i SYS
 tables; it returns table or view does not exist,
 when calling dbms_space.unused_space.  I'm not sure
 if this is for all SYS tables or just a few.
 
   The owner of the package has select any table,
 select any dictionary, and I even tried the under
 any view privilege,  but no luck.  The select any
 table privilege, N.B., this is a privilege not a
 role, which obviously must be judiciously given,
 allowed, one running Oracle 8i to write packages
 referencing SYS objects without having to do
 individual grants on the tables.  It is still doing
 so for non-SYS tables, the calls to dbms_space work
 fine for them.  Any idea on the SYS tables?  Must
 they be granted individually?
 
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 -- 
 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Some days you're the pigeon, some days you're the statue

__
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?Connor=20McDonald?=
  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

RE: How to find current ORACLE_HOME programmatically

2002-05-22 Thread Alex Hillman


Looks like no takers, except one whos great advice was to find it somewhere
in the registry.

Alex Hillman

-Original Message-
Hillman
Sent: Monday, May 20, 2002 7:08 PM
To: Multiple recipients of list ORACLE-L


Hi, guys.

I need to find current value of ORACLE_HOME on the client from VB program,
running on that client. I understand that it is in the registry somewhere. I
have 2 client installations - one is 8.1.7 and another is 9 on the same
client. Apparently EM from 9 installation knows that needed tsnames.ora is
in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation.
And my VB program select tsnames.ora from 8.1.7 installation

Any ideas?

Alex Hillman


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
  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: Alex Hillman
  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: partitioning

Title: Message



None

It is an option (Means you pay).

Yechiel AdarMehish

  - Original Message - 
  From: 
  Cunningham, Gerald 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, May 22, 2002 6:38 
  PM
  Subject: partitioning
  
  Hi 
  all,
  
  Does anybody know 
  with what version of Oracle partitioning was included at no extra 
  cost?
  
  
  Thanks!
  
  - 
  Jerry

Re: Rename Column in 9iR2

2002-05-22 Thread Ron Rogers


Kevin,
 Yes but does it work with data in the column?, I do not have 9i set up
yet. If it works as you describe with data in the column it will really
help with the multi million row tables that they want to rename a
column  after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR mª¿ªm

 [EMAIL PROTECTED] 05/22/02 10:38AM 
Summary: it works!

SQL SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL create table test_table (wrong_name VARCHAR2(40));

Table created.

SQL alter table test_table rename column wrong_name to right_name;

Table altered.

SQL desc test_table;
 Name  Null?Type
 - 

 RIGHT_NAME VARCHAR2(40)

SQL 

Kevin Toepke
[EMAIL PROTECTED] 



The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Toepke, Kevin M
  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: Ron Rogers
  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: New Oracle 9.x Pre-Install Script from Oracle

2002-05-22 Thread Jesse, Rich


On HP/UX at least, it doesn't work very well unless you've modified every
kernel parameter stated in the install docs, even if the default is
adequate.  Only the modified values get put into /stand/system, which the
script greps.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Wednesday, May 22, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Just saw this today...haven't tried it yet.
 
Excerpt from MetaLink:
 
News  Notes
New Script: Pre-Install script which checks your Unix environment to ensure
successful installation of Oracle 9.x version of RDBMS 
The Data Server Support team is pleased to release a new script for Unix
RDBMS users. Customers who plan to install Oracle 9.x RDBMS on an HP,
Solaris, Tru64, AIX or Linux server can run this script to verify that the
server is configured according to the Oracle RDBMS installation guides. The
output will report the required tasks that need to be performed to ensure a
successful installation of Oracle 9.x RDBMS. 
For more details on how to use and download the Unix InstallPrep Script, see
document id 189256.1. 
Thank you for using MetaLink. 
Data Server Support Team
Oracle Support Services

 
 
David B. Wagoner
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: partitioning


Absolutely true! Even worse, it is an option on top of Enterprise Edition,
so you can't license Standard Edition and buy the partitioning option.

-Original Message-
Sent: Wednesday, May 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L


None
 
It is an option (Means you pay).
 
Yechiel Adar
Mehish

- Original Message - 
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]  
Sent: Wednesday, May 22, 2002 6:38 PM

Hi all,
 
Does anybody know with what version of Oracle partitioning was included at
no extra cost?
 
 
Thanks!
 
- Jerry

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

2002-05-22 Thread Richard Huntley

Title: SQL Server to Oracle DB



That's 
exactly what I want to stop, passwords being sent in the clear. However, 
I'm not able to verify it's working so far. I've turned on tracing, as 
recommended in another reply on this topic, did a login before enabling then 
after enabling this parameter and the differences are very minor and I'm seeing 
nothing that specifically points
to 
this parameter being used other than output saying the parameter is 
detected. How are you all having developers connect to the production box 
via SQL*Plus client on developer workstations, so that the password is not sent 
in the clear?

-Original Message-From: MacGregor, Ian A. 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 8:18 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
ORA_ENCRYPT_LOGIN
Even 
without this parameter being setthe password is encrypted. What the 
parameter does is stop the password from being sent in the clear if logging in 
with the encrypted password fails. I believe the encryption is a 
54-bit variant of DES. It is very rare that someone improves 
DES by fiddling with it. It also always encrypts to the same value and 
provides no protection against replay attacks.

Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 9:34 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA_ENCRYPT_LOGIN
  Anyone using this and if so, do you know of a way to 
  verify that the password is actually being encrypted?
  
  Thanks.

Re: Rename Column in 9iR2

2002-05-22 Thread Keith Peterson


wish this had come about 20 years ago, as it would
have saved us approx. 2 man years of dev. time
(conservative estimate).

Considering all 9i enhancements... this feature should
weigh in at well over 25%

Keith

Date: Wed, 22 May 2002 06:38:37 -0800 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] 
Reply-to: [EMAIL PROTECTED] 
Organization: Fat City Network Services, San Diego,
California 
 
 
Summary: it works!

SQL SELECT * FROM v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0   Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL create table test_table (wrong_name
VARCHAR2(40));

Table created.

SQL alter table test_table rename column wrong_name
to right_name;

Table altered.

SQL desc test_table;
 Name  Null?   
Type
 - 

 RIGHT_NAME
VARCHAR2(40)

SQL 

Kevin Toepke
[EMAIL PROTECTED]



__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Keith Peterson
  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: parametric Views

2002-05-22 Thread Connor McDonald


Check out the SYS_CONTEXT package. 

hth
connor

 --- Shishir Kumar Mishra [EMAIL PROTECTED]
wrote:  Can any one of u tell me  How to create 
parametric
 views?? 
 
 
 thanx in advance..
 Shishir Kumar Mishra
 
 
  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Some days you're the pigeon, some days you're the statue

__
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?Connor=20McDonald?=
  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).

How to create Redo Log Members. Oracle8.1.7

2002-05-22 Thread Meomeo Nguyen

Hi,
I just wantedto create new online redo log members forexisting groups. Currently I have 3 online redo log groups. Each one contains only one member. Here is information about the online redo log of a database
select group#, bytes, members from sys.v$log;
GROUP# BYTES MEMBERS-- -- -- 1 512000 1 2 512000 1 3 512000 1
select * from sys.v$logfile where group# = 1;
GROUP# STATUS MEMBER-- --- - 1 /Disk01/app/oradata/ttdb/redo01.log
select * from sys.v$logfile where group# = 2;
GROUP# STATUS MEMBER-- --- -2/Disk01/app/oradata/ttdb/redo02.log
select * from sys.v$logfile where group# = 3;
GROUP# STATUS MEMBER-- --- -3/Disk01/app/oradata/ttdb/redo03.log

After reading the Database Administrator's Guide about how to create online redo log members, I ama little bit confusedabout the file extension foronline redo logfiles.To create new online redo log members foran existing group, use the
alter database add logfile member'/oracle/dbs/log2b.rdo' to group 1; (From Orcle8.1.6 Administrator's Guide).
Based on my query information, member of group 1 is /Disk01/app/oradata/ttdb/redo01.log. My question is why the extension of the member of my redo log file is .log, which is different from the Oracle Administrator's Guide's above example?Here is my SQL statement to create redo log member for each existing group.
alter database add logfile member ' /Disk02/app/oradata/ttdb/redo01a.log to group 1; /* I place this member of group 1 in different location.
Just wondered whether this is a correct statement to create online redo log member. If not, please show me how to fix it. Please help.
I want to add new online redo log member for existing groups because I want to safeguard against a single point of online redo log failure.
Thanks in advance.
TrangDo You Yahoo!?
LAUNCH - Your Yahoo! Music Experience

AW: OSUSER in V$SESSION capture in procedure?

2002-05-22 Thread v . schoen


Hi Eva,

1. If there is always the same osuser, why don't you use a default value.
2. Your proc couldn't work, because
Select uid from dual;
UID Gives you the USER_ID (number) from all_users.
Then you compare OSUSER (char) with UID(number)?

This should work:

CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE) IS
  V_UID NUMBER;
   V_OSUSER
BEGIN
  
   BEGIN
   SELECT UID 
INTO V_UID
   FROM DUAL;
   END;

  BEGIN
   SELECT USERNAME
 INTO V_OSUSER
   FROM ALL_USERS
   WHERE USER_ID := V_UID;
  END

rest of procedure.Includes insert etc
END TEST

HTH

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Denham Eva [mailto:[EMAIL PROTECTED]] 
Gesendet: Mittwoch, 22. Mai 2002 17:34
An: Multiple recipients of list ORACLE-L
Betreff: OSUSER in V$SESSION capture in procedure?


Hello Listers,

I have what I hope is challenging problem.
I am trying to create a procedure that execs from a trigger on a table.
Simple enough. But I want to capture the OSUSER value from v$session so that
the there is a history of changes to the table and by whom. Problem with
using USER function is that all the users access the server via a third
party app and therefore have one username. Pretty pointless for this effort
then, as I could update the column in the history table with that user and
be done with it. But the use of UID also does not work because that brings
back a whole list of all the OSUSER value.

ie 

CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE) IS
  V_UID NUMBER;
   V_OSUSER
BEGIN
  
   BEGIN
   SELECT UID 
INTO V_UID
   FROM DUAL;
   END;

  BEGIN
   SELECT OSUSER
 INTO V_OSUSER
   FROM V$SESSION
   WHERE OSUSER := V_UID;
  END

rest of procedure.Includes insert etc
END TEST

Now obviously this returns more than one row as all the users use the same
username through  the app. Any suggestion?

Many TIA
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.



#
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
For more information please visit www.marshalsoftware.com

#
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denham Eva
  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:
  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: ORA-2085


Yechiel - If this does what I think it does, your value to postings ratio
just soared!
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 22, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L


At last something that I have experience in.

Just do the following:

On the target database issue the following:
Alter database rename global_name to donot_trigger;

We had the same problem. This solves it.
The global name has no other influence.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 6:08 PM


 Yes, I inherited this, and I am setting up Multimaster
 Advanced Replication, setting global_names=false isn't an
 option.  I have suggested moving the donotfiretrigger logic
 into the trigger, which has some initial support.  For the
 moment, we are changing the code to point to a link with the
 same name as the service name (which has obvious limitations,
 so hopefully a real fix will get done).

 I was really hoping there might be another workaround bandaid
 though, as I really don't want the fix to end up permanent.

 Thanks,

 John P Weatherman
 Database Administrator
 Replacements Ltd.



 -Original Message-
 Sent: Tuesday, May 21, 2002 11:23 AM
 To: Multiple recipients of list ORACLE-L


 My guess is that you inherited an environment
 where the DB-Link was setup that way [link-name different
 from DB-name] . and then, sometime later,
 you set GLOBAL_NAMES=TRUE

 Well you have no choice :
 // *Action: create a database link with the same name as the database it
  //  connects to, or set global_names=false.

 Are you setting up Advanced Replication [MultiMaster]
 or Simple Replication [Snapshots] ?  I believe that
 Simple Replication does not mandate GLOBAL_NAMES=TRUE.


 Hemant K Chitale

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, 21 May, 2002 9:23 PM


  Hi all.
 
  I have recently had to enable global_names in order to set up a
  replicated environment.  The application uses a database link to
  reconnect to the database under a differant user id (I inheirited
  this, I had nothing to do with the design!).  Appearantly,
  global_names has a prblem with this...
 
  SQL  select * from [EMAIL PROTECTED];
  select * from [EMAIL PROTECTED]
 *
  ERROR at line 1:
  ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD
 
  SQL !oerr ORA 2085
  02085, 0, database link %s connects to %s
  // *Cause: a database link connected to a database with a different
name.
  //  The connection is rejected.
  // *Action: create a database link with the same name as the database it
  //  connects to, or set global_names=false.
 
  So, does anybody have any work arounds or ideas how I can get this
  thing working again?
 
  TIA,
 
  John P Weatherman
  Database Administrator
  Replacements Ltd.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: John Weatherman
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: Hemant K Chitale
   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: John Weatherman
   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: 9iR2 Install Problem

2002-05-22 Thread Toepke, Kevin M


Stephen:

I can run Java programs I wrote using the installed jvm. Those from
$ORACLE_HOME/bin appear to use the JVM that was installed with 9i. The
dbca and downstream scripts appear to re-create the Java environment for
you.

Caver

-Original Message-
Sent: Wednesday, May 22, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L


Check and see if the jre runtime libraries are in your path for the session.
Otherwise, it will not dynamically find them.

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, May 22, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject:9iR2 Install Problem

Hello!

I am having a little difficulty with the 9iR2 install on a SUN Sparc
(Solaris 8) box. The installer completes normally, but when I try to run
anything java (e.g. dbca) I get the following message
Could not locate Java runtime
It looks to me that Oracle's provided jre did not get installed properly

Any suggestions on what I can do to correct this error? 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Toepke, Kevin M
  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 FTPserver

2002-05-22 Thread Tim Gorman


Depends on what you want to download...

For downloading software, you have to go through http://otn.oracle.com...

For downloading patches found on http://metalink.oracle.com, you can login
via FTP to upgrades.oracle.com, using your MetaLink username/password to
login (useful for downloading directly to your server if it has Internet
access), or use the Patch Download facilities right there inside
MetaLink...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 10:03 AM


 Good morning everyone,

 Please tell me the address for the Oracle FTP server.

 Thanks,
 Ruth

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ruth Gramolini
   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: Tim Gorman
  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: patchset 8.1.7.3 or 8.1.7.4

2002-05-22 Thread Hately Mike


Ruth,
What platform? 
For Sun Solaris ( which is what you have if memory serves )
8173 is 2189751
8174 is 2376472

Regards,
Mike Hately

-Original Message-
Sent: 22 May 2002 18:06
To: Multiple recipients of list ORACLE-L


Dear List,

What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I
download them?   I looking on the FTP site and on Metalink but I couldn't
tell which was which.

Thanks,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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).


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  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).

dbms_stats issues on 8i

2002-05-22 Thread Jack Silvey


Hello fellow orabrains,

Although Oracle has made it clear that DBMS_STATS is
the future and that ANALYZE will be desupported, and
it seems to work well in 9i, here are some things that
I uncovered in my research of it during our initial
stats process implementation (we were on 8.1.6 during
this time):

1) GATHER_DATABASE_STATS gathers stats on SYS schema.

Also creates possible deadlock scenario that
terminates the process with DD stats half gathered,
and the workaround is to delete the SYS stats.

2) ANALYZE_SCHEMA does not work 

I found this to be true in our warehouse. Fixed in 9i.

3) ANALYZE_SCHEMA does not gather stats on all tables

Workaround is to analyze those tables manually (er,
um,.never mind)

5) DBMS_STATS does not gather all stats

Gathers only stats relevant to CBO, such as num_rows,
not those such as empty_blocks. Not really relevant,
necessarily.

6) PARALLEL clause does not work unless you specify
FOR ALL COLUMNS SIZE x

7) GATHER_STALE clause does not gather stale stats

Also found this to be true, which is why I wrote a
looping analyze procedure.

8) Would not analyze our partitioned fact table at the
top level, no matter what I tried. Waited 9 hours,
restarted, and waited another 6. Used parallel degree
24 and still no good. Gave it up and used analyze
which did each partition in ~3-5 minutes. 

9) Cannot use ANALYZE after dbms_stats.

DBMS_STATS sets GLOBAL_FLAG to Y, which prevents
ANALYZE from storing stats for that table. Workaround
is to delete stats with DBMS_STATS.DELETE_TABLE_STATS
and then use ANALYZE.

There are others, like the DESC index problem that I
did not research, just noted in passing.

/jack silvey


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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).

PARALLEL SERVER

2002-05-22 Thread Seema Singh


Hi
I have one application which is running on Oracle 8.1.6.But most of time CPU 
idea is very low due to capacity peak.I am looking for either Oracle 
Parallel server or Oracle9i.Oracle Parallel server would distribute the load 
but question is.
Is Oracle Parallel server is stable in rel 8.1.7 or rel 9i?
We are also thinking to upgrade Oracle9i,What Would be the group View on 
Oracle9i?
Is is ok to move forward Oracle9i for production database?
Any statistics how much %of peoples are using Oracle Parallel server and 
Oracle 9i right now?
Thanks
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: How to create Redo Log Members. Oracle8.1.7

2002-05-22 Thread Hately Mike


That should be fine. The name of the file is not important. I've seen log,
rdo, dbf, redo and many others.
The statement itself should be fine. Your log files seem to be the default
size ( 500k ). It  may be worth checking how often you're switching log
files as you might want to make them larger if the database will be updated
heavily. You can see from the FIRST_TIME column in V$LOG_HISTORY when your
log switches are happening.
Something round about the half hour mark is nice. 
Just a thought,


Regards,
Mike Hately

-Original Message-
Sent: 22 May 2002 18:15
To: Multiple recipients of list ORACLE-L


Hi,
I just wanted to create new online redo log members for existing groups.
Currently I have 3 online redo log groups.  Each one contains only one
member.  Here is information about the online redo log of a database
select group#, bytes, members from sys.v$log;
GROUP#  BYTESMEMBERS
-- -- --
 1 512000  1
 2 512000  1
 3 512000  1

select * from sys.v$logfile where group# = 1;

GROUP# STATUS  MEMBER
-- ---


- 1
/Disk01/app/oradata/ttdb/redo01.log
select * from sys.v$logfile where group# = 2;

GROUP# STATUS  MEMBER
-- ---


- 2
/Disk01/app/oradata/ttdb/redo02.log
select * from sys.v$logfile where group# = 3;

GROUP# STATUS  MEMBER
-- ---


- 3
/Disk01/app/oradata/ttdb/redo03.log


After reading the Database Administrator's Guide about how to create online
redo log members,  I am a little bit confused about the file extension for
online redo log files.  
To create new online redo log members for an existing group, use the 
alter database add logfile member '/oracle/dbs/log2b.rdo' to group 1;
(From Orcle8.1.6 Administrator's Guide).  
Based on my query information, member of group 1 is
/Disk01/app/oradata/ttdb/redo01.log.  
My question is why the extension of the member of my redo log file is .log,
which is different from the Oracle Administrator's Guide's above
example?Here is my SQL statement to create redo log member for each existing
group.
alter database add logfile member ' /Disk02/app/oradata/ttdb/redo01a.log  to
group 1;  /* I place this member of group 1 in different location.  
Just wondered whether this is a correct statement to create online redo log
member.  If not, please show me how to fix it.  Please help.
I want to add new online redo log member for existing groups because I want
to safeguard against a single point of online redo log failure.
Thanks in advance.
Trang


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  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 FTPserver

2002-05-22 Thread Ray Stell


On Wed, May 22, 2002 at 09:14:49AM -0800, Tim Gorman wrote:
 For downloading patches found on http://metalink.oracle.com, you can login
 via FTP to upgrades.oracle.com, 


 ftp upgrades.oracle.com
upgrades.oracle.com: unknown host or invalid literal address

===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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 FTPserver


Thanks!  I am downloading now...it is going to take awhile.  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 1:14 PM


 Depends on what you want to download...

 For downloading software, you have to go through http://otn.oracle.com...

 For downloading patches found on http://metalink.oracle.com, you can login
 via FTP to upgrades.oracle.com, using your MetaLink username/password to
 login (useful for downloading directly to your server if it has Internet
 access), or use the Patch Download facilities right there inside
 MetaLink...

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, May 22, 2002 10:03 AM


  Good morning everyone,
 
  Please tell me the address for the Oracle FTP server.
 
  Thanks,
  Ruth
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Ruth Gramolini
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: Tim Gorman
   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: Ruth Gramolini
  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 FTPserver