date:20010207


The syntax is only OK without the "table"'s in it.  I think you might be
seeing some extra underscores where they aren't.  If I run the sql exactly
as it is in this message, I get the same error message stated here.  Here is
the output:

  1  select * from table A where A.f1 in (
  2  select f1 from table A
  3  minus
  4* select f1 from table B)
SQL> /
select * from table A where A.f1 in (
*
ERROR at line 1:
ORA-00906: missing left parenthesis

> -Original Message-
> From: Jack C. Applewhite [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 3:42 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: NESTED MINUS?
> 
> Mike,
> 
> It's not only possible, but I do it all the time.  In fact I
> just did a query against our database that had a Union
> nested within a Minus nested within an Intersect - not often
> I get to use all three in the same statement!  This
> particular Select hit several tables of over a million rows
> each, with very nice performance - even on Win2k!
> 
> Your problem might be as simple as SQL*Plus getting stupid
> (it happens).  Try moving the initial parenthesis down to in
> front of the select on the next line.  It may not solve your
> problem, but might.  Your syntax is perfectly OK.
> 
> Jack
> 
> 
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> Mike
> Lanteigne
> Sent: Wednesday, February 07, 2001 2:13 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> can you use the minus operator in nested sql
> eg
> select * from table A where A.f1 in (
> select f1 from table A
> minus
> select f1 from table B);
> 
> I'm getting a "missing right parenthesis" error, so I think
> it may not be
> possible!
> 
> Thanks
> 
> Mike
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jack C. Applewhite
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread Paul Baumgartel

Title: Extent allocation



It is a big 
clue.  Oracle rounds to multiples of 5 extents to prevent the existence of 
a free extent of fewer than 5 blocks, which is unlikely to be 
usable.
 
Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 
813-0829 x103 (office) 917 
549-4717 (mobile) 

  -Original Message-From: Yttri, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07, 2001 4:26 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Extent allocation
  Hi - 
  I am confused now about how oracle actually determines the 
  size an extent should be.  I have db_block_size set at 8192 and have 
  defined a tablespace (and tables) at initial and next extents of 128K.  
  When I do a show parameter db_file_multiblock_read_count it says 8.  
  Therefore I thought 128K would be a good number, since it is a multiple of 
  these numbers.
  However, when I check my extent sizes, I see that each extent 
  contains 10 blocks which is 160K. 
  I remember reading an article some time ago about how oracle 
  actually determines what it thinks the extent size should be.  Does 
  anyone know of an article like this, or can anyone explain to me why it chose 
  a different extent size?
  By the way, I looked at several tables and the one common 
  thing I noticed is that the number of blocks allocated seems to be a multiple 
  of 5 - ie. some are 5 blocks, some 10, some 20, etc.  I don't know if 
  that's coincidence or a big clue to the whole thing
  Lisa

RE: Oracle on Unix

2001-02-07 Thread Holman, Rodney


I did this about 4 months ago.  Oracle has probably tired of geting the
irate phone calls on switching CD's. ;)

-Original Message-
Sent: Wednesday, February 07, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


FYI, the box of 817 CDs I got included a sheet of paper warning you to cd
out of the cdrom directory before trying to switch CDs.

Jim

>>> [EMAIL PROTECTED] 02/07/01 03:45PM >>>
Yes,
The java installer is the same look and feel across all platforms.  With
8.1.7 you have 2 CD's on some systems.  Therefore in order to switch CD's
mid install you need to issue the runInstaller command from a directory
other than the CD-ROM.  Such as:
$ cd /home/oracle
$ /cdrom/runInstaller
Doing this allows you to unmount the cdrom and switch cd's when you need to.
This info is not in the readme's.  It was not on metalink the last time I
checked.  And, as you would expect, you need to talk to 3 different support
techs to get someone aware of this little trick.

Rodd Holman

-Original Message-
Sent: Wednesday, February 07, 2001 2:09 PM
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 



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

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

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

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

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

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

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

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

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

2001-02-07 Thread Jack C. Applewhite


Mike,

It's not only possible, but I do it all the time.  In fact I
just did a query against our database that had a Union
nested within a Minus nested within an Intersect - not often
I get to use all three in the same statement!  This
particular Select hit several tables of over a million rows
each, with very nice performance - even on Win2k!

Your problem might be as simple as SQL*Plus getting stupid
(it happens).  Try moving the initial parenthesis down to in
front of the select on the next line.  It may not solve your
problem, but might.  Your syntax is perfectly OK.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Mike
Lanteigne
Sent: Wednesday, February 07, 2001 2:13 PM
To: Multiple recipients of list ORACLE-L


Hi all,

can you use the minus operator in nested sql
eg
select * from table A where A.f1 in (
select f1 from table A
minus
select f1 from table B);

I'm getting a "missing right parenthesis" error, so I think
it may not be
possible!

Thanks

Mike


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

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

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


Try taking out the "table"'s .  This is illegal syntax.  

select * from A where A.f1 in (
select f1 from A
minus
select f1 from B);

The sql above is also very inefficient.  You don't need to do the minus.
Here is the correct syntax:

select * from A where A.f1 not in (
select f1 from B);

> -Original Message-
> From: Mike Lanteigne [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 2:13 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  NESTED MINUS?
> 
> Hi all,
> 
> can you use the minus operator in nested sql
> eg
> select * from table A where A.f1 in (
> select f1 from table A
> minus
> select f1 from table B);
> 
> I'm getting a "missing right parenthesis" error, so I think it may not be
> possible!
> 
> Thanks
> 
> Mike
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mike Lanteigne
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread Oliver Artelt

Hi

select blocks from dba_segments where segment_name ='' shows the size 
of your table.

oli

On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote:
> Hi DBAs
> I have one large table.I want to keep it into memory thru
> alter table  cache;
> Is there any computation formula how much ram this table takes.
> Please help me.Thanks in advance.
> Regards
> -Mala
>
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
---

Oliver Artelt, System- und Datenbankadministration
---
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

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

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

RE: oracle on win2k

2001-02-07 Thread srinivas aradhyula


the machine is not in the network.
--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> did it give anymore detail?  Is the machine on a
> network?
> 
> -Original Message-
> aradhyula
> Sent: Wednesday, February 07, 2001 2:26 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> i installed 8.1.6 on windows 2000 it installed
> succesfully. when i tried to start the service it
> gave
> the ERROR - 1053 from the windows admin Servives,
> 
> where is the problem
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great
> prices.
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: srinivas aradhyula
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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

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

RE: oracle on win2k

2001-02-07 Thread srinivas aradhyula


timing mismatch ... and status goes into starting

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> did it give anymore detail?  Is the machine on a
> network?
> 
> -Original Message-
> aradhyula
> Sent: Wednesday, February 07, 2001 2:26 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> i installed 8.1.6 on windows 2000 it installed
> succesfully. when i tried to start the service it
> gave
> the ERROR - 1053 from the windows admin Servives,
> 
> where is the problem
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great
> prices.
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: srinivas aradhyula
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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

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

Extent allocation

2001-02-07 Thread Yttri, Lisa

Title: Extent allocation





Hi -


I am confused now about how oracle actually determines the size an extent should be.  I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of 128K.  When I do a show parameter db_file_multiblock_read_count it says 8.  Therefore I thought 128K would be a good number, since it is a multiple of these numbers.

However, when I check my extent sizes, I see that each extent contains 10 blocks which is 160K.


I remember reading an article some time ago about how oracle actually determines what it thinks the extent size should be.  Does anyone know of an article like this, or can anyone explain to me why it chose a different extent size?

By the way, I looked at several tables and the one common thing I noticed is that the number of blocks allocated seems to be a multiple of 5 - ie. some are 5 blocks, some 10, some 20, etc.  I don't know if that's coincidence or a big clue to the whole thing

Lisa

RE: Oracle on Unix

2001-02-07 Thread Jim Conboy


FYI, the box of 817 CDs I got included a sheet of paper warning you to cd out of the 
cdrom directory before trying to switch CDs.

Jim

>>> [EMAIL PROTECTED] 02/07/01 03:45PM >>>
Yes,
The java installer is the same look and feel across all platforms.  With
8.1.7 you have 2 CD's on some systems.  Therefore in order to switch CD's
mid install you need to issue the runInstaller command from a directory
other than the CD-ROM.  Such as:
$ cd /home/oracle
$ /cdrom/runInstaller
Doing this allows you to unmount the cdrom and switch cd's when you need to.
This info is not in the readme's.  It was not on metalink the last time I
checked.  And, as you would expect, you need to talk to 3 different support
techs to get someone aware of this little trick.

Rodd Holman

-Original Message-
Sent: Wednesday, February 07, 2001 2:09 PM
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 



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

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

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

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

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

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

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

iFS1.1: penguin gets slaughtered

2001-02-07 Thread Oliver Artelt




Hi,

I've played a little bit with ifs1.1. O.K. the penguin is a little bit
lightweighted for this task (EE8.1.7, SuSE7.0, kernel 2.4.1, 512 MB RAM, 600
MHz PIII) They say that's the minimal configuration for iFS (2 users, 2
protocols) but anyway I only try it out. Now the machine is in polling state,
no load from clients or so are served. The vmstat -he he he:

procs  memoryswap  io system cpu
r  b  w   swpd   free   buff  cache  si  sobibo   incs  us  sy 
 id 2  0  0 256168   4032   1788 227188   0  11 620  185  2174   8  
 8  84 8  0  0 256168   4032   1788 227188   0   0 0 0  106 655563 
 39  61  0 4  0  0 256168   4032   1788 227188   0   0 0 0  104
 591855  39  61  0 2  0  0 256168   4028   1788 227192   0   0 0 6 
 123 552223  45  55  0 8  0  0 256168   4028   1788 227192   0   0 0
 0  104 552822  48  52  0 2  0  0 256168   4028   1788 227192   0   0 0  
  17  140 575998  44  56  0 2  0  0 256168   4028   1788 227192   0   0 0
 6  123 552350  40  60  0 2  0  0 256168   4028   1788 227192   0   0
 0 0  105 553134  42  58  0 2  0  0 256168   4012   1788 227208   0   0  
   2 6  110 503228  45  55  0 8  0  0 256168   4004   1788 227216   0   0
 211  131 666366  33  67  0

Wheew! This penguin got toasted by tons of jre processes. But the machine
reacts on the console easy. Is that normal for a polling iFS-Server? And this
nice try to compensate the ready-to-run contention with these abnormous
exorbitant context switches? He he he -what is big enough to resist an oracle
load test?

oli
---

Oliver Artelt, System- und Datenbankadministration
---
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
---

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

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

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


It will take the same amount of memory that it currently is taking in disk
space.  You will need to increase your cache until it is at least as large
as the number of blocks that are in the table.  If you are running Oracle 8,
then there is a new feature that allows you to assign specific pools to your
tables rather than using the CACHE parameter.  The feature requires
configuration of the init.ora to set aside a KEEP and a RECYCLE pool.  You
then add a POOL KEEP or a POOL RECYCLE command to the create table.

I would question the practice of keeping a large table in memory, however.
How big is "large"?  Oracle already handles caching of the table by cycling
the disk blocks throught the DB_BLOCK_BUFFERS.  If the table is too large,
you may start thrashing your memory with pages and swaps if you get too many
users.

> -Original Message-
> From: mala singh [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 11:56 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  TABLE CACHE
> 
> Hi DBAs
> I have one large table.I want to keep it into memory thru
> alter table  cache;
> Is there any computation formula how much ram this table takes.
> Please help me.Thanks in advance.
> Regards
> -Mala
> 
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: mala singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Elliott, Patrick
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread Djordje Jankovic


I would put it the other way around.  If you need that information in tables
(which I agree is much better than in the report.txt file) edit the utlestat
and put the result in a table, or at least create a file in a loadable
format (series of inserts or file suitable for Sql*Loader), and not go to
report and than to table.
 
The best way though is to create your own utlbstat/utlestat type of script
and record the info that you are interested in, other than letting
utlbstat/utlestat decide what is interesting to you.
 
My 2 cents.
 
Djordje

-Original Message-
Sent: Wednesday, February 07, 2001 3:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
 
Just curious if anyone has a script(s) that will take the contents of the
report.txt file and turn it into loadable files or something along those
lines. I know about 'statspack' but many companies are hesitant to permit
the creation of  tables for storing statistics on their production
databases.
 
Thanks.
-wk

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

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

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

Re:Oracle on Unix


Same screen on HP-UX.  Only problem is that you HAVE to have an Xterminal or
emulator, damn it.

Dick Goulet

Reply Separator
Author: "Nosie" <[EMAIL PROTECTED]>
Date:   2/7/2001 12:00 PM

Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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

8.1.7 DB and auto registration with Listener

2001-02-07 Thread Deshpande, Kirti


Hello All,
 While using the default port number and default listener name with Oracle
8.1.7, the automatic service registration takes place when the database is
started after starting the 8.1.7 Listener. But if the listener is bounced
then the 8.1.7 database does not auto register. However, other 8.1.6
databases do. Anyone ran into this problem? Any possible solution, other
than adding the service name to 8.1.7 listener.ora file? Any help would be
appreciated.
Thanks.
- Kirti Deshpande
 Verizon Information Services 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re: 8.1.7 install

2001-02-07 Thread Oliver Artelt

Hi,

I was also confused by the installer too -Oracle ships a IBM 1.1.8 jre on the 
disk. But I found a jdf 1.2.2 under /usr/local and have this used instead.

oli

On Wednesday 07 February 2001 15:46, [EMAIL PROTECTED] wrote:
> 8.1.7 install prompts for location of a JDK and then falls over when I use
> the default /opt/java
>
> Platform is AIX 4.3.3
>
> What is the pathor do I need to install a JDK?
>
> John

-- 
---

Oliver Artelt, System- und Datenbankadministration
---
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

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

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


In order to get the startup trigger to fire correctly, you need to grant
"EXECUTE ANY PROCEDURE" to the SYS user.  Startup and login triggers fire
before any role grants take place, so the privileges have to be granted
explicitly.

> -Original Message-
> From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 12:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Database Startup Trigger is not pinning all packages
> 
> Why do you want to pin through trigger. Put it into sql file and run it
> as @file_name at startup. For example:
> 
> ORACLE_SID=OPRO4; export ORACLE_SID
> . oraenv
> svrmgrl < @startup
> !!opro4
> sqlplus -s sys/password @opro4_pin_pkg.sql
> 
> Sample file:
> spool opro4_pin_pkg.lst
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.ARP_CASH_RECEIPT_HISTORY');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.ARP_PAY_SCHED');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.ARP_RECEIVABLE_APPLICATIONS');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.ARP_STANDARD');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.FNDCP_CRM');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.FND_CLIENT_INFO');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.FND_GLOBAL');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.FND_INSTALLATION');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.FND_PROFILE');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('APPS.INV_PRJ_CUST_VAL');
> EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.STANDARD');
> spool off
> Regards
> Rafiq
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 07 Feb 2001 08:50:30 -0800
> 
> Greetings,
> 
> I have a database startup trigger which is created from the sys account.
> The trigger is only designed to pin some packages in the shared pool.
> However, the trigger is only pinning the packages that belong to the sys
> account.  I am getting the following error in the alert log file when it
> tries to pin packages which belong to other users:
> 
> Registered presentation http://admin on database startup
> Error in executing triggers on database startup
> *** 2001-02-07 09:00:48.644
> ksedmp: internal or fatal error
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_UTILITY", line 68
> ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
> ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
> ORA-06512: at line 21
> 
> The following is a sample of the trigger:
> 
> CREATE OR REPLACE TRIGGER database_startup
> AFTER STARTUP ON DATABASE
> 
> BEGIN
> 
> sys.dbms_shared_pool.keep('sys.standard');
> sys.dbms_shared_pool.keep('sys.dbms_sys_sql');
> sys.dbms_shared_pool.keep('sys.dbms_sql');
> sys.dbms_shared_pool.keep('sys.dbms_utility');
> sys.dbms_shared_pool.keep('sys.dbms_standard');
> sys.dbms_shared_pool.keep('sys.dbms_output');
> sys.dbms_shared_pool.keep('sys.dbms_pipe');
> 
> sys.dbms_shared_pool.keep('ctxsys.driutl');
> sys.dbms_shared_pool.keep('ctxsys.driutl');
> 
> sys.dbms_shared_pool.keep('oas_public.htp');
> sys.dbms_shared_pool.keep('oas_public.htp');
> END;
> /
> 
> All of the commands in the trigger can be executed successfully when
> logged
> into sqlplus as the sys user with the following syntax:
> 
> BEGIN
> 
> sys.dbms_shared_pool.keep('oas_public.htp');
> sys.dbms_shared_pool.keep('oas_public.htp');
> . . .
> 
> END;
> /
> 
> Because of this I am wondering why the trigger errors out.
> 
> If anyone can help me I greatly appreciate it.  Oracle Support was not
> much
> help.
> 
> Thanks,
> 
> Lindsay Stoddard
> ACS - GSG
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lindsay Stoddard
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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 mail

RE: Oracle on Unix

2001-02-07 Thread Holman, Rodney


Yes,
The java installer is the same look and feel across all platforms.  With
8.1.7 you have 2 CD's on some systems.  Therefore in order to switch CD's
mid install you need to issue the runInstaller command from a directory
other than the CD-ROM.  Such as:
$ cd /home/oracle
$ /cdrom/runInstaller
Doing this allows you to unmount the cdrom and switch cd's when you need to.
This info is not in the readme's.  It was not on metalink the last time I
checked.  And, as you would expect, you need to talk to 3 different support
techs to get someone aware of this little trick.

Rodd Holman

-Original Message-
Sent: Wednesday, February 07, 2001 2:09 PM
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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

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

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


Lisa,

I assume your meaning is NT vs. Unix not NT vs Oracle.  But you do bring a
point.  There are up and down sides all over the place.  Most vendors would
prefer that you handle their application as needing a separate instance &
server.  Well that can cost since you need an Oracle license for each server. 
Having them on one server with separate instances can work, if you have the
disk, memory, etc...  Placing them all in one instance may be better if there is
a need to integrate them but may be impossible if the vendor did some real
stupid stuff with the SYS objects like a certain package from NAI does.  How you
handle it is dependent on the amount of flexibility you want, the amount of
money your willing to pay and the amount of frustration you can stand.  Just be
aware that whichever way you go your going to have a level of frustration no
matter what.  I like to bundle vendor supplied stuff into the same instance if
possible.  Especially if their small applications where the amount of disk used
for the "overhead" (SYSTEM, RBS, TEMP, etc...) is larger than the application
tablespaces.  As far as upgrading Oracle, this is one where you need your
management's support.  We went through the fun with NAI where they did not want
to support Oracle 8.  They demanded to stay on 7.3 which lead to management here
stating that "maybe we need to look for a replacement".  BTW, having your vendor
rep in for a face-to-face discussion on the problem with a signed req. for the
competitors product laying around in full view does help with these
negotiations.

Dick Goulet

Reply Separator
Author: "Yttri; Lisa" <[EMAIL PROTECTED]>
Date:   2/7/2001 7:07 AM

Hi everyone -

I posted this some time ago and didn't really get much response, so I'm
trying again.  For those of you that are implementing multiple application
packages, how to you determine how many Oracle instances and servers to use?
For example - do you build one instance per application package and, if so,
on one server or separate?  Is this possibly a use of NT vs. Oracle (if you
only have 1 small application per instance, you wouldn't necessarily need
the machine power)?

We implemented a few different vendor packages onto one Unix server.  We are
now looking to upgrade oracle (and Solaris) and are having problems finding
a common version that all packages can run on.  I have been asked to propose
a different strategy going forward, so that we have more flexibility for
upgrades, etc.  I would like to hear how others have implemented and
supported the vendor-provided package scenario.

Thanks in advance -
Lisa





Vendor Package Implementation Strategy



Hi everyone -


I posted this some time ago and didn't really get much response,
so I'm trying again.  For those of you that are implementing multiple
application packages, how to you determine how many Oracle instances and servers
to use?  For example - do you build one instance per application package
and, if so, on one server or separate?  Is this possibly a use of NT vs.
Oracle (if you only have 1 small application per instance, you wouldn't
necessarily need the machine power)?

We implemented a few different vendor packages onto one Unix
server.  We are now looking to upgrade oracle (and Solaris) and are having
problems finding a common version that all packages can run on.  I have
been asked to propose a different strategy going forward, so that we have more
flexibility for upgrades, etc.  I would like to hear how others have
implemented and supported the vendor-provided package scenario.

Thanks in advance -
Lisa




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

NESTED MINUS?

2001-02-07 Thread Mike Lanteigne


Hi all,

can you use the minus operator in nested sql
eg
select * from table A where A.f1 in (
select f1 from table A
minus
select f1 from table B);

I'm getting a "missing right parenthesis" error, so I think it may not be
possible!

Thanks

Mike


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

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

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

ora-12547: TNS: lost contact

2001-02-07 Thread Paul Baumgartel


Oracle 8.1.5, Solaris. 

The "oracle" user has no trouble connecting to the local database via the
bequeath adapter.

However, another user, using the same .profile as the oracle user, gets:


SQL*Plus: Release 8.1.5.0.0 - Production on Wed Feb 7 15:30:21 2001
 
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
 
ld.so.1: oracleipdevla: fatal: libucb.so.1: open failed: No such file or
directory
ERROR:
ORA-12547: TNS:lost contact
 

Connecting via SQL*Net is successful.

Any ideas?  Many thanks in advance.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)

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

Bstat/Estat File -> Table?

2001-02-07 Thread Walter K




Hi,
 
Just curious if anyone has a script(s) that will 
take the contents of the report.txt file and turn it into loadable files or 
something along those lines. I know about 'statspack' but many companies are 
hesitant to permit the creation of  tables for storing statistics on their 
production databases.
 
Thanks.
-wk

Oracle on Unix


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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

RE: oracle on win2k

2001-02-07 Thread Kevin Kostyszyn


did it give anymore detail?  Is the machine on a network?

-Original Message-
aradhyula
Sent: Wednesday, February 07, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L


i installed 8.1.6 on windows 2000 it installed
succesfully. when i tried to start the service it gave
the ERROR - 1053 from the windows admin Servives,

where is the problem

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: srinivas aradhyula
  INET: [EMAIL PROTECTED]

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

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

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

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


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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

2001-02-07 Thread Steve Adams


Hi Joan,

Please ignore all lock types other than ST and CF. Please capture all sessions.
It is important to see which session is holding the CF or ST lock when others
are waiting.

Sid 111 has had a TX lock for 1007 seconds, and has been waiting for the CF
enqueue for 3 seconds - this is because the transaction is 1007 seconds old, but
the CF enqueue is only taken intermittently and does not have transaction scope.
This may well not be the first time that this transaction has needed the CF
enqueue, but it is waiting because some other session has a blocking lock. Once
it has obtained and used the CF enqueue lock, it will release it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Thursday, 8 February 2001 4:21
To: Multiple recipients of list ORACLE-L


Hi Steve,

I still couldn't figure out why we have cf enqueue lock. As you suggest, I
run your script repeatedly to see how long the problem persists. All the cf
lock associated locks are tx and tm. Here I choose 4 sid to run. I didn't
find any st lock, but we do have ts and MR lock.

RESOURCE   SID SERIAL# HOLDING WANTING SECONDS
-  --- --- --- ---
CF-0-0  98   19700   X   1
TM-2750-0   98   19700  SX  10
TX-262220-15726098   19700   X  10
CF-0-0 101  72   X   2
TM-2750-0  101  72  SX  14
TX-393292-158320   101  72   X  14
CF-0-0 102  31   X   2
TM-2750-0  102  31  SX 329
TX-131099-158619   102  31   X 328
CF-0-0 111 168   X   3
TM-2750-0  111 168  SX1007
TX-720901-158511   111 168   X1007


RESOURCE  SID HOLDING WANTINGSECONDS
  --- --- --
MR-89-0  DBW0   S 516300
MR-9-0   DBW0   S  0
MR-90-0  DBW0   S 515678
MR-91-0  DBW0   S  91178
MR-92-0  DBW0   S  91178
MR-93-0  DBW0   S  90454
RT-1-0   LGWR   X  0
TM-2750-0 286  SX 22
 1230  SX  0
 1135  SX  0
 1062  SX  0

RESOURCE  SID HOLDING WANTINGSECONDS
  --- --- --
TS-3-16866818SMON  SX 517376


"Looking at this, the sessions are not waiting on the TM and TX locks, but
are holding them. The sessions are waiting on the CF lock (longest wait= 3
seconds)."

"The sessions are holding the TX and TM locks for a long period of time, but
other sessions are not waiting on them, so doesn't appear to be an issue."

*** Can you explain how the timings shown above are computed?  If they are
by process, then how can the CF lock for sid 111 be only 3 seconds, where as
the TX lock for sid 111 is 1007 seconds?

Thanks,

Joan

-Original Message-
Sent: Monday, February 05, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Hi Joan,

You don't have a problem unless there is a session WANTING a lock on the
resource. By "something interesting", I meant a session waiting for a lock
on
either the CF or ST enqueues. Then you run it repeatedly to see how long the
problem persists. Because you are going to run it repeatedly, it would be
good
to hack the script to exclude all other enqueue types. Also, I note that you
are
not running the new version of this script that gives the names of the
background processes instead of their SIDs.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Tuesday, 6 February 2001 1:11
To: Multiple recipients of list ORACLE-L


Steve,

Thank you so much for taking time to reply. I did run couple of times the
enque_lock script as you suggested. CF waiting is really minimum. I noticed
the maximum enqueue comes from MR which is Media Recovery in share lock.
Should I need to concern this or this is just a very normal symptoms for the
database nature?
The real exclusive lock comes from TX. Right now I am starting to look into
it.

MR-8-02   S  0
MR-80-0   2   S 335666
MR-81-0   2   S 335238
MR-82-0   2   S 334850
MR-83-0   2   S 334473
MR-84-0   2   S 334094

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
MR-85-0

Oracle on Unix


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl



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

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

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

2001-02-07 Thread Vandermey, Robert


Lisa,
 
The last company I was at had up to 4 different versions of Oracle on the
same server.  We had 7.3.4 for one package, 8.0.6 for another, 8.1.5 for
another and were doing development on 8.1.6 databases.  There were a total
of 3 development servers with, at one point in time, 30 databases.  These
were all on Sun (Unix) servers. Didn't cause us any problems.  One of the
packages that was on 8.0.6 had up to 12 schemas in it for different levels
of development, i.e. content development, c++ development, utilities
development, etc.  As long as the machine can handle it (CPU, memory, disk
space) you can have multiple versions of Oracle running on it.
 
Bob VanderMey 
Sr. Database Administrator 
McKessonHBOC 
1400 South Wolf Road 
Wheeling, IL. 60090 
e-mail[EMAIL PROTECTED] 
phone847 495-1709 

  

-Original Message-
Sent: Wednesday, February 07, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L



Hi everyone - 

I posted this some time ago and didn't really get much response, so I'm
trying again.  For those of you that are implementing multiple application
packages, how to you determine how many Oracle instances and servers to use?
For example - do you build one instance per application package and, if so,
on one server or separate?  Is this possibly a use of NT vs. Oracle (if you
only have 1 small application per instance, you wouldn't necessarily need
the machine power)?

We implemented a few different vendor packages onto one Unix server.  We are
now looking to upgrade oracle (and Solaris) and are having problems finding
a common version that all packages can run on.  I have been asked to propose
a different strategy going forward, so that we have more flexibility for
upgrades, etc.  I would like to hear how others have implemented and
supported the vendor-provided package scenario.

Thanks in advance - 
Lisa 


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

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

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

RE: How to use Export Transportable Tablespaces

2001-02-07 Thread Tim Sawmiller


This process was repeated monthly.  So, all references in the target database were 
dropped each time the process was performed.


>>> [EMAIL PROTECTED] 02/07/01 11:56AM >>>
Thanks a whole bunch Tim, but one final question.

Why did you drop the tablespaces
 ";
  echo ;
  exit 1;
fi

#
# The tablespaces should always be transported from Stage to Cars databases.
#

if [ `echo $1|grep stage >/tmp/log 2>/tmp/err; echo $?` -eq 1 ] ||
   [ `echo $2|grep cars >/tmp/log 2>/tmp/err; echo $?` -eq 1 ]; then
  echo ;
  echo "Usage :  transport.sh  ";
  echo ;
  exit 1;
fi
  
export ORACLE_SID=$2
#
# Ask for system user passwords on both databases.
#
echo 
echo "Enter system user password for "$2" :\c"
echo  [8m"\c"
read secondpwd
echo  [0m
echo "Enter system user password for "$1" :\c"
echo  [8m"\c"
read firstpwd
echo  [0m

#
# Gather datafiles information for the transportable tablespaces, viz.
# tablespaces stage_haines_data and stage_haines_index.
#

ls -1 /u0??/oradata/$1/stage_haines*data*dbf >/tmp/temp1 2>/tmp/err
ls -1 /u0??/oradata/$1/stage_haines*index*dbf >>/tmp/temp1 2>/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*data*dbf >/tmp/temp2 2>/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*index*dbf >>/tmp/temp2 2>/tmp/err

#
# Exit if this script is being run from different machine than where
databases
# exist.
#

if [ `cat /tmp/temp1|grep "stage_haines" >/tmp/log 2>/tmp/err; echo $?` -eq
1 ] ||
   [ `cat /tmp/temp2|grep "stage_haines" >/tmp/log 2>/tmp/err; echo $?` -eq
1 ]; then
   echo "The databases do not exist on this machine. Please run the script";
   echo "from the machine where databases exist.";
   echo ;
   exit 1;
fi
paste /tmp/temp1 /tmp/temp2 >/tmp/copy_temp.sh
sed 's/^/cp /' /tmp/copy_temp.sh >/tmp/copy_files.sh
sqlplus -s  system/$secondpwd@$2 <>/dev/null
if [ $? = 1 ]; then
  echo "Tablespaces are not self-contained... exiting...";
  exit 1;
fi

#
# Alter the tablespaces in STAGE database to read only mode.
#

export ORACLE_SID=$1
sqlplus -s  system/$firstpwd@$1 <>> [EMAIL PROTECTED] 02/06/01 04:38PM >>>
Could you include the file in your message.  The list strips non-text
attachments.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim
> Sawmiller
> Sent: Tuesday, February 06, 2001 3:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to use Export Transportable Tablespaces
>
>
> Exporting Tablespaces is not achieved using fromuser/touser.  The
> entire tablespace is transported, no matter whose objects are in
> it.  Actually, just the meta data is exported and imported.  The
> other step is to physically copy the files supporting the
> tablespace to a new location and attaching them to the the target
> database.  See attached file for an example.
>
>
>
> >>> [EMAIL PROTECTED] 02/06/01 02:10PM >>>
> There are straightforward examples in the 8.1.7 documentation.  I
> don't know if that feature is available in 8.1.6.  But
> regardless, you should investigate WHY the fromuser/touser didn't
> achieve the desired results or I fear you'll be disappointed again.
>
> Jim
>
> >>> [EMAIL PROTECTED] 02/06/01 12:22PM >>>
>
> Does anyone have an example of how to use transportable tablespaces with
> export/import.
>
> I want export a user (8.1.6 database) source and import fromuser
> touser(8.1.6 database) target.
>
> I tried to import fromuser/ touser, but many contraints were not
> created and
> lost some data
> so I was told to try transportable tables. Can't find any good examples on
> how to use this new
> feature.
>
> Can someone please help me.
>
> Thanks
> Larry
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Larry Taylor
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Jim Conboy
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 ORA

ORA-12547: TNS:lost contact at execution of svrmgrl/sqlplus

2001-02-07 Thread Kanchanakuntla, Suhasini


Hi all,

We are running Oracle 8.1.5 on HP-UX 11.0.  
Recently we started getting an error 'ORA-12547: TNS:lost contact' whenever
trying to connect to svrmgrl.
No upgrades on the server, it was working fine before.
I searched the metalink and tried everything (relinking).  The listener
starts/stops ok.

Here is the output of svrmgrl execution:

gamprime:[/pkg/app/oracle/product/8.1.5/bin]$ svrmgrl

Oracle Server Manager Release 3.1.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

ORA-12547: TNS:lost contact
SVRMGR> connect internal
Password:
ORA-12547: TNS:lost contact
SVRMGR> exit
Server Manager complete.
gamprime:[/pkg/app/oracle/product/8.1.5/bin]$

TIA
Suhasini.

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

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

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

2001-02-07 Thread Cherie_Machler


Lisa,

We have just been upgrading the majority of
our applications that run on Oracle from 7.3.4 to 8.1.5.
Some of the apps do not run on 8.1.5 or are not certified.

Our solution has been to leave some apps where they
are on 7.3.4, have some at 8.0.4 and some at 8.1.5.
In other words, we have multiple Oracle homes and
three different versions of Oracle on most of our Unix
boxes.

This is not the ideal solution but we didn't have
many attractive options.

Cherie Machler
Gelco Information Network




"Yttri, Lisa" <[EMAIL PROTECTED]> on 02/07/2001 09:07:08 AM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)




Hi everyone -

I posted this some time ago and didn't really get much response, so I'm
trying again.  For those of you that are implementing multiple application
packages, how to you determine how many Oracle instances and servers to use?
For example - do you build one instance per application package and, if so,
on one server or separate?  Is this possibly a use of NT vs. Oracle (if you
only have 1 small application per instance, you wouldn't necessarily need
the machine power)?

We implemented a few different vendor packages onto one Unix server.  We are
now looking to upgrade oracle (and Solaris) and are having problems finding
a common version that all packages can run on.  I have been asked to propose
a different strategy going forward, so that we have more flexibility for
upgrades, etc.  I would like to hear how others have implemented and
supported the vendor-provided package scenario.

Thanks in advance -
Lisa


Title: Vendor Package Implementation Strategy





Hi everyone -


I posted this some time ago and didn't really get much response, so I'm trying again.  For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use?  For example - do you build one instance per application package and, if so, on one server or separate?  Is this possibly a use of NT vs. Oracle (if you only have 1 small application per instance, you wouldn't necessarily need the machine power)?

We implemented a few different vendor packages onto one Unix server.  We are now looking to upgrade oracle (and Solaris) and are having problems finding a common version that all packages can run on.  I have been asked to propose a different strategy going forward, so that we have more flexibility for upgrades, etc.  I would like to hear how others have implemented and supported the vendor-provided package scenario.

Thanks in advance -
Lisa

RE: Crontab ,HELP!!!

2001-02-07 Thread Richard Ji

I use
the following method to execute the profile so environment variables

are
all set just like when you manually run the script on the command
line.
00 01 * * * ksh -c ". $HOME/.profile;
/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup"
Richard Ji

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chuck HamiltonSent:
Wednesday, February 07, 2001 12:21 PMTo: Multiple recipients of
list ORACLE-LSubject: Re: Crontab ,HELP!!!
The script probably needs to set up the oracle environment variables
before it will work. Try this.
1) In the oraenv script that's either in /opt/bin or /usr/local/bin
depending on your platform, look for the comment that says "Install any custom
code here" and insert right after it the following line. Don't
forget the dot as the first character.
. /usr/local/bin/profile.ora
2) Create a profile.ora file in /usr/local/bin (or opt/bin) and have
it set up the platform specific environment variables that you need. Ours
looks like this for SGI IRIX64.
SGI_ABI=-64; export
SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export
COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export
LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib;
export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export
LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export
CLASSPATH
3) In your cron scripts, put the following lines at the beginning to set up
the environment.
ORACLE_SID=sidname ; export
ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK.
/opt/bin/oraenv
"Dash, Saroj (CAP,CEF)"
<[EMAIL PROTECTED]> wrote:
Hello
All,I want to run a Job using crontab scheduling.The job is running
butwith error like sqlplus and svrmgrl not found.When I am using the
crontab script then it gives some error ,likesqlplus and svrmgrl not
found.But ths same scripts manually working fine .So please
tell me is there any path will setup to run the crontab . I amrunning
the crontab from oracle id ,not from root.Please tell me what is the
problem if i will run in orcale id. Where i willgive permission so that
it will get the path of sqlplus and svrmgrl .I am sending the out
put of cron .Please see it and tell me.our "cron" job on
JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced
the following output:Started Cold Backup For jlisuser Wed Feb 7
11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J!
! ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not
found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not
found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not
found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not
found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not
foundRegards,saroj.-- Please see the
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj
(CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public
Internet access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe
message BODY, include a line containing: UNSUB ORACLE-L(or the name of
mailing list y! ! ou want to be removed from). You mayalso send the HELP
command for other information (like subscribing).

Do You Yahoo!?Yahoo!
Auctions - Buy the things you want at great
prices.

Re: Database Startup Trigger is not pinning all packages

2001-02-07 Thread Mohammad Rafiq


Why do you want to pin through trigger. Put it into sql file and run it
as @file_name at startup. For example:

ORACLE_SID=OPRO4; export ORACLE_SID
. oraenv
svrmgrl <
Date: Wed, 07 Feb 2001 08:50:30 -0800

Greetings,

I have a database startup trigger which is created from the sys account.
The trigger is only designed to pin some packages in the shared pool.
However, the trigger is only pinning the packages that belong to the sys
account.  I am getting the following error in the alert log file when it
tries to pin packages which belong to other users:

Registered presentation http://admin on database startup
Error in executing triggers on database startup
*** 2001-02-07 09:00:48.644
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at line 21

The following is a sample of the trigger:

CREATE OR REPLACE TRIGGER database_startup
AFTER STARTUP ON DATABASE

BEGIN

sys.dbms_shared_pool.keep('sys.standard');
sys.dbms_shared_pool.keep('sys.dbms_sys_sql');
sys.dbms_shared_pool.keep('sys.dbms_sql');
sys.dbms_shared_pool.keep('sys.dbms_utility');
sys.dbms_shared_pool.keep('sys.dbms_standard');
sys.dbms_shared_pool.keep('sys.dbms_output');
sys.dbms_shared_pool.keep('sys.dbms_pipe');

sys.dbms_shared_pool.keep('ctxsys.driutl');
sys.dbms_shared_pool.keep('ctxsys.driutl');

sys.dbms_shared_pool.keep('oas_public.htp');
sys.dbms_shared_pool.keep('oas_public.htp');
END;
/

All of the commands in the trigger can be executed successfully when logged
into sqlplus as the sys user with the following syntax:

BEGIN

sys.dbms_shared_pool.keep('oas_public.htp');
sys.dbms_shared_pool.keep('oas_public.htp');
. . .

END;
/

Because of this I am wondering why the trigger errors out.

If anyone can help me I greatly appreciate it.  Oracle Support was not much
help.

Thanks,

Lindsay Stoddard
ACS - GSG



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

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Sql Tuning help

2001-02-07 Thread Tim Sawmiller


Instead of customer_id in...try

where exists (select 'x' from customers 
where sb_bets.customer_id = customers.customer_id
and sb_bets.customer_id and LICENSEE_ID=6130)

>>> [EMAIL PROTECTED] 02/07/01 08:30AM >>>
I have been having some problems with this statement 
SELECT to_char(NVL(SUM(bet_amount),0))
FROM sb_bets
WHERE processed_DATE >= add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19-1) AND processed_DATE < add_months(TO_DATE('07011999
00','MMDD HH24MISS'),19) AND customer_id in (select customer_id
from customers
where customers.customer_id=sb_bets.customer_id and LICENSEE_ID=6130)

Both tables are full access no indexes used.  There is an index on
sb_bets.processed_date and customers.customer_id is a primary key and
customers.licensee_id has an index also.  Of course this query may just pull
too many customer ids to bother with an index.  But that is not too bad only
20 records in customers but over 12 million in sb_bets.  Is there a
better way of writing this query?  I have tried hints but still nothing
changed.  Any ideas would be greatly appreciated.

 

Please email me for any further info thanks.

 


  

 
Matt Southcott
DBA 
Starnetsystems
(268) 480 1734
 
 

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

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

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

2001-02-07 Thread exu




Did you use 'dbms_shared_pool.keep' package to ping your objects? and did you
include schema name with the object name.

Below is one example I am using to keep objects in the shared poll immediately
after database startup.

execute dbms_shared_pool.keep ('SWBAPPS.SWSP_TULEAD_PKG');


Eveleen



Please respond to [EMAIL PROTECTED]


"Lindsay Stoddard" <[EMAIL PROTECTED]> on 02/07/2001 10:50:30 AM


  Message - From: "Lindsay Stoddard" <[EMAIL PROTECTED]> on 
 02/07/2001 04:50 PM GMT




  
  
  
 To:  Multiple recipients of list ORACLE-L
  <[EMAIL PROTECTED]>  
  
 cc:  (bcc: Eveleen Xu/NNIB/NNNG) 
  
  
  
 Subject: Database Startup Trigger is not pinning all 
  packages
  






Greetings,

I have a database startup trigger which is created from the sys account.
The trigger is only designed to pin some packages in the shared pool.
However, the trigger is only pinning the packages that belong to the sys
account.  I am getting the following error in the alert log file when it
tries to pin packages which belong to other users:

Registered presentation http://admin on database startup
Error in executing triggers on database startup
*** 2001-02-07 09:00:48.644
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at line 21

The following is a sample of the trigger:

CREATE OR REPLACE TRIGGER database_startup
AFTER STARTUP ON DATABASE

BEGIN

   sys.dbms_shared_pool.keep('sys.standard');
   sys.dbms_shared_pool.keep('sys.dbms_sys_sql');
   sys.dbms_shared_pool.keep('sys.dbms_sql');
   sys.dbms_shared_pool.keep('sys.dbms_utility');
   sys.dbms_shared_pool.keep('sys.dbms_standard');
   sys.dbms_shared_pool.keep('sys.dbms_output');
   sys.dbms_shared_pool.keep('sys.dbms_pipe');

   sys.dbms_shared_pool.keep('ctxsys.driutl');
   sys.dbms_shared_pool.keep('ctxsys.driutl');

   sys.dbms_shared_pool.keep('oas_public.htp');
   sys.dbms_shared_pool.keep('oas_public.htp');
END;
/

All of the commands in the trigger can be executed successfully when logged
into sqlplus as the sys user with the following syntax:

BEGIN

   sys.dbms_shared_pool.keep('oas_public.htp');
   sys.dbms_shared_pool.keep('oas_public.htp');
   . . .

END;
/

Because of this I am wondering why the trigger errors out.

If anyone can help me I greatly appreciate it.  Oracle Support was not much
help.

Thanks,

Lindsay Stoddard
ACS - GSG



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

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

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

2001-02-07 Thread Kimberly Smith


My god, I almost had a cow when I came in this morning.  All
my mail that has cron in it goes to its own folder as I have
all oracle server mail routed to my exchange mail.  I thought
I was having system problems.  

-Original Message-
Sent: Tuesday, February 06, 2001 8:35 PM
To: Multiple recipients of list ORACLE-L


Hi Saroj,

crontab runs within its own environment (ie. it doesn't inherit an
environment from any .profile or /etc/profile etc), so you will have to
explicitly call them in your crontab job line (eg. . /etc/profile;

RE: RE: controlfile schema global enqueue lock

2001-02-07 Thread Joan Hsieh


Hi Steve,

I still couldn't figure out why we have cf enqueue lock. As you suggest, I
run your script repeatedly to see how long the problem persists. All the cf
lock associated locks are tx and tm. Here I choose 4 sid to run. I didn't
find any st lock, but we do have ts and MR lock.

RESOURCE   SID SERIAL# HOLDING WANTING SECONDS
-  --- --- --- ---
CF-0-0  98   19700   X   1
TM-2750-0   98   19700  SX  10
TX-262220-15726098   19700   X  10
CF-0-0 101  72   X   2
TM-2750-0  101  72  SX  14
TX-393292-158320   101  72   X  14
CF-0-0 102  31   X   2
TM-2750-0  102  31  SX 329
TX-131099-158619   102  31   X 328
CF-0-0 111 168   X   3
TM-2750-0  111 168  SX1007
TX-720901-158511   111 168   X1007


RESOURCE  SID HOLDING WANTINGSECONDS
  --- --- --
MR-89-0  DBW0   S 516300
MR-9-0   DBW0   S  0
MR-90-0  DBW0   S 515678
MR-91-0  DBW0   S  91178
MR-92-0  DBW0   S  91178
MR-93-0  DBW0   S  90454
RT-1-0   LGWR   X  0
TM-2750-0 286  SX 22
 1230  SX  0
 1135  SX  0
 1062  SX  0

RESOURCE  SID HOLDING WANTINGSECONDS
  --- --- --
TS-3-16866818SMON  SX 517376


"Looking at this, the sessions are not waiting on the TM and TX locks, but
are holding them. The sessions are waiting on the CF lock (longest wait= 3
seconds)."

"The sessions are holding the TX and TM locks for a long period of time, but
other sessions are not waiting on them, so doesn't appear to be an issue."

*** Can you explain how the timings shown above are computed?  If they are
by process, then how can the CF lock for sid 111 be only 3 seconds, where as
the TX lock for sid 111 is 1007 seconds?

Thanks,

Joan

-Original Message-
Sent: Monday, February 05, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Hi Joan,

You don't have a problem unless there is a session WANTING a lock on the
resource. By "something interesting", I meant a session waiting for a lock
on
either the CF or ST enqueues. Then you run it repeatedly to see how long the
problem persists. Because you are going to run it repeatedly, it would be
good
to hack the script to exclude all other enqueue types. Also, I note that you
are
not running the new version of this script that gives the names of the
background processes instead of their SIDs.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Tuesday, 6 February 2001 1:11
To: Multiple recipients of list ORACLE-L


Steve,

Thank you so much for taking time to reply. I did run couple of times the
enque_lock script as you suggested. CF waiting is really minimum. I noticed
the maximum enqueue comes from MR which is Media Recovery in share lock.
Should I need to concern this or this is just a very normal symptoms for the
database nature?
The real exclusive lock comes from TX. Right now I am starting to look into
it.

MR-8-02   S  0
MR-80-0   2   S 335666
MR-81-0   2   S 335238
MR-82-0   2   S 334850
MR-83-0   2   S 334473
MR-84-0   2   S 334094

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
MR-85-0   2   S 333672
MR-86-0   2   S 333131
MR-87-0   2   S 332593
MR-88-0   2   S 331998
MR-89-0   2   S 331386
MR-9-02   S  0
MR-90-0   2   S 330764
RT-1-03   X  0
TM-2750-0  1459  SX   1262
406  SX987
987  SX968

RESOURCESID HOLDING WANTINGSECONDS
 -- --- --- --
TM-2750-0  1474  SX957
462

RE: Sql Tuning help

2001-02-07 Thread Cale, Rick T (Richard)


Try joining the 2 tables as below. I think the IN will do a FTS always.
Correct me if I'm wrong.

Rick

SELECT to_char(NVL(SUM(a.bet_amount),0))
FROM sb_bets a, customer b
WHERE a.processed_DATE >= add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19-1) 
AND a.processed_DATE < add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19) 
AND a.customer_id = b.customer_id
AND b.licensee_id = 6130;



> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 8:31 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Sql Tuning help
> 
> I have been having some problems with this statement 
> SELECT to_char(NVL(SUM(bet_amount),0))
> FROM sb_bets
> WHERE processed_DATE >= add_months(TO_DATE('07011999 00','MMDD
> HH24MISS'),19-1) AND processed_DATE < add_months(TO_DATE('07011999
> 00','MMDD HH24MISS'),19) AND customer_id in (select customer_id
> from customers
> where customers.customer_id=sb_bets.customer_id and LICENSEE_ID=6130)
> 
> Both tables are full access no indexes used.  There is an index on
> sb_bets.processed_date and customers.customer_id is a primary key and
> customers.licensee_id has an index also.  Of course this query may just
> pull too many customer ids to bother with an index.  But that is not too
> bad only 20 records in customers but over 12 million in sb_bets.  Is
> there a better way of writing this query?  I have tried hints but still
> nothing changed.  Any ideas would be greatly appreciated.
> 
>  
> 
> Please email me for any further info thanks.
> 
>  
> 
> 
>   
> 
>  
> Matt Southcott
> DBA 
> Starnetsystems
> (268) 480 1734
>  
>   << File: Matthew Southcott.vcf >> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread srinivas aradhyula


i installed 8.1.6 on windows 2000 it installed
succesfully. when i tried to start the service it gave
the ERROR - 1053 from the windows admin Servives,

where is the problem

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: srinivas aradhyula
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread Molina, Gerardo


Try:

ps -ef |grep cron

you should see:

/usr/sbin/cron

as one of the entries.  If not, then your cron daemon is not running.

If it is, then it may be the syntax of your crontab entry.

Try:

crontab -l > cron.txt

Post your cron.txt to the list and we'll have a look.

HTH
Gerardo

-Original Message-
Sent: Wednesday, February 07, 2001 2:36 AM
To: Multiple recipients of list ORACLE-L







Hi Molina,
   Yes I want it to run at every day at 1am . But it is not running at
all. My server time is correct .

-- neena 



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

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

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

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

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

2001-02-07 Thread salu Ullah


Hello Waleed.

Set the follwoing parameters.

- LOG_CHECKPOINT_INTERVAL >= the number of OS blocks identical to the redo 
log file size.  It starts a checkpoint only on each switched log file.

- LOG_CHECKPOINT_TIMEOUT = 0.  This disables the checkpointing based on
time interval.


After these two parameters are set correctly, only the switch of a redo log 
starts a new checkpoint.  A correct frequency is normally between 15 and 30 
minutes. If its below, then increase the size of redo logs.


Salu

>From: "Waleed Haggagy \( Nile Networks \)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: NOT COMPLETE LOG
>Date: Wed, 07 Feb 2001 05:00:53 -0800
>
>MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
>DURING FOLLOW UP MY ALERT LOG  FOUND LINES
>
>'CHECKPOINT NOT 
>COMPLETE'
>'Thread 1 cannot 
>allocate
>new log, sequence 609'
>
>WHY?
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Waleed Haggagy \( Nile Networks \)
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

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

TABLE CACHE

2001-02-07 Thread mala singh


Hi DBAs
I have one large table.I want to keep it into memory thru
alter table  cache;
Is there any computation formula how much ram this table takes.
Please help me.Thanks in advance.
Regards
-Mala

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

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

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

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

RE: NT/8.1.6/XML Parser not loading.

2001-02-07 Thread Grabowy, Chris


Argh.  I knew I shouldn't have worked that late last night.  I could have
sworn there was nothing in Metalink, but there is.  Apparently, you have to
run a missing step...

$ORACLE_HOME/javavm/init_security.sql 

...and then it works.

Sorry for the bother. 

-Original Message-
Sent: Wednesday, February 07, 2001 10:15 AM
To: Fatcity's Oracle ListServ; LazyDBA's Oracle ListServ


Hello all,

I am attempting to load the XML Parser into an Oracle 8.1.6 database on NT.

My basic command is...

loadjava -user scott/tiger -r -v xmlparserv2.jar

and I am getting back a series of...

ORA-29545: badly formed class: User has attempted to load a
class(oracle.xmluser), loadclassInPackage

Has anyone encountered this error before?  Any ideas?

TIA!!!

Chris
"May Oracle be with you...always"


Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Sql Tuning help

2001-02-07 Thread Chuck Hamilton

Try turning the subquery into a join like this. Also make sure you've got sufficient hash_area_size to do a hash join instead of a sort/merge join. 20m should be plenty. If you have to, put a use_hash hint on the query to force it to a hash join.
SELECT  to_char(NVL(SUM(bet_amount),0))FROM   sb_bets a, customers bWHERE  a.processed_DATE between     add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) and     add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19)   and a.customer_id = b.customer_id and  b.customer_id=a.customer_id and b.LICENSEE_ID=6130


-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07, 2001 8:31 AMTo: Multiple recipients of list ORACLE-LSubject: Sql Tuning help
I have been having some problems with this statement 

SELECT to_char(NVL(SUM(bet_amount),0))FROM sb_betsWHERE processed_DATE >= add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND processed_DATE < add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19) AND customer_id in (select customer_idfrom customerswhere customers.customer_id=sb_bets.customer_id and LICENSEE_ID=6130)
Both tables are full access no indexes used.  There is an index on sb_bets.processed_date and customers.customer_id is a primary key and customers.licensee_id has an index also.  Of course this query may just pull too many customer ids to bother with an index.  But that is not too bad only 20 records in customers but over 12 million in sb_bets.  Is there a better way of writing this query?  I have tried hints but still nothing changed.  Any ideas would be greatly appreciated.
 
Please email me for any further info thanks.
 
  
 

Matt Southcott
DBA 
Starnetsystems
(268) 480 1734
 
 _This message has been checked for all known viruses by UUNET delivered through the MessageLabs Virus Control Centre. For further information visithttp://www.uk.uu.net/products/security/virus/Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.

RE: NOT COMPLETE LOG

2001-02-07 Thread Cale, Rick T (Richard)


This note is from MetaLink

Rick

 CHECKPOINT NOT COMPLETE 
 === 
  
 At times you may see "checkpoint not complete" messages in the alert log as

 follows: 
  
 Thread 1 advanced to log sequence 248 
   Current log# 2 seq# 248 mem# 0: /prod1/oradata/logs/redologs02.log 
 Thread 1 cannot allocate new log, sequence 249 
 Checkpoint not complete 
  
 These messages indicate that Oracle is ready to recycle the redo logs but
the 
 checkpoint has not been complete on the redo log Oracle needs to accomplish

 this. 
  
 You should also check the bstat/estat report for the statistics 
 BACKGROUND_CHECKPOINTS_COMPLETED and BACKGROUND_CHECKPOINTS_STARTED.  These

 two numbers should never differ by more than 1.  If there is a large 
 difference in these two statistics it indicates that checkpoints are
starting 
 but not completing, just as "checkpoint not complete" messages in the alert

 log indicate. The number of checkpoints completed and started as indicated
by 
 these statistics should be weighed against the duration of the bstat/estat 
 report.  Keep in mind the goal of only one log switch per hour, which
ideally 
 should equate to one checkpoint per hour as well. 
  
  
 The way to resolve incomplete checkpoints is through tuning checkpoints and

 logs: 
  
 1) Give the checkpoint process more time to cycle through the logs 
-  add more redo log groups 
-  increase the size of the redo logs 
  
  
2) Reduce the frequency of checkpoints 
 - increase LOG_CHECKPOINT_INTERVAL 
 - increase size of online redo logs 
  
3) Improve the efficiency of checkpoints 
- enable the CKPT process with CHECKPOINT_PROCESS=TRUE 
  

> -Original Message-
> From: Waleed Haggagy ( Nile Networks ) [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 8:01 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  NOT COMPLETE LOG
> 
> MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
> DURING FOLLOW UP MY ALERT LOG  FOUND LINES
> 
>'CHECKPOINT NOT
> COMPLETE'
>'Thread 1 cannot
> allocate
> new log, sequence 609'
> 
>WHY?
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Waleed Haggagy \( Nile Networks \)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

2001-02-07 Thread Mohammad Rafiq


1-Your log files are small.
2-If message is coming constantly, then you have to increase size of log
files.
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 07 Feb 2001 05:00:53 -0800

MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
DURING FOLLOW UP MY ALERT LOG  FOUND LINES

'CHECKPOINT NOT 
COMPLETE'
'Thread 1 cannot 
allocate
new log, sequence 609'

WHY?



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Waleed Haggagy \( Nile Networks \)
   INET: [EMAIL PROTECTED]

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: problem displaying umlaut character

2001-02-07 Thread Jerry C




Hi Gary and all,
 
Thank you very much for the replies. 
Setting the environment variable NLS_LANG=AMERICAN_AMERICA.UTF8 solved the 
problem.
 
I'm still a little confused as to how all 
this NLS stuff works, though. In the database, we had:
 
nls_language    
string  
AMERICAN  
nls_territory   
string  AMERICA
 
and
 
NLS_CHARACTERSET UTF8
But I still had to set the environment 
variable to store and display the umlaut correctly. Hmm
 
 
Thanks again for your help! 
The virtual British Pale Ale (homebrewed) will be heading your way over the 
ether - no spilling!
 
 
- 
Jerry   


  - Original Message - 
  From: 
  Kirsh, Gary 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, February 06, 2001 1:21 
  PM
  Subject: RE: problem displaying umlaut 
  character
  
  Jerry,
   
  When 
  debugging this type of problem, you need to determine if the umlaut character 
  is being stored incorrectly in the database, or just displayed incorrectly 
  when you select it.  Use the DUMP function to see the internal 
  representation of the character:
   
  select 
  dump(col1) from umlaut where col1='Brömmel';  
   
  Check the ascii value of the 3rd char to see it it is a v or an 
  ö  
  Also, what is 
  the value of NLS_LANG on the client?  Is it AMERICAN_AMERICA.UTF8?  
  What is the client?  Are you on the server, or connecting over 
  sqlnet?  If you are running from a DOS client, you may need to change the 
  code page to display the character 
correctly.
   
  If you post the answers to these 
  questions, I'll try to earn my virtual homebrew!
   
  Gary Kirsh
  Next Extent, 
  Inc
   
   
  
-Original Message-From: Jerry C 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 10:01 
AMTo: Multiple recipients of list ORACLE-LSubject: 
problem displaying umlaut character
Hi all,
 
I'm having problems displaying an 
umlaut character correctly. For example:
create table umlaut(col1 
varchar2(10));  Table created.
 
insert into umlaut 
values('Brömmel'); 1 row created. select * from 
umlaut where col1='Brömmel';  
 
COL1--Brvmmel 
 
My NLS parameters:
 
msuawo01> 
svrmgrl Oracle Server Manager Release 3.1.5.0.0 - 
Production (c) Copyright 1997, Oracle Corporation.  All 
Rights Reserved. Oracle8i Enterprise Edition Release 8.1.5.0.0 
- ProductionWith the Partitioning and Java optionsPL/SQL Release 
8.1.5.0.0 - Production SVRMGR> connect 
internalConnected.SVRMGR> show parameter 
NLSNAME    
TYPE    VALUE--- --- 
--nls_calendar    
string    
nls_comp    
string    
nls_currency    
string    
nls_date_format 
string  
MM/DD/    
nls_date_language   
string    
nls_dual_currency   
string    
nls_iso_currency    
string    
nls_language    
string  
AMERICAN  
nls_numeric_characters  
string    
nls_sort    
string    
nls_territory   
string  
AMERICA   
nls_time_format 
string    
nls_time_tz_format  
string    
nls_timestamp_format    
string    
nls_timestamp_tz_format 
string    

 
SQL> set linesize 125SQL> 
select * from nls_database_parameters ;PARAMETER 
VALUE-- 
--NLS_LANGUAGE 
AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY 
AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET 
UTF8NLS_CALENDAR GREGORIANNLS_DATE_FORMAT 
DD-MON-YYNLS_DATE_LANGUAGE AMERICANNLS_SORT 
BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER 
VALUE-- 
--NLS_TIMESTAMP_FORMAT 
DD-MON-YY HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM 
TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM 
TZH:TNLS_DUAL_CURRENCY $NLS_COMPNLS_NCHAR_CHARACTERSET 
UTF8NLS_RDBMS_VERSION 8.1.5.0.018 rows selected.A 
virtual homebrew (British

Re: Crontab ,HELP!!!

2001-02-07 Thread Chuck Hamilton

 The script probably needs to set up the oracle environment variables before it will work. Try this.
1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after it the following line. Don't forget the dot as the first character.
. /usr/local/bin/profile.ora
2) Create a profile.ora file in /usr/local/bin (or opt/bin) and have it set up the platform specific environment variables that you need. Ours looks like this for SGI IRIX64.
SGI_ABI=-64; export SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib; export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export CLASSPATH
3) In your cron scripts, put the following lines at the beginning to set up the environment.
ORACLE_SID=sidname ; export ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK. /opt/bin/oraenv
  "Dash, Saroj (CAP,CEF)" <[EMAIL PROTECTED]> wrote: 
Hello All,I want to run a Job using crontab scheduling.The job is running butwith error like sqlplus and svrmgrl not found.When I am using the crontab script then it gives some error ,likesqlplus and svrmgrl not found.But ths same scripts manually working fine .So please tell me is there any path will setup to run the crontab . I amrunning the crontab from oracle id ,not from root.Please tell me what is the problem if i will run in orcale id. Where i willgive permission so that it will get the path of sqlplus and svrmgrl .I am sending the out put of cron .Please see it and tell me.our "cron" job on JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced the following output:Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J!
!
ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not foundRegards,saroj.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y!
!
ou want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.

NT/8.1.6/XML Parser not loading.

2001-02-07 Thread Grabowy, Chris


Hello all,

I am attempting to load the XML Parser into an Oracle 8.1.6 database on NT.

My basic command is...

loadjava -user scott/tiger -r -v xmlparserv2.jar

and I am getting back a series of...

ORA-29545: badly formed class: User has attempted to load a
class(oracle.xmluser), loadclassInPackage

Has anyone encountered this error before?  Any ideas?

TIA!!!

Chris
"May Oracle be with you...always"
-- 
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: How to use Export Transportable Tablespaces

2001-02-07 Thread Larry Taylor


Thanks a whole bunch Tim, but one final question.

Why did you drop the tablespaces
 ";
  echo ;
  exit 1;
fi

#
# The tablespaces should always be transported from Stage to Cars databases.
#

if [ `echo $1|grep stage >/tmp/log 2>/tmp/err; echo $?` -eq 1 ] ||
   [ `echo $2|grep cars >/tmp/log 2>/tmp/err; echo $?` -eq 1 ]; then
  echo ;
  echo "Usage :  transport.sh  ";
  echo ;
  exit 1;
fi
  
export ORACLE_SID=$2
#
# Ask for system user passwords on both databases.
#
echo 
echo "Enter system user password for "$2" :\c"
echo  [8m"\c"
read secondpwd
echo  [0m
echo "Enter system user password for "$1" :\c"
echo  [8m"\c"
read firstpwd
echo  [0m

#
# Gather datafiles information for the transportable tablespaces, viz.
# tablespaces stage_haines_data and stage_haines_index.
#

ls -1 /u0??/oradata/$1/stage_haines*data*dbf >/tmp/temp1 2>/tmp/err
ls -1 /u0??/oradata/$1/stage_haines*index*dbf >>/tmp/temp1 2>/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*data*dbf >/tmp/temp2 2>/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*index*dbf >>/tmp/temp2 2>/tmp/err

#
# Exit if this script is being run from different machine than where
databases
# exist.
#

if [ `cat /tmp/temp1|grep "stage_haines" >/tmp/log 2>/tmp/err; echo $?` -eq
1 ] ||
   [ `cat /tmp/temp2|grep "stage_haines" >/tmp/log 2>/tmp/err; echo $?` -eq
1 ]; then
   echo "The databases do not exist on this machine. Please run the script";
   echo "from the machine where databases exist.";
   echo ;
   exit 1;
fi
paste /tmp/temp1 /tmp/temp2 >/tmp/copy_temp.sh
sed 's/^/cp /' /tmp/copy_temp.sh >/tmp/copy_files.sh
sqlplus -s  system/$secondpwd@$2 <>/dev/null
if [ $? = 1 ]; then
  echo "Tablespaces are not self-contained... exiting...";
  exit 1;
fi

#
# Alter the tablespaces in STAGE database to read only mode.
#

export ORACLE_SID=$1
sqlplus -s  system/$firstpwd@$1 <>> [EMAIL PROTECTED] 02/06/01 04:38PM >>>
Could you include the file in your message.  The list strips non-text
attachments.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim
> Sawmiller
> Sent: Tuesday, February 06, 2001 3:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to use Export Transportable Tablespaces
>
>
> Exporting Tablespaces is not achieved using fromuser/touser.  The
> entire tablespace is transported, no matter whose objects are in
> it.  Actually, just the meta data is exported and imported.  The
> other step is to physically copy the files supporting the
> tablespace to a new location and attaching them to the the target
> database.  See attached file for an example.
>
>
>
> >>> [EMAIL PROTECTED] 02/06/01 02:10PM >>>
> There are straightforward examples in the 8.1.7 documentation.  I
> don't know if that feature is available in 8.1.6.  But
> regardless, you should investigate WHY the fromuser/touser didn't
> achieve the desired results or I fear you'll be disappointed again.
>
> Jim
>
> >>> [EMAIL PROTECTED] 02/06/01 12:22PM >>>
>
> Does anyone have an example of how to use transportable tablespaces with
> export/import.
>
> I want export a user (8.1.6 database) source and import fromuser
> touser(8.1.6 database) target.
>
> I tried to import fromuser/ touser, but many contraints were not
> created and
> lost some data
> so I was told to try transportable tables. Can't find any good examples on
> how to use this new
> feature.
>
> Can someone please help me.
>
> Thanks
> Larry
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Larry Taylor
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Jim Conboy
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, Californ

Vendor Package Implementation Strategy

2001-02-07 Thread Yttri, Lisa

Title: Vendor Package Implementation Strategy





Hi everyone -


I posted this some time ago and didn't really get much response, so I'm trying again.  For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use?  For example - do you build one instance per application package and, if so, on one server or separate?  Is this possibly a use of NT vs. Oracle (if you only have 1 small application per instance, you wouldn't necessarily need the machine power)?

We implemented a few different vendor packages onto one Unix server.  We are now looking to upgrade oracle (and Solaris) and are having problems finding a common version that all packages can run on.  I have been asked to propose a different strategy going forward, so that we have more flexibility for upgrades, etc.  I would like to hear how others have implemented and supported the vendor-provided package scenario.

Thanks in advance -
Lisa

RE: Sql Tuning help

2001-02-07 Thread Toepke, Kevin M


Try one of these variations
 
SELECT TO_CHAR(NVL(SUM(sb.bet_amount),0))
FROM  sb_betssb
 ,customers  c
WHERE sb.processed_date >= ADD_MONTHS(TO_DATE('07011999 00','MMDD
HH24MISS'),19-1) 
AND   sb.processed_date < add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19)
AND   sb.customer_id= c.customer_id
AND   c.licensee_id = 6130;
 
Or
  
SELECT TO_CHAR(NVL(SUM(sb.bet_amount),0))
FROM  sb_betssb
WHERE sb.processed_date >= ADD_MONTHS(TO_DATE('07011999 00','MMDD
HH24MISS'),19-1) 
AND   sb.processed_date < add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19)
AND   EXISTS (SELECT 1
  FROM   customers  c
  WHERE  c.customer_id = sb.customer_id
  ANDc.licensee_id = 6130);
 
Make sure the following indexes exist:
sb_bets (processed_date)
customers (customer_id, licensee_id)
 
Kevin

-Original Message-
Sent: Wednesday, February 07, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L


I have been having some problems with this statement 
SELECT to_char(NVL(SUM(bet_amount),0))
FROM sb_bets
WHERE processed_DATE >= add_months(TO_DATE('07011999 00','MMDD
HH24MISS'),19-1) AND processed_DATE < add_months(TO_DATE('07011999
00','MMDD HH24MISS'),19) AND customer_id in (select customer_id
from customers
where customers.customer_id=sb_bets.customer_id and LICENSEE_ID=6130)

Both tables are full access no indexes used.  There is an index on
sb_bets.processed_date and customers.customer_id is a primary key and
customers.licensee_id has an index also.  Of course this query may just pull
too many customer ids to bother with an index.  But that is not too bad only
20 records in customers but over 12 million in sb_bets.  Is there a
better way of writing this query?  I have tried hints but still nothing
changed.  Any ideas would be greatly appreciated.

 

Please email me for any further info thanks.

 


  

 

Matt Southcott
DBA 
Starnetsystems
(268) 480 1734
 
 

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

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

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

RE: RMAN

2001-02-07 Thread Yttri, Lisa

Title: RE: RMAN





That's my dilemma - I would have to install both .. but I have not heard anything good about version 8.1.5.  I don't want to install it and have to deal with all kinds of issues.

Does anyone know - is RMAN always going to be this way (that you need a catalog for each specific version of the software you are running?).  Are there also issues with restoring  -   ie. if I backup an 8.1.5 database, can RMAN restore that into a different version database?

We're trying to determine if this product is worth it, or if we should work on a different backup/recovery strategy.  For now we're doing periodic cold backups and nightly hot backups, with manual management of the output.   That works OK, but we'd like to have a more automated approach.  I'd appreciate hearing about any ideas/strategies that you are using.

Thanks for your help -
Lisa
 --
From: Kevin Kostyszyn
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN
Date: Tuesday, February 06, 2001 4:03PM


I don't know if this is a workaround, but couldn't you use the rman for 815 seperately.  Also, someone on this list said that 815 is not very good.  Just thinkin outloud again.

 -Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yttri, Lisa
Sent: Tuesday, February 06, 2001 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN




Aren't there problems though, if you're running different versions?  For example, we are running 8.1.6 and 8.1.5 database instances.  I had installed 8.1.6 RMAN, but it won't let me register the 8.1.5 version in the catalog.  Does anybody know of a workaround - short of upgrading our 8.1.5 database?

Thanks -
Lisa
 --
From: Vadim Gorbounov
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN
Date: Tuesday, February 06, 2001 3:01PM


    Hi, William,


    I used to have may rman backups since 8.0.5, and I could say, 8.1.6
makes a BIG difference. It is much more stable and worth to go, especially
if you have big/frequantly updated database. Even 8.1.5 is well behind
8.1.6. My preference is to have rman backup information in catalog rather
than controlfile. Anytime you can export it and restore to any database,
even on different platform. Works fine. My current configuration is 8.1.6 on
Solaris + NetBackup.



    Vadim Gorbounov
    Oracle DBA


 -Original Message-
Sent: Tuesday, January 30, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L



Hi,


    At one time, I had implemented RMAN in my 8.0 environment. It had some
bugs, so I went back to my old way of doing backups. Now that I have
upgraded to 8.1.6, I was thinking of re-implementing RMAN. But some of the
discussion here implies that there are still problems. Can someone elaborate
on all of this so we might make an informed decision?



Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]


 --
Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]


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


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

RE: 8.1.7 install

2001-02-07 Thread Molina, Gerardo


Does oracle user have permissions to write into /opt/java ?

-Original Message-
Sent: Wednesday, February 07, 2001 5:36 AM
To: Multiple recipients of list ORACLE-L


8.1.7 install prompts for location of a JDK and then falls over when I use
the default /opt/java

Platform is AIX 4.3.3

What is the pathor do I need to install a JDK?

John





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

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

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

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

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

2001-02-07 Thread Trassens, Christian


Implies that Oracle has to switch the current redo but it hasn't
accomplished a checkpoint that it's been working on. It is a warning that
denotes performance problems. You should increase the size of your redo
logs.

Regards.

> -Mensaje original-
> De:   Waleed Haggagy ( Nile Networks ) [SMTP:[EMAIL PROTECTED]]
> Enviado el:   miércoles 7 de febrero de 2001 14:01
> Para: Multiple recipients of list ORACLE-L
> Asunto:   NOT COMPLETE LOG
> 
> MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
> DURING FOLLOW UP MY ALERT LOG  FOUND LINES
> 
>'CHECKPOINT NOT
> COMPLETE'
>'Thread 1 cannot
> allocate
> new log, sequence 609'
> 
>WHY?
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Waleed Haggagy \( Nile Networks \)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

RE: Sql Tuning help

2001-02-07 Thread Dasko, Dan




Here's 
some thoughts.
 
I 
don't know if between is faster, but it might be, and won't a straight join do 
the same as your subquery?
 
SELECT
  
to_char(NVL(SUM(bet_amount),0))
FROM
  
sb_bets
WHERE
  
processed_DATE between add_months(    .) and 
add_months(   ..) AND
  
customers.customer_id = sb_bets.customer_id AND
  
customer.licensee_id = 6130;
 
Dan 
"Just my thought"

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07, 
  2001 8:31 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Sql Tuning help
  I have been having 
  some problems with this statement 
  
  SELECT 
  to_char(NVL(SUM(bet_amount),0))FROM sb_betsWHERE processed_DATE >= 
  add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) 
  AND processed_DATE < add_months(TO_DATE('07011999 00','MMDD 
  HH24MISS'),19) AND 
  customer_id in (select customer_idfrom 
  customerswhere 
  customers.customer_id=sb_bets.customer_id and 
  LICENSEE_ID=6130)
  Both tables are full access no indexes 
  used.  There is an index on sb_bets.processed_date and 
  customers.customer_id is a primary key and customers.licensee_id has an index 
  also.  Of course this query may just pull too many customer ids to bother 
  with an index.  But that is not too bad only 20 records in customers 
  but over 12 million in sb_bets.  Is there a better way of writing this 
  query?  I have tried hints but still nothing changed.  Any ideas 
  would be greatly appreciated.
   
  Please email me for any further info 
  thanks.
   
    
   
  
  Matt 
  Southcott
  DBA 
  
  Starnetsystems
  (268) 480 
  1734
   
   _This 
  message has been checked for all known viruses by UUNET delivered through 
  the MessageLabs Virus Control Centre. For further information visithttp://www.uk.uu.net/products/security/virus/

RE: V$log Status

2001-02-07 Thread Vadim Gorbounov


Hi Ray,
  There are two different fields in v$log 
 ARCHIVED - tells us if the log is archived or not
 STATUS   - tells us status of data in the log 
  - CURRENT - LGWR is currently writing this log
- ACTIVE - the transactions from this log aren't written to the
datafiles yet (checkpoint not complete), this log is required for instance
recovery
- INACTIVE - log could be reused
- and so on..
What'is important, you have the logs archived but not checkpointed.
this means, DBWR couldn't keep pace with your updates.
Do you have your datafiles on RAID-5? You have to distribute datafiles over
several disks (there are two main options - raid with striping, or manual
distribution) and may be consider partitioning for this table. Many
suggestions in this thread are also very reasonable. Just my $0.02

Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Friday, February 02, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L


My system is in archive mode. What wonders me is that even after archive
files are created the status of the log file is in ACTIVE state.

-Original Message-
Sent: 02 February 2001 14:21
To: Multiple recipients of list ORACLE-L


Most of the times in an archivelog databases that happens because the arch
process is still working. If it was a noarchivelog database, it would be a
block recovering what is going on.

Regards.

> -Mensaje original-
> De:   Raj Gopalan [SMTP:[EMAIL PROTECTED]]
> Enviado el:   viernes 2 de febrero de 2001 13:26
> Para: Multiple recipients of list ORACLE-L
> Asunto:   V$log Status
> 
> Hi All,
> 
> I am doing a batch update which updates around 100,000 rows. While this
> updating is in progress, the system slows down all in a sudden for few
> minutes before it continue to work normally.
> 
> The archive log is enabled and I have 5 online groups with each 10 MB
> size.
> If I check the V$log while updation in progress, I find the status is in
> ACTIVE even after the archive file written for that log. This sequence
> continues until all the log files except current one in ACTIVE state.
> After
> couple of minutes all the ACTIVE status getting changed to INACTIVE.
> 
> Any Idea what could be the reason for this? I got 8.1.6 undex solaris.
> 
> TIA
> 
> Raj
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Raj Gopalan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Trassens, Christian
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

OEM Management Server

2001-02-07 Thread Mark Leith


Hey guys,

I have a quick question about the management server service: Oracle 8.1.6 R2
Win2K box.

I have just installed OEM 2.1 on my machine, and when trying to start the
management server I get the following error:

Could not start the OracleOraHome81ManagementServer service on Local
Computer.

Error 997: Overlapped I/O operation is in progress.


Does anybody know a way of getting around this?

I'm in a bit of a rush on this one so a quick response would be greatly
appreciated.

TIA

Mark



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

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

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

RE: LMT's Question

2001-02-07 Thread Chuck Hamilton

 
  "Kirsh, Gary" <[EMAIL PROTECTED]> wrote: 
Terry,I've seem LMT's used in standby db's without a problem. As a matter offact, if you ever want to use the standby in read-only mode, the temptablespace needs to be a LMT, otherwise any query resulting in a sort todisk will fail.Gary KirshNext Extent, Inc-Original Message-Sent: Tuesday, February 06, 2001 9:08 AMTo: oracledba; oracle listAIX 4.3.3 Oracle 8.1.6.2Is anyone using LMT's in either an OPS environment and/or ad standbydatabase environment? There is some concern here about using LMT'sbecause we are discussing these two options. I don't know or nor forseeany problems, but would like to know if others have any experience.Any input is appreciated and TIA.TerryThink you know someone who can answer the above question? Forward it tothem!to unsubscribe,!
!
 send a blank email to [EMAIL PROTECTED]to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kirsh, GaryINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.

Re:RE: RE: RE: OT NT2K vs Unix.


They're suppose to be in the vendors area of the upcoming IOUG-A, which I hope
to get to.  Wonder if they can do wireless networking from the middle of the
lake?

Dick Goulet

Reply Separator
Author: Suhen Pather <[EMAIL PROTECTED]>
Date:   2/6/2001 1:47 PM

There is a tool called PocketDBA that allows you to do wireless database
management from a PALM OS.
Visit www.pocketdba.com  
Founded by Ari Kaplan, who is one of the list members.
 
 
Suhen
 
 
 

 
How about the DBA tool that runs on a Palm VII, I forgot what is it called.
No voice command but at least you don't have to get out of the bed.

-Original Message-
Sent: Tuesday, February 06, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L



It exists! 

I even see "anti RF" clothing for sale! 


Amazing world. 

-Original Message- 

Sent: Tuesday, February 06, 2001 12:49 PM 
To: Mohan; Ross; Multiple recipients of list ORACLE-L 


Hey, I'm waiting for the wearable computer with the wireless link into the 
network.  Especially if it comes with voice command.  That way when a
"middle of 
the night" problem occurs all I'll have to do is roll over, fix the problem,
and 
then fall back asleep. 

Dick Goulet 

Reply Separator 
Author: "Mohan; Ross" <[EMAIL PROTECTED]> 
Date:   2/6/2001 6:26 AM 

Pithy as hell and twice as true. 

I agree totally..agents...interfacesgraphicsAI... 

-Original Message- 
Sent: Tuesday, February 06, 2001 8:31 AM 
To: Multiple recipients of list ORACLE-L 


The future of computers, look at the games of today. 


 
 Brian L. Anderson 
 Flunky/SA/DBA 
 Darton College 
 [EMAIL PROTECTED] 
 

> -Original Message- 

> are some that I can think of).  Heck, I wouldn't be surprised 
> if the code 
> for some database query optimizers trace back to some gaming 
> AI code.   :) 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Anderson, Brian 
  INET: [EMAIL PROTECTED] 

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

Pithy as hell and twice as true.  
 

I agree 
totally..agents...interfacesgraphicsAI... 
 

-Original Message- 
From: Anderson, Brian [mailto:[EMAIL PROTECTED]
 ">
mailto:[EMAIL PROTECTED]   
achnet.edu] 
Sent: Tuesday, February 06, 2001 8:31 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: RE: OT NT2K vs Unix. 
 
 

The future of computers, look at the games of today. 
 
 

 
 Brian L. Anderson 
 Flunky/SA/DBA 
 Darton College 
 [EMAIL PROTECTED] 
 
 

> -Original Message- 
 

> are some that I can think of).  Heck, I wouldn't
be 
surprised  
> if the code 
> for some database query optimizers trace back to some 
gaming  
> AI code.   :) 
>  
--  
Please see the official ORACLE-L FAQ: http://www.orafaq.com  " TARGET="_blank">
http://www.orafaq.com   
--  
Author: Anderson, Brian 
  INET: [EMAIL PROTECTED] 
 

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

 
 

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

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

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

Re:RE: STOMACH WRENCHINGLY OFFTOPIC RE: RE: RE: OT NT2K vs