[no subject]

2003-07-16 Thread Tom Pall



help


Re: RE: oracle or mssql

2002-11-01 Thread Tom Pall
y
> > the correct reads. Oracle method IS the dirty read.
> >
> > I am sure that your users does at least 1000 commits to every rollback.
> > So when oracle gives you the data it already knows that this data is
> > wrong. If you do the query again a minute later you will get new results
> > that were available when you did the original query but were committed
> > later. So you get a 1000/1 chance to get incorrect data.
> >
> > The "dirty read" method, on the other hand, gives you the current
values,
> > believing that they will be committed in a moment. So you get 1/1000
> > chance
> > to get wrong data.
> >
> > Which odds will you bet on?
> >
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Tuesday, October 29, 2002 2:18 PM
> >
> >
> > List,
> > I'm always keen to refresh on database comparisons so thanks for
> > everyone's pointers.
> >
> > I'm surprised Oracle doesn't make more of an issue about their locking
and
> > concurrency methods (i.e. redo/rollback/undo).
> >
> > MSSQL seems to deal with it in two ways:
> > Default: readers and writers prevent writers from accessing data until
> > they
> > are finished with it!
> > Other method: no control, you just get dirty reads!
> >
> > Anyone got anything to add to this? Or am I wrong?
> >
> > - Mike.
> >
> >
> > -Original Message-
> > Sent: 24 October 2002 17:29
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > As I said, use mssql ONLY if your boss is willing to be strapped into a
> > MicroSlop only platform.  If he's even remotely thinking of using a
> > different OS
> > then you can't use mssql.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: [EMAIL PROTECTED]
> > Date:   10/23/2002 11:48 PM
> >
> > goodmorning
> > everybody who responded to my basic question : thanks
> >
> > summary
> >
> > professional : use oracle enterprise edition
> > semi professional : use oracle standard edition / mssql enterprise
edition
> > in all other cases mssql standard edition
> >
> >
> >
> > > -Oorspronkelijk bericht-
> > > Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> > > Verzonden:woensdag 23 oktober 2002 20:51
> > > Aan:  Multiple recipients of list ORACLE-L
> > > Onderwerp:RE: oracle or mssql
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jenner Mike
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> 
> > Live Life in Broadband
> > www.telewest.co.uk
> >
> >
> > The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.
> > Statements and opinions expressed in this e-mail may not represent those
> of the company. Any review, retransmission, dissemination or other use of,
> or taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender immediately and delete the
material
> from any computer.
> >
> >
> >
>

> ==
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Adrian Roe
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE

Re: Convert DM TSP to LM TSP w/ lots of data

2002-10-30 Thread Tom Pall
L PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: What's your opinion: ALL_ROWS vs FIRST_ROWS

2002-10-30 Thread Tom Pall
I guess that's why when I take a look at the initialization files of
databases in large shops where it's expected the DBAs know what they're
doing, by and large the databases are running in CHOOSE (all rows if there
are sufficient statistics) mode.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 11:19 AM


> We have an OLTP system that I thought will benefit from first rows.
> The sad fact is that when I set optimization to first rows the response
> sucks.
>
> Do some testing, as you can change this anytime.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, October 29, 2002 11:13 PM
>
>
> > We're moving from RBO to CBO.
> >
> > For those of you who use CBO, what mode do you use FIRST_ROWS or
ALL_ROWS?
> > And why?
> >
> > My thinking is if it's a database where most of the querying is done on
> > small sets of records, then we may want to use FIRST_ROWS. On the other
> > hand, if our database is used to generate sizable reports, we might use
> > ALL_ROWS.
> >
> > I also understand that we can always change it per session (with alter
> > session) and per query (with hints).
> >
> > Michael Armstead
> > Principal Database Administrator, OCP-Certified
> > World Wide Corporate IT Database Administration
> > GlaxoSmithKline
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Armstead, Michael A
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Mixing OLTP with DSS

2002-10-29 Thread Tom Pall



Oracle 8i uses a different aging algorithm than 
before.  It waits for blocks to be accessed several times before 
considering keeping them around.  That way the full scan of a big table 
won't push other tables out.  If aging becomes a problem, remember you can 
now size a keep and recycle buffer pool (The names only suggest the buffers' 
intended purposes.  Each follows the same aging algorithm.) and can alter 
table/index/partition to assign it a new buffer cache online.
 
If the data OLTP and DSS don't have to be accessed 
in the same query, it makes sense to create a new database to contain the OLTP 
data.  Not only will the caches be separate, their rollback, redo and 
process will be separate as well.  Plus, you'll be able to backup or take 
one down without bothering the other one.   If the data has to be 
accessed together, you'll have to weigh the impact using database links in with 
the other pros and cons of creating a separate database.
 
- Original Message - 

  From: 
  Rick 
  Stephenson 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, October 29, 2002 12:19 
  PM
  Subject: Mixing OLTP with DSS
  
  
  Am I looking for trouble by mixing 
  an OLTP type database with a DSS type database?
   
  I currently have a relatively 
  small database that is used for quick lookup type actions.  The company 
  wants to add a much bigger and constantly growing application for historical 
  reporting on the same machine.  Should I create another instance or keep 
  it in the same instance?
   
  Keeping it in the same instance 
  would seem to defeat having anything cached seeing that the large reports will 
  flush out the cache each and every time.
   
  I am running Oracle 8.1.7, on 
  Solaris 2.8.
   
  Any suggestions would be 
  helpful.
   
  Thanks,
   
  Rick Stephenson
   


Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Software Raid

2002-10-29 Thread Tom Pall



Ah yes.  
The eternal argument between the DBA, who likes things separate,and the SA, 
who likes big smears (But it's mirrored!).- Original Message 
-From: <[EMAIL PROTECTED]>To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>Sent: Tuesday, October 29, 2002 3:43 PMSubject: Re: 1 Volume 
of Software RAID 1+0 versus Multiple Volumes ofSoftware Raid> 
I would go with 3 RAID 1's given the choice.>> Not necessarily for 
performance though.>> This would allow you to have 3 control files 
on separate drives.>> It would also allow soft mirroring of the 
redo logs.>> And before someone jumps in with "But you don't 
need> to mirror them on RAID 1", I *like* having them in 2 
locations.  :)>> As for performance, it is nice to separate 
the redo as much as possible.>>> 
Jared>>> "VIVEK_SHARMA" 
<[EMAIL PROTECTED]>> Sent by: [EMAIL PROTECTED]>  07/11/2002 06:43 AM>  Please respond to 
ORACLE-L>>> 
To: Multiple recipients of list 
ORACLE-L<[EMAIL PROTECTED]>> 
cc:> 
Subject:    1 Volume of Software RAID 
1+0  versus MultipleVolumes of Software Raid 1> 
? For performance , Which Option is better 
:->> Given 6 Internal FCAL Hard Disks ?> 1) Creating 1 
Volume with Software RAID 1+0 OR> 2) Creating 3 Volumes of Software RAID 
1 , Each Volume Containing 2 Disks> & Manually Spreading the 
Database> across the 3 Volumes ?>> Solaris 8> 
Machine V880 model>> --> Please see the official ORACLE-L 
FAQ: http://www.orafaq.com> --> Author: VIVEK_SHARMA>   INET: [EMAIL PROTECTED]>> Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051> San Diego, 
California    -- Public Internet access / 
Mailing Lists> 
> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in> the message BODY, include a line 
containing: UNSUB ORACLE-L> (or the name of mailing list you want to be 
removed from).  You may> also send the HELP command for other 
information (like subscribing). --> 
Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author:>   INET: [EMAIL PROTECTED]>> Fat City Network Services    -- 858-538-5051 
http://www.fatcity.com> San Diego, California    -- 
Mailing list and web hosting services> 
-> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in> the message BODY, include a line 
containing: UNSUB ORACLE-L> (or the name of mailing list you want to be 
removed from).  You may> also send the HELP command for other 
information (like subscribing).


Re: Convert DM TSP to LM TSP w/ lots of data

2002-10-29 Thread Tom Pall
retted it.  I've not done a rigorous
benchmark but can tell you from casual observation dropping an object
with
lots of extents doesn't happen in the blink of an eye but doesn't lock
out
all other space allocation as UET/FET weren't constantly in use and the
ST
enque wasn't locked for exclusive use.

It's prudent to follow Oracle's recommendations if conditions permit.
Create a new LMT and move your data to it.

- Original Message -
To: Multiple  <mailto:ORACLE-L@;fatcity.com> recipients of list ORACLE-L
Sent: Monday, October 28, 2002 8:43 PM

I am reposting this. Has anyone tried to convert a dictionary managed
table
space containing lots of data to locally managed? We have tried this out
successfully on empty table spaces or created a new LMT tablespace and
moved
the existing objects to it.

Thanks,
Govind

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: RE: oracle or mssql

2002-10-29 Thread Tom Pall
 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle Internals course

2002-10-29 Thread Tom Pall
Title: Message



Oracle didn't start offering instruction directly 
at your desktop or urge you to open up an iTAR instead of talking to a Customer 
Service person for nothing.  People are expensive.

  - Original Message - 
  From: 
  Bob 
  Metelsky 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, October 29, 2002 8:33 
  AM
  Subject: RE: Oracle Internals 
course
  
  It 
  is just me or does 500-2000 per day seem a little "steep"? 

   
  
  Oracle8i: Everything You Always Wanted to Know 
  about the Optimizer 
  


  
  
Instructor-Led 
  inClass
  
US$ 500
  
1 Day 
  
English
  
English 

   
  OR
   
  INTRODUCTION TO ORACLE9I: SQL (ILT)  BLOOMFIELD, CT  
  02-DEC-02  US$2000   Remove from Shopping Cart   
   INTRODUCTION TO ORACLE 8I: SQL AND PL/SQL (ILT) 
   BLOOMFIELD, CT  17-FEB-03  US$2000   Remove from 
  Shopping Cart    ADVANCED PL/SQL (ILT) 
   BLOOMFIELD, CT  07-NOV-02  US$1000   Remove from 
  Shopping Cart 
   
   
   
   


Re: List of Rows Updated

2002-10-29 Thread Tom Pall
Title: RE: List of Rows Updated



Gosh.  I wish I worked in your shop.  I'm 
typically asked to produce an audit report for yesterday on a table I didn't 
even know existed.  "What do you mean you can't do that?  Aren't you 
an Oracle DBA?"

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, October 29, 2002 5:58 
  AM
  Subject: RE: List of Rows Updated
  
  Auditing is much simpler and usable than logminer for *this 
  purpose*. 
  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- From: Tom 
  Pall [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated 
  Logminer comes to mind. - Original 
  Message - To: "Multiple recipients of list 
  ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, 
  October 28, 2002 10:23 PM 
  > Hi, >  I want to get the list of rows which 
  were updated(then commited) in a > particular table 
  say X on a specific date e.g yesterday. > Is this 
  possible and how ? > > 
  Thanks > Manoj. 



Re: Oracle Internals course

2002-10-29 Thread Tom Pall
No.  Scott said he's been to a number of Pacific Ocean countries to teach
the course.  I suspect those courses where hosted by a company which had
offered enough internal enrollment.  As I recall, there's another instructor
who also teaches the Internals, Crashes/Dump/Traces and Backup/Recovery
seminars.  Be careful of all Oracle courses.  Some of them are subcontracted
out.  I don't warn you to put down consultants.  But this thread has been
about Scott and his internals course.  Scott's the star.

If you really want to make sure Scott's going to teach your course, phone
him up or drop him an email.  Don't expect him to respond the same day you
try to contact him.  When he's teaching, he's tied up through lunch and
dinner and sometimes even on the ride to the airport.  Many people go to the
course with specific questions they want answered.  Scott often handles
those during out of class hours.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 5:58 AM


Are these Internals classes only available in the US?

 -Original Message-
Carmichael
Sent: 29 October 2002 11:04
To: Multiple recipients of list ORACLE-L

Tom,

I didn't mean to imply that you were going into damagement!

I was lucky enough to have someone point me to "seminars" and figured
I'd share my luck.

I think the reason they don't publicize it is that he is the only one
teaching it and it's full without publicizing. Can you imagine if they
made it generally available? He'd have time to do nothing else!

Rachel

--- Tom Pall <[EMAIL PROTECTED]> wrote:
> Rachel, I'm not bucking for a management slot by being clueless about
> the
> details.  Really I'm not.  I registered online for the internals
> course by
> searching for it.  I just kind of assumed from what Scott said that I
> just
> managed to luck out when I searched for the course and found it.  I
> mistakenly assumed the course was quietly being removed from online
> registration after hearing Scott's statements about hiding and not
> publicizing the course.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, October 28, 2002 8:58 PM
>
>
> > I registered for it online, at education.oracle.com
> >
> > you have to search on seminars, not classes. It's difficult to
> find,
> > but it IS there
> >
> >
> > --- Tom Pall <[EMAIL PROTECTED]> wrote:
> > > RE: Oracle Internals courseThat rumor's been going on for
> versions
> > > now.  As has been Scott's desire to offer a two week internals
> > > course.  Course participants would sign all sorts of
> non-disclosure
> > > forms then get a scaled down version of what's taught to Customer
> > > Support. Wait a minute! Customer Support takes these courses?
> Surely
> > > not all the Silver Support people I've called.  A difficulty with
> a
> > > two week course is that the very DBAs most likely to benefit from
> the
> > > course are the ones least likely to be let free for two weeks.
> > >
> > > The internals course is slated to be yanked every time a new
> version
> > > of Oracle comes out.  Why teach internals when there are no
> > > initialization parameters and the database maintains and tunes
> > > itself?  There's been an economic downturn and Oracle DBAs have
> lost
> > > their jobs.  But anybody know an Oracle DBA who lost his job
> because
> > > a later version doesn't require a DBA?  Oracle on CDs 1,2 and 3,
> huh?
> > >  I think if I dig enough I can find that old version of Oracle I
> had
> > > that came on a single diskette.
> > >
> > > Scott says the internals course is purposely hidden.  You have to
> > > call Oracle directly and ask for it.  A number of people
> registered
> > > for the course from the paper or online catalogs, showed up then
> > > complained that they weren't about to get anything out of the
> > > course..
> > >   - Original Message -
> > >   From: Nick Wagner
> > >   To: Multiple recipients of list ORACLE-L
> > >   Sent: Monday, October 28, 2002 3:23 PM
> > >   Subject: RE: Oracle Internals course
> > >
> > >
> > >   rumor has it that this course is not going to be
> offered/modified
> > > for the 9.2 release of Oracle.  Can anyone confirm or deny it?
> > >
> > >   Nick
> > >
> > >   p.s. Had a close friend take this class, and they also came
> back
&g

Re: List of Rows Updated

2002-10-28 Thread Tom Pall
Logminer comes to mind.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 10:23 PM


> Hi,
>  I want to get the list of rows which were updated(then commited) in a
> particular table say X on a specific date e.g yesterday.
> Is this possible and how ?
>
> Thanks
> Manoj.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Convert DM TSP to LM TSP w/ lots of data

2002-10-28 Thread Tom Pall



I tried having Oracle convert DMT to 
LMT out a few times on 10 GB tablespaces.  Whether or not that's a lot 
of data depends on you.  Worked like a champ.  And this was in the 
early days of LMT.  People who pay a lot of attention to the internals will 
warn you that converting a DMT to LMT is not optimal.  Your bitmaps wind up 
at the end of the files instead of the headers.
 
I've read posts here and elsewhere where 
people worried about the same issues as they did with DMT.  They wanted to 
limit the number of extents segments grew to by creating tablespaces with 
different sized fixed extents.  A DBA I worked with pointed out how very 
easy and quickly things worked with letting Oracle automatically size the next 
extent.  I've gone that way whenever possible and have never regretted 
it.  I've not done a rigorous benchmark but can tell you from casual 
observation dropping an object with lots of extents doesn't happen in the 
blink of an eye but doesn't lock out all other space allocation as 
UET/FET weren't constantly in use and the ST enque wasn't locked for 
exclusive use.
 
It's prudent to follow Oracle's recommendations if 
conditions permit.  Create a new LMT and move your data to it.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, October 28, 2002 8:43 
  PM
  Subject: Convert DM TSP to LM TSP w/ lots 
  of data
  
  I am reposting this. 
  Has anyone tried to convert a dictionary managed 
  table space containing lots of data to locally managed? We have tried 
  this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects 
  to it. 
  
  
   
  Thanks, 
  
  Govind


Re: Oracle Internals course

2002-10-28 Thread Tom Pall
Rachel, I'm not bucking for a management slot by being clueless about the
details.  Really I'm not.  I registered online for the internals course by
searching for it.  I just kind of assumed from what Scott said that I just
managed to luck out when I searched for the course and found it.  I
mistakenly assumed the course was quietly being removed from online
registration after hearing Scott's statements about hiding and not
publicizing the course.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 8:58 PM


> I registered for it online, at education.oracle.com
>
> you have to search on seminars, not classes. It's difficult to find,
> but it IS there
>
>
> --- Tom Pall <[EMAIL PROTECTED]> wrote:
> > RE: Oracle Internals courseThat rumor's been going on for versions
> > now.  As has been Scott's desire to offer a two week internals
> > course.  Course participants would sign all sorts of non-disclosure
> > forms then get a scaled down version of what's taught to Customer
> > Support. Wait a minute! Customer Support takes these courses?  Surely
> > not all the Silver Support people I've called.  A difficulty with a
> > two week course is that the very DBAs most likely to benefit from the
> > course are the ones least likely to be let free for two weeks.
> >
> > The internals course is slated to be yanked every time a new version
> > of Oracle comes out.  Why teach internals when there are no
> > initialization parameters and the database maintains and tunes
> > itself?  There's been an economic downturn and Oracle DBAs have lost
> > their jobs.  But anybody know an Oracle DBA who lost his job because
> > a later version doesn't require a DBA?  Oracle on CDs 1,2 and 3, huh?
> >  I think if I dig enough I can find that old version of Oracle I had
> > that came on a single diskette.
> >
> > Scott says the internals course is purposely hidden.  You have to
> > call Oracle directly and ask for it.  A number of people registered
> > for the course from the paper or online catalogs, showed up then
> > complained that they weren't about to get anything out of the
> > course..
> >   - Original Message -
> >   From: Nick Wagner
> >   To: Multiple recipients of list ORACLE-L
> >   Sent: Monday, October 28, 2002 3:23 PM
> >   Subject: RE: Oracle Internals course
> >
> >
> >   rumor has it that this course is not going to be offered/modified
> > for the 9.2 release of Oracle.  Can anyone confirm or deny it?
> >
> >   Nick
> >
> >   p.s. Had a close friend take this class, and they also came back
> > extremely pleased with it.
> >
> >   -Original Message-
> >   From: Rachel Carmichael [mailto:wisernet100@;yahoo.com]
> >   Sent: Monday, October 28, 2002 12:19 PM
> >   To: Multiple recipients of list ORACLE-L
> >   Subject: Re: Oracle Internals course
> >
> >
> >
> >   Scott is the "instructors's instructor"
> >
> >   he learns the new features, then teaches them to the instructors so
> >
> >   they can teach them to you
> >
> >   I had the pleasure of taking those classes with Scott a few years
> > ago
> >   as well. He's a great teacher.
> >
> >   If he is ever presenting at any conference you go to, GO SEE HIM
> >
> >   --- Tom Pall <[EMAIL PROTECTED]> wrote:
> >   > I took that very course with Scott a few years ago.  Yup, Scott
> > flies
> >   > through the Internals and Dump/Traces courses with lots of extra
> >   > material to
> >   > spare.  It's really refreshing to hear him tell the class how the
> >
> >   > developers
> >   > documented something then tell how it's actually built.  He keeps
> > a
> >   > database
> >   > running in his notebook to prove what he says.  Scott's one great
> >
> >   > teacher.
> >   > - Original Message -
> >   > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> >
> >   > Sent: Monday, October 28, 2002 12:53 PM
> >   >
> >   >
> >   > I just wanted to say...
> >   >
> >   > If you have a chance to take the Oracle Internals course with
> > Scott
> >   > Gossett
> >   > at Oracle, I highly recommend it.
> >   >
> >   > I wish I knew half of what he knows!
> >   >
> >   > The course isn't included in the OCP tracks, I think i

Re: Oracle Internals course

2002-10-28 Thread Tom Pall
Title: RE: Oracle Internals course



Meaning you're not planning on letting your DBA go 
because Oracle now has now no initialization parameters to tweak (Wrong!), is 
self configuring, self maintaining, self tuning, self repairing?

  - Original Message - 
  From: 
  Khedr, 
  Waleed 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, October 28, 2002 6:58 
  PM
  Subject: RE: Oracle Internals 
course
  
  I 
  think the external visible Oracle stuff are enough to keep any DBA busy these 
  days:)
   
  
-Original Message-From: Tom Pall 
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 5:24 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Oracle Internals course
That rumor's been going on for versions 
now.  As has been Scott's desire to offer a two week internals 
course.  Course participants would sign all sorts of non-disclosure 
forms then get a scaled down version of what's taught to Customer Support. 
Wait a minute! Customer Support takes these courses?  Surely 
not all the Silver Support people I've called.  A difficulty with 
a two week course is that the very DBAs most likely to benefit from the 
course are the ones least likely to be let free for two weeks.
 
The internals course is slated to be yanked 
every time a new version of Oracle comes out.  Why teach internals when 
there are no initialization parameters and the database maintains and tunes 
itself?  There's been an economic downturn and Oracle DBAs have lost 
their jobs.  But anybody know an Oracle DBA who lost his job because a 
later version doesn't require a DBA?  Oracle on CDs 1,2 and 3, 
huh?  I think if I dig enough I can find that old version of Oracle I 
had that came on a single diskette.
 
Scott says the internals course is purposely 
hidden.  You have to call Oracle directly and ask for it.  A 
number of people registered for the course from the paper or online 
catalogs, showed up then complained that they weren't about to get anything 
out of the course..  

  - Original Message - 
  From: 
  Nick 
  Wagner 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, October 28, 2002 3:23 
  PM
  Subject: RE: Oracle Internals 
  course
  
  rumor has it that this course is not going to be 
  offered/modified for the 9.2 release of Oracle.  Can anyone confirm 
  or deny it?   
  Nick 
  p.s. Had a close friend take this class, and they also 
  came back extremely pleased with it. 
  -Original Message- From: 
  Rachel Carmichael [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course 
  Scott is the "instructors's instructor" 
  he learns the new features, then teaches them to the 
  instructors so they can teach them to you 
  
  I had the pleasure of taking those classes with Scott a 
  few years ago as well. He's a great 
  teacher. 
  If he is ever presenting at any conference you go to, GO 
  SEE HIM 
  --- Tom Pall <[EMAIL PROTECTED]> wrote: 
  > I took that very course with Scott a few years 
  ago.  Yup, Scott flies > through the 
  Internals and Dump/Traces courses with lots of extra > material to > spare.  It's 
  really refreshing to hear him tell the class how the > developers > documented something 
  then tell how it's actually built.  He keeps a > database > running in his notebook 
  to prove what he says.  Scott's one great > teacher. > - Original Message 
  - > To: "Multiple recipients of list 
  ORACLE-L" <[EMAIL PROTECTED]> > Sent: 
  Monday, October 28, 2002 12:53 PM > 
  > > I just wanted to 
  say... > > If you 
  have a chance to take the Oracle Internals course with Scott 
  > Gossett > at Oracle, I 
  highly recommend it. > > I wish I knew half of what he knows! > > The course isn't included in the 
  OCP tracks, I think it should be > given 
  a > higher profile though. > > 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] > > > -- > 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com &

Re: Oracle Internals course

2002-10-28 Thread Tom Pall
Title: RE: Oracle Internals course



That rumor's been going on for versions now.  
As has been Scott's desire to offer a two week internals course.  Course 
participants would sign all sorts of non-disclosure forms then get a scaled down 
version of what's taught to Customer Support. Wait a minute! Customer Support 
takes these courses?  Surely not all the Silver Support people I've 
called.  A difficulty with a two week course is that the very DBAs most 
likely to benefit from the course are the ones least likely to be let free for 
two weeks.
 
The internals course is slated to be yanked every 
time a new version of Oracle comes out.  Why teach internals when there are 
no initialization parameters and the database maintains and tunes itself?  
There's been an economic downturn and Oracle DBAs have lost their jobs.  
But anybody know an Oracle DBA who lost his job because a later version doesn't 
require a DBA?  Oracle on CDs 1,2 and 3, huh?  I think if I dig enough 
I can find that old version of Oracle I had that came on a single 
diskette.
 
Scott says the internals course is purposely 
hidden.  You have to call Oracle directly and ask for it.  A number of 
people registered for the course from the paper or online catalogs, showed up 
then complained that they weren't about to get anything out of the 
course..  

  - Original Message - 
  From: 
  Nick 
  Wagner 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, October 28, 2002 3:23 
  PM
  Subject: RE: Oracle Internals 
course
  
  rumor has it that this course is not going to be 
  offered/modified for the 9.2 release of Oracle.  Can anyone confirm or 
  deny it?   
  Nick 
  p.s. Had a close friend take this class, and they also came 
  back extremely pleased with it. 
  -Original Message- From: 
  Rachel Carmichael [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course 
  Scott is the "instructors's instructor" 
  he learns the new features, then teaches them to the 
  instructors so they can teach them to you 
  I had the pleasure of taking those classes with Scott a few 
  years ago as well. He's a great teacher. 
  If he is ever presenting at any conference you go to, GO SEE 
  HIM 
  --- Tom Pall <[EMAIL PROTECTED]> wrote: 
  > I took that very course with Scott a few years 
  ago.  Yup, Scott flies > through the Internals 
  and Dump/Traces courses with lots of extra > 
  material to > spare.  It's really refreshing 
  to hear him tell the class how the > 
  developers > documented something then tell how 
  it's actually built.  He keeps a > 
  database > running in his notebook to prove what he 
  says.  Scott's one great > teacher. 
  > - Original Message - > To: "Multiple recipients of list ORACLE-L" 
  <[EMAIL PROTECTED]> > Sent: Monday, 
  October 28, 2002 12:53 PM > > > I just wanted to say... 
  > > If you have a chance to 
  take the Oracle Internals course with Scott > 
  Gossett > at Oracle, I highly recommend it. 
  > > I wish I knew half of what 
  he knows! > > The course 
  isn't included in the OCP tracks, I think it should be > given a > higher profile though. 
  > > 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] > > > -- > 
  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 http://www.fatcity.com > San 
  Diego, California    -- Mailing list 
  and web hosting services > 
  - 
  > To REMOVE yourself from this mailing list, send an 
  E-Mail message > to: [EMAIL PROTECTED] (note 
  EXACT spelling of 'ListGuru') and in > the message 
  BODY, include a line containing: UNSUB ORACLE-L > 
  (or the name of mailing list you want to be removed from).  You 
  may > also send the HELP command for other 
  information (like subscribing). > > -- > Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com > -- 
  > Author: Tom Pall >   INET: [EMAIL PROTECTED] > 
  > Fat City Network Services    -- 
  858-538-5051 http://www.fatcity.com > San 
  Diego, California    -- Mailing list 
  and web hosting services > 
  - 
  > To REMO

Re: Location of Trace file

2002-10-28 Thread Tom Pall



Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the 
Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - 
Productionon Microsoft Window 2000 5.00.2195 Service Pack 3.I 
have no registry entry for a pfile or ifile.  Since I have no ifile, 
thequeryShow parameter ifilereturns a null 
string.oracle\ora92\database contains the file SPFILETOM.ORA (this is 
9i,remember).oracle\admin\tom\pfile contains 
init.ora.9212002185826.TOM is the database sid.It looks like the 
Oracle installer for 9i did away with the single linepfile it created in 
Oracle 8i.  It also looks like Oracle expects to findthe spfile 
ORACLE_HOME\database.  ORACLE_HOME is defined in the registry.- 
Original Message -From: "Yechiel Adar" <[EMAIL PROTECTED]>To: "Multiple 
recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Monday, 
October 28, 2002 12:25 PMSubject: Re: Location of Trace file> 
I just built a new database for 8.1.6 on win2000.> In 
oracle\ora81\database there is init.ora file for the 
database.> This file contains only 
ifile=\oracle\admin\\pfile\init.ora.>> But - 
The registery entry for pfile point directly to:> 
\oracle\admin\\pfile\init.ora>> so ifile 
value is empty.>> If you are on windows check that values in the 
registery for oracle home.> Look for name=ora__pfile. The 
value points to the pfile.>> Yechiel Adar> Mehish> 
- Original Message -> To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>> 
Sent: Saturday, October 26, 2002 5:43 PM>>> > My query 
was executed on an Oracle installed, Oracle created Oracle 9i> > 
version 2 database on Windows 2000.  Oracle really started following 
OFA> on> > Windows starting with version 8i.> > - 
Original Message -> > To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>> 
> Sent: Friday, October 25, 2002 1:04 PM> >> >> 
> >> > > If you follow OFA, it works for NT ;-)> > 
>> > >> > >> > >> > 
>> > 
> 
"Tom Pall"> > 
> 
<tpall@realti    
To: Multiple recipientsof> > list ORACLE-L 
<[EMAIL PROTECTED]>> 
> 
> 
me.net>  
cc:> > 
> 
Sent by: 
Subject: Re: Location of> > Trace file> 
> 
> 
root@fatcity.> > 
> 
com> > >> > >> > 
> 
October 25,> > 
> 
2002 12:58 PM> > 
> 
Please> > 
> 
respond to> > 
> 
ORACLE-L> > >> > >> > >> > 
>> > >> > >> > > Show parameter ifile 
shows the ifile address, not the pfile address.> > >> > 
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production> > 
> With the Partitioning, OLAP and Oracle Data Mining options> > 
> JServer Release 9.2.0.1.0 - Production> > >> > > 
SQL> show parameter ifile> > >> > > 
NAME 
TYPE    VALUE> > > 
 ---> > > 
---> > > ---> > > 
ifile> > > file> > >> > > SQL> show 
parameter background_dump_dest> > >> > > 
NAME 
TYPE    VALUE> > > 
 ---> > > 
---> > > ---> > > 
background_dump_dest 
string> C:\oracle\admin\tom\bdump> > > - Original 
Message -> > > To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>> 
> > Sent: Friday, October 25, 2002 4:12 AM> > >> > 
>> > > > Manoj,> > > >> > > > 
svrmgrl > show parameter ifile> > > >> > > > 
will give u the location of init.ora and> > > >> > 
> > svrmgrl > show parameter background_dump_dest> > > 
> svrmgrl > show parameter user_dump_dest> > > >> 
> > > will give u the location of alert and trace files 
respectively.> > > >> > > > HTH.> > 
> > Jp.> > >> > >> > > --> 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > > 
--> > > Author:> > >   INET: [EMAIL PROTECTED]> > 
>> > > Fat City Network Services    -- 
858-538-5051 http://www.fatcity.com> 
> > San Die

Re: Re:[Q] what kind of documents shoud contractor provide to m

2002-10-28 Thread Tom Pall
Do some checking.  These are typical deliverables.  The key is whether or
not the documentation is AS DESIGNED or AS DELIVERED.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 12:53 PM


> Only those listed as deliverables.  Now you should have listed a database
design
> document, data dictionary, users manuals, maintenance manuals, and
commented
> code.
>
> Dick Goulet
>
> Reply Separator
> Author: "dist cash" <[EMAIL PROTECTED]>
> Date:   10/28/2002 10:13 AM
>
>
>
> We have a application use ORACLE 8.1.6 and Forms 6i.  This project going
> to finish soon.  Can anyone tell me what kind of documents should
> contractor provide to us before they leave?
>
>
> Thanks.
>
>
>
>
>
> _
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: dist cash
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle Internals course

2002-10-28 Thread Tom Pall
I took that very course with Scott a few years ago.  Yup, Scott flies
through the Internals and Dump/Traces courses with lots of extra material to
spare.  It's really refreshing to hear him tell the class how the developers
documented something then tell how it's actually built.  He keeps a database
running in his notebook to prove what he says.  Scott's one great teacher.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 12:53 PM


I just wanted to say...

If you have a chance to take the Oracle Internals course with Scott Gossett
at Oracle, I highly recommend it.

I wish I knew half of what he knows!

The course isn't included in the OCP tracks, I think it should be given a
higher profile though.

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]


--
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: BUG 2632931 on 9.2.0.2

2002-10-28 Thread Tom Pall
Title: RE: BUG 2632931 on 9.2.0.2



"C" what side effects you have to consider when 
choosing a programming language?

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, October 28, 2002 12:38 
  PM
  Subject: RE: BUG 2632931 on 9.2.0.2
  
  What's new in Oracle processes leaking memory ...? Looks like 
  they shouldn't follow microslop in this regards at-least. 
  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- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, October 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: BUG 2632931 on 9.2.0.2 
  Excuse my French but that !!@@# -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, October 28, 2002 12:44 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: Re: BUG 2632931 on 9.2.0.2 
  native_threads process associated with 9.2.0 OEM OMS is 
  leaking memory. Process  starts out about 8  MB and keeps growing. 
  Up to  28.93 MB after less than 1 
  hour. 
  
  Workaround: None 


Re: Experience with Quest Shareplex

2002-10-28 Thread Tom Pall
I did some investigation into SharePlex a few years ago.  I tried for months
to get someone to respond to email and voicemail messages to the vendor that
"I want to buy SharePlex and I have the money".   Eventually I got the
software for evaluation.  I found once again that replication isn't easy, no
matter which approach or vendor you use.  My own playing around with
SharePlex, talks with noted Oracle book authors and email exchanges with
SharePlex users who responded to my query on this listserver privately honed
in on one problem:  getting synchronized and ready to start replicating.
SharePlex would synch up table after table, find one it couldn't synch up
and fail.

Like anything with Oracle, see if Oracle's solution fits your needs first.
It's nice only having to go to one vendor for support.  SharePlex costs a
lot of money.  Make sure you've got your requirements firm.  After all of my
investigating, the company I did the work for decided they could live with
reporting databases created by breaking a third mirror, exporting the
filesystems from the production box, importing them into the reporting box.
If you really need the capability of SharePlex, well, it does have a lot of
happy customers.  Be prepared, as they were, to spend lots of time getting
it right.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 10:13 AM


> Does anyone have experience with a product called Shareplex
> by Quest Software.  We have some remote access performance
> issues and my management is looking at this product
> as a possible solution for a distributed database.
>
> thanks,
> Peter Schauss
> Northrop Grumman Corporation
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schauss, Peter
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Location of Trace file

2002-10-26 Thread Tom Pall
My query was executed on an Oracle installed, Oracle created Oracle 9i
version 2 database on Windows 2000.  Oracle really started following OFA on
Windows starting with version 8i.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 1:04 PM


>
> If you follow OFA, it works for NT ;-)
>
>
>
>
>
> "Tom Pall"
> 
> me.net>  cc:
> Sent by: Subject: Re: Location of
Trace file
> root@fatcity.
> com
>
>
> October 25,
> 2002 12:58 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> Show parameter ifile shows the ifile address, not the pfile address.
>
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL> show parameter ifile
>
> NAME TYPEVALUE
>  ---
> ---
> ---
> ifile
> file
>
> SQL> show parameter background_dump_dest
>
> NAME TYPEVALUE
>  ---
> ---
> ---
> background_dump_dest string  C:\oracle\admin\tom\bdump
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, October 25, 2002 4:12 AM
>
>
> > Manoj,
> >
> > svrmgrl > show parameter ifile
> >
> > will give u the location of init.ora and
> >
> > svrmgrl > show parameter background_dump_dest
> > svrmgrl > show parameter user_dump_dest
> >
> > will give u the location of alert and trace files respectively.
> >
> > HTH.
> > Jp.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: SQL*Plus COPY error

2002-10-26 Thread Tom Pall
I've not seen this particular error.  Over the years I've found SQL*Plus
COPY to be buggy.  I just did a search on Metalink for "sqlplus copy error".
Your problem is not addressed directly, but other problems point to bugs in
the GUI version of SQL*PLUS.  Oracle's advice is to use the command line,
non-GUI version of SQL*Plus for COPY.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 12:54 PM


> I'm trying to use (for the first time in 15 years of Oracle
> experience!) SQL*Plus COPY, and am receiving the following
> incomprehensible error:
>
> SQL>  @odss/cmsr
>
> Array fetch/bind size is 100. (arraysize is 100)
> Will commit after every 10 array binds. (copycommit is 10)
> Maximum long size is 2. (long is 2)
>
> ERROR:
> ORA--3393898: Message -3393898 not found;  product=RDBMS; facility=ORA
>
> Anyone seen this or anything like it?  My environment is set up
> properly; i.e., errors returned by operations other than COPY display
> the way they're supposed to.
>
> TIA!
>
>
> __
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site
> http://webhosting.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Location of Trace file

2002-10-25 Thread Tom Pall
The most common reason is that you are not logged on the system as the user
and group that owns the $ORACLE_HOME/bin/oracle executable. You also need to
have ORACLE_HOME and ORACLE_SID set appropriately.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 4:43 AM


> Hi,
>when I connect to internal using svrmgrl,it asks for password.
> I do not know the password.
>
>
> Regards,
> Manoj.
>
> -Original Message-
> Sent: Friday, October 25, 2002 1:44 PM
> To: ORACLE-L
> Cc: oraoraora; Manoj, COSLTEMP-G
>
>
> Manoj,
>
> svrmgrl > show parameter ifile
>
> will give u the location of init.ora and
>
> svrmgrl > show parameter background_dump_dest
> svrmgrl > show parameter user_dump_dest
>
> will give u the location of alert and trace files respectively.
>
> HTH.
> Jp.
>
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Location of Trace file

2002-10-25 Thread Tom Pall
Show parameter ifile shows the ifile address, not the pfile address.

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> show parameter ifile

NAME TYPEVALUE
 --- ---
---
ifile
file

SQL> show parameter background_dump_dest

NAME TYPEVALUE
 --- ---
---
background_dump_dest string  C:\oracle\admin\tom\bdump
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 4:12 AM


> Manoj,
>
> svrmgrl > show parameter ifile
>
> will give u the location of init.ora and
>
> svrmgrl > show parameter background_dump_dest
> svrmgrl > show parameter user_dump_dest
>
> will give u the location of alert and trace files respectively.
>
> HTH.
> Jp.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Location of Trace file

2002-10-25 Thread Tom Pall
SQL> select name, value from v$parameter where name='user_dump_dest';

NAME VALUE
 --
user_dump_dest   C:\oracle\admin\tom\udump

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 3:08 AM


> Hi ,
> I want to know the location of trace file.I do not know location of
> init.ora.
> How to get it.
> 
> Thanks
> Manoj
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



[no subject]

2002-10-04 Thread Tom Pall

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: SYSTEM TABLESPACE IS SO HUGE ?

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

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

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

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



Sessions Hang When Not Being Traced/Unhang When Being Traced

2002-02-15 Thread Tom Pall



Anybody seen this before?
 
Running 8.1.5.0 on Solaris.  We have a third party 
product written in java which runs for a certain amount of time then 
hangs.  I don't see any locks or waits for the applications sessions.  
This does not happen if I put sql_trace=true in the init file and bounce the 
database.  I can unhang and hang the application sessions using ORADEBUG 
EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL whatever/ORADEBUG EVENT 10046 
TRACE NAME CONTEXT OFF.
 
I've searched Metalink's bug database and haven't found any 
bugs that apply yet.  
 


RE: Another NT question

2001-06-26 Thread Tom Pall

I believe Oracle on NT/Alpha has fewer bug reports against it than
Oracle on NT/Intel.

-Original Message-
Sent: Tuesday, June 26, 2001 5:12 PM
To: Multiple recipients of list ORACLE-L


Does it matter NT/Alpha or NT/Intel?

-Original Message-
Sent: Tuesday, June 26, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L


Anybody currently have more than 500 concurrent users on an NT box?
Just trying to validate a compaq claim that they can handle a large system.

-- 
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).
-- 
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: Tom Pall
  INET: [EMAIL PROTECTED]

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

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



RE: Another NT question

2001-06-26 Thread Tom Pall



-Original Message-
Sent: Tuesday, June 26, 2001 5:12 PM
To: Multiple recipients of list ORACLE-L


Does it matter NT/Alpha or NT/Intel?

-Original Message-
Sent: Tuesday, June 26, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L


Anybody currently have more than 500 concurrent users on an NT box?
Just trying to validate a compaq claim that they can handle a large system.

-- 
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).
-- 
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: Tom Pall
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 8.1.6 vs 8.1.7

2001-04-05 Thread Tom Pall (E-mail)

We're in the process of migrating all of our 8.0.5 to 8.1.6
databases over to 8.1.7.1.  We'll be done in a few weeks.
We used 8.1.7.0 on our reporting and other non-money making
databases since it was released.  The few cosmetic
issues we had with 8.1.7.0, like v$buffer_pool_statistics being broken,
appear fixed in 8.1.7.1.  8.1.7 fixed an almost endless number of
bugs we encountered in 8.1.5 and 8.1.6.

Sun/Sparc 2.7.

-Original Message-
Sanmarti
Sent: Thursday, April 05, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L



Hello,

I was wondering how stable the Oracle 8i release 3 is. We plan to move our
DB in production to the latest version.
Has anybody had problems migrating it? I was told by colleges that release 2
looks more stable than the other. How true is that?

Any comments ?

Thanks in advance,
Jordi

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall (E-mail)
  INET: [EMAIL PROTECTED]

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

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



What does _allow_read_only_corruption do?

2001-04-05 Thread Tom Pall (E-mail)

Yes,

I know it's a hidden parameter that should only be used at the advice
of counsel and Oracle Support.

But has anyone used it?  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall (E-mail)
  INET: [EMAIL PROTECTED]

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

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



SQLServer vs. Oracle Papers Needed

2001-04-02 Thread Tom Pall (E-mail)

I need pointers to papers/studies that compare and contrast
SQLServer vs. Oracle.  I'm specifically looking for studies
which appear impartial and conclude that Oracle is the better
choice.

Thanks in advance.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall (E-mail)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30

2001-02-12 Thread Tom Pall

Here's a quick excerpt while awaiting a fax number:

(page 44) "If v$sysstat shows a significant number of enqueue waits, then a break-
down of the resource types for which these waits have been sustained can
be obtained from x$ksqst, or from the APT script enqueue_stats.sql.
Unfortunately, x$ksqst does not contains (sic.) any indication of the duration
of the waits, so care is needed when interpreting these figures.

It is sometimes suggested that ENQUEUE_RESOURCES should be increased
to combat enqueue waits.  But please note that there is absolutely no
substance to this suggestion.  Oracle will return an ora-52 or Ora-53 error
if it fails to find a free slot in the enqueue resources or enqueue locks fixed
arrays respectively.  Beyond that, the setting of the ENQUEUE_RESOURCES
and _ENQUEUE_LOCKS parameters is unimportant.

(page 45)
The v$resource_limit view should be used to adjust your settings for
the ENQUEUE_RESOURCES and _ENQUEUE_LOCKS parameters to ensure
that you will not run out of slots in these arrays.  You can afford to be
generous, because slots in these arrays only take on the order of 72 bytes
and 60 bytes respectively.  I like to maintain headroom of at least 20%
above the maxiumu utilization ever recorded."

You probably want to go to the author's we site, which is http://www.ixora.com.au/
and send mail direct to the author, Steve Adams, at [EMAIL PROTECTED]

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


> I've continued to research this error and found several references on
> various search engines.  The most promising seems to point this book by
> O'Reilly "Oracle8i Internal Services for Waits, Latches, Locks, and Memory".
> There is a section (4.4, pg. 42) which talks about enqueue locks, but I
> cannot see the text.
> 
> If anyone has this book, could you give the above section a quick read and
> let us know what it says about enqueue locks and possible resource
> limits/settings for init params.
> 
> THANKS!
> 
> For Kenneth;  My version is; Oracle 8.1.6.0.0 and sun Solaris 2.6, as stated
> in my original post.
> 
> > -Original Message-
> > From: Glenn Travis [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 12, 2001 11:16 AM
> > To: Oracledba@Lazydba. Com; [EMAIL PROTECTED]
> > Subject: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
> >
> >
> > The system was not too busy.  Processes running were materialized view
> > refreshes (stored procs doing rollups, joins, etc...).  The
> > system was then
> > locked up.  Some queries could be run, others couldn't.  Refreshes never
> > completed.  I had to alter system kill to release the hang.
> >
> > Here are the errors:
> >
> > From the alert file;
> > WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
> >
> > From the udump dir;
> > *** SESSION ID:(37.4) 2001-02-11 22:55:18.638
> > >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<<
> > row cache enqueue: session: 8c184270, mode: N, request: X
> > row cache parent object: address=8ac94c10 type=8(dc_objects)
> > transaction=8c4b78e4 mode=X flags=002a
> > status=VALID/UPDATE/-/-/-/-/-/-
> > data=
> > ...
> > waiting for 'library cache lock' blocking sess=0x0 seq=8105 wait_time=0
> > handle address=8b27869c, lock address=8c629710,
> > 10*mode+namespace=15
> >
> > -
> > Metalink is pretty vague and not much help with this error (some
> > say it is a
> > VMS enqlm problem, others say it was a bug in v7 and early 8.0).  I am
> > running 8.1.6 on Solaris 2.6.
> >
> > As always, any insight would be greatly appreciated.
> >
> >
> > 
> > Think you know someone who can answer the above question? Forward
> > it to them!
> > to unsubscribe, send a blank email to [EMAIL PROTECTED]
> > to subscribe send a blank email to [EMAIL PROTECTED]
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >
> 
> -- 
> 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).  Yo

Re: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30

2001-02-12 Thread Tom Pall

Please send me ([EMAIL PROTECTED]) a fax number.  Too much to type in,
don't have ready access to a scanner.

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


> I've continued to research this error and found several references on
> various search engines.  The most promising seems to point this book by
> O'Reilly "Oracle8i Internal Services for Waits, Latches, Locks, and Memory".
> There is a section (4.4, pg. 42) which talks about enqueue locks, but I
> cannot see the text.
> 
> If anyone has this book, could you give the above section a quick read and
> let us know what it says about enqueue locks and possible resource
> limits/settings for init params.
> 
> THANKS!
> 
> For Kenneth;  My version is; Oracle 8.1.6.0.0 and sun Solaris 2.6, as stated
> in my original post.
> 
> > -Original Message-
> > From: Glenn Travis [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 12, 2001 11:16 AM
> > To: Oracledba@Lazydba. Com; [EMAIL PROTECTED]
> > Subject: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
> >
> >
> > The system was not too busy.  Processes running were materialized view
> > refreshes (stored procs doing rollups, joins, etc...).  The
> > system was then
> > locked up.  Some queries could be run, others couldn't.  Refreshes never
> > completed.  I had to alter system kill to release the hang.
> >
> > Here are the errors:
> >
> > From the alert file;
> > WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
> >
> > From the udump dir;
> > *** SESSION ID:(37.4) 2001-02-11 22:55:18.638
> > >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<<
> > row cache enqueue: session: 8c184270, mode: N, request: X
> > row cache parent object: address=8ac94c10 type=8(dc_objects)
> > transaction=8c4b78e4 mode=X flags=002a
> > status=VALID/UPDATE/-/-/-/-/-/-
> > data=
> > ...
> > waiting for 'library cache lock' blocking sess=0x0 seq=8105 wait_time=0
> > handle address=8b27869c, lock address=8c629710,
> > 10*mode+namespace=15
> >
> > -
> > Metalink is pretty vague and not much help with this error (some
> > say it is a
> > VMS enqlm problem, others say it was a bug in v7 and early 8.0).  I am
> > running 8.1.6 on Solaris 2.6.
> >
> > As always, any insight would be greatly appreciated.
> >
> >
> > 
> > Think you know someone who can answer the above question? Forward
> > it to them!
> > to unsubscribe, send a blank email to [EMAIL PROTECTED]
> > to subscribe send a blank email to [EMAIL PROTECTED]
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >
> 
> -- 
> 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: Tom Pall
  INET: [EMAIL PROTECTED]

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

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