Reraising exceptions

[Szecsy Tamas]

Hi,
 
I am 
currently writing some pretty complex triggers. In some cases I would need catch 
all exceptions occuring in a procedure call, make some processing (set a package 
variable) and then reraise the exception. Can this be done?
 
Every 
hint will be highly appreciated.
 
Tamas 
Szecsy

RE: checkpoint message

[Mohan, Ross]

 Kevin, 

Thanksclarity is always preferable. 

As for the acronym inflationI guess when I wrote "block" instead of
"byte", I simply hadn't smoked enough DBA crack. (That's Data Block Address,
I think, but...where *did* i leave that mushroom tea...darnit...)

:)

Ross

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/21/2001 10:55 PM

Ross:

I believe that RBA is referred to Redo Byte Address (Checkpoint RBA).
The checkpoint RBA is stored in the control file. When recovery is
required,
the checkpoint RBA determines the location in the redo stream from which
to
start applying recovery.

kevin

-Original Message-
Sent: Tuesday, August 21, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L


smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.

More than that, and you'll have to smoke some DBA crack,
make some guru mushroom tea, hack the internals, write a
book, and then become highly enigmatic and largely helpful.

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


I get the same kind of message, anyone knows what it means?

Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message


Hi all

I think there is some wait in our checkpointing.please correct me.I
received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN:
0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA

_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mala 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
  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: Mohan, Ross
  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: Kevin Tsay
  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: Mohan, Ross
  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 

RE: User access within/outside of app

[Larry Hahn]

Jon,

This is one of the options we have talked about. This
will require the vendor to do a bit of progamming. But
since they havent provided any security to this point,
it is the least they can do. 

I'm just wondering if anyone has any ideas we can use
as a stop gap until the app is changed. 

Thanks again for your help, Jon.

Larry Hahn
DB Manager
Journal Sentinel, Inc.

--- Jon Walthour <[EMAIL PROTECTED]> wrote:
> Larry:
> 
> Upon rereading your post (this time with my eyes
> open!), I see your
> problem. Hmm. I worked with a developer who did
> something like this. I
> don't know all the details, but I seem to recall
> that he didn't put the
> password in the DSN for the ODBC connection, but
> rather encrypted it in
> an .ini file that the app decrypted and used to log
> into the database.
> That way, the users couldn't use the ODBC connection
> with that userid
> outside of the app. That may not be an option for
> you here, but that's
> about all I can think of as an alternative.
> 
> Jon Walthour
> -Original Message-
> Sent: Tuesday, August 21, 2001 3:36 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Jon,
> 
> Thanks for the response. But these users still need
> to
> do updates through the app. I only want to keep them
> from doing updates from outside the app.
> 
> Larry
> --- Jon Walthour <[EMAIL PROTECTED]> wrote:
> > Create another user with select privileges only on
> > the objects in the app's schema. Give that one to
> > them and then change the password on the original
> > app id so they won't be able to use that one
> > anymore.
> > 
> > Jon Walthour
> > > 
> > > From: Larry Hahn <[EMAIL PROTECTED]>
> > > Date: 2001/08/21 Tue AM 11:21:04 EDT
> > > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > > Subject: User access within/outside of app
> > > 
> > > List,
> > > 
> > > We have purchased a system where users login
> > through
> > > an ODBC connection using a generic Oracle
> userid.
> > This
> > > userid has full rights to do insert, update,
> > delete,
> > > select on any table in the schema. The app asks
> > for
> > > another username and password which checks the
> > > application security table, which limits what
> > areas of
> > > the apps they can access.
> > > 
> > > Although this may work fine for the app, the
> users
> > > also have the ability to use Access and other
> ODBC compliant 
> > > programs to look at the data. When doing
> > so,
> > > they use the same ODBC DSN and, what do you
> know,
> > they
> > > have capabilities beyond their wildest
> > imagination.
> > > 
> > > This is obviously not a situation I want to
> > implement.
> > > I am looking for a way to allow a user into the
> > app to
> > > do their normal work, but only allow read access
> > for
> > > anything outside the app.
> > > 
> > > Any suggestions or ideas would be more than
> > welcome.
> > > 
> > > Thanks,
> > > 
> > > Larry Hahn
> > > Journal Sentinel, Inc.
> > > 
> > >
> __
> > > Do You Yahoo!?
> > > Make international calls for as low as
> $.04/minute
> > with Yahoo! Messenger
> > > http://phonecard.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Larry Hahn
> > >   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: Jon Walthour
> >   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).
> 
> 
> =
> Larry Hahn
> DBA
> Journal Sentinel,Inc
> 
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com

Re: Performance analysis (enqueue and buffer busy waits)

[Babette Turner-Underwood]

What is "unil-bialism" ??

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 20, 2001 2:12 PM


> FYI, in a previous message I detailed some of the tuning efforts we have
> been working on in regards to getting a EDI sales order processing job to
> process 150,000 lines per hour.  Well the major point of contention was
> freelists.  We went from 250 lines per minute to over 1500 lines per
minute
> simply by increasing freelists on some tables and indexes.  We saw an
> unbelievable 20,000 commits per minute on a 12 CPU AIX box.  Looked like
we
> could actually achieve the client's goal until we turned on advanced
> pricing.  It added 60% more overhead and increased user calls 3 fold which
> pegged all 12 CPU's at 100%.  I have a detail trace file event 10046 level
8
> to look at and see if I can improve any.  Think I will give unil-bialism a
> try.
>
> Thanks,
> Ethan
> http://www.geocities.com/epost1
>
>
> >-Original Message-
> >From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, August 20, 2001 7:56 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Re: Performance analysis (enqueue and buffer busy waits)
> >
> >
> >
> >Small rollback segments can be recycled
> >without being written to disc.  This can
> >reduce the total write-load on the system
> >and enhance your general use of the
> >db_block_buffer.
> >
> >
> >Jonathan Lewis
> >
> >Host to The Co-Operative Oracle Users' FAQ
> >http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> >Author of:
> >Practical Oracle 8i: Building Efficient Databases
> >See http://www.jlcomp.demon.co.uk/book_rev.html
> >
> >For latest news of public appearances
> >See http://www.jlcomp.demon.co.uk
> >
> >Screen saver or Life saver: http://www.ud.com
> >Use spare CPU to assist in cancer research.
> >
[snipped]
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babette Turner-Underwood
  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 for Solaris (on Intel)

[Scott]

Clint, The last I heard was that Oracle is not going
release anymore software for X86 Solaris. 8.1.7 is the
terminal release.  I think that should sum up the
pro's and con's.

Scott

--- Clinton Naude <[EMAIL PROTECTED]> wrote:
> Hi all.
>  
> I sent out a mail recently about Oracle for Solaris
> on Intel, but never saw
> any replies.
>  
> Has anyone got any facts/info on this. 
> What are the pro's and cons?
>  
> Thanks.
>  
> Clint
> 


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Re: linux & Oracle -- best combination

[Scott]

I believe that Oracle has decided that when porting to
linux all products will be ported to SuSE and then
perform post release certifications on Redhat. I
believe stability and support of multiple Linux
distributions was a factor in this decision. I run
both Redhat and SuSE and I actually perfer SuSE. SuSE
has a lot of packages it distributes with there
product. The only thing is the SuSE wont create ISO
images for download and Redhat will.

Scott


--- Brian McGraw <[EMAIL PROTECTED]>
wrote:
> Correct me if I'm wrong, but wasn't Red Hat Oracle's
> preferred Linux
> distribution, right up until the time they announced
> the availability of the Red
> Hat Database (PostgreSQL)?
> 
> Brian
> 
> Christopher Spence wrote:
> 
> > I would be curious to see these tests going
> forward, seeing as RedHat
> > support is difficult to do with 9i and such.  And
> suse now being Oracle's
> > perfered linux.  I wonder if these results have
> changed.  I never really
> > played with Oracle on Linux, but if I ever had to,
> I would be curious.
> >
> > "Do not criticize someone until you walked a mile
> in their shoes, that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> >
> > Christopher R. Spence
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
> > -Original Message-
> > Sent: Tuesday, August 21, 2001 1:53 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Lisa and others,
> >
> >  About a year ago, I was working for a company
> as a Linux systems
> > engineer (Read as: Tech guy doing sales support). 
> Most of our customers
> > wanted Linux systems, and it was my responsibility
> to provide them the
> > correct combination of Linux and hardware to meet
> their needs.  I had an ISO
> > 9002 compliance to maintain as I provided testing
> and supporting data to our
> > clients.
> >
> > My first test was RedHat linux 6.1 with Oracle
> 8.1.5.  I don't have the
> > benchmarks any more, but it worked the best.
> >
> > SCO Unix was bought by Caldera Linux and is not
> yet being implemented to the
> > full capability (IMHO).
> >
> > Mandrake, SuSe, Storm were all tested as well, 
> And had less satisfactory
> > performance and reliability.
> >
> > Slackware 7 was the next best solution, followed
> by TurboLinux 6.
> >
> > All of these configurations were tested on the
> same machine, completely
> > formatted and the same installation performed on
> each test cycle.
> >
> > I hope this is helpful information.
> >
> > Daniel Curry
> > Systems Administrator
> > CGtime, Inc.
> > 625 Second Street
> > Suite 201
> > San Francisco, CA 94107
> > ph: 415-348-6516
> > fx: 415-348-6505
> > cell: 510-304-7889
> >
> > -Original Message-
> > Sent: Tuesday, August 21, 2001 9:36 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Lisa
> >
> > SuSe is the best so I have been told. I am about
> to install 8i on 7.1 and
> > another guy here is installing 9i on 7.2.
> >
> > Totally untested on my behalf as I haven't started
> yet but that is the best
> > I have been told.
> >
> > Probably of no use whatsoever !!!
> >
> > Lee
> > -Original Message-
> > Sent: 21 August 2001 16:51
> > To: Multiple recipients of list ORACLE-L
> > Sorry everyone, I know you were just discussing
> this recently.
> > What is the most stable combination of Oracle &
> Linux?  What would you
> > recommend?  I want to say the consensus was SCO
> Linux but I don't quite
> > remember.
> > Thank you
> > Lara Croft
> > Oracle Database Administrator
> > Fairfield Resorts, Inc
> >
> >
> > 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: Daniel Curry
> >   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
> 

RE: checkpoint message

[Scott]

8i implements lazy checkpointing. The dirty buffers
are flushed to disk but the datafile headers are
updated later and when all the datafile headers are
updated the checkpoint complete is written to the
alert log. So it is not uncommon to checkpoints taking
longer in 8i.

Scott


--- Kevin Tsay <[EMAIL PROTECTED]> wrote:
> Ross:
> 
> I believe that RBA is referred to Redo Byte Address
> (Checkpoint RBA).
> The checkpoint RBA is stored in the control file.
> When recovery is required,
> the checkpoint RBA determines the location in the
> redo stream from which to
> start applying recovery.
> 
> kevin
> 
> -Original Message-
> Sent: Tuesday, August 21, 2001 7:21 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> smacks of incremental checkpointing...new
> implemented
> in 8i i thinkthe RBA is a redo block address.
> 
> More than that, and you'll have to smoke some DBA
> crack,
> make some guru mushroom tea, hack the internals,
> write a
> book, and then become highly enigmatic and largely
> helpful.
> 
> -Original Message-
> Sent: Tuesday, August 21, 2001 10:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I get the same kind of message, anyone knows what it
> means?
> 
> Saludos,
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> 
> 
> -Mensaje original-
> De: mala singh [mailto:[EMAIL PROTECTED]]
> Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
> Para: Multiple recipients of list ORACLE-L
> Asunto: checkpoint message
> 
> 
> Hi all
> 
> I think there is some wait in our
> checkpointing.please correct me.I received
> 
> the following message in alert.log file
> 
> Beginning log switch checkpoint up to RBA
> [0x55.3.11], SCN: 0x.000505b1
> 
> Completed checkpoint up to RBA [0x55.3.11], SCN:
> 0x.000505b1
> 
> Please advice me for correction.
> Thanks in advance.
> 
> Mala
> DBA-USA
>
_
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> 
> Share information about yourself, create your own
> public profile at
> http://profiles.msn.com.
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: mala 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Veronica Levin
>   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: Mohan, Ross
>   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: Kevin Tsay
>   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!?

Re: Freelist Contention

[Scott]

Raja, You will only have freelist contention on
conventional insert operations only. Insert operations
from direct loads won't cause freelist contention
because of the way direct inserts are done. You can
check for freelist contention by checking
V$SESSION_WAIT and look for the Event 'Buffer Busy
Waits'. If you see you have these waits you will need
to look at the P1, P2 and P3 columns to determine what
block is causing the wait as well as the type of wait.

P1 - Absolute file #
P2 - Block #
P3 - ID

ID's

<8.1.6  >=8.1.6
   00  Block being read

  1003100  Want to new the block but is being read
(maybe for undo)

  1007200  Want to new the block but another
session is holding it (possibly changing the block)

  1010230 Trying to get a cr on the buffer but a
session modifying the buffer has not completed.

  1012 A modification is happening on SCUR or XCUR
(OPS or RAC) but has not completed

  1012231 dup of 1010

  1013130 block is being read another session and
no other suitable image was found so we wait until the
read is complete.

  1014110 We want the current block but someone
else is currently reading into the cache.

  1014120 duplicate

  1016210 The session wants the block in SCUR or
XCUR mode.

  1016220 Duplicate of 1014

If you join p1 and p2 to dba_segments columns
Header_file and Header_block and you get match on the
join chances are you have a freelist problem.

If p1 and p2 are datablocks then the block could be
waiting on reads. If the waits are for reads chances
are you are scanning unselective indexes. If the waits
are for modifications then you need to add more
inittrans or reduce the number of rows in the block.
Reducing the number of rows in the block can be
achieved by using pctfree/pctused or min records per
block(8i feature). Data block waits could also be
caused by multiple process inserting into an index at
the index value.

If it is undo header then add more rollback segments. 
If it is undo blocks then you might try to make the
rollback segment bigger.

BBW's are cause by a session waiting for another
session to complete a read or the buffer is in
incompatible mode. The blocker may be modifying the
block we want or may be waiting on another wait
operation (typically IO). The ID above should help
show which. If we are in a buffer busy wait state and
there is no other session which is causing this wait
then possible causes are spinning process with buffer
lock. Oracle will normally wait 1 second and if it has
to wait again for an exclusive buffer it will wait 3
seconds.

Scott





--- Viraj Luthra <[EMAIL PROTECTED]> wrote:
> Hello folks,
> 
> How do I come to know that there is a contention
> going on in the freelists? Is there any v$ table or
> this type of contention you derive from some other
> info. like a ripple effect from some parameter?
> 
> TIA.
> 
> raja
> 
> 
> Get 250 color business cards for FREE!
> http://businesscards.lycos.com/vp/fastpath/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Viraj Luthra
>   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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

RE: Q about Oracle Optimizer

[Mohammad Rafiq]

John,
Thanks for update. But in our case no export was involved in migration as it 
was not our option for migration because of Database size. We used 7.3.4.5 
datafiles and migrated...there were no statistics of our objects

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 21 Aug 2001 16:50:46 -0800

Hi all,

Although it is a little late in this thread, keep in mind that
'STATISTICS=ESTIMATE' kicks in by default for export. This could also have
affected the final outcome, i.e. CHOOSE with incorrect stats isn't exactly
the right combination for the best performance ;-)

IMHO, this gotcha has caught out a lot of DBAs - even experienced ones...

John Kanagaraj

 >-Original Message-
 >From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
 >Sent: Saturday, August 18, 2001 10:00 AM
 >To: Multiple recipients of list ORACLE-L
 >Subject: RE: Q about Oracle Optimizer
 >
 >
 >Anita,
 >You are 100% right for your explanation. I observed that
 >behaviour just last
 >week when we migrated our second production database  from 7.3.4.5 to
 >8.1.6.2 and my colleague forgot to define optimizer as rule in our new
 >init.ora file and resultantly optimizer became CHOOSE and from
 >very next day
 >users started complaining about slowness. When I investigated
 >and found
 >problem with that, I defined it as RULE and rebounced database
 >at day-end
 >and problem resolved.
 >
 >MOHAMMAD RAFIQ
 >
 >
 >
 >Reply-To: [EMAIL PROTECTED]
 >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 >Date: Sat, 18 Aug 2001 07:16:20 -0800
 >
 >Mohammad,
 >
 >For this particular case you're probably correct.
 >What I was attempting to explain, and not doing very
 >well, was that the absence of statistics does NOT mean
 >the RBO will ALWAYS be used.  Many people don't
 >realize this and assume that because they have
 >OPTIMIZER_MODE = RULE that they will always use the
 >RBO.  Even if OPTIMIZER_MODE = RULE, the CBO will be
 >used on queries involving partitioned tables, for
 >example.
 >
 >It doesn't help that tkprof shows the optimizer_mode
 >for the session, not the optimizer that was actually
 >used.  So it's quite common to have the output show
 >RULE, while the explain plan itself shows a calculated
 >cost, hash joins, parallel query paths, and/or other
 >features that are used only by the CBO.
 >
 >HTH,
 >
 >-- Anita
 >
 >--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
 > > IMHO,Problem in this situation is that ,in 7.3.4 ,if
 > > I am not wrong ,thier
 > > optimizer must be RULE as default and after
 > > migration if optimizer is not
 > > explicitly set as RULE , default optimizer in 8.1.6
 > > is CHOOSE. This is the
 > > reason their objects never analyzed in 7.3.4 or now
 > > in 8.1.6.
 > > If optimizer is set explicitly as RULE in
 > > initSID.ora will automatically
 > > resolve their problem...
 > > Besides just going to CHOOSE and analyzing objects
 > > will not resolve all
 > > performance issues as it depends on application
 > > code, which was
 > > tuned/written keeping in mind RULE based optimizer
 > > and such codes must be
 > > checked and modified to get the best result under
 > > CHOOSE
 > >
 > >
 > > MOHAMMAD RAFIQ
 > >
 > >
 > >
 > > Reply-To: [EMAIL PROTECTED]
 > > To: Multiple recipients of list ORACLE-L
 > > <[EMAIL PROTECTED]>
 > > Date: Sat, 18 Aug 2001 05:45:19 -0800
 > >
 > > That's true provided you're not using any of the new
 > > features introduced in 8.0, and later versions, that
 > > automatically cause the CBO to be used (e.g.
 > > partitioning, degree or instances > 1, IOT, etc...)
 > >
 > > When in doubt, I always check metalink note:
 > > 66484.1.
 > >
 > > HTH,
 > >
 > > -- Anita
 > >
 > > --- Jon Walthour <[EMAIL PROTECTED]> wrote:
 > >  > Volker:
 > >  >
 > >  > If optimizer_mode = 'choose', then the optimizer
 > >  > chooses between
 > >  > cost-based optimization and rule-based
 > > optimization
 > >  > based on whether or
 > >  > not statistics are present. In your case, since
 > > they
 > >  > aren't it's using
 > >  > rule-based.
 > >  >
 > >  > -Original Message-
 > >  > Volker
 > >  > Sent: Thursday, August 16, 2001 4:46 AM
 > >  > To: Multiple recipients of list ORACLE-L
 > >  >
 > >  >
 > >  > Hi list,
 > >  >
 > >  > a quick question about oracle optimizer.
 > >  >
 > >  > a customer has database migrated from 7.3.4 to
 > > 8.1.6
 > >  > on AIX. Data was
 > >  > transfered via full exp/imp. After migration the
 > >  > performance of the new
 > >  > database is very poor. I looked at the parameters
 > >  > and saw that no object
 > >  > is analyzed. So now me question:
 > >  >
 > >  > What does oracle optimizer do, if there are no
 > >  > statistics on all
 > >  > objects. Optimizer level is choose.
 > >  >
 > >  > Volker Schön
 > >  > E-Mail: mailto:[EMAIL PROTECTED]
 > >  > http://www.inplan.de
 >
 >
 >__
 >Do You Yahoo!?
 >Make international call

RE: checkpoint message

[Kevin Tsay]

Ross:

I believe that RBA is referred to Redo Byte Address (Checkpoint RBA).
The checkpoint RBA is stored in the control file. When recovery is required,
the checkpoint RBA determines the location in the redo stream from which to
start applying recovery.

kevin

-Original Message-
Sent: Tuesday, August 21, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L


smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.

More than that, and you'll have to smoke some DBA crack,
make some guru mushroom tea, hack the internals, write a
book, and then become highly enigmatic and largely helpful.

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


I get the same kind of message, anyone knows what it means?

Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message


Hi all

I think there is some wait in our checkpointing.please correct me.I received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mala 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
  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: Mohan, Ross
  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: Kevin Tsay
  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: User access within/outside of app

[Jon Walthour]

Larry:

Upon rereading your post (this time with my eyes open!), I see your
problem. Hmm. I worked with a developer who did something like this. I
don't know all the details, but I seem to recall that he didn't put the
password in the DSN for the ODBC connection, but rather encrypted it in
an .ini file that the app decrypted and used to log into the database.
That way, the users couldn't use the ODBC connection with that userid
outside of the app. That may not be an option for you here, but that's
about all I can think of as an alternative.

Jon Walthour
-Original Message-
Sent: Tuesday, August 21, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Jon,

Thanks for the response. But these users still need to
do updates through the app. I only want to keep them
from doing updates from outside the app.

Larry
--- Jon Walthour <[EMAIL PROTECTED]> wrote:
> Create another user with select privileges only on
> the objects in the app's schema. Give that one to
> them and then change the password on the original
> app id so they won't be able to use that one
> anymore.
> 
> Jon Walthour
> > 
> > From: Larry Hahn <[EMAIL PROTECTED]>
> > Date: 2001/08/21 Tue AM 11:21:04 EDT
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > Subject: User access within/outside of app
> > 
> > List,
> > 
> > We have purchased a system where users login
> through
> > an ODBC connection using a generic Oracle userid.
> This
> > userid has full rights to do insert, update,
> delete,
> > select on any table in the schema. The app asks
> for
> > another username and password which checks the
> > application security table, which limits what
> areas of
> > the apps they can access.
> > 
> > Although this may work fine for the app, the users
> > also have the ability to use Access and other ODBC compliant 
> > programs to look at the data. When doing
> so,
> > they use the same ODBC DSN and, what do you know,
> they
> > have capabilities beyond their wildest
> imagination.
> > 
> > This is obviously not a situation I want to
> implement.
> > I am looking for a way to allow a user into the
> app to
> > do their normal work, but only allow read access
> for
> > anything outside the app.
> > 
> > Any suggestions or ideas would be more than
> welcome.
> > 
> > Thanks,
> > 
> > Larry Hahn
> > Journal Sentinel, Inc.
> > 
> > __
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Larry Hahn
> >   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: Jon Walthour
>   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).


=
Larry Hahn
DBA
Journal Sentinel,Inc

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Hahn
  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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

Re: checkpoint message

[Joe Testa]

Or just be like me and spend most of the time saying "rtfm" :)

joe
"Mohan, Ross" wrote:
> 
> smacks of incremental checkpointing...new implemented
> in 8i i thinkthe RBA is a redo block address.
> 
> More than that, and you'll have to smoke some DBA crack,
> make some guru mushroom tea, hack the internals, write a
> book, and then become highly enigmatic and largely helpful.
> 
> -Original Message-
> Sent: Tuesday, August 21, 2001 10:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> I get the same kind of message, anyone knows what it means?
> 
> Saludos,
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> 
> -Mensaje original-
> De: mala singh [mailto:[EMAIL PROTECTED]]
> Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
> Para: Multiple recipients of list ORACLE-L
> Asunto: checkpoint message
> 
> Hi all
> 
> I think there is some wait in our checkpointing.please correct me.I received
> 
> the following message in alert.log file
> 
> Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1
> 
> Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1
> 
> Please advice me for correction.
> Thanks in advance.
> 
> Mala
> DBA-USA
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mala 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --


-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: AS400 RPG Access to Oracle on Sun/Sparc

[Kevin Tsay]

Try Oracle Gateway.

kevin

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L


I've got a requirement to do DML from an RPG program running in an AS400
against a database on a Sun box
running Oracle.

Has anyone done this?

Any pointers?

-- 
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: Kevin Tsay
  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: checkpoint message

[Mohan, Ross]

smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.

More than that, and you'll have to smoke some DBA crack, 
make some guru mushroom tea, hack the internals, write a 
book, and then become highly enigmatic and largely helpful. 

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


I get the same kind of message, anyone knows what it means?

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message 


Hi all

I think there is some wait in our checkpointing.please correct me.I received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mala 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  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: Mohan, Ross
  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 help me to become DBA

[Ha Duy Thien]

Hi Gurus 
 
Thanks you so much for reading my 
problem.
 
I am a new oracle user and I really interested in 
exploring this product.
 
In fact I want to know it clearly and can control 
it in the future. 
Someone has said to me that it's better 
to become a DBA but it seems very difficult for me
 
If you don't mind, please show me which steps I 
should take first and which books or which websites I can read.
 
In this forum I find many thing interesting. You 
are very experienced
 
Best regards,
 
ThienHD

RE: checkpoint message

[Veronica Levin]

I get the same kind of message, anyone knows what it means?

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message 


Hi all

I think there is some wait in our checkpointing.please correct me.I received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mala 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
  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: DBA tasks

[Ron Thomas]

And for those who are daring, attend the Fulsom Street Fair.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Either lead by example, or become a terrible warning"


   
  
Bruce.Page@Bel 
  
lSouth.comTo: [EMAIL PROTECTED] 
  
Sent by:  cc:  
  
[EMAIL PROTECTED]Subject: RE: DBA tasks   
  
om 
  
   
  
   
  
08/20/01 11:03 
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hey, Oracle IS a company based in San Francisco.

> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 1:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DBA tasks
>
>
> ahem... "get the girl"
>
> lol
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
  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 Thomas
  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: Q about Oracle Optimizer

[John Kanagaraj]

Hi all,

Although it is a little late in this thread, keep in mind that
'STATISTICS=ESTIMATE' kicks in by default for export. This could also have
affected the final outcome, i.e. CHOOSE with incorrect stats isn't exactly
the right combination for the best performance ;-)

IMHO, this gotcha has caught out a lot of DBAs - even experienced ones...

John Kanagaraj

>-Original Message-
>From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 18, 2001 10:00 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Q about Oracle Optimizer
>
>
>Anita,
>You are 100% right for your explanation. I observed that 
>behaviour just last 
>week when we migrated our second production database  from 7.3.4.5 to 
>8.1.6.2 and my colleague forgot to define optimizer as rule in our new 
>init.ora file and resultantly optimizer became CHOOSE and from 
>very next day 
>users started complaining about slowness. When I investigated 
>and found 
>problem with that, I defined it as RULE and rebounced database 
>at day-end 
>and problem resolved.
>
>MOHAMMAD RAFIQ
>
>
>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: Sat, 18 Aug 2001 07:16:20 -0800
>
>Mohammad,
>
>For this particular case you're probably correct.
>What I was attempting to explain, and not doing very
>well, was that the absence of statistics does NOT mean
>the RBO will ALWAYS be used.  Many people don't
>realize this and assume that because they have
>OPTIMIZER_MODE = RULE that they will always use the
>RBO.  Even if OPTIMIZER_MODE = RULE, the CBO will be
>used on queries involving partitioned tables, for
>example.
>
>It doesn't help that tkprof shows the optimizer_mode
>for the session, not the optimizer that was actually
>used.  So it's quite common to have the output show
>RULE, while the explain plan itself shows a calculated
>cost, hash joins, parallel query paths, and/or other
>features that are used only by the CBO.
>
>HTH,
>
>-- Anita
>
>--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> > IMHO,Problem in this situation is that ,in 7.3.4 ,if
> > I am not wrong ,thier
> > optimizer must be RULE as default and after
> > migration if optimizer is not
> > explicitly set as RULE , default optimizer in 8.1.6
> > is CHOOSE. This is the
> > reason their objects never analyzed in 7.3.4 or now
> > in 8.1.6.
> > If optimizer is set explicitly as RULE in
> > initSID.ora will automatically
> > resolve their problem...
> > Besides just going to CHOOSE and analyzing objects
> > will not resolve all
> > performance issues as it depends on application
> > code, which was
> > tuned/written keeping in mind RULE based optimizer
> > and such codes must be
> > checked and modified to get the best result under
> > CHOOSE
> >
> >
> > MOHAMMAD RAFIQ
> >
> >
> >
> > Reply-To: [EMAIL PROTECTED]
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > Date: Sat, 18 Aug 2001 05:45:19 -0800
> >
> > That's true provided you're not using any of the new
> > features introduced in 8.0, and later versions, that
> > automatically cause the CBO to be used (e.g.
> > partitioning, degree or instances > 1, IOT, etc...)
> >
> > When in doubt, I always check metalink note:
> > 66484.1.
> >
> > HTH,
> >
> > -- Anita
> >
> > --- Jon Walthour <[EMAIL PROTECTED]> wrote:
> >  > Volker:
> >  >
> >  > If optimizer_mode = 'choose', then the optimizer
> >  > chooses between
> >  > cost-based optimization and rule-based
> > optimization
> >  > based on whether or
> >  > not statistics are present. In your case, since
> > they
> >  > aren't it's using
> >  > rule-based.
> >  >
> >  > -Original Message-
> >  > Volker
> >  > Sent: Thursday, August 16, 2001 4:46 AM
> >  > To: Multiple recipients of list ORACLE-L
> >  >
> >  >
> >  > Hi list,
> >  >
> >  > a quick question about oracle optimizer.
> >  >
> >  > a customer has database migrated from 7.3.4 to
> > 8.1.6
> >  > on AIX. Data was
> >  > transfered via full exp/imp. After migration the
> >  > performance of the new
> >  > database is very poor. I looked at the parameters
> >  > and saw that no object
> >  > is analyzed. So now me question:
> >  >
> >  > What does oracle optimizer do, if there are no
> >  > statistics on all
> >  > objects. Optimizer level is choose.
> >  >
> >  > Volker Schön
> >  > E-Mail: mailto:[EMAIL PROTECTED]
> >  > http://www.inplan.de
>
>
>__
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo! 
>Messenger
>http://phonecard.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: A. Bardeen
>   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: Archived logs

[Jared . Still]

Did you perchance leave all your tablespaces in backup mode?

Jared




   
 
"Aldi Barco"   
 

com> cc:   
 
Sent by: Subject: Archived logs
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
08/21/01 03:00 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi,

My database generated so many archived log now, let say 20 archived log per

minute. The application and the number of rows in the database is not too
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived
log
files ?
More information : I'm also audit database mostly by session.
816 on Redhat Linux 6.2
Thanks for any clue.

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Aldi Barco
  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: Spool 32 Error

[Jared . Still]

Let's not turn this forum into a help-desk for all questions you don't
care to bother to research yourself.

Jared



   
 
Huy_Le@manulif 
 
e.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Spool 32 Error   
 
om 
 
   
 
   
 
08/21/01 06:30 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





We recently have Spool 32 Error message appear on almost all of computers
when user request printing. Could anyone share the experience why and how
to solve this problem. Thx.


Warmest regards,

Le Quang Huy
Manager -- Information Technology
Chinfon Manulife Insurance Company Limited
Diamond Plaza, 12fl, 34 Le Duan, District 1, Ho Chi Minh city, Vietnam
Phone: (848) 825 7722 Ext: 2999 --- Fax: (848) 825 7718 --- Mobile: (848)

==
This message is confidential and may also be privileged.  If you are not
the intended recipient, please notify me by return e-mail and delete this
message from your system.  If you are not the intended recipient, any use
by you of this message is strictly prohibited.

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

AS400 RPG Access to Oracle on Sun/Sparc

[tpall]

I've got a requirement to do DML from an RPG program running in an AS400
against a database on a Sun box
running Oracle.

Has anyone done this?

Any pointers?

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

Connect as a different user in PL/SQL

[Bartolo, David]

Hi all,

Is there a way to connect or see if a username and password are valid in a
PL/SQL procedure?
I will come in as one user.  Pass in the username and password I want to
validate.  Try to connect to the 
database with that username and password.

Thanks,
David 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bartolo, David
  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: Archived logs

[Mohammad Rafiq]

Check for code doing insert,delete,update etc in v$sqlarea..
you may run following script to check for active sessions resulting lot of 
DML's

select
substr(username,1,10)"USER",process,sid,substr(sql_text,1,200),disk_reads,buffer_gets,rows_processed
from v$session,v$sqlarea
where sql_address=address and status = 'ACTIVE'
order by disk_reads desc
/

OR run

SELECT   a.username AS username
   , a.sid AS sid
   , a.serial# AS ser#
   , b.sql_text AS statement
FROM v$session a
   , v$sqltext b
   WHERE a.username IS NOT NULL
 AND a.status = 'ACTIVE'
 AND a.sql_address = b.address
 AND a.sql_hash_value = b.hash_value
 AND a.audsid != USERENV('sessionid')
ORDER BY sid
   , ser#
   , b.piece
/

Regards



MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 21 Aug 2001 13:53:06 -0800

Hi,

My database generated so many archived log now, let say 20 archived log per
minute. The application and the number of rows in the database is not too
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log
files ?
816 on Redhat Linux 6.2
Thanks for any clue.

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Archived logs

[Aldi Barco]

Hi,

My database generated so many archived log now, let say 20 archived log per 
minute. The application and the number of rows in the database is not too 
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log 
files ?
More information : I'm also audit database mostly by session.
816 on Redhat Linux 6.2
Thanks for any clue.

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Archived logs

[Aldi Barco]

Hi,

My database generated so many archived log now, let say 20 archived log per 
minute. The application and the number of rows in the database is not too 
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log 
files ?
816 on Redhat Linux 6.2
Thanks for any clue.

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

RMAN Copies

[Stephen Andert]

Hello, 
 
We are in the process of learning and implementing RMAN.  
We are also in the process of implementing BCP (Business Continuity 
Planning).  We have a BCP machine with enough disk space to do a restore of 
our "production-critical" databases.  I need to be able to make a copy of 
the RMAN backup from one location, make a copy and overnight the tapes to our 
BCP location.  The problem I have is that we are multi-plexing the backups 
of several databases and I need to make a copy on to one set of tapes of just 1 
database.  
 
PLEASE tell me there is an easy way to do this!!!  I 
looked in the Oracle8i Recovery Manager User's Guide 
and Reference and found duplexing, but that will require more tape drives than 
we currently have available as well as some additional configuration of 
NetBackup that our Tape Operators are hesitant to undertake.
 
Thanks for any pointers, tips, 
suggestions, etc.
 
Stephen Andert
 
 

Re: How do they get the answer?

[Scott Shafer]

Each subject has 2 teachers.  By limiting the update by 2 subject_id's,
you guarantee that 4 teachers will get a raise.  Actually, this is poor
SQL if a teacher teaches more than one subject (but that's not part of
the problem).

Scott Shafer
San Antonio, TX


[EMAIL PROTECTED] wrote:
> 
> I am taking the Self-Test software test for the SQL exam
> and don't see how they get the answer to this problem.
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
> NameNull?   Type
> ID  NOT NULLNUMBER(9)
> SALARY  NUMBER
> (7,2)
> SUBJECT_ID  NOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION VARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
> v_pct_raise number := 1.10;
> BEGIN
> UPDATE  teacher
> SET salary = salary * 1.10
> WHERE   subject_id IN (102, 105);
> COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary
> increase.
> (C) At least four teachers will receive a 10% salary
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C)

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

w2k db connections... <>

[Koivu, Lisa]

Title: w2k db connections...   <>





OK.  This question is posed to those who maintain applications & Oracle on Windows 2000 servers. 


What's the maximum number of connections you can feasibly support?  


Has anyone implemented a windows 2000 cluster and had it reliably work? 


I feel sick.  


Thanks


Lisa Koivu
Glorified Monkey and Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

Re: linux & Oracle -- best combination

[Brian McGraw]

Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
distribution, right up until the time they announced the availability of the Red
Hat Database (PostgreSQL)?

Brian

Christopher Spence wrote:

> I would be curious to see these tests going forward, seeing as RedHat
> support is difficult to do with 9i and such.  And suse now being Oracle's
> perfered linux.  I wonder if these results have changed.  I never really
> played with Oracle on Linux, but if I ever had to, I would be curious.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
> -Original Message-
> Sent: Tuesday, August 21, 2001 1:53 PM
> To: Multiple recipients of list ORACLE-L
>
> Lisa and others,
>
>  About a year ago, I was working for a company as a Linux systems
> engineer (Read as: Tech guy doing sales support).  Most of our customers
> wanted Linux systems, and it was my responsibility to provide them the
> correct combination of Linux and hardware to meet their needs.  I had an ISO
> 9002 compliance to maintain as I provided testing and supporting data to our
> clients.
>
> My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
> benchmarks any more, but it worked the best.
>
> SCO Unix was bought by Caldera Linux and is not yet being implemented to the
> full capability (IMHO).
>
> Mandrake, SuSe, Storm were all tested as well,  And had less satisfactory
> performance and reliability.
>
> Slackware 7 was the next best solution, followed by TurboLinux 6.
>
> All of these configurations were tested on the same machine, completely
> formatted and the same installation performed on each test cycle.
>
> I hope this is helpful information.
>
> Daniel Curry
> Systems Administrator
> CGtime, Inc.
> 625 Second Street
> Suite 201
> San Francisco, CA 94107
> ph: 415-348-6516
> fx: 415-348-6505
> cell: 510-304-7889
>
> -Original Message-
> Sent: Tuesday, August 21, 2001 9:36 AM
> To: Multiple recipients of list ORACLE-L
>
> Lisa
>
> SuSe is the best so I have been told. I am about to install 8i on 7.1 and
> another guy here is installing 9i on 7.2.
>
> Totally untested on my behalf as I haven't started yet but that is the best
> I have been told.
>
> Probably of no use whatsoever !!!
>
> Lee
> -Original Message-
> Sent: 21 August 2001 16:51
> To: Multiple recipients of list ORACLE-L
> Sorry everyone, I know you were just discussing this recently.
> What is the most stable combination of Oracle & Linux?  What would you
> recommend?  I want to say the consensus was SCO Linux but I don't quite
> remember.
> Thank you
> Lara Croft
> Oracle Database Administrator
> Fairfield Resorts, Inc
>
>
> 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: Daniel Curry
>   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: Christopher Spence
>   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).

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://b

Re: Freelist Contention

[Jared . Still]

Yeah, like I said, I wasn't thinking too hard about it.  :)

Jared




   
  
"Jonathan Lewis"   
  
<[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
mon.co.uk>cc:  
  
Sent by:  Subject: Re: Freelist Contention 
  
[EMAIL PROTECTED]   
  
   
  
   
  
08/21/01 11:46 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  





Not only that, PX slaves do direct reads
 anyway, bypassing the buffer cache.

It is possible, though, that the flush
that has to take place before the PX
scan can read back is sufficient to
cause other processes to wait for
write complete waits, and I guess that
you could also get extra rbs header
waits as the flushed and scanned blocks
are rolled back by the PX slaves for
read consistency.


Excessive serial tablescans, on the other
hand can easily cause significant buffer
busy waits.

Jonathan Lewis

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

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 21 August 2001 18:32


|On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
|> Bufer busy waits can also be caused by parallel query
|> servers trying to read the same buffer block at the
|> same time.
|
|Just off the top of my head, and without giving it a lot
|of thought, this doesn't sound right.
|
|PQS divvy up the blocks to read, and should not be trying
|to access the same block.
|
|Got any documentation or evidence to back that up?
|
|Jared


--
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: 
  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: Apologies... linux & Oracle

[Jared . Still]

Not  true.

Oracle 8.1.7 is supported on SuSE 7.1

It requires a patch, available through otn.oracle.com and suse.com.

Works fine for me.

Jared




   
 
"Ron Rogers"   
 

tery.org>cc:   
 
Sent by: Subject: Re: Apologies... linux & Oracle  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
08/21/01 10:31 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Lora, lisa, what ever...
Oracle only supports SUSE 7.1 for Oracle 9i.
 I use RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.
Works great but not supported. SCO was bought out by RedHat a while back I
believe.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 11:50AM >>>
Sorry everyone, I know you were just discussing this recently.

What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.

Thank you

Lara Croft
Oracle Database Administrator
Fairfield Resorts, Inc




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




--
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: MOVE Tables from One Tablespace to Another Tablespace !!

[Hillman, Alex]

Need to add accounting for LOB indexes or simply not to add whenever SQL
error ...
alter index .. rebuild does not work for LOB indexes.

Alex Hillman

-Original Message-
Sent: Tuesday, August 21, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L


I just did this yesterday.  Here are the scripts I used;

sqlplus system/syspaswd

set pagesize 0
set feedback off
spool mv_tbls.sql
select 'alter table '|| owner || '.' || segment_name || ' move tablespace
new_tblspc;'
from dba_segments
where segment_type='TABLE'
and tablespace_name='old_tblspc';
spool off;
spool alter_idxs.sql
select 'alter index ' || i.table_owner || '.' || i.index_name || ' rebuild;'
from dba_indexes i, dba_segments s
where s.segment_name=i.table_name
and s.owner=i.table_owner
and s.segment_type='TABLE'
and s.tablespace_name='old_tblspc';
spool off;

this is from memory, so check the spooled scripts before running...

-Original Message-
INF/MEKKAOUI
Sent: Tuesday, August 21, 2001 5:41 AM
To: Multiple recipients of list ORACLE-L


hi,
the command is :

Alter table table_name move tablespace tablespace_name;

But be careful from index corruption.

Best Regards,
Nabila Mekkaoui
DBA Oracle


-Message d'origine-
De : Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 21 août 2001 08:16
À : Multiple recipients of list ORACLE-L
Objet : MOVE Tables from One Tablespace to Another Tablespace !!



Hello All,


Please tell me the detailed steps to move tables from one tablespace to
another tablespace.

Regards,
Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj  (CAP,CEF)
  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: INF/MEKKAOUI
  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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
  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: Standby Database Error

[arunc]

Nope u do not have to copy the online redologfiles to the standby, this has
to be done only in the case of switch over from production to the standby
database.
The online redos are only read when the database is getting opened it will
not be read during recovery until and unless u specify the online redo log
file during recovery or u specify recover database command at this moment if
it has applied all the archive logs it will check the online redologs and
recover complete from it.



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 12:22 PM


> I was able to configure the standby database.I am not clear about the redo
> log files.Oracle
> Standby database creation dod doesn't talk of moving the redo log files.Do
> we have to move
> the redo log files from the primary database to the standby database.But
the
> standby database
> iw working fine and i open it in READ only mode to check if the data is in
> sync with the primary database
> and i found it to be good.
>
> When I give selct member from v$logfile; it lists the redo logs but
actually
> no files
> exist in that directory.
>
> Should we move the redo logs also to the standby database from the primary
> database.
>
> Thanks
> Ravindra
>
> -Original Message-
> Basavaraja
> Sent: Friday, August 10, 2001 6:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I am getting the following error when applying the archive files from the
> production database
> to the standby database.I just configured the standby database and was
> applying the archive
> files from production.
>
> This error appeared after processing many archive files
>
> ORA-00308: cannot open archived log
> '/u03/ora/app/admin/sentica/arch/Prod_arch_1_9823.arc'
> ORA-27046: file size is not a multiple of logical block size
> Additional information: 1
>
> What could be the problem.?
>
> Thanks
> Ravindra
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ravindra Basavaraja
>   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: Ravindra Basavaraja
>   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: arunc
  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: Freelist Contention

[arunc]

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 9:48 AM


> On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
> > Bufer busy waits can also be caused by parallel query
> > servers trying to read the same buffer block at the
> > same time.
> 
> Just off the top of my head, and without giving it a lot
> of thought, this doesn't sound right.
> 
> PQS divvy up the blocks to read, and should not be trying
> to access the same block.
> 
> Got any documentation or evidence to back that up?
> 
> Jared
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   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: arunc
  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).

CF and Oracle

[Belinda Taylor]

Currently upgrading from Coldfusion 4.0 to 4.5 and now all the CF forms
are having problems displaying time portion of date fields. Regardless
of the value of the time, CF always displays 12:00 AM. Anyone else
encounter this problem when converting/using CF?


begin:vcard 
n:Taylor;Belinda
tel;fax:(703)993-3403
tel;work:(703)993-3346
x-mozilla-html:FALSE
url:http://www.gmu.edu
org:George Mason University;UCIS
version:2.1
email;internet:[EMAIL PROTECTED]
title:Applications Analyst/DBA
adr;quoted-printable:;;4400 University Drive=0D=0AMSN 1B5;Fairfax;VA;22030;USA
fn:Belinda K Taylor
end:vcard

RE: Apologies... linux & Oracle

[Jared . Still]

I've found SuSE easier to work with than RH.

Jared




   
 
Robertson Lee  
 
- lerobe To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
  Subject: RE: Apologies... linux & Oracle  
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
08/21/01 09:35 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Lisa

SuSe is the best so I have been told. I am about to install 8i on 7.1 and
another guy here is installing 9i on 7.2.

Totally untested on my behalf as I haven't started yet but that is the best
I have been told.

Probably of no use whatsoever !!!

Lee

-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L



Sorry everyone, I know you were just discussing this recently.

What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.

Thank you

Lara Croft
Oracle Database Administrator
Fairfield Resorts, Inc





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

SuSe is the best so I have been told. I am about to install 8i on 7.1 and
another guy here is installing 9i on 7.2.

Totally untested on my behalf as I haven't started yet but that is the best
I have been told.

Probably of no use whatsoever !!!

Lee


 -Original Message-
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
 Sent: 21 August 2001 16:51
 To: Multiple recipients of list ORACLE-L
 Subject: Apologies... linux & Oracle



 Sorry everyone, I know you were just discussing this recently.


 What is the most stable combination of Oracle & Linux?  What would you
 recommend?  I want to say the consensus was SCO Linux but I don't
 quite remember.


 Thank you


 Lara Croft
 Oracle Database Administrator
 Fairfield Resorts, Inc






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

oracle 8i and mts problem

[daniel szabo]

Hello there, Oracle users!I am new here, as new to the Oracle 
technology. We are developping a =software which must be transaction 
compliant, and we're on microsoft =platform, and thatswy we're using sql2000 
and microsoft transaction =server for our application server 
components.=20But one of our clients wants to use oracle 8i db as the 
resource =manager. We had to make the proper work mts with oracle. I red all 
of =the oracle documentation within this topic, and i successfully installed 
=the Oracle Services for MTS on our development machine at the workplace. 
=(created the mts_proxy_info table, granted the specific roles to a 
=specific db user, the specific privileges, the xa views, and so on), and 
=it is working nicely, the log says "accepting new enlistment request", 
=everything is wonderful.But at the client, i repeated all of the 
steps (the only difference is, =that they have the server on a HP-UX machine 
instead of winnt), and when =i wanted to start the oracle services for MTS 
on the Application server, =the log says this: "incorrect password, or 
username". I really don't =undestand it, because i can connect through the 
OLEDB driver with the =specified username, password and Service 
name.=20If anybody had an idea i would be very happythanks in 
advance,daniel szabo

Help - Fail Safe ODBC not working

[Shaw, John B]

I've got a new install on a HP cluster (windows NT service pack 6) oracle
8.1.7 and failsafe 3.1.2, oracle odbc 8.1.7.4.
Everything seems to work - database and cluster all failover. I can
reconnect to the node after failover, but the odbc driver (with the enable
retry option checked) doesn't keep the connection alive during the failover
- I get 3113 end-of-file error - both from access and a foxpro front end, I
have to stop and restart the app's and then everything connects up fine. 
Any ideas?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw, John B
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB2 Question

[Therrien, Francois]

If you're talking DB2 on OS/390, the default is EBCDIC but as of DB2 V5, the
default could be changed to ASCII on a table per table basis.
FT

-Original Message-
Sent: August 21, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L


Does DB2 store data as EBCDIC or ASCII?

Thanks,
Ken Janusz, CPIM
-- 
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: Therrien, Francois
  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 do they get the answer?

[DBarbour]

Yes, if 102 and 105 are valid subject_id codes.  The correct answer is "Not
enough data has been supplied to properly evaluate the results."

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

"Deshpande, Kirti" 

  
rizon.com>cc:  

Sent by:  Subject: RE: How do they get the 
answer? 
[EMAIL PROTECTED]   

   

   

08/21/2001 12:03 PM

Please respond to  

ORACLE-L   

   

   





   >> Each subject is taught by at least 2 teachers.
So, if 102 and 105 are the 2 subject-ids, then a total of at least 4
teachers will get selected for salary update.
Correct ?

Regards,

- Kirti Deshpande
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 11:26 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:   How do they get the answer?
>
> I am taking the Self-Test software test for the SQL exam
> and don't see how they get the answer to this problem.
> They don't explain how it is arrived at.
>
> Any help you can give me will be appreciated.
>
> Thanks,
> Ken Janusz, CPIM
>
> --
>
> Examine the structure of the TEACHER table:
>
> Name Null?
Type
> ID  NOT NULLNUMBER(9)
> SALARY   NUMBER
> (7,2)
> SUBJECT_ID  NOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION   VARCHAR2(2)
>
> There are 200 teachers and 15 subjects.  Each subject is
> taught
> by at least 2 teachers.
>
> Evaluate this PL/SQL block:
>
> DECLARE
>  v_pct_raisenumber := 1.10;
> BEGIN
>  UPDATE   teacher
>  SET salary = salary * 1.10
>  WHEREsubject_id IN (102, 105);
>  COMMIT;
> END;
>
> Which result will the PL/SQL block provide?
>
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary
> increase.
> (C) At least four teachers will receive a 10% salary
> increase.
> (D) A syntax error will occur.
>
> Answer:
> (C)
>
>
> --
> 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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

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

Re: How do they get the answer?

[Regina Harter]

The structure of the table indicates to me that they began with the
assumption that each teacher would only be teaching one subject. 

At 10:52 AM 8/21/01 -0800, you wrote:
i still stand by(reading into the question)
that it could be only 2 teachers get a raise, if the same 2 teachers
teach both of those courses.  would they get twice as much of a
raise? :)
 
joe


>>> [EMAIL PROTECTED] 08/21/01 12:52PM >>>
in the where clause, the IN says "any teachers that are in any of
these subjects. Since there are two subjects in the IN set and at least 2
teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4
teachers will get a raise.

Jon Walthour
> 
> From: [EMAIL PROTECTED]
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> Subject: How do they get the answer?
> 
> I am taking the Self-Test software test for the SQL exam 
> and don't see how they get the answer to this problem.  
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
>
Name   
Null?    Type
>
ID   
NOT NULL    NUMBER(9)
>
SALARY   
NUMBER
> (7,2)
>
SUBJECT_ID   
NOT NULL    NUMBER(3)
>
SUBJECT_DESCRIPTION   
VARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
>
v_pct_raise    number :=
1.10;
> BEGIN
>
UPDATE    teacher
>
SET    salary = salary * 
1.10
>
WHERE    subject_id IN (102,
105);
> COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
> 
> 
> -- 
> 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: Jon Walthour
  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 do they get the answer?

[JOE TESTA]

well we know the answer is C, but its the most correct out of the 4, not 
necessarily the ultimate correct answer.
 
joe
>>> [EMAIL PROTECTED] 08/21/01 03:25PM 
>>>It's possible, but not the only possibility.  Therefore you 
can't answer A. 
And if you're not certain, you can't answer the question.  Because this 
is the Oracle OCP exam.  The thing that you've studied night and day 
for.  Everything you learned in the two-night class preparing you for 
database administration and nuclear physics.  This is crunch time, baby - 
right or wrong?  You make the call.  Pressure's on.  Which will 
it be?  What if this is the question that will put me under that 
passing grade.  A or C?  A or C?  Which will it be?  What 
will I do?  You want the truth?  You want the truth?  You 
can't handle the truth! 
I'm heading back to the espresso machine now... 
Brian 
JOE TESTA wrote: 
 i still stand by(reading into the question) that 
  it could be only 2 teachers get a raise, if the same 2 teachers teach both of 
  those courses.  would they get twice as much of a raise? 
  :) joe  
  >>> [EMAIL PROTECTED] 08/21/01 12:52PM >>> in the where 
  clause, the IN says "any teachers that are in any of these subjects. Since 
  there are two subjects in the IN set and at least 2 teachers have to teach 
  each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise. 
  Jon Walthour > > From: [EMAIL PROTECTED] > Date: 
  2001/08/21 Tue PM 12:25:54 EDT > To: Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]> > Subject: How do they get the 
  answer? > > I am taking the Self-Test software test for the SQL 
  exam > and don't see how they get the answer to this problem. > 
  They don't explain how it is arrived at. > > Any help you can 
  give me will be appreciated. > > Thanks, > Ken Janusz, 
  CPIM > > -- > > 
  Examine the structure of the TEACHER table: > > 
  Name    
  Null?    Type > 
  ID    
  NOT NULL    NUMBER(9) > 
  SALARY    
  NUMBER > (7,2) > 
  SUBJECT_ID    
  NOT NULL    NUMBER(3) > 
  SUBJECT_DESCRIPTION    
  VARCHAR2(2) > > There are 200 teachers and 15 subjects.  
  Each subject is > taught > by at least 2 teachers. > 
  > Evaluate this PL/SQL block: > > DECLARE 
  > 
  v_pct_raise    number := 1.10; > 
  BEGIN > 
  UPDATE    teacher 
  > SET    
  salary = salary * 1.10 > 
  WHERE    subject_id IN (102, 105); 
  > COMMIT; > END; > > Which 
  result will the PL/SQL block provide? > > (A) Only two teachers 
  will receive a 10% salary increase. > (B) All of the teachers will 
  receive a 10% salary > increase. > (C) At least four teachers 
  will receive a 10% salary > increase. > (D) A syntax error will 
  occur. > > Answer: > (C) > > > -- 
  > 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: Jon 
  Walthour   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).
-- -- | Brian 
McGraw -- Oracle DBA | | 
Central Alabama Oracle Users Group | || 
| mailto:[EMAIL PROTECTED]  
| | http://bmcgraw.home.mindspring.com 
| --   

RE: How do they get the answer?

[Shreter, Hilary]

They can't give any raises this year.  
They have to hire a data modeler using those monies.  There were at least 
four raises that could be used for this purpose.

  -Original Message-From: Brian McGraw 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 
  21, 2001 3:26 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: How do they get the 
  answer?It's possible, but not the only possibility.  
  Therefore you can't answer A. 
  And if you're not certain, you can't answer the question.  Because 
  this is the Oracle OCP exam.  The thing that you've studied night 
  and day for.  Everything you learned in the two-night class preparing you 
  for database administration and nuclear physics.  This is crunch time, 
  baby - right or wrong?  You make the call.  Pressure's on.  
  Which will it be?  What if this is the question that will put me 
  under that passing grade.  A or C?  A or C?  Which will it 
  be?  What will I do?  You want the truth?  You want the 
  truth?  You can't handle the truth! 
  I'm heading back to the espresso machine now... 
  Brian 
  JOE TESTA wrote: 
   i still stand by(reading into the question) 
that it could be only 2 teachers get a raise, if the same 2 teachers teach 
both of those courses.  would they get twice as much of a raise? 
:) joe  
>>> [EMAIL PROTECTED] 08/21/01 12:52PM >>> in the where 
clause, the IN says "any teachers that are in any of these subjects. Since 
there are two subjects in the IN set and at least 2 teachers have to teach 
each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a 
raise. 
Jon Walthour > > From: [EMAIL PROTECTED] > Date: 
2001/08/21 Tue PM 12:25:54 EDT > To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> > Subject: How do they get the 
answer? > > I am taking the Self-Test software test for the 
SQL exam > and don't see how they get the answer to this problem. 
> They don't explain how it is arrived at. > > Any help 
you can give me will be appreciated. > > Thanks, > Ken 
Janusz, CPIM > > -- > 
> Examine the structure of the TEACHER table: > > 
Name    
Null?    Type > 
ID    
NOT NULL    NUMBER(9) > 
SALARY    
NUMBER > (7,2) > 
SUBJECT_ID    
NOT NULL    NUMBER(3) > 
SUBJECT_DESCRIPTION    
VARCHAR2(2) > > There are 200 teachers and 15 subjects.  
Each subject is > taught > by at least 2 teachers. > 
> Evaluate this PL/SQL block: > > DECLARE 
> 
v_pct_raise    number := 1.10; 
> BEGIN > 
UPDATE    teacher 
> 
SET    salary = salary * 1.10 
> 
WHERE    subject_id IN (102, 105); 
> COMMIT; > END; > > 
Which result will the PL/SQL block provide? > > (A) Only two 
teachers will receive a 10% salary increase. > (B) All of the 
teachers will receive a 10% salary > increase. > (C) At least 
four teachers will receive a 10% salary > increase. > (D) A 
syntax error will occur. > > Answer: > (C) > 
> > -- > 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: 
Jon Walthour   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).
  -- -- | Brian 
  McGraw -- Oracle DBA | | 
  Central Alabama Oracle Users Group | 
  || | mailto:[EMAIL PROTECTED]  
  | | http://bmcgraw.home.mindspring.com 
  | --   

Re: How do they get the answer?

[Igor Neyman]

It could be anywhere from 0 to more then 4 teachers receiving increase,
depending on whether there are teacher/teachers teaching both subjects, and
on whether one (or both subjects) with those IDs (102, 105) exists or not
exists in the table.
Extreme case (0 teachers receiving increase), when neither subject_id exists
in the table.


Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 12:57 PM


> I think you're being tricked by the question.
>
> If each subject is taught by two or more teachers, and you're updating the
> salaries of all teachers teaching two subjects, 2 x (2+?) >= 4
>
> Brian
>
> [EMAIL PROTECTED] wrote:
>
> > I am taking the Self-Test software test for the SQL exam
> > and don't see how they get the answer to this problem.
> > They don't explain how it is arrived at.
> >
> > Any help you can give me will be appreciated.
> >
> > Thanks,
> > Ken Janusz, CPIM
> >
> > --
> >
> > Examine the structure of the TEACHER table:
> >
> > NameNull?   Type
> > ID  NOT NULLNUMBER(9)
> > SALARY  NUMBER
> > (7,2)
> > SUBJECT_ID  NOT NULLNUMBER(3)
> > SUBJECT_DESCRIPTION VARCHAR2(2)
> >
> > There are 200 teachers and 15 subjects.  Each subject is
> > taught
> > by at least 2 teachers.
> >
> > Evaluate this PL/SQL block:
> >
> > DECLARE
> > v_pct_raise number := 1.10;
> > BEGIN
> > UPDATE  teacher
> > SET salary = salary * 1.10
> > WHERE   subject_id IN (102, 105);
> > COMMIT;
> > END;
> >
> > Which result will the PL/SQL block provide?
> >
> > (A) Only two teachers will receive a 10% salary increase.
> > (B) All of the teachers will receive a 10% salary
> > increase.
> > (C) At least four teachers will receive a 10% salary
> > increase.
> > (D) A syntax error will occur.
> >
> > Answer:
> > (C)
> >
> > --
> > 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).
>
> --
> --
> | Brian McGraw -- Oracle DBA |
> | Central Alabama Oracle Users Group |
> ||
> | mailto:[EMAIL PROTECTED]  |
> | http://bmcgraw.home.mindspring.com |
> --
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brian McGraw
>   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: Igor Neyman
  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 do they get the answer?

[Seley, Linda]

What if there are no subject_ids of either 102 or 105 or both in the table?
I'd say it's a case of not enough info (for us that is, not enough thought
on the part of whoever made it up but then they didn't ask the list did they
;-) ).  
 
This is why I dislike word problems.
 
Linda
 
 -Original Message-
Sent: Tuesday, August 21, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L



i still stand by(reading into the question) that it could be only 2 teachers
get a raise, if the same 2 teachers teach both of those courses.  would they
get twice as much of a raise? :)
 
joe


>>> [EMAIL PROTECTED] 08/21/01 12:52PM >>>
in the where clause, the IN says "any teachers that are in any of these
subjects. Since there are two subjects in the IN set and at least 2 teachers
have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers
will get a raise.

Jon Walthour
> 
> From: [EMAIL PROTECTED]
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How do they get the answer?
> 
> I am taking the Self-Test software test for the SQL exam 
> and don't see how they get the answer to this problem.  
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
> NameNull?Type
> IDNOT NULLNUMBER(9)
> SALARYNUMBER
> (7,2)
> SUBJECT_IDNOT NULLNUMBER(3)
> SUBJECT_DESCRIPTIONVARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
> v_pct_raisenumber := 1.10;
> BEGIN
> UPDATEteacher
> SETsalary = salary * 1.10
> WHEREsubject_id IN (102, 105);
> COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
> 
> 
> -- 
> 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: Jon Walthour
  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: Seley, Linda
  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 do they get the answer?

[eric harrington]

I agree with Joe, the correct answer is two. It doesn't state 
that a teacher can only teach one subject 
so the same two teachers can teach both 
subjects. I also agree with 
everyone that mentioned that this is a crappy 
question.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 
  Tuesday, August 21, 2001 2:52 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: How do they get the 
  answer?
  i still stand by(reading into the question) that it could be only 2 
  teachers get a raise, if the same 2 teachers teach both of those 
  courses.  would they get twice as much of a raise? :)
   
  joe
  >>> [EMAIL PROTECTED] 08/21/01 12:52PM >>>in 
  the where clause, the IN says "any teachers that are in any of these subjects. 
  Since there are two subjects in the IN set and at least 2 teachers have to 
  teach each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a 
  raise.Jon Walthour> > From: [EMAIL PROTECTED]> 
  Date: 2001/08/21 Tue PM 12:25:54 EDT> To: Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]>> Subject: How do they get the 
  answer?> > I am taking the Self-Test software test for the SQL 
  exam > and don't see how they get the answer to this problem.  
  > They don't explain how it is arrived at.> > Any help 
  you can give me will be appreciated.> > Thanks,> Ken 
  Janusz, CPIM> > --> 
  > Examine the structure of the TEACHER table:> > 
  Name            
      Null?        Type> 
  ID                
  NOT NULL    NUMBER(9)> SALARY    
                  
      NUMBER> (7,2)> SUBJECT_ID    
          NOT NULL    
  NUMBER(3)> SUBJECT_DESCRIPTION        
      VARCHAR2(2)> > There are 200 teachers and 15 
  subjects.  Each subject is > taught> by at least 2 
  teachers.> > Evaluate this PL/SQL block:> > 
  DECLARE>     v_pct_raise    
      number := 1.10;> BEGIN>     
  UPDATE        teacher>     
  SET        salary = salary * 1.10> 
      WHERE        subject_id IN 
  (102, 105);>     COMMIT;> END;> > 
  Which result will the PL/SQL block provide?> > (A) Only two 
  teachers will receive a 10% salary increase.> (B) All of the teachers 
  will receive a 10% salary > increase.> (C) At least four 
  teachers will receive a 10% salary > increase.> (D) A syntax 
  error will occur.> > Answer:> (C) > > 
  > -- > 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: Jon 
  Walthour  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

RE: Apologies... linux & Oracle

[Christopher Spence]

Title: Message



With enough ram, does it work without 
changing things?
 
"Do not criticize someone until you walked a mile in their shoes, that way 
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 
Fuelspot 73 Princeton Street North, Chelmsford 01863   

  
  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 2:17 
  PMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: 
  RE: Apologies... linux & Oracle
  yea 7.1, i've got it working and am using it on a daily basis, my biggest 
  problem is i only got 192M of ram, so i had to install the software(and none 
  of it would link during the install), and then link them all externally out of 
  the installer, then all was well.
   
  joe
  >>> [EMAIL PROTECTED] 08/21/01 02:52PM 
  >>>Anyone have luck with 9i on RedHat?  I am sure the answer 
  is yes as peoplehas mentioned trying.Do they have it documented what 
  is needed to be done to accomplish this?"Do not criticize someone 
  until you walked a mile in their shoes, that waywhen you criticize them, 
  you are a mile a way and have their shoes."Christopher R. Spence 
  Oracle DBAPhone: (978) 322-5744Fax:    (707) 
  885-2275Fuelspot73 Princeton StreetNorth, Chelmsford 
  01863-Original Message-Sent: Tuesday, August 
  21, 2001 1:31 PMTo: Multiple recipients of list ORACLE-LLora, 
  lisa, what ever...Oracle only supports SUSE 7.1 for Oracle 9i.I use 
  RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.Works 
  great but not supported. SCO was bought out by RedHat a while back 
  Ibelieve. ROR mª¿ªm>>> [EMAIL PROTECTED] 08/21/01 
  11:50AM >>>Sorry everyone, I know you were just discussing this 
  recently.  What is the most stable combination of Oracle & 
  Linux?  What would yourecommend?  I want to say the consensus 
  was SCO Linux but I don't quiteremember.  Thank 
  youLara CroftOracle Database Administrator Fairfield Resorts, 
  Inc-- 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-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage 
  BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing 
  list you want to be removed from).  You may also send the HELPcommand 
  for other information (like subscribing).--Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com--Author: 
  Christopher Spence  INET: [EMAIL PROTECTED]Fat City 
  Network Services    -- (858) 538-5051  FAX: (858) 
  538-5051San Diego, California    -- 
  Public Internet access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

Re: Apologies... linux & Oracle

[Konrad BüKo]

Title: Apologies... linux & Oracle



Hi
 
We've Oracle 8.1.5  8.1.6 and 8.1.7 on Suse 
Linux from 7.1 and 7.2 !
 
We've 6 Databases with this linux and this 
databases runnig since 01.02.01 as productive databases by 
switzerland post !
 
The size from the databases is from 10GB to 
80GB on Compact Server and we've no problems with it.
 
Regards Rudi

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, August 21, 2001 5:50 
  PM
  Subject: Apologies... linux & 
  Oracle
  
  Sorry everyone, I know you were just discussing 
  this recently.  
  What is the most stable combination of Oracle & 
  Linux?  What would you recommend?  I want to say the consensus was 
  SCO Linux but I don't quite remember.  
  Thank you 
  Lara Croft Oracle Database Administrator Fairfield Resorts, Inc 

Re: Nolog writes log ?

[JOE TESTA]

SQL Statements That Can Use No-Logging Mode   
    The following operations can make use of no-logging 
mode:     direct load 
(SQL*Loader)     direct-load INSERT 
    CREATE TABLE ... AS SELECT 
    CREATE INDEX 
    ALTER TABLE ... MOVE PARTITION 
    ALTER TABLE ... SPLIT PARTITION 
    ALTER INDEX ... SPLIT PARTITION 
    ALTER INDEX ... REBUILD 
    ALTER INDEX ... REBUILD PARTITION 
    INSERT, UPDATE, and DELETE on 
LOBs in NOCACHE NOLOGGING mode stored out of line
hth, joe
>>> [EMAIL PROTECTED] 08/21/01 01:47PM 
>>>Joe,I do not have the ability to test it at my sight. Would 
you test this and respond. Thanks,Oracle Performance Tuning Tips & 
Techniques Page 538. Subject NOLOGGING: "It specifies whether subsequent direct 
loader (SQL*LOADER) and direct-load INSERT operations against the table, 
partition, or LOB storage are logged".Sounds like only under "special" 
conditions the logging is not performed.Thanks,ROR 
mª¿ªm>>> [EMAIL PROTECTED] 08/21/01 12:42PM 
>>>yes.i've tested it and you should 
too.joe>>> [EMAIL PROTECTED] 08/21/01 11:21AM 
>>>Hi,I have Emp table NOLOGGING.Does it write to log files 
the insert,update,delete activity on that table 
?TiaAldi_Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi 
Barco  INET: [EMAIL PROTECTED] Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso 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-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: How do they get the answer?

[Boivin, Patrice J]

Multiple choice exams are lousy at testing creative, imaginative people,
because the answer ends up being "it depends" almost every time!

Hmmm, I wonder why they use them in universities...

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  



-Original Message-
From:   JOE TESTA [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: How do they get the answer?

i still stand by(reading into the question) that it could be only 2
teachers get a raise, if the same 2 teachers teach both of those courses.
would they get twice as much of a raise? :)
 
joe


>>> [EMAIL PROTECTED] 08/21/01 12:52PM >>>
in the where clause, the IN says "any teachers that are in any of
these subjects. Since there are two subjects in the IN set and at least 2
teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4
teachers will get a raise.

Jon Walthour
> 
> From: [EMAIL PROTECTED]
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How do they get the answer?
> 
> I am taking the Self-Test software test for the SQL exam 
> and don't see how they get the answer to this problem.  
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
> NameNull?Type
> IDNOT NULLNUMBER(9)
> SALARYNUMBER
> (7,2)
> SUBJECT_IDNOT NULLNUMBER(3)
> SUBJECT_DESCRIPTIONVARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
> v_pct_raisenumber := 1.10;
> BEGIN
> UPDATEteacher
> SETsalary = salary * 1.10
> WHEREsubject_id IN (102, 105);
> COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
> 
> 
> -- 
> 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: Jon Walthour
  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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

RE: Standby Database Error

[Ravindra Basavaraja]

I was able to configure the standby database.I am not clear about the redo
log files.Oracle
Standby database creation dod doesn't talk of moving the redo log files.Do
we have to move
the redo log files from the primary database to the standby database.But the
standby database
iw working fine and i open it in READ only mode to check if the data is in
sync with the primary database
and i found it to be good.

When I give selct member from v$logfile; it lists the redo logs but actually
no files
exist in that directory.

Should we move the redo logs also to the standby database from the primary
database.

Thanks
Ravindra

-Original Message-
Basavaraja
Sent: Friday, August 10, 2001 6:05 PM
To: Multiple recipients of list ORACLE-L


I am getting the following error when applying the archive files from the
production database
to the standby database.I just configured the standby database and was
applying the archive
files from production.

This error appeared after processing many archive files

ORA-00308: cannot open archived log
'/u03/ora/app/admin/sentica/arch/Prod_arch_1_9823.arc'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

What could be the problem.?

Thanks
Ravindra

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

TNSPING Test Script for NT

[Ed . Haskins]

Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file.  I
need to have the TNSPING run for say 1000 loops.  Once complete, I can
search through the file for errors.

Thanks,
Ed
-- 
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: WARNING: CURSOR_SHARING=FORCE on 8.1.7

[Kevin Kostyszyn]

It also causes ORA 600's, it was supposed to be fixed in Patch 8..1.7.1.. I
believe.
KK

-Original Message-
Sent: Tuesday, August 21, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L



Although it works for me under Oracle 8.1.7.1.4 on Win/2K as shown below, I
do have doubts about CURSOR_SHARING=FORCE. When I had experimented couple of
months ago, Oracle didn't substitute bind variables for all literals values,
and that wasn't going to help us. So we couldn't use this feature.

Jay


ORADB SQL>CREATE TABLE REJ_TEST (
  2ACCESSCONTROLID  NUMBER (10)   NOT NULL,
  3RESOURCE_NAMEVARCHAR2 (10)  NOT NULL,
  4ACTION   VARCHAR2 (10)  NOT NULL,
  5ISALLOWEDNUMBER (5)NOT NULL,
  6PARTYID  NUMBER (10)   NOT NULL,
  7PTYPENUMBER (3)NOT NULL);

Table created.

ORADB SQL>
ORADB SQL>insert into rej_test
  2   values (23, 'ESR', 'upd1', -1, 60, 1);

1 row created.

ORADB SQL>insert into rej_test
  2   values (60, 'ESR', 'upd1', -1, 13, 2);

1 row created.

ORADB SQL>
ORADB SQL>analyze table rej_test compute statistics;

Table analyzed.

ORADB SQL>
ORADB SQL>REM SELECT 1
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test
  3  WHERE
  4  (PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND
IsAllowed=-1
  5  AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>
ORADB SQL>ALTER SESSION SET CURSOR_SHARING=EXACT;

Session altered.

ORADB SQL>
ORADB SQL>REM SELECT 2
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test
  3  WHERE
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1) OR
  5   (PartyID=13  AND IsAllowed=-1 AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>
ORADB SQL>ALTER SESSION SET CURSOR_SHARING=FORCE;

Session altered.

ORADB SQL>
ORADB SQL>REM SELECT 3
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test
  3  WHERE
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1)
  5  OR
  6  (PartyID=13  AND IsAllowed=-1 AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>


-Original Message-
Sent: Tuesday, August 21, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L


Eeeek!  It just keeps getting worse!  Can someone on 8.1.7.x on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system level try the
following test for me?

--

DROP TABLE REJ_TEST CASCADE CONSTRAINTS ;

CREATE TABLE REJ_TEST (
  ACCESSCONTROLID  NUMBER (10)   NOT NULL,
  RESOURCE_NAMEVARCHAR2 (10)  NOT NULL,
  ACTION   VARCHAR2 (10)  NOT NULL,
  ISALLOWEDNUMBER (5)NOT NULL,
  PARTYID  NUMBER (10)   NOT NULL,
  PTYPENUMBER (3)NOT NULL);

insert into rej_test
values (23, 'ESR', 'upd1', -1, 60, 1);
insert into rej_test
values (60, 'ESR', 'upd1', -1, 13, 2);

analyze table rej_test compute statistics;

REM SELECT 1

SELECT Resource_Name, Action
FROM rej_test
WHERE
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND IsAllowed=-1
AND PType=2);

ALTER SESSION SET CURSOR_SHARING=EXACT;

REM SELECT 2

SELECT Resource_Name, Action
FROM rej_test
WHERE
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

ALTER SESSION SET CURSOR_SHARING=FORCE;

REM SELECT 3

SELECT Resource_Name, Action
FROM rej_test
WHERE
(PartyID=60 AND IsAllowed=-1 AND PType=1)
OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

--

I've purposely formatted each SELECT a little differently in order to force
a hard parse.  The problem I'm seeing is that SELECT #1 and #3 *RETURN NO
ROWS*!  If #3's formatted to be just like #2, it works fine, which leads me
to believe the problem's in the parse.

TIA!

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


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



This electronic message contains information from CTIS, Inc., which
may be company sensitive, proprietary, privileged or otherwise protected
from disclosure. The information is intended to be used solely by the
recipients named abo

RE: Freelist Contention - PQ slaves

[Johnson Poovathummoottil]

What happens when you join a large parllelized table
with a very small table (contained in just 10 or 12
blocks) the retrieval of rows from the large table
looks up the small table causing buffer busy waits on
the blocks of the small table. Keeping the small table
in keep pool removes the buffer busy waits.

--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> I thought that parallel query slaves were smart
> enough to divide up the work
> between them so there was no overlap?  What am I
> missing?  Can you
> elaborate?
> 
> > -Original Message-
> > From:   Johnson Poovathummoottil
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 21, 2001 11:21
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Freelist Contention
> > 
> > Bufer busy waits can also be caused by parallel
> query
> > servers trying to read the same buffer block at
> the
> > same time. So does it always indicate a freelist
> > problem?
> > .
> > --- Jon Walthour <[EMAIL PROTECTED]> wrote:
> > > Raja:
> > > 
> > > You will know you have freelist contention if
> you
> > > have a significant
> > > buffer busy waits ratio (>5%). 
> > >  
> > > Jon Walthour
> > > 
> > > -Original Message-
> > > Luthra
> > > Sent: Monday, August 20, 2001 11:45 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hello folks,
> > > 
> > > How do I come to know that there is a contention
> > > going on in the
> > > freelists? Is there any v$ table or this type of
> > > contention you derive
> > > from some other info. like a ripple effect from
> some
> > > parameter?
> > > 
> > > TIA.
> > > 
> > > raja
> > > 
> > > 
> > > Get 250 color business cards for FREE!
> > > http://businesscards.lycos.com/vp/fastpath/
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > -- 
> > > Author: Viraj Luthra
> > >   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: Jon Walthour
> > >   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!?
> > Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Johnson Poovathummoottil
> >   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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  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 y

RE: Apologies... linux & Oracle

[Daniel Curry]

SCO (Unix) was bought by Caldera who releases a version or flavor of
Linux.  Caldera's main emphasis has been (historically) the desktop and
end users.  During the Linux World conference in San Jose last year,
Caldera announced their acquisition of SCO to fuel their server line of
software products.
 
See this link for more information.
http://ir.caldera.com/ReleaseDetail.cfm?ReleaseID=38489
 
 
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
 
SCO makes a version of Linux now?  
 
Ed
-Original Message-
Sent: Tuesday, August 21, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Curry
  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: User access within/outside of app

[Larry Hahn]

Jon,

Thanks for the response. But these users still need to
do updates through the app. I only want to keep them
from doing updates from outside the app.

Larry
--- Jon Walthour <[EMAIL PROTECTED]> wrote:
> Create another user with select privileges only on
> the objects in the app's schema. Give that one to
> them and then change the password on the original
> app id so they won't be able to use that one
> anymore.
> 
> Jon Walthour
> > 
> > From: Larry Hahn <[EMAIL PROTECTED]>
> > Date: 2001/08/21 Tue AM 11:21:04 EDT
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > Subject: User access within/outside of app
> > 
> > List,
> > 
> > We have purchased a system where users login
> through
> > an ODBC connection using a generic Oracle userid.
> This
> > userid has full rights to do insert, update,
> delete,
> > select on any table in the schema. The app asks
> for
> > another username and password which checks the
> > application security table, which limits what
> areas of
> > the apps they can access. 
> > 
> > Although this may work fine for the app, the users
> > also have the ability to use Access and other ODBC
> > compliant programs to look at the data. When doing
> so,
> > they use the same ODBC DSN and, what do you know,
> they
> > have capabilities beyond their wildest
> imagination. 
> > 
> > This is obviously not a situation I want to
> implement.
> > I am looking for a way to allow a user into the
> app to
> > do their normal work, but only allow read access
> for
> > anything outside the app. 
> > 
> > Any suggestions or ideas would be more than
> welcome.
> > 
> > Thanks,
> > 
> > Larry Hahn
> > Journal Sentinel, Inc. 
> > 
> > __
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Larry Hahn
> >   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: Jon Walthour
>   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).


=
Larry Hahn
DBA
Journal Sentinel,Inc

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Hahn
  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: Freelist Contention

[Jonathan Lewis]

Not only that, PX slaves do direct reads
 anyway, bypassing the buffer cache.

It is possible, though, that the flush
that has to take place before the PX
scan can read back is sufficient to 
cause other processes to wait for
write complete waits, and I guess that
you could also get extra rbs header
waits as the flushed and scanned blocks
are rolled back by the PX slaves for
read consistency.


Excessive serial tablescans, on the other
hand can easily cause significant buffer
busy waits.

Jonathan Lewis

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

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 21 August 2001 18:32


|On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
|> Bufer busy waits can also be caused by parallel query
|> servers trying to read the same buffer block at the
|> same time.
|
|Just off the top of my head, and without giving it a lot
|of thought, this doesn't sound right.
|
|PQS divvy up the blocks to read, and should not be trying
|to access the same block.
|
|Got any documentation or evidence to back that up?
|
|Jared


-- 
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: How do they get the answer?

[Pat Hildebrand]

This is a poorly written question. I would guess that since it is the
teacher table the assumption is that the ID is unique, even a primary
key (it is not null), but none of this is stated so it doesn't have to
be the case. Although I can't see it making any sense to repeat the
salary (if indeed this is the salary for the teacher rather than the
course), if a teacher can be in more than once that block could be
used an example of an update not doing what was expected.

The update is done on subject_id and it is the record with that
subject_id. If a teacher is teaching more than one course and the
salary if for the teacher rather than the course, we end up with the
possibility of different salaries for the same teacher and if the
teacher happened to be teaching both and therefore was to get two
raises what happens but those two records are now consistent at the
wrong value.

Of course with what info is given in the question there are other
possibilities for what the table really represents and what the PL/SQL
block is supposed to do.

I would think an essay question on what is going on would be more
revealing of the individual's knowledge than a flawed multiple guess
question. I don't think I have ever heard of it for anything other
than true-false but justifying the selection might make it a little
more useful.

   Pat


> 
> Examine the structure of the TEACHER table:
> 
> Name  Null?   Type
> IDNOT NULLNUMBER(9)
> SALARYNUMBER
> (7,2)
> SUBJECT_IDNOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION   VARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
>   v_pct_raise number := 1.10;
> BEGIN
>   UPDATE  teacher
>   SET salary = salary * 1.10
>   WHERE   subject_id IN (102, 105);
>   COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pat Hildebrand
  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 do they get the answer?

[Brian McGraw]

It's possible, but not the only possibility.  Therefore you can't
answer A.
And if you're not certain, you can't answer the question.  Because
this is the Oracle OCP exam.  The thing that you've studied
night and day for.  Everything you learned in the two-night class
preparing you for database administration and nuclear physics.  This
is crunch time, baby - right or wrong?  You make the call.  Pressure's
on.  Which will it be?  What if this is the question that
will put me under that passing grade.  A or C?  A or C? 
Which will it be?  What will I do?  You want the truth? 
You want the truth?  You can't handle the truth!
I'm heading back to the espresso machine now...
Brian
JOE TESTA wrote:
 i still stand by(reading into the question)
that it could be only 2 teachers get a raise, if the same 2 teachers teach
both of those courses.  would they get twice as much of a raise? :) joe 
>>> [EMAIL PROTECTED] 08/21/01 12:52PM >>>
in the where clause, the IN says "any teachers that are in any of these
subjects. Since there are two subjects in the IN set and at least 2 teachers
have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers
will get a raise.
Jon Walthour
>
> From: [EMAIL PROTECTED]
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How do they get the answer?
>
> I am taking the Self-Test software test for the SQL exam
> and don't see how they get the answer to this problem.
> They don't explain how it is arrived at.
>
> Any help you can give me will be appreciated.
>
> Thanks,
> Ken Janusz, CPIM
>
> --
>
> Examine the structure of the TEACHER table:
>
> Name   
Null?    Type
> ID   
NOT NULL    NUMBER(9)
> SALARY   
NUMBER
> (7,2)
> SUBJECT_ID   
NOT NULL    NUMBER(3)
> SUBJECT_DESCRIPTION   
VARCHAR2(2)
>
> There are 200 teachers and 15 subjects.  Each subject is
> taught
> by at least 2 teachers.
>
> Evaluate this PL/SQL block:
>
> DECLARE
> v_pct_raise   
number := 1.10;
> BEGIN
> UPDATE   
teacher
> SET   
salary = salary * 1.10
> WHERE   
subject_id IN (102, 105);
> COMMIT;
> END;
>
> Which result will the PL/SQL block provide?
>
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary
> increase.
> (C) At least four teachers will receive a 10% salary
> increase.
> (D) A syntax error will occur.
>
> Answer:
> (C)
>
>
> --
> 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: Jon Walthour
  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).

--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--
 

Re: What is in archive log...

[JOE TESTA]

Aldi, there is a bit to be desired in 8i logmining.  no ddl, no 
chained/migrated rows, etc.
 
joe
>>> [EMAIL PROTECTED] 08/21/01 12:48PM >>>Check 
out the Oracle 8i Administrator's Guide, look at the chapter entitled: "Using 
LogMiner to Analyze Online and Archived Redo Logs".Jon Walthour> 
> From: "Aldi Barco" <[EMAIL PROTECTED]>> Date: 2001/08/21 
Tue AM 11:41:32 EDT> To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>> Subject: What is in archive log...> 
> Hi Lister,> > Can we read what activities are in archive 
log files ?> (utility like 'tkprof' to read trace file).> 
Tia.> > Aldi> > > 
_> Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp> 
> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > 
Author: Aldi Barco>   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: Jon 
Walthour  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: How do they get the answer?

[Rachel Carmichael]

um, I can see possible answers to this question being 2 teachers, 3 teachers 
or 4 teachers.

however, since that isn't one of the multiple choice answers, then it has to 
be "at least 4" since "only 2" is wrong


>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How do they get the answer?
>Date: Tue, 21 Aug 2001 09:27:46 -0800
>
>two subjects in the "in" clause, times at least two teachers per subject
>equals at least four records updated.
>
>sometimes it is easier to eliminate answers first.
>like, you can throw out d) syntax will occur. and b) all teachers will get
>an increase.
>you are then left with a) two teachers and c). at least four teachers.
>
>Since the "where" clause is looking at the 'subject_id' column, rather than
>the 'teacher_id' column, you can almost guess that it is c).
>
>hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Tuesday, August 21, 2001 12:26 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I am taking the Self-Test software test for the SQL exam
>and don't see how they get the answer to this problem.
>They don't explain how it is arrived at.
>
>Any help you can give me will be appreciated.
>
>Thanks,
>Ken Janusz, CPIM
>
>--
>
>Examine the structure of the TEACHER table:
>
>Name   Null?   Type
>ID NOT NULLNUMBER(9)
>SALARY NUMBER
>(7,2)
>SUBJECT_ID NOT NULLNUMBER(3)
>SUBJECT_DESCRIPTIONVARCHAR2(2)
>
>There are 200 teachers and 15 subjects.  Each subject is
>taught
>by at least 2 teachers.
>
>Evaluate this PL/SQL block:
>
>DECLARE
>   v_pct_raise number := 1.10;
>BEGIN
>   UPDATE  teacher
>   SET salary = salary * 1.10
>   WHERE   subject_id IN (102, 105);
>   COMMIT;
>END;
>
>Which result will the PL/SQL block provide?
>
>(A) Only two teachers will receive a 10% salary increase.
>(B) All of the teachers will receive a 10% salary
>increase.
>(C) At least four teachers will receive a 10% salary
>increase.
>(D) A syntax error will occur.
>
>Answer:
>(C)
>
>
>--
>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: Mercadante, Thomas F
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Apologies... linux & Oracle

[JOE TESTA]

yea 7.1, i've got it working and am using it on a daily basis, my biggest 
problem is i only got 192M of ram, so i had to install the software(and none of 
it would link during the install), and then link them all externally out of the 
installer, then all was well.
 
joe
>>> [EMAIL PROTECTED] 08/21/01 02:52PM 
>>>Anyone have luck with 9i on RedHat?  I am sure the answer 
is yes as peoplehas mentioned trying.Do they have it documented what is 
needed to be done to accomplish this?"Do not criticize someone until you 
walked a mile in their shoes, that waywhen you criticize them, you are a 
mile a way and have their shoes."Christopher R. Spence Oracle 
DBAPhone: (978) 322-5744Fax:    (707) 
885-2275Fuelspot73 Princeton StreetNorth, Chelmsford 
01863-Original Message-Sent: Tuesday, August 21, 
2001 1:31 PMTo: Multiple recipients of list ORACLE-LLora, lisa, 
what ever...Oracle only supports SUSE 7.1 for Oracle 9i.I use RedHat 6.2 
with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.Works great but not 
supported. SCO was bought out by RedHat a while back Ibelieve. ROR 
mª¿ªm>>> [EMAIL PROTECTED] 08/21/01 11:50AM 
>>>Sorry everyone, I know you were just discussing this 
recently.  What is the most stable combination of Oracle & 
Linux?  What would yourecommend?  I want to say the consensus was 
SCO Linux but I don't quiteremember.  Thank youLara 
CroftOracle Database Administrator Fairfield Resorts, 
Inc-- 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-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage 
BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list 
you want to be removed from).  You may also send the HELPcommand for 
other information (like subscribing).--Please see the official ORACLE-L 
FAQ: http://www.orafaq.com--Author: 
Christopher Spence  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

[Jacques Kilchoer]

Title: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7





> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]


> 
> Eeeek!  It just keeps getting worse!  Can someone on 8.1.7.x 
> on a NON-HP
> platform using CURSOR_SHARING=FORCE and CBO at the system 
> level try the
> following test for me?



Here are my results. No rows returned from the third query!!!


SQL> select * from v$version ;


BANNER

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE    8.1.7.0.0   Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production


SQL> CREATE TABLE REJ_TEST ( 
  2    ACCESSCONTROLID  NUMBER (10)   NOT NULL, 
  3    RESOURCE_NAME    VARCHAR2 (10)  NOT NULL, 
  4    ACTION   VARCHAR2 (10)  NOT NULL, 
  5    ISALLOWED    NUMBER (5)    NOT NULL, 
  6    PARTYID  NUMBER (10)   NOT NULL, 
  7    PTYPE    NUMBER (3)    NOT NULL);


Table created.


SQL> 
SQL> insert into rej_test
  2   values (23, 'ESR', 'upd1', -1, 60, 1);


1 row created.


SQL> insert into rej_test
  2   values (60, 'ESR', 'upd1', -1, 13, 2);


1 row created.


SQL> 
SQL> analyze table rej_test compute statistics;


Table analyzed.


SQL> 
SQL> REM SELECT 1
SQL> 
SQL> SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4  (PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND IsAllowed=-1
  5  AND PType=2);


RESOURCE_N ACTION
-- --
ESR    upd1
ESR    upd1


SQL> 
SQL> ALTER SESSION SET CURSOR_SHARING=EXACT;


Session altered.


SQL> 
SQL> REM SELECT 2
SQL> 
SQL> SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1) OR
  5   (PartyID=13  AND IsAllowed=-1 AND PType=2);


RESOURCE_N ACTION
-- --
ESR    upd1
ESR    upd1


SQL> 
SQL> ALTER SESSION SET CURSOR_SHARING=FORCE;


Session altered.


SQL> 
SQL> REM SELECT 3
SQL> 
SQL> SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1)
  5  OR
  6  (PartyID=13  AND IsAllowed=-1 AND PType=2);


no rows selected

Re: How do they get the answer?

[Bunyamin K. Karadeniz]

The answer must be AT LEAST 2 Teachers . 
Because lets say two teachers Rick and Susan.

Susan gives the subjects 102 and 105 
Rick  gives the subjects 102 and 105 
Nobody else gives these subjects. 

This proves that at least two teachers are given salary rise. 
bunyamin

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 8:03 PM


> >> Each subject is taught by at least 2 teachers.
> So, if 102 and 105 are the 2 subject-ids, then a total of at least 4
> teachers will get selected for salary update. 
> Correct ? 
> 
> Regards,
> 
> - Kirti Deshpande 
>   Verizon Information Services
>http://www.superpages.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 21, 2001 11:26 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: How do they get the answer?
> > 
> > I am taking the Self-Test software test for the SQL exam 
> > and don't see how they get the answer to this problem.  
> > They don't explain how it is arrived at.
> > 
> > Any help you can give me will be appreciated.
> > 
> > Thanks,
> > Ken Janusz, CPIM
> > 
> > --
> > 
> > Examine the structure of the TEACHER table:
> > 
> > Name Null? Type
> > ID NOT NULL NUMBER(9)
> > SALARY NUMBER
> > (7,2)
> > SUBJECT_ID NOT NULL NUMBER(3)
> > SUBJECT_DESCRIPTION VARCHAR2(2)
> > 
> > There are 200 teachers and 15 subjects.  Each subject is 
> > taught
> > by at least 2 teachers.
> > 
> > Evaluate this PL/SQL block:
> > 
> > DECLARE
> > v_pct_raise number := 1.10;
> > BEGIN
> > UPDATE teacher
> > SET salary = salary * 1.10
> > WHERE subject_id IN (102, 105);
> > COMMIT;
> > END;
> > 
> > Which result will the PL/SQL block provide?
> > 
> > (A) Only two teachers will receive a 10% salary increase.
> > (B) All of the teachers will receive a 10% salary 
> > increase.
> > (C) At least four teachers will receive a 10% salary 
> > increase.
> > (D) A syntax error will occur.
> > 
> > Answer:
> > (C) 
> > 
> > 
> > -- 
> > 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: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin K. Karadeniz
  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: Index question ???

[Koivu, Lisa]

Title: RE: Index question ???





Andrea, 


It is recommended, not required.  Anytime the db needs to verify the fk constraint, if there isn't an index there to support it, a full table scan will happen.  Performance killer.

What do you mean your indices disappeared?  Can you elaborate?  


-Original Message-
From:   Andrea Oracle [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 14:06
To: Multiple recipients of list ORACLE-L
Subject:    Index question ???


Hi, all


I got couple of indices questions:


Is it REQUIRED or just recommended to build an index
on FK column/s?


I used Alter Table ... Move and Alter Index ...
Rebulid to move the table into differenct block and
then rebuild index.  Table Move works fine, but after
index rebuilt, some indices disappeared! How come?


Thanks!


Andrea


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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).

Problem in setting up Pro*C on RedHat Linux 6.1 with Oracle Serve

[Kumar, Dharminder]

Hey all,
My system is RedHat 6.1 and installed oracle version is 8.05. Database is
running fine. But I was trying to check if Pro*C is setup properly. I am
getting the following errors when I try to compile the sample programs. I am
able to compile C programs successfully using cc command.

Can somebody give me a clue, what could be wrong. 

Thx.


make -f /home/u01/app/oracle/product/8.1.5/plsql/demo/demo_plsql.mk build
EXE=examp10 OBJS=examp10.
o
make[1]: Entering directory `/home/oracle/sample'
/home/u01/app/oracle/product/8.1.5/bin/proc sqlcheck=full userid=scott/tiger
CHAR_MAP=VARCHAR2, DBM
S=V7 iname=examp10.pc

Pro*C/C++: Release 8.0.5.0.0 - Production on Thu Aug 16 8:45:53 2001

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

System default option values taken from:
/home/u01/app/oracle/product/8.1.5/precomp/admin/pcscfg.cf
g

Error at line 33, column 11 in file /usr/include/stdio.h
Syntax error at line 368, column 19, file /usr/include/libio.h:
Error at line 368, column 19 in file /usr/include/libio.h
extern _IO_size_t _IO_sgetn __P ((_IO_FILE *, void *, _IO_size_t));
..1
PCC-S-02201, Encountered the symbol "_IO_sgetn" when expecting one of the
follow
ing:

   ; , = ( [
The symbol ";" was substituted for "_IO_sgetn" to continue.

Syntax error at line 442, column 15, file /usr/include/stdio.h:
Error at line 442, column 15 in file /usr/include/stdio.h
extern size_t fread __P ((void *__restrict __ptr, size_t __size,
..1
PCC-S-02201, Encountered the symbol "fread" when expecting one of the
following:

   ; , = ( [
The symbol ";" was substituted for "fread" to continue.

Syntax error at line 445, column 15, file /usr/include/stdio.h:
Error at line 445, column 15 in file /usr/include/stdio.h
extern size_t fwrite __P ((__const void *__restrict __ptr, size_t __size,
..1
PCC-S-02201, Encountered the symbol "fwrite" when expecting one of the
following
:

   ; , = ( [
The symbol ";" was substituted for "fwrite" to continue.

Syntax error at line 450, column 15, file /usr/include/stdio.h:
Error at line 450, column 15 in file /usr/include/stdio.h
extern size_t fread_unlocked __P ((void *__restrict __ptr, size_t __size,
..1
PCC-S-02201, Encountered the symbol "fread_unlocked" when expecting one of
the f
ollowing:

   ; , = ( [
The symbol ";" was substituted for "fread_unlocked" to continue.

Syntax error at line 452, column 15, file /usr/include/stdio.h:
Error at line 452, column 15 in file /usr/include/stdio.h
extern size_t fwrite_unlocked __P ((__const void *__restrict __ptr,
..1
PCC-S-02201, Encountered the symbol "fwrite_unlocked" when expecting one of
the 
following:

   ; , = ( [
The symbol ";" was substituted for "fwrite_unlocked" to continue.

Error at line 0, column 0 in file examp10.pc
PCC-F-02102, Fatal error while doing C preprocessing
make[1]: Leaving directory `/home/oracle/sample'
[oracle@kahnuwan ]$ 

Dharminder Kumar




This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal. Unless otherwise stated,
opinions expressed in this e-mail are those of the author and are not
endorsed by the author's employer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kumar, Dharminder
  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: TNSPING Test Script for NT

[Mercadante, Thomas F]

Ed,

how about:


tnsping {sid} 1000 > ping.lis

will tnsping the {sid} 1000 times, with the result being placed in a file
created named ping.lis

changing it to

***  file name pingtest.bat
tnsping %1 1000 > ping.lis

Can be executed as   pingtest {sid}


Another way to do this using a loop within the .bat file follows.
This would execute the tnsping command 1000 times:

***  file name pingtest1.bat
echo TnsPing Test > ping.lis
echo date /T  >> ping.lis
for /L %I in (1,1,1000) do tnsping r816 >> ping.lis


And a third way, using goto looping:

***  file name pingtest2.bat
@rem
@rem  Loop through a counter searching for the RunDaily.{seq} file
@rem

@set /A ctr=0

:again

echo TnsPing Test > ping.lis
echo date /T  >> ping.lis
set /A ctr=ctr+1

if (%ctr%) == (1000) goto endloop
tnsping r816 >> ping.lis
goto again

:endloop

hope these help.


Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L


Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file.  I
need to have the TNSPING run for say 1000 loops.  Once complete, I can
search through the file for errors.

Thanks,
Ed
-- 
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: Mercadante, Thomas F
  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: High DML Table - Suggestions??

[Jay Mehta]

Walter,

Couple of other areas to watch while DMLs are being issues against this
table are: LGWR and DBWR statistics and activities. Based on DBWR/LGWR
statistics, you may need to tune these parameters.

Jay

-Original Message-
Sent: Monday, August 20, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a table that is going to have a large amount of
inserts, updates and deletes performed against it
daily. Approximately 1,000,000 transactions per day
(some single-record, some multi-record). The table is
~100Mb in size.

I'm looking for some suggestions on what I can do to
have the most optimal I/O for the table. I've been
doing a little reading about buffer pools. Is
assigning this table to a KEEP pool a practical
approach or is that not going to buy me anything
because DML is involved? Does anyone have any other
suggestions?

Unfortunately, I can't put the table on a dedicated
disk and I am stuck with Raid-5 currently.

Any suggestions would be appreciated.

Thanks in advance!
-w

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
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).



This electronic message contains information from CTIS, Inc., which 
may be company sensitive, proprietary, privileged or otherwise protected 
from disclosure. The information is intended to be used solely by the 
recipients named above. If you are not an intended recipient, be aware 
that any review, disclosure, copying, distribution or use of this 
transmission or its contents is prohibited.  If you have received this 
transmission in error, please notify us immediately at [EMAIL PROTECTED] 




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

User access within/outside an app

[Larry Hahn]

List,

We have purchased a system where users login through
an ODBC connection using a generic Oracle userid. This
userid has full rights to do insert, update, delete,
select on any table in the schema. The app asks for
another username and password which checks the
application security table, which limits what areas of
the apps they can access. 

Although this may work fine for the app, the users
also have the ability to use Access and other ODBC
compliant programs to look at the data. When doing so,
they use the same ODBC DSN and, what do you know, they
have capabilities beyond their wildest imagination. 

This is obviously not a situation I want to implement.
I am looking for a way to allow a user into the app to
do their normal work, but only allow read access for
anything outside the app. 

Any suggestions or ideas would be more than welcome.

Thanks,

Larry Hahn
Journal Sentinel, Inc. 


=
Larry Hahn
DBA
Journal Sentinel,Inc

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Hahn
  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: MOVE Tables from One Tablespace to Another Tablespace !!

[Glenn Travis]

I just did this yesterday.  Here are the scripts I used;

sqlplus system/syspaswd

set pagesize 0
set feedback off
spool mv_tbls.sql
select 'alter table '|| owner || '.' || segment_name || ' move tablespace
new_tblspc;'
from dba_segments
where segment_type='TABLE'
and tablespace_name='old_tblspc';
spool off;
spool alter_idxs.sql
select 'alter index ' || i.table_owner || '.' || i.index_name || ' rebuild;'
from dba_indexes i, dba_segments s
where s.segment_name=i.table_name
and s.owner=i.table_owner
and s.segment_type='TABLE'
and s.tablespace_name='old_tblspc';
spool off;

this is from memory, so check the spooled scripts before running...

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
INF/MEKKAOUI
Sent: Tuesday, August 21, 2001 5:41 AM
To: Multiple recipients of list ORACLE-L


hi,
the command is :

Alter table table_name move tablespace tablespace_name;

But be careful from index corruption.

Best Regards,
Nabila Mekkaoui
DBA Oracle


-Message d'origine-
De : Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 21 août 2001 08:16
À : Multiple recipients of list ORACLE-L
Objet : MOVE Tables from One Tablespace to Another Tablespace !!



Hello All,


Please tell me the detailed steps to move tables from one tablespace to
another tablespace.

Regards,
Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj  (CAP,CEF)
  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: INF/MEKKAOUI
  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: How do they get the answer?

[Ron Rogers]

At least 2 teachers per subject and the where clause has 2 subjects in the query. 2 
teachers X 2 subjects= 4 minimum.
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/21/01 12:25PM >>>
I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.

Any help you can give me will be appreciated.

Thanks,
Ken Janusz, CPIM

--

Examine the structure of the TEACHER table:

NameNull?   Type
ID  NOT NULLNUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID  NOT NULLNUMBER(3)
SUBJECT_DESCRIPTION VARCHAR2(2)

There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.

Evaluate this PL/SQL block:

DECLARE
v_pct_raise number := 1.10;
BEGIN
UPDATE  teacher
SET salary = salary * 1.10
WHERE   subject_id IN (102, 105);
COMMIT;
END;

Which result will the PL/SQL block provide?

(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.

Answer:
(C) 


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

8.1.7/HP-UX 11/PRODUCT_USER_PROFILE

[Vergara, Michael (TEM)]

Hi All:

I have entries in the PRODUCT_USER_PROFILE to inhibit a user from
executing the DROP command.  However, if I embed a DROP command
inside a PL/SQL procedure, and execute it with Dynamic SQL, the
DROP is executed.

Is this normal?

Thanx,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Freelist Contention - PQ slaves

[Gogala, Mladen]

Another thing that comes to mind is incorrectly tuned DBWR, which cannot
keep up.

> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Freelist Contention - PQ slaves
> 
> 
> Lisa is right. PQ slaves operate on different set of blocks 
> and would not be
> contending for the same blocks. 
> 
> - Kirti 
> 
> > -Original Message-
> > From:   Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 21, 2001 11:42 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Freelist Contention - PQ slaves
> > 
> > I thought that parallel query slaves were smart enough to 
> divide up the
> > work between them so there was no overlap?  What am I 
> missing?  Can you
> > elaborate?
> > 
> > -Original Message- 
> > From:   Johnson Poovathummoottil [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, August 21, 2001 11:21 
> > To: Multiple recipients of list ORACLE-L 
> > Subject:RE: Freelist Contention 
> > 
> > Bufer busy waits can also be caused by parallel query 
> > servers trying to read the same buffer block at the 
> > same time. So does it always indicate a freelist 
> > problem? 
> > . 
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

RE: Apologies... linux & Oracle

[Koivu, Lisa]

Title: RE: Apologies... linux & Oracle





Dunno...  I know even less about Linux than I do about perl and smtp. 


LK


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 13:31
To: Multiple recipients of list ORACLE-L
Subject:    RE: Apologies... linux & Oracle


SCO makes a version of Linux now?  
 
Ed


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Apologies... linux & Oracle




Sorry everyone, I know you were just discussing this recently.  


What is the most stable combination of Oracle & Linux?  What would you recommend?  I want to say the consensus was SCO Linux but I don't quite remember.  

Thank you 


Lara Croft
Oracle Database Administrator
Fairfield Resorts, Inc 

RE: How do they get the answer?

[Jamadagni, Rajendra]

What if there are only two teachers among all teachers that teach both the
(specified) subjects ?

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 !

-Original Message-
Sent: Tuesday, August 21, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L

in the where clause, the IN says "any teachers that are in any of these
subjects. Since there are two subjects in the IN set and at least 2 teachers
have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers
will get a raise.

Jon Walthour

*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 corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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 do they get the answer?

[Koivu, Lisa]

Title: RE: How do they get the answer?





Ken, after reading through the quesiton and thinking it through I arrived at the answer they give.  They are trying to trick you into choosing syntax error.  You'll find questions similar to this on the exams. 

Lara Croft. 
Certified Tomb Raider and DBA.
Ft. Lauderdale, FL, USA


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 12:26
To: Multiple recipients of list ORACLE-L
Subject:    How do they get the answer?


I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.


Any help you can give me will be appreciated.


Thanks,
Ken Janusz, CPIM


--


Examine the structure of the TEACHER table:


Name                Null?       Type
ID              NOT NULL    NUMBER(9)
SALARY                      NUMBER
(7,2)
SUBJECT_ID          NOT NULL    NUMBER(3)
SUBJECT_DESCRIPTION         VARCHAR2(2)


There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.


Evaluate this PL/SQL block:


DECLARE
    v_pct_raise     number := 1.10;
BEGIN
    UPDATE      teacher
    SET     salary = salary * 1.10
    WHERE       subject_id IN (102, 105);
    COMMIT;
END;


Which result will the PL/SQL block provide?


(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.


Answer:
(C) 



-- 
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: Nolog writes log ?

[Ron Rogers]

Joe,
 I do not have the ability to test it at my sight. Would you test this and respond. 
Thanks,
Oracle Performance Tuning Tips & Techniques Page 538. Subject NOLOGGING: "It specifies 
whether subsequent direct loader (SQL*LOADER) and direct-load INSERT operations 
against the table, partition, or LOB storage are logged".
Sounds like only under "special" conditions the logging is not performed.
Thanks,
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 12:42PM >>>
yes.

i've tested it and you should too.

joe


>>> [EMAIL PROTECTED] 08/21/01 11:21AM >>>
Hi,
I have Emp table NOLOGGING.
Does it write to log files the insert,update,delete activity on that table ?
Tia

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Aldi Barco
  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: linux & Oracle -- best combination

[Christopher Spence]

I would be curious to see these tests going forward, seeing as RedHat
support is difficult to do with 9i and such.  And suse now being Oracle's
perfered linux.  I wonder if these results have changed.  I never really
played with Oracle on Linux, but if I ever had to, I would be curious.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:53 PM
To: Multiple recipients of list ORACLE-L


Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an ISO
9002 compliance to maintain as I provided testing and supporting data to our
clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to the
full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less satisfactory
performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1 and
another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the best
I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


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: Daniel Curry
  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: Christopher Spence
  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: Exporting partitioned tables

[JOE TESTA]

quickly looking at metalstink, it appears quite often with an ora-600 
message, got one of those in the alert.log?
 
joe
>>> [EMAIL PROTECTED] 08/21/01 12:35PM 
>>>
Greetings and salutations oh magnificent Oracles of Oracle, 
 
I am experiencing something that I don't understand.  (No comments 
from the peanut gallery!) When I do an export for a schema that contains a 
number of partitioned tables most of the time everything works fine.  

 
Sometimes however, the last partition of one object produces the following 
errors:
 
EXP-8: Oracle error 8103 encountered
ORA-08103: object no longer exists 
 
This error happens overnight and when I check in the morning (select 
count(*) from schema.table partition (P026);) and it always shows that I have 
rows.
 
I RTFM'd and that error message indicates that the object is gone.  
This object is not dropped and re-created by any process.  
 
Any ideas?
 
Stephen Andert
 
 

Index question ???

[Andrea Oracle]

Hi, all

I got couple of indices questions:

Is it REQUIRED or just recommended to build an index
on FK column/s?

I used Alter Table ... Move and Alter Index ...
Rebulid to move the table into differenct block and
then rebuild index.  Table Move works fine, but after
index rebuilt, some indices disappeared! How come?

Thanks!

Andrea

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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: Apologies... linux & Oracle

[Christopher Spence]

Anyone have luck with 9i on RedHat?  I am sure the answer is yes as people
has mentioned trying.
Do they have it documented what is needed to be done to accomplish this?

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Lora, lisa, what ever...
Oracle only supports SUSE 7.1 for Oracle 9i.
 I use RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.
Works great but not supported. SCO was bought out by RedHat a while back I
believe. ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 11:50AM >>>
Sorry everyone, I know you were just discussing this recently.  

What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  

Thank you

Lara Croft
Oracle Database Administrator 
Fairfield Resorts, Inc




-- 
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  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: Apologies... linux & Oracle

[Ron Rogers]

Lora, lisa, what ever...
Oracle only supports SUSE 7.1 for Oracle 9i.
 I use RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards. Works great 
but not supported. SCO was bought out by RedHat a while back I believe.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 11:50AM >>>
Sorry everyone, I know you were just discussing this recently.  

What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  

Thank you

Lara Croft
Oracle Database Administrator 
Fairfield Resorts, Inc




--
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: WARNING: CURSOR_SHARING=FORCE on 8.1.7

[Jay Mehta]

Although it works for me under Oracle 8.1.7.1.4 on Win/2K as shown below, I
do have doubts about CURSOR_SHARING=FORCE. When I had experimented couple of
months ago, Oracle didn't substitute bind variables for all literals values,
and that wasn't going to help us. So we couldn't use this feature.

Jay


ORADB SQL>CREATE TABLE REJ_TEST ( 
  2ACCESSCONTROLID  NUMBER (10)   NOT NULL, 
  3RESOURCE_NAMEVARCHAR2 (10)  NOT NULL, 
  4ACTION   VARCHAR2 (10)  NOT NULL, 
  5ISALLOWEDNUMBER (5)NOT NULL, 
  6PARTYID  NUMBER (10)   NOT NULL, 
  7PTYPENUMBER (3)NOT NULL);

Table created.

ORADB SQL>
ORADB SQL>insert into rej_test
  2   values (23, 'ESR', 'upd1', -1, 60, 1);

1 row created.

ORADB SQL>insert into rej_test
  2   values (60, 'ESR', 'upd1', -1, 13, 2);

1 row created.

ORADB SQL>
ORADB SQL>analyze table rej_test compute statistics;

Table analyzed.

ORADB SQL>
ORADB SQL>REM SELECT 1
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4  (PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND
IsAllowed=-1
  5  AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>
ORADB SQL>ALTER SESSION SET CURSOR_SHARING=EXACT;

Session altered.

ORADB SQL>
ORADB SQL>REM SELECT 2
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1) OR
  5   (PartyID=13  AND IsAllowed=-1 AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>
ORADB SQL>ALTER SESSION SET CURSOR_SHARING=FORCE;

Session altered.

ORADB SQL>
ORADB SQL>REM SELECT 3
ORADB SQL>
ORADB SQL>SELECT Resource_Name, Action
  2  FROM rej_test 
  3  WHERE 
  4   (PartyID=60 AND IsAllowed=-1 AND PType=1)
  5  OR
  6  (PartyID=13  AND IsAllowed=-1 AND PType=2);

RESOURCE_N ACTION
-- --
ESRupd1
ESRupd1

2 rows selected.

ORADB SQL>


-Original Message-
Sent: Tuesday, August 21, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L


Eeeek!  It just keeps getting worse!  Can someone on 8.1.7.x on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system level try the
following test for me?

--

DROP TABLE REJ_TEST CASCADE CONSTRAINTS ; 

CREATE TABLE REJ_TEST ( 
  ACCESSCONTROLID  NUMBER (10)   NOT NULL, 
  RESOURCE_NAMEVARCHAR2 (10)  NOT NULL, 
  ACTION   VARCHAR2 (10)  NOT NULL, 
  ISALLOWEDNUMBER (5)NOT NULL, 
  PARTYID  NUMBER (10)   NOT NULL, 
  PTYPENUMBER (3)NOT NULL);

insert into rej_test
values (23, 'ESR', 'upd1', -1, 60, 1);
insert into rej_test
values (60, 'ESR', 'upd1', -1, 13, 2);

analyze table rej_test compute statistics;

REM SELECT 1

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND IsAllowed=-1
AND PType=2);

ALTER SESSION SET CURSOR_SHARING=EXACT;

REM SELECT 2

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

ALTER SESSION SET CURSOR_SHARING=FORCE;

REM SELECT 3

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1)
OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

--

I've purposely formatted each SELECT a little differently in order to force
a hard parse.  The problem I'm seeing is that SELECT #1 and #3 *RETURN NO
ROWS*!  If #3's formatted to be just like #2, it works fine, which leads me
to believe the problem's in the parse.

TIA!

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


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



This electronic message contains information from CTIS, Inc., which 
may be company sensitive, proprietary, privileged or otherwise protected 
from disclosure. The information is intended to be used solely by the 
recipients named above. If you are not an intended recipient, be aware 
that any review, disclosure, copying, distribution or use of this 
transmission or its contents is prohibited.

RE: No errors showed in the DBA Studio

[Boivin, Patrice J]

Likewise, I always believed that if you had to use DOS, then you have a
better understanding of how Windows operates, because it has to go through
DOS to reach the hardware.

Assembly language is useful too, if you like headaches.

Another reason to learn the command line is that GUI tools very rarely
include all the options, you usually have more flexibility when using
commands than when using the GUI.  The GUI is useful for doing simple,
standardized tasks like creating one or two user accounts at a time.

e.g. when you install 8.1.7, you can't tell Oracle to use local
administration of the tablespaces.  You have to go in after the
installation, delete all those tablespaces, and re-create them manually...
using another GUI tool (DBA Studio)!  When both tools should be able to do
the same work.

Also, let's say Oracle decides they don't like a tool, and they drop it
altogether, and come up with a different GUI.  What will you do then?  You
have to learn a "new" application, and if you don't understand what is
happening underneath, you won't be able to adapt as easily.

The GUI tools are not consistent either, some use the .ora file extension
for datafiles, others use .dbf.  It seems to change from version to version.
I am also not clear on how the tools user small case vs. capital letters
when creating datafiles on case-sensitive OSes.  You have to be careful with
these tools.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 2:08 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: No errors showed in the DBA Studio

I'm not morally opposed to GUI tools... and using them doesn't make
you a 
bad DBA. But I really think that you (generic you) need to
understand what 
the tool is doing, so that if you end up somewhere that doesn't have
and 
won't buy the tool, you can still do your job.



>From: Beatriz Martínez Jiménez <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: No errors showed in the DBA Studio
>Date: Tue, 21 Aug 2001 08:01:20 -0800
>
>A lot of thanks Rachel,
>it helps me a lot, although I would prefer to use a GUI tool
(despite of 
>looking  like a
>bad DBA).
>Thank you,
>
>Rachel Carmichael wrote:
>
> > Here's a radical thought. You could actually go into sqlplus and
do a 
>select
> > from the dba_errors or user_errors view. I realize that this is
will 
>cause
> > many on this list to think of me as a dinosaur, ready to be
relegated to 
>the
> > old DBAs home, but come on, if you are going to call yourself a
DBA you
> > should be able to look things up in the database WITHOUT a GUI
tool.
> >
> > I'll even be nice and give you the query:
> >
> > log into sqlplus as the procedure owner
> >
> > select * from user_errors order by line;
> >
> > here's an example:
> >
> > SQL> create procedure this_is_bad
> >   2  as
> >   3select * from dual
> >   4  end;
> >   5
> >   5
> >   5  /
> >
> > Warning: Procedure created with compilation errors.
> >
> > SQL> select * from user_errors order by line;
> >
> > NAME TYPE  SEQUENCE

>LINE
> > POSITION
> >   - 
>-
> > -
> > TEXT
> > 

>---

> > THIS_IS_BAD  PROCEDURE1

>3
> >   3
> > PLS-00103: Encountered the symbol "SELECT" when expecting one of
the
> > following:
> >
> >begin function package pragma procedure subtype type use
> >  cursor
> >form current external language
> > The symbol "begin" was substituted for "SELECT" to continue.
> >
> > THIS_IS_BAD  PROCEDURE2

>4
> >   1
> > PLS-00103: Encountered the symbol "END" when expecting one of
the 
>following:
> >
> >. , @ ; for 
> > group having intersect
> >minus orde

Re: Performance analysis (enqueue and buffer busy waits)

[Jonathan Lewis]

Does that mean you think it is impossible
to have rollback segments that are too big ?

Jonathan Lewis

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

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 20 August 2001 21:54


|Increase the "snapshot too old" query mortality rate?
|
|> -Original Message-
|> From: Babette Turner-Underwood
[mailto:[EMAIL PROTECTED]]
|> Sent: Monday, August 20, 2001 9:22 AM
|> To: Multiple recipients of list ORACLE-L
|> Subject: RE: Performance analysis (enqueue and buffer busy waits)
|>
|>
|> I am curious.
|> What are you trying to accomplish by
|> decreasing rollback segment size??
|>
|> - Babette


-- 
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: How do they get the answer?

[Stephen Andert]

Well, 
 
to me it looks like 
    WHERE        subject_id IN 
(102, 105);will select 2 classes. Since there are a minimum of 2 teachers 
per class, this will select at least 4 teachers.  
 
Am I missing something?
 
Stephen>>> [EMAIL PROTECTED] 08/21/01 09:25AM 
>>>I am taking the Self-Test software test for the SQL exam and 
don't see how they get the answer to this problem.  They don't explain 
how it is arrived at.Any help you can give me will be 
appreciated.Thanks,Ken Janusz, 
CPIM--Examine the structure of 
the TEACHER table:Name        
        Null?        
TypeID            
    NOT NULL    
NUMBER(9)SALARY            
            
NUMBER(7,2)SUBJECT_ID        
    NOT NULL    
NUMBER(3)SUBJECT_DESCRIPTION        
    VARCHAR2(2)There are 200 teachers and 15 
subjects.  Each subject is taughtby at least 2 
teachers.Evaluate this PL/SQL 
block:DECLARE    v_pct_raise    
    number := 1.10;BEGIN    
UPDATE        teacher    
SET        salary = salary * 
1.10    WHERE        subject_id 
IN (102, 105);    COMMIT;END;Which result will 
the PL/SQL block provide?(A) Only two teachers will receive a 10% salary 
increase.(B) All of the teachers will receive a 10% salary 
increase.(C) At least four teachers will receive a 10% salary 
increase.(D) A syntax error will occur.Answer:(C) 
-- 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-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: User access within/outside of app

[Jon Walthour]

Create another user with select privileges only on the objects in the app's schema. 
Give that one to them and then change the password on the original app id so they 
won't be able to use that one anymore.

Jon Walthour
> 
> From: Larry Hahn <[EMAIL PROTECTED]>
> Date: 2001/08/21 Tue AM 11:21:04 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: User access within/outside of app
> 
> List,
> 
> We have purchased a system where users login through
> an ODBC connection using a generic Oracle userid. This
> userid has full rights to do insert, update, delete,
> select on any table in the schema. The app asks for
> another username and password which checks the
> application security table, which limits what areas of
> the apps they can access. 
> 
> Although this may work fine for the app, the users
> also have the ability to use Access and other ODBC
> compliant programs to look at the data. When doing so,
> they use the same ODBC DSN and, what do you know, they
> have capabilities beyond their wildest imagination. 
> 
> This is obviously not a situation I want to implement.
> I am looking for a way to allow a user into the app to
> do their normal work, but only allow read access for
> anything outside the app. 
> 
> Any suggestions or ideas would be more than welcome.
> 
> Thanks,
> 
> Larry Hahn
> Journal Sentinel, Inc. 
> 
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Larry Hahn
>   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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

DB2 Question

[kjanusz]

Does DB2 store data as EBCDIC or ASCII?

Thanks,
Ken Janusz, CPIM
-- 
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: linux & Oracle -- best combination

[Daniel Curry]

Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an
ISO 9002 compliance to maintain as I provided testing and supporting
data to our clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to
the full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less
satisfactory performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1
and another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the
best I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


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: Daniel Curry
  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: Apologies... linux & Oracle

[Ed . Haskins]

Title: Apologies... linux & Oracle



SCO 
makes a version of Linux now?  
 
Ed

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 
  11:51 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Apologies... linux & Oracle
  Sorry everyone, I know you were just discussing 
  this recently.  
  What is the most stable combination of Oracle & 
  Linux?  What would you recommend?  I want to say the consensus was 
  SCO Linux but I don't quite remember.  
  Thank you 
  Lara Croft Oracle Database Administrator Fairfield Resorts, Inc 

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

[Jesse, Rich]

Eeeek!  It just keeps getting worse!  Can someone on 8.1.7.x on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system level try the
following test for me?

--

DROP TABLE REJ_TEST CASCADE CONSTRAINTS ; 

CREATE TABLE REJ_TEST ( 
  ACCESSCONTROLID  NUMBER (10)   NOT NULL, 
  RESOURCE_NAMEVARCHAR2 (10)  NOT NULL, 
  ACTION   VARCHAR2 (10)  NOT NULL, 
  ISALLOWEDNUMBER (5)NOT NULL, 
  PARTYID  NUMBER (10)   NOT NULL, 
  PTYPENUMBER (3)NOT NULL);

insert into rej_test
values (23, 'ESR', 'upd1', -1, 60, 1);
insert into rej_test
values (60, 'ESR', 'upd1', -1, 13, 2);

analyze table rej_test compute statistics;

REM SELECT 1

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND IsAllowed=-1
AND PType=2);

ALTER SESSION SET CURSOR_SHARING=EXACT;

REM SELECT 2

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

ALTER SESSION SET CURSOR_SHARING=FORCE;

REM SELECT 3

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1)
OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

--

I've purposely formatted each SELECT a little differently in order to force
a hard parse.  The problem I'm seeing is that SELECT #1 and #3 *RETURN NO
ROWS*!  If #3's formatted to be just like #2, it works fine, which leads me
to believe the problem's in the parse.

TIA!

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


-- 
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: How do they get the answer?

[Jon Walthour]

in the where clause, the IN says "any teachers that are in any of these subjects. 
Since there are two subjects in the IN set and at least 2 teachers have to teach each 
subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise.

Jon Walthour
> 
> From: [EMAIL PROTECTED]
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How do they get the answer?
> 
> I am taking the Self-Test software test for the SQL exam 
> and don't see how they get the answer to this problem.  
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
> Name  Null?   Type
> IDNOT NULLNUMBER(9)
> SALARYNUMBER
> (7,2)
> SUBJECT_IDNOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION   VARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
>   v_pct_raise number := 1.10;
> BEGIN
>   UPDATE  teacher
>   SET salary = salary * 1.10
>   WHERE   subject_id IN (102, 105);
>   COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
> 
> 
> -- 
> 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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: What is in archive log...

[Rachel Carmichael]

what version of Oracle? but yes, read the manuals on logminer



>From: "Aldi Barco" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: What is in archive log...
>Date: Tue, 21 Aug 2001 07:41:32 -0800
>
>Hi Lister,
>
>Can we read what activities are in archive log files ?
>(utility like 'tkprof' to read trace file).
>Tia.
>
>Aldi
>
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Aldi Barco
>  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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Nolog writes log ?

[Ron Rogers]

Aldi,
How did you create a table as NOLOGGING. The fine manual states that you can use 
nologging only on a table created with the select as clause. The fine manual also 
states that you can create a table based on a query without generating redo log 
entries. Keep in mind that in the event of a failure/recovery action before you do a 
backup the new table will not be recovered.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 11:21AM >>>
Hi,
I have Emp table NOLOGGING.
Does it write to log files the insert,update,delete activity on that table ?
Tia

Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Aldi Barco
  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: High DML Table - Suggestions??

[CC Harvest]

I have a big table too, about 16GB.
It is a vert static one(customer table), will add data

once in it, but queried all the time, and do the
segmentations against it all the time.

It also has 12 indexes. Right now , the performance is
ok. Any special consideration for such a big table.

Thanks,

Harvest.

--- Christian Trassens <[EMAIL PROTECTED]> wrote:
> Don't put it in a buffer keep because of the amount
> of
> consistent gets the table could have. It seems to be
> a
> high volatile table.
> 
> Maybe it is too late but you should look on the
> initrans, freelist of the table. Also if the table
> has
> foreign keys, talk with Development to leave the
> table
> without them. I should consider to partition the
> tablemaybe a hash one.
> 
> Regards.
> 
> 
> --- Walter K <[EMAIL PROTECTED]> wrote:
> > Hi,
> > 
> > I have a table that is going to have a large
> amount
> > of
> > inserts, updates and deletes performed against it
> > daily. Approximately 1,000,000 transactions per
> day
> > (some single-record, some multi-record). The table
> > is
> > ~100Mb in size.
> > 
> > I'm looking for some suggestions on what I can do
> to
> > have the most optimal I/O for the table. I've been
> > doing a little reading about buffer pools. Is
> > assigning this table to a KEEP pool a practical
> > approach or is that not going to buy me anything
> > because DML is involved? Does anyone have any
> other
> > suggestions?
> > 
> > Unfortunately, I can't put the table on a
> dedicated
> > disk and I am stuck with Raid-5 currently.
> > 
> > Any suggestions would be appreciated.
> > 
> > Thanks in advance!
> > -w
> > 
> > __
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> > with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > -- 
> > 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).
> 
> 
> =
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : 541149816062
> 
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Christian Trassens
>   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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  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 do they get the answer?

[Deshpande, Kirti]

>> Each subject is taught by at least 2 teachers.
So, if 102 and 105 are the 2 subject-ids, then a total of at least 4
teachers will get selected for salary update. 
Correct ? 

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 11:26 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  How do they get the answer?
> 
> I am taking the Self-Test software test for the SQL exam 
> and don't see how they get the answer to this problem.  
> They don't explain how it is arrived at.
> 
> Any help you can give me will be appreciated.
> 
> Thanks,
> Ken Janusz, CPIM
> 
> --
> 
> Examine the structure of the TEACHER table:
> 
> Name  Null?   Type
> IDNOT NULLNUMBER(9)
> SALARYNUMBER
> (7,2)
> SUBJECT_IDNOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION   VARCHAR2(2)
> 
> There are 200 teachers and 15 subjects.  Each subject is 
> taught
> by at least 2 teachers.
> 
> Evaluate this PL/SQL block:
> 
> DECLARE
>   v_pct_raise number := 1.10;
> BEGIN
>   UPDATE  teacher
>   SET salary = salary * 1.10
>   WHERE   subject_id IN (102, 105);
>   COMMIT;
> END;
> 
> Which result will the PL/SQL block provide?
> 
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary 
> increase.
> (C) At least four teachers will receive a 10% salary 
> increase.
> (D) A syntax error will occur.
> 
> Answer:
> (C) 
> 
> 
> -- 
> 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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

9i Via Oracle 8 ODBC Drivers?

[Hal Hempe]

Greetings,

Current Client: NT Workstation 4.0, w/ Oracle 8.00.05.00 ODBC driver and

SQL*Plus Rel 8.0.5.0.0
Current DB Server: Oracle 8.0.6.0.0 EE for HP-UX 11.0

Will our current client config work with 9i databases?
If not, what driver, SQL*Plus client, or other config changes would be
required?

Thank you in advance,
Hal

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hal Hempe
  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: Freelist Contention

[Jared Still]

On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
> Bufer busy waits can also be caused by parallel query
> servers trying to read the same buffer block at the
> same time.

Just off the top of my head, and without giving it a lot
of thought, this doesn't sound right.

PQS divvy up the blocks to read, and should not be trying
to access the same block.

Got any documentation or evidence to back that up?

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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]: How do they get the answer?

[dgoulet]

I think someone had difficulties with word problems in Math class.  Gotcha
again!!

Dick Goulet

Reply Separator
Author: "Brian McGraw" <[EMAIL PROTECTED]>
Date:   8/21/2001 8:57 AM

I think you're being tricked by the question.

If each subject is taught by two or more teachers, and you're updating the
salaries of all teachers teaching two subjects, 2 x (2+?) >= 4

Brian

[EMAIL PROTECTED] wrote:

> I am taking the Self-Test software test for the SQL exam
> and don't see how they get the answer to this problem.
> They don't explain how it is arrived at.
>
> Any help you can give me will be appreciated.
>
> Thanks,
> Ken Janusz, CPIM
>
> --
>
> Examine the structure of the TEACHER table:
>
> NameNull?   Type
> ID  NOT NULLNUMBER(9)
> SALARY  NUMBER
> (7,2)
> SUBJECT_ID  NOT NULLNUMBER(3)
> SUBJECT_DESCRIPTION VARCHAR2(2)
>
> There are 200 teachers and 15 subjects.  Each subject is
> taught
> by at least 2 teachers.
>
> Evaluate this PL/SQL block:
>
> DECLARE
> v_pct_raise number := 1.10;
> BEGIN
> UPDATE  teacher
> SET salary = salary * 1.10
> WHERE   subject_id IN (102, 105);
> COMMIT;
> END;
>
> Which result will the PL/SQL block provide?
>
> (A) Only two teachers will receive a 10% salary increase.
> (B) All of the teachers will receive a 10% salary
> increase.
> (C) At least four teachers will receive a 10% salary
> increase.
> (D) A syntax error will occur.
>
> Answer:
> (C)
>
> --
> 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).

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  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: Apologies... linux & Oracle

[Ed . Haskins]

Title: Apologies... linux & Oracle



O.K...it looks like SCO was bought by Caldera, who 
sells a distribution of Linux under that name.
 
Ed
 

  -Original Message-From: Robertson Lee - lerobe 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 12:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Apologies... linux & Oracle
  Lisa
   
  SuSe 
  is the best so I have been told. I am about to install 8i on 7.1 and another 
  guy here is installing 9i on 7.2.
   
  Totally untested on my behalf as I haven't started 
  yet but that is the best I have been told.
   
  Probably of no use whatsoever !!!
   
  Lee
  
  
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: 21 August 2001 
16:51To: Multiple recipients of list ORACLE-LSubject: 
Apologies... linux & Oracle
Sorry everyone, I know you were just discussing 
this recently.  
What is the most stable combination of Oracle 
& Linux?  What would you recommend?  I want to say the 
consensus was SCO Linux but I don't quite remember.  
Thank you 
Lara Croft Oracle Database Administrator Fairfield Resorts, Inc The information contained in this communication 
  isconfidential, is intended only for the use of the recipientnamed 
  above, and may be legally privileged. If the reader of this message is not 
  the intended recipient, you arehereby notified that any dissemination, 
  distribution orcopying 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 computersystem.