date:20030123

R - When this came up on this list recently, the consensus seemed to be that
Guy Harrison's Oracle SQL High-Performance Tuning is best.

http://www.amazon.com/exec/obidos/tg/detail/-/0130123811/qid=1043332563/sr=8
-1/ref=sr_8_1/103-9193296-9002269?v=glances=booksn=507846


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


-Original Message-
Sent: Thursday, January 23, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I have the Oracle Performance Tuning 101 book and I have been reading the
Performance Tuning Guide on OTN, however, I found its explanation of when to
use messages and how to write queries extremely terse. Are there any
websites or books which focus strictly on query tuning that provide more in
depth explanations and examples? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Karniotis, Stephen

Yes.  I agree that works.  The problem is that there are over 2000 lines of
code similar to the one I identified.  I'm not interested in recommending
changing all of it unless it's a conversion issue.  

Thanks for the help.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, January 23, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i

Stephen,

What about this,
SQL  Create sequence a;
SQL  Create table xxx(numtest   number,   testvalue varchar2(100));
SQL  declare
  x number:=0;
  begin
 select a.nextval into x from dual;
 Insert into xxx values(x, 'TEST');
  end;

Rgrd,

Sony

 -Original Message-
 From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 4:49 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Sequences in 8.1.7 vs 9i
 
 Hello everyone. 
 
   This one stumps me and I'm wondering if it is a bug that was resolved in
 9i.  Here is sample code.
 
 Create sequence a;
 Create table xxx(numtest   number,   testvalue varchar2(100));
 
 Inside PL/SQL block and from SQL*Plus Prompt;
 
 Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST');
 
 PL/SQL: ORA-02287: sequence number not allowed here
 
 Take out the () after the sequence name and all is well.  Anyone
 experience
 something like this???
 Application (not my code) written in 8i but imported the database into 9i.
 
  
 
 Thank You
 
 Stephen P. Karniotis
 Product Architect
 Compuware Corporation
 Direct:   (248) 865-4350
 Mobile:   (248) 408-2918
 Email:[EMAIL PROTECTED]
 Web:  www.compuware.com
 
 
 
 
 The contents of this e-mail are intended for the named addressee only. It
 contains information that may be confidential. Unless you are the named
 addressee or an authorized designee, you may not copy or use it, or
 disclose
 it to anyone else. If you received it in error please notify us
 immediately
 and then destroy it. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Karniotis, Stephen
   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: Sony kristanto
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  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).

Statspack recomendations.

List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
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).

RE: Query Tuning Documentation

2003-01-23 Thread Deshpande, Kirti

encoded content removed -- binaries not allowed by ListGuru

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

winmail.dat

Re: simple question on DDL

2003-01-23 Thread Jared Still


It could also have something to do with the status changes
of objects that may be affected by the DDL, though I am
speculating here.

Jared

On Thursday 23 January 2003 02:58, you wrote:
 remember this functionality of committing before a DDL statement has
 been around from the beginning. Autonomous transactions have not. It
 may simply be a case of Oracle not getting around to adding that change
 to the kernel code.

 Or, as Kirti quoted from Tom Kyte, that might just be the way they want
 it to work.

 --- Arup Nanda [EMAIL PROTECTED] wrote:
  Dan,
 
  If I may, essentially you are saying that changes to data dictionary
  tables
  have to be committed immediately regardless of the outcome of the
  transaction.
 
  For instance in the following code, starting with an empty table t1
 
  step 1: insert into table t1 values row1
  step 2: create table t2
  step 3: insert into table t1 values row2
  step 4: rollback
 
  At this point a select * from t1 will show only row1, since the ddl
  create
  table t2 has inserted a commit. However, the point is, my transaction
  should
  have been from step 1 through step 4, not fromn step 3 through 4. The
  DDL
  broke my txn at step 2 and another transaction started from there.
  The data
  dictionary tables were updated and they should be committed; but that
  commit
  could have been done via an autonomous transaction, not in the same
 
  transaction the user issued.
 
  The more I think about it, I see no point why a DDL should insert a
  commit.
  This is different from saying that DDL itself may issue a commit to
  its
  seprate transaction to update the catalog. Any thoughts on that?
 
  Arup
 
  From: Fink, Dan [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: simple question on DDL
  Date: Wed, 22 Jan 2003 14:18:57 -0800
  MIME-Version: 1.0
  Received: from newsfeed.cts.com ([209.68.248.164]) by
  mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed,
 
  22 Jan
 
  2003 15:13:04 -0800
  Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com
  (8.9.3/8.9.3) with UUCP id PAA16552;Wed, 22 Jan 2003 15:11:42 -0800
 
  (PST)
 
  Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id
 
  00537F3B;
 
  Wed, 22 Jan 2003 14:18:57 -0800
  Message-ID: [EMAIL PROTECTED]
  X-Comment: Oracle RDBMS Community Forum
  X-Sender: Fink, Dan [EMAIL PROTECTED]
  Sender: [EMAIL PROTECTED]
  Errors-To: [EMAIL PROTECTED]
  Organization: Fat City Network Services, San Diego, California
  X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A.
 
  Bergman
 
  Precedence: bulk
  Return-Path: [EMAIL PROTECTED]
  X-OriginalArrivalTime: 22 Jan 2003 23:13:04.0174 (UTC)
  FILETIME=[D0E4CCE0:01C2C26B]
  
  Don't forget that extent allocation also affects the extent map for
 
  the
 
  segment and possibly the high water mark. The hwm can be set without
  allocating another extent and allocation of an extent may not alter
 
  the hwm
 
  (if you manually allocate an extent). If I deallocate space from an
 
  object,
 
  I will alter the  rows in fet$ and uet$ but not update the hwm. Make
 
  sense?
 
  As for the ATOMICITY of the transaction, this is usually used to
 
  describe
 
  the changes to data of interest. I don't think it is used to
 
  describe any
 
  underlying data dictionary changes. Thus the answer is Yes (for 99%
 
  of the
 
  Oracle techies) and No (for the 1% of us who really like to know
 
  exactly
 
  what is going on under the covers).
  
  Thanks for a great question, it brought up a subject that I had
 
  never
 
  thought about. Yee-Haw! I learned someting today!
  
  Cheers,
  Dan
  
  -Original Message-
  Sent: Wednesday, January 22, 2003 2:04 PM
  To: Multiple recipients of list ORACLE-L
  
  
  
  Thanks Dan. The gist of your response was that all changes to the
 
  data
 
  dictionary are immediately commited. Seems to make sense to me.
 
  Maybe,
 
  thats one reason why one cannot free space below the high water
 
  mark. Coz
 
  changes to UET$ has been committed, even though the data was rolled
 
  back.
 
  I sent an email to one of my senior DBA friends, posing the same
 
  question,
 
  and he replied with a one liner To make the transaction as ATOMIC
 
  as
 
  possible - They either run completely, or not at all.  Now, does
 
  that mean
 
  the Insert, update and delete statements are not ATOMIC? For on a
 
  rollback,
 
  changes to the data dictionary are commited, whereas the data is
 
  rolled
 
  back.
  
  Thanks
  Raj
  
  
  
  
  
  
   Fink, Dan
  
   Dan.Fink@mdxTo: Multiple
 
  recipients of
 
  list
  ORACLE-L [EMAIL PROTECTED]
   .comcc:
  
   Sent by: Subject: RE: simple
 
  question
 
  on
  DDL
   root@fatcity.
  
   com

RE: trigger problem in Oracle 8i

Title: RE: trigger problem in Oracle 8i





Change the logic ... it will be easier and the right way to handle this.


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: Shishir Kumar Mishra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: trigger problem in Oracle 8i



Hi List !
Can we disable and enable trigger from Inside a same trigger.
I am updating records of a table from statement level trigger on same table
. Iit causes recursion so, want to avoid it.


regards ..
Shishir Kumar Mishra
Agni Software (P) Ltd.
www.agnisoft.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Shishir Kumar Mishra
 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 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Slow SQL*Plus connect.

2003-01-23 Thread Mark Leith

Hi Tim, and Steve,

Thanks for the comments. I did check whether tracing was enabled, and it
wasn't..

Thanks for the thought though.

Cheers

Mark

-Original Message-
Stephen
Sent: 23 January 2003 13:49
To: Multiple recipients of list ORACLE-L


I would also verify that Oracle Trace is turned off and that within
$ORACLE_HOME/otrace/admin there are no files.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, January 22, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Slow SQL*Plus connect.

How big is the listener log file?? do you truncate/rename it on regular
basis??
just a thought.

Sunil Nookala
Dell Corp.



-Original Message-
Sent: Wednesday, January 22, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L


Hi All,

We have experienced a *very* slow connect time to a 9.0.1 database via
SQL*Plus (and other apps as well) on a Win2K machine, and I was wondering if
anybody else had experienced these slow connection times as well? We have
also been asked lately by a number of customers about slow connection times,
and to this point haven't found a solution for either ourselves or our
contacts..

It's not a network issue as connection times take just as long locally.
Connections can take up to around a minute (and the odd occasion a couple of
minutes). No MTS is in use.

OS's that I've heard about this on are Win2K, XP and NT so I'm also
wondering if it may be a Win32 issue.

Help!

Cheers :)

Mark

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Karniotis, Stephen
  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: Mark Leith
  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).

Shutting down Oracle servers

2003-01-23 Thread Nuala Cullen



Hi,

Can anyone point me to any web sites that have information on the following
two issues

1. Running oracle forms on the oracle server

Our customer wants to take away our access to the client machines and they
were wondering about running the actual forms on the server. (We are a bit
worried if the forms crashed it would pull the server down with it or just
hold onto resources)

2. Shutting down the oracle server on a regular basis (once a month) incase
of memory leaks or resource holding.

Its just that we've had a problem with one of our servers and I heard that
shutting it down on a regular basis is good - but I need proof before I
schedule such a job.

Thanks,

N.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuala Cullen
  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: simple question on DDL

2003-01-23 Thread Fink, Dan

Arup,
I see your point and agree that the DDL should be an autonomous tx.
Perhaps an enhancement request is in order? Since Oracle has the autonomous
tx code, integrating into the kernel should be considered...perhaps for
Oracle 38i?
In the absence of that change, I must disagree and say that ddl must
issue a commit. If you look at a combination of your example and mine, the
problem of waiting transactions still exists. In order to create a table,
space must be allocated. Again, if fet$ contains only 1 row for the
particular file where the table is to be created, there is a potential for a
serious locking problem. 

Dan

-Original Message-
Sent: Wednesday, January 22, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L


Dan,

If I may, essentially you are saying that changes to data dictionary tables 
have to be committed immediately regardless of the outcome of the 
transaction.

For instance in the following code, starting with an empty table t1

step 1: insert into table t1 values row1
step 2: create table t2
step 3: insert into table t1 values row2
step 4: rollback

At this point a select * from t1 will show only row1, since the ddl create 
table t2 has inserted a commit. However, the point is, my transaction should

have been from step 1 through step 4, not fromn step 3 through 4. The DDL 
broke my txn at step 2 and another transaction started from there. The data 
dictionary tables were updated and they should be committed; but that commit

could have been done via an autonomous transaction, not in the same 
transaction the user issued.

The more I think about it, I see no point why a DDL should insert a commit. 
This is different from saying that DDL itself may issue a commit to its 
seprate transaction to update the catalog. Any thoughts on that?

Arup

From: Fink, Dan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: simple question on DDL
Date: Wed, 22 Jan 2003 14:18:57 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by 
mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 22 Jan

2003 15:13:04 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id PAA16552;Wed, 22 Jan 2003 15:11:42 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00537F3B; 
Wed, 22 Jan 2003 14:18:57 -0800
Message-ID: [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Fink, Dan [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 22 Jan 2003 23:13:04.0174 (UTC) 
FILETIME=[D0E4CCE0:01C2C26B]

Don't forget that extent allocation also affects the extent map for the
segment and possibly the high water mark. The hwm can be set without
allocating another extent and allocation of an extent may not alter the hwm
(if you manually allocate an extent). If I deallocate space from an object,
I will alter the  rows in fet$ and uet$ but not update the hwm. Make sense?

As for the ATOMICITY of the transaction, this is usually used to describe
the changes to data of interest. I don't think it is used to describe any
underlying data dictionary changes. Thus the answer is Yes (for 99% of the
Oracle techies) and No (for the 1% of us who really like to know exactly
what is going on under the covers).

Thanks for a great question, it brought up a subject that I had never
thought about. Yee-Haw! I learned someting today!

Cheers,
Dan

-Original Message-
Sent: Wednesday, January 22, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L



Thanks Dan. The gist of your response was that all changes to the data
dictionary are immediately commited. Seems to make sense to me. Maybe,
thats one reason why one cannot free space below the high water mark. Coz
changes to UET$ has been committed, even though the data was rolled back.

I sent an email to one of my senior DBA friends, posing the same question,
and he replied with a one liner To make the transaction as ATOMIC as
possible - They either run completely, or not at all.  Now, does that mean
the Insert, update and delete statements are not ATOMIC? For on a rollback,
changes to the data dictionary are commited, whereas the data is rolled
back.

Thanks
Raj






 Fink, Dan

 Dan.Fink@mdxTo: Multiple recipients of 
list
ORACLE-L [EMAIL PROTECTED]
 .comcc:

 Sent by: Subject: RE: simple question 
on
DDL
 root@fatcity.

 com





 January 22,

 2003 02:16 PM

 Please

 respond to

 ORACLE-L

RE: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Fink, Dan

Stephen,
Wild-hair idea...could you create a function with the name nextval
and use it to populate from the sequence?

Dan Fink

-Original Message-
Sent: Thursday, January 23, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L


Yes.  I agree that works.  The problem is that there are over 2000 lines of
code similar to the one I identified.  I'm not interested in recommending
changing all of it unless it's a conversion issue.  

Thanks for the help.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, January 23, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i

Stephen,

What about this,
SQL  Create sequence a;
SQL  Create table xxx(numtest   number,   testvalue varchar2(100));
SQL  declare
  x number:=0;
  begin
 select a.nextval into x from dual;
 Insert into xxx values(x, 'TEST');
  end;

Rgrd,

Sony

 -Original Message-
 From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 4:49 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Sequences in 8.1.7 vs 9i
 
 Hello everyone. 
 
   This one stumps me and I'm wondering if it is a bug that was resolved in
 9i.  Here is sample code.
 
 Create sequence a;
 Create table xxx(numtest   number,   testvalue varchar2(100));
 
 Inside PL/SQL block and from SQL*Plus Prompt;
 
 Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST');
 
 PL/SQL: ORA-02287: sequence number not allowed here
 
 Take out the () after the sequence name and all is well.  Anyone
 experience
 something like this???
 Application (not my code) written in 8i but imported the database into 9i.
 
  
 
 Thank You
 
 Stephen P. Karniotis
 Product Architect
 Compuware Corporation
 Direct:   (248) 865-4350
 Mobile:   (248) 408-2918
 Email:[EMAIL PROTECTED]
 Web:  www.compuware.com
 
 
 
 
 The contents of this e-mail are intended for the named addressee only. It
 contains information that may be confidential. Unless you are the named
 addressee or an authorized designee, you may not copy or use it, or
 disclose
 it to anyone else. If you received it in error please notify us
 immediately
 and then destroy it. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Karniotis, Stephen
   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: Sony kristanto
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  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: Fink, Dan
  INET: [EMAIL PROTECTED]

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

hide password from being seen on screen

2003-01-23 Thread Robin Li


-- Hi all,

All users on the server can see the password when they issue a ps
-ef|grep rman comman after the RMAN job runs, such as rman target
[name]/[password]   Is there any way to prevent the password being
seen on screen?

TIA


Robin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robin Li
  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: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Stephen Lee


sed will fix that in a big hurry.  PERL?!  We don't need no stinkin' perl!

 -Original Message-
 
 The problem is that there are over 
 2000 lines of
 code similar to the one I identified.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  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: simple question on DDL

2003-01-23 Thread Rajesh . Rao


Well, then even Tom's vague on this one.

DDL locks are automatically placed against objects during a DDL operation
to protect them from changes by other sessions.
Well, then even an insert statement makes changes to DD objects. Ain't
locks taken then?

DDL Starts by commiting.
Why not declare a savepoint, and later, rollback to that savepoint?

And theres another DBA friend, who speculates that the reason could be that
DDL statements always take an exclusive lock on the underlying object. If
that transaction is not ended implicitly, the locks would be waiting
forever until the user intervenes. This could have serious consequences on
the database, with a potential for deadlocks. Ahem. This by far, seems to
be the most convincing answer to me.

Ok. Maybe, thats just the way its coded. The point I have understood from
this thread, is that a commit is performed to protect the data dictionary.
And DML statements are not truly atomic, for while it maybe possible for an
DML statement to roll back, there are some changes that are indeed
committed.

Thanks
Raj




   
   
Deshpande, Kirti 
   
kirti.deshpande@veTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
rizon.com cc: 
   
Sent by:   Subject: RE: simple question on DDL 
   
[EMAIL PROTECTED]   
   
   
   
   
   
January 22, 2003   
   
10:33 PM   
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Dan addressed this very well in his earlier post...

Here is what Tom Kyte says in his book (Expert one-on-one Oracle):
DDL locks are automatically placed against objects during a DDL operation
to protect them from changes by other sessions.
DDL locks are held for the duration of the DDL statement, and are released
immediately afterwards. This is done, in effect, by always wrapping DDL
statements in implicit commits (or commit/rollback pair). It is for this
reason that DDL always commits in Oracle..
So, DDL will always commit, even if it is unsuccessful. DDL starts by
committing - be aware of this. It commits first so that if it has to
rollback, it will not roll back your transaction. If you execute DDL, it'll
make permanent any outstanding work you have performed, even if the DDL is
not successful..


Refer to page 119...

- Kirti

-Original Message-
Sent: Wednesday, January 22, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L


Dan,

If I may, essentially you are saying that changes to data dictionary tables

have to be committed immediately regardless of the outcome of the
transaction.

For instance in the following code, starting with an empty table t1

step 1: insert into table t1 values row1
step 2: create table t2
step 3: insert into table t1 values row2
step 4: rollback

At this point a select * from t1 will show only row1, since the ddl create
table t2 has inserted a commit. However, the point is, my transaction
should
have been from step 1 through step 4, not fromn step 3 through 4. The DDL
broke my txn at step 2 and another transaction started from there. The data

dictionary tables were updated and they should be committed; but that
commit
could have been done via an autonomous transaction, not in the same
transaction the user issued.

The more I think about it, I see no point why a DDL should insert a commit.

This is different from saying that DDL itself may issue a commit to its
seprate transaction to update the catalog. Any thoughts on that?

Arup


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

Fat City Network Services-- 858-538-5051

RE: Statspack recomendations.

2003-01-23 Thread Farnsworth, Dave

Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK.  
Check out the link below.

http://www.dba-oracle.com/books.htm

Dave

-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Farnsworth, Dave
  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: Replication question

2003-01-23 Thread Nguyen, David M

Title: RE: Replication question





We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes.


David


-Original Message-
From: BigP [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 22, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Replication question


it depends on how you are updating slave databases .
-bp


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 3:39 PM



 We have four machines setup as slave databases which get updated data from
 one Master database every 5 minutes. The question is how do I know all
 slave machines get updated data completely from the master database,
another
 word is how do I know there is no missing data when slave machines
replicate
 from the master database?

 Thanks,
 David
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nguyen, David M
 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: BigP
 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: Statspack recommendations.

Ron - There are a series of articles available on-line.

http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html

Don Burleson has some articles on-line
http://www.dba-oracle.com/articles.htm
And Don has an entire book titled: Oracle High-Performance Tuning with
STATSPACK. 
   Let us know if that meets your requirements.

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


-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
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).
-- 
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: TOra

2003-01-23 Thread Gogala, Mladen

Nope. Tora works perfectly well with the Evolution.
They cause no problems to each other.

 -Original Message-
 From: Mark Warner [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 7:54 AM
 To: Multiple recipients of list ORACLE-L
 Subject: TOra

 Hi

 Has anyone had issues with TOra and Outlook not playing 
 together nicely? It
 seems that since I installed it, I have been getting blank 
 emails and email
 attachments have no name (or extension).

 Thanks
 Mark

 __
 The information contained in this communication is confidential and
 may be legally privileged.  It is intended solely for the use of the
 individual or entity to whom it is addressed and others authorised to
 receive it.  If you are not the intended recipient you are hereby
 notified that any disclosure, copying, distribution or taking action
 in reliance of the contents of this information is strictly prohibited
 and may be unlawful.  Absa is liable neither for the proper, complete
 transmission of the information contained in this communication, nor 
 for any delay in its receipt, nor for the assurance that it is 
 virus-free.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Mark Warner
   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: Gogala, Mladen
  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: hide password from being seen on screen

2003-01-23 Thread Spears, Brian


Here it is in Unix...

$ORACLE_HOME/bin/rman EOF_script
connect catalog ${CATALOG_OWNER}/${PASS_VALUE1}@${REPOSITORY_DB}
connect target ${TARGET_RMAN_USER}/${PASS_VALUE1}@${ORACLE_SID}
@${rman_script_path}
EOF_script
RMAN_RETURN_CODE=$?

Brian Spears 
Sr. Oracle Database Administrator 
Limited Brands Technology Services, Inc. 
Phone: (614)415-1398 
Email: [EMAIL PROTECTED] 




-Original Message-
Sent: Thursday, January 23, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L



-- Hi all,

All users on the server can see the password when they issue a ps
-ef|grep rman comman after the RMAN job runs, such as rman target
[name]/[password]   Is there any way to prevent the password being
seen on screen?

TIA


Robin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robin Li
  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: Global names

We can't use global names here either, same reason.

it is set to false, one of the first things we do when we create a new
instance.

Pat.

-Original Message-
Sent: Thursday, January 23, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L



Sorry, no, I can't find it.

Maybe someone else knows?

Jared

On Wednesday 22 January 2003 21:03, Justin Cave wrote:
 At 12:07 PM 1/22/2003, [EMAIL PROTECTED] wrote:
   It recently came to my attention that the DBA's where I work have
 
 adopted a
 
   convention where the global_name of a database is the same for the
   production, test, and development instance of that database
(obviously,
   they've turned off global naming in the init.ora).  They've also set
up
 
 the
 
 Oracle has stated for some time that global_names=true will be required
 in future versions of Oracle, and recommend that that be done now.

 Do you happen to have a link to an Oracle document to that effect?  I've
 searched tahiti and metalink, but haven't come up with anything other than
 documentation that says Oracle recommends global_names=true.

   Our DBA argues that this configuration is strongly preferred by the
 
 majority
 
   of developers since they don't have to make any changes to their code
 
 when they
 
   move from development to QA and to test.
 
 Junior developers? If the changing the database name requires code
 changes, then
 the duhvelopers need some remedial education.

 I fully agree.  Unfortunately, my project can't really tell other projects
 to educate their developers.

 Thanks!
 Justin Cave
 Distributed Database Consulting
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

RE: Shutting down Oracle servers

Nuala - It would be really helpful if you could mention what type of servers
these are. For example, we have had Alpha (Dec a.k.a. Compaq a.k.a. HP)
servers up for over a year without a problem. Also the Oracle version might
make a difference. This is Oracle 8.1.6.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, January 23, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L




Hi,

Can anyone point me to any web sites that have information on the following
two issues

1. Running oracle forms on the oracle server

Our customer wants to take away our access to the client machines and they
were wondering about running the actual forms on the server. (We are a bit
worried if the forms crashed it would pull the server down with it or just
hold onto resources)

2. Shutting down the oracle server on a regular basis (once a month) incase
of memory leaks or resource holding.

Its just that we've had a problem with one of our servers and I heard that
shutting it down on a regular basis is good - but I need proof before I
schedule such a job.

Thanks,

N.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuala Cullen
  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: Statspack recomendations.

2003-01-23 Thread Mark Leith

Oracle9i High-Performance Tuning with STATSPACK
Donald K. Burleson, Oracle Press

http://www.amazon.com/exec/obidos/ASIN/0072190582/qid=996445780/sr=1-4/ref=s
c_b_4/102-7596303-7878550

URL will be wrapped..

Also on Don's site:

http://www.dba-oracle.com/art_statspack.htm

HTH

Mark

-Original Message-
Sent: 23 January 2003 14:44
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
--
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: Statspack recomendations.

2003-01-23 Thread Gogala, Mladen

I second that motion. Also, to get you started quickly, there is
a whole load of white papers on Metalink and OTN.

 -Original Message-
 From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 10:40 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Statspack recomendations.

 Get Don Burleson's book - I think it's called Oracle 9i
 High Performance Tuning with STATSPACK.

 -Original Message-
 Sent: Thursday, January 23, 2003 6:44 AM
 To: Multiple recipients of list ORACLE-L

 List,
   I am looking for a recommendation on a book or web site covering
 statspack and it's use. A moderate level usage rather than an expert
 level literature is desired.
   Any recommendations please.
 Thanks,
 Ron
 -- 
 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).

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  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: Global names

2003-01-23 Thread Hemant K Chitale


Interesting question.  Why should it be mandatory to have distinct global 
names ?
For convenience, manageability etc, yes. But mandatory for operations ?
AFAIK, the only place where GLOBAL_NAMES is enforced is in Replication.

I've inherited a site where the DBA created a database image and duplicated
it to 7 servers [7 servers running the same database schema but used in
different areas of manufacturing].  This is then replicated across multiple
production facilities -- thus I have about 30 databases with the same 
GLOBAL_NAME,
the same SID, the same DatabaseSchemaName and Password etc etc [all, of
course, on the same platform Tru64].

Whenever I duplicate my Oracle Apps production environment to one of the
Test/Development/Conversion I sometimes forget to change the GLOBAL_NAME
for weeks.

Another issue is that all the database default to a .WORLD domain as no
DB_DOMAIN has been set !

Hemant

At 05:48 AM 23-01-03 -0800, you wrote:

Sorry, no, I can't find it.

Maybe someone else knows?

Jared

On Wednesday 22 January 2003 21:03, Justin Cave wrote:
 At 12:07 PM 1/22/2003, [EMAIL PROTECTED] wrote:
   It recently came to my attention that the DBA's where I work have
 
 adopted a
 
   convention where the global_name of a database is the same for the
   production, test, and development instance of that database (obviously,
   they've turned off global naming in the init.ora).  They've also set up
 
 the
 
 Oracle has stated for some time that global_names=true will be required
 in future versions of Oracle, and recommend that that be done now.

 Do you happen to have a link to an Oracle document to that effect?  I've
 searched tahiti and metalink, but haven't come up with anything other than
 documentation that says Oracle recommends global_names=true.

   Our DBA argues that this configuration is strongly preferred by the
 
 majority
 
   of developers since they don't have to make any changes to their code
 
 when they
 
   move from development to QA and to test.
 
 Junior developers? If the changing the database name requires code
 changes, then
 the duhvelopers need some remedial education.

 I fully agree.  Unfortunately, my project can't really tell other projects
 to educate their developers.

 Thanks!
 Justin Cave
 Distributed Database Consulting
--
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).


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 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: Statspack recomendations.

Thanks to all who replied.
 I will look for the book at the local book store this weekend.
Ron


 [EMAIL PROTECTED] 01/23/03 10:44AM 
Don Burleson has a book called Oracle9i High-Performance Tuning with
STATSPACK.  Check out the link below.

http://www.dba-oracle.com/books.htm 

Dave

-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Farnsworth, Dave
  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: 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).

over-normalized?

2003-01-23 Thread Saira Somani

Is there such thing as an over-normalized database design?
What defines over-normalization? And what are its consequences? (Other
than the obvious degraded database performance and lots of tuning)

I hear rumblings that our ERP system is over-normalized.

Just curious,

Thanks!

Saira Somani
IT Support/Analyst
Hospital Logistics Inc. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  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: simple question on DDL

2003-01-23 Thread Hemant K Chitale


I tend to agree with the argument that's the way they wrote it.
If I remember correctly, DDL always commits the current transaction
in the session, even back in Oracle5 [and earlier ?] days.  Most likely
they couldn't write autonomous transactions then.
That autonomous transactions have been available to us since 8i
doesn't mean that autonomous transactions may not have been possible
within the kernel earlier.  I always think that the SCN mechanism is
like a sequence and has been around since before Oracle6 but
sequences were available to us only in Oracle6.

Hemant

At 06:54 AM 23-01-03 -0800, you wrote:


Well, then even Tom's vague on this one.

DDL locks are automatically placed against objects during a DDL operation
to protect them from changes by other sessions.
Well, then even an insert statement makes changes to DD objects. Ain't
locks taken then?

DDL Starts by commiting.
Why not declare a savepoint, and later, rollback to that savepoint?

And theres another DBA friend, who speculates that the reason could be that
DDL statements always take an exclusive lock on the underlying object. If
that transaction is not ended implicitly, the locks would be waiting
forever until the user intervenes. This could have serious consequences on
the database, with a potential for deadlocks. Ahem. This by far, seems to
be the most convincing answer to me.

Ok. Maybe, thats just the way its coded. The point I have understood from
this thread, is that a commit is performed to protect the data dictionary.
And DML statements are not truly atomic, for while it maybe possible for an
DML statement to roll back, there are some changes that are indeed
committed.

Thanks
Raj






Deshpande, 
Kirti 

kirti.deshpande@veTo: Multiple 
recipients of list ORACLE-L [EMAIL PROTECTED]
rizon.com cc: 

Sent by:   Subject: RE: simple 
question on DDL
[EMAIL PROTECTED] 





January 22, 
2003 

10:33 
PM 

Please respond 
to 

ORACLE-L 









Dan addressed this very well in his earlier post...

Here is what Tom Kyte says in his book (Expert one-on-one Oracle):
DDL locks are automatically placed against objects during a DDL operation
to protect them from changes by other sessions.
DDL locks are held for the duration of the DDL statement, and are released
immediately afterwards. This is done, in effect, by always wrapping DDL
statements in implicit commits (or commit/rollback pair). It is for this
reason that DDL always commits in Oracle..
So, DDL will always commit, even if it is unsuccessful. DDL starts by
committing - be aware of this. It commits first so that if it has to
rollback, it will not roll back your transaction. If you execute DDL, it'll
make permanent any outstanding work you have performed, even if the DDL is
not successful..


Refer to page 119...

- Kirti

-Original Message-
Sent: Wednesday, January 22, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L


Dan,

If I may, essentially you are saying that changes to data dictionary tables

have to be committed immediately regardless of the outcome of the
transaction.

For instance in the following code, starting with an empty table t1

step 1: insert into table t1 values row1
step 2: create table t2
step 3: insert into table t1 values row2
step 4: rollback

At this point a select * from t1 will show only row1, since the ddl create
table t2 has inserted a commit. However, the point is, my transaction
should
have been from step 1 through step 4, not fromn step 3 through 4. The DDL
broke my txn at step 2 and another transaction started from there. The data

dictionary tables were updated and they should be committed; but that
commit
could have been done via an autonomous transaction, not in the same
transaction the user issued.

The more I think about it, I see no point why a DDL should insert a commit.

This is different from saying that DDL itself may issue a commit to its
seprate transaction to update the catalog. Any thoughts on that?

Arup


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

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K

RE: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Karniotis, Stephen

Daniel:

  You are a sick person.  Not going to change the code that much.  I need to
evaluate the pain for the development team.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, January 23, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i

Stephen,
Wild-hair idea...could you create a function with the name nextval
and use it to populate from the sequence?

Dan Fink

-Original Message-
Sent: Thursday, January 23, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L


Yes.  I agree that works.  The problem is that there are over 2000 lines of
code similar to the one I identified.  I'm not interested in recommending
changing all of it unless it's a conversion issue.  

Thanks for the help.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, January 23, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i

Stephen,

What about this,
SQL  Create sequence a;
SQL  Create table xxx(numtest   number,   testvalue varchar2(100));
SQL  declare
  x number:=0;
  begin
 select a.nextval into x from dual;
 Insert into xxx values(x, 'TEST');
  end;

Rgrd,

Sony

 -Original Message-
 From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 4:49 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Sequences in 8.1.7 vs 9i
 
 Hello everyone. 
 
   This one stumps me and I'm wondering if it is a bug that was resolved in
 9i.  Here is sample code.
 
 Create sequence a;
 Create table xxx(numtest   number,   testvalue varchar2(100));
 
 Inside PL/SQL block and from SQL*Plus Prompt;
 
 Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST');
 
 PL/SQL: ORA-02287: sequence number not allowed here
 
 Take out the () after the sequence name and all is well.  Anyone
 experience
 something like this???
 Application (not my code) written in 8i but imported the database into 9i.
 
  
 
 Thank You
 
 Stephen P. Karniotis
 Product Architect
 Compuware Corporation
 Direct:   (248) 865-4350
 Mobile:   (248) 408-2918
 Email:[EMAIL PROTECTED]
 Web:  www.compuware.com
 
 
 
 
 The contents of this e-mail are intended for the named addressee only. It
 contains information that may be confidential. Unless you are the named
 addressee or an authorized designee, you may not copy or use it, or
 disclose
 it to anyone else. If you received it in error please notify us
 immediately
 and then destroy it. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Karniotis, Stephen
   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: Sony kristanto
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  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

RE: Slow SQL*Plus connect.

2003-01-23 Thread Cary Millsap

I had a similar problem once that was solved by editing my SQLNET.ORA
file. I set:

SQLNET.AUTHENTICATION_SERVICES= (None)

...instead of:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

I'm not sure what functionality this change eliminated, but my
connection times are sure a lot faster now.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


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

Hi Tim, and Steve,

Thanks for the comments. I did check whether tracing was enabled, and it
wasn't..

Thanks for the thought though.

Cheers

Mark

-Original Message-
Stephen
Sent: 23 January 2003 13:49
To: Multiple recipients of list ORACLE-L


I would also verify that Oracle Trace is turned off and that within
$ORACLE_HOME/otrace/admin there are no files.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, January 22, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Slow SQL*Plus connect.

How big is the listener log file?? do you truncate/rename it on regular
basis??
just a thought.

Sunil Nookala
Dell Corp.



-Original Message-
Sent: Wednesday, January 22, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L


Hi All,

We have experienced a *very* slow connect time to a 9.0.1 database via
SQL*Plus (and other apps as well) on a Win2K machine, and I was
wondering if
anybody else had experienced these slow connection times as well? We
have
also been asked lately by a number of customers about slow connection
times,
and to this point haven't found a solution for either ourselves or our
contacts..

It's not a network issue as connection times take just as long
locally.
Connections can take up to around a minute (and the odd occasion a
couple of
minutes). No MTS is in use.

OS's that I've heard about this on are Win2K, XP and NT so I'm also
wondering if it may be a Win32 issue.

Help!

Cheers :)

Mark

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
  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).



The contents of this e-mail are intended for the named addressee only.
It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us
immediately
and then destroy it.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Karniotis, Stephen
  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: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services

RE: simple question on DDL

2003-01-23 Thread Jeremy Pulcifer

Title: RE: simple question on DDL

 From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, January 23, 2003 8:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: simple question on DDL

 Actually, DB2 (pardon my French) doesn't issue a commit 
 after a DDL. I'm not aware of any standards specifying 
 the presence or absence of a commit after a DDL. I know
 that, for instance, EXPLAIN PLAN can be rolled back.

Huh?

Explain plan is DDL?

Re: Re: How to parallel index scan.

2003-01-23 Thread chao_ping

Hi,
  After your words, I did a single thread of index creation and i was so surprised to 
find that the time spent on index creation is less: 
SQL  CREATE INDEX IDX_PRO ON PRODUCTS(SELLER_ID)  NOLOGGING ;

Index created.

Elapsed: 00:01:12.65
God! 
But I still think there is something we can tune.I noticed that when one thread 
creating index, cpu usage is high, while multiple thread index create, cpu usage is 
low. They are waiting for the wait event like those i listed in the statspack report.
Thanks for your experience.:)

 I do a lot of this and have found that there isn't much you can do. I don't
 use degree anymore as I've found it hasn't been worth the effort of trying
 to figure it all out. ie. timings didn't change much. I have read where you
 might want a smaller sort_area_size. This way some slaves will be reading,
 others sorting etc. I don't do this myself, my sort_area_size is 5Mb and I
 do notice them all bunch up. I don't think adjusting the sort_area_size will
 have that much of a difference anyways.
 
 Mike
 [EMAIL PROTECTED]
 - Original Message -
 From: chao_ping [EMAIL PROTECTED]
 To: LazyDBA.com Discussion [EMAIL PROTECTED]
 Sent: Thursday, January 23, 2003 11:01 AM
 Subject: How to parallel index scan.
 
 
  Hi, friends:
Soon there will be a database reorgnization in my system and downtime is
 limited, so i am doing some test in parallel operation.
My test system has 8CPU/8G memory/8disk Raid5(raid pretty old).And I
 tested create index in parallel.
First I enlarge sort_area_size to 30MB. and do create index parallel
 degree 2-12(all tested), with nologging option. But it does not help when i
 enlarge the parallel clause:
   2 parallel thread: 1minute and 44 second.
   12 parallel thread: 1 minute and 30 second.
  I did a statspack between the time I create the index, and find the top
 wait event like:
 
  Top 5 Wait Events
  ~ Wait %
 Total
  Event   Waits  Time (cs)   Wt
 Time
     ---
 
  direct path read   64,594  179,134
 41.04
  PX Deq: Table Q Normal 88,100  174,969
 40.09
  PX Deq: Execute Reply 666   61,336
 14.05
  PX Deq: Execution Msg 731   16,122
 3.69
  control file parallel write   2492,139
 .49
 
  Disk is already 100% busy and system load profile:
  23:04:05  15   1   8  75
  23:04:15  16   1   2  80
  23:04:25  18   1   3  78
  23:04:35  16   1   3  80
  23:04:45  17   1   2  80
  23:04:55  18   1   1  80
  23:05:05  17   1   1  80
  23:05:15  16   1   2  81
  23:05:25  17   1   1  81
  23:05:35  16   1   2  81
  23:05:45  32   3   0  65
  23:05:55  15   2  13  69
  23:06:05  17   2   5  77
  23:06:15  17   2   7  74
  23:06:25  15   1   4  79
  23:06:35  15   1   3  81
  23:06:45  17   2   3  78
  23:06:55  17   1   2  80
  23:07:05  17   2   2  79
  23:07:15  15   1   5  79
  23:07:25  21   2   2  75
  23:07:35  29   1  11  59
  23:07:45  17   2   6  76
  23:07:55  17   1   6  75
  23:08:05  17   1   5  76
  23:08:15  17   1   3  79
  23:08:25  15   1   2  81
  23:08:35  15   1   2  82
Can someone share your experience of tuning parallel operation like
 parallel index create and parallel ctas? Is the disk the really bottlenect
 and is there still space for tuning?
Thanks.
 
  zhu chao.
  www.cnoug.org.
 
 
  
  Oracle documentation is here:
 http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
  To unsubscribe: send a blank email to [EMAIL PROTECTED]
  To subscribe:   send a blank email to [EMAIL PROTECTED]
  Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
  Tell yer mates about http://www.farAwayJobs.com
  By using this list you agree to these
 terms:http://www.lazydba.com/legal.html
 
 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  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

RE: Statspack recomendations.

2003-01-23 Thread Vergara, Michael (TEM)

Get Don Burleson's book - I think it's called Oracle 9i
High Performance Tuning with STATSPACK.


-Original Message-
Sent: Thursday, January 23, 2003 6:44 AM
To: Multiple recipients of list ORACLE-L


List,
  I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
  Any recommendations please.
Thanks,
Ron
-- 
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).

-- 
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: over-normalized?

2003-01-23 Thread Rajesh . Rao


How many join table operations do you perform, in most of the queries? As
more tables are added to the join, you take a performance hit? Plus, all
the space for the indexes on the additional tables? An update could end up
having to write to multiple tables. So, I guess, you have to walk the tight
rope between these issues, and having a perfectly normalized database.

To quote George Koch No major application will run in third normal form.

Raj




   
  
Saira Somani 
  
saira_somani@To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
yahoo.comcc:  
  
Sent by:  Subject: over-normalized?
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
January 23,
  
2003 11:00 AM  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Is there such thing as an over-normalized database design?
What defines over-normalization? And what are its consequences? (Other
than the obvious degraded database performance and lots of tuning)

I hear rumblings that our ERP system is over-normalized.

Just curious,

Thanks!

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.


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

hi people need some help here again

2003-01-23 Thread Paulo Gomes

i'm trying to configure a new system (aix 4.3.3 or any other unix or even
any linux) to work as a development server with 9i r2 and 9ias r2.
One of the things i allready know is that i have to create a aix user to be
owner of each one of those tools (i've been working with the previous
versions and everithing is fine).
My question is :

IS THERE ANY ONE THAT HAVE THE CONFIGURATION I'M PLANNING TO HAVE (IN UNIX)
THAT CAN HELP ME (BY SENDING ME THE .PROFILE OR THE .LOGIN OF THE OWNER OF
9IR2 AND 9IASR2)?

i WOULD MUCH APPRECIATE FOR ANY HELP HERE.
THANKS
PAULO

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paulo Gomes
  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).

senior oracle dba

It just occurred to me that maybe senior DBAs should get discount cards for
shopping, etc.

: )

Pat.

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

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

Sizing the RMAN Catalog

2003-01-23 Thread Patterson, Mark

Hi,

I'm going to be implementing RMAN sometime soon and am putting together the
RMAN catalog server spec. Have had a look around for formulae to size the
RMAN catalog tablespace(s) but have had no luck.

Best information I can find is to size the catalog tablespace(s) at between
10 MB to 20 MB per target database per year. 

Is this estimate accurate and does it still apply to an Oracle 9.2 RMAN
catalog?

Any help or pointers greatly appreciated.

Thanks,
Mark.

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Patterson, Mark
  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: simple question on DDL

2003-01-23 Thread Gogala, Mladen

Actually, DB2 (pardon my French) doesn't issue a commit 
after a DDL. I'm not aware of any standards specifying 
the presence or absence of a commit after a DDL. I know
that, for instance, EXPLAIN PLAN can be rolled back.

 -Original Message-
 From: Fink, Dan [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 10:05 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: simple question on DDL

 Arup,
   I see your point and agree that the DDL should be an 
 autonomous tx.
 Perhaps an enhancement request is in order? Since Oracle has 
 the autonomous
 tx code, integrating into the kernel should be 
 considered...perhaps for
 Oracle 38i?
   In the absence of that change, I must disagree and say 
 that ddl must
 issue a commit. If you look at a combination of your example 
 and mine, the
 problem of waiting transactions still exists. In order to 
 create a table,
 space must be allocated. Again, if fet$ contains only 1 row for the
 particular file where the table is to be created, there is a 
 potential for a
 serious locking problem. 

 Dan

 -Original Message-
 Sent: Wednesday, January 22, 2003 7:14 PM
 To: Multiple recipients of list ORACLE-L

 Dan,

 If I may, essentially you are saying that changes to data 
 dictionary tables 
 have to be committed immediately regardless of the outcome of the 
 transaction.

 For instance in the following code, starting with an empty table t1

 step 1: insert into table t1 values row1
 step 2: create table t2
 step 3: insert into table t1 values row2
 step 4: rollback

 At this point a select * from t1 will show only row1, since 
 the ddl create 
 table t2 has inserted a commit. However, the point is, my 
 transaction should

 have been from step 1 through step 4, not fromn step 3 
 through 4. The DDL 
 broke my txn at step 2 and another transaction started from 
 there. The data 
 dictionary tables were updated and they should be committed; 
 but that commit

 could have been done via an autonomous transaction, not in the same 
 transaction the user issued.

 The more I think about it, I see no point why a DDL should 
 insert a commit. 
 This is different from saying that DDL itself may issue a 
 commit to its 
 seprate transaction to update the catalog. Any thoughts on that?

 Arup

 From: Fink, Dan [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: simple question on DDL
 Date: Wed, 22 Jan 2003 14:18:57 -0800
 MIME-Version: 1.0
 Received: from newsfeed.cts.com ([209.68.248.164]) by 
 mc1-f3.law16.hotmail.com with Microsoft 
 SMTPSVC(5.0.2195.5600); Wed, 22 Jan

 2003 15:13:04 -0800
 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
 (8.9.3/8.9.3) with UUCP id PAA16552;Wed, 22 Jan 2003 
 15:11:42 -0800 (PST)
 Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via 
 UUCP id 00537F3B; 
 Wed, 22 Jan 2003 14:18:57 -0800
 Message-ID: [EMAIL PROTECTED]
 X-Comment: Oracle RDBMS Community Forum
 X-Sender: Fink, Dan [EMAIL PROTECTED]
 Sender: [EMAIL PROTECTED]
 Errors-To: [EMAIL PROTECTED]
 Organization: Fat City Network Services, San Diego, California
 X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce 
 A. Bergman
 Precedence: bulk
 Return-Path: [EMAIL PROTECTED]
 X-OriginalArrivalTime: 22 Jan 2003 23:13:04.0174 (UTC) 
 FILETIME=[D0E4CCE0:01C2C26B]

 Don't forget that extent allocation also affects the extent 
 map for the
 segment and possibly the high water mark. The hwm can be set without
 allocating another extent and allocation of an extent may 
 not alter the hwm
 (if you manually allocate an extent). If I deallocate space 
 from an object,
 I will alter the  rows in fet$ and uet$ but not update the 
 hwm. Make sense?

 As for the ATOMICITY of the transaction, this is usually 
 used to describe
 the changes to data of interest. I don't think it is used to 
 describe any
 underlying data dictionary changes. Thus the answer is Yes 
 (for 99% of the
 Oracle techies) and No (for the 1% of us who really like to 
 know exactly
 what is going on under the covers).

 Thanks for a great question, it brought up a subject that I had never
 thought about. Yee-Haw! I learned someting today!

 Cheers,
 Dan

 -Original Message-
 Sent: Wednesday, January 22, 2003 2:04 PM
 To: Multiple recipients of list ORACLE-L

 Thanks Dan. The gist of your response was that all changes 
 to the data
 dictionary are immediately commited. Seems to make sense to 
 me. Maybe,
 thats one reason why one cannot free space below the high 
 water mark. Coz
 changes to UET$ has been committed, even though the data was 
 rolled back.

 I sent an email to one of my senior DBA friends, posing the 
 same question,
 and he replied with a one liner To make the transaction as ATOMIC as
 possible - They either run completely, or not at all.  Now, 
 does that mean
 the Insert, update and delete statements are not ATOMIC? For 
 on a rollback,
 changes

RE: simple question on DDL

Title: RE: simple question on DDL



Set autotrace on ... and then do explain plan for 


You'll see.

Raj
__
Rajendra 
Jamadagni 
 MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot 
com
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: Jeremy Pulcifer 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 23, 2003 
  12:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: simple question on DDL
   From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]  Sent: Thursday, January 23, 2003 8:45 AM  To: Multiple recipients of list ORACLE-L  Subject: RE: simple question on DDL  
Actually, DB2 
  (pardon my French) doesn't issue a commit  after a 
  DDL. I'm not aware of any standards specifying  
  the presence or absence of a "commit" after a DDL. I know  that, for instance, "EXPLAIN PLAN" can be rolled back. 
   
  Huh? 
  Explain plan is DDL? 
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Program name in v$ views

Does anyone know why sometimes a program name appears in the v$ views for
user sessions, and sometimes nothing?

I noticed that sqlplus appears as sqlplus.exe, and other problems as their
executable file name, but for TOAD nothing appears.

Is there a way to force Oracle to collect this information?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


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

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

RE: Program name in v$ views

Title: RE: Program name in v$ views





TOAD sets the module name as T.O.A.D


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Program name in v$ views



Does anyone know why sometimes a program name appears in the v$ views for
user sessions, and sometimes nothing?


I noticed that sqlplus appears as sqlplus.exe, and other problems as their
executable file name, but for TOAD nothing appears.


Is there a way to force Oracle to collect this information?


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]



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


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



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

Re: hide password from being seen on screen

2003-01-23 Thread Robin Li

Thanks a lot.

Spears, Brian wrote:
 
 Here it is in Unix...
 
 $ORACLE_HOME/bin/rman EOF_script
 connect catalog ${CATALOG_OWNER}/${PASS_VALUE1}@${REPOSITORY_DB}
 connect target ${TARGET_RMAN_USER}/${PASS_VALUE1}@${ORACLE_SID}
 @${rman_script_path}
 EOF_script
 RMAN_RETURN_CODE=$?
 
 Brian Spears
 Sr. Oracle Database Administrator
 Limited Brands Technology Services, Inc.
 Phone: (614)415-1398
 Email: [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Thursday, January 23, 2003 10:34 AM
 To: Multiple recipients of list ORACLE-L
 
 -- Hi all,
 
 All users on the server can see the password when they issue a ps
 -ef|grep rman comman after the RMAN job runs, such as rman target
 [name]/[password]   Is there any way to prevent the password being
 seen on screen?
 
 TIA
 
 Robin
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Robin Li
   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).

-- 
Robin


* Robin Li *
* Technical Specialist, DBA   Phone#: (212) 297-3073   *
* Information ServicesFax#:   (212) 297-4231   *
* 333 East 38th Street, 2nd fl.   E-mail: [EMAIL PROTECTED]  *
* New York, NY 10016   *

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robin Li
  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: senior oracle dba

Title: RE: senior oracle dba





would you like reserved parking with that??


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: senior oracle dba



It just occurred to me that maybe senior DBAs should get discount cards for
shopping, etc.


: )


Pat.


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


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



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

Re: simple question on DDL

2003-01-23 Thread Jonathan Lewis


One question to ask is whether whether all DDL
use the same strategy. Similarly, if you have
multiple code paths for do a ddl call how much
more risk of error do you introduce to the kernel.
Finally how do you get a consistent error response
to the end user if the error condition of apparently
identical events can fail in extremely different ways.

Consider the complexities of finding a consistent
kernel level approach to:

insert into t1 values (1);
drop table t1;
-- how to deal with self-deadlock ?
insert into t1 values (2);
commit;

insert into t1 values (1);
drop table t2;
-- how to deal with lock by other user ?
insert into t1 values (2);
commit;



Regards

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

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

England__January 21/23
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 23 January 2003 16:31


Arup,
 I see your point and agree that the DDL should be an autonomous tx.
Perhaps an enhancement request is in order? Since Oracle has the
autonomous
tx code, integrating into the kernel should be considered...perhaps
for
Oracle 38i?
 In the absence of that change, I must disagree and say that ddl must
issue a commit. If you look at a combination of your example and
mine, the
problem of waiting transactions still exists. In order to create a
table,
space must be allocated. Again, if fet$ contains only 1 row for the
particular file where the table is to be created, there is a
potential for a
serious locking problem.

Dan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: over-normalized?

2003-01-23 Thread Jeremy Pulcifer

Title: RE: over-normalized?





 From: Saira Somani [mailto:[EMAIL PROTECTED]] 
 
 
 Is there such thing as an over-normalized database design?


Sure. But usually that would be in the case of doing olap-type reporting in a transactional app. 


 What defines over-normalization? And what are its 
 consequences? (Other than the obvious degraded database 
 performance and lots of tuning)


What kind of problems are folks talking about? 99 times out of ten ;-) it's developers who consider joins weird.


 I hear rumblings that our ERP system is over-normalized.


Could be; I'm working on a planning app that is just about as normalized as I've ever seen in a database I didn't create ;-). The problem is, of course, that there are a lot of olap-type queries that are needed, and hence we have some of the squirreliest-looking code in our report engine. The OO guys don't care that much about it, as they have a pretty efficient relational-to-Object engine that does all the roll-up stuff for them.

So, what are the kinds of problems you are running into?

Re: senior oracle dba

Pat, 
  We do, AARP, O'l HIP, AAA, and some times AA.
Ron

 [EMAIL PROTECTED] 01/23/03 12:09PM 
It just occurred to me that maybe senior DBAs should get discount cards
for
shopping, etc.

: )

Pat.

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.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).

RE: Statspack recomendations.

List, 
  There have been a lot of good suggestions and recommendations from
all of you. I thank you very much. The information sources list
information about a Unx / NT os and I need to read up on what happens
when the creation scripts fail on OpenVMS. Hopefully the sources will
supply some insight.
Thanks again,
Ron

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

Re: over-normalized?

2003-01-23 Thread Jared . Still

 An update could end up
 having to write to multiple tables. So, I guess, you have to walk the 
tight
 rope between these issues, and having a perfectly normalized database.

You might want to rethink that statement.  The goal of a 
relational database is to have no redundant data.

If you have to update multiple tables in a transaction, so what?

That is certainly preferable to being required to ferret out all
the tables that store the same information, and must therefore be
updated together, as in a denormalized database.

Jared







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/23/2003 09:15 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: over-normalized?



How many join table operations do you perform, in most of the queries? As
more tables are added to the join, you take a performance hit? Plus, all
the space for the indexes on the additional tables? An update could end up
having to write to multiple tables. So, I guess, you have to walk the 
tight
rope between these issues, and having a perfectly normalized database.

To quote George Koch No major application will run in third normal form.

Raj




  
Saira Somani   
saira_somani@To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
yahoo.comcc:   
Sent by:  Subject: over-normalized?
 
[EMAIL PROTECTED]   
om  
  
  
January 23,  
2003 11:00 AM   
Please respond   
to ORACLE-L  
  
  




Is there such thing as an over-normalized database design?
What defines over-normalization? And what are its consequences? (Other
than the obvious degraded database performance and lots of tuning)

I hear rumblings that our ERP system is over-normalized.

Just curious,

Thanks!

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.


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

Slow database, too MANY buffers???

2003-01-23 Thread Michael Kline




I've got a cust 
that is showing some signs that one would
think is having a 
horrible problem onI/O...

I suspect it is the 
"error" of having a **HUGE** value
in db_block_buffers 
and it's constantly crunching memory
trying to figure 
out which ones to free up. It's only
256 meg, but 
depending on load, it may be too much. SGA
is 687 
meg.

While I've got 
hundreds of SQL, I'm not sure I have one
to diagnose buffer 
utilization. It's also version 8.1.7
and I could 
probably do some tweaking of buffers.

It's Oracle CRM 
with a lot of customization and I'm also
finding some SQL 
that's getting a bit ugly under there.

Maks.

RE: senior oracle dba

2003-01-23 Thread Spears, Brian

Title: RE: senior oracle dba

Actually we need a cot, 2 females... one popping grapes into mouth
and the
other
waving palm leaf for cool air...

HOLD
the flames...Im kidding..

-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 23,
2003 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: senior oracle dba
would you like reserved parking with that??
Raj __ Rajendra Jamadagni
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any
opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion
is an art!
-Original Message- From:
Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: senior oracle dba
It just occurred to me that maybe senior DBAs should get
discount cards for shopping, etc.
: )
Pat.
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

Re: senior oracle dba

2003-01-23 Thread Peter Barnett

Hard to answer this.  I am a 'lead' DBA for my current
employer but I do not lead anything.

I was a Senior DBA for a consulting firm.  That was
mostly to bill me out at higher rates.

For two different employers I was a plain, unadorned
DBA.  I was completely in charge of everything related
to bits and bytes.  From developers, to networking to
telecommunications to printer repair.

I was a systems programmer because that was the only
way I could be hired at a competitive pay scale for a
DBA.  My systems programmquitewas uite limited.

There have also been the jobs where I was a
combination Unix Admin/DBA.  Pick the title that looks
best on your business card.


--- BigP [EMAIL PROTECTED] wrote:
 MessageHow does one qualify for senior oracel dba.
 Do you guys have any questionare which I can ask
 myself .
 
 -Bp
 


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Barnett
  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: Slow database, too MANY buffers???

Michael - Can you run a STATSPACK report or otherwise get a query of the
wait statistics? Once you have that, you'll know where to go.


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

-Original Message-
Sent: Thursday, January 23, 2003 12:47 PM
To: Multiple recipients of list ORACLE-L


I've got a cust that is showing some signs that one would
think is having a horrible problem on I/O...
 
I suspect it is the error of having a **HUGE** value
in db_block_buffers and it's constantly crunching memory
trying to figure out which ones to free up. It's only
256 meg, but depending on load, it may be too much. SGA
is 687 meg.
 
While I've got hundreds of SQL, I'm not sure I have one
to diagnose buffer utilization. It's also version 8.1.7
and I could probably do some tweaking of buffers.
 
It's Oracle CRM with a lot of customization and I'm also
finding some SQL that's getting a bit ugly under there.
 
Maks.

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

Clean Up Win2K Event Log

2003-01-23 Thread Post, Ethan

Saw a message somewhere (Usenet maybe) about someone having trouble with the
Win2K event log filling with Oracle messages whenever SYS privs are
accessed.  Here is a little free tool that might be useful if you are having
this problem.

http://ntsecurity.nu/toolbox/winzapper/

- Ethan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  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).

BMC's Patrol

2003-01-23 Thread KENNETH JANUSZ




Is anyone using BMC's Patrol tool on their Oracle DB? If 
so, what do you like / dislike about it? Any problem areas? Customer 
support from BMC?

Thanks,
Ken Janusz, CPIM

AUTORAID and VA7100 disk arrays for rp7400

2003-01-23 Thread Mandar A. Ghosalkar

Hi,

i am in the process of defining the specs for a rp7400. a lil overwhelmed by the
storage offerings from HP.
i wanted to know if any of ull hv any inputs regarding a disk array.
we currently hv a Model 30/FC disk array with 9gig drives.
I am looking for a similar or the next higher configuration disk array from HP.

Any inputs regarding VA7100 disk array or corresponding competetive disk aray from
HP/competitor?

cache size 256/512/1024 MB? dont know which to go.
thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives.

the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1
or 5 configuration on the fly).
any inputs on AutoRAID for Oracle database files.
hv ull used 0+1 h/w configuration on VA7100? am i talking sense?

a good article to read, especially page 4
http://www.hp.com/products1/storage/products/disk_arrays/infolibrary/hp_va_and_san_virtualization.pdf

any inputs related to configuring a rp7400 are invited. my initial specs based on my
current k570 is below.

current k570 (7.3.4)
4 * 200Mhz
2 gn ram

specs for rp7400 (8i/9i)
4 * 550MHz
6 Gb ram

and i thought it was easy.
take a few procs
add ram
add few disks,
(Baaam!) make sound and license
and u hv a server.

but look into a detailed partlist and configuration options at
https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi

Thanks
Mandar

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mandar A. Ghosalkar
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: STATSPACK INFO UPDATE

List,
 While doing a very broad search on Metalink I found an answer to one
of my questions about where the readme files are on openvms...
 VMS:

Oracle8i 8.1.7

For Oracle8i 8.1.7.0.0, to get the README file, please contact

Oracle Support Services, and request patch for bug:

[BUG:1745567] - MISSING STATSPACK FILES FOR ALPHA OPENVMS 8.1.7.0.0 

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

Re: Slow database, too MANY buffers???

2003-01-23 Thread Jonathan Lewis


You could try:

selectfile#, dbablk, count(*)
fromx$bh
group by 
file#, dbablk
having count(*)  5
;

(technically you should include the 
tablespace number, but that won't 
matter if you have less than 1022 
files).

This will report the blocks which have an
unusually large number of CR copies in the
buffer.  There is a nominal limit of 7, but
if your buffer is excessive for the work done
then there is a fair chance that the most
intensively used blocks will have far more 
buffers.  (The worst case I saw was something
like 75).

The side effects of this would include lots of
spinning and sleeping on the cache buffers
chains latch.






Regards

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

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates: 
(see http://www.jlcomp.demon.co.uk/seminar.html )

England__January 21/23
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 23 January 2003 19:05


I've got a cust that is showing some signs that one would
think is having a horrible problem on I/O...

I suspect it is the error of having a **HUGE** value
in db_block_buffers and it's constantly crunching memory
trying to figure out which ones to free up. It's only
256 meg, but depending on load, it may be too much. SGA
is 687 meg.

While I've got hundreds of SQL, I'm not sure I have one
to diagnose buffer utilization. It's also version 8.1.7
and I could probably do some tweaking of buffers.

It's Oracle CRM with a lot of customization and I'm also
finding some SQL that's getting a bit ugly under there.

Maks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: AUTORAID and VA7100 disk arrays for rp7400

2003-01-23 Thread Vergara, Michael (TEM)

Apologies to all for shouting, but ...

DO NOT USE AUTORAID!
** *** *** *

I used an AutoRaid system when I was at Petco.  Performance was
el-sucko.  There was more I/Os happening in the disk array
(by observing the disk lights) than was being caused by the
application and database.

Plus, when the AR system Raid 0+1/5 mode, where some blocks are
kept in a RAID 0+1 area and some are kept in a RAID 5 area, the
array got so busy swapping one for another that it was virtually
useless.

Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok,
heck, even JBOD works better than AutoRaid.

Just my 2¢ worth.

Cheers,
Mike


-Original Message-
Sent: Thursday, January 23, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L


Hi,

i am in the process of defining the specs for a rp7400. a lil overwhelmed by the 
storage offerings from HP.
i wanted to know if any of ull hv any inputs regarding a disk array.
we currently hv a Model 30/FC disk array with 9gig drives.
I am looking for a similar or the next higher configuration disk array from HP.

Any inputs regarding VA7100 disk array or corresponding competetive disk aray from 
HP/competitor?

cache size 256/512/1024 MB? dont know which to go.
thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives.

the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 
or 5 configuration on the fly).
any inputs on AutoRAID for Oracle database files.
hv ull used 0+1 h/w configuration on VA7100? am i talking sense?

a good article to read, especially page 4
http://www.hp.com/products1/storage/products/disk_arrays/infolibrary/hp_va_and_san_virtualization.pdf


any inputs related to configuring a rp7400 are invited. my initial specs based on my 
current k570 is below.

current k570 (7.3.4)
4 * 200Mhz 
2 gn ram

specs for rp7400 (8i/9i)
4 * 550MHz
6 Gb ram

and i thought it was easy.
take a few procs
add ram
add few disks,
(Baaam!) make sound and license
and u hv a server.

but look into a detailed partlist and configuration options at
https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi


Thanks
Mandar
-- 
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: Statspack recomendations.

2003-01-23 Thread Freeman Robert - IL

Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:

select a.file_name 
from dba_temp_files a, v$tempstat b
where b.file#=a.file_id;

I get an ora-0600 on this with a [ktfthcf-1] [202]

Argument. I looked this up on Metalink and this appears to have been a bug
discovered in 8i and fixed in 9i but alas, it's still here. I tried to
implement the work around, issuing the RULE hint, which removes the error
message but gives me no results.

Anyone experience this?

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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: Statspack recomendations.

2003-01-23 Thread Freeman Robert - IL

Go to bookpool.com. Best prices on tech books. I've ordered several books
from them and have always been happy.

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Thursday, January 23, 2003 1:46 PM
To: Multiple recipients of list ORACLE-L


 
 Don Burleson has a book called Oracle9i High-Performance 
 Tuning with STATSPACK.  Check out the link below.
 
 http://www.dba-oracle.com/books.htm
 
 Dave
 

Unfortunatly the ordering feature dosnt work on that site. IE 6 or
Mozilla 1.2.1
I was interested in Conducting the Oracle Job Interview

bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  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: Freeman Robert - IL
  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: Statspack recomendations.

2003-01-23 Thread Bob Metelsky

 
 Don Burleson has a book called Oracle9i High-Performance 
 Tuning with STATSPACK.  Check out the link below.
 
 http://www.dba-oracle.com/books.htm
 
 Dave
 

Unfortunatly the ordering feature dosnt work on that site. IE 6 or
Mozilla 1.2.1
I was interested in Conducting the Oracle Job Interview

bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  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: AUTORAID and VA7100 disk arrays for rp7400

2003-01-23 Thread Jesse, Rich

NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID

That ought to sum it up.  S.L.O.W.  Our little 28GB DB takes 14 hours to
fully restore to the AutoRAID.  And we've done the tuning.  Granted, it's a
bit stressed since we're using some of the 0+1 area, but it's still way too
slow.  We don't even have the redos on the AutoRAID, and we still take a
beating.  Our I/O waits are horrendous.  We'll be replacing it this year.

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

 -Original Message-
 From: Mandar A. Ghosalkar [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 1:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: AUTORAID and VA7100 disk arrays for rp7400
 

[snip]
 
 the va7100 product specs on HP site mention more about 
 AutoRAID (which is dynamic 0+1 or 5 configuration on the fly).
 any inputs on AutoRAID for Oracle database files.
 hv ull used 0+1 h/w configuration on VA7100? am i talking sense?

[snip]
-- 
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: Program name in v$ views

Title: RE: Program name in v$ views

Doesn't show up in my OEM 9.2.0.1.0 listing of
sessions.

Pat.

-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 23,
2003 2:01 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Program name in v$ views
TOAD sets the module name as T.O.A.D
Raj __ Rajendra Jamadagni
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any
opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion
is an art!
-Original Message- From:
Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Subject: Program name in v$ views
Does anyone know why sometimes a program name appears in the
v$ views for user sessions, and sometimes
nothing?
I noticed that sqlplus appears as sqlplus.exe, and other
problems as their executable file name, but for TOAD
nothing appears.
Is there a way to force Oracle to collect this
information?
Regards, Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
systèmes Technology
Services | Services
technologiques Informatics
Branch | Direction de
l'informatique Maritimes Region,
DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Boivin, Patrice J INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

Dictionary location or initSID.ora and PWDsid.ora

2003-01-23 Thread Bob Metelsky

Can I dynamicall find the location of initSID.ora 
Eg C:\admin\INSTANCE\PFILE\initSID.ora
and the password dir
E.g C:\Oracle\Ora81\DATABASE\*.ora

Im setting up a cold backup script and would like to include these 2 dir

Im poking around in the v$ tables but cant seem to find it
Id like to avoid hardcoding the values

Thanks!!
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  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: STATSPACK INFO UPDATE