date:20030224


You really should be looking at locally
managed tablespaces with uniform extent
size (see www.dbazine.com for one article
on this, www.oracledba.co.uk for another).

Even if you want to avoid LMTs, then you
should be looking at aiming for uniform
extent sizing by mechanical methods.
(initial = next = minimum extent).

You problem comes from the fact that when
you create an index using parallel slaves,
each slave creates its own section of the
index using the base initial/next, and when
all slaves have completed, the co-ordinator
creates a root block linking them together.

To minimise space wastage, just work on the
fact that each slave will, on average, leave
half an extent of space unused.

In your case, I would probably consider 16M or 32M
as the unit size - 16M is the index was only going
to grow slowly after the rebuild, 32M if it was likely
to grow at a rate that would result in extra extents
appearing more than once per month. (16 and 32 because
they are powers to 2, and in your case lead to 40 to 80
extents)

Smaller extents give you less wastage, larger extents give
you slower subsequent growth rates and a lower granularity
of monitoring.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: 24 February 2003 00:23


 OpenVMS 7.1-2
 Oracle 8.1.7.4
 db_block_size 4096

 I need to re-create a large table and its associated
 indexes as fast as possible, and with a limited amt of
 disk space.  I have a new tblspace at 7000m for index
 creation.

 I'm creating indexes with DOP4.  (I really need the
 speed I get with parallel to create the indexes.) In
 my testing, I keep running out of contiguous space in
 my index tablespace -- it gets fragmented
 all-to-blazes.  I end up with each index at 4 extents.

 I have a pretty good estimate of how large the indexes
 will be.  Is there some sane way to compute a
 reasonable initial and next extent when using
 parallel?

 As an example, I created an index (wodh_pk) with
 initial 600m next 20m pctincrease 0.  The index is now
 1334m with 4 extents.  If I know the index should be
 about 1300 megs, what's a good initial and next size?

 Thanks for any assistance!
 Barb


 SELECT SEGMENT_NAME, BYTES/1024/1024 M, EXTENTS,
 NEXT_EXTENT,
   PCT_INCREASE FROM DBA_SEGMENTS
   WHERE TABLESPACE_NAME='ARCHIDX';

 Segment Next Pct
 Name  M Extents  Extent   Increase

  -- ---  
 WODH_PK  1333.55859   4   20,971,5200
 WODH_FK1 821.289063   4   20,971,5200

 here's the code . . .

 create unique INDEX
  REPORT_REP.WODH_PK
  ON
 REPORT_REP.WORK_ORDER_DETAILS_NOHIST(WORK_ORDER_KEY)
  TABLESPACE ARCHIDX
 STORAGE(INITIAL 600M
 NEXT 20M
 MINEXTENTS 1
 MAXEXTENTS 249)
 PARALLEL (DEGREE 4)
 ;



 __
 Do you Yahoo!?
 Yahoo! Tax Center - forms, calculators, tips, more
 http://taxes.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Barbara Baker
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
services
 
-
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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

RE: Oracle Names Server 8.1.7 on HP 11

2003-02-24 Thread Zabair Ahmed

Hello Stephen,
sorry for the delay in reply, the names respository is located on a different server as compared to the names server. I would be interested in the white paper, it be great if you could send it over.
Thanks
Zabair
"Karniotis, Stephen" [EMAIL PROTECTED] wrote:

Zabair:

Interesting problem. Where is the names server repository located?

We have implemented the Dynamic Discovery Option of the Oracle Names Server. Additionally, we implemented multiple names servers and used the internal replication facility to keep them in sync. I will send you a white paper on how to configure this if you want. I believe it has already been posted by Jared (am I correct Jared) on the orafaq.net web site. Let me know.

Thank You

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

-Original Message-From: Zabair Ahmed [mailto:[EMAIL PROTECTED]Sent: Thursday, February 20, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Names Server 8.1.7 on HP 11

We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message.
TNS-03505 - Failed to resolve name
This implies that our client PC is unable to resolve the name and hence was not able to connect to the database. Usually this implies that something is wrong with all our Oracle Names servers.
Inorder to resolve this problem, I had to kill the Names Server on each of the 4 boxes and restart it.
The Names servers had somehow lost connection to the Oracle Names repository database, although the servers appear to be attached to the database.
I reckon we canreduce the chances of this problem occuring again, by adding a second Oracle Names database repository in our database cluster. This means, that if the NAMES servers lose connection to one repository, they can fall back on the second database without any loss of service.
What have other people done with their Names Server and respository and do they see any draw backs with the above.
Sorry for the long email.
TIA

With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs

Re: Error pinning PKS in shared pool


... oops
and then you might want to add that you really
have to mess around with quote marks and
begin/ends to get it to work - something like (and 
I really ought to  test this before posting, 'cos it's 
one of those tiny details that there's no point in 
wasting valuable memorisation time on)

begin
execute immediate  -- no shortened form allowed
'begin   sys.dbms_shared_pool.keep(''DBMS_ALERT'') ; end;'
;
end;

Note - double up the quotes around the quoted package name,
add in the 'begin end' to make the thing you want to execute
an anonymous pl/sql block, make sure that there is a semi-colon
(which would be incorrect for a pure SQL example) at the end of the 
thing you are executing.


(I totally agree with your comments though -
sys packages have been known to become 
mysteriously invalid from time to time).


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: 24 February 2003 05:23


 ...oops, and I forgot to add that you might wanna wrap
 the call to 'dbms_shared_pool' in pin_me within exec
 immed, so that if the package ever goes invalid (or
 does not exist - ie forgotten to be run) the trigger
 will still run ok.
 
 cheers
 connor
 


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

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

RE: installation / recovery question

2003-02-24 Thread Sinardy Xing

Hi,

***Suggestions***

I think your consent is more toward OS backup,

From the DB point of view (assume your databases are created and populated)
- Do cold backup (Oracle redundancy set + all parameter files (db and network) + 
password file + user docs + scripts + 
  everything)
- backup the export dump file (compress = n full=y) 

then reinstall Oracle binary files, this is quite fast, right?



Sinardy

-Original Message-
Sent: 24 February 2003 16:39
To: Multiple recipients of list ORACLE-L


Hi all,
I have a test installation of Oracle 817 and 902 on my PC - installed
completly on a device other than system device.
Now my computer is getting  buggy (well it's Win2k on it) so the sysadmin
want's to reinstall the system device.
Is there any way to save the registry entries for Oracle and recover them
when the new installtion on system device is done?
Can I export the entries in a .reg file and merge that into my new registry
when sysadmin is done? Or do I have to reinstall Oracle software and how to
I preserve my databases? 
Any suggestions/hints/warnings are welcome.

Regards,
Antje Sackwitz


  Antje Sackwitz
  ppi Media GmbH
  Deliusstraße 10
  D-24114 Kiel
  phone +49 (0) 43 1-53 53-2 16
  fax   +49 (0) 43 1-53 53-2 22
  email mailto:[EMAIL PROTECTED]
  web   www.ppi.de




-- 
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: 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: installation / recovery question

2003-02-24 Thread Abdul Aleem

I don't know about entries for a particular product. You can explore regedit
and regedit32 utilities provided with windows.
Aleem

 -Original Message-
Sent:   Monday, February 24, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject:installation / recovery question

Hi all,
I have a test installation of Oracle 817 and 902 on my PC - installed
completly on a device other than system device.
Now my computer is getting  buggy (well it's Win2k on it) so the sysadmin
want's to reinstall the system device.
Is there any way to save the registry entries for Oracle and recover them
when the new installtion on system device is done?
Can I export the entries in a .reg file and merge that into my new registry
when sysadmin is done? Or do I have to reinstall Oracle software and how to
I preserve my databases? 
Any suggestions/hints/warnings are welcome.

Regards,
Antje Sackwitz

  Antje Sackwitz
  ppi Media GmbH
  Deliusstraße 10
  D-24114 Kiel
  phone +49 (0) 43 1-53 53-2 16
  fax   +49 (0) 43 1-53 53-2 22
  email mailto:[EMAIL PROTECTED]
  web   www.ppi.de

-- 
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: Abdul Aleem
  INET: [EMAIL PROTECTED]

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

RE: Which is beter a cursor or a for loop?

2003-02-24 Thread Thomas, Kevin

I would suggest that the cursor is the best way to go.
-Original Message-
Sent: 24 February 2003 08:39
To: Multiple recipients of list ORACLE-L



Hello, 

I was just asked by one of our developers which is beter to use:- 
a cursor or a for loop? 
I must admit I am not sure 

Anyway the specific piece of code in discussion is similar to the
following 
   
FOR X IN (SELECT X FROM TABLE_NAME 
WHERE COL1 = 'Something')) 
LOOP 
Do a whole lot of stuff in database here.. 
LOOP END; 

I would guess that the cursor would follow similar execution criteria but
using 
the cursor syntax. 

Any ideas? 

TIA 
regards 
Denham Eva 
Oracle DBA 
The real problem is not whether machines think but whether men do. 
- B. F. Skinner 


  _  

DISCLAIMER 

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. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage 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 views of any such entity. 

  _  


  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com 
  _  

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

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

Lost Mail



Apologies to anyone out there that is hoping
for a reply to a question that they may have 
sent directly.

I upgraded to IE 5 over the weekend.

The upgrade process was thorough, firing
on all cylinders, and has destroyed half
my email database, and duplicated the
other half (so on average no change ;).

If you don't hear from me - it probably 
means you were in the unlucky half.

Unfortunately I've decided that I want
to treat this incident as a drastic, yet 
necessary, though overzealous piece of 
house-keeping, so I'm not going to try to 
recover the database.


BTW - if you have sent me mail about the
seminars in Texas, or the Tutorial in Orlando,
those were two of the files that got duplicated,
so I still know about you.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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



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

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

RE: Which is beter a cursor or a for loop?

2003-02-24 Thread Stephane Faroult

Hello,

I was just asked by one of our developers which is
beter to use:-
a cursor or a for loop?
I must admit I am not sure

Anyway the specific piece of code in discussion is
similar to the
following
   
FOR X IN (SELECT X FROM TABLE_NAME
WHERE COL1 = 'Something'))
LOOP
Do a whole lot of stuff in database
here..
LOOP END;

I would guess that the cursor would follow similar
execution criteria but
using 
the cursor syntax.

Any ideas?

TIA
regards
Denham Eva
Oracle DBA
The real problem is not whether machines think but
whether men do.
- B. F. Skinner

Down with loops.

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: newbie sqlplus ?

2003-02-24 Thread Daniel Wisser

hi!

in your profile set $ORACLE_HOME to your oracle directory and
put $ORACLE_HOME/bin in your path

daniel

Les Ayudo wrote:
 
 I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued
 the command sqlplus and I rec'd a command not found error.  Is there
 something I forgt to do before the install?  Let me kow if u need more info.
 THanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: installation / recovery question

2003-02-24 Thread Naveen Nahata

Run REGEDIT, then go to HKEY_LOCAL_MACHINE\SOFTWARE, click oracle and then
from the file menu choose export. it will save the Oracle key to a .reg file.

Then you can go to HKEY_LOCAL_MACHINE\SYSTEM\CUrrent Control Set\Services and
do the same for all the services which start with Oracle.

After the new installation, double click on all the .reg files and restart
the comp.

That should work for you. There might be some environment variables related
issues for which you can also copy HKEY_CURRENT_USER\Envioronment or set the
environment manually.

Regards
Naveen



-Original Message-
Sent: Monday, February 24, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L


Hi all,
I have a test installation of Oracle 817 and 902 on my PC - installed
completly on a device other than system device.
Now my computer is getting  buggy (well it's Win2k on it) so the sysadmin
want's to reinstall the system device.
Is there any way to save the registry entries for Oracle and recover them
when the new installtion on system device is done?
Can I export the entries in a .reg file and merge that into my new registry
when sysadmin is done? Or do I have to reinstall Oracle software and how to
I preserve my databases? 
Any suggestions/hints/warnings are welcome.

Regards,
Antje Sackwitz


  Antje Sackwitz
  ppi Media GmbH
  Deliusstraße 10
  D-24114 Kiel
  phone +49 (0) 43 1-53 53-2 16
  fax   +49 (0) 43 1-53 53-2 22
  email mailto:[EMAIL PROTECTED]
  web   www.ppi.de




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



DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. 
Before opening attachments please check them for viruses and defects. MindTree 
Consulting Private Limited (MindTree) will not be responsible for any viruses or 
defects or any forwarded attachments emanating either from within MindTree or outside. 
If you have received this message by mistake please notify the sender by return  
e-mail and delete this message from your system. Any unauthorized use or dissemination 
of this message in whole or in part is strictly prohibited.  Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, untimely 
or incomplete transmission.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

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

RE: Which is beter a cursor or a for loop?

2003-02-24 Thread Lord, David - CSG

--_=_NextPart_001_01C2DBF5.0AC6B3E0
Content-Type: text/plain; charset=iso-8859-1

Denham
 
The for loop is a lot easier to read.  It can be a real pain scrolling to
the top every time you want to see what such-and-such a cursor is doing.  On
the other hand, it can be a bit limiting in more 'advanced' situations - eg.
you can't mess around with cursor%rowtype variables and you can't fetch from
the cursor in more than one place.
 
Regards
David Lord

-Original Message-
Sent: 24 February 2003 08:39
To: Multiple recipients of list ORACLE-L



Hello, 

I was just asked by one of our developers which is beter to use:- 
a cursor or a for loop? 
I must admit I am not sure 

Anyway the specific piece of code in discussion is similar to the
following 
   
FOR X IN (SELECT X FROM TABLE_NAME 
WHERE COL1 = 'Something')) 
LOOP 
Do a whole lot of stuff in database here.. 
LOOP END; 

I would guess that the cursor would follow similar execution criteria but
using 
the cursor syntax. 

Any ideas? 

TIA 
regards 
Denham Eva 
Oracle DBA 
The real problem is not whether machines think but whether men do. 
- B. F. Skinner 



  _  

DISCLAIMER 



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. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage 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 views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com 
  _  




**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**


--_=_NextPart_001_01C2DBF5.0AC6B3E0
Content-Type: text/html; charset=iso-8859-1

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1
TITLEWhich is beter a cursor or a for loop?/TITLE

META content=MSHTML 6.00.2716.2200 name=GENERATOR/HEAD
BODY
DIVSPAN class=741430311-24022003FONT face=Courier New 
size=2Denham/FONT/SPAN/DIV
DIVSPAN class=741430311-24022003FONT face=Courier New 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=741430311-24022003FONT face=Courier New size=2The for loop 
is a lot easier to read.nbsp; It can be a real pain scrolling to the top every 
time you want to see what such-and-such a cursor is doing.nbsp; On the other 
hand, it can be a bit limiting in more 'advanced' situations - eg. you can't 
mess around with cursor%rowtype variables and you can't fetch from the cursor in 
more than one place./FONT/SPAN/DIV
DIVSPAN class=741430311-24022003FONT face=Courier New 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=741430311-24022003FONT face=Courier New 
size=2Regards/FONT/SPAN/DIV
DIVSPAN class=741430311-24022003FONT face=Courier New size=2David 
Lord/FONT/SPAN/DIV
BLOCKQUOTE 
style=PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid
  DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma 
  size=2-Original Message-BRBFrom:/B Denham Eva 
  [mailto:[EMAIL PROTECTED]BRBSent:/B 24 February 2003 08:39BRBTo:/B 
  Multiple recipients of list ORACLE-LBRBSubject:/B Which is beter a 
  cursor or a for loop?BRBR/FONT/DIV
  PFONT face=Arial size=2Hello,/FONT /P
  PFONT face=Arial size=2I was just asked by one of our developers which is 
  beter to use:-/FONT BRFONT face=Arial size=2a cursor or a for 
  loop?/FONT BRFONT face=Arial size=2I must admit I am not sure/FONT 
  /P

RE: Which is beter a cursor or a for loop?

2003-02-24 Thread Grant Allen

 -Original Message-
 Sent: 24 February 2003 08:39
 To: Multiple recipients of list ORACLE-L



 Hello,

 I was just asked by one of our developers which is beter to use:-
 a cursor or a for loop?
 I must admit I am not sure

humour on

That's like asking I have a Porsche.  What's the fastest way to make it
move ... to push it, or pull it?

The answer would have to be neither ... drive the thing the way it's been
engineered to perform.

humour off

If your developers don't understand the power of set-based logic in RDBMS,
then now's the time to teach them.

(Yeah, OK, depending on the complexity of the 'do lots of database stuff',
you might need to resort to cursors or loops.  But these shouldn't be the
first option!)

Just my 2¢

Ciao
Fuzzy
:-)

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

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

File Table Overflow on Oracle DB Server

2003-02-24 Thread VIVEK_SHARMA


 We have the following query reg. an error on HP-UX ORacle DB server.
 
 We are encountering HPUX Error: 23: File table overflow' on the
 Oracle database server while executing stress tests for our
 application. We are not opening any files on the database server
 through the application still this error keeps coming after running
 the test for some duration.
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

Re: Which is beter a cursor or a for loop?

2003-02-24 Thread Bjørn Engsig





It's purely syntactical sugar unless you use the BULK features of the explicit
cursor, in which case, you may gain some performance.

/Bjrn.

Denham Eva wrote:
   
  
 
  
  Which is beter a cursor or a for loop?

  Hello, 
  
  I was just asked by one of our developers
which is beter to use:- 
  a cursor or a for loop? 
  I must admit I am not sure 
  
  Anyway the specific piece of code in discussion
is similar to the following 

 FOR X IN (SELECT X FROM TABLE_NAME 
  
   WHERE COL1 = 'Something')) 
  
   LOOP 
   Do a whole lot of stuff in
database here.. 
   LOOP END; 
  
  I would guess that the cursor would follow
similar execution criteria but using  
  the cursor syntax. 
  
  Any ideas? 
  
  TIA 
  regards 
  Denham Eva 
  Oracle DBA 
  The real problem is not
whether machines think but whether men do. 
  - B. F. Skinner 
  

   
   DISCLAIMER
  
  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.
TFMC, its holding company, and any of its subsidiaries each reserve  the
right to monitor and manage 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 views of any such entity.
  
 
   This e-mail message has been scanned for Viruses and Content and cleared
by  MailMarshal -  For more
information please visit www.marshalsoftware.com
  
   

-- 
 Bjrn Engsig, Miracle A/S 
 Member of Oak Table Network 
 [EMAIL PROTECTED] - http://MiracleAS.dk

Re: File Table Overflow on Oracle DB Server

2003-02-24 Thread K Gopalakrishnan

Vivek:

I remember you getting the same problem some time back. I guess you
need to increase the nfiles kernel paramter (it defaults to
maxuser*constant or something similar to that)

Just bump the max users or change the nfile parameter.

KG



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

Re: Alert Log reporting question

Sinardy,

I've posted a shell script called chk_oerr.sh on
http://www.EvDBT.com/tools.htm;.  It doesn't do exactly what you ask, but it
remembers where it left off scanning in the alert.log file.  You can run
it hourly, daily, or weekly if you like, and the timing of the emails it
sends you should provide some sense of the timing of the errors...

Hope this helps...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:33 AM


 Hi all,

 I am writing a script that can grep ORA- from alert log.

 I think it will be good if I can grep the time of the error occur, can you
please help me?

 If you are lazy to type please introduce me any related unix function, I
will do man the function myself.


 Thanks

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


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Testing database links

2003-02-24 Thread Charu Joshi

I think I spoke too soon.

The v$dblink view shows the db_links opened by the current session only.

I want to be able to find out the db_links opened by all current sessions
and the sids for the sessions. This way I can monitor all the application
instances that opened the db_link and those that didn't close it.

Thanks  regards,
Charu.

-Original Message-
Sent: Friday, February 21, 2003 5:19 PM
To: '[EMAIL PROTECTED]'

Darn!!

I had taken a hasty look at 'Oracle 8i reference', before posting the query.
Not my day today.

Thanks Allan.

Regards,

Charu

-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L

V$dblink

-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L

Dear Listers,

Oracle 8i HP-UX11.

We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
'dbms_session.close_database_link' procedure (that is what they
claim!!).

We want to track the call to the database link and the subsequent
closure. We don't have any access to the remote system to check the
remote session being created and closed.

Is there any way (dynamic performance view etc.) which would show the
database link being in use and closed again on the local database
itself?

Thanks  regards,
Charu

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

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


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

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

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

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

2003-02-24 Thread dist cash

I don't agree with don't #1 and #5.

From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800

Here is the list of top 10 do's and don't that I
came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect
Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG
Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other
Resources
#9 - Do Establish Standards and Change Control
Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not
Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For
Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.

Bonus!! - Do Not Assume A Good or Bad Hit Ratio
Means Anything

Ok, anyone wanna comment?

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

Robert,

  DO #3 and DON'T #7 are developer stuff, not DBA stuff ...
I would gladly replace DO #3 by 'Relentlessly preach good practice to 
developers'. I can hardly talk to a developer without mentioning 
DBMA_APPLICATION_INFO in the first 30 seconds :-).

Regards,

Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dist cash
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Error pinning PKS in shared pool

2003-02-24 Thread Ramon E. Estevez

Thanks Suzy, Waleed, John, Richard, Connor, Jonathan, for your help.

Out of shape on sundays :-)

TKS



-Original Message-
Vordos
Sent: Sunday, February 23, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L



Don't think you need to use execute immediate.  Try this (should be run
as SYS):

CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA
AFTER STARTUP ON DATABASE
  BEGIN
 dbms_shared_pool.keep('DBMS_ALERT');
 dbms_shared_pool.keep('DBMS_DDL');
 dbms_shared_pool.keep('DBMS_DESCRIBE');
 dbms_shared_pool.keep('DBMS_LOCK');
 dbms_shared_pool.keep('DBMS_OUTPUT');
 dbms_shared_pool.keep('DBMS_PIPE');
 dbms_shared_pool.keep('DBMS_SESSION');
 dbms_shared_pool.keep('DBMS_SHARED_POOL');
 dbms_shared_pool.keep('DBMS_STANDARD');
 dbms_shared_pool.keep('DBMS_UTILITY');
 dbms_shared_pool.keep('STANDARD');
 dbms_shared_pool.keep('BUSCA_SECUENCIA');
END;
/

 Ramon E. Estevez wrote:
 
 Sorry, new DB and hadn't execute the Dbmspool.sql script.
 
 CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA
 AFTER STARTUP ON DATABASE
   BEGIN
  exec immediate dbms_shared_pool.keep('DBMS_ALERT');
  exec immediate dbms_shared_pool.keep('DBMS_DDL');
  exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE');
  exec immediate dbms_shared_pool.keep('DBMS_LOCK');
  exec immediate dbms_shared_pool.keep('DBMS_OUTPUT');
  exec immediate dbms_shared_pool.keep('DBMS_PIPE');
  exec immediate dbms_shared_pool.keep('DBMS_SESSION');
  exec immediate dbms_shared_pool.keep('DBMS_SHARED_POOL');
  exec immediate dbms_shared_pool.keep('DBMS_STANDARD');
  exec immediate dbms_shared_pool.keep('DBMS_UTILITY');
  exec immediate dbms_shared_pool.keep('STANDARD');
  exec immediate dbms_shared_pool.keep('BUSCA_SECUENCIA');
 END;
 
 I am getting this error, tried with users SYS and SYSTEM
 
 12/11PLS-00103: Encountered the symbol DBMS_SHARED_POOL when
  expecting one of the following:
  := . ( @ % ;
 tia
 
 
 Ramon E. Estevez
 [EMAIL PROTECTED]
 809-565-3121

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: File Table Overflow on Oracle DB Server

2003-02-24 Thread babu . nagarajan


Here is Kirti's reply to it (long time back in June). I think it was to you
that time also...

Babu

Vivek,
You are right, this is an OS related issue, but a DBA must be aware of why
it happens ;)

Error 23 means 'File Table Overflow' and it is generated when the system
wide limit for the number of simultaneously open files is exceeded. It is
controlled by a kernel parameter 'nfile'. which defaults to a value arrived
at by a formula that uses 'maxusers' (and a couple of other) kernel
parameters. You can check the values set for 'maxusers' and 'nfile' on
these
servers, and get your SA to increase those on the server where you had a
problem starting the database.

Use '/usr/sbin/kmtune -q ' command to check currently set value
for 'nfile' and 'maxusers'.

Read more about 'nfile' at
http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html.

HTH,

- Kirti




   
 
  VIVEK_SHARMA 
 
  [EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  osys.comcc: 
 
  Sent by: Subject:  File Table Overflow on Oracle 
DB Server
  [EMAIL PROTECTED]
  
   
 
   
 
  02/24/03 06:28 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 





 We have the following query reg. an error on HP-UX ORacle DB server.

 We are encountering HPUX Error: 23: File table overflow' on the
 Oracle database server while executing stress tests for our
 application. We are not opening any files on the database server
 through the application still this error keeps coming after running
 the test for some duration.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.


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

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

Re: Which is beter a cursor or a for loop?

Both use cursors, but a FOR loop is more concise coding.  Technically, they
are exactly equivalent;  the differences are just stylistic...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:08 AM


 I would suggest that the cursor is the best way to go.
 -Original Message-
 Sent: 24 February 2003 08:39
 To: Multiple recipients of list ORACLE-L



 Hello,

 I was just asked by one of our developers which is beter to use:-
 a cursor or a for loop?
 I must admit I am not sure

 Anyway the specific piece of code in discussion is similar to the
 following

 FOR X IN (SELECT X FROM TABLE_NAME
 WHERE COL1 = 'Something'))
 LOOP
 Do a whole lot of stuff in database here..
 LOOP END;

 I would guess that the cursor would follow similar execution criteria but
 using
 the cursor syntax.

 Any ideas?

 TIA
 regards
 Denham Eva
 Oracle DBA
 The real problem is not whether machines think but whether men do.
 - B. F. Skinner


   _

 DISCLAIMER

 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. TFMC, its holding company, and any of its subsidiaries each
 reserve the right to monitor and manage 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 views of any such entity.

   _


   _

 This e-mail message has been scanned for Viruses and Content and cleared
by
 MailMarshal - For more information please visit
 http://www.marshalsoftware.com www.marshalsoftware.com
   _

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

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list,

2003-02-24 Thread Rachel Carmichael

You brought to mind another one... DON'T assume that changes in one
environment will have the same impact across all environments so DO
test the impact of any change in all environments that you can, before
implementing it in production. We had a change go in to the dev
environment that fixed the performance problem there. Unfortunately, it
made performance fall through the floor in test, which was closer to
the production environment in data volume. Fortunately it was caught
before it went into production.


--- Cary Millsap [EMAIL PROTECTED] wrote:
 You guys are very kind, thank you.
 
 My LIO vs PIO thesis is this:
 
 1. Too many PIOs *is* a bad thing.
 2. But eliminating unnecessary PIOs isn't enough. Even completely
 memory-resident databases can perform horribly (not scale, consume
 dozens of hours per query, etc.)
 3. If you begin by eliminating unnecessary LIOs first, then you often
 eliminate all the PIOs you needed to eliminate, by side-effect.
 
 About the Top-10 list, I'll add...
 
 DON'T do something to make the system faster until you understand
 the
 impact that your proposed activity will have upon the response time
 of
 your important user actions. (Some proposed activities create
 negligible
 impact, and some even create negative impact. When you try those
 activities that don't create sufficient *positive* impact, then you
 *waste* your company's resources.)
 
 DO learn how to figure out--quickly, accurately, and
 inexpensively--the
 impact of a proposed activity upon end-user response time.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 25-27 London
 
 
 -Original Message-
 Landrum
 Sent: Sunday, February 23, 2003 5:49 PM
 To: Multiple recipients of list ORACLE-L
 
 Yes, regarding these 3, how can they be considered absolute do's or
 don'ts?
 I didn't take Cary's material to mean ignore physical IO's but rather
 to
 show the importance and impact of logical IO's.  Too many PIOs could
 still be an issue.
 (I would say maybe Cary could speak to this, but I'd rather him spend
 that time on his book, which I'll be ordering as soon as it's
 available.)
 The others have their places as well.  I wouldn't practice or preach
 that bind variables are always, always the right way (usually, but
 not
 always).
 Why not ASSM?  Surely, there could be circumstances where ASSM is a
 good
 way, or at least ok.
 Do Use Bind Variables
 Do tune to Reduce Logical IO's Not Physical IO's.
 Don't Use ASSM
 
 Please consider, Robert, that I'm not challenging your list as these
 may
 be very good rules to live by.  I don't usually take any 'rule' as
 hard
 and fast until I can test it, but there may be others reading the
 list
 that would benefit greatly to understand why these things should or
 should not be done.
 Thanks for your input, it helps us all learn.
 
 Darrell Landrum
 
 
 
  [EMAIL PROTECTED] 02/23/03 04:23PM 
 Here is the list of top 10 do's and don't that I came up with.
 
 #1 - Do Maintain your Expertise
 #2 - Do Use the DBMS_STATS Package to Collect Statistics
 #3 - Do Use Bind Variables
 #4 - Do Put your Production Database in ARCHIVELOG Mode
 #5 - Do Use Locally Managed Tablespaces
 #6 - Do Monitor Your Database
 #7 - Do Practice Recoveries
 #8 - Do Get Involved with User Groups and Other Resources
 #9 - Do Establish Standards and Change Control Processes
 #10 - Do Think Ahead
 
 Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
 (With regards to Cary!)
 
 Oracle Database Top 10 Don'ts
 #1 - Don't Waste Time Re-Organizing Your Databases
 #2 - Don't Use .Log or Other Common Extensions For Your Database File
 Names
 #3 - Don't Leave Your Database Open To Attack
 #4 - Don't Decide Against Hot Backups
 #5 - Don't Use ASSM
 #6 - Don't Forget the 80/20 Rule
 #7 - Don't Stack Views
 #8 - Don't Be a Normalization Bigot
 #9 - Don't Forget to Document Everything
 #10 - Do Not Use Products You are Not Licensed For.
 
 Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
 
 Ok, anyone wanna comment?
 
 
 Robert G. Freeman
 Technical Management Consultant
 TUSC - The Oracle Experts www.tusc.com 
 904.708.5076 Cell (It's everywhere that I am!)
 Author of several books you can find on Amazon.com!
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net 
 -- 
 Author: Freeman Robert - IL
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 --

RE: Alert Log reporting question

2003-02-24 Thread Jamadagni, Rajendra

Title: RE: Alert Log reporting question





Checkout http://www.zephyrus.com ... it is a very nice tool ...


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Alert Log reporting question



Sinardy,


I've posted a shell script called chk_oerr.sh on
http://www.EvDBT.com/tools.htm. It doesn't do exactly what you ask, but it
remembers where it left off scanning in the alert.log file. You can run
it hourly, daily, or weekly if you like, and the timing of the emails it
sends you should provide some sense of the timing of the errors...


Hope this helps...


-Tim


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:33 AM



 Hi all,

 I am writing a script that can grep ORA- from alert log.

 I think it will be good if I can grep the time of the error occur, can you
please help me?

 If you are lazy to type please introduce me any related unix function, I
will do man the function myself.


 Thanks

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



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


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



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

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

2003-02-24 Thread K Gopalakrishnan

MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion 
abt that. Would you mind telling us 'Why you don't agree on them?'


KG

--- dist cash [EMAIL PROTECTED] wrote:
 
 
 I don't agree with don't #1 and #5.
 
 
 
 
 From: Stephane Faroult [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
 list, 
 comments
 Date: Mon, 24 Feb 2003 00:23:37 -0800
 
  Here is the list of top 10 do's and don't that I
  came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
  Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
  Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
  Resources
  #9 - Do Establish Standards and Change Control
  Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
  Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
  Your Database File Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed For.
  
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
  Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
  Technical Management Consultant
  TUSC - The Oracle Experts www.tusc.com
  904.708.5076 Cell (It's everywhere that I am!)
  Author of several books you can find on Amazon.com!
  
 
 Robert,
 
DO #3 and DON'T #7 are developer stuff, not DBA stuff ...
 I would gladly replace DO #3 by 'Relentlessly preach good practice
 to 
 developers'. I can hardly talk to a developer without mentioning 
 DBMA_APPLICATION_INFO in the first 30 seconds :-).
 
 Regards,
 
 Stephane Faroult
 Oriole
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Stephane Faroult
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services

-
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 new MSN 8: advanced junk mail protection and 2 months FREE*  
 http://join.msn.com/?page=features/junkmail
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: dist cash
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: JDK_HOME - Do we need damn JDK_HOME?

2003-02-24 Thread Kurth, Michael J.

I left
it blank, and all is well.

-Original Message-From: Vladimir Barac
[mailto:[EMAIL PROTECTED]Sent: Saturday, February 22, 2003 10:04
AMTo: Multiple recipients of list ORACLE-LSubject:
JDK_HOME - Do we need damn JDK_HOME?
Good day to
everyone

I'm installing 9.2 on
Tru64.

And I'm asked to provide JDK_HOME...
Since I'm not going to install HTTP server or use any Java within database or
with database, do I need to set JDK_HOME? I left it blank...

Will there be any problem?

Database is going to be used without
any fancy options beside partitioning. Clients are good old Forms and
Reports...

Thanks,
Vladimir
Barac

Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter.

The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance.

If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail.

Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.

Fwd: Re: Optimizer help, get query to run as good as with RULE

2003-02-24 Thread Hemant K Chitale

Jonathan,

Thanks.
I am able to get better performance running
-- SELECT /*+ CHOOSE */ DISTINCT
-- SELECT /*+ RULE */ DISTINCT
-- SELECT /*+ index (prcd_instruction, prcd_instruction_pk) */ DISTINCT
-- SELECT /*+ index (prcd_instruction_runsheet,
prcd_instruction_runsheet_pk) */ DISTINCT
-- SELECT /*+ index (part, part_pk) */ DISTINCT
-- SELECT /*+ index (stage, stage_pk) */ DISTINCT
-- SELECT /*+ use_nl (prcd_instruction) */ DISTINCT
-- SELECT /*+ use_nl (part) */ DISTINCT
-- SELECT /*+ full(prcd_instruction) parallel(prcd_instruction, 4) */
DISTINCT
SELECT /*+ ordered index (part part_pk) use_nl (part )
index (prcd PRCD_IK03) use_nl (prcd)
index (PRCD_INSTRUCTION_RUNSHEET PRCD_INSTRUCTION_RUNSHEET_PK)
use_nl(PRCD_INSTRUCTION_RUNSHEET)
index (STAGE STAGE_PK) use_nl (STAGE)
index (RECIPE RECIPE_NDX_1) use_nl (RECIPE)
*/ DISTINCT
PRCD_INSTRUCTION_RUNSHEET.STAGE_NAME,
PRCD_INSTRUCTION_RUNSHEET.RECIPE_NAME,
PRCD_INSTRUCTION_RUNSHEET.RECIPE_ORDER,
PRCD_INSTRUCTION_RUNSHEET.PRCD_ID,
PRCD_INSTRUCTION_RUNSHEET.RECIPE_STAGE,
PRCD_INSTRUCTION_RUNSHEET.INSTRUCTION_NUMBER,
RECIPE.RECIPE_TITLE,
PART.PART_NAME,
RECIPE.EQP_TYPE,
PRCD_INSTRUCTION_RUNSHEET.STAGE_ORDER,
STAGE.STAGE_DESC,
TO_NUMBER (STAGE.MATCH_ORDER),
DECODE (STAGE.MATCH_ORDER, STAGE.STAGE_SORT_ORDER, 'N', 'Y'),
PRCD.PRCD_TITLE
FROM
-- PRCD_INSTRUCTION_RUNSHEET,
-- RECIPE,
-- PART,
-- STAGE,
-- PRCD,
-- PRCD_INSTRUCTION
PRCD_INSTRUCTION,
PART,
PRCD,
PRCD_INSTRUCTION_RUNSHEET,
STAGE,
RECIPE
WHERE
( PART.PART_ID = PRCD_INSTRUCTION.PRCD_ID )
AND ( STAGE.STAGE_ID = PRCD_INSTRUCTION_RUNSHEET.RECIPE_STAGE )
AND ( PRCD.PRCD_ID = PRCD_INSTRUCTION_RUNSHEET.PRCD_ID )
AND ( (RECIPE.RECIPE_NAME = PRCD_INSTRUCTION_RUNSHEET.RECIPE_NAME) AND
(RECIPE.RECIPE_ACTIVE_FLAG = 'A') )
AND ( (PRCD.PRCD_ID LIKE PRCD_INSTRUCTION.CALL_PRCD_NAME || '.%') AND
(PRCD.PRCD_ACTIVE_FLAG = 'A') )
AND (
( PRCD_INSTRUCTION_RUNSHEET.HIERARCHICAL = 'Y' )
AND ( PRCD.PRCD_ACTIVE_FLAG = 'A' )
AND ( PART.PART_ACTIVE_FLAG = 'A' )
AND ( PART.OBSELETE_FLAG  'Y' )
AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'F-%'
AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'L000%'
AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'PCW%'
)
/
Also, yes, multiple index hints ARE working as
SELECT /*+ index (part, part_pk) index (prcd, prcd_ik03)
index (prcd_instruction_runsheet prcd_instruction_runsheet_pk)
index (stage stage_pk)
index (recipe recipe_ndx_1) */ DISTINCT
I had encountered an error message when trying multiple index hints earlier 
and I
cannot reproduce it now.
I couldn't find examples of multiple hints in the documentation and I came
across a Metalink Forum entry  posting where Helene Schoone [whose advice I 
generally respect]
had stated  You cannot specify multiple tables in the index hint. 
I didn't catch that she would have meant a single hint but that it did not
exclude seperate hints !

Regards
Hemant


Date: Wed, 19 Feb 2003 13:05:11 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Jonathan Lewis [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Jonathan Lewis [EMAIL PROTECTED]
Subject: Re: Optimizer help, get query to run as good as with RULE hint
Organization: Fat City Network Services, San Diego, California
Can you clarify what you mean by:
I find that I cannot specify multiple Index Hints.
Just for the sake of checking a point,
arrange the tables in the from clause
in the order indicated by the RULE path,
viz:
PRCD_INSTRUCTION
PART
PRCD
PRCD_INSTRUCTION_RUNSHEET
STAGE
RECIPE
(NB Your plan seems to have displayed the
odd order switch on table RECIPE due to
v9 table prefetching - which is odd because
I had heard it was a cost-based thing).
Then put in the ORDERED hint, along with
a hint for each table to use the index that
appears for that table, with a USE_NL hint
viz:
/*+
ordered
index(part PART_PK)
use_nl(part)
index(PRCD PRCD_IK03)
use_nl(prcd)
... etc ...
*/
This should give you exactly the same access
path as the rule path.
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
USA_(FL)_May 2nd
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 18 February 2003 04:32
hint
Mark,

Here's the query in expl_PRCD.sql

delete plan_table where statement_id ='PRCD_H';
explain plan
set statement_id='PRCD_H'
for
SELECT /*+ CHOOSE */ DISTINCT
-- SELECT /*+ RULE */ DISTINCT
-- SELECT /*+ index (prcd_instruction, prcd_instruction_pk) */
DISTINCT
-- SELECT /*+ index (prcd_instruction_runsheet,
prcd_instruction_runsheet_pk) *T
--

Re: initial/next computation with DOP 4

2003-02-24 Thread Barbara Baker

Jonathan:
Just what I was looking for -- thank you so much!
I can (and will) turn this tablespace into locally
managed.   Just can't do it right at this moment.

I kinda thought that making the next the same for
all of my extents would be enough to keep
fragmentation down, but that obviously did not work. 
I'll try the sizing you recommended.

Again, thanks for the speedy reply.

Barb

--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
 
 You really should be looking at locally
 managed tablespaces with uniform extent
 size (see www.dbazine.com for one article
 on this, www.oracledba.co.uk for another).
 
 Even if you want to avoid LMTs, then you
 should be looking at aiming for uniform
 extent sizing by mechanical methods.
 (initial = next = minimum extent).
 
 You problem comes from the fact that when
 you create an index using parallel slaves,
 each slave creates its own section of the
 index using the base initial/next, and when
 all slaves have completed, the co-ordinator
 creates a root block linking them together.
 
 To minimise space wastage, just work on the
 fact that each slave will, on average, leave
 half an extent of space unused.
 
 In your case, I would probably consider 16M or 32M
 as the unit size - 16M is the index was only going
 to grow slowly after the rebuild, 32M if it was
 likely
 to grow at a rate that would result in extra extents
 appearing more than once per month. (16 and 32
 because
 they are powers to 2, and in your case lead to 40 to
 80
 extents)
 
 Smaller extents give you less wastage, larger
 extents give
 you slower subsequent growth rates and a lower
 granularity
 of monitoring.
 
 
 Regards
 
 Jonathan Lewis
 http://www.jlcomp.demon.co.uk
 
 Coming soon one-day tutorials:
 Cost Based Optimisation
 Trouble-shooting and Tuning
 Indexing Strategies
 (see http://www.jlcomp.demon.co.uk/tutorial.html )
 
 UK___March 19th
 USA_(FL)_May 2nd
 
 
 Next Seminar dates:
 (see http://www.jlcomp.demon.co.uk/seminar.html )
 
 USA_(CA, TX)_August
 
 
 The Co-operative Oracle Users' FAQ
 http://www.jlcomp.demon.co.uk/faq/ind_faq.html
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: 24 February 2003 00:23
 
 
  OpenVMS 7.1-2
  Oracle 8.1.7.4
  db_block_size 4096
 
  I need to re-create a large table and its
 associated
  indexes as fast as possible, and with a limited
 amt of
  disk space.  I have a new tblspace at 7000m for
 index
  creation.
 
  I'm creating indexes with DOP4.  (I really need
 the
  speed I get with parallel to create the indexes.)
 In
  my testing, I keep running out of contiguous space
 in
  my index tablespace -- it gets fragmented
  all-to-blazes.  I end up with each index at 4
 extents.
 
  I have a pretty good estimate of how large the
 indexes
  will be.  Is there some sane way to compute a
  reasonable initial and next extent when using
  parallel?
 
  As an example, I created an index (wodh_pk) with
  initial 600m next 20m pctincrease 0.  The index is
 now
  1334m with 4 extents.  If I know the index should
 be
  about 1300 megs, what's a good initial and next
 size?
 
  Thanks for any assistance!
  Barb
 
 
  SELECT SEGMENT_NAME, BYTES/1024/1024 M, EXTENTS,
  NEXT_EXTENT,
PCT_INCREASE FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME='ARCHIDX';
 
  Segment Next
 Pct
  Name  M Extents  Extent  
 Increase
 
   -- ---  
  WODH_PK  1333.55859   4   20,971,520  
  0
  WODH_FK1 821.289063   4   20,971,520  
  0
 
  here's the code . . .
 
  create unique INDEX
   REPORT_REP.WODH_PK
   ON
 
 REPORT_REP.WORK_ORDER_DETAILS_NOHIST(WORK_ORDER_KEY)
   TABLESPACE ARCHIDX
  STORAGE(INITIAL 600M
  NEXT 20M
  MINEXTENTS 1
  MAXEXTENTS 249)
  PARALLEL (DEGREE 4)
  ;
 
 
 
  __
  Do you Yahoo!?
  Yahoo! Tax Center - forms, calculators, tips, more
  http://taxes.yahoo.com/
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
  --
  Author: Barbara Baker
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
  San Diego, California-- Mailing list and
 web hosting
 services
 


 -
  To REMOVE yourself from this mailing list, send an
 E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
  the message BODY, include a line containing: UNSUB
 ORACLE-L
  (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: Jonathan Lewis
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San

RE: Error pinning PKS in shared pool

Instead of modifying the trigger all the time, why not just maintain rows in
a table?

Here's what I've written after I got tired of making typos that caused the
objects after it to fail to pin:

CREATE OR REPLACE TRIGGER sys.qt_pin_on_startup AFTER STARTUP ON DATABASE
DECLARE
v_count NUMBER;
CURSOR c1 IS
SELECT object_owner, object_name, object_type
FROM qt_dba.objects_to_pin_on_startup
WHERE valid_object = 'Y'
FOR UPDATE OF valid_object;

BEGIN
-- 11/08/2002   REJ Auto-pin these on DB startup.  Run
$ADMIN/kept_procs.sql for feedback.
-- NOTE!  In order for this to work, GRANT EXECUTE ANY PROCEDURE TO SYS as
well as explicit
-- SELECT access to the QT_DBA.OBJECTS_TO_PIN_ON_STARTUP table *must* be
done!
--
-- If the object pulled from the table doesn't exist, this trigger should
invalidate the row.
--
FOR ocur IN c1 LOOP
SELECT COUNT(*) INTO v_count
FROM dba_objects
WHERE owner = ocur.object_owner AND
object_name = ocur.object_name;
IF v_count  1 THEN
UPDATE qt_dba.objects_to_pin_on_startup
SET valid_object = 'N'
WHERE CURRENT OF c1;
ELSE
EXECUTE IMMEDIATE 'BEGIN
sys.dbms_shared_pool.keep('''||ocur.object_owner||'.'||ocur.object_name||'''
,'''||ocur.object_type||'''); END;';
END IF;
END LOOP;   

COMMIT;

EXCEPTION
WHEN OTHERS THEN
COMMIT;

END qt_pin_on_startup;
/


Rich

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

-Original Message-
Sent: Monday, February 24, 2003 3:34 AM
To: Multiple recipients of list ORACLE-L



... oops
and then you might want to add that you really
have to mess around with quote marks and
begin/ends to get it to work - something like (and 
I really ought to  test this before posting, 'cos it's 
one of those tiny details that there's no point in 
wasting valuable memorisation time on)

begin
execute immediate  -- no shortened form allowed
'begin   sys.dbms_shared_pool.keep(''DBMS_ALERT'') ; end;'
;
end;

Note - double up the quotes around the quoted package name,
add in the 'begin end' to make the thing you want to execute
an anonymous pl/sql block, make sure that there is a semi-colon
(which would be incorrect for a pure SQL example) at the end of the 
thing you are executing.


(I totally agree with your comments though -
sys packages have been known to become 
mysteriously invalid from time to time).


Regards

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

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

Re: Alert Log reporting question

2003-02-24 Thread Connor McDonald

I have a script to do this (but not access to it at
the moment) but its basically egrep and awk to:

a) grep for ORA-, ^Mon, ^Tue, ... ^Sat
b) results piped through awk which does:
 if $0 like ORA-, the print p, $0
 if $0 like Mon,Tue,...Sat, then p=substr($0,12)

hth
connor

 --- Sinardy Xing [EMAIL PROTECTED] wrote: 
Hi all,
 
 I am writing a script that can grep ORA- from
 alert log.
 
 I think it will be good if I can grep the time of
 the error occur, can you please help me?
 
 If you are lazy to type please introduce me any
 related unix function, I will do man the function
 myself.
 
 
 Thanks 
 
 Sinardy
 -- 
 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).
  

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

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

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

Re: Which is beter a cursor or a for loop?

2003-02-24 Thread Connor McDonald

If you are after the n'th degree performance then the:

for x in (select ... ) 

will be minisculely faster (simply because its
slightly less code and plsql is interpreted).  And
unless I have a particular need for the cursor
%attributes, or the cursor needs to be passed around I
prefer the sql directly in the for-loop.  I don't have
to hunt up through the procedure/package to find the
cursor definition, and (subjectively) I find it easier
to read.

hth
connor

 --- Tim Gorman [EMAIL PROTECTED] wrote:  Both use
cursors, but a FOR loop is more concise
 coding.  Technically, they
 are exactly equivalent;  the differences are just
 stylistic...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Monday, February 24, 2003 3:08 AM
 
 
  I would suggest that the cursor is the best way to
 go.
  -Original Message-
  Sent: 24 February 2003 08:39
  To: Multiple recipients of list ORACLE-L
 
 
 
  Hello,
 
  I was just asked by one of our developers which is
 beter to use:-
  a cursor or a for loop?
  I must admit I am not sure
 
  Anyway the specific piece of code in discussion is
 similar to the
  following
 
  FOR X IN (SELECT X FROM TABLE_NAME
  WHERE COL1 = 'Something'))
  LOOP
  Do a whole lot of stuff in
 database here..
  LOOP END;
 
  I would guess that the cursor would follow similar
 execution criteria but
  using
  the cursor syntax.
 
  Any ideas?
 
  TIA
  regards
  Denham Eva
  Oracle DBA
  The real problem is not whether machines think but
 whether men do.
  - B. F. Skinner
 
 
_
 
  DISCLAIMER
 
  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. TFMC, its holding company, and any of
 its subsidiaries each
  reserve the right to monitor and manage 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 views of any such entity.
 
_
 
 
_
 
  This e-mail message has been scanned for Viruses
 and Content and cleared
 by
  MailMarshal - For more information please visit
  http://www.marshalsoftware.com
 www.marshalsoftware.com
_
 
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
  --
  Author: Thomas, Kevin
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
  San Diego, California-- Mailing list and
 web hosting services
 

-
  To REMOVE yourself from this mailing list, send an
 E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
  the message BODY, include a line containing: UNSUB
 ORACLE-L
  (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: Tim Gorman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

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

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments


#4 on the Do list assumes that you are an On-Line Transaction Process
database.  If you are a Decision Support database, then ARCHIVELOG is not
needed.  But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode.  #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)

My #1 don't is never, ever delete an OS file.  Rename it, wait a week, and
if everything is still running OK then delete the renamed file.



   

  Freeman Robert - 

  IL FREEMANR To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @tusc.com   cc: 

  Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts 
anyone - Here is my list, comments  
   

   

  02/23/2003 05:23 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Here is the list of top 10 do's and don't that I came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.

Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything

Ok, anyone wanna comment?


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

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

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






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

Upgrading from 8.1.5 to 8.1.6

2003-02-24 Thread Nguyen, David M

After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is
created to store new version's files and the old directory of old version
8.1.5 is still there.  Is is safe to remove the old directory to save disk
spaces on the disk?  Is there any files being linked to the old version
after upgrading?

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

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

RE: Testing database links

There is an underlying x$table named x$uganco that contains a column
named inst_id which is being filtered in the view_definition for
V$DBLINK as found in V$FIXED_VIEW_DEFINITION.  Selecting from the
x$uganco should do the trick.  Mind you there are no rows in there when
the links are not active so this may be a real problem for you in terms
of capturing all the links.

Allan

-Original Message-
Sent: Monday, February 24, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L


I think I spoke too soon.

The v$dblink view shows the db_links opened by the current session only.

I want to be able to find out the db_links opened by all current
sessions and the sids for the sessions. This way I can monitor all the
application instances that opened the db_link and those that didn't
close it.

Thanks  regards,
Charu.

-Original Message-
Sent: Friday, February 21, 2003 5:19 PM
To: '[EMAIL PROTECTED]'

Darn!!

I had taken a hasty look at 'Oracle 8i reference', before posting the
query. Not my day today.

Thanks Allan.

Regards,

Charu

-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L

V$dblink

-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L

Dear Listers,

Oracle 8i HP-UX11.

We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
'dbms_session.close_database_link' procedure (that is what they
claim!!).

We want to track the call to the database link and the subsequent
closure. We don't have any access to the remote system to check the
remote session being created and closed.

Is there any way (dynamic performance view etc.) which would show the
database link being in use and closed again on the local database
itself?

Thanks  regards,
Charu

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

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



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

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

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

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: Nelson,

How long to hold onto old Oracle CDs?

Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
been at 8.1.7 for 18 months now.  I can't think of a good reason, other than
the software isn't available anymore.

Anybody want some old CDs?  :)

Rich

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

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

Top 10 normalised down to Top 2

2003-02-24 Thread Connor McDonald

I have to admit my list is considerably smaller:

DO:

#1: Listen, Think, Learn, Communicate
#2: Have a passion for what you do.  If its just a
job, then you're in the wrong one.

DON'T:
#1: Do the opposite of the Do's

Cheers
Connor

 --- Rachel Carmichael [EMAIL PROTECTED] wrote:
 You brought to mind another one... DON'T assume that
 changes in one
 environment will have the same impact across all
 environments so DO
 test the impact of any change in all environments
 that you can, before
 implementing it in production. We had a change go in
 to the dev
 environment that fixed the performance problem
 there. Unfortunately, it
 made performance fall through the floor in test,
 which was closer to
 the production environment in data volume.
 Fortunately it was caught
 before it went into production.
 
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  You guys are very kind, thank you.
  
  My LIO vs PIO thesis is this:
  
  1. Too many PIOs *is* a bad thing.
  2. But eliminating unnecessary PIOs isn't enough.
 Even completely
  memory-resident databases can perform horribly
 (not scale, consume
  dozens of hours per query, etc.)
  3. If you begin by eliminating unnecessary LIOs
 first, then you often
  eliminate all the PIOs you needed to eliminate, by
 side-effect.
  
  About the Top-10 list, I'll add...
  
  DON'T do something to make the system faster
 until you understand
  the
  impact that your proposed activity will have upon
 the response time
  of
  your important user actions. (Some proposed
 activities create
  negligible
  impact, and some even create negative impact. When
 you try those
  activities that don't create sufficient *positive*
 impact, then you
  *waste* your company's resources.)
  
  DO learn how to figure out--quickly, accurately,
 and
  inexpensively--the
  impact of a proposed activity upon end-user
 response time.
  
  
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
  
  Upcoming events:
  - RMOUG Training Days 2003, Mar 5-6 Denver
  - Hotsos Clinic 101, Mar 25-27 London
  
  
  -Original Message-
  Landrum
  Sent: Sunday, February 23, 2003 5:49 PM
  To: Multiple recipients of list ORACLE-L
  
  Yes, regarding these 3, how can they be considered
 absolute do's or
  don'ts?
  I didn't take Cary's material to mean ignore
 physical IO's but rather
  to
  show the importance and impact of logical IO's. 
 Too many PIOs could
  still be an issue.
  (I would say maybe Cary could speak to this, but
 I'd rather him spend
  that time on his book, which I'll be ordering as
 soon as it's
  available.)
  The others have their places as well.  I wouldn't
 practice or preach
  that bind variables are always, always the right
 way (usually, but
  not
  always).
  Why not ASSM?  Surely, there could be
 circumstances where ASSM is a
  good
  way, or at least ok.
  Do Use Bind Variables
  Do tune to Reduce Logical IO's Not Physical IO's.
  Don't Use ASSM
  
  Please consider, Robert, that I'm not challenging
 your list as these
  may
  be very good rules to live by.  I don't usually
 take any 'rule' as
  hard
  and fast until I can test it, but there may be
 others reading the
  list
  that would benefit greatly to understand why these
 things should or
  should not be done.
  Thanks for your input, it helps us all learn.
  
  Darrell Landrum
  
  
  
   [EMAIL PROTECTED] 02/23/03 04:23PM 
  Here is the list of top 10 do's and don't that I
 came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
 Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
 Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
 Resources
  #9 - Do Establish Standards and Change Control
 Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
 Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
 Your Database File
  Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed
 For.
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
 Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
  Technical Management Consultant
  TUSC - The Oracle Experts www.tusc.com 
  904.708.5076 Cell (It's everywhere that I am!)
  Author of several books you can find on
 Amazon.com!
  
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.net 
  -- 
  Author: Freeman Robert - IL
INET: [EMAIL PROTECTED] 
  
  Fat City Network Services-- 858-538-5051
 http://www.fatcity.com 
  San Diego, California

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Stephen Lee


You should keep them.  You never know when you will decide to get a shotgun
and be in need of some targets.

 -Original Message-
 
 Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX 
 CDs?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

I'm curious as to an explanation on don't #1 (what constitutes
reorganization?) and what is ASSM for don't #5?  Assembly???

Rich


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

-Original Message-
Sent: Monday, February 24, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
comments


MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion 
abt that. Would you mind telling us 'Why you don't agree on them?'


KG

--- dist cash [EMAIL PROTECTED] wrote:
 
 
 I don't agree with don't #1 and #5.
 
 
 
 
 From: Stephane Faroult [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
 list, 
 comments
 Date: Mon, 24 Feb 2003 00:23:37 -0800
 
  Here is the list of top 10 do's and don't that I
  came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
  Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
  Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
  Resources
  #9 - Do Establish Standards and Change Control
  Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
  Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
  Your Database File Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed For.
  
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
  Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Jamadagni, Rajendra

Title: RE: How long to hold onto old Oracle CDs?





Just remember during some versions of 7.x most of dbms_xxx packages weren't encoded, that could be a good reference if you are so interested.

Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Subject: How long to hold onto old Oracle CDs?



Hey all,


Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've
been at 8.1.7 for 18 months now. I can't think of a good reason, other than
the software isn't available anymore.


Anybody want some old CDs? :)


Rich



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: storing credit card numbers in a database

None taken!  :)

Rich



-Original Message-
Sent: Friday, February 21, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L


No offense Rich, but I think a crypto expert
would make short work of decrypting this.

Jared






Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 02/21/2003 01:48 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: storing credit card numbers in a database


Even a half-arsed encryption (e.g. 255-ascii(each_char) for 1-byte
languages) in your code can make the wrapped procedure extremely difficult
to crack.  Keep in mind that the assignment of the hashed value shouldn't 
be
in the DECLARE section, because it's location in the wrapped procedure 
will
give away the fact that it's hashed.  For example:

create or replace procedure bleah as
 v_hashed_pass VARCHAR2(5) := 
chr(180)||chr(190)||chr(234)||chr(123);
 v_hash  VARCHAR2(16);
 v_pass  VARCHAR2(16);
BEGIN
 v_hash :=
CHR(171)||CHR(151)||CHR(30*5)||CHR(140)||CHR(182)||CHR(140)||
 CHR(206)||CHR(201)||CHR(189)||CHR(134)||CHR(139)||CHR(154)||
 CHR(140)||CHR(222)||CHR(222)||CHR(222);
 for x in 1..length(v_hash) loop
 v_pass := 
v_pass||CHR(255-ascii(substr(v_hash,x,1)));
 end loop;
 dbms_output.put_line(v_pass);
end bleah;

The v_hashed_pass is in there only for obfuscation, since each literal
isn't wrapped.  Notice also the 30*5 in the assignment of v_hash.  Since
the 5 literal was used in the assignment of v_hashed_pass, it'll throw 
off
anyone trying to reverse engineer the wrapped code.  You could do all 
sorts
of stuff like this to make it next-to-impossible to crack.

Or you could just use Pro*C and secure the code, since you'd have to 
secure
the unwrapped package somewhere anyway...  :)


Rich

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


-Original Message-
Sent: Friday, February 21, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L



Look into the DBMS_OBFUSCAITON package. I used it to encrypt
passwords for a system management app and it works well. The
only problem is that you need an encryption key for the
programs to use. If anybody knows how to read the ALL_SOURCE
view they will be able to find your key and decrypt the data.
You can use the 'wrap' utility to try to hide it and then protect
the un-wrapped source code up the ying-yang but if you use a
text variable like I was crazy enough to to, the damn literal
gets put into the wrapped source. You can use an expression
of some sort but it's going to have to generate the key reliably
each time and then what happens if it doesn't some day
and all of your data becomes unreadable??? the literal
starts looking betterbut you have to hide it well and
protect it from being compromised.

Not to toally turn you off of the packagebut I was coming
at it from the angle that I was trying to protect the information
from somebody like me  =8-)

HTH

Jeff Herrick

On Fri, 21 Feb 2003, Chris Stephens wrote:


 I've been asked to find out a way to encrypt credit card numbers and 
store
 that encrypted string in the database.  ...any oracle functions or
 functionality to do this? or would we have to encrypt the numbers in
the
 application and then pass that string to the database?

 We don't want anyone to be able to get to the numbers even if they have
 access to the table in which it is stored.

 Thanks for any input
 chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: How long to hold onto old Oracle CDs?

2003-02-24 Thread Darrell Landrum

Glue felt on one side and sell as trendy coasters at local flea market.

 [EMAIL PROTECTED] 02/24/03 08:58AM 
Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
been at 8.1.7 for 18 months now.  I can't think of a good reason, other than
the software isn't available anymore.

Anybody want some old CDs?  :)

Rich

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

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


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list,

2003-02-24 Thread david davis

I agree with not relying on a GUI tool, but can't necessarily agree with a 
Good DBA will use command line SQL first.

Personally, I figure a good DBA should make effective use of their time. Use 
or don't use the tool when it makes sense to do so.

I use the tools for one off items but not for applying mass changes or items 
I want to batch.

Good thing I am not sensitive. :-)

Perhaps a Don't

Don't rush in applying changes to the database without reviewing/testing 
first.

David Davis
Mediocre DBA
Manulife Financial




From: Karniotis, Stephen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Date: Sun, 23 Feb 2003 16:28:43 -0800
This thread is great.  Wish I was paying more attention to it.

Here is one Don't

Done rely on gui tools to accomplish any task.  Great DBAs can endure the
SQL to get the answer done.  Good DBAs may opt for a GUI tool but will 
still
use command line SQL first.  Poor DBAs run for their GUI tools.

Here is a DO

Do always challenge yourself to find the solution.
Do remember that other's have been through the same situation are available
to help you.
Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com
 -Original Message-
Sent:   Sunday, February 23, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Yes, regarding these 3, how can they be considered absolute do's or don'ts?
I didn't take Cary's material to mean ignore physical IO's but rather to
show the importance and impact of logical IO's.  Too many PIOs could still
be an issue.
(I would say maybe Cary could speak to this, but I'd rather him spend that
time on his book, which I'll be ordering as soon as it's available.)
The others have their places as well.  I wouldn't practice or preach that
bind variables are always, always the right way (usually, but not always).
Why not ASSM?  Surely, there could be circumstances where ASSM is a good
way, or at least ok.
Do Use Bind Variables
Do tune to Reduce Logical IO's Not Physical IO's.
Don't Use ASSM
Please consider, Robert, that I'm not challenging your list as these may be
very good rules to live by.  I don't usually take any 'rule' as hard and
fast until I can test it, but there may be others reading the list that
would benefit greatly to understand why these things should or should not 
be
done.
Thanks for your input, it helps us all learn.

Darrell Landrum



 [EMAIL PROTECTED] 02/23/03 04:23PM 
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead
Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)
Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.
Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything

Ok, anyone wanna comment?

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send

encryption - peoplesoft 8 - oracle ??

2003-02-24 Thread Mohammed . Ahsanuddin

Title: storing credit card numbers in a database



Has 
anyone used data encryption/decryption with peoplesoft8 HR application with 
oracle backend? Any hints will be appreciated..

Thanks 
Mohammed 
Ahsanuddin Oracle DBA -Original 
Message-From: Nick Wagner 
[mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 4:28 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
storing credit card numbers in a database

  it 
  would be safer to encrypt the credit card number at the application level, and 
  insert that string into the database, because anyone with a decent sniffer 
  would be able to pick it out of the SQL*Net code.Whether or not they 
  even have access to the database.
  
  -Original Message-From: Richard Ji 
  [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 
  12:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: storing credit card numbers in a database
  Besides the DBMS_OBFUSCATION_TOOLKIT, 
  Application Security Inc also has a product to 
  encrypt data in the database. Check out their web site 
  www.appsecinc.com.
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Friday, 
February 21, 2003 3:25 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: storing credit card numbers in a 
database
We have been looking at a similar requirement..so far it seems if you 
want to use oracle's encryption (DBMS_OBFUSCATION_TOOLKIT) tool kit 
encryption has to be done in code and passed to the database and vice 
versa.

There is a product called secure.data for oracle database from 
protegrity which claims to be application transparent..I have not worked 
with that but it is an option.

Thanks 
Mohammed 
Ahsanuddin Oracle DBA -Original 
Message-From: Chris Stephens 
[mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 
2:06 PMTo: Multiple recipients of list 
ORACLE-LSubject: storing credit card numbers in a 
database

  I've been asked to find out a way to encrypt credit card 
  numbers and store that encrypted string in the database. ...any 
  oracle functions or functionality to do this? or would we have to 
  encrypt the numbers in the application and then pass that string to the 
  database?
  We don't want anyone to be able to get to the numbers even 
  if they have access to the table in which it is stored. 
  Thanks for any input chris

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can
withstand on that DB?  If your recovery time for most situations is much
shorter using ARCHIVELOG mode (perhaps on very large DBs or systems
w/limited IO), wouldn't that be better than NOARCHIVELOG?

Rich

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


-Original Message-
Sent: Monday, February 24, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
comments



#4 on the Do list assumes that you are an On-Line Transaction Process
database.  If you are a Decision Support database, then ARCHIVELOG is not
needed.  But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode.  #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)

My #1 don't is never, ever delete an OS file.  Rename it, wait a week, and
if everything is still running OK then delete the renamed file.



 

  Freeman Robert -

  IL FREEMANR To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  @tusc.com   cc:

  Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments  
 

 

  02/23/2003 05:23

  PM

  Please respond

  to ORACLE-L

 

 





Here is the list of top 10 do's and don't that I came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.

Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything

Ok, anyone wanna comment?


Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Export generates ORA-04031 error

2003-02-24 Thread Nguyen, David M

I received following errors during export.  I had increased shared_pool_size
in configuration file several times, it just fixed the problem for couple
weeks then now I received the same problem.  Is there a better way to fix
this issue permanently?  And what is the maximum limit size can I increase
shared_pool_size?  Currenlty it is increased from 500 to 900.

EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam
Buffer)
EXP-00083: The previous problem occurred when calling
SYS.DBMS_REFRESH_EXP_SITES.schema_info_expacle


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

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

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Mark Leith

CD's make great coffee coasters! Just ask our competition!! ;)

-Original Message-
Sent: 24 February 2003 15:34
To: Multiple recipients of list ORACLE-L



You should keep them.  You never know when you will decide to get a shotgun
and be in need of some targets.

 -Original Message-
 
 Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX 
 CDs?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

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

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

Re: How long to hold onto old Oracle CDs?

2003-02-24 Thread david davis

Actually the CD's are available. You just have to request them from Oracle. 
Of course, this does depend upon having a support contract.

Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to 
cracked media.

From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How long to hold onto old Oracle CDs?
Date: Mon, 24 Feb 2003 06:58:58 -0800
Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
been at 8.1.7 for 18 months now.  I can't think of a good reason, other 
than
the software isn't available anymore.

Anybody want some old CDs?  :)

Rich

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

_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: david davis
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 long to hold onto old Oracle CDs?


Hold on to them - they're really good for
hanging in branches of fruit trees to scare
the birds off.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: 24 February 2003 14:58


 Hey all,

 Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?
We've
 been at 8.1.7 for 18 months now.  I can't think of a good reason,
other than
 the software isn't available anymore.

 Anybody want some old CDs?  :)

 Rich


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

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

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Tom,

Having a data warehouse database in NOARCHIVELOG is, like any other
database, only the very last resort when ARCHIVELOG is simply not possible.
Your advice results from several assumptions which may or may not be valid:

  * data warehouse are read-only;  don't worry about transaction
processing

  * data warehouses have lower availability expectations;  the business wll
not halt if it is down

  * data warehouses are not mission-critical;  the business will not halt
if it is down

  * we believe in rebuild-and-reload for DW, not restore-and-recover, so
we use NOARCHIVELOG mode

Ironically, data warehouses frequently spend enormous amounts of time
performing extraction, transformation, and load (ETL), so they are
anything but read-only.  Depending on the complexity and duration of ETL
processing, uptime and availability may be real concerns.  I converted a
Teradata DW to Oracle in the early 90s.  This DW was loaded monthly, but
Teradata could not process 4 weeks of data faster than 6 weeks, so months
were being skipped.  This was due to frequent outages as well as poorly
designed ETL processes.  The ETL process averaged 3-4 weeks, but outages
would extend this to 5-6 weeks...

The idea that the business will not halt if the DW is down is a view
commonly held by organizations lacking a successful DW.  Successful DW
deployments frequently have ties from customer service into DW-supported
systems, not to mention the irritation from on-high that accompanies a DW
outage.  Also, many DW systems have queries that legimately take days to
complete, so daily or weekly outages are not an option.

I have worked several DW systems where NOARCHIVELOG mode and the resultant
rebuild-then-reload recovery mechanism has been in place, instead of
ARCHIVELOG mode and the resultant restore-and-recover recovery strategy.
Each time, our eyes were wide open to the advantages and benefits as well as
the disadvantages and risks.  The disadvantages and risks outweigh the
advantages and benefits in almost every situation.  One time, the DW simply
didn't have access to suffiicient tape capacity for archivelog backups (we
had planned to steal bandwidth on the mainframe tape drives, but they shut
that down right quick!), which is a problem that was corrected when project
funding permitted 3 years later.  Another time, the activity on the DW
database would have generated an *average* of 2 Tbytes of archived redo log
files every day, sometimes peaking at 3-4 Tbytes.  This time, considerable
tape capacity was available, but it was still far from sufficient.  Despite
the mission-critical nature of this DW, it remains in NOARCHIVELOG mode to
this day, despite several week-long outages during rebuild-then-reload
recovery operations...

NOARCHIVELOG mode should always be either an indication that the database is
utterly unimportant or it should be the absolute last resort, the ultimate
expediency, a stopgap until correction.  It is never a viable option from a
design or planning standpoint.  Robert's do #4 is correct.

Hope this helps...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 8:03 AM



 #4 on the Do list assumes that you are an On-Line Transaction Process
 database.  If you are a Decision Support database, then ARCHIVELOG is not
 needed.  But, as a general rule, the world would be a better place if more
 production DBAs had their databases in ARCHIVELOG mode.  #4 on the DO list
 is the same as #4 on the DON'T list (or have they got a way now to do hot
 backups without ARCHIVELOG mode?)

 My #1 don't is never, ever delete an OS file.  Rename it, wait a week, and
 if everything is still running OK then delete the renamed file.





   Freeman Robert -
   IL FREEMANR To:  Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
   @tusc.com   cc:
   Sent by: rootSubject: RE: Top 10 DBA
Do's and Don'ts anyone - Here is my list, comments


   02/23/2003 05:23
   PM
   Please respond
   to ORACLE-L






 Here is the list of top 10 do's and don't that I came up with.

 #1 - Do Maintain your Expertise
 #2 - Do Use the DBMS_STATS Package to Collect Statistics
 #3 - Do Use Bind Variables
 #4 - Do Put your Production Database in ARCHIVELOG Mode
 #5 - Do Use Locally Managed Tablespaces
 #6 - Do Monitor Your Database
 #7 - Do Practice Recoveries
 #8 - Do Get Involved with User Groups and Other Resources
 #9 - Do Establish Standards and Change Control Processes
 #10 - Do Think Ahead

 Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
 (With regards to Cary!)

 Oracle Database Top 10 Don'ts
 #1 - Don't Waste Time Re-Organizing Your Databases
 #2 - Don't Use .Log or Other Common Extensions For Your Database File
Names
 #3 - Don't Leave Your Database Open To

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

2003-02-24 Thread Mark Leith

Automatic Segment Space Management

-Original Message-
Sent: 24 February 2003 15:39
To: Multiple recipients of list ORACLE-L
comm


I'm curious as to an explanation on don't #1 (what constitutes
reorganization?) and what is ASSM for don't #5?  Assembly???

Rich


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

-Original Message-
Sent: Monday, February 24, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
comments


MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion 
abt that. Would you mind telling us 'Why you don't agree on them?'


KG

--- dist cash [EMAIL PROTECTED] wrote:
 
 
 I don't agree with don't #1 and #5.
 
 
 
 
 From: Stephane Faroult [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
 list, 
 comments
 Date: Mon, 24 Feb 2003 00:23:37 -0800
 
  Here is the list of top 10 do's and don't that I
  came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
  Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
  Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
  Resources
  #9 - Do Establish Standards and Change Control
  Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
  Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
  Your Database File Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed For.
  
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
  Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

corrupted block

2003-02-24 Thread Suzy Vordos


I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Upgrading from 8.1.5 to 8.1.6

It depends on whether or not you are talking about your old
$ORACLE_HOME.  You may still have shared lib dependancies there.  You
don't give enough information in your post to be absolutely certain so
you might consider relinking if this is the case.

-Original Message-
Sent: Monday, February 24, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L


After upgrading oracle database from V8.1.5 to V8.1.6, a new directory
is created to store new version's files and the old directory of old
version 8.1.5 is still there.  Is is safe to remove the old directory to
save disk spaces on the disk?  Is there any files being linked to the
old version after upgrading?

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

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



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

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

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

RE: Top Do's and Don'ts - Ferenc's list

Good list yerself!! :-))

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

-Original Message-
Sent: Sunday, February 23, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Hey Robert, I rather like your list, it gives one plenty to ponder. I have
maintained my own much smaller list for some years, and thus will take this
opportunity to share it:

1. Do keep your knowledge concurrent. This includes reading books (by Jared,
Cary, let us not forget Gaja and Kirti's book, Jonathan, Queen Rachel, Tom,
Steve Feuerstein and apologies to anyone I left out and should not have),
attending conferences, making time to belong to this list that drains at
least an hour+ per day of my time. Take charge of your future !
2. Do know your data, know it inside and out. If someone wakes you up at 3
a.m., you should be able to rattle off the size and configuration (SGA, redo
logs, etc) of your production DB, and the 3 - 5 largest tables, approx. how
many rows they have and how large they are in size and their current growth
rates.
3. Do try to understand a little (or a lot) about the legacy / packaged
application you're supporting.
4. Be aware that you and the entire IT department exist to support a
business process, not because the CEO is in love with technology. The goal
of your employer is to earn and save money and maximize ROI !
5. Do encourage and thank those around you that make your working day a
little easier. This includes recognition of up-and-coming talent (pat on the
back type thing), occasionally buying a round when your SA's, network fundis
are with you, just to show your gratitude ! You never know when you will
next run in to a major crisis and need them.
6. Keep a good sense of humour ! Things won't always go your way, and your
stress levels are decided by your reaction to the situation you find
yourself in. Accept the fact that alone you will not change the world or
even your company.

DON'T's
1. Don't believe everything you hear ! Whether that be from vendors,
programmers or sysadmins. Investigate for yourself. When in doubt, try it
out ! Don't jump to conclusions !
2. Don't assume you have a safe, cushy job. All it takes is one classic
screw-up on your part, or some back-stabbing bastard before you could find
yourself looking for the next thing. So keep your resume / CV updated and
handy, always ! See point 1 on taking charge !
3. Don't expect the CIO / CTO / CEO to jump enthusiastically at your ideas,
and readily praise you for your insight. they often don't get it, and when
they do, they are often subject to the bean counters or lawyers (did you
know USA has about 90% of all the world's lawyers ? ) who set policy, and
don't tolerate deviances. I recently (Sep 2002) came across a client who was
still using Storagetek silo's that housed 480 tapes per robotic arm, each of
them ... wait for it  200 MB in size, and the drives were upgraded 4
years ago to use DLT4000 (woohoo ! ) technology. These silos were about 15
square metres each, and there were 3 of them back to back and it was purely
for daily backups of a 100 GB database ! It turns out they knew about
Ultrium, but the bean counters who controlled the company said that the tape
drive system was not be replaced for another 2 years until it had been fully
depreciated, since its resale value was below zero, in that they would have
to pay someone to remove it. Go figure !
4. Don't forget to back up. My home PC recently died after almost 3 years
faithful service (well, if you exclude the Windows OS causing near-daily
crashes). Both IBM hard drives packed up within a week, and I was most
embarrassed when I was asked if I had backed up everything on it before it
died, and my answer was 'yes, 8 months ago'. B-A-A-A-A-A-H ! Really sheepish
!
5. Don't boast too much ! A little happiness and rejoicing for solving a
complex problem is fine (at least this is a rule I set for myself, I don't
expect everyone to see it my way), but I prefer to let others do the
praising that for me to do it on my own behalf ! And of course, just when I
think I am doing so well, I go home and am reminded of how many things I am
completely incompetent at :-) (for instance a recent dialogue went like
this, Hey Dad, Danny's dad just ran a marathon last weekend, when and why
did you stop running ?. To which the classic comeback is ever since I
discovered that I can drive the distance a lot faster and in more comfort !
heh heh .

Have a great day, all of you ! Cheerio:


Ferenc Mantfeld
Dreaming costs you nothing. Not dreaming costs you everything.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 9:23 AM


 Here is the list of top 10 do's and

Re: How long to hold onto old Oracle CDs?

Under no circumstances would you consider moving your production db back
from 8.1.7 to 7.3.3, would you?  So the only possible reason for retaining
them would be to support a newly-acquired application (!?!?!?!).  Even if
you still had the CDs, shouldn't you just say you didn't?  :-)

They make great tacky drink coasters.  If you're into skeet shooting or
plinking, then there's another good use...

Speaking of plinking, former Minnesota Governor (and boa-wearing pro
wrestler) Jesse Ventura had a quote that was relevant:  Gun control?  Sure
I believe in gun control.  Putting three shots through the same hole --
that's gun control!  If you can put a BB through the drive hole of the CD
without touching from 10 meters out, that's gun control!

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 8:33 AM


 I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies)

  -Original Message-
  From: Jesse, Rich [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 24, 2003 9:59 AM
  To: Multiple recipients of list ORACLE-L
  Subject: How long to hold onto old Oracle CDs?
 
 
  Hey all,
 
  Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX
  CDs?  We've
  been at 8.1.7 for 18 months now.  I can't think of a good
  reason, other than
  the software isn't available anymore.
 
  Anybody want some old CDs?  :)
 
  Rich
 
  Rich JesseSystem/Database Administrator
  [EMAIL PROTECTED]   Quad/Tech International,
  Sussex, WI USA
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jesse, Rich
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]

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


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 long to hold onto old Oracle CDs?

2003-02-24 Thread Gogala, Mladen

I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies)

 -Original Message-
 From: Jesse, Rich [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 24, 2003 9:59 AM
 To: Multiple recipients of list ORACLE-L
 Subject: How long to hold onto old Oracle CDs?

 Hey all,

 Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX 
 CDs?  We've
 been at 8.1.7 for 18 months now.  I can't think of a good 
 reason, other than
 the software isn't available anymore.

 Anybody want some old CDs?  :)

 Rich

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

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

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

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

RE: File Table Overflow on Oracle DB Server

2003-02-24 Thread John Kanagaraj

Vivek,

The database backend process will open the file on your behalf, and each
open takes up one entry in your 'Numbe of Open files in the System' OS
table. Not many people monitor the output of 'sar -v'. Look for overflows of
some of the OS tables under the 'ov' column... (this will also indicate the
amount of overflow). 

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

Disappointment is inevitable, but Discouragement is optional! 

** The opinions and statements above are entirely my own and not those of my
employer or clients **


 -Original Message-
 From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 24, 2003 3:29 AM
 To: Multiple recipients of list ORACLE-L
 Subject: File Table Overflow on Oracle DB Server
 
 
 
  We have the following query reg. an error on HP-UX ORacle DB server.
  
  We are encountering HPUX Error: 23: File table overflow' on the
  Oracle database server while executing stress tests for our
  application. We are not opening any files on the database server
  through the application still this error keeps coming after running
  the test for some duration.
  
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: VIVEK_SHARMA
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 long to hold onto old Oracle CDs?

2003-02-24 Thread Boyle Candi

We covered an entire wall in the operations manager's office with the
Oracle cd's.  We even had enough red ones to create a nice design...  It
all started because I asked him if we recycle cd's.  He said only if I
could find a new use for them.  He shouldn't have said that and then
taken a day off...  

-Candi

On Mon, 2003-02-24 at 10:33, Stephen Lee wrote:
 
 You should keep them.  You never know when you will decide to get a shotgun
 and be in need of some targets.
 
  -Original Message-
  
  Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX 
  CDs?
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boyle Candi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Export generates ORA-04031 error

9M is not a large shared pool.  What db version?  What app?  We really
do need some details to provide intelligent responces.  You might
consider bumping it to 20M and see what happens.  Without more
information it is impossible to be more specific.

Allan

-Original Message-
Sent: Monday, February 24, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L


I received following errors during export.  I had increased
shared_pool_size in configuration file several times, it just fixed the
problem for couple weeks then now I received the same problem.  Is there
a better way to fix this issue permanently?  And what is the maximum
limit size can I increase shared_pool_size?  Currenlty it is increased
from 500 to 900.

EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam
Buffer)
EXP-00083: The previous problem occurred when calling
SYS.DBMS_REFRESH_EXP_SITES.schema_info_expacle


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

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



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

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

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

RE: corrupted block

2003-02-24 Thread Khedr, Waleed

See Note:61685.1 (metalink)

Good luck

Waleed

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



I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

A... but in my world view, DBA's need to THINK like developers, since we
are always the ones who the real SQL tuning gets pushed down to. Also, DBA's
often are called on to design the database, and when views are brought to
them to create they need to ask themselves, is this really a good idea???
Same thing with respect to bind variables. We need to be saying, Uh, folks,
don't you think this might be a good time to use bind variables?

Of course, YMMV :-)

RF

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


-Original Message-
Sent: Monday, February 24, 2003 2:24 AM
To: Multiple recipients of list ORACLE-L
comments


Here is the list of top 10 do's and don't that I
came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect
Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG
Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other
Resources
#9 - Do Establish Standards and Change Control
Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not
Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For
Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.


Bonus!! - Do Not Assume A Good or Bad Hit Ratio
Means Anything

Ok, anyone wanna comment?


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


Robert,

  DO #3 and DON'T #7 are developer stuff, not DBA stuff ...
I would gladly replace DO #3 by 'Relentlessly preach good practice to
developers'. I can hardly talk to a developer without mentioning
DBMA_APPLICATION_INFO in the first 30 seconds :-).

Regards,

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

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

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

Using fully qualified table_name.database_object in application code?

2003-02-24 Thread laura pena

I would like to know if it is advocated to use fully qualified table_name.database objects in application code.
Example would be schema.table_name in a PL/SQL code.
I would like to know the Pros/Cons if there are any?
Thanks in advance.Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

Re: Teradata baned from IOUG???


Robert,

I agree, personal attacks are inappropriate and
fairly pointless.  On the other hand, I do sympathise
with the people who are irritated by the divergence
between Rich Niemiec's claims to be one of the best,
and the poor, even dangerous, work that he publishes.

Please note, I do not believe he is trying to mislead
his readers into dangerous or unsuitable areas, but
the combination of his claims to expertise, past
reputation, and generally sketchy comments can easily
persuade individuals to 'try option X' simply because
Rich has written a few lines which say option X exists
and this is an example from the manuals.

The question has to be asked, therefore, where is
the forum for questioning the material published by a
guru and if there is one, how do you avoid crossing
the line between criticising the material and criticising
the person ?



Personally, I don't mind if Rich thinks he's one of the
best in the world; but I'd far rather see him publish
a lower quantity and higher quality - his present output
does not do his reputation credit.



Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


Freeman Robert - IL wrote:

 I must admit that I'm a bit tired of the Rich/TUSC bashing here.
I've
 written and canned two rather terse responses to personal attacks
 against Rich. If you want to disagree with his position on BHR, go
for
 it, I have no problem with that. In fact, I'm not sure I *know* what
 his current position is, and will attend his presentation to find
out
 (I suppose I could ask him since I will be at the office tomorrow).

 Personal attacks really are pointless. I would APPRECIATE IT if they
 would cease.




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

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

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Weiss, Rick

Tim:

I can't say that I can shoot BB's @ 10M, I prefer a .30 caliber @ 150 yds,
although I must admit that I can't keep them inside the center hole at that
distance. I do know they don't load worth a hoot with 3 or 4 extra holes in
them ;}

Rick Weiss

-Original Message-
Sent: Monday, February 24, 2003 09:14
To: Multiple recipients of list ORACLE-L


Under no circumstances would you consider moving your production db back
from 8.1.7 to 7.3.3, would you?  So the only possible reason for retaining
them would be to support a newly-acquired application (!?!?!?!).  Even if
you still had the CDs, shouldn't you just say you didn't?  :-)

They make great tacky drink coasters.  If you're into skeet shooting or
plinking, then there's another good use...

Speaking of plinking, former Minnesota Governor (and boa-wearing pro
wrestler) Jesse Ventura had a quote that was relevant:  Gun control?  Sure
I believe in gun control.  Putting three shots through the same hole --
that's gun control!  If you can put a BB through the drive hole of the CD
without touching from 10 meters out, that's gun control!

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 8:33 AM


 I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies)

  -Original Message-
  From: Jesse, Rich [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 24, 2003 9:59 AM
  To: Multiple recipients of list ORACLE-L
  Subject: How long to hold onto old Oracle CDs?
 
 
  Hey all,
 
  Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  
  We've been at 8.1.7 for 18 months now.  I can't think of a good
  reason, other than
  the software isn't available anymore.
 
  Anybody want some old CDs?  :)
 
  Rich
 
  Rich JesseSystem/Database Administrator
  [EMAIL PROTECTED]   Quad/Tech International,
  Sussex, WI USA
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jesse, Rich
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]

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


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: Weiss, Rick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: newbie sqlplus ?

2003-02-24 Thread Les Ayudo

I'm just going to reinstall Oracle8i and start from scratch.  Any docs out
there on uninstalling Oracle8i?  The only ones I have found are on Windows
and they're all saying how Oracle does not completely uninstall.  Is this
true for Oracle on Solaris?  I ran the uninstaller and removed everything
but I noticed the oracle home was still there.  I ended up deleting it.  Is
there anything else I need to do?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 2:34 AM


 hi!

 in your profile set $ORACLE_HOME to your oracle directory and
 put $ORACLE_HOME/bin in your path

 daniel

 Les Ayudo wrote:
 
  I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and
issued
  the command sqlplus and I rec'd a command not found error.  Is there
  something I forgt to do before the install?  Let me kow if u need more
info.
  THanks.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Daniel Wisser
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Les Ayudo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: corrupted block

2003-02-24 Thread Deshpande, Kirti

Suzy,
 Just more questions: 
 Are your sure that this corruption has made it to the disk? It could be memory 
related. 
 Can you export the table to /dev/null to double check the corruption? 
 What do you get when reading that particular block using dba_extents? 

- Kirti 
 
 


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



I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
-- 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 long to hold onto old Oracle CDs?

Yeah, these are actually replacements, too.  But when I ordered them, the
person (back when you could actually talk to a person on a non-level 1 call)
was surprised that they had any 7.x media in stock.  She had said that they
would distribute the CDs only as long as they had stock.

Maybe I'll make an Oracle Mobile using these CDs and all the Start Here
CDs that come with every pack.  At least I won't be throwing them out...  :)

Thx!
Rich


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

-Original Message-
Sent: Monday, February 24, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L


Actually the CD's are available. You just have to request them from Oracle. 
Of course, this does depend upon having a support contract.

Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to 
cracked media.


From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How long to hold onto old Oracle CDs?
Date: Mon, 24 Feb 2003 06:58:58 -0800

Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
been at 8.1.7 for 18 months now.  I can't think of a good reason, other 
than
the software isn't available anymore.

Anybody want some old CDs?  :)

Rich

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

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

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Robson, Peter


Talking of old Oracle stuff, just been cleaning out the bookshelf. 'UFI',
'IAF', 'IAG', 'IAP', 'RPT' bring back any memories?

This lot is going OUT.

peter



On Mon, 2003-02-24 at 10:33, Stephen Lee wrote:
 
 You should keep them.  You never know when you will decide to get a
shotgun
 and be in need of some targets.
 
  -Original Message-
  
  Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX 
  CDs?
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boyle Candi
  INET: [EMAIL PROTECTED]

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


*
This  e-mail   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not  necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS  accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. The BGS cannot accept any responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 long to hold onto old Oracle CDs?


That's about the only thing that AOL CDs are good for.  I don't know if
Oracle CDs would be scary enough!



   

  Jonathan Lewis 

  jonathanTo:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @jlcomp.demon.co cc: 

  .uk Subject: Re: How long to hold onto old 
Oracle CDs?  
  Sent by: root

   

   

  02/24/2003 11:24 

  AM   

  Please respond   

  to ORACLE-L  

   

   






Hold on to them - they're really good for
hanging in branches of fruit trees to scare
the birds off.


Regards

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

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


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

USA_(CA, TX)_August


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


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: 24 February 2003 14:58


 Hey all,

 Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?
We've
 been at 8.1.7 for 18 months now.  I can't think of a good reason,
other than
 the software isn't available anymore.

 Anybody want some old CDs?  :)

 Rich


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

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






-- 
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: corrupted block

2003-02-24 Thread Suzy Vordos


Rama Velpuri's book had the answer to how to copy rows from a table when
a corrupted block exists.  The downside is the table is roughly 18GB,
and has LONG.  

So my next question, is there any way to determine by trace file when
the block corruption occurred?   I'm still under the assumption that all
backups will have the corrupted block.  

Suzy Vordos wrote:
 
 I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade).
 Last night I analyzed the tables and a corrupted block was found.  I
 know which table and datafile it is, and it's the only table in the
 affected tablespace.
 
 The database is in archivelog mode so I can recover the datafile, but I
 am not certain when the block corruption occurred.  There were no
 proactive measures in place to quickly report a corrupted block.  So I
 assume it may have been there a long time, and was just found through
 analyze (tables hadn't been analyzed since Dec-2000).
 
 So my question is, if all backups contain the corrupted block, how would
 I copy all non-corrupted blocks from this table into a new table?
 
 Here is the trace file:
 
 ORACLE data block corrupted (file # 24, block # 57856)
 
 Dump file
 /dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
 Oracle7 Server Release 7.3.4.3.0 - Production
 With the distributed, replication, parallel query and Spatial Data
 options
 PL/SQL Release 2.3.4.3.0 - Production
 ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
 System name:SunOS
 Node name:  kanadb-co1
 Release:5.6
 Version:Generic_105181-17
 Machine:sun4u
 Instance name: kana03aP
 Redo thread mounted by this instance: 1
 Oracle process number: 10
 Unix process pid: 13163, image: oraclekana03aP
 
 *** 2003.02.24.02.49.42.000
 *** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
 ***
 Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
 buffer read
 on disk type:0. ver:0. dba: 0x inc:0x seq:0x
 incseq:0x
 Entire contents of block is zero - block never written
 Reread of block=6000e200 file=24. blocknum=57856. found same corupted
 data
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Suzy Vordos
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

All the hearsay evidence I've seen (including comments attributed to Cary at
his HotSOS symposium that I heard second hand last week) leads me to believe
that don't #5 is true...I must admit I've not done benchmarking myself...
:-)

I am, however, ever open minded.

RF

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


-Original Message-
Sent: Sunday, February 23, 2003 6:39 PM
To: Multiple recipients of list ORACLE-L
comments


why #5 on the don'ts?

I know we've had lots of discussions on this list about it, but I
haven't seen anything that made me think never ever use that


--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
 Here is the list of top 10 do's and don't that I came up with.
 
 #1 - Do Maintain your Expertise
 #2 - Do Use the DBMS_STATS Package to Collect Statistics
 #3 - Do Use Bind Variables
 #4 - Do Put your Production Database in ARCHIVELOG Mode
 #5 - Do Use Locally Managed Tablespaces
 #6 - Do Monitor Your Database
 #7 - Do Practice Recoveries
 #8 - Do Get Involved with User Groups and Other Resources
 #9 - Do Establish Standards and Change Control Processes
 #10 - Do Think Ahead
 
 Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
 (With regards to Cary!)
 
 Oracle Database Top 10 Don'ts
 #1 - Don't Waste Time Re-Organizing Your Databases
 #2 - Don't Use .Log or Other Common Extensions For Your Database File
 Names
 #3 - Don't Leave Your Database Open To Attack
 #4 - Don't Decide Against Hot Backups
 #5 - Don't Use ASSM
 #6 - Don't Forget the 80/20 Rule
 #7 - Don't Stack Views
 #8 - Don't Be a Normalization Bigot
 #9 - Don't Forget to Document Everything
 #10 - Do Not Use Products You are Not Licensed For.
 
 Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
 
 Ok, anyone wanna comment?
 
 
 Robert G. Freeman
 Technical Management Consultant
 TUSC - The Oracle Experts www.tusc.com
 904.708.5076 Cell (It's everywhere that I am!)
 Author of several books you can find on Amazon.com!
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Freeman Robert - IL
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

E!  That icky LMT option?  Ick!  Ick!  Ick!

Thx!
Rich

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


-Original Message-
Sent: Monday, February 24, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
comm


Automatic Segment Space Management

-Original Message-
Sent: 24 February 2003 15:39
To: Multiple recipients of list ORACLE-L
comm


I'm curious as to an explanation on don't #1 (what constitutes
reorganization?) and what is ASSM for don't #5?  Assembly???

Rich


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

-Original Message-
Sent: Monday, February 24, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
comments


MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion 
abt that. Would you mind telling us 'Why you don't agree on them?'


KG

--- dist cash [EMAIL PROTECTED] wrote:
 
 
 I don't agree with don't #1 and #5.
 
 
 
 
 From: Stephane Faroult [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
 list, 
 comments
 Date: Mon, 24 Feb 2003 00:23:37 -0800
 
  Here is the list of top 10 do's and don't that I
  came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
  Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
  Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
  Resources
  #9 - Do Establish Standards and Change Control
  Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
  Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
  Your Database File Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed For.
  
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
  Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Upgrading from 8.1.5 to 8.1.6

2003-02-24 Thread DENNIS WILLIAMS

David
   Just now getting to 8.1.6? Do you wait for a version to be desupported
before you upgrade to it? Just kidding, I'm still on 8.1.6 myself.
   Are we talking data files or program files? Not knowing how you did the
upgrade, it is hard for me to make a blanket statement.
   Look at file dates to make sure these files haven't been modified
recently. If you operating system reports the last access date, check this.
   As someone just mentioned, don't delete, rename if possible.
   Ideally you did the upgrade on your test system before you did it on
production, so you could delete them first on your test server and verify
nothing bad happens.
   Cross your fingers and hope for the best :-)

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


-Original Message-
Sent: Monday, February 24, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L


After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is
created to store new version's files and the old directory of old version
8.1.5 is still there.  Is is safe to remove the old directory to save disk
spaces on the disk?  Is there any files being linked to the old version
after upgrading?

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

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

2003-02-24 Thread Stephen Lee


I think more recent versions of Oracle have options for skipping corrupt
blocks with exports.

One possible way:
If you have a valid primary key index on the table, and the index is in a
good tablespace, you might be able to cycle through all the primary keys,
select the row corresponding to that primary key and insert it into a new
table.  I was able to do this about a month ago with a 8.1.7 database.  In
my case, I think it was a block header that was corrupt, not data; so I got
all the data OK.  It was rather slow, grabbing and inserting one row at a
time; but I got all the data.  As long as I didn't do anything that would
cause a table scan of any kind, I could get the data.

By the way, rman not only failed to spot the corruption, but backed it up
AND restored the corruption!  My initial attempt was to just rename the
datafile at the file system level, then recover it from the previous backup.
I could relate another one of those TAR non-support -- total and complete
NON-support! -- on this one.

 -Original Message-
 
 So my question is, if all backups contain the corrupted 
 block, how would
 I copy all non-corrupted blocks from this table into a new table?  
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

2003-02-24 Thread Mercadante, Thomas F

Rich,

I agree.  We have a warehouse here that is not in archivelog mode.  They
perform loads two days a week (Sunday and Monday) followed by a cold backup
on Tuesday.  The cold backup is now taking 18 hours to complete.  I've
suggested switching into Archivelog mode and performing Rman backups - at
least the database is up and available to the users during the backup!  It's
probably going to happen, just waiting for the proper discussion.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, February 24, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
comments


Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can
withstand on that DB?  If your recovery time for most situations is much
shorter using ARCHIVELOG mode (perhaps on very large DBs or systems
w/limited IO), wouldn't that be better than NOARCHIVELOG?

Rich

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


-Original Message-
Sent: Monday, February 24, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
comments



#4 on the Do list assumes that you are an On-Line Transaction Process
database.  If you are a Decision Support database, then ARCHIVELOG is not
needed.  But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode.  #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)

My #1 don't is never, ever delete an OS file.  Rename it, wait a week, and
if everything is still running OK then delete the renamed file.



 

  Freeman Robert -

  IL FREEMANR To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  @tusc.com   cc:

  Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments  
 

 

  02/23/2003 05:23

  PM

  Please respond

  to ORACLE-L

 

 





Here is the list of top 10 do's and don't that I came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.

Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything

Ok, anyone wanna comment?


Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: corrupted block


Have you tried copying it into a new table?

Assuming that you have tried and failed, try creating a new table something
like this:

Create new_table as (select * from old_table where substr(rowid,1,8) !=
02457856);

I believe that that's the way the rowid was set up in Oracle 7.3.4 but my
understand comes from a script that Dave Hungle, [EMAIL PROTECTED] ,
DBCORP Information Systems Inc. posted here.

HTH



   

  Suzy Vordos  

  lvordos To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @qwest.com  cc: 

  Sent by: rootSubject: corrupted block

   

   

  02/24/2003 11:09 

  AM   

  Please respond   

  to ORACLE-L  

   

   






I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade).
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name: SunOS
Node name: kanadb-co1
Release:   5.6
Version:   Generic_105181-17
Machine:   sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 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

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

Care to share why...?

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


-Original Message-
Sent: Monday, February 24, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L
comments




I don't agree with don't #1 and #5.




From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800

 Here is the list of top 10 do's and don't that I
 came up with.
 
 #1 - Do Maintain your Expertise
 #2 - Do Use the DBMS_STATS Package to Collect
 Statistics
 #3 - Do Use Bind Variables
 #4 - Do Put your Production Database in ARCHIVELOG
 Mode
 #5 - Do Use Locally Managed Tablespaces
 #6 - Do Monitor Your Database
 #7 - Do Practice Recoveries
 #8 - Do Get Involved with User Groups and Other
 Resources
 #9 - Do Establish Standards and Change Control
 Processes
 #10 - Do Think Ahead
 
 Bonus! - Do tune to Reduce Logical IO's Not
 Physical IO's.
 (With regards to Cary!)
 
 Oracle Database Top 10 Don'ts
 #1 - Don't Waste Time Re-Organizing Your Databases
 #2 - Don't Use .Log or Other Common Extensions For
 Your Database File Names
 #3 - Don't Leave Your Database Open To Attack
 #4 - Don't Decide Against Hot Backups
 #5 - Don't Use ASSM
 #6 - Don't Forget the 80/20 Rule
 #7 - Don't Stack Views
 #8 - Don't Be a Normalization Bigot
 #9 - Don't Forget to Document Everything
 #10 - Do Not Use Products You are Not Licensed For.
 
 
 Bonus!! - Do Not Assume A Good or Bad Hit Ratio
 Means Anything
 
 Ok, anyone wanna comment?
 
 
 Robert G. Freeman
 Technical Management Consultant
 TUSC - The Oracle Experts www.tusc.com
 904.708.5076 Cell (It's everywhere that I am!)
 Author of several books you can find on Amazon.com!
 

Robert,

   DO #3 and DON'T #7 are developer stuff, not DBA stuff ...
I would gladly replace DO #3 by 'Relentlessly preach good practice to 
developers'. I can hardly talk to a developer without mentioning 
DBMA_APPLICATION_INFO in the first 30 seconds :-).

Regards,

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

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

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

Re: corrupted block

2003-02-24 Thread K Gopalakrishnan

Hi,

If you can afford to forget the data in the corrupted block you can use
the event 10231 to skip the corrupted block during table scan. Set the
event and you can do a CTAS with a new table name and then you can
rename that as original table after dropping the original table.

Here is the syntax:

alter session set events '10231 trace name context forever, level 10'

If you want to see the contents of that skipped blocks, you can use the
event 10232 which dumps the contents of that blocks to the trace files.
And if you are comfortable in reading block dumps, you can write a
simple INSERT statement to put those rows in to the new table.


KG


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

* SHOCK *

You mean someone disagrees with *ME* 

Horrors the world is soon to come to an end!!

:-))

RF

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


-Original Message-
Sent: Monday, February 24, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
comments


MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion 
abt that. Would you mind telling us 'Why you don't agree on them?'


KG

--- dist cash [EMAIL PROTECTED] wrote:
 
 
 I don't agree with don't #1 and #5.
 
 
 
 
 From: Stephane Faroult [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
 list, 
 comments
 Date: Mon, 24 Feb 2003 00:23:37 -0800
 
  Here is the list of top 10 do's and don't that I
  came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
  Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
  Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
  Resources
  #9 - Do Establish Standards and Change Control
  Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
  Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
  Your Database File Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed For.
  
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
  Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
  Technical Management Consultant
  TUSC - The Oracle Experts www.tusc.com
  904.708.5076 Cell (It's everywhere that I am!)
  Author of several books you can find on Amazon.com!
  
 
 Robert,
 
DO #3 and DON'T #7 are developer stuff, not DBA stuff ...
 I would gladly replace DO #3 by 'Relentlessly preach good practice
 to 
 developers'. I can hardly talk to a developer without mentioning 
 DBMA_APPLICATION_INFO in the first 30 seconds :-).
 
 Regards,
 
 Stephane Faroult
 Oriole
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Stephane Faroult
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services

-
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 new MSN 8: advanced junk mail protection and 2 months FREE*  
 http://join.msn.com/?page=features/junkmail
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: dist cash
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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
--

RE: corrupted block

2003-02-24 Thread DENNIS WILLIAMS

Suzy - 
   Here is an article that explains it well. Hopefully this will work with
7.3.4.
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/oramag/16tech.html

Once you get past the immediate crisis, there are a couple of ways to detect
block corruption more quickly.

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


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



I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP

*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Using fully qualified table_name.database_object in

Title: Message



Most 
application developers in my experience are in love with synonyms exactly so 
they won't have to fully qualify the table name. Oracle uses them fairly 
extensively in APPs. They do require some overhead for looking up the 
synonym and they can be a mess if nested deeply enough. Controlling use of 
synonyms on the other hand is a lot like herding cats.

Allan

  
  -Original Message-From: laura pena 
  [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 
  10:29 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Using fully qualified table_name.database_object in application 
  code?
  I would like to know if it is advocated to use fully qualified 
  table_name.database objects in application code.
  Example would be schema.table_name in a PL/SQL code.
  I would like to know the Pros/Cons if there are any?
  Thanks in advance.
  
  
  Do you Yahoo!?Yahoo! 
  Tax Center - forms, calculators, tips, and more

__
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: How long to hold onto old Oracle CDs?

2003-02-24 Thread david davis

How about making them into clocks. I have seen this done. A potential 
revenue source is available. Or drink coasters for the fashionable IT 
person.








From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: How long to hold onto old Oracle CDs?
Date: Mon, 24 Feb 2003 09:19:00 -0800
Yeah, these are actually replacements, too.  But when I ordered them, the
person (back when you could actually talk to a person on a non-level 1 
call)
was surprised that they had any 7.x media in stock.  She had said that they
would distribute the CDs only as long as they had stock.

Maybe I'll make an Oracle Mobile using these CDs and all the Start Here
CDs that come with every pack.  At least I won't be throwing them out...  
:)

Thx!
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Monday, February 24, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Actually the CD's are available. You just have to request them from Oracle.
Of course, this does depend upon having a support contract.
Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to
cracked media.
From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How long to hold onto old Oracle CDs?
Date: Mon, 24 Feb 2003 06:58:58 -0800

Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
been at 8.1.7 for 18 months now.  I can't think of a good reason, other
than
the software isn't available anymore.

Anybody want some old CDs?  :)

Rich

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


_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: david davis
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list,

2003-02-24 Thread Jamadagni, Rajendra

Title: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,





Another Do's ...


0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom.


Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!



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: Top 10 DBA Do's and Don'ts anyone - Here is my list,

Oo, that *IS* a good one May need to add that to the list
somewhere somehow.

RF

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


-Original Message-
Sent: Monday, February 24, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L


You brought to mind another one... DON'T assume that changes in one
environment will have the same impact across all environments so DO
test the impact of any change in all environments that you can, before
implementing it in production. We had a change go in to the dev
environment that fixed the performance problem there. Unfortunately, it
made performance fall through the floor in test, which was closer to
the production environment in data volume. Fortunately it was caught
before it went into production.


--- Cary Millsap [EMAIL PROTECTED] wrote:
 You guys are very kind, thank you.
 
 My LIO vs PIO thesis is this:
 
 1. Too many PIOs *is* a bad thing.
 2. But eliminating unnecessary PIOs isn't enough. Even completely
 memory-resident databases can perform horribly (not scale, consume
 dozens of hours per query, etc.)
 3. If you begin by eliminating unnecessary LIOs first, then you often
 eliminate all the PIOs you needed to eliminate, by side-effect.
 
 About the Top-10 list, I'll add...
 
 DON'T do something to make the system faster until you understand
 the
 impact that your proposed activity will have upon the response time
 of
 your important user actions. (Some proposed activities create
 negligible
 impact, and some even create negative impact. When you try those
 activities that don't create sufficient *positive* impact, then you
 *waste* your company's resources.)
 
 DO learn how to figure out--quickly, accurately, and
 inexpensively--the
 impact of a proposed activity upon end-user response time.
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 25-27 London
 
 
 -Original Message-
 Landrum
 Sent: Sunday, February 23, 2003 5:49 PM
 To: Multiple recipients of list ORACLE-L
 
 Yes, regarding these 3, how can they be considered absolute do's or
 don'ts?
 I didn't take Cary's material to mean ignore physical IO's but rather
 to
 show the importance and impact of logical IO's.  Too many PIOs could
 still be an issue.
 (I would say maybe Cary could speak to this, but I'd rather him spend
 that time on his book, which I'll be ordering as soon as it's
 available.)
 The others have their places as well.  I wouldn't practice or preach
 that bind variables are always, always the right way (usually, but
 not
 always).
 Why not ASSM?  Surely, there could be circumstances where ASSM is a
 good
 way, or at least ok.
 Do Use Bind Variables
 Do tune to Reduce Logical IO's Not Physical IO's.
 Don't Use ASSM
 
 Please consider, Robert, that I'm not challenging your list as these
 may
 be very good rules to live by.  I don't usually take any 'rule' as
 hard
 and fast until I can test it, but there may be others reading the
 list
 that would benefit greatly to understand why these things should or
 should not be done.
 Thanks for your input, it helps us all learn.
 
 Darrell Landrum
 
 
 
  [EMAIL PROTECTED] 02/23/03 04:23PM 
 Here is the list of top 10 do's and don't that I came up with.
 
 #1 - Do Maintain your Expertise
 #2 - Do Use the DBMS_STATS Package to Collect Statistics
 #3 - Do Use Bind Variables
 #4 - Do Put your Production Database in ARCHIVELOG Mode
 #5 - Do Use Locally Managed Tablespaces
 #6 - Do Monitor Your Database
 #7 - Do Practice Recoveries
 #8 - Do Get Involved with User Groups and Other Resources
 #9 - Do Establish Standards and Change Control Processes
 #10 - Do Think Ahead
 
 Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
 (With regards to Cary!)
 
 Oracle Database Top 10 Don'ts
 #1 - Don't Waste Time Re-Organizing Your Databases
 #2 - Don't Use .Log or Other Common Extensions For Your Database File
 Names
 #3 - Don't Leave Your Database Open To Attack
 #4 - Don't Decide Against Hot Backups
 #5 - Don't Use ASSM
 #6 - Don't Forget the 80/20 Rule
 #7 - Don't Stack Views
 #8 - Don't Be a Normalization Bigot
 #9 - Don't Forget to Document Everything
 #10 - Do Not Use Products You are Not Licensed For.
 
 Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
 
 Ok, anyone wanna comment?
 
 
 Robert G. Freeman
 Technical Management Consultant
 TUSC - The Oracle Experts www.tusc.com 
 904.708.5076 Cell (It's everywhere that I am!)
 Author of several books you can find on Amazon.com!
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net 
 -- 
 Author: Freeman Robert - IL
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
 San Diego, California-- Mailing list and web hosting services

Re: corrupted block

2003-02-24 Thread PAUL.HOOD

Hi Suzi,
The first thing I would suggest is to determine if it is actualy in use by the database (ie allocated to an object)... dbv has an "os perspective" on the file and hence does not understand what objects contain what blocks. Metalink note Doc ID: 28814.1 has some good basic information on block corruptions as well.
A query such as:
SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id = AFN and BL between block_id AND block_id + blocks - 1;
will help to answer this first question... once that question is answered, you can move on to other options (what do do about it)... Perhaps it is simply an index and can be dropped / recreated... If not, the note discussed various ways to extract the good data in the case of a table. (dbms_repair, events, select using rowids to exclude the block,etc)
There is also always the question of why. In this case it may be quite difficult to figure out why based on its existence for some time.
Additions and corrections welcomed!
Regards,
Paul
I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). Last night I analyzed the tables and a corrupted block was found. Iknow which table and datafile it is, and it's the only table in theaffected tablespace. The database is in archivelog mode so I can recover the datafile, but Iam not certain when the block corruption occurred. There were noproactive measures in place to quickly report a corrupted block. So Iassume it may have been there a long time, and was just found throughanalyze (tables hadn't been analyzed since Dec-2000). So my question is, if all backups contain the corrupted block, how wouldI copy all non-corrupted blocks from this table into a new table? Here is the trace file:ORACLE data block corrupted (file # 24, block # 57856)Dump file/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trcOracle7 Server Release 7.3.4.3.0 - ProductionWith the distributed, replication, parallel query and Spatial DataoptionsPL/SQL Release 2.3.4.3.0 - ProductionORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4System name: SunOSNode name: kanadb-co1Release: 5.6Version: Generic_105181-17Machine: sun4uInstance name: kana03aPRedo thread mounted by this instance: 1Oracle process number: 10Unix process pid: 13163, image: oraclekana03aP*** 2003.02.24.02.49.42.000*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000***Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found duringbuffer readon disk type:0. ver:0. dba: 0x inc:0x seq:0xincseq:0xEntire contents of block is zero - block never writtenReread of block=6000e200 file=24. blocknum=57856. found same corupteddata-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Suzy VordosINET: [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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Good one for the don't list. I suppose that the ARCHIVELOG mode question
depends on the situation, but for the most part I think ARCHIVELOG mode in
production is a good do...
Granted, if you don't have changes, then as long as you can stand the
outage, then you 
can do cold backups.

:-)

RF

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


-Original Message-
Sent: Monday, February 24, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
comments



#4 on the Do list assumes that you are an On-Line Transaction Process
database.  If you are a Decision Support database, then ARCHIVELOG is not
needed.  But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode.  #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)

My #1 don't is never, ever delete an OS file.  Rename it, wait a week, and
if everything is still running OK then delete the renamed file.



 

  Freeman Robert -

  IL FREEMANR To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  @tusc.com   cc:

  Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments  
 

 

  02/23/2003 05:23

  PM

  Please respond

  to ORACLE-L

 

 





Here is the list of top 10 do's and don't that I came up with.

#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead

Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
(With regards to Cary!)

Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.

Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything

Ok, anyone wanna comment?


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

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

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






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

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

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

Re: SqlNet Response ports

2003-02-24 Thread Regina Harter

Redhat Linux 7.2

At 07:28 PM 2/21/2003 -0800, you wrote:
What platform is this?  Windows?

Don Granaman
OraSaurus
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 5:48 PM
 Hi listers,

 Here is a question my client asked me, that I can't seem to find the
answer
 to on metalink, mostly because I am not sure how to frame the search
 query.  If you don't know what NMCI is, just know that it is a government
 program that is establishing control over the network which our database
 servers are on.  Anyone have any ideas or advice for me?

 TIA, Regina

 Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t
allow
 inbound/outbound 1521 traffic (SQLNET).  Hence, no NMCI user would be able
 to use any client/server application.  Wow, that s a major problem.  There
 are a few possible solutions.

 1.  Configure the database server to listen on port 443, because NMCI
 allows 443.  But, SQLNET uses random high order ports on the
 return.  Anybody know if you can configure SQLNET to use only 443 on the
 response?

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

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Don Granaman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Regina Harter
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: corrupted block

2003-02-24 Thread Suzy Vordos


Thanks Kirti.  Interesting, dba_extents doesn't return rows for
block_id=57856.  However, export to /dev/null does report the
corruption.  Does this indicate disk or memory corruption?

Deshpande, Kirti wrote:
 
 Suzy,
  Just more questions:
  Are your sure that this corruption has made it to the disk? It could be memory 
 related.
  Can you export the table to /dev/null to double check the corruption?
  What do you get when reading that particular block using dba_extents?
 
 - Kirti
 
 
 
 -Original Message-
 Sent: Monday, February 24, 2003 10:09 AM
 To: Multiple recipients of list ORACLE-L
 
 I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade).
 Last night I analyzed the tables and a corrupted block was found.  I
 know which table and datafile it is, and it's the only table in the
 affected tablespace.
 
 The database is in archivelog mode so I can recover the datafile, but I
 am not certain when the block corruption occurred.  There were no
 proactive measures in place to quickly report a corrupted block.  So I
 assume it may have been there a long time, and was just found through
 analyze (tables hadn't been analyzed since Dec-2000).
 
 So my question is, if all backups contain the corrupted block, how would
 I copy all non-corrupted blocks from this table into a new table?
 
 Here is the trace file:
 
 ORACLE data block corrupted (file # 24, block # 57856)
 
 Dump file
 /dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
 Oracle7 Server Release 7.3.4.3.0 - Production
 With the distributed, replication, parallel query and Spatial Data
 options
 PL/SQL Release 2.3.4.3.0 - Production
 ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
 System name:SunOS
 Node name:  kanadb-co1
 Release:5.6
 Version:Generic_105181-17
 Machine:sun4u
 Instance name: kana03aP
 Redo thread mounted by this instance: 1
 Oracle process number: 10
 Unix process pid: 13163, image: oraclekana03aP
 
 *** 2003.02.24.02.49.42.000
 *** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
 ***
 Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
 buffer read
 on disk type:0. ver:0. dba: 0x inc:0x seq:0x
 incseq:0x
 Entire contents of block is zero - block never written
 Reread of block=6000e200 file=24. blocknum=57856. found same corupted
 data
 --
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Deshpande, Kirti
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Using fully qualified table_name.database_object in application code?

2003-02-24 Thread Wayne Straughn





  One 
  possibledisadvantage is thatyour apps are then 'tied' to a 
  particular schema... if you wanted to run
  them against another 
  schema, you would have to go back and modify 
  everything...
  
  To get around 
  this:
  You could create public 
  synonyms pointingto aparticular schema'stables 
  so if a reason ever arose to
  switch schema you'd only 
  have tomodify one set of code...your public synonym 
  script.
  
  Wayne 
  Straughn

  -Original Message-From: 
  laura pena [mailto:[EMAIL PROTECTED]Sent: Monday, February 
  24, 2003 12:29 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Using fully qualified table_name.database_object 
  in application code?
  I would like to know if it is advocated to use fully qualified 
  table_name.database objects in application code.
  Example would be schema.table_name in a PL/SQL code.
  I would like to know the Pros/Cons if there are any?
  Thanks in advance.
  
  
  Do you Yahoo!?Yahoo! 
  Tax Center - forms, calculators, tips, and more

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Adams, Matthew (GECP, MABG, 088130)

Title: RE: How long to hold onto old Oracle CDs?





Two months ago, I tried to order older non-supported 
CDs (7.3, 8.0.5, 8.0.6) and they told me
they could not ship them.


How did you order them?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: david davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: How long to hold onto old Oracle CDs?



Actually the CD's are available. You just have to request them from Oracle. 
Of course, this does depend upon having a support contract.


Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to 
cracked media.



From: Jesse, Rich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How long to hold onto old Oracle CDs?
Date: Mon, 24 Feb 2003 06:58:58 -0800

Hey all,

Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've
been at 8.1.7 for 18 months now. I can't think of a good reason, other 
than
the software isn't available anymore.

Anybody want some old CDs? :)

Rich

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

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



_
Help STOP SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


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


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 normalised down to Top 2

I bow at the feet of the master.

:-)

Very good sir 

RF

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


-Original Message-
Sent: Monday, February 24, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


I have to admit my list is considerably smaller:

DO:

#1: Listen, Think, Learn, Communicate
#2: Have a passion for what you do.  If its just a
job, then you're in the wrong one.

DON'T:
#1: Do the opposite of the Do's

Cheers
Connor

 --- Rachel Carmichael [EMAIL PROTECTED] wrote:
 You brought to mind another one... DON'T assume that
 changes in one
 environment will have the same impact across all
 environments so DO
 test the impact of any change in all environments
 that you can, before
 implementing it in production. We had a change go in
 to the dev
 environment that fixed the performance problem
 there. Unfortunately, it
 made performance fall through the floor in test,
 which was closer to
 the production environment in data volume.
 Fortunately it was caught
 before it went into production.
 
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  You guys are very kind, thank you.
  
  My LIO vs PIO thesis is this:
  
  1. Too many PIOs *is* a bad thing.
  2. But eliminating unnecessary PIOs isn't enough.
 Even completely
  memory-resident databases can perform horribly
 (not scale, consume
  dozens of hours per query, etc.)
  3. If you begin by eliminating unnecessary LIOs
 first, then you often
  eliminate all the PIOs you needed to eliminate, by
 side-effect.
  
  About the Top-10 list, I'll add...
  
  DON'T do something to make the system faster
 until you understand
  the
  impact that your proposed activity will have upon
 the response time
  of
  your important user actions. (Some proposed
 activities create
  negligible
  impact, and some even create negative impact. When
 you try those
  activities that don't create sufficient *positive*
 impact, then you
  *waste* your company's resources.)
  
  DO learn how to figure out--quickly, accurately,
 and
  inexpensively--the
  impact of a proposed activity upon end-user
 response time.
  
  
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
  
  Upcoming events:
  - RMOUG Training Days 2003, Mar 5-6 Denver
  - Hotsos Clinic 101, Mar 25-27 London
  
  
  -Original Message-
  Landrum
  Sent: Sunday, February 23, 2003 5:49 PM
  To: Multiple recipients of list ORACLE-L
  
  Yes, regarding these 3, how can they be considered
 absolute do's or
  don'ts?
  I didn't take Cary's material to mean ignore
 physical IO's but rather
  to
  show the importance and impact of logical IO's. 
 Too many PIOs could
  still be an issue.
  (I would say maybe Cary could speak to this, but
 I'd rather him spend
  that time on his book, which I'll be ordering as
 soon as it's
  available.)
  The others have their places as well.  I wouldn't
 practice or preach
  that bind variables are always, always the right
 way (usually, but
  not
  always).
  Why not ASSM?  Surely, there could be
 circumstances where ASSM is a
  good
  way, or at least ok.
  Do Use Bind Variables
  Do tune to Reduce Logical IO's Not Physical IO's.
  Don't Use ASSM
  
  Please consider, Robert, that I'm not challenging
 your list as these
  may
  be very good rules to live by.  I don't usually
 take any 'rule' as
  hard
  and fast until I can test it, but there may be
 others reading the
  list
  that would benefit greatly to understand why these
 things should or
  should not be done.
  Thanks for your input, it helps us all learn.
  
  Darrell Landrum
  
  
  
   [EMAIL PROTECTED] 02/23/03 04:23PM 
  Here is the list of top 10 do's and don't that I
 came up with.
  
  #1 - Do Maintain your Expertise
  #2 - Do Use the DBMS_STATS Package to Collect
 Statistics
  #3 - Do Use Bind Variables
  #4 - Do Put your Production Database in ARCHIVELOG
 Mode
  #5 - Do Use Locally Managed Tablespaces
  #6 - Do Monitor Your Database
  #7 - Do Practice Recoveries
  #8 - Do Get Involved with User Groups and Other
 Resources
  #9 - Do Establish Standards and Change Control
 Processes
  #10 - Do Think Ahead
  
  Bonus! - Do tune to Reduce Logical IO's Not
 Physical IO's.
  (With regards to Cary!)
  
  Oracle Database Top 10 Don'ts
  #1 - Don't Waste Time Re-Organizing Your Databases
  #2 - Don't Use .Log or Other Common Extensions For
 Your Database File
  Names
  #3 - Don't Leave Your Database Open To Attack
  #4 - Don't Decide Against Hot Backups
  #5 - Don't Use ASSM
  #6 - Don't Forget the 80/20 Rule
  #7 - Don't Stack Views
  #8 - Don't Be a Normalization Bigot
  #9 - Don't Forget to Document Everything
  #10 - Do Not Use Products You are Not Licensed
 For.
  
  Bonus!! - Do Not Assume A Good or Bad Hit Ratio
 Means Anything
  
  Ok, anyone wanna comment?
  
  
  Robert G. Freeman
  Technical Management Consultant
  TUSC - The Oracle

Re: Upgrading from 8.1.5 to 8.1.6

2003-02-24 Thread Joan Hsieh

The best pratice is rename the old directory to a new name and wait to
see if you have problem.

joan

Nelson, Allan wrote:
 
 It depends on whether or not you are talking about your old
 $ORACLE_HOME.  You may still have shared lib dependancies there.  You
 don't give enough information in your post to be absolutely certain so
 you might consider relinking if this is the case.
 
 -Original Message-
 Sent: Monday, February 24, 2003 9:34 AM
 To: Multiple recipients of list ORACLE-L
 
 After upgrading oracle database from V8.1.5 to V8.1.6, a new directory
 is created to store new version's files and the old directory of old
 version 8.1.5 is still there.  Is is safe to remove the old directory to
 save disk spaces on the disk?  Is there any files being linked to the
 old version after upgrading?
 
 Regards,
 David
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nguyen, David M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
 message BODY, include a line containing: UNSUB ORACLE-L (or the name of
 mailing list you want to be removed from).  You may also send the HELP
 command for other information (like subscribing).
 
 __
 This email is intended solely for the person or entity to which it is addressed and 
 may contain confidential and/or privileged information.  Copying, forwarding or 
 distributing this message by persons or entities other than the addressee is 
 prohibited. If you have received this email in error, please contact the sender 
 immediately and delete the material from any computer.  This email may have been 
 monitored for policy compliance.  [021216]
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Nelson, Allan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: installation / recovery question

2003-02-24 Thread Jared Still


Antje,

Have you ever completely removed Oracle from a Windoze machine
and gone throught the consequent cleanup of the registry?

If not, MetaLink document 124353.1 describes the process.  There
are many more entries for Oracle in the registry for than what you
will see in HKLM\Oracle.

I mention this because I see someone has responded that you just
export/import the Oracle registry key, but that won't likely work.

Just reinstall Oracle, it's much safer.

Jared


On Monday 24 February 2003 00:38, [EMAIL PROTECTED] wrote:
 Hi all,
 I have a test installation of Oracle 817 and 902 on my PC - installed
 completly on a device other than system device.
 Now my computer is getting  buggy (well it's Win2k on it) so the sysadmin
 want's to reinstall the system device.
 Is there any way to save the registry entries for Oracle and recover them
 when the new installtion on system device is done?
 Can I export the entries in a .reg file and merge that into my new registry
 when sysadmin is done? Or do I have to reinstall Oracle software and how to
 I preserve my databases?
 Any suggestions/hints/warnings are welcome.

 Regards,
 Antje Sackwitz

 
   Antje Sackwitz
   ppi Media GmbH
   Deliusstraße 10
   D-24114 Kiel
   phone   +49 (0) 43 1-53 53-2 16
   fax +49 (0) 43 1-53 53-2 22
   email   mailto:[EMAIL PROTECTED]
   web www.ppi.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

Re: corrupted block

2003-02-24 Thread Daniel W. Fink

Suzy,
   The big question is whether or not the block actually contains data. 
It appears that it does not, if I am reading the last few lines 
correctly. This means you are in luck. Use a non-full table scan query 
to extract the data, drop the tablespace and remove the datafile. 
Recreate the tablespace/datafile/table/indexes and reload the data. I 
would also recommend having the physical disk(s) checked to see if it is 
a physical problem.
   Why a non-full table scan? It will read all of the blocks (used or 
empty) below the high water mark, much like the analyze has done (I 
think). The block indicated is empty, but below the highwatermark, so it 
will be read (or attempted) in a full table scan. This will then cause 
the fts to fail. Using an index will cause only the populated blocks to 
be read.

Dan FInk

Suzy Vordos wrote:

I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). 
Last night I analyzed the tables and a corrupted block was found.  I
know which table and datafile it is, and it's the only table in the
affected tablespace.  

The database is in archivelog mode so I can recover the datafile, but I
am not certain when the block corruption occurred.  There were no
proactive measures in place to quickly report a corrupted block.  So I
assume it may have been there a long time, and was just found through
analyze (tables hadn't been analyzed since Dec-2000).  

So my question is, if all backups contain the corrupted block, how would
I copy all non-corrupted blocks from this table into a new table?  

Here is the trace file:

ORACLE data block corrupted (file # 24, block # 57856)

Dump file
/dbms/ora00/app/oracle/admin/kana03aP/udump/kana03ap_ora_13163.trc
Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.3.0 - Production
ORACLE_HOME = /dbms/ora00/app/oracle/product/7.3.4
System name:SunOS
Node name:  kanadb-co1
Release:5.6
Version:Generic_105181-17
Machine:sun4u
Instance name: kana03aP
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 13163, image: oraclekana03aP
*** 2003.02.24.02.49.42.000
*** SESSION ID:(24.1317) 2003.02.24.02.49.41.000
***
Corrupt block dba: 0x6000e200 file=24. blocknum=57856. found during
buffer read
on disk type:0. ver:0. dba: 0x inc:0x seq:0x
incseq:0x
Entire contents of block is zero - block never written
Reread of block=6000e200 file=24. blocknum=57856. found same corupted
data
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments