Re: consistent gets

[bhabani s pradhan]

Hi

consistent gets are when the SQL needs the data in consistent mode i.e not the current 
data. SELECT statements contribute to consistent gets (read from the RBS). DML 
normally contribute to db block gets, but say an UPDATE based on a search criterion -- 
will contribute to consistent gets.

Thanks and Regards
Pradhan

-

On Wed, 08 Oct 2003 Sultan Syed wrote :
Hi,

What does the meaning for this consistent gets.
Some time my statement return more consistent gets in statistics.
How I can reduce this Consistent gets.

Thanks in advance.

RE: consistent gets

[Sinardy Xing]

If 
you want to reduce your consistent gets, you can reduce your sga size 



  -Original Message-From: Sultan Syed 
  [mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To: 
  Multiple recipients of list ORACLE-LSubject: consistent 
  gets
  Hi,
  
  What does the meaning for this consistent 
  gets.
  Some time my statement returnmore 
  consistent gets in statistics.
  How I can reduce this Consistent 
  gets.
  
  Thanks in advance.
  
  
  

RE: Strange Request

[Sinardy Xing]

:)

-Original Message-
Sent: 08 October 2003 09:54
To: Multiple recipients of list ORACLE-L


did you just want to see it in an alert.log?  or are you working with a 
dump?

joe


Vergara, Michael (TEM) wrote:

Ok...strange request time.  I want to test a script that I found
on the DBA Village web site.  It's supposed to capture some
information whenever there's a DB error.

Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality?

Thanks,
Mike


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

  


-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  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: Sinardy Xing
  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: Strange Request

[Sinardy Xing]

ora-600 may result your db down or crash

-Original Message-
Sent: 08 October 2003 10:09
To: Multiple recipients of list ORACLE-L


I want the DB to see and act on an ORA-00600, not just record
one in the alertSID.log

Thanks,
Mike


-Original Message-
Sent: Tuesday, October 07, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L


did you just want to see it in an alert.log?  or are you working with a 
dump?

joe


Vergara, Michael (TEM) wrote:

Ok...strange request time.  I want to test a script that I found
on the DBA Village web site.  It's supposed to capture some
information whenever there's a DB error.

Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality?

Thanks,
Mike


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

  


-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  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: Sinardy Xing
  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: Basic question about controlfile recovery

[scott]

Thankz Mladen  Govindan.

I do have Velpuri's book besides me.
let me go thro' it once again.

Regards,
Scott.

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: scott
  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: Strange Request

[Lord David]

How about...

declare
   ora600 exception;
   pragma exception_init(ora600, -600);
begin
   raise ora600;
end;
/
show errors;

HTH
--
David Lord

 -Original Message-
 From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2003 02:14
 To: Multiple recipients of list ORACLE-L
 Subject: Strange Request
 
 
 Ok...strange request time.  I want to test a script that I found
 on the DBA Village web site.  It's supposed to capture some
 information whenever there's a DB error.
 
 Does anybody know how to trigger a 'benign' ORA-600 so I can test
 this functionality?
 
 Thanks,
 Mike
 
 
 ---
 ==
 =
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** 
 This e-mail and its attachments are intended for the
 author's addressee only and may be confidential. 

 If they have come to you in error you must take no 
 action based on them, nor must you copy or show 
 them to anyone; please reply to this e-mail and  
 highlight the error. 

 Please note that this e-mail has been created in the
 knowledge that Internet e-mail is not a 100% secure 
 communications medium. We advise that you 
 understand and observe this lack of security when 
 e-mailing us. Steps have been taken to ensure this 
 e-mail and attachments are free from any virus, but 
 advise the recipient to ensure they are actually virus 
 free. 

 The views, opinions and judgments expressed in this 
 message are solely those of the author. The message 
 contents have not been reviewed or approved by Iron 
 Mountain.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lord David
  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: consistent gets

[zhu chao]

Hi,
Consistent gets means the blocks oracle have to visit , it means the real cost of 
the SQL.(consisteng gets + db block gets)
Reduce SGA size has nothing to do with Consistent gets.
TO reduce consistent gets, only Tune the SQL or create proper index etc can help.


Zhu Chao.
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, October 08, 2003 3:34 PM



If you want to reduce your consistent gets, you can reduce your sga size 

-Original Message-
Sent: 08 October 2003 14:14
To: Multiple recipients of list ORACLE-L


Hi,

What does the meaning for this consistent gets.
Some time my statement return more consistent gets in statistics.
How I can reduce this Consistent gets.

Thanks in advance.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  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: Strange Request

[Jack van Zanen]

Dbms_system.ksdwrt(2,'ORA-600: This is a test error message')

Writes a message to the alert log
Change the 2 into a 1 writes to trace file and 3 (I think writes to both)


Jack



-Original Message-
Sent: Wednesday, October 08, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L


How about...

declare
   ora600 exception;
   pragma exception_init(ora600, -600);
begin
   raise ora600;
end;
/
show errors;

HTH
--
David Lord

 -Original Message-
 From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2003 02:14
 To: Multiple recipients of list ORACLE-L
 Subject: Strange Request
 
 
 Ok...strange request time.  I want to test a script that I found on 
 the DBA Village web site.  It's supposed to capture some information 
 whenever there's a DB error.
 
 Does anybody know how to trigger a 'benign' ORA-600 so I can test this 
 functionality?
 
 Thanks,
 Mike
 
 
 --- ==
 =
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from).  You may also send 
 the HELP command for other information (like subscribing).
 


*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** 
 This e-mail and its attachments are intended for the
 author's addressee only and may be confidential. 

 If they have come to you in error you must take no 
 action based on them, nor must you copy or show 
 them to anyone; please reply to this e-mail and  
 highlight the error. 

 Please note that this e-mail has been created in the
 knowledge that Internet e-mail is not a 100% secure 
 communications medium. We advise that you 
 understand and observe this lack of security when 
 e-mailing us. Steps have been taken to ensure this 
 e-mail and attachments are free from any virus, but 
 advise the recipient to ensure they are actually virus 
 free. 

 The views, opinions and judgments expressed in this 
 message are solely those of the author. The message 
 contents have not been reviewed or approved by Iron 
 Mountain.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lord David
  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: Jack van Zanen
  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).

karikatur

[A.Bahar]

RE: consistent gets

[Sinardy Xing]

yeah rite, i just test u

-Original Message-
Sent: 08 October 2003 16:29
To: Multiple recipients of list ORACLE-L


Hi,
Consistent gets means the blocks oracle have to visit , it means the real cost of 
the SQL.(consisteng gets + db block gets)
Reduce SGA size has nothing to do with Consistent gets.
TO reduce consistent gets, only Tune the SQL or create proper index etc can help.


Zhu Chao.
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, October 08, 2003 3:34 PM



If you want to reduce your consistent gets, you can reduce your sga size 

-Original Message-
Sent: 08 October 2003 14:14
To: Multiple recipients of list ORACLE-L


Hi,

What does the meaning for this consistent gets.
Some time my statement return more consistent gets in statistics.
How I can reduce this Consistent gets.

Thanks in advance.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  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: Sinardy Xing
  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: RE: Unintentional Humor ( aka Robert's Book )

[Hately, Mike (LogicaCMG)]

Without wishing to start another Cary's Fabled Book thread, I've got my
copy of 10G Features on order.

BTW I should mention I found Cary's book in Leeds at the weekend and it is,
as trailed in this very group, a beauty.

Cheers,
Mike

-Original Message-
Sent: 07 October 2003 21:39
To: Multiple recipients of list ORACLE-L


Oracle10g New Features is coming to a book store near you soon!!

he he he




E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  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: Re[2]: Cary's Book - new topic

[Grabowy, Chris]

Perhaps a flashback query would help???

-Original Message-
Wolfgang Breitling
Sent: Tuesday, October 07, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L


Unfortunately it's not my ability to see into the future, but an
inability 
to see all of the past.

Now what was that I was looking for?

At 03:34 PM 10/7/2003, you wrote:
Wolfgang,

Tuesday, October 7, 2003, 2:04:24 PM, you wrote:

W A totally different point: How come I see your response before I
W see my own post?

Sounds like you can see into the future.  Would you mind reading the
Wall Street journal and reporting back to us?

-rje

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  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: Grabowy, Chris
  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: RE: Desupport of RBO

[Grabowy, Chris]

I didn't ask for a comment, just a suggestion...or a hint...off the record.

Don't worry Raj, I'll stop by Mr. Freeman's house with a keg...soon he'll be 
commenting a lot.  If that doesn't work then I'll threaten to call him a SQL Server 
DBA...

-Original Message-
Sent: Tuesday, October 07, 2003 5:16 PM
To: Grabowy, Chris; 'Multiple recipients of list ORACLE-L '


For right now, I am unable to comment on anything 10g.

Thanks for understanding!

Robert

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/7/2003 3:44 PM

Nope.  Mr Freeman are you out there??

Also, Jonathan Lewis is a commentary author for this book, so he may
some insight.

But wait, I have some dice at my desk...bingo...it's 8 percent faster.
You can quote me.

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L


did he mention any benchmarked performance improvements from gathering
statistics on the system tablespacE? 
 
 From: Grabowy, Chris [EMAIL PROTECTED]
 Date: 2003/10/07 Tue PM 03:34:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Desupport of RBO
 
 At the recent NYOUG conference, they were handing out special preview
copies of Oracle 10g New Features by our very own Robert Freeman
  
 Page 11 has a section entitled...Collecting Data Dictionary
Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS
procedure.
  
 Does that answer your question Patrice?
 
 -Original Message-
 Sent: Tuesday, October 07, 2003 3:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 We had issues here with first_rows and all_rows when set in init.ora
for 8i a couple of years ago... performance dropped significantly.
During discussions with Oracle Support I learned that the data
dictionary for 8i has to run in rule mode, I don't know if they changed
that in 9i or 10G.
  
 Hopefully... 10G still has a data dictionary I imagine.
  
 : )
  
 Patrice.
 
 -Original Message-
 Sent: Tuesday, October 07, 2003 3:14 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 10g it won't be supported... wander when rule hints won't be used in
E-Business Suite... 11.5.8 still has rule hints in some of the code.
 
 April Wells 
 Oracle DBA/Oracle Apps DBA 
 Corporate Systems 
 Amarillo Texas 
   /\ 
  /   \ 
 / \ 
 \ / 
   \/ 
   \ 
  \ 
  \ 
  \ 
 Few people really enjoy the simple pleasure of flying a kite 
 Adam Wells age 11 
 
 
 
 -Original Message- 
 Sent: Tuesday, October 07, 2003 1:05 PM 
 To: Multiple recipients of list ORACLE-L 
 
 
 OK, dumb question.  Does this mean the rule hint won't be possible? 
 Application I support mostly uses CBO but there have been cases where
we had to 
 resort to RBO hint.  'course it'll be some time before we can consider
v10... 
 
 Kip 
 
 |Hi Jared, 
 
 |haven't seen it, too. But the fact 
 |was spreaded over the newsgroups. 
 
 |We still have some 3rd party apps that don't use 
 |*any* feature above Oracle 7 (well, almost). Queries with 
 |the RULE hint where it's not necessary. 
 |But if we change a thing, support will be lost. 
 |So we decided to rewrite the whole app. 
 |Lucky me: enough work for the next years. 
 
 |Greetings, 
 |Guido 
 
 | [EMAIL PROTECTED] 07.10.2003  01.34 Uhr  
 |First time I've seen this note:  189702.1 
 
 |Jared 
 
 |-- 
 |Please see the official ORACLE-L FAQ: http://www.orafaq.net 
 |-- 
 |Author: Guido Konsolke 
 |  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 information contained in this communication, including
attachments, is strictly 
 
 confidential and for the intended use of the addressee only; it may
also contain 
 
 proprietary, price sensitive, or legally privileged information.
Notice is 

RE: RE: Cary's Book - new topic

[Rachel Carmichael]

You point out something that I've found most developers/DBAs don't
do... actually sit with the end user to see what the problem is.

This happens at the design end as well. I have seen way too many user
friendly applications that aren't, because the programmer wrote it for
someone at his/her technical level and not for the clerk who actually
uses it.

I'm STILL fighting with one development team who wrote a search screen,
with ONE box for data entry and did not have the cursor sit in the box.
One extra mouse click for the end user. Every time they search.


--- Cary Millsap [EMAIL PROTECTED] wrote:
 These are the BEST projects to be on. You took a different path than
 I
 would have at the second Me line. I would shoot for:
 
 Customer: It's Slow
 Me: What is?
 Customer: The application. Make it fast.
 Me: Show me.
 Customer: Okay, come see.
 
 Then your job becomes to get a 10046/12 trace on what you're
 watching.
 From there, it's all downhill.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Tuesday, October 07, 2003 2:24 PM
 To: Multiple recipients of list ORACLE-L
 
 how many projects actually have SLAs? Ive been on 5 projects and none
 of
 them have had them. Its always been. 
 
 Customer: 'It's Slow'
 Me: What is?
 Customer: The application. Make it fast.
 Me: Define fast.
 Customer: As fast as possible. Do it now. 
 
  
  From: Wolfgang Breitling [EMAIL PROTECTED]
  Date: 2003/10/07 Tue PM 02:59:55 EDT
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: Cary's Book - new topic
  
  Good point. I suppose this gets into the realm of perceived
 response 
  time. Some applications break long transactions into several user 
  interactions to hide the real response time. The application still
 makes 
  its SLA defined as 90% of transactions complete in  3 seconds
 while
 the 
  real transaction takes a lot longer. However, the user is kept busy
 and you 
  get into that perception thing. I know that if I see a traffic jam,
 I
 look 
  for ways to detour around it. Even it I don't save any time (there
 is
 no 
  way of telling really), I have at least the impression that I'm
 doing 
  something, that I'm in charge, rather sitting passively in the jam
 crawling 
  along, waiting for something the clear up.
  
  At 12:39 PM 10/7/2003, you wrote:
  
  Also, if we are to really address the business case as you suggest
 then
  the definition should also include the quality of the response. If
 the
  response is quick but incomplete and the user has to ask 10
 questions
 to
  get at the one real answer he's after then what good is a fast
 response
  time?
  
  -Original Message-
  Sent: Tuesday, October 07, 2003 12:09 PM
  To: Multiple recipients of list ORACLE-L
  
  Wolfgang Breitling
  Oracle7, 8, 8i, 9i OCP DBA
  Centrex Consulting Corporation
  http://www.centrexcc.com 
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Wolfgang Breitling
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: [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: Cary Millsap
   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
 

Small Oracle db

[Dwayne Cox]

Does anyone have more info on this?

http://www.infoworld.com/article/03/10/07/HNoraclesmb_1.html

--
Dwayne Cox
Corporate DBA
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608
email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dwayne Cox
 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: Desupport of RBO

[Boivin, Patrice J]

Title: RE: Desupport of RBO



Chris, 
Yes, thank you very much!

In a 
way it will be simpler to have only one optimizer mode to take into 
consideration. We will be able to analyze the whole database and leave it 
at that.

I 
assume that dbms_stats.gather_database_stats is smart enough to make the 
difference between sys objects and the rest of the data...

Patrice.

  -Original Message-From: Grabowy, Chris 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 4:34 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Desupport of RBO
  At 
  the recent NYOUG conference, they were handing out special preview copies of 
  Oracle 10g New Features by our very own Robert Freeman
  
  Page 
  11 has a section entitled...Collecting Data Dictionary Statistics...this is 
  done using the DBMS_STATS.GATHER_DICTIONARY_STATS 
  procedure.
  
  Does 
  that answer your question Patrice?
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice 
JSent: Tuesday, October 07, 2003 3:00 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: Desupport of 
RBO
We 
had issues here with first_rows and all_rows when set in init.ora for 8i a 
couple of years ago... performance dropped significantly. 
During discussions with Oracle Support I learned that the data 
dictionary for 8i has to run in rule mode, I don't know if they changed that 
in 9i or 10G.

Hopefully... 10G still has a data dictionary I 
imagine.

: 
)

Patrice.

  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 3:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Desupport of RBO
  10g it won't be supported... wander when rule hints won't 
  be used in E-Business Suite... 11.5.8 still has rule hints in some of the 
  code.
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo Texas  /\ / \ / \ \ /  
  \/  \  \  \  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, October 07, 2003 1:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: Desupport of RBO 
  OK, dumb question. Does this mean the rule hint 
  won't be possible? Application I support mostly 
  uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can 
  consider v10... 
  Kip 
  |Hi Jared, 
  |haven't seen it, too. But the fact |was spreaded over the newsgroups. 
  |We still have some 3rd party apps that don't use 
  |*any* feature above Oracle 7 (well, almost). Queries 
  with |the RULE hint where it's not 
  necessary. |But if we change a thing, support will 
  be lost. |So we decided to rewrite the whole 
  app. |Lucky me: enough work for the next 
  years. 
  |Greetings, |Guido 
  | [EMAIL PROTECTED] 07.10.2003 
  01.34 Uhr  |First time I've seen this 
  note: 189702.1 
  |Jared 
  |-- |Please see the official 
  ORACLE-L FAQ: http://www.orafaq.net |-- 
  |Author: Guido Konsolke | 
  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 information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, 

RE: RE: Cary's Book - new topic

[rgaffuri]

2 of the projects Ive been on I have not had any contact with clients. I wasnt even 
allowed to speak to them. It all had to go through product managers, or the prime 
contractor. 

Its nice when your able to speak to your customer, but sometimes your not allowed to. 
Ive been attacked by the prime contractor with 'Why do you need to talk to the 
customer, I told you what to do?'

That kind of environment is not uncommon. Unfortunately its also necessary, alot of 
technical people dont speak well and you really dont want them to get anywhere near a 
client. Especially if they are just sub-contractors. 

I found the paranoia level to be especially high on US government projects. 
 
 From: Rachel Carmichael [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 07:59:24 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Cary's Book - new topic
 
 You point out something that I've found most developers/DBAs don't
 do... actually sit with the end user to see what the problem is.
 
 This happens at the design end as well. I have seen way too many user
 friendly applications that aren't, because the programmer wrote it for
 someone at his/her technical level and not for the clerk who actually
 uses it.
 
 I'm STILL fighting with one development team who wrote a search screen,
 with ONE box for data entry and did not have the cursor sit in the box.
 One extra mouse click for the end user. Every time they search.
 
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  These are the BEST projects to be on. You took a different path than
  I
  would have at the second Me line. I would shoot for:
  
  Customer: It's Slow
  Me: What is?
  Customer: The application. Make it fast.
  Me: Show me.
  Customer: Okay, come see.
  
  Then your job becomes to get a 10046/12 trace on what you're
  watching.
  From there, it's all downhill.
  
  
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
  
  Upcoming events:
  - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
  - Hotsos Symposium 2004: March 7-10 Dallas
  - Visit www.hotsos.com for schedule details...
  
  
  -Original Message-
  [EMAIL PROTECTED]
  Sent: Tuesday, October 07, 2003 2:24 PM
  To: Multiple recipients of list ORACLE-L
  
  how many projects actually have SLAs? Ive been on 5 projects and none
  of
  them have had them. Its always been. 
  
  Customer: 'It's Slow'
  Me: What is?
  Customer: The application. Make it fast.
  Me: Define fast.
  Customer: As fast as possible. Do it now. 
  
   
   From: Wolfgang Breitling [EMAIL PROTECTED]
   Date: 2003/10/07 Tue PM 02:59:55 EDT
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Subject: RE: Cary's Book - new topic
   
   Good point. I suppose this gets into the realm of perceived
  response 
   time. Some applications break long transactions into several user 
   interactions to hide the real response time. The application still
  makes 
   its SLA defined as 90% of transactions complete in  3 seconds
  while
  the 
   real transaction takes a lot longer. However, the user is kept busy
  and you 
   get into that perception thing. I know that if I see a traffic jam,
  I
  look 
   for ways to detour around it. Even it I don't save any time (there
  is
  no 
   way of telling really), I have at least the impression that I'm
  doing 
   something, that I'm in charge, rather sitting passively in the jam
  crawling 
   along, waiting for something the clear up.
   
   At 12:39 PM 10/7/2003, you wrote:
   
   Also, if we are to really address the business case as you suggest
  then
   the definition should also include the quality of the response. If
  the
   response is quick but incomplete and the user has to ask 10
  questions
  to
   get at the one real answer he's after then what good is a fast
  response
   time?
   
   -Original Message-
   Sent: Tuesday, October 07, 2003 12:09 PM
   To: Multiple recipients of list ORACLE-L
   
   Wolfgang Breitling
   Oracle7, 8, 8i, 9i OCP DBA
   Centrex Consulting Corporation
   http://www.centrexcc.com 
   
   
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   -- 
   Author: Wolfgang Breitling
 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: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 

RE: Unix Help

[Nelson, Allan]

Title: Message



DEST_DIR=your_desination_directory
SOURCE_DIR=your_source_directory

for 
file in `ls $SOURCE_DIR`
do
 fn=basename $file
 if [ ! -f $DEST_DIR/$fn ]
 then
 cp $file $DEST_DIR/$fn
 fi
done

Hope 
it helps.
Allan

  
  -Original Message-From: Sujatha Madan 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 
  10:24 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Unix Help
  Hi,
  
  Sorry for the 
  slightly non-Oracle post.
  
  I am after a 
  UNIX code snippet that will help me copy archive logs to another directory BUT 
  not if they already exist. So if only 2 archive logs are generated between 
  script runs only the two new ones should copy. I know I can do this using 
  sysdate - "time interval" but I am trying to avoid 
  that.
  
  Thanks in 
  advance,
  
  Sujatha 
  Madan.

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

RE: RE: Cary's Book - new topic

[Jamadagni, Rajendra]

Title: RE: RE: Cary's Book - new topic





Cary,


We are doing exactly that on one of our databases. After hearing _few_complaints that DB is slow (code is not), we enabled trace at level 12 for power users. Now every AM my job is to analyze 20+ trace files that I get and report back. 

Once we see a pattern, we will hand it over to Development team and then work with them to resolve the issues.


Now only if I could find a version of TKPROF that works with 2GB+ trace files .. 


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


--- Cary Millsap [EMAIL PROTECTED] wrote:
 These are the BEST projects to be on. You took a different path than I would have at the second Me line. I would shoot for:

 
 Customer: It's Slow
 Me: What is?
 Customer: The application. Make it fast.
 Me: Show me.
 Customer: Okay, come see.
 
 Then your job becomes to get a 10046/12 trace on what you're watching.
 From there, it's all downhill.
 Cary Millsap



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: RE: Cary's Book - new topic

[rgaffuri]

go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046 
traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink. 
 
 From: Jamadagni, Rajendra [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 09:14:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Cary's Book - new topic
 
 Cary,
 
 We are doing exactly that on one of our databases. After hearing
 _few_complaints that DB is slow (code is not), we enabled trace at level 12
 for power users. Now every AM my job is to analyze 20+ trace files that I
 get and report back. 
 
 Once we see a pattern, we will hand it over to Development team and then
 work with them to resolve the issues.
 
 Now only if I could find a version of TKPROF that works with 2GB+ trace
 files .. 
 
 Raj
 
 
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  These are the BEST projects to be on. You took a different path than I
 would have at the second Me line. I would shoot for:
  
  Customer: It's Slow
  Me: What is?
  Customer: The application. Make it fast.
  Me: Show me.
  Customer: Okay, come see.
  
  Then your job becomes to get a 10046/12 trace on what you're watching.
  From there, it's all downhill.
  Cary Millsap
 
 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
 
 
Title: RE: RE: Cary's Book - new topic





Cary,


We are doing exactly that on one of our databases. After hearing _few_complaints that DB is slow (code is not), we enabled trace at level 12 for power users. Now every AM my job is to analyze 20+ trace files that I get and report back. 

Once we see a pattern, we will hand it over to Development team and then work with them to resolve the issues.


Now only if I could find a version of TKPROF that works with 2GB+ trace files .. 


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


--- Cary Millsap [EMAIL PROTECTED] wrote:
 These are the BEST projects to be on. You took a different path than I would have at the second Me line. I would shoot for:

 
 Customer: It's Slow
 Me: What is?
 Customer: The application. Make it fast.
 Me: Show me.
 Customer: Okay, come see.
 
 Then your job becomes to get a 10046/12 trace on what you're watching.
 From there, it's all downhill.
 Cary Millsap

RE: RE: Cary's Book - new topic

[Stefick Ronald S Contr ESC/HRIDD]

Title: RE: RE: Cary's Book - new topic





Or you can look into getting the Hotsos Profiler It would definitely be money well spent!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 08, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Cary's Book - new topic



go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046 traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink. 

 
 From: Jamadagni, Rajendra [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 09:14:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Cary's Book - new topic
 
 Cary,
 
 We are doing exactly that on one of our databases. After hearing 
 _few_complaints that DB is slow (code is not), we enabled trace at 
 level 12 for power users. Now every AM my job is to analyze 20+ trace 
 files that I get and report back.
 
 Once we see a pattern, we will hand it over to Development team and 
 then work with them to resolve the issues.
 
 Now only if I could find a version of TKPROF that works with 2GB+ 
 trace files ..
 
 Raj
 --
 --
 
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  These are the BEST projects to be on. You took a different path than 
  I
 would have at the second Me line. I would shoot for:
  
  Customer: It's Slow
  Me: What is?
  Customer: The application. Make it fast.
  Me: Show me.
  Customer: Okay, come see.
  
  Then your job becomes to get a 10046/12 trace on what you're 
  watching. From there, it's all downhill. Cary Millsap
 
 Th
 is 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: Can I execute an exe from a stored Procedure

[Pete Finnigan]

Mladen,

Not if you don't use micro$ mail clients!!

cheers

Pete

In article [EMAIL PROTECTED], Mladen Gogala
[EMAIL PROTECTED] writes
No problem! Just open any email entitled Latest security patch from
MIcrosoft and you'll execute an .exe file.

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  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: COBOL TO ORACLE

[babette.turnerunderwood]

Welcome to MY world :-( 

Basically, we need to get a Volkswagen to run faster than a Ferrari.

-Original Message-
Sent: 2003-10-07 4:29 PM
To: Multiple recipients of list ORACLE-L



I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/)
and found OS/390 -
   
  
   
  
 OS/390
  
 OS/390, the foundation of the new z/OS, provides high levels of availability, scale 
and 
 manageability for mission-critical workloads, with such features as Workload Manager 
and
 Parallel Sysplex support. OS/390 is an integrated offering of many elements and 
optional
 features, including new technologies such as Enterprise Java Beans, XML, and HTML. 
OS/390   
 provides the qualities of service needed to meet the demands of global e-business.
  
   
  

Notice the mention of Workload Manager --- Basically setting the priorities
of various processes as to when they will be swapped back in.  I suspect
that your SYSADMIN is trained in the current version but does not
understand the underlying technology.  If there were no swapping then only
one user could be signed on at a time, they could only run one process, and
when they went to print the process would stop until the printing was
finished.


   

  babette.turneru 

  nderwood To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @hrdc-drhc.gc.ca cc: 

  Subject: RE: COBOL TO ORACLE

  Sent by: 

  ml-errors

   

   

  10/07/2003 03:59 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Sorry for the delay ...

Was at Ottawa Oracle User Group Days last week and spent the time since
then playing catch-up

Yes, we are using OS/390 v10.
I STRONGLY suspect the SYSADMIN is wrong.
There HAS to be swapping / paging going on, but he insists this is not the
case.

Babette Turner-Underwood
work: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
954-3752 (Mon - Fri 7am - 3pm)


-Original Message-
Sent: 2003-10-01 4:00 PM
To: Multiple recipients of list ORACLE-L



What kind of a mainframe is that?

Usually mainframe means an IBM machine based on 370 architecture.  If
that's the case then your SYSADMIN is wrong.  Many, many years ago I
started out as a computer operator for an IBM 370/165 and worked with IBM
mainframes up through the E6000 series.  They all work as virtual machines,
swapping and paging sessions in and out of the physical RAM.

Of course, you may have some other type of mainframe, in which case, what I
said doesn't apply.




  babette.turneru

  nderwood To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  @hrdc-drhc.gc.ca cc:

  Subject: RE: COBOL TO ORACLE

  Sent by:

  ml-errors



 

A quick note

[Robertson Lee - lerobe]

Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee






**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  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: IGNORE: Unix Help

[Farnsworth, Dave]

Title: Message



Or was 
it that we just ignored your post? ;o)

Dave

  -Original Message-From: Sujatha Madan 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 
  11:29 PMTo: Multiple recipients of list ORACLE-LSubject: 
  IGNORE: Unix Help
  Sorry ... but I solved it.
  
  Cheers
  Sujatha
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Sujatha MadanSent: Wednesday, 8 October 2003 1:24 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Unix Help
Hi,

Sorry for the 
slightly non-Oracle post.

I am after a 
UNIX code snippet that will help me copy archive logs to another directory 
BUT not if they already exist. So if only 2 archive logs are generated 
between script runs only the two new ones should copy. I know I can do this 
using sysdate - "time interval" but I am trying to avoid 
that.

Thanks in 
advance,

Sujatha 
Madan.

RE: Small Oracle db

[Grabowy, Chris]

Now we know where the RBO went too!!  They pulled it out of 10g and
stuck it into Oracle Standard Edition One.  Duh.  It's smaller, cheaper
it uses RBO.  You gotta pay extra for CBO.

Sorry for stealing your thunder Mladen ...just borrowing it...you can
have it back now.

-Original Message-
Dwayne Cox
Sent: Wednesday, October 08, 2003 8:21 AM
To: Multiple recipients of list ORACLE-L


Does anyone have more info on this?

http://www.infoworld.com/article/03/10/07/HNoraclesmb_1.html


-- 
Dwayne Cox
Corporate DBA
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608

email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.

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

encrypt traffic across internet?

[Joe Testa]

The question was posed to me about a simple web browser (non ssl), 
accessing an oracle database and shooting the information across the 
internet to a client, this info is NOT encrypted i assume.

is that also true for like remote sqlplus connections and if you wanted 
it to be for web, you need to go via SSL and for sqlplus what can be 
used?  Is this where ASO comes in(i think thats is, advanced security 
option?)

thanks, joe

--
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

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

OTN 10g sessions

[Ron Rogers]

List,
from the following url on the application server you can resister for
the OTN session in your area.
http://www.oracle.com/appserver/  Featuring 10g for the grid.

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: RE: Cary's Book - new topic

[Jamadagni, Rajendra]

Title: RE: RE: Cary's Book - new topic





Thanks, 


I have been using that tool for a long time now, it needs a big tablespace (cause everything is loaded in tables) and puts a load on the server. It is good for smaller files, but takes too long on larger files.

Nevertheless it is a great utility.
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 08, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Cary's Book - new topic



go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046 traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink. 

RE: BROKEN_PIPE during Weblogic J2EE - thanks

[DENNIS WILLIAMS]

Ryan, Ian - Thanks for your replies. This helped get the developers talking
to BEA. It may come back to the database, but at least it got them looking
at possibilities beyond the database. Sometimes a statement from an outsider
carries more weight.

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


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


did it have an accompanying ORA- message or some such? If not than its
either a Weblogic error, a weblogic translation of an oracle error, or your
developers trapped the oracle error and translated it to something else(I
hate when they do that). 
 
 From: DENNIS WILLIAMS [EMAIL PROTECTED]
 Date: 2003/10/06 Mon PM 01:19:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: BROKEN_PIPE during Weblogic J2EE deployment
 
 Our web administrator was deploying a new J2EE application to production
and
 received the error broken_pipe. We are using the thin client. Apparently
 Weblogic tries to verify existence the tables the application uses. The
 deployment was otherwise successful in that the error occurred several
times
 when deployment was retried but testing the app worked fine. They feel it
 was a database error, but I don't see anything on my end. Naturally they
are
 nervous about this error just going into a critical new application.
 Apparently if the database was down, this is the error returned on the
 Weblogic side, but the database was fine and I couldn't find any errors. I
 searched for broken_pipe on Metalink and the search returned empty. Has
 anyone had any experience with this Weblogic error?
 
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [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: OTN 10g sessions

[rgaffuri]

those sessions are typical all marketing and buzz word type training. you wont get the 
goods until the product and the documentation comes out. i dont see the rush. it wont 
be out until atleast 2nd quarter next year. Most shops arent even using 9i yet... 
 
 From: Ron Rogers [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 10:39:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: OTN 10g sessions
 
 List,
 from the following url on the application server you can resister for
 the OTN session in your area.
 http://www.oracle.com/appserver/  Featuring 10g for the grid.
 
 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: [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).

RE: RE: Cary's Book - new topic

[Cary Millsap]

I agree that it's common. But it's probably provably correct to say that
these sites cannot reach a targeted performance level as quickly or as
cheaply as if they would if they removed the constraint.

I know it's a slow, uphill battle. Getting ammunition together to fight
this battle is one of the motives I had for writing the book. I believe
that an idea with a real book behind it is a lot more likely to have
weight in a bureaucracy than an idea without a book behind it. For some
reason, a book is like a necktie for ideas.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L

2 of the projects Ive been on I have not had any contact with clients. I
wasnt even allowed to speak to them. It all had to go through product
managers, or the prime contractor. 

Its nice when your able to speak to your customer, but sometimes your
not allowed to. Ive been attacked by the prime contractor with 'Why do
you need to talk to the customer, I told you what to do?'

That kind of environment is not uncommon. Unfortunately its also
necessary, alot of technical people dont speak well and you really dont
want them to get anywhere near a client. Especially if they are just
sub-contractors. 

I found the paranoia level to be especially high on US government
projects. 
 
 From: Rachel Carmichael [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 07:59:24 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Cary's Book - new topic
 
 You point out something that I've found most developers/DBAs don't
 do... actually sit with the end user to see what the problem is.
 
 This happens at the design end as well. I have seen way too many user
 friendly applications that aren't, because the programmer wrote it
for
 someone at his/her technical level and not for the clerk who actually
 uses it.
 
 I'm STILL fighting with one development team who wrote a search
screen,
 with ONE box for data entry and did not have the cursor sit in the
box.
 One extra mouse click for the end user. Every time they search.
 
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  These are the BEST projects to be on. You took a different path than
  I
  would have at the second Me line. I would shoot for:
  
  Customer: It's Slow
  Me: What is?
  Customer: The application. Make it fast.
  Me: Show me.
  Customer: Okay, come see.
  
  Then your job becomes to get a 10046/12 trace on what you're
  watching.
  From there, it's all downhill.
  
  
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
  
  Upcoming events:
  - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
  - Hotsos Symposium 2004: March 7-10 Dallas
  - Visit www.hotsos.com for schedule details...
  
  
  -Original Message-
  [EMAIL PROTECTED]
  Sent: Tuesday, October 07, 2003 2:24 PM
  To: Multiple recipients of list ORACLE-L
  
  how many projects actually have SLAs? Ive been on 5 projects and
none
  of
  them have had them. Its always been. 
  
  Customer: 'It's Slow'
  Me: What is?
  Customer: The application. Make it fast.
  Me: Define fast.
  Customer: As fast as possible. Do it now. 
  
   
   From: Wolfgang Breitling [EMAIL PROTECTED]
   Date: 2003/10/07 Tue PM 02:59:55 EDT
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Subject: RE: Cary's Book - new topic
   
   Good point. I suppose this gets into the realm of perceived
  response 
   time. Some applications break long transactions into several user

   interactions to hide the real response time. The application still
  makes 
   its SLA defined as 90% of transactions complete in  3 seconds
  while
  the 
   real transaction takes a lot longer. However, the user is kept
busy
  and you 
   get into that perception thing. I know that if I see a traffic
jam,
  I
  look 
   for ways to detour around it. Even it I don't save any time (there
  is
  no 
   way of telling really), I have at least the impression that I'm
  doing 
   something, that I'm in charge, rather sitting passively in the jam
  crawling 
   along, waiting for something the clear up.
   
   At 12:39 PM 10/7/2003, you wrote:
   
   Also, if we are to really address the business case as you
suggest
  then
   the definition should also include the quality of the response.
If
  the
   response is quick but incomplete and the user has to ask 10
  questions
  to
   get at the one real answer he's after then what good is a fast
  response
   time?
   
   -Original Message-
   Sent: Tuesday, October 07, 2003 12:09 PM
   To: Multiple recipients of list ORACLE-L
   
   Wolfgang Breitling
   Oracle7, 8, 8i, 9i OCP DBA
   Centrex Consulting Corporation
   http://www.centrexcc.com 
   
   
   -- 
   Please see the 

interesting article...

[Chris Stephens]

Title: RE: RE: Cary's Book - new topic









http://www.eweek.com/article2/0,4149,1312906,00.asp

RE: encrypt traffic across internet?

[Norris, Gregory T [ITS]]

ASO should work here, although I've not used it personally (apparently it's rather 
expensive).  It's certainly not the only option, however.  I've used OpenSSH's 
tunneling capabilities for this purpose, for example, but there are a number of other 
utilities which can do more-or-less the same thing (stunnel, VPNs, etc.).  This sort 
of thing requires the use of CMAN on the DB server, but is fairly trivial to set up.

-Original Message-
Sent: Wednesday, October 08, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L


The question was posed to me about a simple web browser (non ssl), 
accessing an oracle database and shooting the information across the 
internet to a client, this info is NOT encrypted i assume.

is that also true for like remote sqlplus connections and if you wanted 
it to be for web, you need to go via SSL and for sqlplus what can be 
used?  Is this where ASO comes in(i think thats is, advanced security 
option?)

thanks, joe

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  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: Norris, Gregory T [ITS]
  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).

SAME and separating disk and index tablespaces

[vikas kawatra]

Guys,

Does it make sense to separate data and index segments into separate
tablespaces if you create a single logical volume and all files are
striped using the SAME methodology ?

Thanks

vikas


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: vikas kawatra
  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: RE: Cary's Book - new topic

[rgaffuri]

the goal of government maintenance projects is not to get anything done. its to keep 
the contract going and keep the revenues coming in. people dont want to work 
themselves out of a job.

I think its one of the reasons people over do the CMM stuff. They can look good with 
their processes, get money, and pro-long the life of the contract due to the extra red 
tape. 
 
 From: Cary Millsap [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 11:24:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Cary's Book - new topic
 
 I agree that it's common. But it's probably provably correct to say that
 these sites cannot reach a targeted performance level as quickly or as
 cheaply as if they would if they removed the constraint.
 
 I know it's a slow, uphill battle. Getting ammunition together to fight
 this battle is one of the motives I had for writing the book. I believe
 that an idea with a real book behind it is a lot more likely to have
 weight in a bureaucracy than an idea without a book behind it. For some
 reason, a book is like a necktie for ideas.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
 - Hotsos Symposium 2004: March 7-10 Dallas
 - Visit www.hotsos.com for schedule details...
 
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Wednesday, October 08, 2003 7:44 AM
 To: Multiple recipients of list ORACLE-L
 
 2 of the projects Ive been on I have not had any contact with clients. I
 wasnt even allowed to speak to them. It all had to go through product
 managers, or the prime contractor. 
 
 Its nice when your able to speak to your customer, but sometimes your
 not allowed to. Ive been attacked by the prime contractor with 'Why do
 you need to talk to the customer, I told you what to do?'
 
 That kind of environment is not uncommon. Unfortunately its also
 necessary, alot of technical people dont speak well and you really dont
 want them to get anywhere near a client. Especially if they are just
 sub-contractors. 
 
 I found the paranoia level to be especially high on US government
 projects. 
  
  From: Rachel Carmichael [EMAIL PROTECTED]
  Date: 2003/10/08 Wed AM 07:59:24 EDT
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: RE: Cary's Book - new topic
  
  You point out something that I've found most developers/DBAs don't
  do... actually sit with the end user to see what the problem is.
  
  This happens at the design end as well. I have seen way too many user
  friendly applications that aren't, because the programmer wrote it
 for
  someone at his/her technical level and not for the clerk who actually
  uses it.
  
  I'm STILL fighting with one development team who wrote a search
 screen,
  with ONE box for data entry and did not have the cursor sit in the
 box.
  One extra mouse click for the end user. Every time they search.
  
  
  --- Cary Millsap [EMAIL PROTECTED] wrote:
   These are the BEST projects to be on. You took a different path than
   I
   would have at the second Me line. I would shoot for:
   
   Customer: It's Slow
   Me: What is?
   Customer: The application. Make it fast.
   Me: Show me.
   Customer: Okay, come see.
   
   Then your job becomes to get a 10046/12 trace on what you're
   watching.
   From there, it's all downhill.
   
   
   Cary Millsap
   Hotsos Enterprises, Ltd.
   http://www.hotsos.com
   
   Upcoming events:
   - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
   - Hotsos Symposium 2004: March 7-10 Dallas
   - Visit www.hotsos.com for schedule details...
   
   
   -Original Message-
   [EMAIL PROTECTED]
   Sent: Tuesday, October 07, 2003 2:24 PM
   To: Multiple recipients of list ORACLE-L
   
   how many projects actually have SLAs? Ive been on 5 projects and
 none
   of
   them have had them. Its always been. 
   
   Customer: 'It's Slow'
   Me: What is?
   Customer: The application. Make it fast.
   Me: Define fast.
   Customer: As fast as possible. Do it now. 
   

From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 02:59:55 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Cary's Book - new topic

Good point. I suppose this gets into the realm of perceived
   response 
time. Some applications break long transactions into several user
 
interactions to hide the real response time. The application still
   makes 
its SLA defined as 90% of transactions complete in  3 seconds
   while
   the 
real transaction takes a lot longer. However, the user is kept
 busy
   and you 
get into that perception thing. I know that if I see a traffic
 jam,
   I
   look 
for ways to detour around it. Even it I don't save any time (there
   is
   no 
way of telling really), I have at least the impression that I'm
   doing 
something, that I'm in charge, rather sitting passively in the jam
   crawling 

Re: auditing is my friend

[Pete Finnigan]

Hi Paul,

Have a look at the paper i wrote for security focus a few months ago,
called An Introduction to simple Oracle auditing - there is a link to
it on my site - http://www.petefinnigan.com/orasec.htm - its the second
paper on there. It is not in-depth but concentrates on the benefits of
just turning audit on and gives examples of SQL to find a few abuses,
such as logins out of hours, users sharing accounts, attempts to use
accounts that do not exist etc - as i say just basic ideas. I agree its
well worth just turning audit on and seeing what can be learned from
just audit session for instance!.

Kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  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: encrypt traffic across internet?

[Richard Ji]

Or you can tunnel sqlplus and many other programs through ssh.

-Original Message-
Sent: Wednesday, October 08, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


The question was posed to me about a simple web browser (non ssl), 
accessing an oracle database and shooting the information across the 
internet to a client, this info is NOT encrypted i assume.

is that also true for like remote sqlplus connections and if you wanted 
it to be for web, you need to go via SSL and for sqlplus what can be 
used?  Is this where ASO comes in(i think thats is, advanced security 
option?)

thanks, joe

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  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: Richard Ji
  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: RE: BROKEN_PIPE during Weblogic J2EE - thanks

[rgaffuri]

sounds like bad error handling on BEA's part. i hate when vendors 'translate' database 
messages to something else. 
 
 From: DENNIS WILLIAMS [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 10:59:26 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: BROKEN_PIPE during Weblogic J2EE - thanks
 
 Ryan, Ian - Thanks for your replies. This helped get the developers talking
 to BEA. It may come back to the database, but at least it got them looking
 at possibilities beyond the database. Sometimes a statement from an outsider
 carries more weight.
 
 Thanks,
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 
 -Original Message-
 Sent: Monday, October 06, 2003 1:04 PM
 To: Multiple recipients of list ORACLE-L
 
 
 did it have an accompanying ORA- message or some such? If not than its
 either a Weblogic error, a weblogic translation of an oracle error, or your
 developers trapped the oracle error and translated it to something else(I
 hate when they do that). 
  
  From: DENNIS WILLIAMS [EMAIL PROTECTED]
  Date: 2003/10/06 Mon PM 01:19:25 EDT
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: BROKEN_PIPE during Weblogic J2EE deployment
  
  Our web administrator was deploying a new J2EE application to production
 and
  received the error broken_pipe. We are using the thin client. Apparently
  Weblogic tries to verify existence the tables the application uses. The
  deployment was otherwise successful in that the error occurred several
 times
  when deployment was retried but testing the app worked fine. They feel it
  was a database error, but I don't see anything on my end. Naturally they
 are
  nervous about this error just going into a critical new application.
  Apparently if the database was down, this is the error returned on the
  Weblogic side, but the database was fine and I couldn't find any errors. I
  searched for broken_pipe on Metalink and the search returned empty. Has
  anyone had any experience with this Weblogic error?
  
  Dennis Williams
  DBA, 80%OCP, 100% DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [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).
 

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

RE: Strange Request

[Vergara, Michael (TEM)]

Works like a champ, and didn't bring down the DB.

Thanks,
Mike


-Original Message-
Sent: Wednesday, October 08, 2003 1:25 AM
To: Multiple recipients of list ORACLE-L


How about...

declare
   ora600 exception;
   pragma exception_init(ora600, -600);
begin
   raise ora600;
end;
/
show errors;

HTH
--
David Lord

 -Original Message-
 From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2003 02:14
 To: Multiple recipients of list ORACLE-L
 Subject: Strange Request
 
 
 Ok...strange request time.  I want to test a script that I found
 on the DBA Village web site.  It's supposed to capture some
 information whenever there's a DB error.
 
 Does anybody know how to trigger a 'benign' ORA-600 so I can test
 this functionality?
 
 Thanks,
 Mike
 
 
 ---
 ==
 =
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** 
 This e-mail and its attachments are intended for the
 author's addressee only and may be confidential. 

 If they have come to you in error you must take no 
 action based on them, nor must you copy or show 
 them to anyone; please reply to this e-mail and  
 highlight the error. 

 Please note that this e-mail has been created in the
 knowledge that Internet e-mail is not a 100% secure 
 communications medium. We advise that you 
 understand and observe this lack of security when 
 e-mailing us. Steps have been taken to ensure this 
 e-mail and attachments are free from any virus, but 
 advise the recipient to ensure they are actually virus 
 free. 

 The views, opinions and judgments expressed in this 
 message are solely those of the author. The message 
 contents have not been reviewed or approved by Iron 
 Mountain.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lord David
  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: interesting article...

[Mladen Gogala]

At the moment, I'm more interested in the new governator of California
then Larry Ellison. Even if oracle is out, I'll be able to do  other
things. As a former VAX/VMS system administrator, believe me, I know.

On Wed, 2003-10-08 at 11:29, Chris Stephens wrote:
 http://www.eweek.com/article2/0,4149,1312906,00.asp
 
  
 
  
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

[Mercadante, Thomas F]

Title: RE: RE: Cary's Book - new topic



it is 
interesting. but who knows if this person's opinions are correct. 
should we start "shorting" Oracle stock?


  -Original Message-From: Chris Stephens 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003 
  11:29 AMTo: Multiple recipients of list ORACLE-LSubject: 
  interesting article...
  
  http://www.eweek.com/article2/0,4149,1312906,00.asp
  
  

RE: A quick note

[Hallas, John, Tech Dev]

Hey good to see you back again Lee.

The big change here is that all Oracle knowledge has been cyber-engineered into an 
automoton called Tanel Poder.
Any query to the list is routed by a big fast connection into a huge server with 
hundreds of CPU's and unlimited memory

An almost instantaneous reply is automatically generated , often complete with complex 
examples and code cuts to demonstrate the point.
The best part is that is that the machine is programmed to exibit almost humanistic 
type responses (occasionally) 

John


-Original Message-
Robertson Lee - lerobe
Sent: 08 October 2003 11:34
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee






**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  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: Hallas, John, Tech Dev
  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).

Oracle Corp. and the LINUX conversion

[Boivin, Patrice J]

I am wondering... Does anyone know if Oracle completed its transition to
LINUX?

Are they even running their backup servers  to the linux platform?  

The proof is in the pudding as they say, if Oracle converted even their
backup architecture to LINUX then you know LINUX is ready for the
enterprise.

Did Oracle ever post something recommending LINUX for 9iAS 9.0.x instead of
Win32?

Patrice.
-- 
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: OTN 10g sessions

[Boivin, Patrice J]

I have the impression it's November perhaps December for 10G shipping.

Patrice.

-Original Message-
Sent: Wednesday, October 08, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


those sessions are typical all marketing and buzz word type training. you
wont get the goods until the product and the documentation comes out. i dont
see the rush. it wont be out until atleast 2nd quarter next year. Most shops
arent even using 9i yet... 
 
 From: Ron Rogers [EMAIL PROTECTED]
 Date: 2003/10/08 Wed AM 10:39:25 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: OTN 10g sessions
 
 List,
 from the following url on the application server you can resister for
 the OTN session in your area.
 http://www.oracle.com/appserver/  Featuring 10g for the grid.
 
 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: [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: 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: A quick note

[Robertson Lee - lerobe]

I suggest you buy your mushrooms from the supermarket like the rest of us
instead of picking them in those strange fields my friend



-Original Message-
Sent: 08 October 2003 17:25
To: Multiple recipients of list ORACLE-L


Hey good to see you back again Lee.

The big change here is that all Oracle knowledge has been cyber-engineered
into an automoton called Tanel Poder.
Any query to the list is routed by a big fast connection into a huge server
with hundreds of CPU's and unlimited memory

An almost instantaneous reply is automatically generated , often complete
with complex examples and code cuts to demonstrate the point.
The best part is that is that the machine is programmed to exibit almost
humanistic type responses (occasionally) 

John


-Original Message-
Robertson Lee - lerobe
Sent: 08 October 2003 11:34
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee






**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  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: Hallas, John, Tech Dev
  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: Robertson Lee - lerobe
  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: A quick note

[Boivin, Patrice J]

Did you see this in the news?

http://www.theonion.com/3939/news1.html

Patrice

-Original Message-
Sent: Wednesday, October 08, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee






**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  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: Re: Desupport of RBO

[Henry Poras]

from Chap. 1 of Oracle Database 10g New Features on
http://otn.oracle.com/oramag/webcolumns/2003/techarticles/new_features_previ
ew.pdf

The Rule Based Optimizer (RBO) is desupported with Oracle Database 10 g. It
's still
there in Oracle Database 10 g, but Oracle is moving away from it quickly and
you will
find no bug fixes associated with it in future versions of the database.

Henry


-Original Message-
Cary Millsap
Sent: Tuesday, October 07, 2003 11:20 PM
To: Multiple recipients of list ORACLE-L


I'm pretty sure that RBO is *gone* in 10g. If I understood correctly
what I learned this week, there will be no more RBO, just one optimizer
code path called the Oracle Query Optimizer. Also, if I understand
correctly, the RULE hint will have exactly the same functionality as
the HEY, DUDE hint: none.

...But I haven't tested it.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L

i dont think they are totally removing the RBO from 10g. Ive seen
conflicting reports. I think tom kyte hinted that it is gone, then I
read somewhere else that its still going to be there.

RBO is necessary if you use layered complex views. CBO often times
doesnt hold up. Its a pretty bad design. But some people use it. I see
it mostly with cross-platform apps. They tell you to always use RBO.

if the RBO is totally gone they will need to totally re-architecture
their products. So I dont know if Oracle will do this.

 From: [EMAIL PROTECTED]
 Date: 2003/10/07 Tue PM 02:04:31 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Desupport of RBO

 OK, dumb question.  Does this mean the rule hint won't be possible?
 Application I support mostly uses CBO but there have been cases where
we had to
 resort to RBO hint.  'course it'll be some time before we can consider
v10...

 Kip

 |Hi Jared,

 |haven't seen it, too. But the fact
 |was spreaded over the newsgroups.

 |We still have some 3rd party apps that don't use
 |*any* feature above Oracle 7 (well, almost). Queries with
 |the RULE hint where it's not necessary.
 |But if we change a thing, support will be lost.
 |So we decided to rewrite the whole app.
 |Lucky me: enough work for the next years.

 |Greetings,
 |Guido

 | [EMAIL PROTECTED] 07.10.2003  01.34 Uhr 
 |First time I've seen this note:  189702.1

 |Jared

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

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

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


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [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: Cary Millsap
  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 

RE: interesting article...

[Thomas Day]

I'm just hoping that Larry won't loose interest in the next 10 years.
After that, he can sell out to CA anytime.



   

  Mercadante, 

  Thomas FTo:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  NDATFM  cc: 

  @labor.state.ny. Subject: RE: interesting article... 

  us  

  Sent by: 

  ml-errors

   

   

  10/08/2003 12:24 

  PM   

  Please respond   

  to ORACLE-L  

   

   





it is interesting.  but who knows if this person's opinions are correct.
should we start shorting Oracle stock?

  -Original Message-
  From: Chris Stephens [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, October 08, 2003 11:29 AM
  To: Multiple recipients of list ORACLE-L
  Subject: interesting article...

  http://www.eweek.com/article2/0,4149,1312906,00.asp






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

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

RE: RE: Cary's Book - new topic

[Cary Millsap]

Title: RE: RE: Cary's Book - new topic









Hotsos Profiler will handle it, no problem.





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

Upcoming events:
- Performance Diagnosis101:
10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com for schedule
details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni,
Rajendra
Sent: Wednesday, October 08, 2003
8:14 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: RE: Cary's Book - new
topic



Cary, 

We are doing exactly that on one of our databases.
After hearing _few_complaints that DB is slow (code is not), we enabled trace
at level 12 for power users. Now every AM my job is to analyze 20+ trace files
that I get and report back. 

Once we see a pattern, we will hand it over to
Development team and then work with them to resolve the issues. 

Now only if I could find a version of TKPROF that
works with 2GB+ trace files .. 

Raj 


Rajendra dot Jamadagni at
nospamespn dot com 
All Views expressed in this email
are strictly personal. 
QOTD: Any clod can have facts,
having an opinion is an art ! 

--- Cary Millsap [EMAIL PROTECTED]
wrote: 
 These are the BEST projects to
be on. You took a different path than I would have at the second Me
line. I would shoot for:

 
 Customer: It's
Slow 
 Me: What is? 
 Customer: The application.
Make it fast. 
 Me: Show me. 
 Customer: Okay, come see.

 
 Then your job becomes to get a
10046/12 trace on what you're watching. 
 From there, it's all downhill.

 Cary Millsap 

RE: data loading

[Nancy Hu]

Thank Stephane and Jacques for your reply.  We are running Oracle 8.1.7.4, 
but will upgrade to Oracle 9.2.0.3 soon.  Partitioning works for some of our 
tables.  Are there other methods that allow us to avoid the problem of 
unique constraint.


From: Jacques Kilchoer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: data loading
Date: Mon, 06 Oct 2003 14:29:24 -0800
If you choose to implement this method, make sure that all the tables can 
be in the exchange partition command. The exchange partition command has 
certain requirements to be able to complete the exchange (similarity of 
indexes and constraints), and the table has to be suitable for building a 
copy as a partitioned table.
For example, the method would not work with this table (because of the two 
unique keys):
create table t (a number unique, b number unique) ;
If your database version is 8.0 there are even more restrictions on what 
kind of table you can use in an exchange partition command (IIRC any FK 
constraint will prevent you from using the table in an exchange partition.)

 -Original Message-
 Stephane Paquette

 You can use the partitionning option.

 Load into a 1 partitionned table then do a partition exchange with the
 target table.

 It allows you to have the current data live while loading into the
 partitionned table.
 Once the load is loaded just exchange the partition with the
 table, it is
 fast as it is just an update in the data dictionnary. No data
 is physically
 moved.

 -Original Message-
 Nancy Hu

 We have an Oracle database that is a kind of data warehouse.
 We load data
 from mainframe into the database every day.  The following
 are the steps how
 we load data currently:

 1. get the data file from Datacom
 2. ftp the data file from mainframe to the Sun machine where
 the Oracle
 database resides
 3. truncate all tables in Oracle database
 4. load the data into Oracle with SQL LOADER

 Most tables in the Oracle database don't have primary key.
 Tables are not
 available during the loading that gives us problem for our 24x7
 availability.  Therefore, we would like to change our loading
 method.  Any
 ideas would be highly appreciated.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
  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).
_
Instant message in style with MSN Messenger 6.0. Download it now FREE!  
http://msnmessenger-download.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nancy Hu
 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: OTN 10g sessions

[Mladen Gogala]

I expect to find it under my Christmas tree on 12/25. I've been
a bad boy during the whole year, I deserve 10g for Xmas.

On Wed, 2003-10-08 at 12:39, Boivin, Patrice J wrote:
 I have the impression it's November perhaps December for 10G shipping.
 
 Patrice.
 
 -Original Message-
 Sent: Wednesday, October 08, 2003 12:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 those sessions are typical all marketing and buzz word type training. you
 wont get the goods until the product and the documentation comes out. i dont
 see the rush. it wont be out until atleast 2nd quarter next year. Most shops
 arent even using 9i yet... 
  
  From: Ron Rogers [EMAIL PROTECTED]
  Date: 2003/10/08 Wed AM 10:39:25 EDT
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: OTN 10g sessions
  
  List,
  from the following url on the application server you can resister for
  the OTN session in your area.
  http://www.oracle.com/appserver/  Featuring 10g for the grid.
  
  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: [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
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: SAME and separating disk and index tablespaces

[Gaja Krishna Vaidyanatha]

Vikas,

The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to rebuild your indexes using
the NOLOGGING option between 2 backup jobs. If that
were the case, then all you will need to do after the
rebuild is complete, is to backup only the INDX
tablespace.

This is a best practice (if not a requirement) in most
production shops, unless you think you can re-re-build
your indexes in the event of media failure and you
lose your INDX tablespace.


Hope that helps,


Gaja
--- vikas kawatra [EMAIL PROTECTED] wrote:
 Guys,
 
 Does it make sense to separate data and index
 segments into separate
 tablespaces if you create a single logical volume
 and all files are
 striped using the SAME methodology ?
 
 Thanks
 
 vikas
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: vikas kawatra
   INET: [EMAIL PROTECTED]
 


=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager, 
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  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: interesting article...

[Orr, Steve]

Title: Message



See 
the four stepinvestment strategy I laid out in the feedback on the 
article... It only involves one illegal action. ;-)

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 
  08, 2003 10:25 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: interesting article...
  it 
  is interesting. but who knows if this person's opinions are 
  correct. should we start "shorting" Oracle stock?
  
  
-Original Message-From: Chris Stephens 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 
2003 11:29 AMTo: Multiple recipients of list 
ORACLE-LSubject: interesting article...

http://www.eweek.com/article2/0,4149,1312906,00.asp

RE: A quick note

[Michael Milligan]

Welcome back!

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, October 08, 2003 4:34 AM
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: A funny thing happened today on the way to OraPerf.com ...

[Gaja Krishna Vaidyanatha]

Hi Paul,

Long time no talk/see. Hope things are well with you.
I personally don't think there is any need for concern
here. OraPerf still remains as a free analyzer, just
the way it did when it was Anjo's site. OraPerf is now
provided as a service, as part of the Veritas
Architect Network. The same old good stuff, with more
resources supporting the site. If you have any further
concerns, please do not hesitate to contact me -
[EMAIL PROTECTED]

Thanks,

Gaja


--- Paul Drake [EMAIL PROTECTED] wrote:
 and I ended up here:
  
 http://oraperf.veritas.com/index.html
  
 Hmm. so now Veritas has the statspack reports that I
 uploaded previously.
 I don't know what to think.
  
 Maybe they'll see the source code, and the sales
 staff will think - too far gone for any of our
 utils and leave me alone?
  
 Pd
 
 
 -
 Do you Yahoo!?
 The New Yahoo! Shopping - with improved product
search


=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager, 
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  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).

EXP-00091: Exporting questionable statistics.

[Jake Johnson]

Hello,
I upgraded my oracle version from 9.2.0.1 to 9.2.0.3 and now I am getting this error.  
I collected stats on all the tables and still have this error.  Any ideas?

-- 
Thanks,
Jake Johnson
[EMAIL PROTECTED]

__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Tires, and Wheel Packages.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jake Johnson
  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: SAME and separating disk and index tablespaces

[vikas kawatra]

Thanks Gaja !  Does it also make sense from a performance perspective
(I/O issues due to concurrent access of index and data ) to separate
them or is that point moot once you apply the SAME methodology ? 

-Original Message-
Gaja Krishna Vaidyanatha
Sent: Wednesday, October 08, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L

Vikas,

The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to rebuild your indexes using
the NOLOGGING option between 2 backup jobs. If that
were the case, then all you will need to do after the
rebuild is complete, is to backup only the INDX
tablespace.

This is a best practice (if not a requirement) in most
production shops, unless you think you can re-re-build
your indexes in the event of media failure and you
lose your INDX tablespace.


Hope that helps,


Gaja
--- vikas kawatra [EMAIL PROTECTED] wrote:
 Guys,
 
 Does it make sense to separate data and index
 segments into separate
 tablespaces if you create a single logical volume
 and all files are
 striped using the SAME methodology ?
 
 Thanks
 
 vikas
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: vikas kawatra
   INET: [EMAIL PROTECTED]
 


=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager, 
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  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: vikas kawatra
  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: RE: Strange Request

[bhabani s pradhan]

Try this:

A shell script calling sql env to ANALYZE certain table. kill the process running the 
shell script before it is done. You might get ora-00600 with argumrnt[1113]

Thanks
Pradhan




On Wed, 08 Oct 2003 Sinardy Xing wrote :
ora-600 may result your db down or crash

-Original Message-
Sent: 08 October 2003 10:09
To: Multiple recipients of list ORACLE-L


I want the DB to see and act on an ORA-00600, not just record
one in the alertSID.log

Thanks,
Mike


-Original Message-
Sent: Tuesday, October 07, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L


did you just want to see it in an alert.log?  or are you working with a
dump?

joe


Vergara, Michael (TEM) wrote:

 Ok...strange request time.  I want to test a script that I found
 on the DBA Village web site.  It's supposed to capture some
 information whenever there's a DB error.
 
 Does anybody know how to trigger a 'benign' ORA-600 so I can test
 this functionality?
 
 Thanks,
 Mike
 
 
 ---
 ===
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 
 

--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


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

Sujatha.Madan@optus.net.au

[Chris Stephens]

Title: Message









I've been looking to do this for a
while...would you mind sharing the script??



Thanks either way!!



chris



-Original Message-
From: Sujatha Madan
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 07, 2003
11:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: IGNORE: Unix Help





Sorry ... but I solved
it.











Cheers





Sujatha





-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sujatha
Madan
Sent: Wednesday, 8 October 2003
1:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: Unix Help



Hi,











Sorry for the slightly non-Oracle
post.











I am after a UNIX code snippet
that will help me copy archive logs to another directory BUT not if they
already exist. So if only 2 archive logs are generated between script runs only
the two new ones should copy. I know I can do this using sysdate - time
interval but I am trying to avoid that.











Thanks in advance,











Sujatha Madan.

RE: A quick note

[Mladen Gogala]

No, I was too busy reading this:
http://www.welovearnold.com/

On Wed, 2003-10-08 at 12:39, Boivin, Patrice J wrote:
 Did you see this in the news?
 
 http://www.theonion.com/3939/news1.html
 
 Patrice
 
 -Original Message-
 Sent: Wednesday, October 08, 2003 7:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi everyone,
 
 I'm back in the land of the living after spending a year on a DB2 EEE
 project. I've just started working on a 9i RAC solution so the questions
 will soon be flooding in. I will be lucky if I can even remember to spell
 spqlusl , I mean sqlplus :-)
 
 Cheers
 
 Lee
 
 
 
 
 
 
 **
 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged.
 If the reader of this message is not the intended
 recipient, you are hereby notified that any dissemination, 
 distribution, or copying of this communication is strictly
 prohibited.
 If you have received this communication in error,
 please re-send this communication to the sender and
 delete the original message or any copy of it from your
 computer system. Thank You.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Robertson Lee - lerobe
   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
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: EXP-00091: Exporting questionable statistics.

[Mladen Gogala]

Did you collect system stats? In case everything else fails,
export will work with statistics=none

On Wed, 2003-10-08 at 13:49, Jake Johnson wrote:
 Hello,
 I upgraded my oracle version from 9.2.0.1 to 9.2.0.3 and now I am getting this 
 error.  I collected stats on all the tables and still have this error.  Any ideas?
 
 -- 
 Thanks,
 Jake Johnson
 [EMAIL PROTECTED]
 
 __
 Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
 Rims, Tires, and Wheel Packages.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

FIRST_ROWS hints

[Sai Selvaganesan]

hi

i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me inunderstanding this.

i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i could understand the 9204 db has fewer number of blocks compared to the existing 9203 (db size changed to 16k) and sort merge join turned out to be less costlier than nested loops (i couldntunderstand the sort statistics). no parameter other than db block size was changed.

after breaking my head i changed the optimizer mode from choose to first rows and the query is back to the old explain plans.

please clarify
1. whether this is a expected behaviour
2. what is first_rows hint and whether it is good move to go to first_rows to fix this problem.

thanks
sai

PS enqueue waits - need help

[Olga Gurevich]

Hi. I have a query that seems to be waiting for a PS
enqueu for about 2 days. When querying the
v$session_wait, I'm getting the following:

 SID EVENT  S-I-WT P1 
P2 P3
- - --  --
--- --
   48 enqueue   ##0 1347616774
  1 15
   15 direct path write  0   -1304
 185925 16
   67 direct path write  3   -1304
 326053 16
   23 direct path write  3   -1304
 171333 16
   64 direct path write  3   -1304
 159829 16

(sids 15,67,23 and 64 are parallel slaves of the SID
48).

I also see that this is a PS type enqueue via the
following:

  1  select sid,
  2  chr(bitand(p1,-16777216)/16777215)||
chr(bitand(p1,16711680)/65535) enq,
  3  decode(
chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/65535),
'TX','Transaction accessing a rbd', 'ST','Space mgt
activity', 'SS','Sort segment activity', 'TM','DML
ACtivity', 'UL','user defined',
chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/65535))
edes,
  4 
decode(bitand(p1,65535),1,'NULL',2,'SUB_SHARE',3,'SUB-exclusive',4,'share',5,'share
or subexclusive',6,'exclusive','other') md,
  5  p2,
  6  p3
  7  from gv$session_wait
  8* where event='enqueue'

 sid enq  enqueue name   lock mode
  P2 P3
-  -- --
--- --
   48 PS   PS exclusive   
1 15

I'm not sure what P2 and P3 are referring to in this
case. I have tried to kill the session, but it didn't
go away and the parallel slaves are still holding a
lot of space in the TEMP tablespace. What should I do
now? any sugestions?

thanks

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Olga Gurevich
  INET: [EMAIL PROTECTED]

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

How to copy recursive files in Windows? like unix cp -r

[Oracle DBA]

Hi List:

How to copy recursive files in Windows? like unix cp
-r

Thanks in advance,
Sami


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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: How to copy recursive files in Windows? like unix cp -r

[Jamadagni, Rajendra]

Title: RE: How to copy recursive files in Windows? like unix cp -r





xcopy /s -- copies recursively if sub-dir is not empty
xcopy /e -- everything including empty.


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Oracle DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: How to copy recursive files in Windows? like unix cp -r



Hi List:


How to copy recursive files in Windows? like unix cp
-r


Thanks in advance,
Sami


**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.**5

RE: How to copy recursive files in Windows? like unix cp -r

[Rothouse, Michael]

xcopy /e source destination

Example: xcopy /e c:\temp e:\


-Original Message-
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


Hi List:

How to copy recursive files in Windows? like unix cp
-r

Thanks in advance,
Sami


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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: Rothouse, Michael
  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: EXP-00091: Exporting questionable statistics.

[Wolfgang Breitling]

There are a number of reasons why you might get that error. The most 
frequent one is probably that the NLS_LANG setting between the server and 
the client are different. In Oracle 8i that prevented the export from 
exporting existing statistics altogether. Oracle 9i does export the 
statistics, but gives you this warning. If I'm correct you should also have 
gotten the warning about possible charset conversion.

At 11:49 AM 10/8/2003, you wrote:
Hello,
I upgraded my oracle version from 9.2.0.1 to 9.2.0.3 and now I am getting 
this error.  I collected stats on all the tables and still have this 
error.  Any ideas?

--
Thanks,
Jake Johnson
[EMAIL PROTECTED]
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: How to copy recursive files in Windows? like unix cp -r

[Khedr, Waleed]

xcopy

-Original Message-
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


Hi List:

How to copy recursive files in Windows? like unix cp
-r

Thanks in advance,
Sami


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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: Khedr, Waleed
  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: How to copy recursive files in Windows? like unix cp -r

[Wolfgang Breitling]

use xcopy /S or /E

C:\help xcopy
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
   [/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U]
   [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
   [/EXCLUDE:file1[+file2][+file3]...]
  source   Specifies the file(s) to copy.
  destination  Specifies the location and/or name of new files.
  /A   Copies only files with the archive attribute set,
   doesn't change the attribute.
  /M   Copies only files with the archive attribute set,
   turns off the archive attribute.
  /D:m-d-y Copies files changed on or after the specified date.
   If no date is given, copies only those files whose
   source time is newer than the destination time.
  /EXCLUDE:file1[+file2][+file3]...
   Specifies a list of files containing strings.  When any of the
   strings match any part of the absolute path of the file to be
   copied, that file will be excluded from being copied.  For
   example, specifying a string like \obj\ or .obj will exclude
   all files underneath the directory obj or all files with the
   .obj extension respectively.
  /P   Prompts you before creating each destination file.
  /S   Copies directories and subdirectories except empty ones.
  /E   Copies directories and subdirectories, including empty ones.
   Same as /S /E. May be used to modify /T.
  /V   Verifies each new file.
  /W   Prompts you to press a key before copying.
  /C   Continues copying even if errors occur.
  /I   If destination does not exist and copying more than one file,
   assumes that destination must be a directory.
  /Q   Does not display file names while copying.
  /F   Displays full source and destination file names while copying.
  /L   Displays files that would be copied.
  /H   Copies hidden and system files also.
  /R   Overwrites read-only files.
  /T   Creates directory structure, but does not copy files. Does not
   include empty directories or subdirectories. /T /E includes
   empty directories and subdirectories.
  /U   Copies only files that already exist in destination.
  /K   Copies attributes. Normal Xcopy will reset read-only 
attributes.
  /N   Copies using the generated short names.
  /O   Copies file ownership and ACL information.
  /X   Copies file audit settings (implies /O).
  /Y   Suppresses prompting to confirm you want to overwrite an
   existing destination file.
  /-Y  Causes prompting to confirm you want to overwrite an
   existing destination file.
  /Z   Copies networked files in restartable mode.

The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
At 12:59 PM 10/8/2003, you wrote:
Hi List:

How to copy recursive files in Windows? like unix cp
-r
Thanks in advance,
Sami
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Oracle DBA
  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).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: FIRST_ROWS hints

[Rajesh . Rao]

Very Much expected behaviour. Your increase in the db_block_size from 8 to
16, is making the optimizer choose full table scans, where applicable,
since you have to scan through only half the number of blocks now.

A nested loop will starting throwing the initial results faster. A sort
merge join might take more time to start throwing out the results, but the
entire job will finish faster. So, the first rows hint is forcing the
optimizer to choose nested loops.

Regards
Raj




   
  
Sai Selvaganesan   
  
[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
lobal.net cc: 
  
Sent by:   Subject: FIRST_ROWS hints   
  
[EMAIL PROTECTED]  
   
y.com  
  
   
  
   
  
10/08/2003 02:54   
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




hi

i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a
couple of observations. please help me in understanding this.

i changed the db block size from 8k to 16k and all sql queires which were
using nested loops earlier moved to sort merge joins. i ran 10053 and form
whatever i could understand the 9204 db has fewer number of blocks compared
to the existing 9203 (db size changed to 16k) and sort merge join turned
out to be less costlier than nested loops (i couldnt understand the sort
statistics). no  parameter other than db block size was changed.

after breaking my head i changed the optimizer mode from choose to first
rows and the query is back to the old explain plans.

please clarify
1. whether this is a expected behaviour
2. what is first_rows hint and whether it is good move to go to first_rows
to fix this problem.

thanks
sai

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

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

RE: FIRST_ROWS hints

[Scott Canaan]

Did you remember to cut the db_file_multiblock_read_count
in half, since you doubled the blocksize? I would assume that you also started
seeing more full table scans, as well.







Scott Canaan ([EMAIL PROTECTED])

(585) 475-7886

Life is like a sewer, what you get
out of it depends on what you put into it. - Tom Lehrer.





-Original Message-
From: Sai Selvaganesan
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday,
 October 08, 2003 2:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: FIRST_ROWS hints





hi











i had a migration from 9.2.0.3 to 9.2.0.4 of a
database and here are a couple of observations. please help me
inunderstanding this.











i changed the db block size from 8k to 16k and all sql
queires which were using nested loops earlier moved to sort merge joins. i ran
10053 and form whatever i could understand the 9204 db has fewer number of
blocks compared to the existing 9203 (db size changed to 16k) and sort merge
join turned out to be less costlier than nested loops (i
couldntunderstand the sort statistics). no parameter other than db
block size was changed.











after breaking my head i changed the optimizer mode
from choose to first rows and the query is back to the old explain plans.











please clarify





1. whether this is a expected behaviour





2. what is first_rows hint and whether it is good move
to go to first_rows to fix this problem.











thanks





sai

RE: SAME and separating disk and index tablespaces

[Hans de Git]

Vikas,

Spend an hour on reading this usenet thread:

http://groups.google.nl/groups?hl=nllr=ie=UTF-8oe=UTF-8threadm=brjz8.15%24707.245%40news.oracle.comrnum=1prev=/groups%3Fhl%3Dnl%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3Drogers%2Bseparate%2Bdata%2Bindex

It will open your eyes about separating data/index.

Still not sure about the redolog stream...Because of the sequential nature 
of redologfiles. I've read  tests that 'prove' it doesn't matter much 
whether you separate your redolog from 'ordinary' datafiles or not. It does 
simplify things when you pure SAME.

Regards,
Hans
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 08 Oct 2003 09:54:30 -0800
Thanks Gaja !  Does it also make sense from a performance perspective
(I/O issues due to concurrent access of index and data ) to separate
them or is that point moot once you apply the SAME methodology ?
-Original Message-
Gaja Krishna Vaidyanatha
Sent: Wednesday, October 08, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
Vikas,

The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to rebuild your indexes using
the NOLOGGING option between 2 backup jobs. If that
were the case, then all you will need to do after the
rebuild is complete, is to backup only the INDX
tablespace.
This is a best practice (if not a requirement) in most
production shops, unless you think you can re-re-build
your indexes in the event of media failure and you
lose your INDX tablespace.
Hope that helps,

Gaja
--- vikas kawatra [EMAIL PROTECTED] wrote:
 Guys,

 Does it make sense to separate data and index
 segments into separate
 tablespaces if you create a single logical volume
 and all files are
 striped using the SAME methodology ?

 Thanks

 vikas


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

=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
  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: vikas kawatra
  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).
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
 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: FIRST_ROWS hints

[Sai Selvaganesan]

tried that too.infact i changed the db_file_multiblock_read_count to a very small value about 1/8 of the previous value. for it to move from SM to NL in only one case.

generally,it is using SJ only.and right i have started seeing a lot of full table scans.

apparently the general recommendation is to have a bigger block size on datawarehouse kind of systems. in those cases this could be a issue. so can i conclude that though DW returns results in a longer time, this is acceptable and it is a attribute of DW.
saiScott Canaan [EMAIL PROTECTED] wrote:





Did you remember to cut the db_file_multiblock_read_count in half, since you doubled the blocksize? I would assume that you also started seeing more full table scans, as well.



Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

-Original Message-From: Sai Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:54 PMTo: Multiple recipients of list ORACLE-LSubject: FIRST_ROWS hints


hi



i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me inunderstanding this.



i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i could understand the 9204 db has fewer number of blocks compared to the existing 9203 (db size changed to 16k) and sort merge join turned out to be less costlier than nested loops (i couldntunderstand the sort statistics). no parameter other than db block size was changed.



after breaking my head i changed the optimizer mode from choose to first rows and the query is back to the old explain plans.



please clarify

1. whether this is a expected behaviour

2. what is first_rows hint and whether it is good move to go to first_rows to fix this problem.



thanks

sai

intermedia text and dbms_job problem

[Bill Tantzen]

OK, I know I must be doing something wrong, would somebody please point
out what it is?  I would like to set up a job to sync an intermedia text
index.  Here is my job:

  SQL select what from all_jobs where job = 2;
  WHAT
  -
  ctx_ddl.sync_index ( 'ctx_xml_text' );

I can execute the procedute from the command line like so:

  SQL execute ctx_ddl.sync_index ( 'ctx_xml_text' );
  PL/SQL procedure successfully completed.

But the job itself fails:

  SQL execute dbms_job.run ( 2 );
  BEGIN dbms_job.run ( 2 ); END;

  *
  ERROR at line 1:
  ORA-12011: execution of 1 jobs failed
  ORA-06512: at SYS.DBMS_IJOB, line 405
  ORA-06512: at SYS.DBMS_JOB, line 267
  ORA-06512: at line 1


in my init.ora I have:
  job_queue_processes = 4
  job_queue_interval = 60

I am in the ctxapp role, and ctxsys has granted me execute on ctx_ddl.
The only other job works just fine.

OS=Solaris, Version=8.1.7

What the heck is going on?

Thanks in advance,
Bill

Bill Tantzen 
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office)  612-250-6125 (cell)

I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bill Tantzen
  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: RE: Cary's Book - new topic

[John Kanagaraj]

Title: Message



Raj 
(and all who use Oracle's Trace analyzer,

I 
'converted' the trace analzyer tables to GTTs, and no longer had the space 
issues with large trace files. This is because the data is stored 'temporarily' 
and is used for reporting in a subsequent SQL in the same session stream, and 
not reused elsewhere. Haven't really measured performance improvement, but this 
should ride on all the advantages that GTT provides.

FWIW! 


John KanagarajDB Soft IncPhone: 408-970-7002 
(W)Disappointment is inevitable, but Discouragement is 
optional!** The opinions and facts contained in this message are 
entirely mine and do not reflect those of my employer or customers 
**

  
  -Original Message-From: Jamadagni, 
  Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, 
  October 08, 2003 7:19 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: RE: Cary's Book - new 
  topic
  Thanks, 
  I have been using that tool for a long time now, it needs a 
  big tablespace (cause everything is loaded in tables) and puts a load on the 
  server. It is good for smaller files, but takes too long on larger 
  files.
  Nevertheless it is a great utility. Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 9:50 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: RE: 
  Cary's Book - new topic 
  go to metalink and check out trace analyzer. ITs a new tool 
  for analyzing 10046 traces. Has ALOT more detail than tkprof. Major 
  improvement. Its on metalink. 

RE: FIRST_ROWS hints

[Kevin Toepke]

Title: Message



How 
big are your sort_area_size and hash_area_size? I would guess that your 
hash_area_size is set very small when compared to your sort_area_size I know 
that won't move the queries back to using a NL, but I've found that in most 
cases a hash join is much more efficient than a SM join when there is adequite 
hash area available

Kevin 
T

  
  -Original Message-From: Sai Selvaganesan 
  [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 
  3:50 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: FIRST_ROWS hints
  
  tried that too.infact i changed the db_file_multiblock_read_count to a 
  very small value about 1/8 of the previous value. for it to move from SM to NL 
  in only one case.
  
  generally,it is using SJ only.and right i have started seeing a lot of 
  full table scans.
  
  apparently the general recommendation is to have a bigger block size on 
  datawarehouse kind of systems. in those cases this could be a issue. so can i 
  conclude that though DW returns results in a longer time, this is 
  acceptable and it is a attribute of DW.
  saiScott Canaan [EMAIL PROTECTED] 
  wrote:
  




Did you remember to 
cut the db_file_multiblock_read_count in half, since you doubled the 
blocksize? I would assume that you also started seeing more full table 
scans, as well.



Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out 
of it depends on what you put into it." - Tom 
Lehrer.

-Original 
Message-From: Sai 
Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 
08, 2003 2:54 
PMTo: Multiple recipients of list 
ORACLE-LSubject: 
FIRST_ROWS hints


hi



i had a migration from 9.2.0.3 to 
9.2.0.4 of a database and here are a couple of observations. please help me 
inunderstanding this.



i changed the db block size from 8k to 
16k and all sql queires which were using nested loops earlier moved to sort 
merge joins. i ran 10053 and form whatever i could understand the 9204 db 
has fewer number of blocks compared to the existing 9203 (db size changed to 
16k) and sort merge join turned out to be less costlier than nested loops (i 
couldntunderstand the sort statistics). no parameter other than 
db block size was changed.



after breaking my head i changed the 
optimizer mode from choose to first rows and the query is back to the old 
explain plans.



please clarify

1. whether this is a expected 
behaviour

2. what is first_rows hint and whether 
it is good move to go to first_rows to fix this 
problem.



thanks

sai

Re: intermedia text and dbms_job problem

[Sai Selvaganesan]

bill
this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i.
u have to call the procedure in the ur job and embed the sync index in ur procedure.
here is a snippet.u can try this way.

create or replace procedure i_doc_sync 
 is 
 begin 
 ctx_ddl.sync_index( idx_name = 'prb_title'); 
 end; 

declare 
 v_job number; 
 begin 
 dbms_job.submit( job=v_job, what='i_doc_sync;', next_date=sysdate, interval='sysdate+1/24'); 
 end; 

that should work
saiBill Tantzen [EMAIL PROTECTED] wrote:
OK, I know I must be doing something wrong, would somebody please pointout what it is? I would like to set up a job to sync an intermedia textindex. Here is my job:SQL select what from all_jobs where job = 2;WHAT-ctx_ddl.sync_index ( 'ctx_xml_text' );I can execute the procedute from the command line like so:SQL execute ctx_ddl.sync_index ( 'ctx_xml_text' );PL/SQL procedure successfully completed.But the job itself fails:SQL execute dbms_job.run ( 2 );BEGIN dbms_job.run ( 2 ); END;*ERROR at line 1:ORA-12011: execution of 1 jobs failedORA-06512: at "SYS.DBMS_IJOB", line 405ORA-06512: at "SYS.DBMS_JOB", line 267ORA-06512: at line 1in my init.ora I have:job_queue_processes = 4job_queue_interval = 60!
I am
 in the ctxapp role, and ctxsys has granted me execute on ctx_ddl.The only other job works just fine.OS=Solaris, Version=8.1.7What the heck is going on?Thanks in advance,BillBill Tantzen University of Minnesota Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 (cell)I guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora Joyce-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bill TantzenINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message!
 BODY,
 include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

RE: RE: Cary's Book - new topic

[Jamadagni, Rajendra]

Title: Message



God that you mentioned ... I am doing the same thing ... changing the 
code.

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: John Kanagaraj 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003 
  4:04 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: RE: Cary's Book - new topic
  Raj 
  (and all who use Oracle's Trace analyzer,
  
  I 
  'converted' the trace analzyer tables to GTTs, and no longer had the space 
  issues with large trace files. This is because the data is stored 
  'temporarily' and is used for reporting in a subsequent SQL in the same 
  session stream, and not reused elsewhere. Haven't really measured performance 
  improvement, but this should ride on all the advantages that GTT 
  provides.
  
  FWIW! 
  
  John KanagarajDB Soft IncPhone: 408-970-7002 
  (W)Disappointment is inevitable, but Discouragement is 
  optional!** The opinions and facts contained in this message are 
  entirely mine and do not reflect those of my employer or customers 
  **
  

-Original Message-From: Jamadagni, 
Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, 
October 08, 2003 7:19 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: RE: Cary's Book - new 
topic
Thanks, 
I have been using that tool for a long time now, it needs a 
big tablespace (cause everything is loaded in tables) and puts a load on the 
server. It is good for smaller files, but takes too long on larger 
files.
Nevertheless it is a great utility. Raj  
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly 
personal. QOTD: Any clod can have facts, having an 
opinion is an art ! 
-Original Message- From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 9:50 AM To: 
Multiple recipients of list ORACLE-L Subject: RE: 
RE: Cary's Book - new topic 
go to metalink and check out trace analyzer. ITs a new tool 
for analyzing 10046 traces. Has ALOT more detail than tkprof. Major 
improvement. Its on metalink. 
**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.**5

how to keep statistics up to date for CBO

[Bob Metelsky]

How does one keep CBO statistics for an applications base tables up to
date?

We are about to implement the CBO any must read documents.

Many 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: intermedia text and dbms_job problem

[Bill Tantzen]

Title: Message



Sai,

Thank 
you so very much! It worked perfectly!!!

Bill
Bill TantzenUniversity of Minnesota 
Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 
(cell)I 
guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora 
Joyce

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sai 
  SelvaganesanSent: Wednesday, October 08, 2003 3:19 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: intermedia text 
  and dbms_job problem
  bill
  this is a bug..infact it was happening in 8i 
  and oracle said they will try to fix in 9i.
  u have to call the procedure in the ur job and embed the sync index in ur 
  procedure.
  here is a snippet.u can try this way.
  
  create or 
  replace procedure i_doc_sync 
   is 
  
   begin 
  
   
  ctx_ddl.sync_index( idx_name = 'prb_title'); 
  
   end; 
  
  
  declare 
   v_job 
  number; 
   begin 
  
   
  dbms_job.submit( job=v_job, what='i_doc_sync;', 
  next_date=sysdate, interval='sysdate+1/24'); 
  
   end; 
  
  
  that should work
  sai

Re: auditing is my friend

[Paul Drake]

Pete,

I readyour paper before I turned auditing on (in the first place). I've spent many an evening reading papers posted on your site and on the sans.org site.

I haven't picked up your book in awhile, but I'm due to do so in updating our install docs for Oracle 9i on w2k3 svr. Has content been added online regarding implementing many of the recommendations provided in Oracle security step-by-step Guide? I remember seeing something like that mentioned some time ago, but I haven't followed up on it.
thanks,
Paul
Pete Finnigan [EMAIL PROTECTED] wrote:
Hi Paul,Have a look at the paper i wrote for security focus a few months ago,called "An Introduction to simple Oracle auditing" - there is a link toit on my site - http://www.petefinnigan.com/orasec.htm - its the secondpaper on there. It is not in-depth but concentrates on the benefits ofjust turning audit on and gives examples of SQL to find a few abuses,such as logins out of hours, users sharing accounts, attempts to useaccounts that do not exist etc - as i say just basic ideas. I agree itswell worth just turning audit on and seeing what can be learned fromjust audit session for instance!.Kind regardsPete-- Pete Finniganemail:[EMAIL PROTECTED]Web site: http://www.petefinnigan.com - Oracle security audit specialistsBook:Oracle security step-by-step Guide - see http://store.sans.org for details.--
 Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Pete FinniganINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

RE: How to copy recursive files in Windows? like UNIX cp -r

[Bob Metelsky]

For stubborn files, or if an error occurs during the copy, this uses the
/c switch 

FOR /d %a in (G:\some\location\*) do xcopy *.* /s /c
H:\someother\location

This essentially forces the xcopy through the source directory,
sometimes useful for copying off of cds where the data can be
temporarily unavailable due to windows interaction with the hardware

bob


-Original Message-
Sent: Wednesday, October 08, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L

xcopy

-Original Message-
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


Hi List:

How to copy recursive files in Windows? like unix cp
-r

Thanks in advance,
Sami


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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: Khedr, Waleed
  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: 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: how to keep statistics up to date for CBO

[David Wagoner]

Title: RE: how to keep statistics up to date for CBO





I like to use a cron job that runs the following in SQL Plus:


begin
dbms_stats.gather_schema_stats(ownname= 'YOUR_SCHEMA_NAME', options= 'GATHER AUTO');
end;


You should search the Oracle docs for your version of Oracle (you didn't specify version) to determine the best method for gathering statistics. You'll also see the different options there, like GATHER AUTO, which lets Oracle determine when it's time to compute new statistics for tables and indexes.

For 9iR2, the best method for CBO is dbms_stats, rather than analyze table compute statistics, according to the Oracle docs.



Best regards,


David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Web: http://www.arsenaldigital.com


the most trusted source for
 STORAGE MANAGEMENT SERVICES



The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. 

Thank you.



-Original Message-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 08, 2003 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: how to keep statistics up to date for CBO



How does one keep CBO statistics for an applications base tables up to
date?


We are about to implement the CBO any must read documents.


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

Help with a scripting problem

[Smith, Ron L.]

Title: Message



I am trying to issue the following command in SQL*PLUS but it 
doesn't like the space between 'program' and 
'files'.
Can 
anyone tell me how to get around this?

echo select 'host c:\program 
files\resource kit\robocopy;' from dual;


Thanks!
Ron 
Smith

where can I find sample db creation script (9.2.0.1.0 installation)?

[Guang Mei]

Hi:

I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I
let the installation to create a sample db. Now I am trying to see where I
can find the db creation script, so I can study it and use it to create db
instance manually. I can only find a bounch of log files in
$ORACLE_ADMIN/sid/create directory, such as

cloneDBCreation.log  lockAccount.log  postDBCreation.log
postScripts.log  ultraSearchCfg.log


So does anyone know where I can find the script? Thanks.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  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: A quick note

[Johnston, Tim]

So Lee...  As an experienced Oracle guy, what are your thoughts about DB2?

-Original Message-
Sent: Wednesday, October 08, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


I suggest you buy your mushrooms from the supermarket like the rest of us
instead of picking them in those strange fields my friend



-Original Message-
Sent: 08 October 2003 17:25
To: Multiple recipients of list ORACLE-L


Hey good to see you back again Lee.

The big change here is that all Oracle knowledge has been cyber-engineered
into an automoton called Tanel Poder.
Any query to the list is routed by a big fast connection into a huge server
with hundreds of CPU's and unlimited memory

An almost instantaneous reply is automatically generated , often complete
with complex examples and code cuts to demonstrate the point.
The best part is that is that the machine is programmed to exibit almost
humanistic type responses (occasionally) 

John


-Original Message-
Robertson Lee - lerobe
Sent: 08 October 2003 11:34
To: Multiple recipients of list ORACLE-L


Hi everyone,

I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)

Cheers

Lee






**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  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: Hallas, John, Tech Dev
  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: Robertson Lee - lerobe
  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: Johnston, Tim
  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: SAME and separating disk and index tablespaces

[Gaja Krishna Vaidyanatha]

Hi Hans/Vikas,

I tend to agree that the old draconian rule that thou
shalt always separate indexes from tables may not
apply any more. We used to apply that principle in the
past when the number of available spindles was not
adequate. Seems like with 256G drives in the market,
we are being pushed back in time, in some way!!!

The way I look at the problem is purely from an IOPS
perspective. For example, if each physical disk is
capable of 256 IOPS (ignore the cache configured here)
and you have 10 disks in your volume, then the total
I/O capacity on this volume is 2560 IOPS. Separation
of objects across multiple volumes may becomes an
issue, only when the demand for I/O outstrips the
supply (in this case 2560 IOPS).

Even then, you can always add more drives to the
existing volume and restripe, i.e., adding 5 more
drives to 10 drives increases the I/O capacity by 50%.
At the end of the day, the I/O sub-system does not
care, whether it is servicing a data segment, index
segment or undo segment. 

But, in certain environments, that I have dealt with,
there has been a need to separate heavily and
concurrently accessed objects (does not matter whether
these objects are all indexes or tables or both). This
may be true only for certain objects and certain
queries. So, please don't apply this in a blanket
fashion. 

Empirical data is always the best justification
mechnism for a configuration exercise such as this.
Plus, you may have partitioning and other requirements
such as parallelism that impact the placement and
availability of your data. This in turn will control
the number of logical volumes that need to be created.

I think the idea and philosophy behind SAME is noble -
Use all available drives, so that you do not have
localized hot-spots. But the implementation of SAME
and how many volumes you need in your enviroment, is a
function of your custom needs based on your system and
application demands. When you over-simplify something,
you lose the flexibility. The art factor here (which
requires some planning) is in achieving a balance
between simplicity, flexibility, performance,
manageability and availability.


Hope that helps,


Gaja
--- Hans de Git [EMAIL PROTECTED] wrote:
 Vikas,
 
 Spend an hour on reading this usenet thread:
 

http://groups.google.nl/groups?hl=nllr=ie=UTF-8oe=UTF-8threadm=brjz8.15%24707.245%40news.oracle.comrnum=1prev=/groups%3Fhl%3Dnl%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3Drogers%2Bseparate%2Bdata%2Bindex
 
 It will open your eyes about separating data/index.
 
 Still not sure about the redolog stream...Because of
 the sequential nature 
 of redologfiles. I've read  tests that 'prove' it
 doesn't matter much 
 whether you separate your redolog from 'ordinary'
 datafiles or not. It does 
 simplify things when you pure SAME.
 
 Regards,
 Hans
 
 
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Date: Wed, 08 Oct 2003 09:54:30 -0800
 
 Thanks Gaja !  Does it also make sense from a
 performance perspective
 (I/O issues due to concurrent access of index and
 data ) to separate
 them or is that point moot once you apply the SAME
 methodology ?
 
 -Original Message-
 Gaja Krishna Vaidyanatha
 Sent: Wednesday, October 08, 2003 9:24 AM
 To: Multiple recipients of list ORACLE-L
 
 Vikas,
 
 The answer is an enthusiastic yes. This is purely
 from
 an administrative and manageability standpoint. For
 example, if you have INDEX and DATA segments
 separated
 in 2 different tablespaces, the backup of these
 tablespaces can be done INDEPENDENTLY. This is
 relevant, as if you were to rebuild your indexes
 using
 the NOLOGGING option between 2 backup jobs. If that
 were the case, then all you will need to do after
 the
 rebuild is complete, is to backup only the INDX
 tablespace.
 
 This is a best practice (if not a requirement) in
 most
 production shops, unless you think you can
 re-re-build
 your indexes in the event of media failure and you
 lose your INDX tablespace.
 
 
 Hope that helps,
 
 
 Gaja
 --- vikas kawatra [EMAIL PROTECTED] wrote:
   Guys,
  
   Does it make sense to separate data and index
   segments into separate
   tablespaces if you create a single logical volume
   and all files are
   striped using the SAME methodology ?
  
   Thanks
  
   vikas
  
  
   --
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.net
   --
   Author: vikas kawatra
 INET: [EMAIL PROTECTED]
  
 
 
 =
 Gaja Krishna Vaidyanatha
 Principal Technical Product Manager,
 Application Performance Management, Veritas
 Corporation
 E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
 Website: http://www.veritas.com
 
 __
 Do you Yahoo!?
 The New Yahoo! Shopping - with improved product
 search
 http://shopping.yahoo.com
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 --
 Author: Gaja Krishna Vaidyanatha
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 

Re: Help with a scripting problem

[Ron Rogers]

Ron,
 It works as you requested on 8.1.7.4.
Ron mª¿ªm

 [EMAIL PROTECTED] 10/08/03 05:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.  
Can anyone tell me how to get around this?
   
 echo select 'host c:\program files\resource kit\robocopy;' from dual;

 
 
Thanks!
Ron Smith 
-- 
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: Help with a scripting problem

[Stephen Andert]

Ron,

First of all, is echo a SQL*Plis command?

Secondly, I think this will do what you want:

select 'host c:\program files\resource kit\robocopy' from dual;

as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.

If you want to do something else, clarify your intentions on the list.

Stephen 

 [EMAIL PROTECTED] 10/08/03 04:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.  
Can anyone tell me how to get around this?
   
 echo select 'host c:\program files\resource kit\robocopy;' from dual;

 
 
Thanks!
Ron Smith 

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

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

RE: Help with a scripting problem

[Smith, Ron L.]

Sorry, this is what I am trying to run.  But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.

set heading off;
set feedback off;   
set linesize 1000;  
spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql; 
select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual; 
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system archive log stop;' from dual;  
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual; 
select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual;
select 'alter system archive log start;' from dual; 
select 'exit;' from dual;   
spool off;  
exit;   

Thanks!
Ron

-Original Message-
Sent: Wednesday, October 08, 2003 3:57 PM
To: [EMAIL PROTECTED]; Smith, Ron L.


Ron,

First of all, is echo a SQL*Plis command?

Secondly, I think this will do what you want:

select 'host c:\program files\resource kit\robocopy' from dual;

as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.

If you want to do something else, clarify your intentions on the list.

Stephen 

 [EMAIL PROTECTED] 10/08/03 04:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.  
Can anyone tell me how to get around this?
   
 echo select 'host c:\program files\resource kit\robocopy;' from dual;

 
 
Thanks!
Ron Smith 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  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: SAME and separating disk and index tablespaces

[Cary Millsap]

I completely agree with Howard about one thing: indexes and data don't
necessarily compete against each other for I/O capacity.

So the following is *not* true: You should separate indexes and data
into different tablespaces because they compete so strenuously for I/O
capacity.

However, the following *is* true: You should separate indexes and data
into different tablespaces because there are several legitimate reasons
to do so.

http://www.hotsos.com/dnloads/0.Millsap1995.09.24-OFA.pdf for more
information.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Hans de Git
Sent: Wednesday, October 08, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L

Vikas,

Spend an hour on reading this usenet thread:

http://groups.google.nl/groups?hl=nllr=ie=UTF-8oe=UTF-8threadm=brjz8
.15%24707.245%40news.oracle.comrnum=1prev=/groups%3Fhl%3Dnl%26lr%3D%26
ie%3DUTF-8%26oe%3DUTF-8%26q%3Drogers%2Bseparate%2Bdata%2Bindex

It will open your eyes about separating data/index.

Still not sure about the redolog stream...Because of the sequential
nature 
of redologfiles. I've read  tests that 'prove' it doesn't matter much 
whether you separate your redolog from 'ordinary' datafiles or not. It
does 
simplify things when you pure SAME.

Regards,
Hans


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 08 Oct 2003 09:54:30 -0800

Thanks Gaja !  Does it also make sense from a performance perspective
(I/O issues due to concurrent access of index and data ) to separate
them or is that point moot once you apply the SAME methodology ?

-Original Message-
Gaja Krishna Vaidyanatha
Sent: Wednesday, October 08, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L

Vikas,

The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to rebuild your indexes using
the NOLOGGING option between 2 backup jobs. If that
were the case, then all you will need to do after the
rebuild is complete, is to backup only the INDX
tablespace.

This is a best practice (if not a requirement) in most
production shops, unless you think you can re-re-build
your indexes in the event of media failure and you
lose your INDX tablespace.


Hope that helps,


Gaja
--- vikas kawatra [EMAIL PROTECTED] wrote:
  Guys,
 
  Does it make sense to separate data and index
  segments into separate
  tablespaces if you create a single logical volume
  and all files are
  striped using the SAME methodology ?
 
  Thanks
 
  vikas
 
 
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.net
  --
  Author: vikas kawatra
INET: [EMAIL PROTECTED]
 


=
Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
   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: vikas kawatra
   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).

_
Chatten met je online vrienden via MSN Messenger.
http://messenger.msn.nl/

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San 

Re: Help with a scripting problem

[Mladen Gogala]

What is echo supposed to do? The proper command
should read like this:
select 'host /program\ files/resource\ kit/robocopy' from dual;
On Wed, 2003-10-08 at 17:34, Smith, Ron L. wrote:
  I am trying to issue the following command in SQL*PLUS but it doesn't
 like the space between 'program' and 'files'.  
 Can anyone tell me how to get around this?

  echo select 'host c:\program files\resource kit\robocopy;' from
 dual; 
  
  
 Thanks!
 Ron Smith 
-- 
Mladen Gogala
Oracle DBA




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

OT - Microsoft Security Bulletin MS03-040 (828750)

[Rajesh . Rao]

Microsoft issued this critical update on the 3rd, which I found out about,
when I did a Windows Update from my IE.



 A number of security issues have been identified in Microsoft® Internet
 Explorer that could allow an attacker to compromise a Microsoft
 Windows®-based system and then take a variety of actions. For example, an  
 attacker could run programs on your computer when you are viewing a Web
 page. This vulnerability affects all computers that have Internet Explorer 
 installed. (You do not have to be using Internet Explorer as your Web  
 browser to be affected by this issue.) You should help protect your
 computer by installing this update from Microsoft. 





And now, after applying this patch, I am no longer able to run Windows
Update. Doesn't windows update run programs on my computer when I am
viewing the web page?  I wonder if they locked themselves out ;-) , or is
the site down? I wish to know if I am the only one experiencing this.

Regards
Raj

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

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

RE: Help with a scripting problem

[Igor Neyman]

Try using double quotes:

select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L

Sorry, this is what I am trying to run.  But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.

set heading off;
set feedback off;   
set linesize 1000;  
spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql; 
select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual; 
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system archive log stop;' from dual;  
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual; 
select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual;
select 'alter system archive log start;' from dual; 
select 'exit;' from dual;   
spool off;  
exit;   

Thanks!
Ron

-Original Message-
Sent: Wednesday, October 08, 2003 3:57 PM
To: [EMAIL PROTECTED]; Smith, Ron L.


Ron,

First of all, is echo a SQL*Plis command?

Secondly, I think this will do what you want:

select 'host c:\program files\resource kit\robocopy' from dual;

as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.

If you want to do something else, clarify your intentions on the list.

Stephen 

 [EMAIL PROTECTED] 10/08/03 04:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.  
Can anyone tell me how to get around this?
   
 echo select 'host c:\program files\resource kit\robocopy;' from dual;

 
 
Thanks!
Ron Smith 

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

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


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

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

RE: where can I find sample db creation script (9.2.0.1.0 installation)?

[Bob Metelsky]

%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
calls several others

bob

-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?

Hi:

I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time.
I
let the installation to create a sample db. Now I am trying to see where
I
can find the db creation script, so I can study it and use it to create
db
instance manually. I can only find a bounch of log files in
$ORACLE_ADMIN/sid/create directory, such as

cloneDBCreation.log  lockAccount.log  postDBCreation.log
postScripts.log  ultraSearchCfg.log


So does anyone know where I can find the script? Thanks.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  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: 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: Help with a scripting problem

[Smith, Ron L.]

Never mind.  The error was related to another problem with the script.

Thanks!
Ron

-Original Message-
Sent: Wednesday, October 08, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L


Try using double quotes:

select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L

Sorry, this is what I am trying to run.  But again, it barfs on the
'program files' portion of the script. I have tried with and without
quotes.

set heading off;
set feedback off;   
set linesize 1000;  
spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql; 
select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual; 
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system archive log stop;' from dual;  
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual; 
select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual;
select 'alter system archive log start;' from dual; 
select 'exit;' from dual;   
spool off;  
exit;   

Thanks!
Ron

-Original Message-
Sent: Wednesday, October 08, 2003 3:57 PM
To: [EMAIL PROTECTED]; Smith, Ron L.


Ron,

First of all, is echo a SQL*Plis command?

Secondly, I think this will do what you want:

select 'host c:\program files\resource kit\robocopy' from dual;

as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.

If you want to do something else, clarify your intentions on the list.

Stephen 

 [EMAIL PROTECTED] 10/08/03 04:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.  
Can anyone tell me how to get around this?
   
 echo select 'host c:\program files\resource kit\robocopy;' from dual;

 
 
Thanks!
Ron Smith 

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

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


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

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

[Whittle Jerome Contr NCI]

Title: RE: OT - Microsoft Security Bulletin MS03-040 (828750)






Can you get to the Windows Update web page? If so does it freeze at 0% or 33%? If so there are some fixes available. If you can get to the web page, there's a button towards the bottom left for help with Windows Update. Check in there as Windows Update seems to need a LOT of help.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]

Microsoft issued this critical update on the 3rd, which I found out about,

when I did a Windows Update from my IE.

 

A number of security issues have been identified in Microsoft® Internet 

Explorer that could allow an attacker to compromise a Microsoft 

Windows®-based system and then take a variety of actions. For example, an 

attacker could run programs on your computer when you are viewing a Web 

page. This vulnerability affects all computers that have Internet Explorer 

installed. (You do not have to be using Internet Explorer as your Web 

browser to be affected by this issue.) You should help protect your 

computer by installing this update from Microsoft. 

 

And now, after applying this patch, I am no longer able to run Windows

Update. Doesn't windows update run programs on my computer when I am

viewing the web page? I wonder if they locked themselves out ;-) , or is

the site down? I wish to know if I am the only one experiencing this.

Regards

Raj

RE: Help with a scripting problem

[Gary W. Parker]

Two options:

1.  Change  \program files\  to \program~1\

   That should execute with no problems.

2.  Another tact:

select 'host '||chr(34)||'c:\program files\resource kit\robocopy'||chr(34)||
   ' f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;

   This will enclose the string in double quotes ( chr(34) ) which should allow
execution

HTH

GWP

-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L


Sorry, this is what I am trying to run.  But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.

set heading off;
set feedback off;
set linesize 1000;
spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql;
select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system switch logfile;' from dual;
select 'alter system archive log stop;' from dual;
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual;
select 'alter system archive log start;' from dual;
select 'exit;' from dual;
spool off;
exit;

Thanks!
Ron

-Original Message-
Sent: Wednesday, October 08, 2003 3:57 PM
To: [EMAIL PROTECTED]; Smith, Ron L.


Ron,

First of all, is echo a SQL*Plis command?

Secondly, I think this will do what you want:

select 'host c:\program files\resource kit\robocopy' from dual;

as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.

If you want to do something else, clarify your intentions on the list.

Stephen

 [EMAIL PROTECTED] 10/08/03 04:34PM 
 I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me how to get around this?

 echo select 'host c:\program files\resource kit\robocopy;' from dual;



Thanks!
Ron Smith

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
  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: Gary W. Parker
  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).

Update Japanese character without Exp/IMp and DB Link

[Oracle DBA]

Hi List:

I have 
Database DB1
Table name T1
Column Name C1

C1 has some japanese character


Database DB2
Table name T2
Column Name C2

I want to update C2 column(only one record) with C1
column value.

Note:-
Exp/Imp  AND db_link is not possible
===


Any help would be really appreciated.

Thanks
Sami
 



__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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).