RE: PGA

[C.S.Venkata Subramanian]

where can one find the other myths about oracle?

Venkat 
--

On Mon, 31 Mar 2003 06:18:35  
 Connor McDonald wrote:
>Oracle Myth #1745
>
>"When u set the sort_area_size for a database, it will
>allocate that much memory PER USER for any sort
>operation being performed on the database"
>
>
>
> --- "SARKAR, Samir"
><[EMAIL PROTECTED]> wrote: >
>Arvind,
>> 
>> When u set the sort_area_size for a database, it
>> will allocate that much
>> memory PER USER
>> for any sort operation being performed on the
>> database. In practice, it
>> means that if u allocate 
>> too high a value for the sort_area_size and multiple
>> users are performing
>> multiple sorts, the Unix
>> system may run out of memory and Oracle will return
>> u a process memory
>> error.
>> 
>> For eg. if u have ur sort_area_size as 100MB and u
>> have 10 users performing
>> sort operations 
>> on the database, Oracle will take up 100*10 MB
>> memory. This might degrade ur
>> system performance.
>> 
>> Samir
>> 
>> Samir Sarkar
>> Oracle DBA 
>> SchlumbergerSema
>> Email  :  [EMAIL PROTECTED] 
>> Phone : +44 (0) 115 - 957 6028
>> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
>> Fax : +44 (0) 115 - 957 6018
>> 
>> 
>> -Original Message-
>> Sent: 31 March 2003 11:04
>> To: Multiple recipients of list ORACLE-L
>> 
>> 
>> hello all,
>> 
>>  how does increasing the value of SORT_AREA_SIZE
>> affect the unix system
>> perfomance.
>> 
>> 
>> Thanks
>> Arvind
>> -- 
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.net
>> -- 
>> Author: Arvind Kumar
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> San Diego, California-- Mailing list and web
>> hosting services
>>
>-
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (or the name of mailing list you want to be removed
>> from).  You may
>> also send the HELP command for other information
>> (like subscribing).
>> 
>> 
>>
>_
>> This email is confidential and intended solely for
>> the use of the 
>> individual to whom it is addressed. Any views or
>> opinions presented are 
>> solely those of the author and do not necessarily
>> represent those of 
>> SchlumbergerSema.
>> If you are not the intended recipient, be advised
>> that you have received
>> this email in error and that any use, dissemination,
>> forwarding, printing, 
>> or copying of this email is strictly prohibited.
>> 
>> If you have received this email in error please
>> notify the
>> SchlumbergerSema Helpdesk by telephone on +44 (0)
>> 121 627 5600.
>>
>_
>> 
>> -- 
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.net
>> -- 
>> Author: SARKAR, Samir
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> San Diego, California-- Mailing list and web
>> hosting services
>>
>-
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (or the name of mailing list you want to be removed
>> from).  You may
>> also send the HELP command for other information
>> (like subscribing).
>>  
>
>=
>Connor McDonald
>web: http://www.oracledba.co.uk
>web: http://www.oaktable.net
>email: [EMAIL PROTECTED]
>
>"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he 
>will sit in a boat and drink beer all day"
>
>__
>Yahoo! Plus
>For a better Internet experience
>http://www.yahoo.co.uk/btoffer
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: =?iso-8859-1?q?Connor=20McDonald?=
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>


_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: C.S.Venkata Subr

RE: help

[Arvind Kumar]

its a single instance system..here is some more details ...pls suggest
if something needs to be corrected

   SHARED_POOL_SIZE=190MB
   DB_BLOCK_SIZE   = 4KB
   DB_BLOCK_BUFFERS = 125000 (488MB)
   LOG_BUFFER = 5MB
   SORT_AREA_SIZE = 2MB
   SORT_AREA_RETAINED_SIZE = 1MB
   DB_WRITER_PROCESSES =4
   LOG_ARCHIVE_MAX_PROCESS = 3

   AND THE MOST WAITED EVENT IN V$SYSTEM_EVENT IS 'DB_FILE_SCATTERED_READ'
,TO REDUCE ITS WAIT 
TIME I HAVE INCREASED THE DB_FILE_MULTIBLOCK_READ_COUNT FROM 16 TO 64 ,BUT
STILL SWAPPING SIZE IS SAME FROM 'TOP' COMMAND IN UNIX


Regards
Arvind 

-Original Message-
Sent: Monday, March 31, 2003 10:19 PM
To: Multiple recipients of list ORACLE-L


Hi!

You didn't send your SHARED_POOL_SIZE parameter
value...
but... 

usually, when the machine swaps is due to not enough
memory allocated!

I would check your shared_pool_size, sort_area_size,
and db_block_buffer for verifying that there's enough
memory asigned.

Of course, you should diagnose memory problems on your
OS and Oracle.

HTH
JL

--- Arvind Kumar <[EMAIL PROTECTED]> wrote:
> 
> Hello all,
> 
>  i am facing swapping problem ..below is the
> details
> 
> 
>System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB
> SWAP SPACE
> 
>DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER
> CACHE HIT RATIO IS ABOVE
> 93%
> 
>   Now the problem is of swapping there are about 70
> oracle users using this
> database ,swap utilization is always above 1.5gb.
> 
> what could be the problem...
> 
> 
>  Thanks
> Arvind Kumar
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]> (by way of Jared
> Still <[EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

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

RE: help

[Arvind Kumar]

No,

its a single instance system..here is some more details ...pls suggest
if something needs to be corrected

   SHARED_POOL_SIZE=190MB
   DB_BLOCK_SIZE   = 4KB
   DB_BLOCK_BUFFERS = 125000 (488MB)
   LOG_BUFFER = 5MB
   SORT_AREA_SIZE = 2MB
   SORT_AREA_RETAINED_SIZE = 1MB
   DB_WRITER_PROCESSES =4
   LOG_ARCHIVE_MAX_PROCESS = 3

   AND THE MOST WAITED EVENT IN V$SYSTEM_EVENT IS 'DB_FILE_SCATTERED_READ'
,TO REDUCE ITS WAIT 
TIME I HAVE INCREASED THE DB_FILE_MULTIBLOCK_READ_COUNT FROM 16 TO 64 ,BUT
STILL SWAPPING SIZE IS SAME FROM 'TOP' COMMAND IN UNIX


Regards
Arvind 
  


-Original Message-
Sent: Monday, March 31, 2003 11:09 PM
To: Multiple recipients of list ORACLE-L


Arvind ,
Do you have any other  instance or application running on same box ?
-ak

- Original Message -
<[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 7:54 AM


>
> Hello all,
>
>  i am facing swapping problem ..below is the details
>
>
>System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE
>
>DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE
> 93%
>
>   Now the problem is of swapping there are about 70 oracle users using
this
> database ,swap utilization is always above 1.5gb.
>
> what could be the problem...
>
>
>  Thanks
> Arvind Kumar
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]> (by way of Jared Still
<[EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

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

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

RE: AIX 5L - what is it?

[Rich Holland]

Title: Message



5L is 
the designation for "Linux affinity".  The output of 'oslevel -r' will tell 
you your release and maintenance level.  For example, 5100-02 means you're 
running AIX 5L 5.1 maint level 02.
 
The 
reason there are two different downloads is that 64-bit code is OS dependant; 
64-bit 4.3.x code is NOT binary compatible with the 5.x 64-bit operating 
environment.  All 32-bit code is compatible.
 
Rich

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Vladimir BaracSent: 
  Monday, March 31, 2003 8:58 AMTo: Multiple recipients of list 
  ORACLE-LSubject: AIX 5L - what is it?
  Hello to everyone
   
  I see two options for 9i download at 
  "technet" site - "AIX" and "AIX based 5L systems".
   
  What does that difference 
  mean?
   
  How do I find out whether server is one 
  or the other?
   
  Thanks,
   
  Vladimir 
Barac

RE: AIX 5L - what is it?

[Ron Yount]

Title: Message



AIX 5L 
is version 5.1 or 5.2, as opposed to not 5L which would be 
4.3.x

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Vladimir BaracSent: 
  Monday, March 31, 2003 7:58 AMTo: Multiple recipients of list 
  ORACLE-LSubject: AIX 5L - what is it?
  Hello to everyone
   
  I see two options for 9i download at 
  "technet" site - "AIX" and "AIX based 5L systems".
   
  What does that difference 
  mean?
   
  How do I find out whether server is one 
  or the other?
   
  Thanks,
   
  Vladimir 
Barac

Re: SQL Query -- List of managers

[Vladimir Begun]

Vladimir Begun wrote:
 SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2, 
typo: ^RTRIM
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN question....

[DENNIS WILLIAMS]

Chris - Do you have any more details on the files you deleted that you felt
were snapshot control files? How large?
 
I may be incredibly stupid, but for the life of me I can't figure out why
you would ask RMAN to restore your controlfile from backup. Was it corrupt?
I would assume bad things could happen if you did that. I could see backing
it up just to be safe. Was this a test database? Anyway I'm always willing
to learn.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

 
 -Original Message-
Sent: Monday, March 31, 2003 3:54 PM
To: Multiple recipients of list O d  RACLE-L



List, 

When I got into work this morning I noticed u01 was nearly full on out
production OLTP machine.  I found the files and the looked to be RMAN files.

They were all in '$ORACLE_HOME/dbs/.'  My first thought was that they were
the snapshot controlfiles.  but aren't those automatically deleted?  I
double checked the RMAN scripts I use to make sure nothing was explicitly
written there.  They weren't.  So I deleted those files.  I next ran the
following on one of the databases:

RMAN> run { 
2> allocate channel d1 type disk; 
3> restore database validate; 
4> } 

that returned successfully. (whew) 

then: 

RMAN>  run { 
2> allocate channel d1 type disk; 
3> restore controlfile validate; 
4> } 

RMAN-03022: compiling command: allocate 
RMAN-03023: executing command: allocate 
RMAN-08030: allocated channel: d1 
RMAN-08500: channel d1: sid=14 devtype=DISK 

RMAN-03022: compiling command: restore 
RMAN-03025: performing implicit partial resync of recovery catalog 
RMAN-03023: executing command: partial resync 
RMAN-08003: starting partial resync of recovery catalog 
RMAN-08005: partial resync complete 

RMAN-03022: compiling command: IRESTORE 
RMAN-03023: executing command: IRESTORE 
RMAN-08518: channel d1: scanning controlfile copy
/oracle_backup/ASTU/astu_ctl 
RMAN-03026: error recovery releasing channel resources 
RMAN-08031: released channel: d1 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-03002: failure during compilation of command 
RMAN-03013: command type: restore 
RMAN-03006: non-retryable error occurred during execution of command:
IRESTORE 
RMAN-07004: unhandled exception during command execution on channel d1 
RMAN-10035: exception raised in RPC: ORA-00600: internal error code,
arguments:] 
ORA-19600: input file is datafile copy 0 () 
RMAN-10031: ORA-600 occurred during call to
DBMS_BACKUP_RESTORE.SCANDATAFILECOPY 

RMAN> exit 


YIKES!!  

anybody have an idea why this would happen?? 

Here is the backup script that is used each night (it's the same for all 3
databases minus the changes is ORACLE_SID and sub-directories):

#!/bin/sh 
export ORACLE_HOME=/u01/app/oracle/product/8.1.7 
export ORACLE_SID=ASTU 
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ 

rm /oracle_backup/$ORACLE_SID/* 
$ORACLE_HOME/bin/rman 

Re: SQL Query -- List of managers

[Vladimir Begun]

Hello

9i (ORA-01489! be aware):

 SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2, 19)) ename
  , ename mgrs
   FROM emp
CONNECT BY PRIOR mgr = empno
/
Eberhard, Jeff wrote:
Using the EMP table as an example I want to create a query that will show a
list of employees and the mgrs above them.  Like this:
ENAME   MGRS 
--- -- 
SMITH   SMITH
SMITH   FORD 
SMITH   JONES  
SMITH   KING  
..
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: index ??

[AK]

Title: Re: index ??



is has got lots of distinct values .
 
 

  - Original Message - 
  From: 
  Wolfgang 
  Breitling 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 31, 2003 2:38 
PM
  Subject: Re: index ??
  
  Sorry, forgot to ask the first time.  What is the 
  selectivity of B? 
  At 12:53 PM 3/31/2003 -0800, you wrote: >well , at A is not null and pt present there is only one distinct 
  value in A. > >ak 
  >- Original Message - >From: Wolfgang 
  Breitling >To: Multiple 
  recipients of list ORACLE-L >Sent: Monday, March 
  31, 2003 10:34 AM >Subject: Re: index ?? 
  > >What is the selectivity of 
  column A? How many distinct values? Is A >nullable? 
  How many rows and blocks in the table and what are the nr of leaf 
  >blocks and the clustering factors of the indexes? 
  > >At 09:08 AM 3/31/2003 -0800, 
  you wrote: > > >I 
  have a table X with unix index on column A ,B and non unique index on 
  > >A,C,D  . The query give below doesn't use any 
  index . > > > >I 
  thought its due to  function nvl being used here , so made a change 
  in > >query to  replace > > > >B = NVL(:b2,B)  
  with   (B=:b2 or :b2 is null  ) , but this one also not 
  > >using index . Why if I put an or condition it 
  doesn't use index while if I > >put and 
  condition it will used ? > > > >IS there any way I can change query or index so that it starts 
  using index > >( in a better way ) 
  > > > > > > > >Thanks, > > > >-ak > > > > > > > > > > > > > > > >SELECT   z 
  > > > >FROM 
  > > > >X > > > >WHERE > > > >A = :b1 AND > > > >B = NVL(:b2,B) AND 
  > > > >C= nvl(:b3,C) 
  And > > > 
  >D=nvl(:b4,D) > > > > > > > > > > > > > >Wolfgang Breitling >Centrex Consulting 
  Corporation >http://www.centrexcc.com > 
  >  
   > >This email communication is intended as a private communication for 
  the >sole use of the primary addressee and those 
  individuals listed for copies >in the original 
  message. The information contained in this email is >private and confidential and if you are not an intended recipient 
  you are >hereby notified that copying, forwarding 
  or other dissemination or >distribution of this 
  communication by any means is prohibited.  If you are >not specifically authorized to receive this email and if you 
  believe that >you received it in error please 
  notify the original sender >immediately.  We 
  honour similar requests relating to the privacy of email >communications. >Cette communication par 
  courrier électronique est une communication privée >à l'usage exclusif du destinataire principal ainsi que des 
  personnes dont >les noms figurent en copie.  
  Les renseignements contenus dans ce courriel >sont 
  confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes 
  >avisé, par les présentes que toute reproduction, 
  tout transfert ou toute >autre forme de diffusion 
  de cette communication par quelque moyen que ce >soit est interdit.  Si vous n'êtes pas spécifiquement autorisé 
  à recevoir >ce courriel ou si vous croyez l'avoir 
  reçu par erreur, veuillez en aviser >l'expéditeur 
  original immédiatement.  Nous respectons les demandes >similaires qui touchent la confidentialité des communications par 
  courrier >électronique. 
  Wolfgang Breitling Centrex Consulting 
  Corporation http://www.centrexcc.com 
   
   
  This email communication is intended as a private 
  communication for the sole use of the primary addressee and those individuals 
  listed for copies in the original message. The information contained in this 
  email is private and confidential and if you are not an intended recipient you 
  are hereby notified that copying, forwarding or other dissemination or 
  distribution of this communication by any means is prohibited.  If you 
  are not specifically authorized to receive this email and if you believe that 
  you received it in error please notify the original sender immediately.  
  We honour similar requests relating to the privacy of email 
  communications.
  Cette communication par courrier électronique est une 
  communication privée à l'usage exclusif du destinataire principal ainsi que 
  des personnes dont les noms figurent en copie.  Les renseignements 
  contenus dans ce courriel sont confidentiels et si vous n'êtes pas le 
  destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, 
  tout transfert ou toute autre forme de diffusion de cette communication par 
  quelque moyen que ce soit est interdit.  Si vous n'êtes pas 
  spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu 
  par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous 
  respectons les demandes similaires qui touchent la confidentialité des 
  communications par courrier électronique.

Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?

[Tim Bunce]

I released DBD::Oracle 1.14 a few days ago.

In the release notes I said:

  NOTE: OCI 7 and Oraperl will not be supported in future releases.

I'm keen to rip out the old OCI7 API code to make it easier to add
support for more OCI8 features.

I've had no reaction to that yet so I can't gauge how much of a
problem that might be for some people. I know Oracle are ceasing
to support Oracle 7 but there are certainly some Oracle 7 installation
in production in strange places/situations.

And there may be some script/applications based on Oraperl but now
talking to Oracle 8 or 9 servers.

So I thought I'd ask here.

At the end of the day I guess anyone using Oracle 7 in production
with DBD::Oracle / Oraperl has to live with the bugs in Oracle 7
and whatever version of DBD::Oracle / Oraperl they're using.
(At least they wouldn't need such a fat cheque book to get support
from me if they really needed it :)

And converting from Oraperl is a fairly mechanincal process.

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

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

how to calculate table size

[Basavaraja, Ravindra]

Hi,

Anyone having any formula to calculate table size?Basically to estimate the growth of 
table over a peroid of time.
I have the row_size,db_block_size.How do i get the table size.

Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Basavaraja, Ravindra
  INET: [EMAIL PROTECTED]

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

SQL Query -- List of managers

[Eberhard, Jeff]

Using the EMP table as an example I want to create a query that will show a
list of employees and the mgrs above them.  Like this:

ENAME   MGRS 
--- -- 
SMITH   SMITH
SMITH   FORD 
SMITH   JONES  
SMITH   KING  
ALLEN   ALLEN 
ALLEN   BLAKE   
ALLEN   KING
WARDWARD
WARDBLAKE   
WARDKING
JONES   JONES   
JONES   KING
MARTIN  MARTIN  
MARTIN  BLAKE   
MARTIN  KING
BLAKE   BLAKE   
BLAKE   KING
CLARK   CLARK   
CLARK   KING
SCOTT   SCOTT   
SCOTT   JONES   
SCOTT   KING
KINGKING
TURNER  TURNER  
TURNER  BLAKE   
TURNER  KING
ADAMS   ADAMS   
ADAMS   SCOTT   
ADAMS   JONES   
ADAMS   KING
JAMES   JAMES   
JAMES   BLAKE   
JAMES   KING
FORDFORD
FORDJONES   
FORDKING
MILLER  MILLER  
MILLER  CLARK   
MILLER  KING





So far I've got it to this:

  1  select lpad(' ',3*level-3)||ename org_char, leve
  2  empno, mgr
  3  from emp
  4* connect by prior mgr = empno

ORG_CHAR LEVEL  EMPNOMGR
--- -- -- --
SMITH1   7369   7902
   FORD  2   7902   7566
  JONES  3   7566   7839
 KING4   7839
ALLEN1   7499   7698
   BLAKE 2   7698   7839
  KING   3   7839
WARD 1   7521   7698
   BLAKE 2   7698   7839
  KING   3   7839
JONES1   7566   7839
   KING  2   7839
MARTIN   1   7654   7698
   BLAKE 2   7698   7839
  KING   3   7839
BLAKE1   7698   7839
   KING  2   7839
CLARK1   7782   7839
   KING  2   7839
SCOTT1   7788   7566
   JONES 2   7566   7839
  KING   3   7839
KING 1   7839
TURNER   1   7844   7698
   BLAKE 2   7698   7839
  KING   3   7839
ADAMS1   7876   7788
   SCOTT 2   7788   7566
  JONES  3   7566   7839
 KING4   7839
JAMES1   7900   7698
   BLAKE 2   7698   7839
  KING   3   7839
FORD 1   7902   7566
   JONES 2   7566   7839
  KING   3   7839
MILLER   1   7934   7782
   CLARK 2   7782   7839
  KING   3   7839

39 rows selected.



Which brain cell am I missing today that will help me get what I want?  


Thanks,
Jeff Eberhard
Database Administrator
Rolls-Royce Gear Systems


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

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

RE: Populating VARCHAR2 with LONG data...

[Jared . Still]

Yes, Perl can do it also.  And without 32k limits.

Jared





Jacques Kilchoer <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/31/2003 11:14 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Populating VARCHAR2 with LONG data...


(answer below) 
> -Original Message- 
> From: Gujral, Harpal S. [mailto:[EMAIL PROTECTED] 
> 
> We have a requirement to add a VARCHAR2 column to an existing 
> table which is 
> a part of an application and also has a LONG column with data 
> in it. Without 
> using PL/SQL, how can we create the new VARCHAR2 column and 
> "default" it to 
> the LONG column data? 
> 
> The idea is all future inserts and updates made to the LONG 
> column by the 
> application, should get reflected in the VARCHAR2 column. We 
> need to use 
> this new VARCHAR2 column for reporting and use a WHERE clause 
> on the column 
> to filter data. 
a) If the length of the data in the LONG column is more than 2000 
characters (Oracle 7.3) or 4000 characters (Oracle 8.0 or higher) the data 
in the LONG column will not fit into a varchar2 column. You will need to 
use a LONG or a CLOB.
b) If the length of the data in the LONG column is less than the above 
numbers, then you can have any new values (insert/update to the LONG 
column) be replicated to the varchar2 column by using a trigger (which is 
of course written in PL/SQL).
c) To move the existing values in the LONG column to the varchar2 column 
you will need to write either PL/SQL (anonymous block or procedure) or 
else use Pro*C or your programming language or choice. (I assume PERL 
would be able to do this also.)


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

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

Re: index ??

[Wolfgang Breitling]

Title: Re: index ??





Sorry, forgot to ask the first time.  What is the selectivity of B?


At 12:53 PM 3/31/2003 -0800, you wrote:
>well , at A is not null and pt present there is only one distinct value in A.
>
>ak
>- Original Message -
>From: Wolfgang Breitling
>To: Multiple recipients of list ORACLE-L
>Sent: Monday, March 31, 2003 10:34 AM
>Subject: Re: index ??
>
>What is the selectivity of column A? How many distinct values? Is A
>nullable? How many rows and blocks in the table and what are the nr of leaf
>blocks and the clustering factors of the indexes?
>
>At 09:08 AM 3/31/2003 -0800, you wrote:
>
> >I have a table X with unix index on column A ,B and non unique index on
> >A,C,D  . The query give below doesn't use any index .
> >
> >I thought its due to  function nvl being used here , so made a change in
> >query to  replace
> >
> >B = NVL(:b2,B)  with   (B=:b2 or :b2 is null  ) , but this one also not
> >using index . Why if I put an or condition it doesn't use index while if I
> >put and condition it will used ?
> >
> >IS there any way I can change query or index so that it starts using index
> >( in a better way )
> >
> >
> >
> >Thanks,
> >
> >-ak
> >
> >
> >
> >
> >
> >
> >
> >SELECT   z
> >
> >FROM
> >
> >X
> >
> >WHERE
> >
> >A = :b1 AND
> >
> >B = NVL(:b2,B) AND
> >
> >C= nvl(:b3,C) And
> >
> >D=nvl(:b4,D)
> >
> >
> >
> >
> >
> >
>
>Wolfgang Breitling
>Centrex Consulting Corporation
>http://www.centrexcc.com
>
>  
>
>This email communication is intended as a private communication for the 
>sole use of the primary addressee and those individuals listed for copies 
>in the original message. The information contained in this email is 
>private and confidential and if you are not an intended recipient you are 
>hereby notified that copying, forwarding or other dissemination or 
>distribution of this communication by any means is prohibited.  If you are 
>not specifically authorized to receive this email and if you believe that 
>you received it in error please notify the original sender 
>immediately.  We honour similar requests relating to the privacy of email 
>communications.
>Cette communication par courrier électronique est une communication privée 
>à l'usage exclusif du destinataire principal ainsi que des personnes dont 
>les noms figurent en copie.  Les renseignements contenus dans ce courriel 
>sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes 
>avisé, par les présentes que toute reproduction, tout transfert ou toute 
>autre forme de diffusion de cette communication par quelque moyen que ce 
>soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir 
>ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser 
>l'expéditeur original immédiatement.  Nous respectons les demandes 
>similaires qui touchent la confidentialité des communications par courrier 
>électronique.


Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com



 


This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited.  If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately.  We honour similar requests relating to the privacy of email communications.

Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie.  Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.

How to use rPerf to estimate a partitioned server capabilities

[Gurelei]

Hi.

I'm trying to see whether a logical partition of a IBM
server will have enough resources to support our
databse based on the size of the DB. In the past the
way I did it was to take an rperf, multipy by 100-125M
and see whether it will exceed my estimate for a DB
size (as suggested in IBM REd book). This time around
we are going to get a logical partition of a p690
server. The question that I face now is how do I get
the value of an rperf. For example, the rperf for
8CPUs is 12.72. If we get 4CPU, do I use 6.36 for the
rperf (that is half of 12.72)?  Or should I use some
other number? Has anyone been through this process
before and has any insight?


thanks


Gene

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

RMAN question....

[Chris Stephens]

Title: RMAN question





List,


When I got into work this morning I noticed u01 was nearly full on out production OLTP machine.  I found the files and the looked to be RMAN files.

They were all in '$ORACLE_HOME/dbs/.'  My first thought was that they were the snapshot controlfiles.  but aren't those automatically deleted?  I double checked the RMAN scripts I use to make sure nothing was explicitly written there.  They weren't.  So I deleted those files.  I next ran the following on one of the databases:

RMAN> run {
2> allocate channel d1 type disk;
3> restore database validate;
4> }


that returned successfully. (whew)


then:


RMAN>  run {
2> allocate channel d1 type disk;
3> restore controlfile validate;
4> }


RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK


RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete


RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08518: channel d1: scanning controlfile copy /oracle_backup/ASTU/astu_ctl
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel d1
RMAN-10035: exception raised in RPC: ORA-00600: internal error code, arguments:]
ORA-19600: input file is datafile copy 0 ()
RMAN-10031: ORA-600 occurred during call to DBMS_BACKUP_RESTORE.SCANDATAFILECOPY


RMAN> exit



YIKES!!  


anybody have an idea why this would happen??


Here is the backup script that is used each night (it's the same for all 3 databases minus the changes is ORACLE_SID and sub-directories):

#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/


rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman <
set dbid=1337318309
connect target 
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql "alter system switch logfile";
sql "alter system archive log all";
sql  "alter database backup controlfile to trace";
sql  "alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''";
exit; 
EOF
#



any and all help will be GREATLY appreciated.  I won't be sleeping well until I know the backup process is truly ok. 


Thanks


Chris

RE: enterprise manager console and sqlplus worksheet can't work

[Mohammed Shakir]

I installed Jdeveloper 9.x on oracle 9.0.1.3 and did not have a problem
with OEM or SQL worksheet. I believe, you need to install it in a
separate directory. Also it does not give you any startup Icon or put
the Jdeveloper in Start and program menu, so you need to start from the
directory.
--- [EMAIL PROTECTED] wrote:
> If it is NT/2000 platform, Oracle installer normally screws up the
> registry entries, for example TNS_ADMIN in registry etc.
> Some product also screws up "DLL" ( specially microsoft DLL) files ,
> if
> installed in the same "oracle Home" ( overwrite good DLLs with new
> but
> incompatible DLL) . 
> 1. See, if OLD TNS_ADMIN is overridden by new TNS_ADMIN. Copy old
> stuff
> into the tnsnames.ora of new TNS_ADMIN. You will be lucky if this is
> the
> case.
> 2. Deinstall and reinstall all of the stuff in seperate home. Lots of
> work. In between install(s), you can export registry entries for
> backup
> and compare. 
> 3. Some products have to be in same oracle home and will still screw
> up.
> In that case call Oracle :). Meanwhile, you can again deinstall
> everything and try, change the order of install of the product. I am
> assuming here that you have no other work, but do these over and
> over again. 
> 
> Pradip
> 
> -Original Message-
> Sent: Thursday, March 27, 2003 12:09 AM
> To: Multiple recipients of list ORACLE-L
> afer installed the development tools
> 
> 
> 
> I downloadd the developer suites from www.oracle.com such as
> jdeveloper.
> But after I installed it .my oracle enterprise manager console and
> sqlplus worksheet cant work which I installed before.
> Why ,and how to make them work .
> Thanks in advance!
> 
> Regards
> Liujd
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: liujd
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


=
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

RE: PGA

[Goulet, Dick]

Pete,

Then send it privately: [EMAIL PROTECTED]  No I have not seen it, but I still 
believe it's more like giving a cat a bath.

Dick Goulet

-Original Message-
Sent: Monday, March 31, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L


Did you ever see the EDS commercial on herding cats?  Damn, it was funny!  I
still have it on my laptop, but I won't send it to the list (over 1 Mb is a
bit much to send).

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L


Pate,

Controlling duhvelopers is not like herding cats, it's more like
giving them a bath!!  Heavy body armor required!

Dick Goulet

-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases.  The MALLOC call never really returned the memory to the OS.  Of
course, I don't have any earlier releases to prove it now!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory
Oracle will use for a sort. After   the sort is complete, but before the
rows are returned, Oracle releases memory down to the size  specified by
the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned,
Oracle  releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides
on a Unix machine it will just trigger the swapper into action which slows
the entire machine down.  Now if you want to know if the swapper is active,
check out 'vmstat -s' and look for 'rotations of the clock hand'.  Then
check out the system's Uptime.  Divide 'rotations of the clock hand' by
uptime.  If it's greater then  or equal to 1, you've got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are
> solely those of the author and do not necessarily
> represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is s

Re: Any tips to installing Designer 9i?

[Mohammed Shakir]

Check the readme file or installation notes. It will tell you where to
install Designer to make it work.

I installed a couple of years old version, and I was asked to install
in another Oracle_home.

Hope this helps


--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> Hey all,
> 
> I'm downloading Designer 9.0.2.4.0 to try it out.  I don't want to
> #$%^@ up
> my current ORACLE_HOME, like I've done while testing every other
> Oracle
> product for Winders 2000.  Any tips?
> 
> Without reading the docs yet (still downloading), I plan to install
> it into
> another ORACLE_HOME.  Other than that and some Registry scraping so I
> can
> actually remove Designer when I'm done, anything else I should be
> aware of?
> 
> 
> TIA,
> Rich
> 
> Rich JesseSystem/Database Administrator
> [EMAIL PROTECTED]   Quad/Tech International, Sussex, WI
> USA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


=
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mohammed Shakir
  INET: [EMAIL PROTECTED]

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

RE: PGA

[Gogala, Mladen]

S_A_R_S stuff? Please, be careful with those abbreviations.

-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases.  The MALLOC call never really returned the memory to the OS.  Of
course, I don't have any earlier releases to prove it now!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory
Oracle will use for a sort. After   the sort is complete, but before the
rows are returned, Oracle releases memory down to the size  specified by
the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned,
Oracle  releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides
on a Unix machine it will just trigger the swapper into action which slows
the entire machine down.  Now if you want to know if the swapper is active,
check out 'vmstat -s' and look for 'rotations of the clock hand'.  Then
check out the system's Uptime.  Divide 'rotations of the clock hand' by
uptime.  If it's greater then  or equal to 1, you've got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailin

Re: Followup to jobs not running

[Jerome Roa]

should have bought the blue!!!

At 12:04 PM 3/28/03 -0800, you wrote:
Privileges should be granted to the user, who created the job.
Was it "system"?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:13 PM
> I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user.  I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing.  The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system.  Is there anything
else I should look for?
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ball, Terry
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jerome Roa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: index ??

[AK]

Title: Re: index ??



well , at A is not null and pt present there is 
only one distinct value in A. 
 
ak

  - Original Message - 
  From: 
  Wolfgang 
  Breitling 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 31, 2003 10:34 
  AM
  Subject: Re: index ??
  
  What is the selectivity of column A? How many distinct values? 
  Is A nullable? How many rows and blocks in the table 
  and what are the nr of leaf blocks and the clustering 
  factors of the indexes? 
  At 09:08 AM 3/31/2003 -0800, you wrote: 
  >I have a table X with unix index on column A ,B and non 
  unique index on >A,C,D  . The query give below 
  doesn't use any index . > >I thought its due to  function nvl being used here , so made a 
  change in >query to  replace > >B = NVL(:b2,B)  with   
  (B=:b2 or :b2 is null  ) , but this one also not >using index . Why if I put an or condition it doesn't use index 
  while if I >put and condition it will used ? 
  > >IS there any way I can 
  change query or index so that it starts using index >( in a better way ) > > > >Thanks, > >-ak > > > > 
  > > > >SELECT   z > >FROM > >X > 
  >WHERE > >A = :b1 AND > >B = NVL(:b2,B) AND > >C= nvl(:b3,C) And > >D=nvl(:b4,D) > > > > 
  > > 
  Wolfgang Breitling Centrex Consulting 
  Corporation http://www.centrexcc.com 
   
   
  This email communication is intended as a private 
  communication for the sole use of the primary addressee and those individuals 
  listed for copies in the original message. The information contained in this 
  email is private and confidential and if you are not an intended recipient you 
  are hereby notified that copying, forwarding or other dissemination or 
  distribution of this communication by any means is prohibited.  If you 
  are not specifically authorized to receive this email and if you believe that 
  you received it in error please notify the original sender immediately.  
  We honour similar requests relating to the privacy of email 
  communications.
  Cette communication par courrier électronique est une 
  communication privée à l'usage exclusif du destinataire principal ainsi que 
  des personnes dont les noms figurent en copie.  Les renseignements 
  contenus dans ce courriel sont confidentiels et si vous n'êtes pas le 
  destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, 
  tout transfert ou toute autre forme de diffusion de cette communication par 
  quelque moyen que ce soit est interdit.  Si vous n'êtes pas 
  spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu 
  par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous 
  respectons les demandes similaires qui touchent la confidentialité des 
  communications par courrier électronique.

RE: How to delete name service

[Jacques Kilchoer]

Title: RE: How to delete name service





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> Oracle 8.1.7.4 Win 2000
> Does anyone know how to delete a name server.  I created thru net8
> assistant however it will the service will not start.
> I want to remove it. When I highlight it the 'X' is not 
> deleted nor thru
> menu options. How can I safely remove name service.


If you run regedit (registry editor) Start->Run... regedit
then you should see the service in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
But be sure you know what you're removing and why when you change the Windows Registry!

RE: PGA

[Pete Sharman]

Did you ever see the EDS commercial on herding cats?  Damn, it was funny!  I
still have it on my laptop, but I won't send it to the list (over 1 Mb is a
bit much to send).

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L


Pate,

Controlling duhvelopers is not like herding cats, it's more like
giving them a bath!!  Heavy body armor required!

Dick Goulet

-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases.  The MALLOC call never really returned the memory to the OS.  Of
course, I don't have any earlier releases to prove it now!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory
Oracle will use for a sort. After   the sort is complete, but before the
rows are returned, Oracle releases memory down to the size  specified by
the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned,
Oracle  releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides
on a Unix machine it will just trigger the swapper into action which slows
the entire machine down.  Now if you want to know if the swapper is active,
check out 'vmstat -s' and look for 'rotations of the clock hand'.  Then
check out the system's Uptime.  Divide 'rotations of the clock hand' by
uptime.  If it's greater then  or equal to 1, you've got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are
> solely those of the author and do not necessarily
> represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FA

How to delete name service

[Rick_Cale]

Hi All,

Oracle 8.1.7.4 Win 2000
Does anyone know how to delete a name server.  I created thru net8
assistant however it will the service will not start.
I want to remove it. When I highlight it the 'X' is not deleted nor thru
menu options. How can I safely remove name service.

Thanks
Rick

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

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

RE: Rman disk and tape work

[Spears, Brian]

Thanks Dennis for taking the time to grapple with this..

The scripts that do the RMAN backups and recoveries...
can backup and restore without the Catalog being up.. (just run in nocatalog
mode)
and it automatically resyncs the catalog when it appears.

I want to be able to recover/validate "ONLY" from tape..but if I have
backups
sitting on disk Rman will use those first.

I wanted the ability to Tell RMAN to use my tape backups..(for many
reasons...
like duplicating databases, refreshing standby's , validating tape backups)

There must be a way to look at the backupset stamp and say validate it
I just havent got to that point yet...

I have been going though Robert Freeman's book Oracle9i RMAN Backup &
Recovery
for sometime now but haven't had time to go through this yet...hoping
someone
would have some ideas.

Brian


-Original Message-
Sent: Monday, March 31, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L


Brian - I'm still not clear on what you're trying to accomplish here.
Usually I feel that RMAN has better information than I do. With automated
systems like RMAN, trying to override them is usually not a good idea. I
don't think there is a direct command to do what you ask.
Some other ideas:
   Usually if the catalog database is down when you need to do a backup,
then you simply manually trigger a backup later. If this is a nagging
problem, I would consider shifting to control file backups. What if your
catalog is unavailable when you need to do a recovery? Now that is a
problem!!
   If you are concerned that the control file will have backup information
the catalog won't, the first thing I would try is RESYNC CATALOG and see if
the control file backups are populated to the catalog. Would be easy to try.
If that doesn't work, you can manually add the control file backups to the
catalog.
   Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L



I am using RMan with and without the Catalog...

 if the Catalog goes down..my backups and restores just 

switch to Nocatalog mode and keep on ticking..


My goal is to restore/recovery just a backup that resides on
tape rather than accessing the Disk copies...

 I guess that Rman at least with the Catalog knows of both...

 What would the command be to only recover using the tape media

 backups...


 I think Rman doesn't directly give you that option(RTM)... so I was
wondering
 if somebody knew a work around to Force RMAN and the Catalog to only
 recover from the Tape backups.

Brian Spears

-Original Message-
Sent: Monday, March 31, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Brian - I couldn't figure out what you are asking. First of all, are you
intending to use RMAN with a catalog? Are you wanting to distinguish the
backups for a report or on recovery. I think that RMAN will record all the
backups you have performed and will want to use the most recent backup for
recovery. If it is just a report, you could use the "TAG" parameter when you
perform backups so the disk backups and tape backups could easily be listed
differently.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L




 Anybody doing Rman Disk and MML tape backups ?

 Do you know how to force Rman just look at tape backups?
 (please no change the directory on disk answers.. just
  lookin to see if I can automate it at the command level.)


Brian

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

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

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

RE: PGA

[Goulet, Dick]

Pate,

Controlling duhvelopers is not like herding cats, it's more like giving them a 
bath!!  Heavy body armor required!

Dick Goulet

-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases.  The MALLOC call never really returned the memory to the OS.  Of
course, I don't have any earlier releases to prove it now!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory
Oracle will use for a sort. After   the sort is complete, but before the
rows are returned, Oracle releases memory down to the size  specified by
the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned,
Oracle  releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides
on a Unix machine it will just trigger the swapper into action which slows
the entire machine down.  Now if you want to know if the swapper is active,
check out 'vmstat -s' and look for 'rotations of the clock hand'.  Then
check out the system's Uptime.  Divide 'rotations of the clock hand' by
uptime.  If it's greater then  or equal to 1, you've got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the mes

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

[mail2gkatteri]

Oracle 7 to Oracle 8 involves changes to the rowid itself. Hence the 
tablespaces are part of migration.  For higher releases , the changes
take place to the system , rbs  tablespaces (if i recall correctly) and 
the user tablespaces are not touched by migration.

HTH

GovindanK

=

DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:

>Jared - I agree with you. My understanding is that an Oracle upgrade just
>changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8)
>involves changes to the tablespaces.
>
>Dennis Williams
>DBA, 40%OCP, 100% DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED] 
>
>
>-Original Message-
>Sent: Monday, March 31, 2003 1:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Thomas,
>
>I think you will find this in either in the upgrade manual or MetaLink.
>
>IIRC it depends on the number of DD objects, but I can't recall where
>it was that I read that.
>
>Jared
>
>
>
>
>
>"Thomas Day" <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
> 03/31/2003 10:34 AM
> Please respond to ORACLE-L
>
> 
>        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>        cc: 
>        Subject:        Upgrade from 8.1.7.4 to 9.2.0.1.0
>
>
>
>Is this just a data dictionary upgrade?
>
>The real question is, does the down time for this upgrade depend on the
>number of objects in the data dictionary or on the overall used tablespace
>in the database?
>
>


__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

RE: Which process is taking up so much CPU???

[M Rafiq]

Fermin,

The following query might help you 

set linesize 120
select substr(vs.username,1,10)username,
  vs.osuser,
  vs.sid,
  vs.serial#,
 vs.LOGON_TIME,
to_char(vs.logon_time, 'DD-MON-YY HH24:MI:SS') LOGON_TIME,
  substr(vs.machine,1,15)machine,
  vs.process,
  vp.spid,
  vs.last_call_et
from v$session vs, v$process vp
where vs.paddr = vp.addr
and vs.username is not null
and vs.status = 'ACTIVE'
/
Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 31 Mar 2003 07:54:03 -0800
	Dennis, you seem to be have a master in Oracle! please can you help, I can 
see the SPID column under table v$process, but how do I link it to table 
v$session so that I actually know which UNIX process it corresponds to. I 
think there must be another table that links both of them; you talk about 
the shadow process, where is it or where can I get more info on it.

	Thank you for your time.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???
Fermin
   The spid column in the v$process column matches the Unix process i.d. 
You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L


I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.
I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.
	Thank you for your answers!

Fermin.

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




_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

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

RE: PGA

[Pete Sharman]

IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases.  The MALLOC call never really returned the memory to the OS.  Of
course, I don't have any earlier releases to prove it now!  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 31, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L


>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory
Oracle will use for a sort. After   the sort is complete, but before the
rows are returned, Oracle releases memory down to the size  specified by
the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned,
Oracle  releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides
on a Unix machine it will just trigger the swapper into action which slows
the entire machine down.  Now if you want to know if the swapper is active,
check out 'vmstat -s' and look for 'rotations of the clock hand'.  Then
check out the system's Uptime.  Divide 'rotations of the clock hand' by
uptime.  If it's greater then  or equal to 1, you've got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledb

RE: Rman disk and tape work

[DENNIS WILLIAMS]

Brian - I'm still not clear on what you're trying to accomplish here.
Usually I feel that RMAN has better information than I do. With automated
systems like RMAN, trying to override them is usually not a good idea. I
don't think there is a direct command to do what you ask.
Some other ideas:
   Usually if the catalog database is down when you need to do a backup,
then you simply manually trigger a backup later. If this is a nagging
problem, I would consider shifting to control file backups. What if your
catalog is unavailable when you need to do a recovery? Now that is a
problem!!
   If you are concerned that the control file will have backup information
the catalog won't, the first thing I would try is RESYNC CATALOG and see if
the control file backups are populated to the catalog. Would be easy to try.
If that doesn't work, you can manually add the control file backups to the
catalog.
   Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L



I am using RMan with and without the Catalog...

 if the Catalog goes down..my backups and restores just 

switch to Nocatalog mode and keep on ticking..


My goal is to restore/recovery just a backup that resides on
tape rather than accessing the Disk copies...

 I guess that Rman at least with the Catalog knows of both...

 What would the command be to only recover using the tape media

 backups...


 I think Rman doesn't directly give you that option(RTM)... so I was
wondering
 if somebody knew a work around to Force RMAN and the Catalog to only
 recover from the Tape backups.

Brian Spears

-Original Message-
Sent: Monday, March 31, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Brian - I couldn't figure out what you are asking. First of all, are you
intending to use RMAN with a catalog? Are you wanting to distinguish the
backups for a report or on recovery. I think that RMAN will record all the
backups you have performed and will want to use the most recent backup for
recovery. If it is just a report, you could use the "TAG" parameter when you
perform backups so the disk backups and tape backups could easily be listed
differently.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L




 Anybody doing Rman Disk and MML tape backups ?

 Do you know how to force Rman just look at tape backups?
 (please no change the directory on disk answers.. just
  lookin to see if I can automate it at the command level.)


Brian

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

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

[DENNIS WILLIAMS]

Jared - I agree with you. My understanding is that an Oracle upgrade just
changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8)
involves changes to the tablespaces.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Thomas,

I think you will find this in either in the upgrade manual or MetaLink.

IIRC it depends on the number of DD objects, but I can't recall where
it was that I read that.

Jared





"Thomas Day" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/31/2003 10:34 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Upgrade from 8.1.7.4 to 9.2.0.1.0



Is this just a data dictionary upgrade?

The real question is, does the down time for this upgrade depend on the
number of objects in the data dictionary or on the overall used tablespace
in the database?


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

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




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

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

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

RE: Populating VARCHAR2 with LONG data...

[Jacques Kilchoer]

Title: RE: Populating VARCHAR2 with LONG data...





(answer below)


> -Original Message-
> From: Gujral, Harpal S. [mailto:[EMAIL PROTECTED]]
> 
> We have a requirement to add a VARCHAR2 column to an existing 
> table which is
> a part of an application and also has a LONG column with data 
> in it. Without
> using PL/SQL, how can we create the new VARCHAR2 column and 
> "default" it to
> the LONG column data?
> 
> The idea is all future inserts and updates made to the LONG 
> column by the
> application, should get reflected in the VARCHAR2 column. We 
> need to use
> this new VARCHAR2 column for reporting and use a WHERE clause 
> on the column
> to filter data.


a) If the length of the data in the LONG column is more than 2000 characters (Oracle 7.3) or 4000 characters (Oracle 8.0 or higher) the data in the LONG column will not fit into a varchar2 column. You will need to use a LONG or a CLOB.

b) If the length of the data in the LONG column is less than the above numbers, then you can have any new values (insert/update to the LONG column) be replicated to the varchar2 column by using a trigger (which is of course written in PL/SQL).

c) To move the existing values in the LONG column to the varchar2 column you will need to write either PL/SQL (anonymous block or procedure) or else use Pro*C or your programming language or choice. (I assume PERL would be able to do this also.)

Re: Upgrade from 8.1.7.4 to 9.2.0.1.0

[Jared . Still]

Thomas,

I think you will find this in either in the upgrade manual or MetaLink.

IIRC it depends on the number of DD objects, but I can't recall where
it was that I read that.

Jared





"Thomas Day" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/31/2003 10:34 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Upgrade from 8.1.7.4 to 9.2.0.1.0



Is this just a data dictionary upgrade?

The real question is, does the down time for this upgrade depend on the
number of objects in the data dictionary or on the overall used tablespace
in the database?


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

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




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

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

RE: help

[Jose Luis Delgado]

Dennis...

not enough from (for) the Oracle
and too much (used) from the OS perspective.

That's why you can get swapped data to disk!

JL

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Jose - Not enough allocated or too much allocated
> (from the Oracle
> perspective)?
> 
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Monday, March 31, 2003 10:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi!
> 
> You didn't send your SHARED_POOL_SIZE parameter
> value...
> but... 
> 
> usually, when the machine swaps is due to not enough
> memory allocated!
> 
> I would check your shared_pool_size, sort_area_size,
> and db_block_buffer for verifying that there's
> enough
> memory asigned.
> 
> Of course, you should diagnose memory problems on
> your
> OS and Oracle.
> 
> HTH
> JL
> 
> --- Arvind Kumar <[EMAIL PROTECTED]> wrote:
> > 
> > Hello all,
> > 
> >  i am facing swapping problem ..below is the
> > details
> > 
> > 
> >System - IBM RS 6000, two CPU,2GB RAM,AIX
> 4.3,4GB
> > SWAP SPACE
> > 
> >DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER
> > CACHE HIT RATIO IS ABOVE
> > 93%
> > 
> >   Now the problem is of swapping there are about
> 70
> > oracle users using this
> > database ,swap utilization is always above 1.5gb.
> > 
> > what could be the problem...
> > 
> > 
> >  Thanks
> > Arvind Kumar
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Arvind Kumar
> >   INET: [EMAIL PROTECTED]> (by way of Jared
> > Still <[EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web
> > hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

Re: Solaris/8.1.7/LOBSEGMENT

[Robert Pegram]

alter table table_name
modify lob (lob_column) 
 (storage (maxextents unlimited)); 


Look in dba_lobs if you are unsure of the table_name
the lobsegment belongs to.

Rob Pegram
Oracle Certified DBA

--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
wrote:
> Hi all!
> 
> I'm getting a report that a LOBSEGMENT has reached
> MAXEXTENTS.
> How do I modify this?  ALTER LOBSEGMENT doesn't
> work.  I'm still
> R'ing the FMs, but I thought I'd ask the list too.
> 
> Thanks,
> Mike
> 
> ---
>
===
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Vergara, Michael (TEM)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Pegram
  INET: [EMAIL PROTECTED]

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

Re: index ??

[Wolfgang Breitling]

Title: Re: index ??





What is the selectivity of column A? How many distinct values? Is A 
nullable? How many rows and blocks in the table and what are the nr of leaf 
blocks and the clustering factors of the indexes?



At 09:08 AM 3/31/2003 -0800, you wrote:


>I have a table X with unix index on column A ,B and non unique index on 
>A,C,D  . The query give below doesn't use any index .
>
>I thought its due to  function nvl being used here , so made a change in 
>query to  replace
>
>B = NVL(:b2,B)  with   (B=:b2 or :b2 is null  ) , but this one also not 
>using index . Why if I put an or condition it doesn't use index while if I 
>put and condition it will used ?
>
>IS there any way I can change query or index so that it starts using index 
>( in a better way )
>
>
>
>Thanks,
>
>-ak
>
>
>
>
>
>
>
>SELECT   z
>
>FROM
>
>X
>
>WHERE
>
>A = :b1 AND
>
>B = NVL(:b2,B) AND
>
>C= nvl(:b3,C) And
>
>D=nvl(:b4,D)
>
>
>
>
>
>


Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com



 


This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited.  If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately.  We honour similar requests relating to the privacy of email communications.

Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie.  Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.

RE: ORA-600 [12501] Error ??

[Jacques Kilchoer]

Title: RE: ORA-600 [12501] Error ??





Couldn't find it on Metalink. Perhaps you should open a TAR for it?
Oracle version? Server version? Is there a trace file? Can you show us the DDL for the table including its indexes?


> -Original Message-
> From: Prem Khanna J [mailto:[EMAIL PROTECTED]]
> 
> I came across this error in ALRT log file.
> 
> ORA-00600 Internal error [12501]
> 
>  It happened during this SELECT statement and it returned no rows, 
>   after i dropped an index on FROMPROFNO column.
> 
> SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE 
>   ( MEMNO = 123 AND PROFNO = 456 AND FROMMEMNO = 789 AND 
> FROMPROFNO = 910 AND SEX='MALE' AND POINT=1)
> OR
>   ( MEMNO = 124 AND PROFNO = 457 AND FROMMEMNO = 789 AND 
> FROMPROFNO = 910 AND SEX='MALE' AND POINT=1)
> 
> this statement was working fine and was returning rows b4 i 
> dropped the index.
> 
> as soon as i created an index on FROMPROFNO , it returned rows.
> 
> why is it behaving so ? 
> whether is there or not , i should be getting the rows.
> but it is not so ? 
> 
> if there is index , i get the data and if it is not there i 
> dont get data.
> 
> and what may be reason of ORA 600 [12501] error ?
> when  is this error expected ?

RE: Unable to lock file

[Nelson, Allan]

Actually, it won't.  If you have built a kernel (SAM is usually the
easiest way) then the kernel build process will boot the machine and
push the new kernel into place.  A simple shutdown will not do it.

Allan

-Original Message-
Sent: Monday, March 31, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Shutdown will automatically rebuild the kernel.
Please correct me if I'm wrong. 

-Original Message-
Sent: Friday, March 28, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


On HP you must rebuild the kernel for the change to take effect.

Allan

-Original Message-
Sent: Friday, March 28, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start
the database manually? In your cron job, is this the last database that
is started? If it is the number of locks, I would think the last
database started would consistently have the problem. Just some thoughts
for you to consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file
/u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything was OK.


Thanks.
Rivaldi








This e-mail, including any attachments, may include confidential and/or
proprietary information, and is intended for use only by the person or
entity to which it is addressed.  If the reader of this e-mail is not
the intended recipient, or his or her authorized agent, the reader is
hereby notified that any dissemination, distribution, or copying of this
e-mail is strictly prohibited.  If you have received this e-mail in
error, please notify the sender by replying to this message and delete
this e-mail immediately.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  INET: [EMAIL PROTECTED]

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

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

***

RE: Solaris/8.1.7/LOBSEGMENT

[Vergara, Michael (TEM)]

Title: RE: Solaris/8.1.7/LOBSEGMENT



Thanks!  I found a note on MetaLink, and got your message 
at
about the same time.  I figured it out, and applied the 

change.
 
Cheers,
Mike

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 
  10:25 AMTo: '[EMAIL PROTECTED]'Cc: Vergara, Michael 
  (TEM)Subject: RE: Solaris/8.1.7/LOBSEGMENT
  > -Original Message- > 
  From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] 
  > > I'm getting a report that a 
  LOBSEGMENT has reached MAXEXTENTS. > How do I 
  modify this?  ALTER LOBSEGMENT doesn't work.  I'm still 
  > R'ing the FMs, but I thought I'd ask the list 
  too. 
  alter table owner.table_name modify lob (lob_name) (storage 
  (maxextents N)) ; 

Upgrade from 8.1.7.4 to 9.2.0.1.0

[Thomas Day]

Is this just a data dictionary upgrade?

The real question is, does the down time for this upgrade depend on the
number of objects in the data dictionary or on the overall used tablespace
in the database?


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

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

RE: PGA

[Goulet, Dick]

>From the Manual:

SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will use 
for a sort. Afterthe sort is complete, but before the rows are returned, 
Oracle releases memory down to the size specified by the 
SORT_AREA_RETAINED_SIZE parameter. After the last row is returned, Oracle  
releases the remainder of the memory. 

Now since the memory is released you won't get a process error, and besides on a Unix 
machine it will just trigger the swapper into action which slows the entire machine 
down.  Now if you want to know if the swapper is active, check out 'vmstat -s' and 
look for 'rotations of the clock hand'.  Then check out the system's Uptime.  Divide 
'rotations of the clock hand' by uptime.  If it's greater then  or equal to 1, you've 
got a problem.

Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are 
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Netwo

RE: PGA

[Jared . Still]

>From MetaLink Note # 102339.1

For each session there will be a moment in time when the first sort 
has to be performed. At that moment, memory is allocated for performing 
that sort (sort area). The size of the sort area grows incrementally 
until sufficient memory has been allocated to perform the sort or until
it reaches the maximum as specified by SORT_AREA_SIZE. 


Jared





"Nelson, Allan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/31/2003 07:58 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: PGA


If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018 
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are 
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
mes

RE: Unable to lock file

[Goulet, Dick]

Shutdown will NOT rebuild the kernel, you must do that manually.  On HP use SAM as it 
does all of the work for you.  Also, take a look at the owner and group associated 
with that file.  I've seen that cause the same problems, especially the 'file already 
in use' one.  If that doesn't fix the problem, try running an fuser command (MUST be 
root) against the file to find the process id that is using the file.

Dick Goulet

-Original Message-
Sent: Monday, March 31, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Shutdown will automatically rebuild the kernel.
Please correct me if I'm wrong. 

-Original Message-
Sent: Friday, March 28, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


On HP you must rebuild the kernel for the change to take effect.

Allan

-Original Message-
Sent: Friday, March 28, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') an

RE: Week - Date function!

[Sesi Odury]

Thanks a lot!!!

-Original Message-
Sent: Saturday, March 29, 2003 1:09 AM
To: Multiple recipients of list ORACLE-L


Hello!

Sesi Odury wrote:
 > Given a week between (1 - 52) for a particular year can we get all the
 > dates within that week. Is there a function to do this in SQL???

Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can get all 7 days/dates of the week.

DEFINE yr=1998
DEFINE wk=5
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
/

Ranges can be used in case one does not have a possibility to use FBI, for
example.

The statement below is a bit more complicated. This one does a simple
check and returns nothing in case week number is out of range.

DEFINE yr=1998
DEFINE wk=53
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
  WHERE TO_NUMBER(
  TO_CHAR(
TO_DATE('3112&yr', 'DDMM')
  + DECODE(TO_CHAR(TO_DATE('3112&yr', 'DDMM'), 'IW')
  , '01', -7
,  0
)
  , 'IW'
  )
) >= &wk
AND &wk > 0
/

HTH[, if I did not make a mistake].
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.




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

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

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

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

RE: Which process is taking up so much CPU???

[DENNIS WILLIAMS]

Jared - You are right, I do type too many words. Just look how people are
misled. I can hear the faint sound of laughter in the air.

Fermin - If you've noticed my signature, I'm nowhere near the expert level.
For joining v$process and v$session, I join v$process.addr =
v$session.paddr. I can't confirm this is correct, but it has provided me the
information I've needed to resolve problems.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L



Dennis, you seem to be have a master in Oracle! please can you help,
I can see the SPID column under table v$process, but how do I link it to
table v$session so that I actually know which UNIX process it corresponds
to. I think there must be another table that links both of them; you talk
about the shadow process, where is it or where can I get more info on it.

Thank you for your time.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

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

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

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

Re: alert log file

[AK]

thanks,

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 8:53 AM


> rename it, Oracle will create a new alert log file when it needs to
> write to the alert log again
> 
> --- AK <[EMAIL PROTECTED]> wrote:
> > for  one of the db over here  alert log is biggg .Looks like its
> > never been truncated or backup .
> > Is it a problem if i just move this alert log file to another
> > directory , will oracle create a new alert log file ?
> > Do I need to bounce db ?
> > 
> > btw its 8.1.6 ( hp-ux )
> > -ak
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

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

index ??

[AK]

I have a table X with unix index on column A 
,B and non unique index on A,C,D  . The query give below doesn't use any 
index .
I thought its due to  function nvl being 
used here , so made a change in query to  replace 
B = NVL(:b2,B)  with   
(B=:b2 or :b2 is null  ) , but this one also not using index . Why if I put 
an or condition it doesn't use index while if I put and condition it will used 
?
IS there any way I can change query or index so that 
it starts using index ( in a better way )
 
Thanks,
-ak
 
 
 
SELECT   z
FROM 
X
WHERE 
A = :b1 AND
B = NVL(:b2,B) AND
C= nvl(:b3,C) And
D=nvl(:b4,D)
 
 
 

Re: help

[AK]

Arvind ,
Do you have any other  instance or application running on same box ?
-ak

- Original Message -
<[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 7:54 AM


>
> Hello all,
>
>  i am facing swapping problem ..below is the details
>
>
>System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE
>
>DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE
> 93%
>
>   Now the problem is of swapping there are about 70 oracle users using
this
> database ,swap utilization is always above 1.5gb.
>
> what could be the problem...
>
>
>  Thanks
> Arvind Kumar
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]> (by way of Jared Still
<[EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

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

RE: alert log file

[Whittle Jerome Contr NCI]

Title: RE: alert log file






We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   AK [SMTP:[EMAIL PROTECTED]


for  one of the db over here  alert log is biggg .Looks like its never been truncated or backup .

Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ?

Do I need to bounce db ?

 

btw its 8.1.6 ( hp-ux )

-ak

 

RE: alert log file

[Vergara, Michael (TEM)]

When I see a humungous file like that, I build a little 
ksh
script that hasn't failed me yet.
 
suffix=`date +%y%m%d`
cp -p alertSID.log alertSID_${suffix}.log
> alertSID.log
 
The only thing that might happen is if Oracle is updating 
the
log file at EXACTLY the moment you execute this script then 
that
log line may be lost.  As I said, it hasn't happened - yet - 
that
I know of - but YMMV.
 
Cheers,
Mike

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 7:54 
  AMTo: Multiple recipients of list ORACLE-LSubject: alert 
  log file
  for  one of the db over here  alert log 
  is biggg .Looks like its never been truncated or backup .
  Is it a problem if i just move this alert log 
  file to another directory , will oracle create a new alert log file 
  ?
  Do I need to bounce db ?
   
  btw its 8.1.6 ( hp-ux )
  -ak
   

RE: Rman disk and tape work

[Spears, Brian]

I am using RMan with and without the Catalog...

 if the Catalog goes down..my backups and restores just 

switch to Nocatalog mode and keep on ticking..


My goal is to restore/recovery just a backup that resides on
tape rather than accessing the Disk copies...

 I guess that Rman at least with the Catalog knows of both...

 What would the command be to only recover using the tape media

 backups...


 I think Rman doesn't directly give you that option(RTM)... so I was
wondering
 if somebody knew a work around to Force RMAN and the Catalog to only
 recover from the Tape backups.

Brian Spears

-Original Message-
Sent: Monday, March 31, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Brian - I couldn't figure out what you are asking. First of all, are you
intending to use RMAN with a catalog? Are you wanting to distinguish the
backups for a report or on recovery. I think that RMAN will record all the
backups you have performed and will want to use the most recent backup for
recovery. If it is just a report, you could use the "TAG" parameter when you
perform backups so the disk backups and tape backups could easily be listed
differently.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L




 Anybody doing Rman Disk and MML tape backups ?

 Do you know how to force Rman just look at tape backups?
 (please no change the directory on disk answers.. just
  lookin to see if I can automate it at the command level.)


Brian

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

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

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

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

RE: help

[DENNIS WILLIAMS]

Jose - Not enough allocated or too much allocated (from the Oracle
perspective)?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L


Hi!

You didn't send your SHARED_POOL_SIZE parameter
value...
but... 

usually, when the machine swaps is due to not enough
memory allocated!

I would check your shared_pool_size, sort_area_size,
and db_block_buffer for verifying that there's enough
memory asigned.

Of course, you should diagnose memory problems on your
OS and Oracle.

HTH
JL

--- Arvind Kumar <[EMAIL PROTECTED]> wrote:
> 
> Hello all,
> 
>  i am facing swapping problem ..below is the
> details
> 
> 
>System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB
> SWAP SPACE
> 
>DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER
> CACHE HIT RATIO IS ABOVE
> 93%
> 
>   Now the problem is of swapping there are about 70
> oracle users using this
> database ,swap utilization is always above 1.5gb.
> 
> what could be the problem...
> 
> 
>  Thanks
> Arvind Kumar
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]> (by way of Jared
> Still <[EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

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

Re: alert log file

[Ron Rogers]

Copy the alert log to the desired location and then
CAT /dev/null into the alert log.
CAT /dev/null > alert.log
 This will zero out the alert log and allow you to keep the old data.
Ron

>>> [EMAIL PROTECTED] 03/31/03 10:53AM >>>
for  one of the db over here  alert log is biggg .Looks like its
never been truncated or backup .
Is it a problem if i just move this alert log file to another directory
, will oracle create a new alert log file ?
Do I need to bounce db ?

btw its 8.1.6 ( hp-ux )
-ak
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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

Solaris/8.1.7/LOBSEGMENT

[Vergara, Michael (TEM)]

Hi all!

I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS.
How do I modify this?  ALTER LOBSEGMENT doesn't work.  I'm still
R'ing the FMs, but I thought I'd ask the list too.

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

RE: Rman disk and tape work

[DENNIS WILLIAMS]

Brian - I couldn't figure out what you are asking. First of all, are you
intending to use RMAN with a catalog? Are you wanting to distinguish the
backups for a report or on recovery. I think that RMAN will record all the
backups you have performed and will want to use the most recent backup for
recovery. If it is just a report, you could use the "TAG" parameter when you
perform backups so the disk backups and tape backups could easily be listed
differently.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L




 Anybody doing Rman Disk and MML tape backups ?

 Do you know how to force Rman just look at tape backups?
 (please no change the directory on disk answers.. just
  lookin to see if I can automate it at the command level.)


Brian

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

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

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

RE: Which process is taking up so much CPU???

[Fermin Bernaus Berraondo]

I just found that v$session.paddr = v$process.addr is the join that has to be 
done. Right?

-Mensaje original-
De: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 31 de marzo de 2003 18:01
Para: '[EMAIL PROTECTED]'
Asunto: RE: Which process is taking up so much CPU???



Dennis, you seem to be have a master in Oracle! please can you help, I can see 
the SPID column under table v$process, but how do I link it to table v$session so that 
I actually know which UNIX process it corresponds to. I think there must be another 
table that links both of them; you talk about the shadow process, where is it or where 
can I get more info on it.

Thank you for your time.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

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

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

Re: alert log file

[Scott Stefick]

If you move the alert log to another directory, Oracle will create a new
one in its place.  There is no need to bounce the DB.

-Scott


At 07:54 AM 3/31/03 -0800, you wrote:
for  one of the
db over here  alert log is biggg .Looks like its never been
truncated or backup .
Is it a problem if i just move this alert log file to another directory ,
will oracle create a new alert log file ?
Do I need to bounce db ?
 
btw its 8.1.6 ( hp-ux )
-ak
 

**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**

Re: alert log file

[Rachel Carmichael]

rename it, Oracle will create a new alert log file when it needs to
write to the alert log again

--- AK <[EMAIL PROTECTED]> wrote:
> for  one of the db over here  alert log is biggg .Looks like its
> never been truncated or backup .
> Is it a problem if i just move this alert log file to another
> directory , will oracle create a new alert log file ?
> Do I need to bounce db ?
> 
> btw its 8.1.6 ( hp-ux )
> -ak
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: alert log file

[Farnsworth, Dave]

You 
can rename the alert log or move it.  Oracle will create a new one the next 
time it has to write to it.  You don't need to bounce the 
DB.
 
Dave

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54 
  AMTo: Multiple recipients of list ORACLE-LSubject: alert 
  log file
  for  one of the db over here  alert log 
  is biggg .Looks like its never been truncated or backup .
  Is it a problem if i just move this alert log 
  file to another directory , will oracle create a new alert log file 
  ?
  Do I need to bounce db ?
   
  btw its 8.1.6 ( hp-ux )
  -ak
   

Re: Populating VARCHAR2 with LONG data...

[Jose Luis Delgado]

Hi...
If you do not want to use pl-sql for populating your
varchar2 field, then another choice is:

use the COPY command from sqlplus... for doing the
pass of data.

you must have into account that varchar2 just can hold
up to 4000 characters!

so, your long data column, should not have more than
4000 chars or you could use: set long 4000

HTH


--- "Gujral, Harpal S." <[EMAIL PROTECTED]> wrote:
> Hello Guys,
> 
> We have a requirement to add a VARCHAR2 column to an
> existing table which is
> a part of an application and also has a LONG column
> with data in it. Without
> using PL/SQL, how can we create the new VARCHAR2
> column and "default" it to
> the LONG column data?
> 
> The idea is all future inserts and updates made to
> the LONG column by the
> application, should get reflected in the VARCHAR2
> column. We need to use
> this new VARCHAR2 column for reporting and use a
> WHERE clause on the column
> to filter data.
> 
> Any help would be greatly appreciated.
> 
> Thanks
> Harpal
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Gujral, Harpal S.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

Re: Week - Date function!

[Vladimir Begun]

I have found out the reasons. Thanks for your information.
That's good.

P.S.: 27 of Nov is my birthday. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unable to lock file

[Bahar, Rivaldi (BBASSI-CHQ)]

Shutdown will automatically rebuild the kernel.
Please correct me if I'm wrong. 

-Original Message-
Sent: Friday, March 28, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


On HP you must rebuild the kernel for the change to take effect.

Allan

-Original Message-
Sent: Friday, March 28, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


Rivaldi
   That requires way more Unix knowledge than I have and we don't run HP
anyway. 
   If it was simply the number of locks, why would you be able to start the
database manually? In your cron job, is this the last database that is
started? If it is the number of locks, I would think the last database
started would consistently have the problem. Just some thoughts for you to
consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dennis,
I had set user profile prior to submit the job.
It works fine for other databases.
Is there any unix command to know the number 
of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks)
and wondering how many locks currently available.

Thanks
Rivaldi


-Original Message-
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L


Rivaldi
   Try to figure out what is different when cron starts the instance vs.
your starting the instance. Some parameter is getting set or not getting
set. For most Unix versions the "env" command dumps all environment
variables. Do that for your interactive session and then add that to the
script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job
at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 46: No locks available   

I increased the nflocks parameter from 200 to 1000 as Metablink said.
But still got the error. 
Any idea why ?
At 8 am when I get in the office, I startup the database manually and
everything
was OK.


Thanks.
Rivaldi







This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the
reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this
message and delete
this e-mail immediately.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  INET: [EMAIL PROTECTED]

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

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



This e-mail, including any attachments, may include confidential and/or
proprietary information,
and is intended for use only by the person or entity to which it is
addressed.  If the reader of this
e-mail is not the in

Re: help

[Jose Luis Delgado]

Hi!

You didn't send your SHARED_POOL_SIZE parameter
value...
but... 

usually, when the machine swaps is due to not enough
memory allocated!

I would check your shared_pool_size, sort_area_size,
and db_block_buffer for verifying that there's enough
memory asigned.

Of course, you should diagnose memory problems on your
OS and Oracle.

HTH
JL

--- Arvind Kumar <[EMAIL PROTECTED]> wrote:
> 
> Hello all,
> 
>  i am facing swapping problem ..below is the
> details
> 
> 
>System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB
> SWAP SPACE
> 
>DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER
> CACHE HIT RATIO IS ABOVE
> 93%
> 
>   Now the problem is of swapping there are about 70
> oracle users using this
> database ,swap utilization is always above 1.5gb.
> 
> what could be the problem...
> 
> 
>  Thanks
> Arvind Kumar
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]> (by way of Jared
> Still <[EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

Any tips to installing Designer 9i?

[Jesse, Rich]

Hey all,

I'm downloading Designer 9.0.2.4.0 to try it out.  I don't want to #$%^@ up
my current ORACLE_HOME, like I've done while testing every other Oracle
product for Winders 2000.  Any tips?

Without reading the docs yet (still downloading), I plan to install it into
another ORACLE_HOME.  Other than that and some Registry scraping so I can
actually remove Designer when I'm done, anything else I should be aware of?


TIA,
Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: alert log file

[Pete Sharman]

Title: Message



No problems, just move it.  No need to shutdown, Oracle will just 
create a new file next time it needs to write to it.  
 
Moving the alert log should be something you do on a regular 
basis.

Pete

"Controlling 
developers is like herding cats."
Kevin 
Loney, Oracle DBA Handbook
"Oh 
no, it's not.  It's much harder than 
that!"
Bruce 
Pihlamae, long-term Oracle DBA
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: Monday, March 
  31, 2003 7:54 AMTo: Multiple recipients of list 
  ORACLE-LSubject: alert log file
  for  one of the db over here  alert log 
  is biggg .Looks like its never been truncated or backup .
  Is it a problem if i just move this alert log 
  file to another directory , will oracle create a new alert log file 
  ?
  Do I need to bounce db ?
   
  btw its 8.1.6 ( hp-ux )
  -ak
   

Re: Populating VARCHAR2 with LONG data...

[Jared Still]

You can not do this with SQL.  You must use a 
procedural  language such as PL/SQL.

If your long columns are > 32k, PL/SQL will not
work either.  You will have to use C or Java
(not sure about Java and Longs) , or some
other supported procedural language.

Jared

On Monday 31 March 2003 07:08, Gujral, Harpal S. wrote:
> Hello Guys,
>
> We have a requirement to add a VARCHAR2 column to an existing table which
> is a part of an application and also has a LONG column with data in it.
> Without using PL/SQL, how can we create the new VARCHAR2 column and
> "default" it to the LONG column data?
>
> The idea is all future inserts and updates made to the LONG column by the
> application, should get reflected in the VARCHAR2 column. We need to use
> this new VARCHAR2 column for reporting and use a WHERE clause on the column
> to filter data.
>
> Any help would be greatly appreciated.
>
> Thanks
> Harpal
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

RE: alert log file

[MARREIROS,RUI (HP-Portugal,ex1)]

just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo 
/dev/null > alertDBSID.log) no need to bounce DB
rui
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54 
PMTo: Multiple recipients of list ORACLE-LSubject: alert 
log file
for  one of the db over here  alert log 
is biggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file 
to another directory , will oracle create a new alert log file ?
Do I need to bounce db ?
 
btw its 8.1.6 ( hp-ux )
-ak
 

RE: PGA

[Nelson, Allan]

If it is a myth where do we find the truth?

Allan

-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the
> individual to whom it is addressed. Any views or
> opinions presented are 
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately

RE: Which process is taking up so much CPU???

[Fermin Bernaus Berraondo]

Dennis, you seem to be have a master in Oracle! please can you help, I can see 
the SPID column under table v$process, but how do I link it to table v$session so that 
I actually know which UNIX process it corresponds to. I think there must be another 
table that links both of them; you talk about the shadow process, where is it or where 
can I get more info on it.

Thank you for your time.

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS
WILLIAMS
Enviado el: jueves, 27 de marzo de 2003 18:49
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


Fermin
   The spid column in the v$process column matches the Unix process i.d. You
may need to track it back through the Oracle shadow process.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, March 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



I usually track our HP-UX 11.0 system with the 'top' command so I
can notice when the system is under slow performance. If that happens, I use
Toad to look for any active Oracle SQL query which may be heavy enough for
degrading the performance.

I think my question is simple, but since I am a newbie on this...
how can I see who is executing an Oracle SQL that is taking all our CPU
provided that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.

Thank you for your answers!

Fermin.

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

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

RE: Which process is taking up so much CPU???

[Fermin Bernaus Berraondo]

It works under Oracle 8.0.6 as well, that's our platform version and I 
successfully run your queries.

Thanks!

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Jeremiah
Wilton
Enviado el: viernes, 28 de marzo de 2003 16:19
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Which process is taking up so much CPU???


On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote:

> Fermin
>Add this line to your init.ora file.
> timed_statistics = true
>Then shutdown, startup your Oracle instance.

I would hasten to point out that this parameter can be set dynamically
using alter system from at least 8.1.x forward.  Thus, restarting the
instance is unnecessary and only reduces availability.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

> -Original Message-
> Sent: Friday, March 28, 2003 6:24 AM
> To: Multiple recipients of list ORACLE-L
> 
>   I wonder where I should set TIMED STATISTICS = TRUE, if any of you
> has the time to answer I'd be grateful, but I will look for it in the docs.

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

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

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

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

alert log file

[AK]

for  one of the db over here  alert log 
is biggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file 
to another directory , will oracle create a new alert log file ?
Do I need to bounce db ?
 
btw its 8.1.6 ( hp-ux )
-ak
 

help

[Arvind Kumar]

Hello all,

 i am facing swapping problem ..below is the details


   System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE

   DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE
93%

  Now the problem is of swapping there are about 70 oracle users using this
database ,swap utilization is always above 1.5gb.

what could be the problem...


 Thanks
Arvind Kumar
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arvind Kumar
  INET: [EMAIL PROTECTED]> (by way of Jared Still <[EMAIL PROTECTED]

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

RE: PGA

[Nelson, Allan]

Hello Arvind,

This is sort of an open ended question.  In general this parameter
controls how much memory is allocated on a per session basis for in
memory sorts.  Sorts that require more memory than this will sort on the
disk with a performance penalty.  If you have the memory you should stay
well north of 90% of your sorts in memory by bumping this parameter
appropriately.  The hitch comes when you consider the fact that an
increase in this parameter uses the incremental amount that you
increased sort area size and mulitplies it by the number of connected
sessions.  You can allocate enough memory this way to force your box to
page if you are close to the line anyway.  So you have a trade off.
More memory to sort area size can reduce disk sorts and so speed up your
process.  UNIX will be happy right up to the point where you have to
page or swap things to disk and at that point your system will crawl.

Allan

-Original Message-
Sent: Monday, March 31, 2003 4:04 AM
To: Multiple recipients of list ORACLE-L


hello all,

 how does increasing the value of SORT_AREA_SIZE affect the unix
system perfomance.


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

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



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

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

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

RE: PGA

[SARKAR, Samir]

So whats the reality, Connor ?? I thought it was the reverse which was the
myth i.e. it 
is often misunderstood as the total memory available to the database user as
a whole for sort 
operations.I believe the reality is that the sort area size is the size
allocated by Oracle
per user process for sorting data.

Do enlighten me if I am wrong

Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email  :  [EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 31 March 2003 15:19
To: Multiple recipients of list ORACLE-L


Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate 
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations 
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA 
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the 
> individual to whom it is addressed. Any views or
> opinions presented are 
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

Rman disk and tape work

[Spears, Brian]

 Anybody doing Rman Disk and MML tape backups ?

 Do you know how to force Rman just look at tape backups?
 (please no change the directory on disk answers.. just
  lookin to see if I can automate it at the command level.)


Brian

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

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

Populating VARCHAR2 with LONG data...

[Gujral, Harpal S.]

Hello Guys,

We have a requirement to add a VARCHAR2 column to an existing table which is
a part of an application and also has a LONG column with data in it. Without
using PL/SQL, how can we create the new VARCHAR2 column and "default" it to
the LONG column data?

The idea is all future inserts and updates made to the LONG column by the
application, should get reflected in the VARCHAR2 column. We need to use
this new VARCHAR2 column for reporting and use a WHERE clause on the column
to filter data.

Any help would be greatly appreciated.

Thanks
Harpal
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gujral, Harpal S.
  INET: [EMAIL PROTECTED]

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

RE: sql query

[DENNIS WILLIAMS]

Reddy
   There are a variety of techniques to accomplish this, and it is difficult
to determine which will work best in your situation. Here is a link to a
classic article on this topic by the great Jonathan Gennick who participates
in this list from time to time.
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, March 31, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L


hi,

i have a table with indent number and quantity with 10 rows
ex ind_no qty
 1  10
 1  12
 1  30
 1  15
 1  30

 2  12
 2  30
 2  15
 2  30
 2  25

 2
I have to dispay it as rows
like
   1  10   12   30   15   30
   2  12   30   15   30   25

please help,

regds,
Sudhakar

___
Odomos - the only  mosquito protection outside 4 walls -
Click here to know more!
http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&w
n

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

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

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

RE: PGA

[Connor McDonald]

Oracle Myth #1745

"When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database"



 --- "SARKAR, Samir"
<[EMAIL PROTECTED]> wrote: >
Arvind,
> 
> When u set the sort_area_size for a database, it
> will allocate that much
> memory PER USER
> for any sort operation being performed on the
> database. In practice, it
> means that if u allocate 
> too high a value for the sort_area_size and multiple
> users are performing
> multiple sorts, the Unix
> system may run out of memory and Oracle will return
> u a process memory
> error.
> 
> For eg. if u have ur sort_area_size as 100MB and u
> have 10 users performing
> sort operations 
> on the database, Oracle will take up 100*10 MB
> memory. This might degrade ur
> system performance.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA 
> SchlumbergerSema
> Email  :  [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 31 March 2003 11:04
> To: Multiple recipients of list ORACLE-L
> 
> 
> hello all,
> 
>  how does increasing the value of SORT_AREA_SIZE
> affect the unix system
> perfomance.
> 
> 
> Thanks
> Arvind
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arvind Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
>
_
> This email is confidential and intended solely for
> the use of the 
> individual to whom it is addressed. Any views or
> opinions presented are 
> solely those of the author and do not necessarily
> represent those of 
> SchlumbergerSema.
> If you are not the intended recipient, be advised
> that you have received
> this email in error and that any use, dissemination,
> forwarding, printing, 
> or copying of this email is strictly prohibited.
> 
> If you have received this email in error please
> notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0)
> 121 627 5600.
>
_
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: SARKAR, Samir
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

AIX 5L - what is it?

[Vladimir Barac]

Hello to everyone
 
I see two options for 9i download at 
"technet" site - "AIX" and "AIX based 5L systems".
 
What does that difference 
mean?
 
How do I find out whether server is one 
or the other?
 
Thanks,
 
Vladimir 
Barac

ORA-600 [12501] Error ??

[Prem Khanna J]

Guys,

I came across this error in ALRT log file.

ORA-00600 Internal error [12501]

 It happened during this SELECT statement and it returned no rows, 
after i dropped an index on FROMPROFNO column.

SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE 
( MEMNO = 123 AND PROFNO = 456 AND FROMMEMNO = 789 AND FROMPROFNO = 910 AND 
SEX='MALE' AND POINT=1)
OR
( MEMNO = 124 AND PROFNO = 457 AND FROMMEMNO = 789 AND FROMPROFNO = 910 AND 
SEX='MALE' AND POINT=1)

this statement was working fine and was returning rows b4 i dropped the index.

as soon as i created an index on FROMPROFNO , it returned rows.

why is it behaving so ? 
whether is there or not , i should be getting the rows.
but it is not so ? 

if there is index , i get the data and if it is not there i dont get data.

and what may be reason of ORA 600 [12501] error ?
when  is this error expected ?

help me guys ?

TIA.
Jp.






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

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

RE: PGA

[Ganesh Raja]

Your PGA directly Affects the Amt memory the OS has to shell out for
Oracle Server Process so Increasing the Sort_Area_Size does not have
immd effect but if your users are going to do a sort then your PGA can
grow to a Maximum of Sort_Area_Size before being pulled down to the Temp
Segments.

Just make sure u size it appropriatley.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP  : +65-9067-8474 

-Original Message-
Kumar
Sent: Monday, March 31, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L


hello all,

 how does increasing the value of SORT_AREA_SIZE affect the unix
system perfomance.


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

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


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

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

RE: PGA

[SARKAR, Samir]

Arvind,

When u set the sort_area_size for a database, it will allocate that much
memory PER USER
for any sort operation being performed on the database. In practice, it
means that if u allocate 
too high a value for the sort_area_size and multiple users are performing
multiple sorts, the Unix
system may run out of memory and Oracle will return u a process memory
error.

For eg. if u have ur sort_area_size as 100MB and u have 10 users performing
sort operations 
on the database, Oracle will take up 100*10 MB memory. This might degrade ur
system performance.

Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email  :  [EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 31 March 2003 11:04
To: Multiple recipients of list ORACLE-L


hello all,

 how does increasing the value of SORT_AREA_SIZE affect the unix system
perfomance.


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

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


_
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
_

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

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

RE: snapshot too old

[Pradip_Biswas]

2. 
Fix: Increase Rll Back segments
1. 
Why: Oracle RDBMS tries to provide "Read consistent " viiew of the data ( 
changed or clean ) at the "statement level" read consitency  and "transaction 
level" read consistency 
This 
is one of the whys-  an Oracle DBA's makes his living in their 
employment as Oracle DBA.
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 12:19 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  snapshot too old
  why a select statement can give snapshot too old 
  erorr .
  there is no update , yes but its a long running 
  query .
  what is fix for this ?
   
  -ak

RE: Week - Date function!

[Ramasubramanian, Shankar (Cognizant)]

I have found out the reasons. Thanks for your information.

-Original Message-
Sent: Monday, March 31, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Hi Begun ,
I am very eager to know the reason why 27th Nov is taken  as the base for each 
year. Can you please explain me the reasons. This query is really helpful for me .

Thanks & Regards,
Shankar

-Original Message-
Sent: Saturday, March 29, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Hello!

Sesi Odury wrote:
 > Given a week between (1 - 52) for a particular year can we get all the
 > dates within that week. Is there a function to do this in SQL???

Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can get all 7 days/dates of the week.

DEFINE yr=1998
DEFINE wk=5
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
/

Ranges can be used in case one does not have a possibility to use FBI, for
example.

The statement below is a bit more complicated. This one does a simple
check and returns nothing in case week number is out of range.

DEFINE yr=1998
DEFINE wk=53
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
  WHERE TO_NUMBER(
  TO_CHAR(
TO_DATE('3112&yr', 'DDMM')
  + DECODE(TO_CHAR(TO_DATE('3112&yr', 'DDMM'), 'IW')
  , '01', -7
,  0
)
  , 'IW'
  )
) >= &wk
AND &wk > 0
/

HTH[, if I did not make a mistake].
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.




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

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


This e-mail and any files transmitted with it are for the sole use of the intended 
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message. 
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or 
copying of this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.

Visit us at http://www.cognizant.com

PGA

[Arvind Kumar]

hello all,

 how does increasing the value of SORT_AREA_SIZE affect the unix system
perfomance.


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

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

RE: copying datafile nt4-w2k

[GKor]

100% correct

 <> 
--- Begin Message ---

This only works if you don't want to rename the database.

Jared

On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote:
> i saw this document on Metalink, it is possible to copy everything even
> without creating the controlfiles!!
>
> * goal: How to copy an Oracle database to another machine
> * fact: Oracle Server - Enterprise Edition
> fix: Pre-requisites: The copy is between 2 machines, both have to be on
the
> same OS and have to have exactly the same database version installed. 1.
> Make sure the database you want to copy was closed with a SHUTDOWN
> IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and
> control files to create instance and be able to go in mount mode. Check
the
> init.ora for the locations where the controlfiles have to be, if those
> locations are not valid on the machine put the control files on different
> places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all
of
> them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the
> environment variables: ORACLE_SID - set to the database name you wish to
> create ORACLE_HOME - set to full pathname of the Oracle system home
> directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do
> 'set ORACLE_SID=' Use oradim to create the service for the instance.
> For more information on oradim please refer to (the part that refers to
> creating a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1
> Instance/Database
> 5.
Use
> servermanager (check the name to use for your version of oracle) or
sqlplus
> (version 9i and above) to startup the database in mount mode. Do CONNECT
> INTERNAL/ then STARTUP MOUNT Then do a rename of the copied
> datafiles if they are not in the same path as on the other machine. For
all
> the files that are in the result of the query: SELECT NAME FROM
V$DATAFILE;
> do ALTER DATABASE RENAME FILE '\' to <
> newfullpath>\'; 6. Query the datadictionary for the old location
> of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place
> is not the same as the old do: ALTER DATABASE RENAME FILE
> '\' to & lt;newfullpath>\';
> 7. Now open the database: ALTER DATBASE OPEN;
>
>
>  <>


Content-Type: message/rfc822; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: Re: copying datafile nt4-w2k

--- End Message ---

RE: Week - Date function!

[Ramasubramanian, Shankar (Cognizant)]

Hi Begun ,
I am very eager to know the reason why 27th Nov is taken  as the base for each 
year. Can you please explain me the reasons. This query is really helpful for me .

Thanks & Regards,
Shankar

-Original Message-
Sent: Saturday, March 29, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Hello!

Sesi Odury wrote:
 > Given a week between (1 - 52) for a particular year can we get all the
 > dates within that week. Is there a function to do this in SQL???

Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can get all 7 days/dates of the week.

DEFINE yr=1998
DEFINE wk=5
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
/

Ranges can be used in case one does not have a possibility to use FBI, for
example.

The statement below is a bit more complicated. This one does a simple
check and returns nothing in case week number is out of range.

DEFINE yr=1998
DEFINE wk=53
SELECT TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 AS date_from
  , TRUNC(TO_DATE('2711&yr', 'DDMM'), 'IYYY') + (&wk - 1) * 7 + 6 AS date_to
   FROM sys.dual
  WHERE TO_NUMBER(
  TO_CHAR(
TO_DATE('3112&yr', 'DDMM')
  + DECODE(TO_CHAR(TO_DATE('3112&yr', 'DDMM'), 'IW')
  , '01', -7
,  0
)
  , 'IW'
  )
) >= &wk
AND &wk > 0
/

HTH[, if I did not make a mistake].
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.




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

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


This e-mail and any files transmitted with it are for the sole use of the intended 
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message. 
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or 
copying of this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.

Visit us at http://www.cognizant.com

Re: copying datafile nt4-w2k

[Jared Still]

This only works if you don't want to rename the database.

Jared

On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote:
> i saw this document on Metalink, it is possible to copy everything even
> without creating the controlfiles!!
>
> * goal: How to copy an Oracle database to another machine
> * fact: Oracle Server - Enterprise Edition
> fix: Pre-requisites: The copy is between 2 machines, both have to be on the
> same OS and have to have exactly the same database version installed. 1.
> Make sure the database you want to copy was closed with a SHUTDOWN
> IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and
> control files to create instance and be able to go in mount mode. Check the
> init.ora for the locations where the controlfiles have to be, if those
> locations are not valid on the machine put the control files on different
> places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all of
> them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the
> environment variables: ORACLE_SID - set to the database name you wish to
> create ORACLE_HOME - set to full pathname of the Oracle system home
> directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do
> 'set ORACLE_SID=' Use oradim to create the service for the instance.
> For more information on oradim please refer to (the part that refers to
> creating a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1
> Instance/Database
> 5. Use
> servermanager (check the name to use for your version of oracle) or sqlplus
> (version 9i and above) to startup the database in mount mode. Do CONNECT
> INTERNAL/ then STARTUP MOUNT Then do a rename of the copied
> datafiles if they are not in the same path as on the other machine. For all
> the files that are in the result of the query: SELECT NAME FROM V$DATAFILE;
> do ALTER DATABASE RENAME FILE '\' to <
> newfullpath>\'; 6. Query the datadictionary for the old location
> of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place
> is not the same as the old do: ALTER DATABASE RENAME FILE
> '\' to & lt;newfullpath>\';
> 7. Now open the database: ALTER DATBASE OPEN;
>
>
>  <>


Content-Type: message/rfc822; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: Re: copying datafile nt4-w2k

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

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