Unix mailing List

[Sinard Xing]

Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East 
and the rest of the World
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

rollback for temp tablespace

[Tatireddy, Shrinivas (MED, Keane)]

Hi lists,


Can anybody clarify this:

Do the sort/idx rebuild  etc.,(tasks that use temp tablespace),  use
rollback segments?

I need to rebuild indexes of 20 Gig to a new tablespace.

Do I need to verify the RBS free space for this.?

Thnx and Regards,

Srinivas

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

difference between temporary tablespaces

[Daiminger, Helmut]

Title: difference between temporary tablespaces





Hi!


I'm getting kinda confused concerning the two types of temporary tablespaces:


create tablespace NAME temporary... is the "old" way of creating a temporary tablespace for sorting purposes. It only allows for sort segments to be stored there. And it can only be dictionary managed, right?

create temporary tablespace NAME tempfile... is the "new" way for it. It can either be dictionary managed or locally managed. 

But the complete reference says that this tablespace will only be used for temporary tables.
Does this tablespace also allow for sort segments?


Or do I need both types of tablespaces?


This is 8.1.7 on Sun Solaris.


Thanks,
Helmut

Re: rollback for temp tablespace

[Connor McDonald]

They do use some rollback but not the volumes you'd
typically need to worry about.  The rollback space is
for mods to the data dictionary as your segments are
created.  

hth
connor

 --- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote: > Hi lists,
> 
> 
> Can anybody clarify this:
> 
> Do the sort/idx rebuild  etc.,(tasks that use temp
> tablespace),  use
> rollback segments?
> 
> I need to rebuild indexes of 20 Gig to a new
> tablespace.
> 
> Do I need to verify the RBS free space for this.?
> 
> Thnx and Regards,
> 
> Srinivas
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

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


Nokia 5510 looks weird sounds great. 
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! 
The competition ends 16 th of December 2001.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: space used by pinned objects

[K Gopalakrishnan]

Hi,

You can select the information from V$DB_OBJECT_CACHE.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


-Original Message-
Sent: Tuesday, December 04, 2001 8:55 PM
To: Multiple recipients of list ORACLE-L

I've pinned some procs that were being loaded very frequently.
How can I determine how much space they are using in the shared pool and
that I
have plenty of space left in the shared pool?  I like pinning objects, but I
don't want to end up with a shared pool contiguous memory problem.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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!?
Get your free @yahoo.com address at http://mail.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: Unix mailing List

[Santosh Varma]

we can check the existence of the file by using fopen command and in read
mode.
if(fopen("temp.rpt","r) == null
   return(0)  -> file not found.

-Original Message-
Sent: Wednesday, December 05, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East
and the rest of the World
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

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

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

[Mark Leith]

Lisa,

Have you seen or heard of NORAD (Surveillance Module)?

Currently you can monitor:

Database:   O/S:

Oracle  NT/2000
Sybase  HP/UX
SQLServer   Solaris
AIX
LINUX

All from the same client console. Support is a LOT better than CA provide,
the tool installs in around 20 minutes per server to get full functionality,
and the price is very reasonable. More operating systems are going to be
supported in the coming 1st and 2nd Q's of 2002.

You can take a look at it here:

www.cool-tools.co.uk/Products/surveillance.html

Or download the datasheet

www.cool-tools.co.uk/Products/Docs/NORADSurveillance.pdf

Or for the O/S & Database module:

www.cool-tools.co.uk/Products/Docs/NORADIAS.pdf

You also only buy the server licenses, so you can install the client
software anywhere you wish. These clients will all be able to see all of the
server agents over the network, meaning you can share alerts/info across the
groups with ease, whilst only alerting the specific group responsible if you
wish.

Sound like it fits the bill?

If so let me know, and I will get somebody in touch with you about it - you
are in the States right?

Regards

Mark

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


-Original Message-
Sent: 05 December 2001 03:55
To: Multiple recipients of list ORACLE-L


Tools!  Tools!  Tools!

Did you look at Quest at all?





-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/4/01 5:35 PM

CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm
interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked
to
look at alternatives (I'm sure the cost will be prohibitive, but we'll
see).

Also if you know of any comparable tools, I'm very interested to hear
about
them.

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

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

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

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

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

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

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

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

RE: Unix mailing List

[Thomas, Kevin]

I think what you want to do is

if [ -d $FILENAME ] then
  echo "the file exists"
else
  echo "file not found"
fi

$FILENAME is a variable holding the name of the file you are looking for.
You can assign a value to it by doing:

FILENAME='/tmp/myfile.txt'

before the if statement.

Regards,
Kev.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 05 December 2001 08:10
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East 
and the rest of the World
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: difference between temporary tablespaces

[Connor McDonald]

The new way (ie tempfile) must be locally managed.  It
is used for ANY temporary segment (including sorting).
 They have other advantages as well - less redo
generated, can be used to open a standby for query,
trivially quick to allocate etc.

hth
connor

 --- "Daiminger, Helmut"
<[EMAIL PROTECTED]> wrote: > Hi!
> 
> I'm getting kinda confused concerning the two types
> of temporary
> tablespaces:
> 
> create tablespace NAME temporary... is the "old" way
> of creating a temporary
> tablespace for sorting purposes. It only allows for
> sort segments to be
> stored there. And it can only be dictionary managed,
> right?
> 
> create temporary tablespace NAME tempfile... is the
> "new" way for it. It can
> either be dictionary managed or locally managed. 
> But the complete reference says that this tablespace
> will only be used for
> temporary tables.
> Does this tablespace also allow for sort segments?
> 
> Or do I need both types of tablespaces?
> 
> This is 8.1.7 on Sun Solaris.
> 
> Thanks,
> Helmut
> 
>  

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

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


Nokia 5510 looks weird sounds great. 
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! 
The competition ends 16 th of December 2001.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: rollback for temp tablespace

[Tatireddy, Shrinivas (MED, Keane)]

By the way

Does this process (rebuilding of indexes) generate redo?

Srinivas

-Original Message-
Sent: Wednesday, December 05, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L


They do use some rollback but not the volumes you'd
typically need to worry about.  The rollback space is
for mods to the data dictionary as your segments are
created.  

hth
connor

 --- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote: > Hi lists,
> 
> 
> Can anybody clarify this:
> 
> Do the sort/idx rebuild  etc.,(tasks that use temp
> tablespace),  use
> rollback segments?
> 
> I need to rebuild indexes of 20 Gig to a new
> tablespace.
> 
> Do I need to verify the RBS free space for this.?
> 
> Thnx and Regards,
> 
> Srinivas
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

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


Nokia 5510 looks weird sounds great. 
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! 
The competition ends 16 th of December 2001.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

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

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

[Thomas, Kevin]

Apologies for the last replythe [ -d $FILENAME ] should be [ -a
$FILENAME ].

Hope that helps,
Cheers,
Kev.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 05 December 2001 08:10
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East 
and the rest of the World
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

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

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

Update query

[Roland . Skoldblom]

Hallo,

How can I update the field PRICE in table B
with prices from field NEW_PRICE in table A.
with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

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

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

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

RE: Update query

[Thomas, Kevin]

SELECT a.sql_basics
  ,b.chapter3
  FROM bookshelf
  ,b.book
 WHERE b.chapter3 = 'basic sql constructs'
   AND a.sql_basics = 'book that should be read before posting requests like
this';

;o)

-Original Message-
Sent: 05 December 2001 09:55
To: Multiple recipients of list ORACLE-L


Hallo,

How can I update the field PRICE in table B
with prices from field NEW_PRICE in table A.
with condition LANGUAGE_CODE IS = 412 (that condition should be taken from
table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

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

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

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

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

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

Re: Embedding perl in Oracle

[Tim Bunce]

On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> My office mate (cc'd) also set this up to demo the process.  I'm
> considering testing out the possibility of using an Oracle view on
> top of function that calls a extproc_perl to a MySQL database.

I imagine that'll be at least an order of magnitude slower than
using the Oracle ODBC Gateway and MyODBC to do the same thing.
I'll also be read-only.

I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC
for a production system soonish. It's part of a strategy to simplify
migration from MySQL to Oracle.

Tim.

> Tom
> 
> On Wed, Dec 05, 2001 at 12:55:31AM +, Tim Bunce wrote:
> > On Tue, Dec 04, 2001 at 01:45:46PM -0800, [EMAIL PROTECTED] wrote:
> > > 
> > > Of course, you can already call Perl from oracle via extproc_perl.
> > > 
> > > I've done it, it works.  Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > > 
> > > That is being remedied however...
> > > 
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> > 
> > Oh, very interesting. Thanks.
> > 
> >   http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme
> > 
> > I'll take a look and add that to my Perl Whirl talk.
> 
> -- 
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
> 
> _
> 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: Tim Bunce
  INET: [EMAIL PROTECTED]

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

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

RE: Update query

[Thomas, Kevin]

And yea, I got the syntax wrong ;o)) Don't point it out to methe bad day
continues...

-Original Message-
Sent: 05 December 2001 11:25
To: '[EMAIL PROTECTED]'
Importance: High


SELECT a.sql_basics
  ,b.chapter3
  FROM bookshelf
  ,b.book
 WHERE b.chapter3 = 'basic sql constructs'
   AND a.sql_basics = 'book that should be read before posting requests like
this';

;o)

-Original Message-
Sent: 05 December 2001 09:55
To: Multiple recipients of list ORACLE-L


Hallo,

How can I update the field PRICE in table B
with prices from field NEW_PRICE in table A.
with condition LANGUAGE_CODE IS = 412 (that condition should be taken from
table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

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

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

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

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

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

Update query

[Roland . Skoldblom]

Hallo,

How can I update the field PRICE in table B
with prices from field NEW_PRICE in table A.
with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

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

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

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

Re: contradictory information in v$session_wait?

[Christian Trassens]

You are right. SECONDS_IN_WAIT is not defined for
known short waits. However, it is only reset it when
known waits happens.

Regards.

--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I had a process showing what I think is
> contradictory information in
> v$session_wait.  
> 
> The event was direct path read.  The state showed
> WAITED SHORT TIME. 
> The time_waited showed -1.  The puzzling thing was
> that SECONDS_IN_WAIT
> was continuously increasing (it was in the 8000
> range while I was
> looking).  SECONDS_IN_WAIT is supposed to be valid
> only when state is
> WAITING, no?
> 
> Has anyone seen this kind of situation, and how can
> we tell what's
> being waited on (it's apparently not the direct path
> read)?  Thanks.
> 
> Paul Baumgartel
> 
> 
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=
ENG. Christian Trassens
Senior DBA
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +34-699240979
+34-649824704

__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

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

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

RE: BMC Patrol DBXray / CA Unicenter

[Gene Sais]

I second that, too long to list the problems I had w/ CA Unicenter, worthless 
expensive product.  CA touts their product to top management, then you get the call to 
implement.  Just my $.02, since you asked :)

Gene

>>> [EMAIL PROTECTED] 12/04/01 08:35PM >>>
CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked to
look at alternatives (I'm sure the cost will be prohibitive, but we'll see).

Also if you know of any comparable tools, I'm very interested to hear about
them.

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

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

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

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

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

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

Problem with DYNAMIC SQL

[ehsan sinavalda]

Hello

As I found in proc docs the following statement should
work properly:

EXEC SQL EXECUTE IMMEDIATE
 "CREATE TABLE dyn1 (col1 VARCHAR2(4))";

But when I want to compile a PROC prog. that has the
above stmt in a function I recevive the following
compile error:

sample1.cc: In function `void test()':
sample1.cc:1313: break statement not within loop or
switch

Could someone pls help me resolving this problem?

Thanks

E.


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ehsan sinavalda
  INET: [EMAIL PROTECTED]

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

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

[Adams, Matthew (GEA, 088130)]

Title: RE: background processes





> ora_s000_ora8
> ora_s001_ora8
> ora_s002_ora8


  ORacle MTS (multithreaded server) server processes


> ora_p000_ora8
> ora_p001_ora8


Oracle parallel query processes



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.  
It's just particular about who it makes friends with.


> -Original Message-
> From: Tatireddy, Shrinivas (MED, Keane) 
> Sent: Tuesday, December 04, 2001 10:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: background processes
> 
> 
> Hi lists,
> 
> Can anybody guess the following background processes?
> 
> ora_s000_ora8
> ora_s001_ora8
> ora_s002_ora8
> ora_p000_ora8
> ora_p001_ora8
> 
> ora8 is instance.
> 
> 
> 
> Thnx and Regards,
> 
> Srinivas
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

checking free space on hard disk drive from RDBMS (Oracle 8i)

[Szecsy Tamas]

Hi,

I would like to know if thwere is a way to check free space on a certain
hard disk drive from stored proecedure on Windows NT and Oracle 8i. UTL_FILE
does not seem to be able to do this for me.

TIA,

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

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

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

[DENNIS WILLIAMS]

Yeah, unfortunately our mail server was down for the count when your message
arrived. Well Bill Gates didn't get to be the richest man on the planet by
spending time worrying about security.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 04, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L



Do not open messages with a "Hi" subject and a screensaver attachment.  It's
a virus circling around our company now.

 

 

 

 

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide Inc.

4815 Emperor Blvd., Suite 110

Durham, NC 27703

Tel. (919) 941-4645

Fax (919) 474-0735

Email  
mailto:[EMAIL PROTECTED]

Web   http://www.arsenaldigital.com/

 

 
***  NOTICE  ***

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

 

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

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

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

RE: BMC Patrol DBXray / CA Unicenter

[Koniszewski, Mike]

HI Lisa,
   We don't use Xray or CA unicenter but we use Patrol from BMC with
UNIX,NT and the Oracle Availability Suite. Installation is straight forward
and support is great. Does allot of proactive monitoring. The psl
programming language is easy for customization. It comes packaged with
Centuari Alarm manage from proxima technology that has a web plugin so you
can get information on your machines from anywhere if you get an alarm. 

Michael Koniszewski
D.B.A. FairPoint Communications
518-242-5922


> -Original Message-
> From: YTTRI  Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 3:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  BMC Patrol DBXray / CA Unicenter
> 
> Hi - 
> 
> Does anyone have experience with either of these products?  I'm interested
> in ease of installation, ease of use, and quality of support.  I realize
> they are both pricey, but they both seem to do a lot.  I've been asked to
> look at alternatives (I'm sure the cost will be prohibitive, but we'll
> see).
> 
> Also if you know of any comparable tools, I'm very interested to hear
> about
> them.
> 
> Thanks much -
> Lisa
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: YTTRI  Lisa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Koniszewski, Mike
  INET: [EMAIL PROTECTED]

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

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

RE: buffer busy wait & latch free ( cache buffer chain )

[ARUN K C]

One way I can say there are bunch of patches which has to be applied on 
8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot of 
work arounds which you will have to get from oracle for library cache,cache 
buffer chains,ora 7445 errors etc etc etc..
We had an issue like if I give the command alter system flush shared pool 
the system got hung and all you can see is library cache pin and latch free 
waits and only option was to bring the database was bring it down.
God I can say they have royally messed up in 8.1.7.2.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: buffer busy wait & latch free ( cache buffer chain )
>Date: Tue, 04 Dec 2001 23:05:19 -0800
>
>
>Your statement "there are several bugs relating to waiting for latch-free
>on cache-buffer-chains, and the possibility of the instance hanging. " has
>me nervous.
>
>I am aware of 1967363 and have obtained the standalone patch for this to be
>applied on top of 8.1.7.2  I have
>seen significant wait times for cache buffer chains latch in my 8.1.7.1
>test environment and am waiting for the
>environment to be released to me so that I can upgrade it to
>8.1.7.2.1+1967363  (our production is still 8.0.5 !!).
>
>What other bugs are you talking off ?
>Hemant
>
>
>"Binley Lim" <[EMAIL PROTECTED]>05/12/2001 06:10 AM
>Sent by: [EMAIL PROTECTED]
>
>Please respond to ORACLE-L
>
>  To: Multiple recipients of list ORACLE-L 
><[EMAIL PROTECTED]>
>  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
>  Subject: RE: buffer busy wait & latch free ( cache buffer 
>chain )
>
>
>
>
>
>
>
>
>
>If on 8.1.7, there are several bugs relating to waiting for latch-free on
>cache-buffer-chains, and the possibility of the instance hanging.
>
>One is 1967363, and at least two others are still open after applying that
>patch.
>
>Changing cache buffer latches/buckets is not mentioned in those bugs, and
>since they are underscored, I would approach with caution.
>
>
> >>> [EMAIL PROTECTED] 12/05/01 08:30AM >>>
>Vivek:
> To combat the latch free- cache buffer chain problem, I would first
>check in v$latch_children if the contention is even across all cache buffer
>chain latches. If this is the case case (most of the time it is not) , I
>would add more cache buffer latches. If this is not the case, as ARUN
>suggested, I would find out which buffers are hot and I would investigate
>WHY they are hot. (Ussually because of a bad SQL-- you should fix them! )
> According to BBW problem, try to identify the segment involved and the
>cause (p1=file , p2=block and p3=cause from a 10046 trace) and then
>according to p3 there are some changes that can be done.
>
>HTH
>Diego
>
>- Original Message -
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Sent: Tuesday, December 04, 2001 9:35 AM
>
>
> > What are u seeing the buffer busy waits on is it for the read 
>intensivity
> > and latch free is showing that there are hot blocks why dont you find 
>out
> > the hot blocks and find what can  be done about it
> >
> >
> > >From: "VIVEK_SHARMA" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: buffer busy wait & latch free ( cache buffer chain )
> > >Date: Tue, 04 Dec 2001 01:55:19 -0800
> > >
> > >
> > >In report.txt we are getting the wait
> > >"buffer busy wait" _& wait on "latch free" for "cache buffer chain"
> > >
> > >Could an excessively Large db_block_buffer cause this ?
> > >
> > >NOTE - Transaction OLTP in nature
> > >
> > >NOTE - freelists is set = 2* cpu_count
> > >
> > >Any oher advice ?
> > >
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Binley Lim
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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
>a

RE: buffer busy wait & latch free ( cache buffer chain )

[Larry Elkins]

I may have missed it, but has anyone mentioned a particular OS here? Or, are
these generic bugs across OS's. I don't have access to Metalink so I can't
lookup the various bugs mentioned.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ARUN K C
> Sent: Wednesday, December 05, 2001 8:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: buffer busy wait & latch free ( cache buffer chain )
>
>
> One way I can say there are bunch of patches which has to be applied on
> 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There
> are lot of
> work arounds which you will have to get from oracle for library
> cache,cache
> buffer chains,ora 7445 errors etc etc etc..
> We had an issue like if I give the command alter system flush shared pool
> the system got hung and all you can see is library cache pin and
> latch free
> waits and only option was to bring the database was bring it down.
> God I can say they have royally messed up in 8.1.7.2.
>

-- 
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: Update query

[Yadav, Shailesh]

Roland,
  How about
  update B
 set PRICE = (select NEW_PRICE from A where )
   where language_code = 412

Shailesh

-Original Message-
Sent: Wednesday, December 05, 2001 6:35 AM
To: Multiple recipients of list ORACLE-L




Hallo,

How can I update the field PRICE in table B
with prices from field NEW_PRICE in table A.
with condition LANGUAGE_CODE IS = 412 (that condition should be taken from
table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

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

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

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

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

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

[dgoulet]

Ehsan,

I don't think so.  In the case you've listed the better way would be to do:

EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4));

The use of EXECUTE IMMEDIATE is more suited to statements that are being
dynamically created on the fly.  This one is not.

Dick Goulet
Pro*C Evangelist

Reply Separator
Author: ehsan sinavalda <[EMAIL PROTECTED]>
Date:   12/5/2001 5:05 AM

Hello

As I found in proc docs the following statement should
work properly:

EXEC SQL EXECUTE IMMEDIATE
 "CREATE TABLE dyn1 (col1 VARCHAR2(4))";

But when I want to compile a PROC prog. that has the
above stmt in a function I recevive the following
compile error:

sample1.cc: In function `void test()':
sample1.cc:1313: break statement not within loop or
switch

Could someone pls help me resolving this problem?

Thanks

E.


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ehsan sinavalda
  INET: [EMAIL PROTECTED]

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

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

[Mohammad Rafiq]

You can try following query
for ver 7.3.4
select substr(c.owner,1,5)"OWNER",substr(c.name,1,30)"name",
   round(c.sharable_mem / 1024) K,
   c.loads,
   c.executions,
   c.kept
from v$db_object_cache c,
 sys.obj$ o,
 sys.user$ u
where c.executions > 1000 and kept = 'NO'
and u.name = c.owner
  and u.user# = o.owner#select 
substr(c.owner,1,5)"OWNER",substr(c.name,1,30)"name",
   round(c.sharable_mem / 1024) K,
   c.loads,
   c.executions,
   c.kept
from v$db_object_cache c,
 sys.obj$ o,
 sys.user$ u
where c.executions > 1000 and kept = 'NO'
and u.name = c.owner
  and u.user# = o.owner#
  and o.name = c.name
  and o.type in (7, 8, 9)
order by 4,2 desc
/




for ver 8I


select substr(c.owner,1,5)"OWNER",substr(c.name,1,30)"name",
   round(c.sharable_mem / 1024) K,
   c.loads,
   c.executions,
   c.kept
from v$db_object_cache c,
 sys.obj$ o,
 sys.user$ u
where c.executions > 1000 and kept = 'NO'
and u.name = c.owner
  and u.user# = o.owner#
  and o.name = c.name
--   and o.type in (7, 8, 9)
order by 4,2 desc
/

You may modify it according to your requirement for loads instead of 
execution, which I personally prefer.

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 05 Dec 2001 01:50:19 -0800

Hi,

You can select the information from V$DB_OBJECT_CACHE.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


-Original Message-
Sent: Tuesday, December 04, 2001 8:55 PM
To: Multiple recipients of list ORACLE-L

I've pinned some procs that were being loaded very frequently.
How can I determine how much space they are using in the shared pool and
that I
have plenty of space left in the shared pool?  I like pinning objects, but I
don't want to end up with a shared pool contiguous memory problem.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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!?
Get your free @yahoo.com address at http://mail.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).


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

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

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

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

RE: buffer busy wait & latch free ( cache buffer chain )

[ARUN K C]

I was mentioning this on Sun 2.6 os


>From: "Larry Elkins" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: buffer busy wait & latch free ( cache buffer chain )
>Date: Wed, 05 Dec 2001 06:30:23 -0800
>
>I may have missed it, but has anyone mentioned a particular OS here? Or, 
>are
>these generic bugs across OS's. I don't have access to Metalink so I can't
>lookup the various bugs mentioned.
>
>Regards,
>
>Larry G. Elkins
>[EMAIL PROTECTED]
>214.954.1781
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ARUN K C
> > Sent: Wednesday, December 05, 2001 8:10 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: buffer busy wait & latch free ( cache buffer chain )
> >
> >
> > One way I can say there are bunch of patches which has to be applied on
> > 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There
> > are lot of
> > work arounds which you will have to get from oracle for library
> > cache,cache
> > buffer chains,ora 7445 errors etc etc etc..
> > We had an issue like if I give the command alter system flush shared 
>pool
> > the system got hung and all you can see is library cache pin and
> > latch free
> > waits and only option was to bring the database was bring it down.
> > God I can say they have royally messed up in 8.1.7.2.
> >
>
>--
>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).


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

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

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

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

Known problems or comments about ERwin, QDesigner or ERStudio????

[Grabowy, Chris]

I could be at OpenWorld, but n...I get the "pleasure" of staying home
and evaluating the three design products to see which one we should
purchase.

Anway, I just found what appears to be a flaw in QDesigner, in that, it
reverse engineered a database schema successfully, but it will not generate
SQL files with the DEFAULT values for columns.  Have other QDesigner users
encountered this?

Any other possible gotchas or comments about these modeling tools

Many thanks

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

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

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

Re: Rollbacks - ORA-1555

[Stephen Andert]

Christine, 
 
Howdy neighbor.  I've almost eliminated 1555's.  It 
took some trial and error, but what we ended up with in one of our bigger db's 
is:
 
30 rollback segments
OPTIMAL (NULL)
minextents 20
initial = next = 4MB
6GB total space
 
We have between 400 and 500 interactive users, several high 
volume batch jobs and some DSS jobs.  
 
By getting rid of OPTIMAL, you avoid one of the more common 
causes of the 1555 where a rollback segment is shrunk while the data block is 
being used.  We schedule a shrink script to run and manually shrink all the 
rollback segments weekly.  At times some tasks can eat up more rbs, but 
since they are dba activities, we just shrink a single rollback segment at a 
time if it gets too big.  
 
HTH
 
Stephen Andert
 
>>> [EMAIL PROTECTED] 12/04/01 03:50PM 
>>>
Greetings All
 
I am 
some what new to the list, so forgive me if I don't have the proper etiquette in 
addressing my issue. I have a database, 8.1.6, running on Windows NT, that 
currently has 5 rollback segments. The specs are as follows for each 
segment:
 
OPTIMAL 350M 
minextents 7 
maxextents unlimited 
initial 50M 
next 
50M
 
These 
segments are currently in one tablespace, for rollbacks only, which is sized at 
2.5 gig, and currently the segments are taking 1.7 gig, obviously aprox 750 meg 
free.
 
I have 
an application, written by our developers here, which is doing a 
functionality called "pricing". Within this process is alot of DML (updates and 
deletes) with some DDL inter-mixed. There is an auto-commit feature, which is 
currently commiting every 1000 records. There is also a locking feature, before 
the actual "fetches" the application is performing for it's cursors, and the 
developers are currently using "select * from table for update nowait" to lock 
the whole table for this process. The locking is in place because this 
particular process can use up to 5 different sessions.
 
Currently the stats of the rollbacks look like 
this:
 
data 
requests-  
3817488
 
CLASS   
COUNT-- --system undo 
header  0system undo 
block   0undo 
header 
3undo 
block  
1
 
 USN 
NAME    AVEACTIVE    
OPTSIZE WAITS WRAPS EXTENDS    SHRINKS  AVESHRINK 
-- -- -- - - --- -- 
--   0 
SYSTEM  
0    
0 0   
0  
0  0   2 
SV_ROLL0    
0  367001600 2 
0   
0  
0  0   3 
SV_ROLL1    
0  367001600 0 
0   
0  
0  0   4 
SV_ROLL2    
0  367001600 1 
0   
0  
0  0   5 
SV_ROLL3    
0  367001600 0 
0   
0  
0  0   6 
SV_ROLL4    
0  367001600 0 
0   
0  
0  0
 
6 rows 
selected.
 
TSPACE   
TOTAL   
USED   FREE--- -- 
-- 
--SV_ROLL_TSP   
2500   
1751    750
 
At 
times I have seen the "aveactive" column have some numeric value in it, but when 
the database and services are shutdown and brought back up, this number clears 
out.
 
My 
question is this: how much larger are these rollbacks supposed to be before I 
can eliminate the waits and wraps? More importantly, eliminate the undo headers 
and block. I have done alot of testing, with different sizing, and I feel like 
I'm chasing my tail. This is a major feature of our software, so it's not like 
it can be "ran at night" to differ to a timing issue. I have also noticed, that 
PMON doesn't really "shrink" appropriately, not back to a state like they are 
when they are first created. At this point, I guess I'm looking for some 
insight, advice as to what to specifically do to tune these segments a little 
more.
 
Thanks 
So Much, in advance
 
Christine 

RE: Unix mailing List

[DENNIS WILLIAMS]

Sinardy - Make sure you are using Korn shell. Make the first line #!
/bin/ksh. A good reference is the O'Reilly book UNIX in a Nutshell. It is
cheap and a thorough reference (not a tutorial). For example, on the -a and
-D options that Kevin mentions, there are about a page of different file
conditions that you can check for. If you have access to usenet newsgroups,
there are some very active lists for the different flavors of UNIX.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 4:30 AM
To: Multiple recipients of list ORACLE-L


Apologies for the last replythe [ -d $FILENAME ] should be [ -a
$FILENAME ].

Hope that helps,
Cheers,
Kev.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 05 December 2001 08:10
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East 
and the rest of the World
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Rollbacks - ORA-1555

[Christine Turner]

Hello All,

I changed the rollback segments, and here are the results. I'm now at 20
segments, 1 meg each, minextents 20, optimal 20. Here are the results after
running the process within the application with auto-commits turned off...

data requests
-
  2969079


CLASS  COUNT
-- -
system undo header 0
system undo block  0
undo header1
undo block 0


 USN NAME   AVEACTIVE   OPTSIZE WAITS WRAPS EXTENDS   SHRINKS AVESHRINK
 -- - - - - --- - -
   0 SYSTEM 0   0 0   0 0 0
   2 SV_ROLL0  106086  20971520 0 1   0 0 0
   3 SV_ROLL1  106086  20971520 0 1   0 0 0
   4 SV_ROLL2  106086  20971520 0 1   0 0 0
   5 SV_ROLL3  106086  20971520 0 1   0 0 0
   6 SV_ROLL4   0  20971520 0 0   0 0 0
   7 SV_ROLL5  106086  20971520 0 1   0 0 0
   8 SV_ROLL6  106086  20971520 0 1   0 0 0
   9 SV_ROLL7  106086  20971520 0 1   0 0 0
  10 SV_ROLL8  106086  20971520 0 1   0 0 0
  11 SV_ROLL9  106086  20971520 0 1   0 0 0
  12 SV_ROLL10 201973  20971520 1 2   0 0 0
  13 SV_ROLL11  0  20971520 0 0   0 0 0
  14 SV_ROLL12 106086  20971520 0 1   0 0 0
  15 SV_ROLL13 106086  20971520 0 1   0 0 0
  16 SV_ROLL14 106086  20971520 0 1   0 0 0
  17 SV_ROLL15 106086  20971520 0 1   0 0 0
  18 SV_ROLL16 201973  20971520 0 2   0 0 0
  19 SV_ROLL17 106086  20971520 0 1   0 0 0
  20 SV_ROLL18 106086  20971520 0 1   0 0 0
  21 SV_ROLL19 106086  20971520 0 1   0 0 0

21 rows selected.


TSPACE  TOTAL  USED  FREE
--- - - -
SV_ROLL_TSP   800   407   394


This doesn't look real good to meam I correct??? I will try processing
without the optimal being set to see what happens, while I await other
response.

thanks!
Christine



-Original Message-
Thapliyal
Sent: Tuesday, December 04, 2001 5:12 PM
To: Multiple recipients of list ORACLE-L


Hi Christine,

Your rollback segments look large to me based on the
description you have given for your application. One
way of eliminating header waits is to increase the
number of rbs .. try this and post if this helps your
stats..

1. Create total of 20 rollback segments

2. Specification for each rbs is :
 initial 1M
 next 1M
 minextents 20
 maxextents unlimited
 optimal 20M

meaning that each rbs will have 20 extents initially
and size of each rbs will be 20M initially. since you
have 20 such rbs, total rbs used is 20 * 20M = 400M

if you observe, the above structure uses smaller sized
large number of rollback segments as from your
description below, it looks like you have a oltp
system with large number of transactions

tell me if this helps ..

Deepak

---  Christine Turner
<[EMAIL PROTECTED]> wrote:
> RE: BMC Patrol DBXray / CA UnicenterGreetings
> All
>
> I am some what new to the list, so forgive me if I
> don't have the proper
> etiquette in addressing my issue. I have a database,
> 8.1.6, running on
> Windows NT, that currently has 5 rollback segments.
> The specs are as follows
> for each segment:
>
> OPTIMAL 350M
> minextents 7
> maxextents unlimited
> initial 50M
> next 50M
>
> These segments are currently in one tablespace, for
> rollbacks only, which is
> sized at 2.5 gig, and currently the segments are
> taking 1.7 gig, obviously
> aprox 750 meg free.
>
> I have an application, written by our developers
> here, which is doing a
> functionality called "pricing". Within this process
> is alot of DML (updates
> and deletes) with some DDL inter-mixed. There is an
> auto-commit feature,
> which is currently commiting every 1000 records.
> There is also a locking
> feature, before the actual "fetches" the application
> is performing for it's
> cursors, and the developers are currently using
> "select * from table for
> update nowait" to lock the whole table for this
> process. The locking is in
> place because this particular process can use up to
> 5 different sessions.
>
> Currently the stats of the rollbacks look like this:
>
> data requests
> -
>   3817488
>
>
> CLASS   COUNT
> -- --
> system undo header  0
> system undo block   0
> undo header 3
> undo block

RE: buffer busy wait & latch free ( cache buffer chain )

[Barbara Baker]

Re:  8.1.7.2 problems
We are also on Solaris 2.6.  We've been testing 8.1.7.2 for the past several 
weeks, and have not seen these kinds of problems.

This is a very critical upgrade for us.  Are others seeing major problems 
with 8.1.7.2 on Solaris??

Thanks for any responses.

Barb


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

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

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

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

[DENNIS WILLIAMS]

I appreciate everyone sharing their experiences.

My question on this topic is what tools are appropriate for what
environments? Some tools seem more extensive (and expensive) and therefore
appropriate to sites with many Oracle instances. I am currently responsible
for 5 production instances all at our HQ datacenter. On those rare occasions
when something goes down, some usually quickly contacts me, so I haven't
felt the need for a monitoring tool. However, we are discussing a project to
put servers in a handful of manufacturing plants and they would be more 23x7
situations, so I have been reviewing OEM (it fails a lot more often than the
instance, I'm not about to turn on its remote notification). Naturally
vendors will claim that their product is just ideal for your type of site.
Does anyone have any input on which monitoring tools are appropriate for
sites with a smaller number of Oracle instances? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L


I second that, too long to list the problems I had w/ CA Unicenter,
worthless expensive product.  CA touts their product to top management, then
you get the call to implement.  Just my $.02, since you asked :)

Gene

>>> [EMAIL PROTECTED] 12/04/01 08:35PM >>>
CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked to
look at alternatives (I'm sure the cost will be prohibitive, but we'll see).

Also if you know of any comparable tools, I'm very interested to hear about
them.

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

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

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

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

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

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

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

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

Re: Unix mailing List

[Scott Shafer]

This is untested and from memory, but:

if [test -f ]
then
echo "found"
else
echo "help, are you an idiot"
fi

--Scott


--- Sinard Xing <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Can someone recommend good unix mailing list
> 
> by the way how to check the existence of a file ?
> 
> My logic :
> 
>   if (findThisFile(/tmp/myfile.txt) == 0)
>   echo "the file is exists"
>   else
>   echo "file not found"
>   endif
> 
> 
> what is the unix function for findThisFile()
> 
> 
> 
> Thank you,
> 
> Sinardy
> Hoping Peace in Middle East 
> and the rest of the World
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sinard Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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

Lookup table design thoughts needed

[Tracy Rahmlow]

We are currently looking at rewriting our entry system and one issue that I am
looking for some feedback involves the use of lookup tables and
populating/editing screens.  We are looking at creating a generic table that
contains all the valid entries for each drop-down list.  For example, we may
display a list of valid states for the user to select.  The proposed "edit"
table contains a row for each state with the following columns as an example:

table_name: address
column_name: state_cd
code: WI
description: Wisconsin

In addition, we have situations on the screen where a user may select option
'a' in a drop-down list, but can not choose option 'c,d or f' in a different
drop down list.
Any suggestions for designing  a flexible system that would incorporate issues
like the above.  We have been considering either "hard-coding" the edits within
the screen as well as creating a "rules/validation" table that would
incorporate these edits.  How practical is a rules table? (We do have
situations where we may have multiple entries to validate to each other).  I
realize these are very broad questions, so I am looking for generic theories
that may be applied that are flexible for adapting to changes within the
business.  What else should I consider?  It appears as if there are several
ways to skin the cat how do we go about choosing the best method for our
situation.

 In addition, does anybody know of any good websites/books that contain
relational design strategies, tips ...




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

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

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

[Kevin Lange]

Couple clarifications:

1. -a : file exists (any type of file)
   -d : file is a directory
   -f : file is a regular file (like Scott Said)

2. The test is not neccessary

vFILE_NAME='The file in question'

if [ -f ${vFILE_NAME} ]
then
  echo "File is there.  You do not have to spend hours recreating it."
else
  echo "Arggghhh !   Who the heck deleted my file !! Where the heck is my
gun!"
fi


-Original Message-
Sent: Wednesday, December 05, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L


This is untested and from memory, but:

if [test -f ]
then
echo "found"
else
echo "help, are you an idiot"
fi

--Scott


--- Sinard Xing <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Can someone recommend good unix mailing list
> 
> by the way how to check the existence of a file ?
> 
> My logic :
> 
>   if (findThisFile(/tmp/myfile.txt) == 0)
>   echo "the file is exists"
>   else
>   echo "file not found"
>   endif
> 
> 
> what is the unix function for findThisFile()
> 
> 
> 
> Thank you,
> 
> Sinardy
> Hoping Peace in Middle East 
> and the rest of the World
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sinard Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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

Column Title

[BINAY . KUMAR]

Hello DBA-Gurus,

Executing the same query on 2 databases, but getting different output- the
column title. In all the databases its limited to the value of the row except
in one database we've. All the  databases are of 8.1.7.2 running on IBM/unix
server.

Database- A
--
select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;


SUB

---

LET

Database-B
--

select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;


SUBSTR('LETMEBABYONEMORET



LET

See the output of Database-B - that's the difference from the others.It seems
that its a database specific problem- we tried with all SQLPLUS versions, both
Unix and Windows and objerved the same.

Eager to know what makes the difference - all your comments are welcome.

Thanks



-Binay






---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

-- 
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: BMC Patrol DBXray / CA Unicenter

[Jared . Still]

Lisa

I didn't get the opportunity to work with BMC, but was somewhat
involved in the selection process for enterprise monitoring tools
a couple of jobs ago.

BMC Patrol ( or whatever it may be called now ) was very impressive.

I had lots of questions, and everything I asked, it was already setup
to do.  It will handle various databases, and will also monitor the OS.

Wanna keep an eye on the page scan rate on Solaris?  They already
have it if you want it.  If you think of something it can't do, they have a
scripting language to build it yourself.  ( too bad it wasn't perl )

It was the most capable tool I've seen.  If others with experience
recommend it
it would be a candidate for closer scrutiny.

Bring a lot of cash though if you plan to use it.

Jared




   
 
YTTRI Lisa 
 

h.com>   cc:   
 
Sent by: Subject: RE: BMC Patrol DBXray / CA 
Unicenter  
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/04/01 02:00 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Ideally, we'd like to find a common tool to monitor Oracle, Sybase and SQL
Server databases running on both NT and Unix platforms.  There are separate
groups that are responsible for NT support and Unix support.  If we could
all use the same tool, we'd be delighted, but if not, then one tool for all
databases would be our next choice.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L


Lisa,

What are you trying to monitor - just Oracle databases, the OS as well (if
so which OS) and anything else?

We use the Watchdog functionality (part of CA Unicenter) to monitor our VMS
servers (where we don't run Oracle) and it good for that.

It depends on what you are trying to achieve.

HTH,
Bruce Reardon

-Original Message-
Sent: Wednesday, 5 December 2001 7:25

Hi -

Does anyone have experience with either of these products?  I'm interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked to
look at alternatives (I'm sure the cost will be prohibitive, but we'll
see).

Also if you know of any comparable tools, I'm very interested to hear about
them.

Thanks much -
Lisa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Embedding perl in Oracle

[Jared . Still]

Tim,

That sounds rather interesting, as the impression that  MySQL users
sometimes give is that they're perfectly happy with MySQL and
don't have any need to move to Oracle or anything else.

Any particular features of Oracle that the owners feel they
need, or is it a move to satisfy  investors/auditors/etc.?

Jared



   
 
Tim Bunce  
 

ox.com>  cc:   
 
Sent by: Subject: Re: Embedding perl in Oracle 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/05/01 03:30 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> My office mate (cc'd) also set this up to demo the process.  I'm
> considering testing out the possibility of using an Oracle view on
> top of function that calls a extproc_perl to a MySQL database.

I imagine that'll be at least an order of magnitude slower than
using the Oracle ODBC Gateway and MyODBC to do the same thing.
I'll also be read-only.

I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC
for a production system soonish. It's part of a strategy to simplify
migration from MySQL to Oracle.

Tim.

> Tom
>
> On Wed, Dec 05, 2001 at 12:55:31AM +, Tim Bunce wrote:
> > On Tue, Dec 04, 2001 at 01:45:46PM -0800, [EMAIL PROTECTED]
wrote:
> > >
> > > Of course, you can already call Perl from oracle via extproc_perl.
> > >
> > > I've done it, it works.  Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > >
> > > That is being remedied however...
> > >
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> >
> > Oh, very interesting. Thanks.
> >
> >
http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme

> >
> > I'll take a look and add that to my Perl Whirl talk.
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
> _
> 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: Tim Bunce
  INET: [EMAIL PROTECTED]

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

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

Create View From Another Schema

[Hamid Alavi]

Question?

I try to create a view from another schema and get the error: ORA-00942:
table or view does not exist
It is a very simple thing don't know why doesn't work???

Create or replace view test_v 
as
select col1,col2,col3 from schemaA.tableA

Any Idea realy appreciate.
Thanks 



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

[Kempf, Reed]

You need to have select priveleges on the schema which want to create the
views from.

ReedK

-Original Message-
Sent: Wednesday, December 05, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L


Question?

I try to create a view from another schema and get the error: ORA-00942:
table or view does not exist
It is a very simple thing don't know why doesn't work???

Create or replace view test_v 
as
select col1,col2,col3 from schemaA.tableA

Any Idea realy appreciate.
Thanks 



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

RV: Create View From Another Schema

[Natalia Laracca]

Hi,
You try:

As SchemaA do:
grant select on  tableA to schemaX;

As SchemaX do:
Create or replace view test_v
as
select col1,col2,col3 from schemaA.tableA;


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 2:40 PM


> Question?
>
> I try to create a view from another schema and get the error: ORA-00942:
> table or view does not exist
> It is a very simple thing don't know why doesn't work???
>
> Create or replace view test_v
> as
> select col1,col2,col3 from schemaA.tableA
>
> Any Idea realy appreciate.
> Thanks
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Natalia Laracca
  INET: [EMAIL PROTECTED]

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

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

[Jared . Still]

Binay,

Try typing the command 'CLEAR COLUMNS' before doing the select.

It may be something in login.sql or glogin.sql that is creating the
difference.

Jared

PS.  You seem to be hung up on 'The Captain and Tenille'.  Therapy
is available.



   
 
BINAY.KUMAR@po 
 
nl.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Column Title 
 
om 
 
   
 
   
 
12/05/01 09:25 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hello DBA-Gurus,

Executing the same query on 2 databases, but getting different output- the
column title. In all the databases its limited to the value of the row
except
in one database we've. All the  databases are of 8.1.7.2 running on
IBM/unix
server.

Database- A
--
select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;


SUB

---

LET

Database-B
--

select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;


SUBSTR('LETMEBABYONEMORET



LET

See the output of Database-B - that's the difference from the others.It
seems
that its a database specific problem- we tried with all SQLPLUS versions,
both
Unix and Windows and objerved the same.

Eager to know what makes the difference - all your comments are welcome.

Thanks



-Binay






---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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

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

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




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

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

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

RE: BMC Patrol DBXray / CA Unicenter

[HAWKINS, JAMES W [IT/1000]]

We looked at Quest extensively, and even began rolling it out.  I/Watch fell
apart at the seams when we tried to scale...

Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 04, 2001 9:55 PM
To: Multiple recipients of list ORACLE-L


Tools!  Tools!  Tools!

Did you look at Quest at all?





-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/4/01 5:35 PM

CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm
interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked
to
look at alternatives (I'm sure the cost will be prohibitive, but we'll
see).

Also if you know of any comparable tools, I'm very interested to hear
about
them.

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

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

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

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

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

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

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

[Gonzalo Romero]

Hi,
 
I am looking for good courses on Oracle 9i Database and Oracle 9iAS.
Does anybody knows some links or resources??.
 
It could be in Video, CD or something like that. Not interested in
online courses (unless they are free :-) ).
 
Thanks for all
 
Gonzalo Romero
 


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

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

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

Schema Owner

[Hamid Alavi]

May be odd question, but I realy need to do this, I want to revoke the
privilege of the schema owner.
I mean give only select priv to the schema owner.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

[Hamid Alavi]

Thanks, but I have define a role and give select from tableA to the role
then assign the role to user but it wasn't work till directly assign select
on tableA to schema.
BTW thanks for reply

-Original Message-
Sent: Wednesday, December 05, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


Hi,
You try:

As SchemaA do:
grant select on  tableA to schemaX;

As SchemaX do:
Create or replace view test_v
as
select col1,col2,col3 from schemaA.tableA;


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 2:40 PM


> Question?
>
> I try to create a view from another schema and get the error: ORA-00942:
> table or view does not exist
> It is a very simple thing don't know why doesn't work???
>
> Create or replace view test_v
> as
> select col1,col2,col3 from schemaA.tableA
>
> Any Idea realy appreciate.
> Thanks
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Natalia Laracca
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

Partitioning Questions

[Harvinder Singh]

Hi,

The system is Oracle 9i on Sun 2.8

1) Which partitioning is better to use HASH or RANGE. Do there is some
overhead for oracle  
   to calculate the hash number
   (hash partitioning) to find the particular partition. We need to
partition 2 tables of  
   sizes 175G and 162G 
   
2  We have about 10 72G hard drives and 22 9G Hard Drives
   How many partitions to use (does this number depends upon number of hard
disks).
   
3) What should be the ideal size of datafiles.


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

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

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

RE: Rollbacks - ORA-1555

[Steve McClure]

Title: RE: BMC Patrol DBXray / CA Unicenter









Christine,

 

Here is a white
paper I recently found while chasing down another link on this site.  I wish I had read something like this 4
years ago, when I was a developer first trying to figure out what to do about
snapshot too old problems.  I too
once tried to tame the tiger with ever increasingly large rollback segments.  It doesn’t really touch on how to
specifically prevent the error, but it certainly explains the problem much
better than I can.  After reading Stephen’s
response, I think I need to brush up on rollback management, because I always
just tell the developers to figure out a way to accomplish their task, and
avoid the error on their own.

 

Oh the
link is Cats Dogs and ORA-01555 

 

Steve
McClure

 

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Christine
Turner
Sent: Tuesday, December 04, 2001
2:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: Rollbacks - ORA-1555

 

Greetings All

 

I am some what new to the
list, so forgive me if I don't have the proper etiquette in addressing my
issue. I have a database, 8.1.6, running on Windows NT, that currently has 5
rollback segments. The specs are as follows for each segment:

 

OPTIMAL 350M 

minextents 7 

maxextents unlimited 

initial 50M 

next 50M

 

These segments are
currently in one tablespace, for rollbacks only, which is sized at 2.5 gig, and
currently the segments are taking 1.7 gig, obviously aprox 750 meg free.

 

I have an
application, written by our developers here, which is doing a
functionality called "pricing". Within this process is alot of DML
(updates and deletes) with some DDL inter-mixed. There is an auto-commit
feature, which is currently commiting every 1000 records. There is also a
locking feature, before the actual "fetches" the application is
performing for it's cursors, and the developers are currently using
"select * from table for update nowait" to lock the whole table for
this process. The locking is in place because this particular process can use
up to 5 different sessions.

 

Currently the stats of
the rollbacks look like this:

 

data requests
-
  3817488

 


CLASS  
COUNT
-- --
system undo header  0
system undo block   0
undo
header
3
undo
block 
1

 


 USN NAME   
AVEACTIVE    OPTSIZE WAITS WRAPS EXTENDS   
SHRINKS  AVESHRINK
 -- -- -- - - --- -- --
   0
SYSTEM 
0   
0 0  
0 
0  0
   2
SV_ROLL0   
0  367001600 2
0  
0  0 
0
   3
SV_ROLL1   
0  367001600 0
0  
0  0 
0
   4
SV_ROLL2   
0  367001600 1
0  
0  0 
0
   5
SV_ROLL3   
0  367001600 0
0  
0  0 
0
   6
SV_ROLL4   
0  367001600 0
0  
0  0 
0

 

6 rows selected.

 


TSPACE  
TOTAL  
USED   FREE
--- -- -- --
SV_ROLL_TSP  
2500  
1751    750

 

At times I have seen the
"aveactive" column have some numeric value in it, but when the
database and services are shutdown and brought back up, this number clears out.

 

My question is this: how
much larger are these rollbacks supposed to be before I can eliminate the waits
and wraps? More importantly, eliminate the undo headers and block. I have done
alot of testing, with different sizing, and I feel like I'm chasing my tail.
This is a major feature of our software, so it's not like it can be "ran
at night" to differ to a timing issue. I have also noticed, that PMON
doesn't really "shrink" appropriately, not back to a state like they
are when they are first created. At this point, I guess I'm looking for some
insight, advice as to what to specifically do to tune these segments a little
more.

 

Thanks So Much, in
advance

 

Christine 

RE: Rollbacks - ORA-1555

[Deepak Thapliyal]

Hi Christine,

these results are slightly differnt from the earlier
ones you .. as the latest ones had 8,48409 fewer data
requests. 

I believe you are worried about the wraps.. if yes ..
dont be , cuz at some point or the other the rbs will
wrap. the definition of wrapping is controversial and
lots of confusion still exists. That said, wraps are
probably not the best metrics to help you identify rbs
issues.. here are the metrics i use to for identifying
if there are rbs issues from v$rollstat.. (excluding
v$waitstat stats as you already seem to have figured
that one it seems)

1. waits (ideally you want this to be 0)

2. shrink (if high means that there is dynamic
allocation and reallocation.. tune optimal.. ideally
you want your rbs to always stay at its optimal size
with 0 shrinks..)

3. AVEACTIVE: you reached a maximum of about 200K. so
maybe you should try changing initial and next to 250K
with other parameters same and check if the numbers
are looking better

finally the reason i replied to the whole list and not
only to you is that i am hoping someone can come
forward and say that .. ""dude!! you have it figgured
all wrong!!""  that way at least i get to learn somin
new for sure... ;)

Thx
Deepak

PS: might also help to check v$session_wait for buffer
waits to see what "type" of blocks are being contended
for..



---  Christine Turner
<[EMAIL PROTECTED]> wrote:
> Hello All,
> 
> I changed the rollback segments, and here are the
> results. I'm now at 20
> segments, 1 meg each, minextents 20, optimal 20.
> Here are the results after
> running the process within the application with
> auto-commits turned off...
> 
> data requests
> -
>   2969079
> 
> 
> CLASS  COUNT
> -- -
> system undo header 0
> system undo block  0
> undo header1
> undo block 0
> 
> 
>  USN NAME   AVEACTIVE   OPTSIZE WAITS WRAPS
> EXTENDS   SHRINKS AVESHRINK
>  -- - - - -
> --- - -
>0 SYSTEM 0   0 0 
>  0 0 0
>2 SV_ROLL0  106086  20971520 0 1 
>  0 0 0
>3 SV_ROLL1  106086  20971520 0 1 
>  0 0 0
>4 SV_ROLL2  106086  20971520 0 1 
>  0 0 0
>5 SV_ROLL3  106086  20971520 0 1 
>  0 0 0
>6 SV_ROLL4   0  20971520 0 0 
>  0 0 0
>7 SV_ROLL5  106086  20971520 0 1 
>  0 0 0
>8 SV_ROLL6  106086  20971520 0 1 
>  0 0 0
>9 SV_ROLL7  106086  20971520 0 1 
>  0 0 0
>   10 SV_ROLL8  106086  20971520 0 1 
>  0 0 0
>   11 SV_ROLL9  106086  20971520 0 1 
>  0 0 0
>   12 SV_ROLL10 201973  20971520 1 2 
>  0 0 0
>   13 SV_ROLL11  0  20971520 0 0 
>  0 0 0
>   14 SV_ROLL12 106086  20971520 0 1 
>  0 0 0
>   15 SV_ROLL13 106086  20971520 0 1 
>  0 0 0
>   16 SV_ROLL14 106086  20971520 0 1 
>  0 0 0
>   17 SV_ROLL15 106086  20971520 0 1 
>  0 0 0
>   18 SV_ROLL16 201973  20971520 0 2 
>  0 0 0
>   19 SV_ROLL17 106086  20971520 0 1 
>  0 0 0
>   20 SV_ROLL18 106086  20971520 0 1 
>  0 0 0
>   21 SV_ROLL19 106086  20971520 0 1 
>  0 0 0
> 
> 21 rows selected.
> 
> 
> TSPACE  TOTAL  USED  FREE
> --- - - -
> SV_ROLL_TSP   800   407   394
> 
> 
> This doesn't look real good to meam I correct???
> I will try processing
> without the optimal being set to see what happens,
> while I await other
> response.
> 
> thanks!
> Christine
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Deepak
> Thapliyal
> Sent: Tuesday, December 04, 2001 5:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rollbacks - ORA-1555
> 
> 
> Hi Christine,
> 
> Your rollback segments look large to me based on the
> description you have given for your application. One
> way of eliminating header waits is to increase the
> number of rbs .. try this and post if this helps
> your
> stats..
> 
> 1. Create total of 20 rollback segments
> 
> 2. Specification for each rbs is :
>  initial 1M
>  next 1M
>  minextents 20
>  maxextents unlimited
>  optimal 20M
> 
> meaning that each rbs will have 20 extents initially
> and size of each rbs will be 20M initially. since
> you
> have 20 such rbs, total rbs used is 20 * 20M = 400M
> 
> if you observe, the above struct

Parallel Server

[Smith, Ron L.]

Is anyone using Oracle Parallel Server?  It that the best solution for a
standby server?
Any idea what it would cost?  Are there any classes covering implementation?

Ron Smith


-- 
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: difference between temporary tablespaces

[Deepak Thapliyal]

Hi Helmut,

here is the breakdown

Tablespaces
1 DMT (dictionary managed)
   a> Normal
   b> temporary(only temp objects)

2. LMT temporary tblspces (True temp tblspces)

   syntax: create temporary tablespace 
   
The behaviour of this is similar to the /tmp of
unix as temp files gets flushed (gone) on db bounce.
Also rman full backups ignore these which is a big
plus. these are visible using v$tempfile or
dba_temp_files or somin like that

Deepak 
  
   
--- "Daiminger, Helmut"
<[EMAIL PROTECTED]> wrote:
> Hi!
> 
> I'm getting kinda confused concerning the two types
> of temporary
> tablespaces:
> 
> create tablespace NAME temporary... is the "old" way
> of creating a temporary
> tablespace for sorting purposes. It only allows for
> sort segments to be
> stored there. And it can only be dictionary managed,
> right?
> 
> create temporary tablespace NAME tempfile... is the
> "new" way for it. It can
> either be dictionary managed or locally managed. 
> But the complete reference says that this tablespace
> will only be used for
> temporary tables.
> Does this tablespace also allow for sort segments?
> 
> Or do I need both types of tablespaces?
> 
> This is 8.1.7 on Sun Solaris.
> 
> Thanks,
> Helmut
> 
> 


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: Schema Owner

[DENNIS WILLIAMS]

Hamid - this was discussed recently on this list and as I recall you can't
revoke the schema owner. Can you create a new userid and get them to use
that? Then change the password on the schema owner. Barring that, you could
create a new schema, move the tables and indexes there, then grant select to
the original owner.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


May be odd question, but I realy need to do this, I want to revoke the
privilege of the schema owner.
I mean give only select priv to the schema owner.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Schema Owner

[Johnston, Tim]

Someone mentioned you could do it with the fine grained access control
stuff...

-Original Message-
Sent: Wednesday, December 05, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


Hamid - this was discussed recently on this list and as I recall you can't
revoke the schema owner. Can you create a new userid and get them to use
that? Then change the password on the schema owner. Barring that, you could
create a new schema, move the tables and indexes there, then grant select to
the original owner.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


May be odd question, but I realy need to do this, I want to revoke the
privilege of the schema owner.
I mean give only select priv to the schema owner.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

[Grabowy, Chris]

So I'm poking around the web looking for product reviews for data modeling
tools, when I come across this article about Computer Associates and in
particular a quote from a certain DBA...

-

Dick Goulet, a database administrator at a U.S.-based maker of electronic
components, was even more blunt - and sarcastic. "It couldn't have happened
to a nicer company," said Goulet, who used Platinum's Plan Analyzer database
administration software until CA's acquisition. Before the buyout, Goulet
said, he was paying an annual maintenance fee of $10,000 for 20 copies of
the Platinum tool. But after CA bought Platinum in June 1999, he said, CA
told him he would have to upgrade immediately to a full Platinum product
suite at a cost of $100,000, plus $50,000 per year in maintenance fees.

Later, he added, CA said Goulet's firm would have to buy into CA's
management and middleware products. That would have cost $5 million to $10
million, Goulet said. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

RE: Has anyone heard of "Mirror Accessible"?

[Miller, Jay]

We just had someone from Oracle in yesterday who said
a) it will be a 9.0.2 feature
b) 9.0.2 won't be out until June, 2002
 
Unfortunately they are still holding fixed to forcing me to come in on
Christmas weekend to upgrade to 8.1.7.  For no good reason.  Forcing me to
cancel the plans I've had with my mother for the last 2 months.  If it
sounds like I'm pissed you're being perceptive.  I've tried to push for
upgrading this database for over a year (last September it was going to be
8.1.6).  Now they're finally letting me do it and are saying (with no notice
and almost no time for testing) that it has to be done at the most
inconvenient time possible for me.
 
I will refrain from saying exactly what I'm thinking because this is a
family forum :).
 
Jay Miller

-Original Message-
Sent: Tuesday, December 04, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L



Just got back from OOW and that 'might' be available in Release 2 of 9i.
Which is due out in Spring 2002.  

Nick. 

-Original Message- 
 ] 
Sent: Friday, November 30, 2001 1:45 PM 
To: Multiple recipients of list ORACLE-L 


Can anyone confirm this?  I've been searching technet and metalink and can't

turn up any details. 

-Original Message- 
Sent: Friday, November 30, 2001 3:01 PM 
To: Multiple recipients of list ORACLE-L 


Isn't that just in release 2 though?  My understanding is that its not out 
yet. 

-Original Message- 
Sent: Friday, November 30, 2001 11:36 AM 
To: Multiple recipients of list ORACLE-L 


Ah, this sounds likely.  And it might explain why they were keen on having 
us upgrade to 9i.  That's the problem with receiving the request filtered 
through two additional levels of people. 

Jay Miller 

-Original Message- 
Sent: Friday, November 30, 2001 1:56 PM 
To: Multiple recipients of list ORACLE-L 


9i has a new feature on standby databases that let's you run reports in read

only while continuing the managed recovery.  I think they call it a logical 
standby database.  See the 9i DataGuard manual for more information.  (I 
just happened to be looking into this lately).  This might be what they are 
talking about. 

Best, 

Ed 

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
Sent: Friday, November 30, 2001 12:05 PM 


> Only thing I can think of off the top of my head is a standby database 
> opened in read only mode.  Its one of the purposes totted for that 
> 
> -Original Message- 
> Sent: Friday, November 30, 2001 9:47 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> My CIO woes continue. My manager has been told by the CIO that Oracle has 
a 
> product called "mirror accessible" which allows the database to be 
mirrored 
> for reporting purposes. He wants us to use this product. 
> 
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby 
> and Oracle Replication but he says it isn't any of these. Any idea what he

> might be talking about? 
> 
> Jay Miller 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
> -- 
> Author: Miller, Jay 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, California-- Public Internet access / Mailing Lists 
>  
> To REMOVE yourself from this mailing list, send an E-Mail message 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L 
> (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). 
> 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line co

query rewrite

[elain he]

Hi,
Does anyone know how can I create a materialized view for query rewrite on 
the following query:

select distinct parttable
from
emp where exists (select * from addr where ((addr.zip=24811)
and emp.timestamp='11/23/2001') and emp.id=addr.id
and emp.sn=addr.sn) order by emp.parttable;

I tried creating a materialized view but it errored out on the 
emp.timestamp='11/23/2001'.

ORA-30353: expression not supported for query rewrite

I created another materialized view without the 'timestamp' and it got 
created fine. ie
select distinct parttable
from
emp where exists (select * from addr where ((addr.zip=24811))
and emp.id=addr.id
and emp.sn=addr.sn) order by emp.parttable;

Now, when I try running the query below, Oracle does not do a query rewrite 
but when I ran the query without referencing 'timestamp', Oracle uses the 
materialized view.

The query below needs to reference the timestamp. How can I create the 
materialized view to enable Oracle to utilize the materialized view whenever 
the below query is ran?

select distinct parttable
from
emp where exists (select * from addr where ((addr.zip=24811)
and emp.timestamp='11/23/2001') and emp.id=addr.id
and emp.sn=addr.sn) order by emp.parttable;

thanks in advance for any assistance you can provide.
elain


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

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

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

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

[Tim Bunce]

On Wed, Dec 05, 2001 at 09:30:55AM -0800, [EMAIL PROTECTED] wrote:
> 
> Tim,
> 
> That sounds rather interesting, as the impression that  MySQL users
> sometimes give is that they're perfectly happy with MySQL and
> don't have any need to move to Oracle or anything else.
> 
> Any particular features of Oracle that the owners feel they
> need, or is it a move to satisfy  investors/auditors/etc.?

Mostly to satisfy investors/auditors/etc.

We'll be keeping MySQL for some performance critical parts.
It is very good and very fast, and getting better and faster
all the time.

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

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

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

[Edward Shevtsov]

Hi,

it seems we have similar situation today. Our production db hangs suddenly. We 
couldn't even login
into the db.
Before aborting oracle we found a process like svrmgrl @/tmp/sql. The body 
includes single
command 'alter system flush shared_pool'.
It seems it was generated by db agent according to our job timetable in the OEM. We 
recently patched
db up to 8.1.7.2 (Linux) in order to get rid of memory leak in the shared pool...

Regards,
Ed





> One way I can say there are bunch of patches which has to be applied on
> 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot of
> work arounds which you will have to get from oracle for library cache,cache
> buffer chains,ora 7445 errors etc etc etc..
> We had an issue like if I give the command alter system flush shared pool
> the system got hung and all you can see is library cache pin and latch free
> waits and only option was to bring the database was bring it down.
> God I can say they have royally messed up in 8.1.7.2.
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: buffer busy wait & latch free ( cache buffer chain )
> >Date: Tue, 04 Dec 2001 23:05:19 -0800
> >
> >
> >Your statement "there are several bugs relating to waiting for latch-free
> >on cache-buffer-chains, and the possibility of the instance hanging. " has
> >me nervous.
> >
> >I am aware of 1967363 and have obtained the standalone patch for this to be
> >applied on top of 8.1.7.2  I have
> >seen significant wait times for cache buffer chains latch in my 8.1.7.1
> >test environment and am waiting for the
> >environment to be released to me so that I can upgrade it to
> >8.1.7.2.1+1967363  (our production is still 8.0.5 !!).
> >
> >What other bugs are you talking off ?
> >Hemant
> >
> >
> >"Binley Lim" <[EMAIL PROTECTED]>05/12/2001 06:10 AM
> >Sent by: [EMAIL PROTECTED]
> >
> >Please respond to ORACLE-L
> >
> >  To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
> >  Subject: RE: buffer busy wait & latch free ( cache buffer
> >chain )
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >If on 8.1.7, there are several bugs relating to waiting for latch-free on
> >cache-buffer-chains, and the possibility of the instance hanging.
> >
> >One is 1967363, and at least two others are still open after applying that
> >patch.
> >
> >Changing cache buffer latches/buckets is not mentioned in those bugs, and
> >since they are underscored, I would approach with caution.
> >
> >
> > >>> [EMAIL PROTECTED] 12/05/01 08:30AM >>>
> >Vivek:
> > To combat the latch free- cache buffer chain problem, I would first
> >check in v$latch_children if the contention is even across all cache buffer
> >chain latches. If this is the case case (most of the time it is not) , I
> >would add more cache buffer latches. If this is not the case, as ARUN
> >suggested, I would find out which buffers are hot and I would investigate
> >WHY they are hot. (Ussually because of a bad SQL-- you should fix them! )
> > According to BBW problem, try to identify the segment involved and the
> >cause (p1=file , p2=block and p3=cause from a 10046 trace) and then
> >according to p3 there are some changes that can be done.
> >
> >HTH
> >Diego
> >
> >- Original Message -
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Sent: Tuesday, December 04, 2001 9:35 AM
> >
> >
> > > What are u seeing the buffer busy waits on is it for the read
> >intensivity
> > > and latch free is showing that there are hot blocks why dont you find
> >out
> > > the hot blocks and find what can  be done about it
> > >
> > >
> > > >From: "VIVEK_SHARMA" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >Subject: buffer busy wait & latch free ( cache buffer chain )
> > > >Date: Tue, 04 Dec 2001 01:55:19 -0800
> > > >
> > > >
> > > >In report.txt we are getting the wait
> > > >"buffer busy wait" _& wait on "latch free" for "cache buffer chain"
> > > >
> > > >Could an excessively Large db_block_buffer cause this ?
> > > >
> > > >NOTE - Transaction OLTP in nature
> > > >
> > > >NOTE - freelists is set = 2* cpu_count
> > > >
> > > >Any oher advice ?
> > > >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Binley Lim
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be

RE: BMC Patrol DBXray / CA Unicenter

[HAWKINS, JAMES W [IT/1000]]

We looked at Quest extensively, and even began rolling it out.  I/Watch fell
apart at the seams when we tried to scale...

Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 04, 2001 9:55 PM
To: Multiple recipients of list ORACLE-L


Tools!  Tools!  Tools!

Did you look at Quest at all?





-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/4/01 5:35 PM

CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm
interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked
to
look at alternatives (I'm sure the cost will be prohibitive, but we'll
see).

Also if you know of any comparable tools, I'm very interested to hear
about
them.

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

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

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

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

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

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

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

[DENNIS WILLIAMS]

Ed - It sounds like someone at your site "fixed" a previous SGA problem.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 3:25 PM
To: Multiple recipients of list ORACLE-L


Hi,

it seems we have similar situation today. Our production db hangs suddenly.
We couldn't even login
into the db.
Before aborting oracle we found a process like svrmgrl @/tmp/sql. The
body includes single
command 'alter system flush shared_pool'.
It seems it was generated by db agent according to our job timetable in the
OEM. We recently patched
db up to 8.1.7.2 (Linux) in order to get rid of memory leak in the shared
pool...

Regards,
Ed





> One way I can say there are bunch of patches which has to be applied on
> 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot of
> work arounds which you will have to get from oracle for library
cache,cache
> buffer chains,ora 7445 errors etc etc etc..
> We had an issue like if I give the command alter system flush shared pool
> the system got hung and all you can see is library cache pin and latch
free
> waits and only option was to bring the database was bring it down.
> God I can say they have royally messed up in 8.1.7.2.
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: buffer busy wait & latch free ( cache buffer chain )
> >Date: Tue, 04 Dec 2001 23:05:19 -0800
> >
> >
> >Your statement "there are several bugs relating to waiting for latch-free
> >on cache-buffer-chains, and the possibility of the instance hanging. "
has
> >me nervous.
> >
> >I am aware of 1967363 and have obtained the standalone patch for this to
be
> >applied on top of 8.1.7.2  I have
> >seen significant wait times for cache buffer chains latch in my 8.1.7.1
> >test environment and am waiting for the
> >environment to be released to me so that I can upgrade it to
> >8.1.7.2.1+1967363  (our production is still 8.0.5 !!).
> >
> >What other bugs are you talking off ?
> >Hemant
> >
> >
> >"Binley Lim" <[EMAIL PROTECTED]>05/12/2001 06:10 AM
> >Sent by: [EMAIL PROTECTED]
> >
> >Please respond to ORACLE-L
> >
> >  To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
> >  Subject: RE: buffer busy wait & latch free ( cache buffer
> >chain )
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >If on 8.1.7, there are several bugs relating to waiting for latch-free on
> >cache-buffer-chains, and the possibility of the instance hanging.
> >
> >One is 1967363, and at least two others are still open after applying
that
> >patch.
> >
> >Changing cache buffer latches/buckets is not mentioned in those bugs, and
> >since they are underscored, I would approach with caution.
> >
> >
> > >>> [EMAIL PROTECTED] 12/05/01 08:30AM >>>
> >Vivek:
> > To combat the latch free- cache buffer chain problem, I would first
> >check in v$latch_children if the contention is even across all cache
buffer
> >chain latches. If this is the case case (most of the time it is not) , I
> >would add more cache buffer latches. If this is not the case, as ARUN
> >suggested, I would find out which buffers are hot and I would investigate
> >WHY they are hot. (Ussually because of a bad SQL-- you should fix them! )
> > According to BBW problem, try to identify the segment involved and
the
> >cause (p1=file , p2=block and p3=cause from a 10046 trace) and then
> >according to p3 there are some changes that can be done.
> >
> >HTH
> >Diego
> >
> >- Original Message -
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Sent: Tuesday, December 04, 2001 9:35 AM
> >
> >
> > > What are u seeing the buffer busy waits on is it for the read
> >intensivity
> > > and latch free is showing that there are hot blocks why dont you find
> >out
> > > the hot blocks and find what can  be done about it
> > >
> > >
> > > >From: "VIVEK_SHARMA" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >Subject: buffer busy wait & latch free ( cache buffer chain )
> > > >Date: Tue, 04 Dec 2001 01:55:19 -0800
> > > >
> > > >
> > > >In report.txt we are getting the wait
> > > >"buffer busy wait" _& wait on "latch free" for "cache buffer chain"
> > > >
> > > >Could an excessively Large db_block_buffer cause this ?
> > > >
> > > >NOTE - Transaction OLTP in nature
> > > >
> > > >NOTE - freelists is set = 2* cpu_count
> > > >
> > > >Any oher advice ?
> > > >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Binley Lim
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To R

package implementation?

[Seema Singh]

Hi
Is there any impact on old data If I implement dbms_obfuscatio_toolkit after 
some data insert?
Thanks
Seema

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

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

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

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

RE: Partitioning Questions

[Johnston, Tim]

Harvinder...

  What is the access patterns of the queries that will be using these
tables...  Knowing how the data will be accessed is am important factor in
determining how to set this stuff up...  i.e. If your data is historical in
nature and the queries typically access data for via time periods, then a
range partition by date is an excellent choice...  It all depends on the
distribution of your data and how it will be accessed...

Tim

-Original Message-
Sent: Wednesday, December 05, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L


Hi,

The system is Oracle 9i on Sun 2.8

1) Which partitioning is better to use HASH or RANGE. Do there is some
overhead for oracle  
   to calculate the hash number
   (hash partitioning) to find the particular partition. We need to
partition 2 tables of  
   sizes 175G and 162G 
   
2  We have about 10 72G hard drives and 22 9G Hard Drives
   How many partitions to use (does this number depends upon number of hard
disks).
   
3) What should be the ideal size of datafiles.


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

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

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

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

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

[John Kanagaraj]

Dear all,

I had promised a few people on the list that I would send an update about
Listers meeting at OOW, so here goes! 

A few of us got together at a Chevy's restaurant near Moscone for a chance
to say hello and put a face to a name. This included Steve 'Guru' Adams (yes
- *the* Steve A all the way from Downunder), Rachel 'DBA Godess' Carmichael,
Gaja 'Tuning 101' Vaidyanatha, Kirti 'Tuning 101' Deshpande, Ari 'Pocket
DBA' Kaplan, Steve 'now in Montana' Orr, Jeremiah '[EMAIL PROTECTED]'
Wilton, Kevin 'Tap-key' Toepke, Gopala 'X$' Krishnan, Jonathan 'OReilly'
Gennick, Gerardo 'local@Schwab' Molina and John 'sleepless@SanJose'
Kanagaraj. We did miss Eric 'Google-gunner' Pierce though!

Starting off with a first round of free drinks from Ari (c/o Expand Beyond -
thanks Ari!), everyone settled in to talk and listen and order and eat,
amidst swapping stories of glory and honor and sleepless nights recovering
the Db as well as horror stories of layoffs and interviewing clueless
candidates. Also swapped were details of X$ tables and other UNIX internal
structures (who can do without those!) as well as hunting and other
adventure trips. Ari showed us some cool toys (were there more than two
Pocket PCs on you, Ari?) and we all 'Oohed' and 'Aahed' over them.. Steve
A's birthday was celebrated in usual Chevy's style with the gift of a straw
hat and special birthday-boy dessert (although he claimed that his birthday
was actually today as per Australian time!). That was the signal for us to
start splitting - we would have continued through the night if the
restaurant didn't have to close up

Cheers!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Kill your killer-commute! Listen to great commercial-free christian music
24x7 (details at www.klove.com)

** The opinions and statements above are entirely my own and not
those of my employer or clients **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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

Re: RE: Has anyone heard of "Mirror Accessible"?

[sdlockhart]

Ain't being a DBA glamorous???

Me, I'm just in it because I heard that DBA's get all the chicks :)

Believe me, I feel your pain.  I have more Oracle 7.3.4 databases here to upgrade than 
I can say without embarassment.  That's what I get for being the new hire. :)

A fellow DBA,
Scott Lockhart
Oracle DBA
I-Link, Ltd.
Draper, UT
-- 
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).

[Q] ORACLE text string search case problem???

[dist cash]

We have third party application, while doing text string search, user need
type in upper case otherwise nothing display.  The vendor said it is
ORACLE problem, because "MS Access" do NOT have this problem.  Because we
does NOT have application source code, does their has way We can setup
parameter on "init.ora" file to make it work or not?


Our ORACLE version is 8.1.7 on SUN Solaris.


Thanks.



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

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

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

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

RE: Embedding perl in Oracle

[MacGregor, Ian A.]

How well does MySQL scale.  How does it handle parallel direct inserts?  Does it do it 
better than the Oracle OCI interface.  We've got an Oracle experiment running now for 
our channel archive data, real time data from sensors monitoring the  accelerator.   
We haven't switched off the old write to linked files method, and won't for a year.  

However, the proposed NLC, Next Linear Collider,  will need to capture this data at a 
rate of 10,000 gigabytes!! a second.  Of course one might question the utility of 
collecting monitoring data at a petabyte a second.  If the project is approved, people 
have five years to come up with the why and how.

Perhaps I should recommend they use MySQL :)   



-Original Message-
Sent: Wednesday, December 05, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L




Tim,

That sounds rather interesting, as the impression that  MySQL users
sometimes give is that they're perfectly happy with MySQL and
don't have any need to move to Oracle or anything else.

Any particular features of Oracle that the owners feel they
need, or is it a move to satisfy  investors/auditors/etc.?

Jared



   
 
Tim Bunce  
 

ox.com>  cc:   
 
Sent by: Subject: Re: Embedding perl in Oracle 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/05/01 03:30 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> My office mate (cc'd) also set this up to demo the process.  I'm
> considering testing out the possibility of using an Oracle view on
> top of function that calls a extproc_perl to a MySQL database.

I imagine that'll be at least an order of magnitude slower than
using the Oracle ODBC Gateway and MyODBC to do the same thing.
I'll also be read-only.

I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC
for a production system soonish. It's part of a strategy to simplify
migration from MySQL to Oracle.

Tim.

> Tom
>
> On Wed, Dec 05, 2001 at 12:55:31AM +, Tim Bunce wrote:
> > On Tue, Dec 04, 2001 at 01:45:46PM -0800, [EMAIL PROTECTED]
wrote:
> > >
> > > Of course, you can already call Perl from oracle via extproc_perl.
> > >
> > > I've done it, it works.  Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > >
> > > That is being remedied however...
> > >
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> >
> > Oh, very interesting. Thanks.
> >
> >
http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme

> >
> > I'll take a look and add that to my Perl Whirl talk.
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
> _
> 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: Tim Bunce
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Has anyone heard of "Mirror Accessible"?

[Sherman, Edward]

Same here!

I have an HP-UX upgrade and an Oracle upgrade over the holidays.
It's been on the queue for more than a year.

bye-bye Oracle 7.3.4  Woo Hoo

 __   _ =
 -o)/ /  (_)__  __   __ | Ed Sherman    |
 /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |
_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
    | Tel: (407) 859-7410 x2708 |
    =
Supporter of the coalition for grumpiness where grumpiness is due

  




-Original Message-
Sent: Wednesday, December 05, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L


Ain't being a DBA glamorous???

Me, I'm just in it because I heard that DBA's get all the chicks :)

Believe me, I feel your pain.  I have more Oracle 7.3.4 databases here to
upgrade than I can say without embarassment.  That's what I get for being
the new hire. :)

A fellow DBA,
Scott Lockhart
Oracle DBA
I-Link, Ltd.
Draper, UT
-- 
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).


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 

<>

RE: RE: Has anyone heard of "Mirror Accessible"?

[Ron Thomas]

You guys will get no sympathy from me.

We have an Apps 11.5 implementation going live on Jan 1.  In Brazil no less.  And of 
course the PHBs
want this to interface with our local 10.7 installation.

BTW,  Anybody speak Porteguese?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]



   
  
shermanej@ecc  
  
ic.com   To: [EMAIL PROTECTED]  
  
Sent by: cc:   
  
root@fatcity.Subject: RE: RE: Has anyone heard of 
"Mirror Accessible"?   
com
  
   
  
   
  
12/05/01   
  
04:25 PM   
  
Please 
  
respond to 
  
ORACLE-L   
  
   
  
   
  




Same here!

I have an HP-UX upgrade and an Oracle upgrade over the holidays.
It's been on the queue for more than a year.

bye-bye Oracle 7.3.4  Woo Hoo

 __   _ =
 -o)/ /  (_)__  __   __ | Ed Sherman    |
 /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |
_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
    | Tel: (407) 859-7410 x2708 |
    =
Supporter of the coalition for grumpiness where grumpiness is due






-Original Message-
Sent: Wednesday, December 05, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L


Ain't being a DBA glamorous???

Me, I'm just in it because I heard that DBA's get all the chicks :)

Believe me, I feel your pain.  I have more Oracle 7.3.4 databases here to
upgrade than I can say without embarassment.  That's what I get for being
the new hire. :)

A fellow DBA,
Scott Lockhart
Oracle DBA
I-Link, Ltd.
Draper, UT
--
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).


* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
(See attached file: attd84ij.dat)




=?iso-8859-1?Q?attd84ij.dat?=
Description: Binary data

RE: Parallel Server

[Johnston, Tim]

What version and platform???  I've had some exposure to OPS in 7.3 on HP a
couple years ago and it was nightmare...  I've heard it is much better now
though...  Anyone using the 9i stuff yet???  I'm sure there are people with
more recent experience and their input more up to date than mine...  That
being said, my concerns are that OPS is a relatively low usage product for
Oracle...  And therefore, when you encounter an issue, it is more likely
that it is a "new" bug...  Which means more diagnostic patches, down time,
less people with experience to talk to and more sleepless nights...  Been
there, done that...  If I were you, I wouldn't consider it unless it was at
least 8.1 or above...  Get used to raw devices...  I'm not sure, but I think
the Oracle OPS license is fairly expensive...  I really don't know for sure
though...  And, make sure you have enough money in the budget to have an OPS
system in your TEST environment...  Trust me on that one...  Regardless of
the version...  

My questions are...  Is this a new app or will you try to port an existing
app to OPS?  Is this solely a failover standby?  What is the failover time
requirements?  How much money do you have to spend?  Have you considered
standby databases?  Either from Oracle or a third party (i.e. Shareplex)...
How big is the database?

Tim

PS - Yes...  There are classes available for OPS...

-Original Message-
Sent: Wednesday, December 05, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L


Is anyone using Oracle Parallel Server?  It that the best solution for a
standby server?
Any idea what it would cost?  Are there any classes covering implementation?

Ron Smith


-- 
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: Johnston, Tim
  INET: [EMAIL PROTECTED]

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

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

[Binley Lim]

Metalink: advance search on the keywords, click only Bug Database for Sources, and 
take your pick from the list.

>>> [EMAIL PROTECTED] 12/05/01 08:05PM >>>

Your statement "there are several bugs relating to waiting for latch-free
on cache-buffer-chains, and the possibility of the instance hanging. " has
me nervous.

I am aware of 1967363 and have obtained the standalone patch for this to be
applied on top of 8.1.7.2  I have
seen significant wait times for cache buffer chains latch in my 8.1.7.1
test environment and am waiting for the
environment to be released to me so that I can upgrade it to
8.1.7.2.1+1967363  (our production is still 8.0.5 !!).

What other bugs are you talking off ?
Hemant



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

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

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

[Ken Janusz]

 8.1.7 on Dell W2000 server. 

When I try to login via sqlplus I get this: 

ORA-01034 Oracle not available 
ORA-27101 shared memory realm doesn't exist 

Then I get: 

Login: 
Password: 

And this error: 
ORA-12560 TNS: protocol adapter error. 

Any ideas as to what the problem is? 

Thanks, 
Ken Janusz 
Sufficient Systems, Inc. 

  

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

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

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

RE: RE: Has anyone heard of "Mirror Accessible"?

[Kimberly Smith]

You know, such is the life of a DBA.  I did have a Christmas downtime
planned.  Then they shut the plant.  I would rather have the downtime.
Part of the job is making sure that databases are available when
the users want them.  That means that maintenance windows can be tight
and at times that are inconvient to you.  I have yet to see a July 4th
holiday here.  Granted that is ok to me since I still celebrate July 1st.
Thanksgiving...  Thankfully I still use the Canadian version.  I did have
Christmas day off last year but I know that the Unix folks and Network
folks got called in as someone stole the IP for the domain server.  If
you want to make sure that does not happen to you then do not do production
support or only do it on systems that can come down for a majority
of the day.

-Original Message-
Sent: Wednesday, December 05, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L




You guys will get no sympathy from me.

We have an Apps 11.5 implementation going live on Jan 1.  In Brazil no less.
And of course the PHBs
want this to interface with our local 10.7 installation.

BTW,  Anybody speak Porteguese?

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]




shermanej@ecc
ic.com   To: [EMAIL PROTECTED]
Sent by: cc:
root@fatcity.Subject: RE: RE: Has anyone
heard of "Mirror Accessible"?
com


12/05/01
04:25 PM
Please
respond to
ORACLE-L






Same here!

I have an HP-UX upgrade and an Oracle upgrade over the holidays.
It's been on the queue for more than a year.

bye-bye Oracle 7.3.4  Woo Hoo

 __   _ =
 -o)/ /  (_)__  __   __ | Ed Sherman    |
 /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |
_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
    | Tel: (407) 859-7410 x2708 |
    =
Supporter of the coalition for grumpiness where grumpiness is due






-Original Message-
Sent: Wednesday, December 05, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L


Ain't being a DBA glamorous???

Me, I'm just in it because I heard that DBA's get all the chicks :)

Believe me, I feel your pain.  I have more Oracle 7.3.4 databases here to
upgrade than I can say without embarassment.  That's what I get for being
the new hire. :)

A fellow DBA,
Scott Lockhart
Oracle DBA
I-Link, Ltd.
Draper, UT
--
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).


* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
(See attached file: attd84ij.dat)


-- 
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: BMC Patrol DBXray / CA Unicenter

[Kimberly Smith]

I have evaluated I/Watch and it was pretty good.  Especially with
Spotlight.  I have actually seen Spotlight help me quickly identify
a problem which I am not sure I could have found so easily with
out the visual picture.  I had both tools for about 3 months but
could not get anyone to agree to the bucks.

Depending on what you are looking for out of OEM it really is not
a bad tool.  It is the one that is the least intrusive on your servers
and you need not create objects in your database for it.  Thing
I learned though is to make sure you set up warnings for email and not
page.  Really annoying when you get paged at 3AM cause a tablespace is
80% full.  Ya, so, tell me tomorrow.  Make sure you do not have alert
log monitoring on for development systems.  If you do you may be
tempted to kill your developers.  It might not be the best tool out
there but if you work with the right versions of Oracle and use the
OEM agents for 8.1.7 or 9i its pretty good.  It does not have those problems
of not being able to deregister and all that fun stuff that existing
in 8.  Don't forget that the agents do not have be the same version as the
database.

-Original Message-
WILLIAMS
Sent: Wednesday, December 05, 2001 8:20 AM
To: Multiple recipients of list ORACLE-L


I appreciate everyone sharing their experiences.

My question on this topic is what tools are appropriate for what
environments? Some tools seem more extensive (and expensive) and therefore
appropriate to sites with many Oracle instances. I am currently responsible
for 5 production instances all at our HQ datacenter. On those rare occasions
when something goes down, some usually quickly contacts me, so I haven't
felt the need for a monitoring tool. However, we are discussing a project to
put servers in a handful of manufacturing plants and they would be more 23x7
situations, so I have been reviewing OEM (it fails a lot more often than the
instance, I'm not about to turn on its remote notification). Naturally
vendors will claim that their product is just ideal for your type of site.
Does anyone have any input on which monitoring tools are appropriate for
sites with a smaller number of Oracle instances? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 05, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L


I second that, too long to list the problems I had w/ CA Unicenter,
worthless expensive product.  CA touts their product to top management, then
you get the call to implement.  Just my $.02, since you asked :)

Gene

>>> [EMAIL PROTECTED] 12/04/01 08:35PM >>>
CA Unicenter sucks, CA support sucks.  CA sucks.  Stay away.

-Original Message-
Sent: Tuesday, December 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi -

Does anyone have experience with either of these products?  I'm interested
in ease of installation, ease of use, and quality of support.  I realize
they are both pricey, but they both seem to do a lot.  I've been asked to
look at alternatives (I'm sure the cost will be prohibitive, but we'll see).

Also if you know of any comparable tools, I'm very interested to hear about
them.

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

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

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

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

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

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

RE: Unix mailing List

[Sinard Xing]

Thank you.

-Original Message-
Kevin
Sent: Wednesday, 5 December 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Apologies for the last replythe [ -d $FILENAME ] should be [ -a
$FILENAME ].

Hope that helps,
Cheers,
Kev.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 05 December 2001 08:10
To: Multiple recipients of list ORACLE-L


Hi all,

Can someone recommend good unix mailing list

by the way how to check the existence of a file ?

My logic :

if (findThisFile(/tmp/myfile.txt) == 0)
echo "the file is exists"
else
echo "file not found"
endif


what is the unix function for findThisFile()



Thank you,

Sinardy
Hoping Peace in Middle East 
and the rest of the World
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

[Steve McClure]

If I were you I would find a conflict during your testing against the new
version.  If confronted with a problem, few managers will want to press on
and put the production system at risk.  Some folks would say this is passive
aggression.  I'd remind them it is preferable to outright aggression.   Our
jobs consume enough of our personal time, without some Pointy Haired Boss
with a wild hare arbitrarily snatching our weekends.

I should say that this technique was developed while working for a manager
that would force people to complete a task incorrectly; just so she could
meet the goal she had set for management.  She managed our group for about 3
months, but we lived with trashed data for the next two years.

I hope this doesn't mean I have a bad attitude.

Steve McClure

-Original Message-
Sent: Wednesday, December 05, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L

We just had someone from Oracle in yesterday who said
a) it will be a 9.0.2 feature
b) 9.0.2 won't be out until June, 2002

Unfortunately they are still holding fixed to forcing me to come in on
Christmas weekend to upgrade to 8.1.7.  For no good reason.  Forcing me to
cancel the plans I've had with my mother for the last 2 months.  If it
sounds like I'm pissed you're being perceptive.  I've tried to push for
upgrading this database for over a year (last September it was going to be
8.1.6).  Now they're finally letting me do it and are saying (with no notice
and almost no time for testing) that it has to be done at the most
inconvenient time possible for me.

I will refrain from saying exactly what I'm thinking because this is a
family forum :).

Jay Miller

-Original Message-
Sent: Tuesday, December 04, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L



Just got back from OOW and that 'might' be available in Release 2 of 9i.
Which is due out in Spring 2002.

Nick.

-Original Message-
 ]
Sent: Friday, November 30, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


Can anyone confirm this?  I've been searching technet and metalink and can't

turn up any details.

-Original Message-
Sent: Friday, November 30, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


Isn't that just in release 2 though?  My understanding is that its not out
yet.

-Original Message-
Sent: Friday, November 30, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Ah, this sounds likely.  And it might explain why they were keen on having
us upgrade to 9i.  That's the problem with receiving the request filtered
through two additional levels of people.

Jay Miller

-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


9i has a new feature on standby databases that let's you run reports in read

only while continuing the managed recovery.  I think they call it a logical
standby database.  See the 9i DataGuard manual for more information.  (I
just happened to be looking into this lately).  This might be what they are
talking about.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:05 PM


> Only thing I can think of off the top of my head is a standby database
> opened in read only mode.  Its one of the purposes totted for that
>
> -Original Message-
> Sent: Friday, November 30, 2001 9:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that Oracle has
a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he


> might be talking about?
>
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> --
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 lis

Re: buffer busy wait & latch free ( cache buffer chain )

[hemantchitale]

I could find bug#1467575 which relates to Parallel DML hanging on executing
an
ALTER SYSTEM FLUSH SHARED_POOL.
However, as per the README of the 8.1.7.2 PatchSet, this *is* fixed in
8.1.7.2

Did you log a TAR with Oracle Support for this situation where you could
only fix it by restarting
the database ?

Hemant



"Edward Shevtsov" <[EMAIL PROTECTED]>  06/12/2001 05:25 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)

 Subject: Re: buffer busy wait & latch free ( cache buffer chain ) 

   

   

   






Hi,

it seems we have similar situation today. Our production db hangs suddenly.
We couldn't even login
into the db.
Before aborting oracle we found a process like svrmgrl @/tmp/sql. The
body includes single
command 'alter system flush shared_pool'.
It seems it was generated by db agent according to our job timetable in the
OEM. We recently patched
db up to 8.1.7.2 (Linux) in order to get rid of memory leak in the shared
pool...

Regards,
Ed





> One way I can say there are bunch of patches which has to be applied on
> 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot
of
> work arounds which you will have to get from oracle for library
cache,cache
> buffer chains,ora 7445 errors etc etc etc..
> We had an issue like if I give the command alter system flush shared pool
> the system got hung and all you can see is library cache pin and latch
free
> waits and only option was to bring the database was bring it down.
> God I can say they have royally messed up in 8.1.7.2.
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: buffer busy wait & latch free ( cache buffer chain )
> >Date: Tue, 04 Dec 2001 23:05:19 -0800
> >
> >
> >Your statement "there are several bugs relating to waiting for
latch-free
> >on cache-buffer-chains, and the possibility of the instance hanging. "
has
> >me nervous.
> >
> >I am aware of 1967363 and have obtained the standalone patch for this to
be
> >applied on top of 8.1.7.2  I have
> >seen significant wait times for cache buffer chains latch in my 8.1.7.1
> >test environment and am waiting for the
> >environment to be released to me so that I can upgrade it to
> >8.1.7.2.1+1967363  (our production is still 8.0.5 !!).
> >
> >What other bugs are you talking off ?
> >Hemant
> >
> >
> >"Binley Lim" <[EMAIL PROTECTED]>05/12/2001 06:10 AM
> >Sent by: [EMAIL PROTECTED]
> >
> >Please respond to ORACLE-L
> >
> >  To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
> >  Subject: RE: buffer busy wait & latch free ( cache buffer
> >chain )
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >If on 8.1.7, there are several bugs relating to waiting for latch-free
on
> >cache-buffer-chains, and the possibility of the instance hanging.
> >
> >One is 1967363, and at least two others are still open after applying
that
> >patch.
> >
> >Changing cache buffer latches/buckets is not mentioned in those bugs,
and
> >since they are underscored, I would approach with caution.
> >
> >
> > >>> [EMAIL PROTECTED] 12/05/01 08:30AM >>>
> >Vivek:
> > To combat the latch free- cache buffer chain problem, I would first
> >check in v$latch_children if the contention is even across all cache
buffer
> >chain latches. If this is the case case (most of the time it is not) , I
> >would add more cache buffer latches. If this is not the case, as ARUN
> >suggested, I would find out which buffers are hot and I would
investigate
> >WHY they are hot. (Ussually because of a bad SQL-- you should fix them!
)
> > According to BBW problem, try to identify the segment involved and
the
> >cause (p1=file , p2=block and p3=cause from a 10046 trace) and then
> >according to p3 there are some changes that can be done.
> >
> >HTH
> >Diego
> >
> >- Original Message -
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Sent: Tuesday, December 04, 2001 9:35 AM
> >
> >
> > > What are u seeing the buffer busy waits on is it for the read
> >intensivity
> > > and latch free is showing that there are hot blocks why dont you find
> >out
> > > the hot blocks and find what can  be done about it
> > >
> > 

Re: Schema Owner

[Joe Testa]

You can't revoke the privilege from the schema owner but you CAN keep
them from doing ddl and dml by using database triggers.

now the catch is this:

the trigger HAS to be owned by someone other than the schema owner AND
the schema owner can't have the alter any trigger privilege(either
direct or via a role).

so yes Virgina(since its the xmas season), you can keep the schema owner
from altering data in its own schema.

joe

DENNIS WILLIAMS wrote:
> 
> Hamid - this was discussed recently on this list and as I recall you can't
> revoke the schema owner. Can you create a new userid and get them to use
> that? Then change the password on the schema owner. Barring that, you could
> create a new schema, move the tables and indexes there, then grant select to
> the original owner.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, December 05, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> May be odd question, but I realy need to do this, I want to revoke the
> privilege of the schema owner.
> I mean give only select priv to the schema owner.
> Thanks
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)

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

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

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

statspack interpretations

[Tatireddy, Shrinivas (MED, Keane)]

Hi lists,


I have a request to tune the sql statements that are generated in the
statspack report. I have a puff document on statspack. But it is of only
7 pages and explains only how to install and run statspack.

Does anybody have any document /  link for statspack report
intepretations.

if yes, can you please forward.

Thnx and Regards,

Srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

[K Gopalakrishnan]

Definitely. Unless you say NOLOGGING or UNRECOVERABLE (depending on the
versions).  But data dictionary changes are always logged irrespective of
logging mode.

Best Regards,
K Gopalakrishnan


-Original Message-
Shrinivas (MED, Keane)
Sent: Wednesday, December 05, 2001 2:30 AM
To: Multiple recipients of list ORACLE-L

By the way

Does this process (rebuilding of indexes) generate redo?

Srinivas

-Original Message-
Sent: Wednesday, December 05, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L


They do use some rollback but not the volumes you'd
typically need to worry about.  The rollback space is
for mods to the data dictionary as your segments are
created.

hth
connor

 --- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote: > Hi lists,
>
>
> Can anybody clarify this:
>
> Do the sort/idx rebuild  etc.,(tasks that use temp
> tablespace),  use
> rollback segments?
>
> I need to rebuild indexes of 20 Gig to a new
> tablespace.
>
> Do I need to verify the RBS free space for this.?
>
> Thnx and Regards,
>
> Srinivas
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

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


Nokia 5510 looks weird sounds great.
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it!
The competition ends 16 th of December 2001.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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!?
Get your free @yahoo.com address at http://mail.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: Re:Problem with DYNAMIC SQL

[Nikunj Gupta]

Hi,
Assign CREATE TABLE statement to a variable and then issue

EXEC SQL EXECUTE IMMEDIATE 

This should work

HTH
Bye




Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 06:30 AM


> Ehsan,
>
> I don't think so.  In the case you've listed the better way would be
to do:
>
> EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4));
>
> The use of EXECUTE IMMEDIATE is more suited to statements that are
being
> dynamically created on the fly.  This one is not.
>
> Dick Goulet
> Pro*C Evangelist
>
> Reply Separator
> Author: ehsan sinavalda <[EMAIL PROTECTED]>
> Date:   12/5/2001 5:05 AM
>
> Hello
>
> As I found in proc docs the following statement should
> work properly:
>
> EXEC SQL EXECUTE IMMEDIATE
>  "CREATE TABLE dyn1 (col1 VARCHAR2(4))";
>
> But when I want to compile a PROC prog. that has the
> above stmt in a function I recevive the following
> compile error:
>
> sample1.cc: In function `void test()':
> sample1.cc:1313: break statement not within loop or
> switch
>
> Could someone pls help me resolving this problem?
>
> Thanks
>
> E.
>
>
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ehsan sinavalda
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Nikunj Gupta
  INET: [EMAIL PROTECTED]

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

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

Parsing count way to high

[Biddell, Ian]

Hi all,

Just wondering if any one can help me here, I have an online server that
has a number of services within it, just lots of Objects.

But the response time is not what it should and after tracing it I got
this:

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse  878 53.85  53.66  0  0  0
0
Execute  10025  4.54   4.90  3501  14806
9854
Fetch 9694 55.90  57.32108 398540  0
9481
--- --   -- -- -- --
--
total20597114.29 115.88111 399041  14806
19335

So my Parse count is way to high, should be insignificant I would have
thought.
So I increased the maxopencursors and recompiled everything that makes
up the server (.exe)

But no joy. Is there something else I can look at or do?

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

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

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

[Peter . McLarty]

Another site for employment opportunities is www.jobnet.com.au. From there you can find most of the agencies that work in IT employment. You might be best checking out some of there websites and maybe contacting some of those directly about visa requirements etc. 

Jobs aren't so prolific over here either anymore however knowledgeable staff with strong skills are able to gain employment. The current employment climate is sending a bunch of the paper certified's back to there old fields of employment.


HTH

Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






"Diego Cutrone" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/12/2001 05:10 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        Off Topic: Australian Visa


Sorry for the off-topic.
 
I'm from Argentina, and I'm finding out what the steps I should follow to get a visa (for working) or may be a sponsor in Australia.
(A friend of mine told me that Oracle proffesionals have a good chance of getting a job in this country)
 
I hope that someone can help me (may be some Australian) by pointing me where should I be searching for an Australian Sponsor (something like www.dbajobs.com) or Jobs offers.
 
 
Thanks



-- 
This transmission is for the intended addressee only and is confidential
information.  If you have received this transmission in error, please
delete it and notify the sender.  The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group
of companies unless expressly stated otherwise.

Re: Re:Problem with DYNAMIC SQL

[ehsan sinavalda]

Hi, 

--- Nikunj Gupta <[EMAIL PROTECTED]> wrote:
> Hi,
> Assign CREATE TABLE statement to a variable and then
> issue
> 
> EXEC SQL EXECUTE IMMEDIATE 
> 
> This should work

I have tried it before sending the mail, and I tried
it after receiving your mail but I did not work and it
had the same problem

Thanx
E.

> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, December 05, 2001 06:30 AM
> 
> 
> > Ehsan,
> >
> > I don't think so.  In the case you've listed
> the better way would be
> to do:
> >
> > EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4));
> >
> > The use of EXECUTE IMMEDIATE is more suited to
> statements that are
> being
> > dynamically created on the fly.  This one is not.
> >
> > Dick Goulet
> > Pro*C Evangelist
> >
> > Reply
> Separator
> > Author: ehsan sinavalda <[EMAIL PROTECTED]>
> > Date:   12/5/2001 5:05 AM
> >
> > Hello
> >
> > As I found in proc docs the following statement
> should
> > work properly:
> >
> > EXEC SQL EXECUTE IMMEDIATE
> >  "CREATE TABLE dyn1 (col1 VARCHAR2(4))";
> >
> > But when I want to compile a PROC prog. that has
> the
> > above stmt in a function I recevive the following
> > compile error:
> >
> > sample1.cc: In function `void test()':
> > sample1.cc:1313: break statement not within loop
> or
> > switch
> >
> > Could someone pls help me resolving this problem?
> >
> > Thanks
> >
> > E.
> >
> >
> > __
> > Do You Yahoo!?
> > Buy the perfect holiday gifts at Yahoo! Shopping.
> > http://shopping.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: ehsan sinavalda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (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: Nikunj Gupta
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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

RE: Re:Problem with DYNAMIC SQL

[Ganesh Raja]

Hi,

Do u have the privleges granted directly to you ???



Best Regards, 
Ganesh R 
Tel  : +971 (4)  397 3337 Ext 420 
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019


-Original Message-
Sent: Thursday, December 06, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L


Hi, 

--- Nikunj Gupta <[EMAIL PROTECTED]> wrote:
> Hi,
> Assign CREATE TABLE statement to a variable and then
> issue
> 
> EXEC SQL EXECUTE IMMEDIATE 
> 
> This should work

I have tried it before sending the mail, and I tried
it after receiving your mail but I did not work and it
had the same problem

Thanx
E.

> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, December 05, 2001 06:30 AM
> 
> 
> > Ehsan,
> >
> > I don't think so.  In the case you've listed
> the better way would be
> to do:
> >
> > EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4));
> >
> > The use of EXECUTE IMMEDIATE is more suited to
> statements that are
> being
> > dynamically created on the fly.  This one is not.
> >
> > Dick Goulet
> > Pro*C Evangelist
> >
> > Reply
> Separator
> > Author: ehsan sinavalda <[EMAIL PROTECTED]>
> > Date:   12/5/2001 5:05 AM
> >
> > Hello
> >
> > As I found in proc docs the following statement
> should
> > work properly:
> >
> > EXEC SQL EXECUTE IMMEDIATE
> >  "CREATE TABLE dyn1 (col1 VARCHAR2(4))";
> >
> > But when I want to compile a PROC prog. that has
> the
> > above stmt in a function I recevive the following
> > compile error:
> >
> > sample1.cc: In function `void test()':
> > sample1.cc:1313: break statement not within loop
> or
> > switch
> >
> > Could someone pls help me resolving this problem?
> >
> > Thanks
> >
> > E.
> >
> >
> > __
> > Do You Yahoo!?
> > Buy the perfect holiday gifts at Yahoo! Shopping.
> > http://shopping.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: ehsan sinavalda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (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: Nikunj Gupta
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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

Fat City Network Services

Re: Parsing count way to high

[Edward Shevtsov]

Ian,

what type of optimizer do you use?

Regards,
Ed


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 8:50 AM


> Hi all,
> 
> Just wondering if any one can help me here, I have an online server that
> has a number of services within it, just lots of Objects.
> 
> But the response time is not what it should and after tracing it I got
> this:
> 
> OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
> call count   cpuelapsed   disk  querycurrent
> rows
> --- --   -- -- -- --
> --
> Parse  878 53.85  53.66  0  0  0
> 0
> Execute  10025  4.54   4.90  3501  14806
> 9854
> Fetch 9694 55.90  57.32108 398540  0
> 9481
> --- --   -- -- -- --
> --
> total20597114.29 115.88111 399041  14806
> 19335
> 
> So my Parse count is way to high, should be insignificant I would have
> thought.
> So I increased the maxopencursors and recompiled everything that makes
> up the server (.exe)
> 
> But no joy. Is there something else I can look at or do?
> 
> Thanks
> Ian
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Biddell, Ian
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Edward Shevtsov
  INET: [EMAIL PROTECTED]

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

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