RE: log checkpoint interval

[Suhen Pather]

Nixon,

It is based on your O/S block size.

If your O/S block size is 512 bytes then you would set the value
>4096 if want to chekpoint only at log switches for redo logs of size 2MB.

I think Windows NT block size is 512 bytes.

Regards
Suhen





Hi,

I would like to know how the value in the log_checkpoint_interval is
presented, is it in blocksize or is it based on other factor?
If I have 2MB redo log size, what could be the appropriate value of
log_checkpoint_interval.

Thanks in advance!

-- 
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: Suhen Pather
  INET: [EMAIL PROTECTED]

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

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

[Paul Drake]

http://www.oracle.com/education/oln/index.html?oln_learn9i.html
http://www.oracle.com/education/oln/index.html

something to fill up the cable modem pipe - that you don't have to be 18
to access.
I watched the 9i Database overview (while burning 9i 4 leenucks CDs)

- where did my rollback segments go? :)
- default temporary tablespace for the database (for all users to
inherit)
- dynamic memory management of the SGA and PGA.
If this means that after a query uses a hash join where it threw say 
8 MB of memory as hash_area_size - that this memory will be
released back
to the available pool - I'm psyched.
- NFS mounts for iFS.
- Timezone/Daylight Savings time functionality across time zones.
- Unicode 3.0
- LONG to LOB conversions (do not need to useexp/imp)
- External Tables - can use PL/SQL to MATCH rows on external files
(ETL).
- multi table inserts
- Upsert (insert/update) MERGE (yes, I'm lazy).
- cubes in the database - OLAP Server.

Yes, my time might have been better spent actually reading the 9i
Administration manual, but I just don't feel like reading right now.


>From the SuSE-Oracle list:

Michael Hasenstein wrote:
> 
> Gregor Schinke wrote:
> 
> > anyone of you knows, if Oracle 9i is ready for Kernel 2.4
> > or have I still to use the glibx 2.1?
> 
> Oracle 9i was developed by Oracle on SuSE Linux 7.1. They later switched
> to the kernel from SuSE Linux 7.2. That means the build platform is:
> - glibc 2.2.1
> - kernel 2.4.4.SuSE
> - gcc 2.95.2
> 9i should also support LFS (>2 GB files) now.
> 
> Larry Ellison will be on stage in Redwood Shores (Oracle Conference
> Center) presenting 9i on a 4 node Compaq (DL580s) cluster, running 9i on
> SuSE Linux. You can view it live on the Internet! I was there when they
> did the last adjustments yesterday.
> 
> --
> For additional commands, e-mail: [EMAIL PROTECTED]

Michael Hasenstein is THE man for Oracle on Linux.
This site is definitely worth a look:
http://www.suse.com/en/support/oracle/

Is it just me - or has anyone else seen that Dell offers "Linux 7"
pre-installed on PowerEdge Servers?
This utterly INFURIATES me.
If Dell truly "gets" Linux - they wouldn't allow an obvious faux-pas
such as this.
There is no such thing as "Linux 7".
"Linux" != "RedHat"
I wonder if the use of the term "Linux" in this manner may in fact be a
copyright/trademark  violation.
Please don't misunderstand me - I'm very glad that Dell ships
pre-installed Linux distributions on its PowerEdge and Precision boxes -
just call it what it is - ideally -  "Dell/RedHat GNU/Linux 7.0". I'd
settle for "Dell Linux 7.0".

used RedHat 5.1, 5.2, 6.0, 6.1, 6.2. 
as far as I was concerned - RH 7.0 was a terminal release for RedHat.
Too many other good distributions.

mucking around with Oracle on SuSE (7.1) anyways - since the 6.2 release
(swag at NYLUG).
playing on Mandrake 8.0.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspa

[Mogens Nørgaard]

My suggestion would be for all of you to move to Denmark. I got Gaja's book two
or three days ago ;-). Several of you could easily fit into the Garage, where
we're located. We could take turns reading chapters aloud to each other.

Rachel Carmichael wrote:

> doesn't bother me. I want people reading the book and getting something from
> it, I don't care what bookstore they get it in or what they paid
>
> >From: Paul Drake <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Good Reference for interpretation of Ultbstat/estat & Statspa
> >Date: Thu, 14 Jun 2001 17:46:16 -0800
> >
> > > By this do you mean you're still working on obtaining a copy?
> >
> >reading.
> >Barnes and Noble delivers next day in NYC.
> >I'm spoiled. :)
> >When I want something next day - I don't mind paying list price for
> >convenience.
> >
> >I hope that I didn't annoy any authors with the reference to bookpool.
> >The way that I figure it - if I get all my books 44% off, then I buy 2x as
> >many books.
> >
> >finding time to read them all - is another matter.
> >
> >Paul
> >
> >-Original Message-
> >Sent: Thursday, June 14, 2001 8:54 PM
> >To: Multiple recipients of list ORACLE-L
> >Statspa
> >
> >
> > > I'm still working on Gaja's Tuning 101 book.
> >
> >By this do you mean you're still working on obtaining a copy, or you're
> >still working on reading it?  I haven't seen any copies at the bookstore,
> >and last time I checked Amazon said they could deliver in one to two weeks,
> >which tells me they don't have any copies in stock but expect it soon.
> >Just
> >wondering
> >
> >- Greg
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Greg Moore
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Paul Drake
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(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
>
> --
> 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).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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

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

Child to Parent

[C.S.Venkata Subramanian]

Dear List,

I need some info, I have a table where I store the details of dealers in the table. 

structure is 
SF_DEALER_CODENOT NULL VARCHAR2(10)
SF_DEALER_NAME VARCHAR2(40)
SF_CIRCLE_CODENOT NULL VARCHAR2(10)
SF_AREA_OF_OPERATION  NOT NULL VARCHAR2(10)
SF_DEALER_TYPENOT NULL VARCHAR2(1)
SF_PARENT_DEALER  NOT NULL VARCHAR2(10)

In the same table itself i store both parent and child recs. Is there any way to trace 
the parent from child. If want to trace the child from parent I use the prior,connect 
and level in my query and get the correct results. I want the reverse. Is there any 
way out.

Pl help.


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: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

[Nguyen, Long (ITS, Limestone Ave)]

Hi,

I did 
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
and ran ./Configure again. This time it completed OK.

Cheers
Long

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, 14 June 2001 3:41 PM
To: Multiple recipients of list ORACLE-L



Thanks Tommy and Jared for the advice. 

I have downloaded perl5.005_03.tar.gz from CPAN, unzip and untar it and started the 
installation. So I ran
sh configure
and accepted default answer for all the questions asked. However after pressing ENTER 
for the two questions

Any additinal cc flags? [-I/usr/local/include]
Any additional ld flags? (NOT including libraries) [ -L/usr/local/lib]

the configure script compiled a simple "try.c" program and ran it, but failed. The 
error messages were


Checking your choice of compiler and flag for coherency
I've tried compile and link the following simple program:

#include 
main() { printf("O\n"; exit(0); }

I used the command:
gcc -O -I/usr/local/include -L/usr/local/lib -o try try.c -lsocket 
-lnsl -lgdbm -lgl -lm -lc -lcrypt
./try

and I got the following

ld.so.1:  ./try: fatal: libgdbm.so.2: open failed: No such file or directory
Killed
The program compiled OK, but exist with status 137.
(The supplied flags or libraries might be incorect).
You have a problem . Shall I abort Configure? [Y]


BUT, the file /usr/local/lib/libgdbm.so.2 does exist and is a link to 
/usr/local/lib/libgdbm.so.2.0.0 .

So, I do not understand. Please help.

Thanks
Long



  Long Nguyen   
  Oracle DBA 
  CSIRO Information Technology Services   
  [EMAIL PROTECTED]
  Phone 02 6276 6646
  Mobile0418 612 269



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, Long (ITS, Limestone Ave)
  INET: [EMAIL PROTECTED]

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

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

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

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

log checkpoint interval

[Nixon_Villanueva]

Hi,

I would like to know how the value in the log_checkpoint_interval is
presented, is it in blocksize or is it based on other factor?
If I have 2MB redo log size, what could be the appropriate value of
log_checkpoint_interval.

Thanks in advance!

-- 
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: RMAN - Incomplete recovery

[C.S.Venkata Subramanian]

Hi,
When u do an incomplete recovery, the db shud be opened with resetlogs. That's why 
they say to backup db after an incomplete recovery.

HTH
--

On Thu, 14 Jun 2001 07:52:20  
 Nirmal Kumar  Muthu Kumaran wrote:
>Helo guru's
>
>i found one ? in self test as follows:
>
>q)why is it not bebeficial to use RMAN when performing incomplete recovery?
>
>a) A full offline backup is required after the recovery operations are
>complete.
>
>Now my question is, In general, in case of incomplete recovery we should do
>the backup.
>
>But here what is the specific reason form doing offline backup?  i cann't do
>online backup itself .
>
>I get confused. Pls help me.
>
>Regards,
>Nirmal.
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Nirmal Kumar  Muthu Kumaran
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

sqlldr ver 8 can't load v7 database

[Raymond Lee Meng Hong]

  I have checkout the solution offer by Oracle , as they said use the sqlldr
come together with Oracle 7 , but if we upgrade our system to 8i already ,
where can I still found the v7 sqlldr ??

  IT also mention about OCI , what is OCI mean ? a interface program for
sqlldr with database ???


Raymond fall asleep in waiting for the Q.

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

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

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

Wow Wee

[Greg Moore]

"Oracle Corp. slashed the price on its database software by nearly 50
percent Thursday in an effort to thwart recent advances by rivals IBM and
Microsoft Corp."

http://www.sfgate.com/cgi-bin/article.cgi?file=/news/archive/2001/06/14/fina
ncial1839EDT0241.DTL&type=business

If the long link doesn't work, just find the SF Chronicle story at:

http://www.sfchronicle.com

and click Business -- it's one of the main headlines there.

- Greg

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

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

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

Re: Good Reference for interpretation of Ultbstat/estat & Statspa

[Rachel Carmichael]

I think Barnes and Noble has it. Or bookpool

>From: Greg Moore <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Good Reference for interpretation of Ultbstat/estat & Statspa
>Date: Thu, 14 Jun 2001 16:53:41 -0800
>
> > I'm still working on Gaja's Tuning 101 book.
>
>By this do you mean you're still working on obtaining a copy, or you're
>still working on reading it?  I haven't seen any copies at the bookstore,
>and last time I checked Amazon said they could deliver in one to two weeks,
>which tells me they don't have any copies in stock but expect it soon.  
>Just
>wondering
>
>- Greg
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Greg Moore
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

RE: Good Reference for interpretation of Ultbstat/estat & Statspa

[Rachel Carmichael]

doesn't bother me. I want people reading the book and getting something from 
it, I don't care what bookstore they get it in or what they paid



>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Good Reference for interpretation of Ultbstat/estat & Statspa
>Date: Thu, 14 Jun 2001 17:46:16 -0800
>
> > By this do you mean you're still working on obtaining a copy?
>
>reading.
>Barnes and Noble delivers next day in NYC.
>I'm spoiled. :)
>When I want something next day - I don't mind paying list price for
>convenience.
>
>I hope that I didn't annoy any authors with the reference to bookpool.
>The way that I figure it - if I get all my books 44% off, then I buy 2x as
>many books.
>
>finding time to read them all - is another matter.
>
>Paul
>
>-Original Message-
>Sent: Thursday, June 14, 2001 8:54 PM
>To: Multiple recipients of list ORACLE-L
>Statspa
>
>
> > I'm still working on Gaja's Tuning 101 book.
>
>By this do you mean you're still working on obtaining a copy, or you're
>still working on reading it?  I haven't seen any copies at the bookstore,
>and last time I checked Amazon said they could deliver in one to two weeks,
>which tells me they don't have any copies in stock but expect it soon.  
>Just
>wondering
>
>- Greg
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Greg Moore
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

-- 
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: CKPTs are not happening with FAST_START_IO_TARGET

[Jon Walthour]

--MS_Mac_OE_3075396610_4810850_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

Srinagesh:

A couple of questions:

1. You have what seem to me to be many very large log groups. What reasons
make this necessary?

2. Have you considered setting LOG_CHECKPOINT_INTERVAL to a much lower value
that would compute to be less than the size of your redo logs so that
checkpoints would be forced in the middle of your redo logs as well as at
log switches? Forcing checkpoints within your log files reduces the time
needed for instance recovery.

3. What about setting LOG_CHECKPOINT_TIMEOUT to a lower value for the same
reasoning?

4. What have you found when setting the FAST_START_IO_TARGET parameter to a
lower value?

-- 

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio


Organization: Fat City Network Services, San Diego, California
Reply-To: [EMAIL PROTECTED]
Date: Thu, 14 Jun 2001 15:45:42 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>




RDBMS: 
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

OS: 
SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-Enterprise

The init params are set as follows:
.. 
db_block_size=8192 
db_block_buffers=2
fast_Start_io_target=5000
log_checkpoints_to_alert = TRUE
log_checkpoint_timeout = 2147483647
log_checkpoint_interval = 9
 

We have 4 Redo log groups with 200M each.

We have a requirement that the instance recovery must be done within 60
secs. 
So, we are trying to use the fast_Start_io_target param.
The issue here is, we don't see any checkpoints being done (as seen in the
alert logs as well as v$sysstat). THe only checkpoints that we see are the
ones that happen during a log switch or if you issue "alter system
checkpoint". 

Any ideas on why  the checkpoints are not being performed.

Thanks in advance. 



--MS_Mac_OE_3075396610_4810850_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable



Re: CKPTs are not happening with  FAST_START_IO_TARGET 


Srinagesh:

A couple of questions:

1. You have what seem to me to be many very large log groups. What reasons =
make this necessary?

2. Have you considered setting LOG_CHECKPOINT_INTERVAL to a much lower valu=
e that would compute to be less than the size of your redo logs so that chec=
kpoints would be forced in the middle of your redo logs as well as at log sw=
itches? Forcing checkpoints within your log files reduces the time needed fo=
r instance recovery.

3. What about setting LOG_CHECKPOINT_TIMEOUT to a lower value for the same =
reasoning?

4. What have you found when setting the FAST_START_IO_TARGET p=
arameter to a lower value?

-- 

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio


From: Srinagesh Battula <[EMAIL PROTECTED]>
Organization: Fat City Network Services, San Diego, Cali=
fornia
Reply-To: [EMAIL PROTECTED]
Date: Thu, 14 Jun 2001 15:45:42 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>=
;
Subject: CKPTs are not happening with  FAST_START_IO_TARGET 




RDBMS: 
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production <=
BR>
With the Partitioning option 
JServer Release 8.1.7.0.0 - Production 

OS: 
SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-En=
terprise 

The init params are set as follows: 
.. 
db_block_size=3D8192 
db_block_buffers=3D2 
fast_Start_io_target=3D5000 
log_checkpoints_to_alert =3D TRUE 
log_checkpoint_timeout =3D 2147483647 
log_checkpoint_interval =3D 9 
 

We have 4 Redo log groups with 200M each. 

We have a requirement that the instance recovery must be don=
e within 60 secs. 
So, we are trying to use the fast_Start_io_target param. 
The issue here is, we don't see any checkpoints being done (as seen in the =
alert logs as well as v$sysstat). THe only checkpoints that we see are the o=
nes that happen during a log switch or if you issue "alter system check=
point". 

Any ideas on why  the checkpoints are not being perform=
ed. 

Thanks in advance. 





--MS_Mac_OE_3075396610_4810850_MIME_Part--

-- 
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: Good Reference for interpretation of Ultbstat/estat & Statspa

[Paul Drake]

> By this do you mean you're still working on obtaining a copy?

reading.
Barnes and Noble delivers next day in NYC.
I'm spoiled. :)
When I want something next day - I don't mind paying list price for
convenience.

I hope that I didn't annoy any authors with the reference to bookpool.
The way that I figure it - if I get all my books 44% off, then I buy 2x as
many books.

finding time to read them all - is another matter.

Paul

-Original Message-
Sent: Thursday, June 14, 2001 8:54 PM
To: Multiple recipients of list ORACLE-L
Statspa


> I'm still working on Gaja's Tuning 101 book.

By this do you mean you're still working on obtaining a copy, or you're
still working on reading it?  I haven't seen any copies at the bookstore,
and last time I checked Amazon said they could deliver in one to two weeks,
which tells me they don't have any copies in stock but expect it soon.  Just
wondering

- Greg

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

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

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

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

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

Log File Sync to Log File Parallel Write Ratio

[Post, Ethan]

Looking at some old Q&A on Steve's site (www.ixora.com.au) and found a post
containing this...

"The ratio of your log file sync to log file parallel write waits indicates
that your log_buffer is much too big. Drop it back to 160K. "

What exactly is the ratio suppose to be and how do these two wait events
differ exactly.

Thanks,
Ethan Post

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

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

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

[Paul Drake]

Joe,
 
I installed Oracle 8.1.7 Standard  on a W2K Pro laptop that only had 80 MB
of RAM.
(It wasn't very fast)
Its since been maxed out at 144MB - looks like its time to turn that one
into a sniffer.
 
Paul
 

-Original Message-
Sent: Thursday, June 14, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


yea except its only certified on Suse(us RH people look like we are SOL) and
min quals are 512M of physical ram, guess that kills any more demos at conf
based on my current 192M maxed out laptop :(
 
joe
 


>>> [EMAIL PROTECTED] 06/14/01 03:05PM >>>
I remember someone asking whether Oracle was going to release Oracle for NT
first, or Oracle for LINUX.

We have our answer.

: )

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] < mailto:[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  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspa

[Greg Moore]

> I'm still working on Gaja's Tuning 101 book.

By this do you mean you're still working on obtaining a copy, or you're
still working on reading it?  I haven't seen any copies at the bookstore,
and last time I checked Amazon said they could deliver in one to two weeks,
which tells me they don't have any copies in stock but expect it soon.  Just
wondering

- Greg

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

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

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

CKPTs are not happening with FAST_START_IO_TARGET

[Srinagesh Battula]

Title: CKPTs are not happening with  FAST_START_IO_TARGET 






RDBMS:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production 
With the Partitioning option 
JServer Release 8.1.7.0.0 - Production 


OS:
SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-Enterprise 



The init params are set as follows: 
.. 
db_block_size=8192 
db_block_buffers=2 
fast_Start_io_target=5000 
log_checkpoints_to_alert = TRUE 
log_checkpoint_timeout = 2147483647 
log_checkpoint_interval = 9 
 


We have 4 Redo log groups with 200M each. 


We have a requirement that the instance recovery must be done within 60 secs. 
So, we are trying to use the fast_Start_io_target param. 
The issue here is, we don't see any checkpoints being done (as seen in the alert logs as well as v$sysstat). THe only checkpoints that we see are the ones that happen during a log switch or if you issue "alter system checkpoint". 

Any ideas on why  the checkpoints are not being performed.


Thanks in advance.

RE: OT RE: Speedo be gone

[A. Bardeen]

Woo hoo! Count me in ;)

-- Anita

--- "Fisher, Julie" <[EMAIL PROTECTED]> wrote:
> I second that.
> 
> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
> 
> 
> -Original Message-
> Sent: June 14, 2001 12:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> uh uh, I'm not contributing to that fund, I want to
> see him lose that Speedo
> 
> 
> 
> 
> >From: "Norrell, Brian" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: RE: Speedo be gone
> >Date: Thu, 14 Jun 2001 09:13:49 -0800
> >
> >I propose a fund to purchase and FedEx a towel to
> Ross before he loses his
> >Speedo.  Let's try to maintain some level of
> decorum.
> >
> >Brian Norrell
> >Manager, MPI Development
> >QuadraMed
> >511 E John Carpenter Frwy, Su 500
> >Irving, TX 75062
> >(972) 831-6600
> >
> >
> >-Original Message-
> >Sent: Thursday, June 14, 2001 10:23 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Henry,
> >
> >Are you suggesting I lose my speedo for Linda?
> >
> >Hmm.
> >
> >
> >
> >-Original Message-
> >Sent: Wednesday, June 13, 2001 1:13 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Ross,
> >It looks like you may have to lose that speedo. I
> saw this in yesterday's
> >newspaper.
> >
> >"The Warnaco Group filed for Chapter 11 bankruptcy
> protection yesterday,
> >blaming the economy and its heavy debt load, among
> other things, for its
> >problems.
> >Under the leadership of Linda J. Wachner, the chief
> executive, Warnaco was
> >transformed from a $590 million underwear maker to
> a diverse $2.25 billion
> >apparel company with a dedicated following in
> stores and on the stock
> >market.
> >Brands like Speedo, Calvin Klein and Chaps by Ralph
> Lauren were part of the
> >fold."
> >
> >Henry
> >
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Henry Poras
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> >San Diego, California-- Public Internet
> access / Mailing Lists
>
>
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(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: Norrell, Brian
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> >San Diego, California-- Public Internet
> access / Mailing Lists
>
>
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(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
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

RE: ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle

[Glasrot, Nechama]

got it ... close it ...
 

Nechama Glasrot
Oracle DBA
Seisint, Inc.6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 nglasrot@seisint.com Direct 
561.999.3977
Main 
561.999.4400
Fax 
561.999.4695


  -Original Message-From: Jeffrey Beckstrom 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 3:57 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  ADMIN: Please vote (was: RE: OT SPAM : Become an 
  Oraclevote for close>>> 
  [EMAIL PROTECTED] 6/14/01 3:25:48 PM >>>I too got it, so 
  I'm presuming they harvested this list.  I'll take a lookinto the 
  logs when I return from this business trip I'm on.  I appreciateall 
  the confirming responses.  Should I find that they harvested the 
  list,they will be removed and banned from all lists here (this is 
  policy).However, it's becoming apparent that more spammers find this 
  list useful andharvest from it.  I have the ability to hide the 
  subscriber list fromeveryone.  I don't typically do this because 
  there are legitimate reasons toallow people to view the subscriber 
  list.  In cases of abuse, it's a common(and effective) way to 
  mitigate the problem.  If I hide it, no one will beable to directly 
  harvest addresses.I'll take a short vote.  Please respond to me 
  privately (here at thisaddress) if you would prefer to have the subscriber 
  list kept open toanyone, or closed to everyone. I'll close the voting on 
  the 19th.  Remember!Don't reply to the list!! :-)Note that 
  this doesn't affect your ability to join or leave the list; itonly affects 
  your ability to do a WHO on the list.thanks,bruceListMaster, 
  Fat City Network Services-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.com-- Author: 
  Bruce Bergman  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).



This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law.

If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED.

If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.

Thank you



  
<>

SyncSort - Unix - Datawarehousing.

[Rajaram]

Hi,
   I want some informarmation about SyncSort for Unix. If anyone is using sincsort 
under unix - I need the following details:
1. What is the basic purpose of syncsort? ( I have gone thru www.syncsort.com - So, I 
dont want this answer).
2. How is sync sort used in data loads or data warehousing? Is there any documentation 
online? Any whitepapers?

TIA,
Rajaram



NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: [EMAIL PROTECTED]

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

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

[Oriole Support]

Vikas,

> I get an error when migrating from 8.1.6 to 8.1.7 on a Sun  box.
> After editing the  /var/opt/oracle for the fbs to the new Oracle Home - when
> I attempt to start svrmgrl - i get an error below:
> ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol
> kgsmp789_compat_: referenced symbol not found
> Killed

When you have unreferenced symbols the first thing to do usually is to
locate them. Here is what it gives on my 8.1.7 :

$ cd $ORACLE_HOME/lib
$ nm -A *.a *.so | grep kgsmp789_compat_ | more
nm: libordim8.so: no symbols
libclient8.a:kgus.o: U kgsmp789_compat_
libclient8.a:kgum.o: U kgsmp789_compat_
libclient8.a:kgupi.o: U kgsmp789_compat_
libclient8.a:kguplt.o: U kgsmp789_compat_
libclntst8.a:kgsm.o:0028 R kgsmp789_compat_
libclntst8.a:kgum.o: U kgsmp789_compat_
libclntst8.a:kgupi.o: U kgsmp789_compat_
libclntst8.a:kguplt.o: U kgsmp789_compat_
libclntst8.a:kgus.o: U kgsmp789_compat_
libgeneric8.a:kgsm.o:0028 R kgsmp789_compat_
libgeneric8.a:kgsn.o: U kgsmp789_compat_
libserver8.a:kcbz.o: U kgsmp789_compat_
libserver8.a:kcbb.o: U kgsmp789_compat_
libserver8.a:ksl.o: U kgsmp789_compat_
libserver8.a:ksu.o: U kgsmp789_compat_
libserver8.a:ksm.o: U kgsmp789_compat_
libclntsh.so:0052be80 R kgsmp789_compat_

This routine is referenced in a number of libraries and apparently you
can find it defined in three places, libgeneric8.a and the dynamic
two-task and static single task versions of the client library. Perhaps
your client library has not been properly built.
Try
   cd $ORACLE_HOME/rdbms/lib
   make -f ins_rdbms.mk client_sharedlib

HTH,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oriole Support
  INET: [EMAIL PROTECTED]

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

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

[Thater, William]

On Thu, 14 Jun 2001,Jared Still scribbled on the wall in glitter crayon:
->The protagonist is a grayish amorphous blob with a plasma
->cannon.  He deals with corporate attorneys with unusual
->dispatch and alacrity.
->
->I've at times wondered if these methods could be employed
->on the big corp consultants.
->
->Bill 'Shrek' may have something to say on this.

i do like his attitude, and nice weapons.;-)  i think i remember him from SEAL team 
2.;-)

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

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

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

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

[Jared Still]

Ah, a big consulting company.  Therein lies the real problem.

Since you're already received useful replies, I'll take 
the other fork in the road.

One of my favorite comic strips is Schlock Mercenary
( http://www.schlockmercenary.com ).

The protagonist is a grayish amorphous blob with a plasma
cannon.  He deals with corporate attorneys with unusual
dispatch and alacrity.

I've at times wondered if these methods could be employed
on the big corp consultants.

Bill 'Shrek' may have something to say on this.

Jared

On Tuesday 12 June 2001 15:32, Austin, Steve S wrote:
> Folks,
>
> Does anyone know how to exploit the real-time scheduler in Solaris?  I can
> only find vague references to this on the web.
>
> We're considering using the real-time scheduler for Oracle background
> processes on our busiest Solaris boxes (that support 2-3k connections).  We
> want to make Unix bias the Oracle background processes for CPU, all other
> things being equal.  We had some consultants suggesting our MTS config
> wasn't getting the cycles it needed after we called into question their SQL
> (which is too long a story for me to get into -- I'll begin ranting about
> big consulting companies.  :)
>
> Thanks,
> Steve
>
> Steve Austin
> DBA for Unix-based systems
> Enterprise Data Center Operations, XO Communications
> email:[EMAIL PROTECTED]
-- 
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: number to binary conversion

[Igor Neyman]

Here is my modification of Tom's Kyte code:

FUNCTION to_base( p_dec in number, p_base in number )
return varchar2
is
 l_str varchar2(255) default NULL;
 l_num number default p_dec;
 l_hex varchar2(16) default '0123456789ABCDEF';
begin
if ( trunc(p_dec) <> p_dec ) then
 raise PROGRAM_ERROR;
end if;

IF (p_dec < 0) THEN
 l_num := l_num + 1;
 loop
  l_str := substr( l_hex, l_num - p_base*FLOOR(l_num/p_base), 1 ) || l_str;
  l_num := trunc( l_num/p_base );
  exit when ( l_num = 0 );
 end loop;
ELSE
 loop
  l_str := substr( l_hex, mod(l_num,p_base)+1, 1 ) || l_str;
  l_num := trunc( l_num/p_base );
  exit when ( l_num = 0 );
 end loop;
END IF;
return l_str;
end to_base;


FUNCTION to_dec
( p_str in varchar2,
  p_from_base in number default 16 ) return number
is
 l_num   number default 0;
 l_hex   varchar2(16) default '0123456789ABCDEF';
begin
 for i in 1 .. length(p_str) loop
  l_num := l_num * p_from_base + instr(l_hex,upper(substr(p_str,i,1)))-1;
 end loop;
 return l_num;
end to_dec;

FUNCTION to_hex( p_dec in number ) return varchar2
is
begin
 return to_base( p_dec, 16 );
end to_hex;


FUNCTION to_bin( p_dec in number ) return varchar2
is
begin
 return to_base( p_dec, 2 );
end to_bin;


FUNCTION to_oct( p_dec in number ) return varchar2
is
begin
 return to_base( p_dec, 8 );
end to_oct;


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


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 5:01 PM


> Good afternoon,
>
> I have seen on this list some time ago PL/SQL to convert a number to/from
> decimal and hex.
> Does anyone have PL/SQL to convert a number to/from a binary
representation?
>
> TIA,
>
> Steven Haas
> Opus Consultants, LLC
> "Opinions expressed, right or wrong, are my own."
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Haas
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: number to binary conversion

[Larry Elkins]

Steven,

For decimal to hex, a to_char function using the "X" element can be used.
There are certain restrictions -- refer to the Number Formats table in the
SQL manual for more info. Here is an example:

  1* select to_char(10,'XXX') from dual
SQL> /

TO_C

   A

For a more robust solution that goes both ways, and, deals with conversions
between various bases, take a look at:

http://govt.oracle.com/~tkyte/hexdec/index.html


Regards,

Larry G. Elkins
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Haas
> Sent: Thursday, June 14, 2001 4:02 PM
> To: Multiple recipients of list ORACLE-L
> Subject: number to binary conversion
>
>
> Good afternoon,
>
> I have seen on this list some time ago PL/SQL to convert a number to/from
> decimal and hex.
> Does anyone have PL/SQL to convert a number to/from a binary
> representation?
>
> TIA,
>
> Steven Haas
> Opus Consultants, LLC
> "Opinions expressed, right or wrong, are my own."

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

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

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

[Jon Walthour]

Ben:

The qref latch is obtained for each Parallel Query process. It
is acquired before the queue buffers can be manipulated so that
communication can take place between the various slave processes.
The latch is acquired for putting messages into the buffer. You
will generally see lots of misses for this latch since it is
acquired with a nowait option. 

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: "Ben Jones" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 6/14/01 1:56:36 PM
>

>Does anyone know what causes waits on this latch ?
>
>Thanks
>Ben
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Ben Jones
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

[Giles, Teri]

I  too am on the list, but not the newsgroup and did not receive the spam.
Also, I am new to the last 6/04/2001.

Teri

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 14, 2001 2:21 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks
> 
> FYI,
> I am on the list and not on newsgroup and I did not receive that message.
> Another clue:  I had joined just recently so it might've been some time
> ago
> some one got a hold of the list..
> 
> -Original Message-
> Sent: Thursday, June 14, 2001 11:47 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter
> crayon:
> 
> ->FYI,
> ->
> ->I got one of these at home, but not at work.
> ->
> ->At home I have logged into the oracle.server newsgroup, but never
> Jared's
> ->list.
> ->
> ->At work I subscribe to Jared's list, but never went to the newsgroup.
> ->
> ->This tells me that unless I received the e-mail at work as well and
> didn't
> ->notice, our addresses were lifted off the newsgroup and not this list.
> ->
> ->Another reason why I don't like newsgroups all that much.
> 
> except i got 2 and never go to the newsgroup.;-) but i did go to lazyDBA
> for
> a few hours.
> 
> --
> Bill "Shrek" Thater   Certifiable ORACLE DBA
> Telergy, Inc.[EMAIL PROTECTED]
> ~~
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> ~~
> Abstraction is achieved by data hiding and enforced by encapsulation.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thater, William
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Giles, Teri
  INET: [EMAIL PROTECTED]

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

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

number to binary conversion

[Steve Haas]

Good afternoon,

I have seen on this list some time ago PL/SQL to convert a number to/from
decimal and hex.
Does anyone have PL/SQL to convert a number to/from a binary representation?

TIA,

Steven Haas
Opus Consultants, LLC
"Opinions expressed, right or wrong, are my own."


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

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

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

Sort_multiblock_read_count

[Johnson Poovathummoottil]

Hi All,

Reading about the SORT_MULTIBLOCK_READ_COUNT init.ora
parameter, I am wondering why it should ever be
anything smaller or larger than the SORT_AREA_SIZE.
Has anyone changed the default setting of this
parameter for the better?

Johnson Job

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.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).

OID on 9i

[Paul Baumgartel]

OID installation on a new 9i database ended with

Creating OiD schema...
Parameter "orahome" = /d00/oracle/product/901
Parameter "oidschema" = true
OID Schema Creation succeeded
OIDMON started
Unable to bind to the OID server
/d00/oracle/product/901/ldap/postcfg/postcfg: -1: bad number
 

Has anyone else tried this?  Any ideas?

This is 9.0.1 on Solaris 2.7

TIA

Paul Baumgartel
InstiPro Group, Inc.
[EMAIL PROTECTED]
212 813-0829 x103

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

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

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

[Kevin Lange]

Off the cuff I would say something did not get linked.  

-Original Message-
Sent: Thursday, June 14, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


I get an error when migrating from 8.1.6 to 8.1.7 on a Sun  box. 
After editing the  /var/opt/oracle for the fbs to the new Oracle Home - when
I attempt to start svrmgrl - i get an error below:

ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol
kgsmp789_compat_: referenced symbol not found
Killed

the .profile for the oracle user - is as below.

Can some one help 

thanks

vikas

PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:.:/usr/openwi
n/bin
export PATH
#
# -  Oracle related items go here - assume ksh on export command. Keep
version neutral!
#
export ORAENV_ASK=NO
export ORACLE_SID=APSVt3
. oraenv
export ORAENV_ASK=YES
export
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/assista
nts/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/owm/jlib:$ORACLE_HOME/plsq
l/jlib:$ORACLE_HOME/rdbms/jlib
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORATAB=/var/opt/oracle
#
# OWA Server (oracle stub - not a databse home)
#
export ORAWEB_BASE=/u06/app/oracle
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6
export ORAWEB_ADMIN=/u06/app/oracle/product/8.1.6/listener
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6

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

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

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

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

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

RE: Good Reference for interpretation of Ultbstat/estat & Statspa

[Rachel Carmichael]

you mean it doesn't work if I just sleep with it under my pillow?  Okay, 
okay, but the "to-be-read" pile is getting bigger and bigger and no matter 
how fast I read, I'm falling behind.

I'm beginning to feel like the Red Queen in Through the Looking Glass.

Rachel


>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Good Reference for interpretation of Ultbstat/estat & Statspa
>Date: Thu, 14 Jun 2001 12:29:10 -0800
>
>Funny thing about that - is that you actually have to read the book for it
>to be any benefit.
>
>I'm still working on Gaja's Tuning 101 book.
>The Statspack book has been sitting here for 3 weeks - hadn't opened it 
>yet.
>
>and there are other book stores - such as Bookpool - where the price was
>$29.50.
>
>do not be assimilated.
>
>Paul
>
>-Original Message-
>Sent: Thursday, June 14, 2001 3:57 PM
>To: Multiple recipients of list ORACLE-L
>Statspack?
>
>
>Hi !
>
>There is  a book from Oracle Press called Oracle High
>performance Tunign with Statspack by Don Burleson. I
>am waiting for my copy.
>
>Just do a search in AMAZON for statspack
>
>=
>Have a nice day !!
>
>Best Regards,
>K Gopalakrishnan,
>Bangalore, INDIA.
>
>__
>Do You Yahoo!?
>Spot the hottest trends in music, movies, and more.
>http://buzz.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Paul Drake
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

-- 
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: Migrating from 8.1.6 to 8.1.7

[Toepke, Kevin M]

Have you checked your LD_LIBRARY_PATH? As of 8.1.7 you can not have
$ORACLE_HOME/bin in your LD_LIBRARY_PATH.

-Original Message-
Sent: Thursday, June 14, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L


I get an error when migrating from 8.1.6 to 8.1.7 on a Sun  box. 
After editing the  /var/opt/oracle for the fbs to the new Oracle Home - when
I attempt to start svrmgrl - i get an error below:

ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol
kgsmp789_compat_: referenced symbol not found
Killed

the .profile for the oracle user - is as below.

Can some one help 

thanks

vikas

PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:.:/usr/openwi
n/bin
export PATH
#
# -  Oracle related items go here - assume ksh on export command. Keep
version neutral!
#
export ORAENV_ASK=NO
export ORACLE_SID=APSVt3
. oraenv
export ORAENV_ASK=YES
export
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/assista
nts/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/owm/jlib:$ORACLE_HOME/plsq
l/jlib:$ORACLE_HOME/rdbms/jlib
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORATAB=/var/opt/oracle
#
# OWA Server (oracle stub - not a databse home)
#
export ORAWEB_BASE=/u06/app/oracle
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6
export ORAWEB_ADMIN=/u06/app/oracle/product/8.1.6/listener
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6

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

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

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

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

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

RE: OT: Working from home

[Kimberly Smith]

I actually work for a company that is ok with working from home and have
done
it but I am now at a client that was quite insistent that everyone be here
from 8-5.
So we all pretty much said ok and we all now work much less hours.  Sucks to

be them.

VPN is a god send though.  When I have to take calls in the middle of the
night
its nice to be able to check the database and then tell the person off on
the phone
(1st tier support) for not doing their job because there is no database
issue.

-Original Message-
Sent: Thursday, June 14, 2001 6:46 AM
To: Multiple recipients of list ORACLE-L


On Wed, 13 Jun 2001,Rachel Carmichael scribbled on the wall in glitter
crayon:

->After all, how do they manage accountability when you are in the office?
By
->the number of hours you sit at your desk or by the work that gets done, to
->deadline and correctly?

in my case the former... damagement is more interested in seeing my smiling
face than in how much gets done while i'm here.

->
->Communication: before I got a cable modem and VPN, I had two phone lines
and
->an email pager. (I still do, but use the VPN now). So I was dialed in on
->one, and had the other free for office communication. We have office email
->and my pager. I let them know if I have to go out for any reason. I am
->ALWAYS available by pager. Yes, even on vacation. I'd rather take time out
->of vacation to do a fast fix of a problem than let it wait until I get
back
->and find it has festered into a major problem.

well, i have a cell phone and a pager [with an email address but no reply
capability.] so when i'm on the phone dialed in i can talk on the cell and
still get a page.

problem: they complain how much i use the cell.

and no i'm not changing the .sig.;-)

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspa

[Paul Drake]

Funny thing about that - is that you actually have to read the book for it
to be any benefit.

I'm still working on Gaja's Tuning 101 book.
The Statspack book has been sitting here for 3 weeks - hadn't opened it yet.

and there are other book stores - such as Bookpool - where the price was
$29.50.

do not be assimilated.

Paul

-Original Message-
Sent: Thursday, June 14, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L
Statspack?


Hi !

There is  a book from Oracle Press called Oracle High
performance Tunign with Statspack by Don Burleson. I
am waiting for my copy. 

Just do a search in AMAZON for statspack

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

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

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

Migrating from 8.1.6 to 8.1.7

[Vikas Kawatra]

I get an error when migrating from 8.1.6 to 8.1.7 on a Sun  box. 
After editing the  /var/opt/oracle for the fbs to the new Oracle Home - when
I attempt to start svrmgrl - i get an error below:

ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol
kgsmp789_compat_: referenced symbol not found
Killed

the .profile for the oracle user - is as below.

Can some one help 

thanks

vikas

PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:.:/usr/openwi
n/bin
export PATH
#
# -  Oracle related items go here - assume ksh on export command. Keep
version neutral!
#
export ORAENV_ASK=NO
export ORACLE_SID=APSVt3
. oraenv
export ORAENV_ASK=YES
export
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/assista
nts/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/owm/jlib:$ORACLE_HOME/plsq
l/jlib:$ORACLE_HOME/rdbms/jlib
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORATAB=/var/opt/oracle
#
# OWA Server (oracle stub - not a databse home)
#
export ORAWEB_BASE=/u06/app/oracle
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6
export ORAWEB_ADMIN=/u06/app/oracle/product/8.1.6/listener
export ORAWEB_HOME=/u06/app/oracle/product/8.1.6

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspack?

[Jon Walthour]

Vicky:

Check out the set of articles on perf tuning on MetaLink at Doc
#61998.1. Look specifically at Doc #Note:62161.1.

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: Oracle DBA <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 6/14/01 2:50:55 PM
>

>Hi,
>
>Looking for an english like reference for
>interpretation of statistics and cooresponding actions
>and modifications.  Any clues?
>
>
>
>=
>Vicky D. Foster, 
>Senior Oracle DBA Consultant
>email:  [EMAIL PROTECTED]
>
>__
>Do You Yahoo!?
>Spot the hottest trends in music, movies, and more.
>http://buzz.yahoo.com/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Oracle DBA
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). 
You may
>also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Good Reference for interpretation of Ultbstat/estat & Statspack?

[K Gopalakrishnan]

Hi !

There is  a book from Oracle Press called Oracle High
performance Tunign with Statspack by Don Burleson. I
am waiting for my copy. 

Just do a search in AMAZON for statspack

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspack?

[Oracle DBA]

great thanx!!

--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Hi !
> 
> There is  a book from Oracle Press called Oracle
> High
> performance Tunign with Statspack by Don Burleson. I
> am waiting for my copy. 
> 
> Just do a search in AMAZON for statspack
> 
> =
> Have a nice day !!
>

> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> 
> __
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=
Vicky D. Foster, 
Oracle DBA
email:  [EMAIL PROTECTED]

__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle

[Jeffrey Beckstrom]

vote for 
close>>> [EMAIL PROTECTED] 6/14/01 3:25:48 PM 
>>>I too got it, so I'm presuming they harvested this list.  
I'll take a lookinto the logs when I return from this business trip I'm 
on.  I appreciateall the confirming responses.  Should I find that 
they harvested the list,they will be removed and banned from all lists here 
(this is policy).However, it's becoming apparent that more spammers find 
this list useful andharvest from it.  I have the ability to hide the 
subscriber list fromeveryone.  I don't typically do this because there 
are legitimate reasons toallow people to view the subscriber list.  In 
cases of abuse, it's a common(and effective) way to mitigate the 
problem.  If I hide it, no one will beable to directly harvest 
addresses.I'll take a short vote.  Please respond to me privately 
(here at thisaddress) if you would prefer to have the subscriber list kept 
open toanyone, or closed to everyone. I'll close the voting on the 
19th.  Remember!Don't reply to the list!! :-)Note that this 
doesn't affect your ability to join or leave the list; itonly affects your 
ability to do a WHO on the list.thanks,bruceListMaster, Fat City 
Network Services-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bruce 
Bergman  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: ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle Certi

[Paul Baumgartel]

I'd prefer the list be kept closed.

Paul Baumgartel
InstiPro Group, Inc.
[EMAIL PROTECTED]
212 813-0829 x103


-Original Message-
Sent: Thursday, June 14, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Certified DBA in 5 Weeks)


I too got it, so I'm presuming they harvested this list.  I'll take a look
into the logs when I return from this business trip I'm on.  I appreciate
all the confirming responses.  Should I find that they harvested the list,
they will be removed and banned from all lists here (this is policy).

However, it's becoming apparent that more spammers find this list useful and
harvest from it.  I have the ability to hide the subscriber list from
everyone.  I don't typically do this because there are legitimate reasons to
allow people to view the subscriber list.  In cases of abuse, it's a common
(and effective) way to mitigate the problem.  If I hide it, no one will be
able to directly harvest addresses.

I'll take a short vote.  Please respond to me privately (here at this
address) if you would prefer to have the subscriber list kept open to
anyone, or closed to everyone. I'll close the voting on the 19th.  Remember!
Don't reply to the list!! :-)

Note that this doesn't affect your ability to join or leave the list; it
only affects your ability to do a WHO on the list.

thanks,
bruce
ListMaster, Fat City Network Services

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good Reference for interpretation of Ultbstat/estat & Statspa

[Christopher Spence]

Metalink has some articles on E/B Stat, Oracle Publishing has great
Statspack docs.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, June 14, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Statspack?


Hi,

Looking for an english like reference for
interpretation of statistics and cooresponding actions
and modifications.  Any clues?



=
Vicky D. Foster, 
Senior Oracle DBA Consultant
email:  [EMAIL PROTECTED]

__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Oracle 9i database for Linux available for download on

[JOE TESTA]

yea except its only certified on Suse(us RH people look like 
we are SOL) and min quals are 512M of physical ram, guess that kills any more 
demos at conf based on my current 192M maxed out laptop :(
 
joe
 
>>> [EMAIL PROTECTED] 06/14/01 03:05PM 
>>>I remember someone asking whether Oracle was going to release 
Oracle for NTfirst, or Oracle for LINUX.We have our answer.: 
)Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems 
Admin & Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | Région 
des Maritimes, MPOE-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  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).

ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks)

[Bruce Bergman]

I too got it, so I'm presuming they harvested this list.  I'll take a look
into the logs when I return from this business trip I'm on.  I appreciate
all the confirming responses.  Should I find that they harvested the list,
they will be removed and banned from all lists here (this is policy).

However, it's becoming apparent that more spammers find this list useful and
harvest from it.  I have the ability to hide the subscriber list from
everyone.  I don't typically do this because there are legitimate reasons to
allow people to view the subscriber list.  In cases of abuse, it's a common
(and effective) way to mitigate the problem.  If I hide it, no one will be
able to directly harvest addresses.

I'll take a short vote.  Please respond to me privately (here at this
address) if you would prefer to have the subscriber list kept open to
anyone, or closed to everyone. I'll close the voting on the 19th.  Remember!
Don't reply to the list!! :-)

Note that this doesn't affect your ability to join or leave the list; it
only affects your ability to do a WHO on the list.

thanks,
bruce
ListMaster, Fat City Network Services

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: IBM creates it's own "9i" ?

[Christopher Spence]

So much leaks between releases that alot of the top vendors tend to use the
same goal list when releasing products.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, June 14, 2001 2:43 PM
To: Multiple recipients of list ORACLE-L


I received this update today about IBM creating a database release that is
suppose to be SMART and self tuning. Was Oracle one step ahead or was there
a leak at IBM?
==

"IBM looks to get SMART with DB2 7.2"

Self-managing and resource tuning (SMART) features, deep integration
with the WebSphere application server and "autonomic computing"
technologies, lead the list of highlights IBM is pointing to in the
newest release of its DB2 Universal Database. Jeff Jones, IBM's
senior program manager of data management solutions, discusses DB2
7.2, IBM's strategy in the database market and the details of the
Informix deal, in the first of a two-part question-and-answer
interview with searchDatabase.

SOURCE:  searchDatabase.com
http://www.searchdatabase.com/qna/0,289202,sid13_gci740063,00.html

==
ROR mô¿ôm

-- 
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: Oracle 9i database for Linux available for download on Techne

[Khedr, Waleed]

I downloaded the file and it's 81013KB.
The file gets uncompressed successfully.
It's 82956567 bytes = 82956KB.

They added 5 to the size of the file by mistake.

If the file has a problem you wouldn't be able to gunzip it.

(B.T.W. I'm playing with 9i for two months on Solaris and the last beta was
on six CDs).

Regards,

Waleed

-Original Message-
Sent: Thursday, June 14, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Techne


Waleed,

Believe it or not, I do know about gunzip. Uncompressed the file is 84MB, 
instead of 80MB. The files in the .cpio file seem to be java files, and I 
think that the contents of some of the directory structures listed in the 
cpio file are not there).

In any case, the size listed on the otn website is supposedly the size of 
the COMPRESSED file (and is, for files 1 and 2). It's only file 3 that 
downloads incorrectly

Rachel


>From: "Khedr, Waleed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle 9i database for Linux available for download on Techne
>Date: Thu, 14 Jun 2001 09:21:12 -0800
>
>   Try to uncompress it and if it works then it's the right size.
>
>Regards,
>
>Waleed
>
>-Original Message-
>Sent: Thursday, June 14, 2001 11:47 AM
>To: Multiple recipients of list ORACLE-L
>Technet
>
>
>has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads
>79+MB and says it's done.
>
>I tried both download sites (east and west) that I know of. Are there any
>others?
>
>Rachel
>
>
> >From: "Joe Raube" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle 9i database for Linux available for download on Technet
> >Date: Wed, 13 Jun 2001 20:25:48 -0800
> >
> >Enjoy
> >
> >
> >
> >_
> >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: Joe Raube
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(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
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

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

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

Good Reference for interpretation of Ultbstat/estat & Statspack?

[Oracle DBA]

Hi,

Looking for an english like reference for
interpretation of statistics and cooresponding actions
and modifications.  Any clues?



=
Vicky D. Foster, 
Senior Oracle DBA Consultant
email:  [EMAIL PROTECTED]

__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle 9i database for Linux available for download on Techne

[Boivin, Patrice J]

I remember someone asking whether Oracle was going to release Oracle for NT
first, or Oracle for LINUX.

We have our answer.

: )

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Ivan_Rivera]

Title: RE: list of good links





Thanks to all who replied.  You guys are great! (like the cereal). Later, Ivan

RE: OT RE: Speedo be gone

[Fisher, Julie]

I second that.

Julie Fisher
Sandia National Laboratories
Oracle 8i DBA
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: June 14, 2001 12:04 PM
To: Multiple recipients of list ORACLE-L


uh uh, I'm not contributing to that fund, I want to see him lose that Speedo




>From: "Norrell, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Speedo be gone
>Date: Thu, 14 Jun 2001 09:13:49 -0800
>
>I propose a fund to purchase and FedEx a towel to Ross before he loses his
>Speedo.  Let's try to maintain some level of decorum.
>
>Brian Norrell
>Manager, MPI Development
>QuadraMed
>511 E John Carpenter Frwy, Su 500
>Irving, TX 75062
>(972) 831-6600
>
>
>-Original Message-
>Sent: Thursday, June 14, 2001 10:23 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Henry,
>
>Are you suggesting I lose my speedo for Linda?
>
>Hmm.
>
>
>
>-Original Message-
>Sent: Wednesday, June 13, 2001 1:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ross,
>It looks like you may have to lose that speedo. I saw this in yesterday's
>newspaper.
>
>"The Warnaco Group filed for Chapter 11 bankruptcy protection yesterday,
>blaming the economy and its heavy debt load, among other things, for its
>problems.
>Under the leadership of Linda J. Wachner, the chief executive, Warnaco was
>transformed from a $590 million underwear maker to a diverse $2.25 billion
>apparel company with a dedicated following in stores and on the stock
>market.
>Brands like Speedo, Calvin Klein and Chaps by Ralph Lauren were part of the
>fold."
>
>Henry
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Henry Poras
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of maili

RE: Oracle 9i database for Linux available for download on Techne

[Terrian, Tom]

Speaking of which, I have not been able to get 9.0.1.0.0 to install on HPUX 11.
Has anyone gotten it to work?  I have a suspicion that it is for 32 bit instead
of 64 bit.

My download file sizes are:
disk1: 587,823,750
disk2: 647,038,861
disk3: 341,722,333

Are these the same sizes that the rest of you are getting.  (size does matter
:-)  )

Tom




-Original Message-
Sent: Thursday, June 14, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Techne


Waleed,

Believe it or not, I do know about gunzip. Uncompressed the file is 84MB, 
instead of 80MB. The files in the .cpio file seem to be java files, and I 
think that the contents of some of the directory structures listed in the 
cpio file are not there).

In any case, the size listed on the otn website is supposedly the size of 
the COMPRESSED file (and is, for files 1 and 2). It's only file 3 that 
downloads incorrectly

Rachel


>From: "Khedr, Waleed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle 9i database for Linux available for download on Techne
>Date: Thu, 14 Jun 2001 09:21:12 -0800
>
>   Try to uncompress it and if it works then it's the right size.
>
>Regards,
>
>Waleed
>
>-Original Message-
>Sent: Thursday, June 14, 2001 11:47 AM
>To: Multiple recipients of list ORACLE-L
>Technet
>
>
>has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads
>79+MB and says it's done.
>
>I tried both download sites (east and west) that I know of. Are there any
>others?
>
>Rachel
>
>
> >From: "Joe Raube" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle 9i database for Linux available for download on Technet
> >Date: Wed, 13 Jun 2001 20:25:48 -0800
> >
> >Enjoy
> >
> >
> >
> >_
> >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: Joe Raube
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(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
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

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

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

RE: Precise Insight/SQL/Pulse

[Henry Poras]

All I would add is that the last time I looked at Savant, I thought it was a
good product. It let you compare your current state with yesterday, last
week, last month, ... This was an easy way to measure changes. Unfortunately
this product was skewed heavily to using hit ratios and not wait events.

Henry

-Original Message-
Sent: Thursday, June 14, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L


Here is my assesment.

Pulse is very weak in terms of dba monitoring.  They rebound this with the
ability to add up to 20 custom packages.
I think I/Watch is a MUCH better product for this.  With them (Precise)
buying Savant I suspect Q Diagnostics (Great package minus notification) and
Pulse with be joined into a single more marketable product.

Precise SQL is a great product and more mature than SQL Lab Vision Expert.
But with the new version of Expert (As of Oct 2000) it does what Precise SQL
does.  Both are great products, I tend to like SQL Lab better as it has the
tuning expert included, which Precise SQL has really weak one.  I also like
the grouping and quering better on SQL statements in SQL Lab vision.
Precise SQL does have a better repository for old statements to do trend
analysis on.  Both products are great, and both companies have a strong ear
from Oracle directly in terms of support or and backing.  In short, I think
SQL Lab Vision is a more fuller product.

I have never played with Precise Insight or SQL Impact.  I heard these are
good products, but I have nothing to offer on them.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, June 14, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L


We are thinking of possibly purchasing the Precise Insight, SQL and
Pulse products.   Has anyone had any very good or very bad experiences
with these products?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

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

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

[Smith, Ron L.]

Sorry, too many lists!
Ron

-Original Message-
Sent: Thursday, June 14, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L


Our security group delete the Guest account from the NT server.  Now SQLMail
does not work.If we add Guest back to the server SQLMail still doesn't work.
What is the security loophole with the Guest account?  Can another account
be used for SQLMAil?  Should we be able to just add the Guest account back
to NT and SQLMAil should work?

Ron Smith
Database Administrator
[EMAIL PROTECTED] 


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

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

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

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

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

IBM creates it's own "9i" ?

[Ron Rogers]

I received this update today about IBM creating a database release that is suppose to 
be SMART and self tuning. Was Oracle one step ahead or was there a leak at IBM?
==

"IBM looks to get SMART with DB2 7.2"

Self-managing and resource tuning (SMART) features, deep integration
with the WebSphere application server and "autonomic computing"
technologies, lead the list of highlights IBM is pointing to in the
newest release of its DB2 Universal Database. Jeff Jones, IBM's
senior program manager of data management solutions, discusses DB2
7.2, IBM's strategy in the database market and the details of the
Informix deal, in the first of a two-part question-and-answer
interview with searchDatabase.

SOURCE:  searchDatabase.com
http://www.searchdatabase.com/qna/0,289202,sid13_gci740063,00.html

==
ROR mô¿ôm

--
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: Precise Insight/SQL/Pulse

[Christopher Spence]

Here is my assesment.

Pulse is very weak in terms of dba monitoring.  They rebound this with the
ability to add up to 20 custom packages.
I think I/Watch is a MUCH better product for this.  With them (Precise)
buying Savant I suspect Q Diagnostics (Great package minus notification) and
Pulse with be joined into a single more marketable product.

Precise SQL is a great product and more mature than SQL Lab Vision Expert.
But with the new version of Expert (As of Oct 2000) it does what Precise SQL
does.  Both are great products, I tend to like SQL Lab better as it has the
tuning expert included, which Precise SQL has really weak one.  I also like
the grouping and quering better on SQL statements in SQL Lab vision.
Precise SQL does have a better repository for old statements to do trend
analysis on.  Both products are great, and both companies have a strong ear
from Oracle directly in terms of support or and backing.  In short, I think
SQL Lab Vision is a more fuller product.

I have never played with Precise Insight or SQL Impact.  I heard these are
good products, but I have nothing to offer on them.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, June 14, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L


We are thinking of possibly purchasing the Precise Insight, SQL and
Pulse products.   Has anyone had any very good or very bad experiences
with these products?

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

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

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

Maintaining Redo Logs

[Post, Ethan]

If you will kindly download and review my .PPT slides for section 7 of of
the much slandered OCP exam (#2) for professional peer review.  I will be
greatly appreciative.  Please send your recommends to me offline unless you
think the discussion is worthy of public comment.  

http://www.freetechnicaltraining.com/docs/07_Maintaining_Redo_Log_Files.zip
(157 K - 47 Slides)

Thanks,
Ethan Post

 

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

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

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

[Michael S. Siebert]

Try patch 1711240 for getting from 8.1.7.0 to 8.1.7.1 and then patch 1797438 to get 
from
8.1.7.1 to 8.1.7.1.3.  I know I found them on MetaLink, so if I recall the navigation 
I'll
let you know.

HTH,
Mike

"Solomon, Saul M." wrote:

> Paul,
>
> But where is this patchset. It's not on Metalink or the ftp sites.
>
> Saul Solomon
> PPG Industries
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, June 13, 2001 10:06 AM
> To: Multiple recipients of list ORACLE-L
>
> "O'Neill, Sean" wrote:
> >
> > I'm trying to configure systems to shutdown immediate Oracle when NT server
> > is shutdown.  I've followed instructions in Admin manual for registry
> > settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to
> > work.  Oracle does crash recovery when PC [NT4-SP6a] is bounced.  Current
> > registry settings are:
> > ora_DBATest_shutdown = TRUE
> > ora_DBATest_shutdowntype = i
> > ora_DBATest_shutdown_timeout = 30
> >
> > I'd like to get this working for the following versions of Oracle on our
> > production NT servers.  Maybe a patch set is required, is so I'd appreciate
> > patch set ID.  If it can't be done for particular version please let me
> > know.
> > 7.3.3.0.0
> > 8.0.5.0.0
> > 8.1.7.0.0
> >
> > I could spend a "while" trying to look all this up on MetaLink but if anyone
> > has "been there" would appreciate your input!
> >
> > Sean :)
> >
>
> Sean,
>
> this is for 8.1.7.1.2
>
> HKLM\Software\Oracle\Home0
>
> Value 3
>   Name:ORA_DEV_AUTOSTART
>   Type:REG_EXPAND_SZ
>   Data:TRUE
>
> Value 4
>   Name:ORA_DEV_PFILE
>   Type:REG_EXPAND_SZ
>   Data:D:\Oracle\admin\DEV\pfile\initDEV.ora
>
> Value 5
>   Name:ORA_DEV_SHUTDOWN
>   Type:REG_EXPAND_SZ
>   Data:TRUE
>
> Value 6
>   Name:ORA_DEV_SHUTDOWN_TIMEOUT
>   Type:REG_EXPAND_SZ
>   Data:180  << 30 seconds is not 
>sufficient
>
> Value 7
>   Name:ORA_DEV_SHUTDOWNTYPE
>   Type:REG_EXPAND_SZ
>   Data:i
>
> Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2
> for 6 weeks.
>
> Paul
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Solomon, Saul M.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Solutions Consulting, LLC
a Perot Systems Company
http://www.SolutionsConsulting.com
http://www.PerotSystems.com

phone: 513.891.3423 ext. 7010
fax:   513.891.3775
email: [EMAIL PROTECTED]


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

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

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

[Tirumala, Surendra]

Ivan, here it is,  hth, suren

-Original Message-


Sent: Wednesday, June 06, 2001 10:32 AM

To: Multiple recipients of list ORACLE-L


 

Just to add

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

for Johnathan Lewis's excellent site

Cheers

Connor

--- Christopher Spence <[EMAIL PROTECTED]> wrote: >

This list is by far incomplete, but it is the links

> i have on my site

> currently.

> I have about 50-100 different sites, I only put the

> ones I most frequently

> use or like on my site.

> I am going to go through the rest and finishing

> adding links as well. I

> left out some good ones here I know, but my list is

> currently at home not

> here as I just cleaning up my machine.

> 

> IXOra.com (Steve Adam's Site) 

> http://ixora.com.au/

> 

> 

> Oracle Technet

> http://technet.oracle.com

> 

> 

> OraPub (Craig Shallahamer's Website)

> www.orapub.com

> 

> 

> DBA Support

> http://www.dbasupport.com/

> 

> 

> Thomas Kyte's Website

> http://osi.oracle.com/~tkyte/

> 

> 

> Connor McDonald's Web Site

> http://www.oracledba.co.uk/

> 

> 

> Hotsos (Cary Millsap's Site)

> www.hotsos.com

> 

> 

> Jared Still's Website

> http://www.cybcon.com/~jkstill/util/util_master.html

> 

> 

> Thomas Cox's Website

> http://www.geocities.com/tbcox23/

> 

> 

> Evergreen Database Technologies

> http://www.evdbt.com/

> 

> 

> Biju's Web Site

> http://www.bijoos.com/oracle/index.htm

> 

> 

> OraBugFinder

>

http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html

> 

> Vampire D's Oracle Den (Christopher R. Spence's

> Site)

> www.vampired.net 

-Original Message-
Sent: Thursday, June 14, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L



Greeting to all, 

My machine got totally hosed and I need to rebuild a new one.  I recall a
little while back there was a post with a bunch of links to good dba sites.
Can someone please send this to me? Thank you very much. Ivan

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

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

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

[lhoska]

FYI,
I am on the list and not on newsgroup and I did not receive that message.
Another clue:  I had joined just recently so it might've been some time ago
some one got a hold of the list..

-Original Message-
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

->FYI,
->
->I got one of these at home, but not at work.
->
->At home I have logged into the oracle.server newsgroup, but never Jared's
->list.
->
->At work I subscribe to Jared's list, but never went to the newsgroup.
->
->This tells me that unless I received the e-mail at work as well and didn't
->notice, our addresses were lifted off the newsgroup and not this list.
->
->Another reason why I don't like newsgroups all that much.

except i got 2 and never go to the newsgroup.;-) but i did go to lazyDBA for
a few hours.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

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

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

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

[Yosi Greenfield]

Ken,

Welcome to the club. Are we starting a trend? At least
we're not competing against each other.

Good luck,

Yosi

[EMAIL PROTECTED] wrote:

> I need some help.  I was an Oracle DBA with ADC Telecomm
> in Minnesota and was laid off along with 7,000 other ADC
> employees.  The job market here in the TC’s has been
> very slow.
>
> Any assistance finding another Oracle related position
> would be greatly appreciated. Please contact me directly
> at [EMAIL PROTECTED]
>
> Relocation from the Mpls / St. Paul, MN is not an option.
>
> Thanks much,
>
> 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).

--
Thanks,

Yosi


-
Yosi Greenfield
Database Architect
Comhill Systems, Inc.
[EMAIL PROTECTED]


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 9i database for Linux available for download on Technet

[Rachel Carmichael]

It unzipped cleanly and the cpio reported no errors so I believe you are 
correct. I hope you are correctly I want to play with this puppy


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle 9i database for Linux available for download on Technet
>Date: Thu, 14 Jun 2001 09:08:55 -0800
>
>
>
>Coincidentally, when you open  Disk3 in Winzip the 'packed' size is almost
>exactly a tenth of the size reported on the TechNet site.
>I think someone put an extra "5" on the end of the size on the web page.
>I haven't tried to use it yet though. It's being burned to CD right now.
>
>Regards,
>Mike Hately,
>Oracle DBA
>
>
>--
>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).

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

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

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

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

OT RE: Speedo be gone

[Rachel Carmichael]

uh uh, I'm not contributing to that fund, I want to see him lose that Speedo 



>From: "Norrell, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Speedo be gone
>Date: Thu, 14 Jun 2001 09:13:49 -0800
>
>I propose a fund to purchase and FedEx a towel to Ross before he loses his
>Speedo.  Let's try to maintain some level of decorum.
>
>Brian Norrell
>Manager, MPI Development
>QuadraMed
>511 E John Carpenter Frwy, Su 500
>Irving, TX 75062
>(972) 831-6600
>
>
>-Original Message-
>Sent: Thursday, June 14, 2001 10:23 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Henry,
>
>Are you suggesting I lose my speedo for Linda?
>
>Hmm.
>
>
>
>-Original Message-
>Sent: Wednesday, June 13, 2001 1:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ross,
>It looks like you may have to lose that speedo. I saw this in yesterday's
>newspaper.
>
>"The Warnaco Group filed for Chapter 11 bankruptcy protection yesterday,
>blaming the economy and its heavy debt load, among other things, for its
>problems.
>Under the leadership of Linda J. Wachner, the chief executive, Warnaco was
>transformed from a $590 million underwear maker to a diverse $2.25 billion
>apparel company with a dedicated following in stores and on the stock
>market.
>Brands like Speedo, Calvin Klein and Chaps by Ralph Lauren were part of the
>fold."
>
>Henry
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Henry Poras
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

-- 
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: Oracle 9i database for Linux available for download on Techne

[Rachel Carmichael]

Waleed,

Believe it or not, I do know about gunzip. Uncompressed the file is 84MB, 
instead of 80MB. The files in the .cpio file seem to be java files, and I 
think that the contents of some of the directory structures listed in the 
cpio file are not there).

In any case, the size listed on the otn website is supposedly the size of 
the COMPRESSED file (and is, for files 1 and 2). It's only file 3 that 
downloads incorrectly

Rachel


>From: "Khedr, Waleed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle 9i database for Linux available for download on Techne
>Date: Thu, 14 Jun 2001 09:21:12 -0800
>
>   Try to uncompress it and if it works then it's the right size.
>
>Regards,
>
>Waleed
>
>-Original Message-
>Sent: Thursday, June 14, 2001 11:47 AM
>To: Multiple recipients of list ORACLE-L
>Technet
>
>
>has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads
>79+MB and says it's done.
>
>I tried both download sites (east and west) that I know of. Are there any
>others?
>
>Rachel
>
>
> >From: "Joe Raube" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle 9i database for Linux available for download on Technet
> >Date: Wed, 13 Jun 2001 20:25:48 -0800
> >
> >Enjoy
> >
> >
> >
> >_
> >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: Joe Raube
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(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
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

Latch 'parallel query qref latch'

[Ben Jones]

Does anyone know what causes waits on this latch ?

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

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

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

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

[Toepke, Kevin M]

I haven't been able to recreate it in development yet...will let you know if
i can.

-Original Message-
Sent: Thursday, June 14, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L


Kevin,

It would be very interesting to know if when you have
the explain plan doing the sort/merge if setting
num_rows to the integer value of the current num_rows 
(using dbms_stats, see note 130899.1) causes the
explain plan to change to N/L.  

-- Anita


--- "Toepke, Kevin M" <[EMAIL PROTECTED]> wrote:
> Anita:
> 
> I am saying that sometimes when the num_rows is not
> an integer oracle will
> sort/merge join 2 multi-million row tables when a
> nested-loop join will
> return much quicker. If a compute stats is done (or
> an estimate stats
> returns integer values for the num_rows) then the
> optimzer chooses the
> nested-loops join.
> 
> I've been going through the bugs database and it
> appears that this may be
> related to several other bugs that seem to hint at
> Oracle 8 and 8i
> excessively choosing the sort/merge join operation.
> 
> Kevin
> 
> -Original Message-
> Sent: Thursday, June 14, 2001 4:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Kevin,
> 
> You might want to check out bug 1540560 "ANALYZE
> TABLE
> ESTIMATE STATISTICS NOT ROUNDING VALUE FOR NUM_ROWS"
> closed as "not a bug."
> 
> Are you saying that the CBO produces a different
> explain plan for a table with NUM_ROWS = 500.25
> vs. NUM_ROWS= 500?  This would definitely be a
> bug
> and should be fairly easy to reproduce since one can
> use DBMS_STATS to set a specific value.
> 
> HTH,
> 
> -- Anita
> 
> 
> --- "Toepke, Kevin M" <[EMAIL PROTECTED]>
> wrote:
> > That's what the doc says. However, at least with
> > Oracle 8.0.5 through
> > 8.1.7.2.0 on Solaris, if you do not explictily
> > compute statistics, the
> > NUM_ROWS column in DBA_TABLES and DBA_INDEXES has
> a
> > decimal value. (yup the
> > table has 32.345 rows in it.)
> > 
> > This may not seem like a big deal until you try to
> > tune the queries that
> > reference these tables/indexes. Man, do the
> > exectution plans get screwed up
> > (how about a FTS against a 5million row table in a
> > nested-loops operation!)
> > 
> > I've submitted a TAR on this and am "working with"
> > Oracle support.
> > 
> > Kevin
> > 
> > -Original Message-
> > Sent: Wednesday, June 13, 2001 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > On Tuesday 12 June 2001 15:05, Kevin Kostyszyn
> > wrote:
> > > Couldn't you try and estimate about 50% of it? 
> > It's not as reliable, but
> > > it would probably work.
> > 
> > Actually, Oracle will do a 'compute statistics'
> when
> > you attempt to do
> > an 'estimate statistics' on 50% or more.
> > 
> > Jared
> > -- 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Toepke, Kevin M
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> __
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.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 spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Toepke, Kevin M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

RE: list of good links

[Bala, Prakash]

IXOra.com (Steve Adam's Site)

http://ixora.com.au/

Oracle Technet

http://technet.oracle.com

OraPub (Craig Shallahamer's Website)

www.orapub.com

DBA Support

http://www.dbasupport.com/

Thomas Kyte's Website

http://osi.oracle.com/~tkyte/

Connor McDonald's Web Site

http://www.oracledba.co.uk/

Hotsos (Cary Millsap's Site)

www.hotsos.com

Jared Still's Website

http://www.cybcon.com/~jkstill/util/util_master.html

Thomas Cox's Website

http://www.geocities.com/tbcox23/

Evergreen Database Technologies

http://www.evdbt.com/

OraBugFinder

http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html

Vampire D's Oracle Den (Christopher R. Spence's Site)

www.vampired.net

Johnathan Lewis's excellent site

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

Lazy DBA

www.lazydba.com

DBA Village

www.dba-village.com

UK Oracle Users Group

www.ukoug.co.uk

K Gopalakrishnan's site

http://www.geocities.com/kgkrish

http://www.oraclenotes.com/

http://www.orafaq.org

http://www.oracle-dba.com

http://www.orafans.com

http://www.oracle-users.com

http://www.oracleguru.com

http://www.oramag.com/

http://www.oraperf.com/

http://www.oraxcel.com

PAPERS-

"Oracle Performance and Tuning: Overview"

http://pillango.sirma.bg/oracle/N014_p%26t_overview.pdf

"Performance Tuning - Now You are the V8 Expert"

http://pillango.sirma.bg/oracle/N023_tun_all.doc

"Identifying Resource Intensive SQL in a production environment" -

http://pillango.sirma.bg/oracle/N026_tuning2.pdf

"Database Tuning Methodology" -

http://pillango.sirma.bg/oracle/N027_DB_Tune.doc

"SQL Tuning for the Oracle DBA" -

http://pillango.sirma.bg/oracle/N050_tuning.pdf

"Practical Tuning Advice for the Oracle8 DBA" -

http://pillango.sirma.bg/oracle/N064_tuning.pdf

"Finding the Performance Bottlenecks in Your Application" -

http://pillango.sirma.bg/oracle/N067_performance.pdf

"Inside the Oracle Cost Based Optimizer" -

http://pillango.sirma.bg/oracle/N080_optimizer.doc

"Seven Deadly SQL Traps and How to Avoid Them" -

http://pillango.sirma.bg/oracle/N082_tuning.doc

"Secrets of SQL and Application Tuning" -

http://pillango.sirma.bg/oracle/N108_tuning.doc

"Oracle DBA Checklist"

http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf

"DBA101: A Refresher Course"

http://pillango.sirma.bg/oracle/N092_dba.doc

Thomas Cox's DBA Checklist.

http://www.geocities.com/tbcox23/dba_checklist13.doc

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

for Johnathan Lewis's excellent site

-Original Message-
Sent: Thursday, June 14, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L



Greeting to all, 

My machine got totally hosed and I need to rebuild a new one.  I recall a
little while back there was a post with a bunch of links to good dba sites.
Can someone please send this to me? Thank you very much. Ivan

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

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

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

Security delete the Guest account - Help!

[Smith, Ron L.]

Our security group delete the Guest account from the NT server.  Now SQLMail
does not work.If we add Guest back to the server SQLMail still doesn't work.
What is the security loophole with the Guest account?  Can another account
be used for SQLMAil?  Should we be able to just add the Guest account back
to NT and SQLMAil should work?

Ron Smith
Database Administrator
[EMAIL PROTECTED] 


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

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

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

[Norrell, Brian]

I propose a fund to purchase and FedEx a towel to Ross before he loses his
Speedo.  Let's try to maintain some level of decorum.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Thursday, June 14, 2001 10:23 AM
To: Multiple recipients of list ORACLE-L


Henry, 

Are you suggesting I lose my speedo for Linda?

Hmm.



-Original Message-
Sent: Wednesday, June 13, 2001 1:13 PM
To: Multiple recipients of list ORACLE-L


Ross,
It looks like you may have to lose that speedo. I saw this in yesterday's
newspaper.

"The Warnaco Group filed for Chapter 11 bankruptcy protection yesterday,
blaming the economy and its heavy debt load, among other things, for its
problems.
Under the leadership of Linda J. Wachner, the chief executive, Warnaco was
transformed from a $590 million underwear maker to a diverse $2.25 billion
apparel company with a dedicated following in stores and on the stock
market.
Brands like Speedo, Calvin Klein and Chaps by Ralph Lauren were part of the
fold."

Henry

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 9i database for Linux available for download on Technet

[Robin Ilardi]

So far my download is at 296mb out of 393mb(for the first download file) and
it's still going.

robin


-Original Message-
Carmichael
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Technet


has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads
79+MB and says it's done.

I tried both download sites (east and west) that I know of. Are there any
others?

Rachel


>From: "Joe Raube" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i database for Linux available for download on Technet
>Date: Wed, 13 Jun 2001 20:25:48 -0800
>
>Enjoy
>
>
>
>_
>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: Joe Raube
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

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

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


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

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

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

[Valiveru, Siva]

All, 
Can some there PLEASE clarify this question.. 

what is the corelation between "user calls" in the statspack report to
number of sql's executed during the timeframe..

This is what i am doing please correct me !!

We are trying to capture the total number of sql's calls during two time
events (say t1, t2), what i was doing to take the snapshot report and copy
of the v$sqlarea at t1 & t2. 

1) the sum of total number of executions from two V$sqlarea tables at t1 and
t2 should be the total sql's excecuted. right ??

2) what way the figure at step1  is releated to the "user calls" in the
statspack report for difference of t1 and t2. 

*** Is there any other method do u suggest to capture number of sql's
application is throwing during a timeframe. 

Thanks, 

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

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

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

[Mercadante, Thomas F]

"Fixed" is a subjective term.

This error has come and gone for the last couple of months.

I wouldn't consider it "fixed" until it does not re-appear for a year.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, June 14, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


fixed as of 10:23am EST.


---

TheOracleDBA
[EMAIL PROTECTED]



On Thu, 14 Jun 2001 07:23:17  
 Orr, Steve wrote:
>Here's what I just got logging in to MetaLink...
>
>Thu, 14 Jun 2001 14:12:33 GMT
>
>ORA-04031: unable to allocate 2550012 bytes of shared memory ("large
>pool","unknown object","session heap","bind var buf")
>
>  DAD name: plsql
>  PROCEDURE  : per_hom.startup
>  USER   : mrorracle
>  URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup
>  PARAMETERS :
>  
>
>  ENVIRONMENT:
>  
>PLSQL_GATEWAY=WebDb
>GATEWAY_IVERSION=2
>SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix)
>ApacheJServ/1.1 mod_perl/1.24
>GATEWAY_INTERFACE=CGI/1.1
>SERVER_PORT=80
>SERVER_NAME=metalink.oracle.com
>REQUEST_METHOD=GET
>QUERY_STRING=
>PATH_INFO=/metalink/plsql/per_hom.startup
>SCRIPT_NAME=/metalink
>REMOTE_HOST=
>REMOTE_ADDR=12.110.24.85
>SERVER_PROTOCOL=HTTP/1.1
>REQUEST_PROTOCOL=HTTP
>REMOTE_USER=
>HTTP_CONTENT_LENGTH=
>HTTP_CONTENT_TYPE=
>HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
>HTTP_HOST=metalink.oracle.com
>HTTP_ACCEPT=*/*
>HTTP_ACCEPT_ENCODING=gzip, deflate
>HTTP_ACCEPT_LANGUAGE=en-us
>HTTP_ACCEPT_CHARSET=
>HTTP_IF_MODIFIED_SINCE=
>HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/ml2_gui.startup
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Orr, Steve
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


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: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: DB shutdown - NT

[Solomon, Saul M.]

Paul,

But where is this patchset. It's not on Metalink or the ftp sites.

Saul Solomon
PPG Industries
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 13, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L


"O'Neill, Sean" wrote:
> 
> I'm trying to configure systems to shutdown immediate Oracle when NT server
> is shutdown.  I've followed instructions in Admin manual for registry
> settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to
> work.  Oracle does crash recovery when PC [NT4-SP6a] is bounced.  Current
> registry settings are:
> ora_DBATest_shutdown = TRUE
> ora_DBATest_shutdowntype = i
> ora_DBATest_shutdown_timeout = 30
> 
> I'd like to get this working for the following versions of Oracle on our
> production NT servers.  Maybe a patch set is required, is so I'd appreciate
> patch set ID.  If it can't be done for particular version please let me
> know.
> 7.3.3.0.0
> 8.0.5.0.0
> 8.1.7.0.0
> 
> I could spend a "while" trying to look all this up on MetaLink but if anyone
> has "been there" would appreciate your input!
> 
> Sean :)
> 

Sean,

this is for 8.1.7.1.2

HKLM\Software\Oracle\Home0

Value 3
  Name:ORA_DEV_AUTOSTART
  Type:REG_EXPAND_SZ
  Data:TRUE
 
Value 4
  Name:ORA_DEV_PFILE
  Type:REG_EXPAND_SZ
  Data:D:\Oracle\admin\DEV\pfile\initDEV.ora
 
Value 5
  Name:ORA_DEV_SHUTDOWN
  Type:REG_EXPAND_SZ
  Data:TRUE
 
Value 6
  Name:ORA_DEV_SHUTDOWN_TIMEOUT
  Type:REG_EXPAND_SZ
  Data:180  << 30 seconds is not sufficient
 
Value 7
  Name:ORA_DEV_SHUTDOWNTYPE
  Type:REG_EXPAND_SZ
  Data:i

Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2
for 6 weeks.

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

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

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

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

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

Need Help

[kjanusz]

I need some help.  I was an Oracle DBA with ADC Telecomm 
in Minnesota and was laid off along with 7,000 other ADC 
employees.  The job market here in the TC’s has been 
very slow.  

Any assistance finding another Oracle related position 
would be greatly appreciated. Please contact me directly 
at [EMAIL PROTECTED]

Relocation from the Mpls / St. Paul, MN is not an option.

Thanks much,

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: Invalid views

[JOE TESTA]

Why not just use(8.1.7 thing)
 
$ORACLE_HOME/rdbms/admin/utlrp.sql
 
joe
 
 
 
 
>>> [EMAIL PROTECTED] 06/14/01 11:47AM >>>Perfect 
timing.  I was putting togeter some recompile scripts for work.Here is 
a modified one that can be used for views.   With a few changes 
itcan be used to recompile any invalid object.1. Create a cursor 
on the Catalog Table ALL_OBJECTS where OBJECT_TYPE ='VIEW' and STATUS = 
'INVALID'.2. Step thru that Cursor and use the DBMS_SQL calls to 
compile.  create or replace Procedure  Recompile_Views 
Is    Cursor cur_objects Is  
Select owner  
, 
object_name  From 
dba_objects  Where object_type = 
'VIEW'    and status = 
'INVALID';    current_cursor  
Integer;    dummy_var   
Integer;    cur_objects_rec  
cur_objects%ROWTYPE;    
Begin  
dbms_output.enable(2);  For cur_objects_rec 
In cur_objects  
Loopdbms_output.put_line(cur_objects_rec.owner||'.'||cur_objects_rec.object_name);    
Begin  current_cursor 
:= 
DBMS_SQL.OPEN_CURSOR;  
DBMS_SQL.PARSE (current_cursor, 'ALTER 
VIEW'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name||'compile',DBMS_SQL.NATIVE);  
dummy_var := DBMS_SQL.EXECUTE 
(current_cursor);  
DBMS_SQL.CLOSE_CURSOR(current_cursor);    
Exception  When 
Others  
Then    
DBMS_SQL.CLOSE_CURSOR(current_cursor);    
dbms_output.put_line('Unable to 
compile'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name);    
End;  End Loop;    
End;This code does work, you just have to make sure you have the 
correctauthority on DBA_OBJECTS.   Make sure the compile is 
granted select directlyon DBA_OBJECTS by 
SYS.Kevin-Original Message-Sent: Thursday, June 
14, 2001 2:36 AMTo: Multiple recipients of list ORACLE-LHallo 
all you DBA'sCan anyone help me with this?I would like to check 
if some views ar einvalid and then if there are Iwould like them to be 
compiled immediately .How can I write this in a pl/sql-procedure?Please 
give me some good examples, all you experts!Roland 
Sköldblom-- 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).--Please see the official ORACLE-L 
FAQ: http://www.orafaq.com--Author: 
Kevin Lange  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-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: Oracle 9i database for Linux available for download on Techne

[Khedr, Waleed]

  Try to uncompress it and if it works then it's the right size.

Regards,

Waleed

-Original Message-
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Technet


has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads 
79+MB and says it's done.

I tried both download sites (east and west) that I know of. Are there any 
others?

Rachel


>From: "Joe Raube" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i database for Linux available for download on Technet
>Date: Wed, 13 Jun 2001 20:25:48 -0800
>
>Enjoy
>
>
>
>_
>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: Joe Raube
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

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

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

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

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

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

list of good links

[Ivan_Rivera]

Title: list of good links





Greeting to all,


My machine got totally hosed and I need to rebuild a new one.  I recall a little while back there was a post with a bunch of links to good dba sites. Can someone please send this to me? Thank you very much. Ivan

RE: Invalid views

[Kevin Lange]

Joe;
  For those of us not on 
8.1.7 ..  
 
Besides .. I had no idea that 
was there.

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 10:55 
  AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE: 
  Invalid views
  Why not just use(8.1.7 thing)
   
  $ORACLE_HOME/rdbms/admin/utlrp.sql
   
  joe
   
   
   
   
  >>> [EMAIL PROTECTED] 06/14/01 11:47AM >>>Perfect 
  timing.  I was putting togeter some recompile scripts for work.Here 
  is a modified one that can be used for views.   With a few changes 
  itcan be used to recompile any invalid object.1. Create a 
  cursor on the Catalog Table ALL_OBJECTS where OBJECT_TYPE ='VIEW' and 
  STATUS = 'INVALID'.2. Step thru that Cursor and use the DBMS_SQL calls to 
  compile.  create or replace Procedure  Recompile_Views 
  Is    Cursor cur_objects 
  Is  Select 
  owner  
  , 
  object_name  From 
  dba_objects  Where object_type = 
  'VIEW'    and status = 
  'INVALID';    current_cursor  
  Integer;    dummy_var   
  Integer;    cur_objects_rec  
  cur_objects%ROWTYPE;    
  Begin  
  dbms_output.enable(2);  For 
  cur_objects_rec In cur_objects  
  Loopdbms_output.put_line(cur_objects_rec.owner||'.'||cur_objects_rec.object_name);    
  Begin  current_cursor 
  := 
  DBMS_SQL.OPEN_CURSOR;  
  DBMS_SQL.PARSE (current_cursor, 'ALTER 
  VIEW'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name||'compile',DBMS_SQL.NATIVE);  
  dummy_var := DBMS_SQL.EXECUTE 
  (current_cursor);  
  DBMS_SQL.CLOSE_CURSOR(current_cursor);    
  Exception  When 
  Others  
  Then    
  DBMS_SQL.CLOSE_CURSOR(current_cursor);    
  dbms_output.put_line('Unable to 
  compile'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name);    
  End;  End Loop;    
  End;This code does work, you just have to make sure you have the 
  correctauthority on DBA_OBJECTS.   Make sure the compile is 
  granted select directlyon DBA_OBJECTS by 
  SYS.Kevin-Original Message-Sent: Thursday, 
  June 14, 2001 2:36 AMTo: Multiple recipients of list 
  ORACLE-LHallo all you DBA'sCan anyone help me with 
  this?I would like to check if some views ar einvalid and then if there 
  are Iwould like them to be compiled immediately .How can I write this 
  in a pl/sql-procedure?Please give me some good examples, all you 
  experts!Roland Sköldblom-- 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).--Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com--Author: Kevin 
  Lange  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-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: Oracle 9i database for Linux available for download on Technet

[MHately]

Coincidentally, when you open  Disk3 in Winzip the 'packed' size is almost
exactly a tenth of the size reported on the TechNet site.
I think someone put an extra "5" on the end of the size on the web page.
I haven't tried to use it yet though. It's being burned to CD right now.

Regards,
Mike Hately,
Oracle DBA


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

No Subject

[Libal, Ivo]

Hello
I have a problem with the reserved size of shared pool. It does not seam to
be used for packages even if I have big packages (200K).
Do you have an idea where the problem can be? Do I have to move the packages
somehow (like pin to shared pool)?
Regards
Ivo Libal

FREE_SPACE AVG_FREE_SIZE FREE_COUNT MAX_FREE_SIZE USED_SPACE  
-- - -- - -- -
-- - -- -- 
  13421772  13421772  1  13421772  0 0
0 0 


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

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

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

[Rachel Carmichael]

was that you I saw wandering by then? I wondered who the other human was :)


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Digestive
>Date: Thu, 14 Jun 2001 07:23:15 -0800
>
>I plan to buy something from the year I was born,
>but scotch did not exist then.
>
>In fact, agriculture had not been created. We were
>still wandering out, pulling berries off bushes,
>munching mint leaves, and harassing mastodons.
>
>-Original Message-
>Sent: Wednesday, June 13, 2001 1:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>Laphroiag is very very nice. I still prefer my Talisker and I have a 
>30-year
>old
>Glenfiddich at home that I'm working my way through VERY slowly.
>I plan to buy a bottle of something from the year I was born ( '67 ) but 
>the
>older I get, the more expensive they become.
>
>
>--
>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: 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).

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

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

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

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

Hey MetaLink... Got RAM?

[Orr, Steve]

Here's what I just got logging in to MetaLink...

Thu, 14 Jun 2001 14:12:33 GMT

ORA-04031: unable to allocate 2550012 bytes of shared memory ("large
pool","unknown object","session heap","bind var buf")

  DAD name: plsql
  PROCEDURE  : per_hom.startup
  USER   : mrorracle
  URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup
  PARAMETERS :
  

  ENVIRONMENT:
  
PLSQL_GATEWAY=WebDb
GATEWAY_IVERSION=2
SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix)
ApacheJServ/1.1 mod_perl/1.24
GATEWAY_INTERFACE=CGI/1.1
SERVER_PORT=80
SERVER_NAME=metalink.oracle.com
REQUEST_METHOD=GET
QUERY_STRING=
PATH_INFO=/metalink/plsql/per_hom.startup
SCRIPT_NAME=/metalink
REMOTE_HOST=
REMOTE_ADDR=12.110.24.85
SERVER_PROTOCOL=HTTP/1.1
REQUEST_PROTOCOL=HTTP
REMOTE_USER=
HTTP_CONTENT_LENGTH=
HTTP_CONTENT_TYPE=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
HTTP_HOST=metalink.oracle.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_ACCEPT_CHARSET=
HTTP_IF_MODIFIED_SINCE=
HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/ml2_gui.startup

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

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

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

Re: Oracle 9i database for Linux available for download on Technet

[Rachel Carmichael]

has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads 
79+MB and says it's done.

I tried both download sites (east and west) that I know of. Are there any 
others?

Rachel


>From: "Joe Raube" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i database for Linux available for download on Technet
>Date: Wed, 13 Jun 2001 20:25:48 -0800
>
>Enjoy
>
>
>
>_
>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: Joe Raube
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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

-- 
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: Hey MetaLink... Got RAM?

[Mustafa]

You would think that Oracle would provide you with a simplier "Server not
available" error or something, instead of providing you with an error stream
dump.  They (should) have DBA's there that should be getting those type of
messages and correcting them! 8-)

Defry

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 11:23 AM


> Here's what I just got logging in to MetaLink...
>
> Thu, 14 Jun 2001 14:12:33 GMT
>
> ORA-04031: unable to allocate 2550012 bytes of shared memory ("large
> pool","unknown object","session heap","bind var buf")
>
>   DAD name: plsql
>   PROCEDURE  : per_hom.startup
>   USER   : mrorracle
>   URL:
http://metalink.oracle.com:80/metalink/plsql/per_hom.startup
>   PARAMETERS :
>   
>
>   ENVIRONMENT:
>   
> PLSQL_GATEWAY=WebDb
> GATEWAY_IVERSION=2
> SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix)
> ApacheJServ/1.1 mod_perl/1.24
> GATEWAY_INTERFACE=CGI/1.1
> SERVER_PORT=80
> SERVER_NAME=metalink.oracle.com
> REQUEST_METHOD=GET
> QUERY_STRING=
> PATH_INFO=/metalink/plsql/per_hom.startup
> SCRIPT_NAME=/metalink
> REMOTE_HOST=
> REMOTE_ADDR=12.110.24.85
> SERVER_PROTOCOL=HTTP/1.1
> REQUEST_PROTOCOL=HTTP
> REMOTE_USER=
> HTTP_CONTENT_LENGTH=
> HTTP_CONTENT_TYPE=
> HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> HTTP_HOST=metalink.oracle.com
> HTTP_ACCEPT=*/*
> HTTP_ACCEPT_ENCODING=gzip, deflate
> HTTP_ACCEPT_LANGUAGE=en-us
> HTTP_ACCEPT_CHARSET=
> HTTP_IF_MODIFIED_SINCE=
> HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/ml2_gui.startup
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mustafa
  INET: [EMAIL PROTECTED]

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

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

[Thater, William]

On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:

->FYI,
->
->I got one of these at home, but not at work.
->
->At home I have logged into the oracle.server newsgroup, but never Jared's
->list.
->
->At work I subscribe to Jared's list, but never went to the newsgroup.
->
->This tells me that unless I received the e-mail at work as well and didn't
->notice, our addresses were lifted off the newsgroup and not this list.
->
->Another reason why I don't like newsgroups all that much.

except i got 2 and never go to the newsgroup.;-) but i did go to lazyDBA for a few 
hours.

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

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

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

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

[Deshpande, Kirti]

Hi,
If you are using Oracle8i, there is a way to do this.
Review the following post:

On Thu, 6 Jan 2000, Joseph Testa wrote:

> Why would you want to do that, well, i'm at a place where the developers 
> have the schema owner password but we DBAs(being retentitive as we
are)dont 
> want them to make any ddl changes.
> 
> 
> here are the steps:
> 
> Feel free to change the names to your liking
> 
> create user schema_control identified by 
> grant create any trigger to schema_control;
> 
> edit the 3 following triggers, changing the  to the schema
you 
> want to put the control on:
> 
> create or replace trigger create_control_trigger
> before create on .schema
> 
> begin
>   raise_application_error(-20001,'NO CREATE DDL ALLOWED');
> end;
> /
> 
> create or replace trigger drop_control_trigger
> before drop on .schema
> 
> begin
>   raise_application_error(-20001,'NO DROP DDL ALLOWED');
> end;
> /
> 
> create or replace trigger alter_control_trigger
> before alter on .schema
> 
> begin
>   raise_application_error(-20001,'NO ALTER DDL ALLOWED');
> end;
> /
> 
> 
> revoke alter any trigger from ;
> 
> the previous line is needed so they dont alter the trigger to disable it
:)
> 
> the next time they attempt to create, drop or alter anything in that
schema 
> they get error msg.
> 
> This all assumes they are not dba :)
> 
> hht, joe
> 


Regards,

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

> -Original Message-
> From: Brijesh Satdev [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 14, 2001 12:11 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Product user profile & 3rd patry product
> 
> Hi all,
> 
> We have a third party product namely a drafting utility called
> microstation
> which requires connectivity to some schema in the  database.
> 
> It is neccesary for the database user to have create table system
> priviledge, but I want to restrict end users from deleting tables from
> this
> schema through microstation (there is a in built sql editor in
> microstation).
> 
> I checked the product_user_profile table and it only seems to work for
> Sql*plus.
> 
> Is there some other way to control the situation, as this poses a very
> high
> security risk for the database.
> 
> I appreciate your time and effort.
> 
> Regards,
> Brijesh.
> DBA Rolta India Ltd.
> OCP Oracle8 DBA.
> 
> -- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: Invalid views

[Kevin Lange]

Perfect timing.  I was putting togeter some recompile scripts for work.
Here is a modified one that can be used for views.   With a few changes it
can be used to recompile any invalid object.


1. Create a cursor on the Catalog Table ALL_OBJECTS where OBJECT_TYPE =
'VIEW' and STATUS = 'INVALID'.
2. Step thru that Cursor and use the DBMS_SQL calls to compile.

  create or replace Procedure  Recompile_Views Is
Cursor cur_objects Is
  Select owner  ,
 object_name
  From dba_objects
  Where object_type = 'VIEW'
and status = 'INVALID';

current_cursor  Integer;
dummy_var   Integer;
cur_objects_rec  cur_objects%ROWTYPE;

Begin
  dbms_output.enable(2);
  For cur_objects_rec In cur_objects
  Loop
 
dbms_output.put_line(cur_objects_rec.owner||'.'||cur_objects_rec.object_name
);
Begin
  current_cursor := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE (current_cursor, 'ALTER VIEW
'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name||'
compile',DBMS_SQL.NATIVE);
  dummy_var := DBMS_SQL.EXECUTE (current_cursor);
  DBMS_SQL.CLOSE_CURSOR(current_cursor);
Exception
  When Others
  Then
DBMS_SQL.CLOSE_CURSOR(current_cursor);
dbms_output.put_line('Unable to compile
'||cur_objects_rec.owner||'.'||cur_objects_rec.object_name);
End;
  End Loop;
End;


This code does work, you just have to make sure you have the correct
authority on DBA_OBJECTS.   Make sure the compile is granted select directly
on DBA_OBJECTS by SYS.

Kevin


-Original Message-
Sent: Thursday, June 14, 2001 2:36 AM
To: Multiple recipients of list ORACLE-L


Hallo all you DBA's

Can anyone help me with this?

I would like to check if some views ar einvalid and then if there are I
would like them to be compiled immediately .
 How can I write this in a pl/sql-procedure?
Please give me some good examples, all you experts!

Roland Sköldblom


-- 
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 Lange
  INET: [EMAIL PROTECTED]

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

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

RE: Speedo be gone

[Mohan, Ross]

Henry, 

Are you suggesting I lose my speedo for Linda?

Hmm.



-Original Message-
Sent: Wednesday, June 13, 2001 1:13 PM
To: Multiple recipients of list ORACLE-L


Ross,
It looks like you may have to lose that speedo. I saw this in yesterday's
newspaper.

"The Warnaco Group filed for Chapter 11 bankruptcy protection yesterday,
blaming the economy and its heavy debt load, among other things, for its
problems.
Under the leadership of Linda J. Wachner, the chief executive, Warnaco was
transformed from a $590 million underwear maker to a diverse $2.25 billion
apparel company with a dedicated following in stores and on the stock
market.
Brands like Speedo, Calvin Klein and Chaps by Ralph Lauren were part of the
fold."

Henry

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

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

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

RE: SMP/MPP and PQO

[Mohan, Ross]

:)
 
Yea, 
it was me.
 
 
heh 
heh

  -Original Message-From: Henry Poras 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 1:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  SMP/MPP and PQO
  Oh 
  oh. Ross, were you the one who initially recommended this? Did I follow your 
  advice? Who knew. 
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:19 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
SMP/MPP and PQO
I 
think it was just updated, too. 
 
Great book.

  -Original Message-From: Henry Poras 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: SMP/MPP and PQO
  Lisa,
  If you are interested in more detail on the 
  differences between SMP, NUMA, and clusters, there is a great book "In 
  search of clusters". It's one of the best technical books I've read. I 
  can't remember the author's name, but maybe another list member can help. 
  I picked it up because someone else on the list recomended it a while 
  ago.
   
  Henrh
  
-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 
Tuesday, June 12, 2001 12:48 PMTo: Multiple recipients of 
list ORACLE-LSubject: Re: SMP/MPP and 
PQOHi Lisa 
        SMP - 
In SMP many CPUs share the same memory. Typical example would be E450, 4 
processors, 4GB memory. Only L2 cache in the CPUs need to be 
co-ordinated when a memory buffer is changed or intended to 
change.       
  MPP - In MPP each CPU has its own memory and its own disks that 
they control (typically). An example would be nCUBE or IBM RS6000, where 
each processor runs its own OS and messaging is used heavily to 
coordinate the access to the resources.         NUMA - Nun -uniform memory access - 
Group of CPUs share the same memory and the messaging is used between 
the group of the CPUs to coordinate the access to the resource. An 
example would be Sequent NUMA-Q, where there are multiple quads and each 
quad has 4 cpus and 2GB memory (typically) and IQ-link coordinates the 
access to the resources between the quads. HP has ccNUMA for 
this.       
  Now, I don't think, E10k domain would qualify for a MPP, since 
there is no coordination or access restrictions between the domains ( at 
least that I know of). Each domain can manipulate its own disk / memory 
/devices without any messaging between the domains, in a non-clustered 
environment.     
        
    PQ architecture splits the FTS or long running operations 
on non-partitioned tables, in to multiple chunks based upon the rowid 
ranges. It is not a simple split though. First, work is divided in to 
degree of parallelism. For example, if the QC process determines that it 
has to scan 100,000 blocks and parallelism is determined as 4 then 25000 
would be the split. But not all 25000 block is handed over to the slave 
processes. QC uses 9/13 rule. QC hands over 9/13 of the work (i.e. 25000 
* 9/13=17307) blocks equally to the slave processes. When the slave 
processes finishes up the 9/13 work, then they get 3/13 of the work 
(25000 *3/13=5769) blocks and 1/13 of the work when the second set of 
3/13s are exhausted. This is done to evenly distribute the load. For 
example, there could data skew such that one process could finish up its 
9/13 work much faster than other processes and hence those processes can 
take up the rema! in! ! ing work.         The suitability of PQO parallelism 
should be defined by IO sub system in conjunction with CPU power. If you 
have many spindles in  2 cpu server my take on it would be to use 
parallelism of 2 to4 depending upon the cpu clock speed, disk speed, 
memory etc..     
    ThanksRiyaj 
"Re-yas" ShamsudeenCertified Oracle DBAi2 technologies   
www.i2.com 

  
  

"Koivu, Lisa" 
  <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
  06/12/01 09:17 AM Please respond to ORACLE-L 
        
        
    To:        Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]>         cc:   
                Subject:       
   SMP/MPP and PQOHello everyone, 
I was reading up on the differences 
between SMP, MPP and how they may affect PQO (Parallel 
Query). 
My understanding is that MPP is a 
host with defined domains (like an e10k with virtual machines on it). 
   

RE: Digestive

[Mohan, Ross]

I plan to buy something from the year I was born, 
but scotch did not exist then. 

In fact, agriculture had not been created. We were
still wandering out, pulling berries off bushes, 
munching mint leaves, and harassing mastodons. 

-Original Message-
Sent: Wednesday, June 13, 2001 1:13 PM
To: Multiple recipients of list ORACLE-L




Laphroiag is very very nice. I still prefer my Talisker and I have a 30-year
old
Glenfiddich at home that I'm working my way through VERY slowly.
I plan to buy a bottle of something from the year I was born ( '67 ) but the
older I get, the more expensive they become.


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

Fw: Is the list up?

[Ruth Gramolini]

After I sent the message I started receiving posts from the list.   Thanks
to all who replied.

Regards,
Ruth

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

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

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

RE: OT - RE: Digestive

[Wolfe, Charles]

IIRC, you can still get a cold Natty Boh at the O's new digs (Oriole Park at
Camden Yard), but they now also offer a variety of microbrews.

-Original Message-
Sent: Thursday, June 14, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L


So what do they serve at the new stadium in Balmer ("Baltimore")? I grew up
with the Orioles at Memorial Stadium. 

Die Hard Oriole Fan in Montana,
Steve Orr


-Original Message-
Sent: Wednesday, June 13, 2001 6:55 PM
To: Multiple recipients of list ORACLE-L


Well,  the G. Heileman  brewery in Balto was closed and put up for sale in
1996.  Since then, the National Bohemian trademark has been owned by Stroh's
and is currently owned by Pabst.  You can still get Natty Boh in Maryland,
but it is no longer brewed here.  Kinda like when Sam Adams Boston Lager
used to be brewed in Pittsburgh.

BTW, any Haffenreffer fans on the list.

Give me a good, home brewed Weissbier or IPA any day.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 8:05 PM


> Yup, that's it. Knew someone who swore by it instead of at it then someone
> slipped him a Bud and he couldn't tell the difference. Talk about lack of
> taste!! :-)
>
> Steve
>
>
> -Original Message-
> Sent: Wednesday, June 13, 2001 4:42 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Do you by any chance mean Natty Boh?
>
> -Original Message-
> Sent: Wednesday, June 13, 2001 6:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Do they still make "National" in the state of Maryland?
> Gonna have to get the local brew tonight... "Moose Drool."
>
> Steve Orr
> Bozeman, MT
>
>
>
> -Original Message-
> Sent: Wednesday, June 13, 2001 3:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> anything has got to better than Lone Star!
>
> 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: Wednesday, June 13, 2001 2:23 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT - RE: Digestive
>
> Genessee baby!  Oh yeah!!!
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
> "I hate the country, all those animals walking around un-cooked."
>
> > -Original Message-
> > From: Kevin Lange [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 3:42 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: OT - RE: Digestive
> >
> > Oh please..  how could you even mention Shiner Bock .?  Next
> thing
> > you know you will be prevailing us to drink Black Label !!
> >
> > -Original Message-
> > Sent: Wednesday, June 13, 2001 3:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > That draft would be Shiner Bock, right?  Otherwise we other Texans
> will
> > have
> > you declared a yankee.
> >
> --
> 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: 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: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see th

RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

[Robertson Lee - lerobe]

Yeah, I'll second that. I NEVER use the newsgroup so I can only assume that
the list is where it came from.


-Original Message-
Sent: 14 June 2001 15:01
To: Multiple recipients of list ORACLE-L


FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the
staff has changed to the following - [EMAIL PROTECTED] eg
[EMAIL PROTECTED] Emails using the old format will continue to be delivered
until 30th June 2001. 

Patrice Boivin wrote

This tells me that unless I received the e-mail at work as well and didn't
notice, our addresses were lifted off the newsgroup and not this list.


Well I never looked at the newsgroup and hardly use my work e-mail address
for external e-mail at all
I believe it can have only come from this mailing list

John




This e-mail and any files transmitted with it, are confidential to Logica
and are intended solely for the use of the individual or entity to whom they
are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

Re: Hey MetaLink... Got RAM?

[The Oracle DBA]

fixed as of 10:23am EST.


---

TheOracleDBA
[EMAIL PROTECTED]



On Thu, 14 Jun 2001 07:23:17  
 Orr, Steve wrote:
>Here's what I just got logging in to MetaLink...
>
>Thu, 14 Jun 2001 14:12:33 GMT
>
>ORA-04031: unable to allocate 2550012 bytes of shared memory ("large
>pool","unknown object","session heap","bind var buf")
>
>  DAD name: plsql
>  PROCEDURE  : per_hom.startup
>  USER   : mrorracle
>  URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup
>  PARAMETERS :
>  
>
>  ENVIRONMENT:
>  
>PLSQL_GATEWAY=WebDb
>GATEWAY_IVERSION=2
>SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix)
>ApacheJServ/1.1 mod_perl/1.24
>GATEWAY_INTERFACE=CGI/1.1
>SERVER_PORT=80
>SERVER_NAME=metalink.oracle.com
>REQUEST_METHOD=GET
>QUERY_STRING=
>PATH_INFO=/metalink/plsql/per_hom.startup
>SCRIPT_NAME=/metalink
>REMOTE_HOST=
>REMOTE_ADDR=12.110.24.85
>SERVER_PROTOCOL=HTTP/1.1
>REQUEST_PROTOCOL=HTTP
>REMOTE_USER=
>HTTP_CONTENT_LENGTH=
>HTTP_CONTENT_TYPE=
>HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
>HTTP_HOST=metalink.oracle.com
>HTTP_ACCEPT=*/*
>HTTP_ACCEPT_ENCODING=gzip, deflate
>HTTP_ACCEPT_LANGUAGE=en-us
>HTTP_ACCEPT_CHARSET=
>HTTP_IF_MODIFIED_SINCE=
>HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/ml2_gui.startup
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Orr, Steve
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


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: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

RMAN - Incomplete recovery

[Nirmal Kumar Muthu Kumaran]

Helo guru's

i found one ? in self test as follows:

q)why is it not bebeficial to use RMAN when performing incomplete recovery?

a) A full offline backup is required after the recovery operations are
complete.

Now my question is, In general, in case of incomplete recovery we should do
the backup.

But here what is the specific reason form doing offline backup?  i cann't do
online backup itself .

I get confused. Pls help me.

Regards,
Nirmal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: [EMAIL PROTECTED]

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

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

[Mercadante, Thomas F]

you're 
kidding, right?  ;)
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Christopher Spence 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 10:07 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT RE: Forever running Analyze
  It 
  was a joke.
   
  Generally when there is a :) or a >:-) or something similar near the 
  end of a comment, it is ussually noted to be sarcastic.
   
   
  "Walking on water and developing software from 
  a specification are easy if both are frozen." 
  Christopher R. Spence Oracle DBA Fuelspot 
  
-Original Message-From: Nguyen, Long (ITS, 
Limestone Ave) [mailto:[EMAIL PROTECTED]]Sent: Thursday, 
June 14, 2001 1:50 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OT RE: Forever running 
Analyze
Sorry Ross, maybe  I missed it, but I did not 
see any rudeness in Alex's message. 
 
Long

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, 14 June 2001 2:57 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  OT RE: Forever running Analyze
   Alex, 
   
  I cannot believe how incredibly rude you are. 
   
  ;-> 
   
  Ross
  
-Original Message-From: Hillman, Alex 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 
13, 2001 11:07 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Forever running 
Analyze
Looks like nobody offered to increase sort_area_size for the 
session that is doing analyze - at least to  such size that it 
will require only one merge phase. See Steve Adams web site for formula 
how to calculate the size, but I think that 20M should be more than 
enough.
 
Alex Hillman
[Hillman, Alex] 
 -Original 
Message-From: Kevin Lange 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Forever running Analyze

  Hi folks;
    We have an Analyze running that is taking forever.  
  Here is the setup:
      The table is about 250 bytes 
  wide.
      The table is normally 100,000 
  rows
      The table has grown to over 4,000,000 
  rows.
      There is one index on 1 
  column.
      We used 
  the Compute Statistics options
   
  Does anyone have any suggestions on how we can get this analyze 
  to complete and still generate worthwile statistics 
  ??
   
  Thanks
   
  Kevin

RE: Speedo be gone

[Mohan, Ross]

ROFL!!

don't forget the fava beans, Ruth!



-Original Message-
Sent: Wednesday, June 13, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L


I now have an image of Ross wearing a Speedo, drinking single malt scotch,
and smoking a Cuban cigar...I need to go lie down.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 1:12 PM


> Ross,
> It looks like you may have to lose that speedo. I saw this in yesterday's
> newspaper.
>
> "The Warnaco Group filed for Chapter 11 bankruptcy protection yesterday,
> blaming the economy and its heavy debt load, among other things, for its
> problems.
> Under the leadership of Linda J. Wachner, the chief executive, Warnaco was
> transformed from a $590 million underwear maker to a diverse $2.25 billion
> apparel company with a dedicated following in stores and on the stock
> market.
> Brands like Speedo, Calvin Klein and Chaps by Ralph Lauren were part of
the
> fold."
>
> Henry
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Precise Insight/SQL/Pulse

[Connie Milliken]

We are thinking of possibly purchasing the Precise Insight, SQL and
Pulse products.   Has anyone had any very good or very bad experiences
with these products?

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

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

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

OT: Happy 50th Birthday UNIVAC 1

[Jamadagni, Rajendra]

The first computer that started it all ...

"Today is the 50th birthday of the UNIVAC I (UNIversal Automatic Computer),
the first commercial computer. It was quite a beast: 16,000 lbs, 5000 vacuum
tubes measuring 9 inches by 2 inches, and an amazing 1000 instructions
executed per second! The first UNIVAC was sold to the US Census bureau where
it revolutionized data storage from them. No longer did they have to use
punch cards, UNIVAC supported storage on metal tape! The US Census bureau
still maintains a plaque commemorating the computer. It reads "Bureau of the
Census dedicated the world's first electronic general purpose data
processing computer, UNIVAC I, on June 14, 1951. Eckert-Mauchly Computer
Corporation" Happy Birthday, UNIVAC I!" 

While celebrating this ... Unisys (http://www.unisys.com) has apologized for
their sins (http://www.unisys.com/news/releases/2001/jun/06148026.asp)
calling them "Unintended Consequences Of The Computer Age".

Among them ...

*   Giving SPAM a bad name
*   Making it impossible for anyone to do more than five minutes' 
worth   of work without being interrupted by an emailed joke, 
Top Ten list, or chain letter.
*   Making it easier for the IRS to spot discrepancies between 
your tax return and objective reality.
*   Providing you with the means to lose money in the stock market 
at an unprecedented pace.

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

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



*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify 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: Netbackup BLI and SQLBacktrack

[Adams, Simon]

Cheers Ron,

I used to use Backtrack with ADSM and it was great. 

Regards
Simon

-Original Message-
Sent: 14 June 2001 14:51
To: Multiple recipients of list ORACLE-L


We use Netbackup, not sure about BLI, and SQLBacktrack for several years.
The only problems we have ever had were with Netbackup.  BMC has taken over
the creation of the NB OBSI which allows the two to communicate.  That
should help prevent problems and finger pointing in the future.  We love
SQLBacktrack.  It works great and gives us a standard method of backup and
recovery.

Ron Smith
Database Administrator
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, June 14, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L


All

Does anyone have any experience of either of these products. I am about to
do a comparison/evaluation so any experiences with either would be helpful.

Both will be interfacing with Netbackups tape management system, on
predominately HP-UX.

Regards
Simon


**
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


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

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

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

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

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


**
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


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

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

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

RE: Oracle 9i Install

[Christopher Spence]

Title: RE: Oracle 8i database & ER diagram



Some 
browsers (i.e. in Solaris itself) will automatically try to ungzip 
it.
 
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: udaycb 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 5:52 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle 9i Install
  I 
  did install 9i successfully Y'day on Sun. Here are the steps to Follow 
  as (copied from OTN),
   
  


  
  Directions

   
  
  1. After downloading the software, gunzip 
it.

   
  
  2. Create directories Disk1, Disk2 and 
Disk3 

   
  
  3. cd Disk1

   
  
  4. cat .cpio | 
cpio -icdThis will extract all the files for disk1.

   
  
  5. Repeat steps 3 & 4 for disk2 and 
disk3

   
  
  6. To run the installer, cd to Disk1 and 
run runInstaller
  Note: I did not try to gunzip as said in step 1. Did steps 2 to 
  6...
  Regards
  Uday
   
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Yuval ArnonSent: 
Wednesday, June 13, 2001 5:06 PMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle 9i Install
Has anyone successfully installed Oracle 9i on Sun Sparc (available 
from technet).
Trying to gzip -d the files I get 'file is not in gz 
format'
 
Yuval Arnon.