RE: Toad vs SQL Navigator

[Christopher Spence]

Take a look at PL/SQL Developer from All Around Automations, much better
than both of them, and a lot cheaper.

But Toad is kind of a better product for the money (750 vrs 5000).
Navigator is severely overpriced.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, November 01, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L

Hi All,

We are looking at purchasing TOAD or SQL Navigator from Quest. I think they
have purchase EZSQL also which I liked(good and cheap). I guess there goal
is to
eliminate the competition.  I have some experience with free version of TOAD
but not with SQL Navigator.
Can someone share there pros/cons,why purchase one over the other, etc. if
they have used both of these products?


Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: OT : from Win XP to RDRAM or SDRAM ?

[Christopher Spence]

AX:
(858) 538-5051
San Diego, California-- Public Internet access
/ Mailing Lists

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

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

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

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

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

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

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

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


=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Courrier : http://courrier.yahoo.fr
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: RE: Win XP

[Christopher Spence]

1.  Corporate Edition does not have the validation piece.  Only serial
number

2.  The validation has already been hacked and not even valid anymore, even
though it will still prevent 90% of the population.


I don't see why they spend so much money on validation when it will just be
cracked.  It just ups the price of the product for everyone.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 3:33 PM
To: Multiple recipients of list ORACLE-L

Remember
XP can only be used on ONE machine. It takes a branding and authorization
code from M$$$ to activate it. If by chance you get around the activation
code it will be checked when you go to the internet and against a master
table that M$$$ has. If it is an unauthorized "copy" then you are breaking
the law and on your own. M$$$ can then prosecute if they desire.  We have a
10 machine development license and each machine has to have a different
authorization code from M. The machine branding is dependent upon the
hardware making up the machine.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 02:20PM >>>
More realistic pricing ("street value"):

http://www.bestbuy.com/software/promo.asp?m=1023&Cat=1807&p=1807 

But for my money:

http://www.linux.org :D


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

-Original Message-
Sent: Monday, October 29, 2001 12:20
To: Multiple recipients of list ORACLE-L


IS THIS REAL?  They charge this much for XP?  
Lisa Koivu 
Oracle Database Monkey 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

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

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

RE: Win XP

[Christopher Spence]

I don't know about servers and with oracle, but XP for my game/workstation
made a huge improvement, it is faster, some Win2000 bugs went away, more
throughput.

Although 8.1.7 seems to be running fine when I do it development, nothing
heavy.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 10:35 AM
To: Multiple recipients of list ORACLE-L


Not until MS comes out with at least 3 SPs.  It doesn't have Uncle Larry's
blessing yet, does it?  (not that it means anything)

I was in Radio Shack this weekend.  I went over to the big monitor that was
connected to a box running the new and improved XP.  It had a large window
on it that said "DEMO.exe has caused an error...and will terminate".  I
laughed and laughed.  Then laughed some more and went home.

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

-Original Message-
Sent: Sunday, October 28, 2001 23:00
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

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

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

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

RE: Win XP

[Christopher Spence]

Win200 is like two years old.  2 years is nothing.
Cars come out every 1 year.   
Most software has 6-12 month releases.

Granted it is more difficult for the OS.  I think it would be better if they
fixed bugs rather than replace it.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L

I have not seen win2K yet!

It's amazing how we get a new O/S version every year from Windows!

I think O/S should be only a stable plain simple O/S with nothing fancy and
all the fancy things should be third party applications by other companies
not the same company!

-Original Message-
Sent: Monday, October 29, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

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

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

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

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

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

RE: Win XP

[Christopher Spence]

Considering you can get 512Mb chips for $30 or so, everyone should.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L

Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

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

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

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

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

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

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

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

RE: Java in the database

[Christopher Spence]

Actually the 5x faster is a third party
benchmark for Orion Server before it was intergrated with Oracle.

 

I forget who did the benchmark, but it is
on www.orionserver.com

 

 

They compared Web Logic, Tomcat, Ressin,
Orion, and I believe one other.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 26, 2001
4:18 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Java in the database

 



Christopher-





 





Do you have first-hand experience
with the performance of Orion, either within iAS or as a stand-alone servlet
engine?  The '5x faster' seems to come from an Oracle source, which I
suspect is referring to Java stored and executed within Oracle.  I'm not
sure whether Orion as a stand-alone product can make the same claim.  Then
again I'm a DBA, not an experienced Java developer, and am finding it a bit
confusing to wade thru the alphabet soup.





 





I have a 3rd-party app to install
that needs 'any J2EE-compliant' java servlet engine.  I'm looking for
something that will provide good scalability at a good price.  The price
is right, if Orion scales well then maybe I won't need iAS for this server
since I don't need all the other goodies that comes along with it.  If you
have any real-world indications of scalability I'd appreciate hearing from
you.  Thanks.





 





Jim







>>> [EMAIL PROTECTED] 10/26/01 02:51PM >>>





Take a look at OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than Web
Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core now.

 

 



"Do not criticize someone
until you walked a mile in their shoes, that way when you criticize them, you
are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 26, 2001
9:50 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Java in the database

 



Jan-





 





I've heard some concerns about the scalability of Tomcat as
an app server.  Of course, some of those concerns are voiced by guys like
Oracle and BEA who have a nice little Java engine to sell you for $10-20K per
CPU.  I know a lot of people use Tomcat for prototypes and such, then go
with one of the big boys for the production system.  Have you - or anyone
else - had Tomcat working in a production environment with, say, 100-200
concurrent users?  Thanks.





 





Jim

>>> [EMAIL PROTECTED] 10/26/01 08:35AM >>>



PL/SQL. 
Java code only on Tomcat-Jakarta (Apache). 

JP 

On Thu 25. October 2001 19:16, you wrote: 
> Out of curiosity, is anyone using the java engine for procedural code, or 
> are most people still using PL/SQL? 
> 
> Regards, 
> Patrice Boivin 
> Systems Analyst (Oracle Certified DBA) 
> 
> Systems Admin & Operations | Admin. et Exploit. des syst?mes 
> Technology Services    | Services
technologiques 
> Informatics Branch |
Direction de l'informatique 
> Maritimes Region, DFO  | Région des
Maritimes, MPO 
> 
> E-Mail: [EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author: Jan Pruner 
  INET: [EMAIL PROTECTED] 

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

RE: Java in the database

[Christopher Spence]

OrionServer runs on almost any platform as it is pure java.  So not sure I buy the 'supports
more os's' comment.

 

Orion has been tested on the following
platforms: 


 
  Windows
  95/98/NT/2000 
  Sparc Solaris 
  Linux
  
  FreeBSD
  4.x 
  AS/400
  
  HP-UX
  (with classic vm) 
 


 

Is the ones they tried, but I am sure
there would be few problems with most any OS that supports java.

So I am not sure where you got that from.

 

 

Granted, I will agree Web Logic has more
features, but does not necessarily mean you need them all, for example their
JMS implementation sucks.  

 

Keep in mind Orion server was the first
J2EE commercial product, 



 

"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Marin Dimitrov
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 29, 2001 4:00 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Java in the database

 



 







- Original Message - 





From: Christopher
Spence 





To: Multiple
recipients of list ORACLE-L 





Sent: Friday,
October 26, 2001 20:51





Subject: RE: Java in
the database





 



Take a look at
OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than
Web Logic, I would wonder why people would use others.

 

 











 





Perhaps because WebLogic has more features,
supports more OSes and is J2EE certified? 





 





you may take a look at http://www.flashline.com/components/appservermatrix.jsp and






http://win-www.uia.ac.be/~s985218/professional/thesis/archief/documenten/Marktoverzicht.doc





 





 





hth,





 





    Marin







"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "





 

RE: Java in the database

[Christopher Spence]

Actually I believe it will be, in 9i they clearly made some improvements
(very notable ones) in PL/SQL.  I would suspect it will be around for a
while.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 25, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L

Still PL/SQL.
Hope, it will be supported long enough. (till my retirement? :)

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 1:16 PM


Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

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

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

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

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

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

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

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

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

RE: Java in the database

[Christopher Spence]

Take a look at OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than Web
Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core now.

 

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 26, 2001
9:50 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Java in the database

 



Jan-





 





I've heard some concerns about the
scalability of Tomcat as an app server.  Of course, some of those concerns
are voiced by guys like Oracle and BEA who have a nice little Java engine to
sell you for $10-20K per CPU.  I know a lot of people use Tomcat for
prototypes and such, then go with one of the big boys for the production
system.  Have you - or anyone else - had Tomcat working in a production
environment with, say, 100-200 concurrent users?  Thanks.





 





Jim

>>> [EMAIL PROTECTED] 10/26/01 08:35AM >>>



PL/SQL. 
Java code only on Tomcat-Jakarta (Apache). 

JP 

On Thu 25. October 2001 19:16, you wrote: 
> Out of curiosity, is anyone using the java engine for procedural code, or 
> are most people still using PL/SQL? 
> 
> Regards, 
> Patrice Boivin 
> Systems Analyst (Oracle Certified DBA) 
> 
> Systems Admin & Operations | Admin. et Exploit. des syst?mes 
> Technology Services    | Services
technologiques 
> Informatics Branch |
Direction de l'informatique 
> Maritimes Region, DFO  | Région des
Maritimes, MPO 
> 
> E-Mail: [EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author: Jan Pruner 
  INET: [EMAIL PROTECTED] 

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

RE: Java in the database

[Christopher Spence]

So a huge Trading exchange written in Perl?  
Not sure about that.  Perl is cool, but I couldn't see it used for
everything.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 25, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L


PL/SQL in the database, Perl everywhere else.

Jared



 

"Boivin, Patrice

J"  To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]   cc:

mpo.gc.ca>  Subject: Java in the
database  
Sent by:

[EMAIL PROTECTED]

 

 

10/25/01 10:16 AM

Please respond to

ORACLE-L

 

 





Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

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

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

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




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

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

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

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

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

RE: RAID for a development box

[Christopher Spence]

If you have a Raid 0 of 6 drives and set a strip size to be 16K, then the
girth (or commonly referred to as stripe width) is 16k x 6 or 96K, if you
write less than 96K you will only use some of the drives.  With a write-back
caching controller it can hold writes to speed transactions but also to be
more efficient with the writes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 24, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L

"use the girth" -- I'd love to pretend that I knew what this means but
someone might call me on it.  What does it mean?  Each drive is 36G.



 

    Christopher

    Spence   To: Multiple recipients of list
ORACLE-L  


@FuelSpot.comcc:

>Subject: RE: RAID for a
development box   
Sent by: root

 

 

10/24/2001

12:25 PM

Please

respond to

ORACLE-L

 

 





On my NT Quad Development box I have 9x2 Raid 1 for OS/Oracle Files.

Then Raid 0+1 for the 6 drives for data.  It isn't perfect, but works good.
If you do raid 0 with 6 drives, make sure you look into a good stripe size
so you actually use the girth.  Otherwise 0+1,1+0 may be a better option.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Wednesday, October 24, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L

We're setting up a development box that will have a number of instances on
it.  We won't need any backup, since we can easily re-create the databases
from testing instances.

I'm planning on implementing the disk storage as RAID0 - a single logical
volume stripped across all the drives (6), with the stripe size set to the
OS (Win2K) block size.  We will only have 4 or 5 developers on the box at
any one time and I want to maximize IO utilization.

Any "heads up" here?

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

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

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

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

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


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling

RE: RAID for a development box

[Christopher Spence]

On my NT Quad Development box I have 9x2 Raid 1 for OS/Oracle Files.

Then Raid 0+1 for the 6 drives for data.  It isn't perfect, but works good.
If you do raid 0 with 6 drives, make sure you look into a good stripe size
so you actually use the girth.  Otherwise 0+1,1+0 may be a better option.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 24, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L

We're setting up a development box that will have a number of instances on
it.  We won't need any backup, since we can easily re-create the databases
from testing instances.

I'm planning on implementing the disk storage as RAID0 - a single logical
volume stripped across all the drives (6), with the stripe size set to the
OS (Win2K) block size.  We will only have 4 or 5 developers on the box at
any one time and I want to maximize IO utilization.

Any "heads up" here?

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

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

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

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

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

RE: How long are statistics good for

[Christopher Spence]

Statistics become old after a single change is made to the object.

Granted adding a single row to a 1 Million row table isn't going to effect
much.  But adding 100,000 rows will.  So where do you draw the line?

I really don't know.  But 5%-10% is generally a good measure. 
Sometimes more sometimes less depending on the size.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 23, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L

We have a data-warehouse that is a combination of Snapshots and table-builds
based on the snapshots.

The table builds run at 4:30 am, scripts are setup to start the snapshots at
7:00am and end 
at 9:00pm.  At 6:30 am a script performs an analyze on ALL (except sys and
system) tables in
the database.

If the snapshots have been running all day, should I run an analyze before I
do the table builds?
as opposed to after ?

At what point do the statistics on a table become no good ? when a new row
is added ?

Thanks

Darren




--
Darren Browett P.EngThis message
was transmitted
Systems Analyst - Information Systems   using 100%
recycled electrons 
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


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

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

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

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

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

RE: Which RAID level do you use?

[Christopher Spence]

For 1TB and only having 20 spindles, I doubt many people would chose 100Gb
drives for an Oracle database unless it was just huge.


$20,000 isn't much for 1Tb solution, but you haven't taken in account your
enclosure, any enclosure that would handle 20 drives, hot swap and most
likely multiple connections for multiple controllers would probably be
$5-$10k.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L

oh yea, 20K plus cabinet and cablingthat IS 
too much for a TERABYTE of storage. 

What was i thinking?



-Original Message-
Sent: Friday, October 19, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L


Then mirror it for an additional 10K

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L

"RAID 1 is fine if you have infinite storage (read: Infinite Budget).
Try buying an extra TB of disk just for the fun of it and see what
your budget committee does to you :-)"


Kind of agree.Get an IBM Deskstar model...close to 100 GBbuy
ten at maybe, what? a grand each..and VOILA a terabyte for about
10K. 

Not exactly "infinite budget"!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

RE: Which RAID level do you use?

[Christopher Spence]

Then mirror it for an additional 10K

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L

"RAID 1 is fine if you have infinite storage (read: Infinite Budget).
Try buying an extra TB of disk just for the fun of it and see what
your budget committee does to you :-)"


Kind of agree.Get an IBM Deskstar model...close to 100 GBbuy
ten at maybe, what? a grand each..and VOILA a terabyte for about
10K. 

Not exactly "infinite budget"!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Little Brother Larry sorta ON topic

[Christopher Spence]

ery terrorist that is caught, there will be 1000
false alarms. That's crying wolf too often for anyone to take it
seriously. And, in the real world, the system isn't anywhere even *near*
99.99% accurate. Change it down to 95% and run the numbers...

The solution isn't technological at all, but technological solutions are
a "magic bullet" used by people too "liberal" to face up to the fact
that WASP grandmothers from the Midwest don't hijack airliners, but
there is an easily recognizable subset of the world's population who do
seem to produce most of the world's hijackers.

g

-Original Message-
Sent: Wednesday, October 17, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L

Yeah, but what if you were the DBA for that database?  ;-)

The article did say that some "prominent civil libertarians" were not
completely averse to the idea. The ID card would only be mandatory for
non-citizens and voluntary for citizens. I confess that as a recovering
libertarian I'm conflicted. We already have to prove our identity for
social
security cards and  driver's licenses (to a lessor degree and varying by
state). A national plan would just be taking a situation that already
exists
and making it bigger and more effecient. ;-| Of course what's voluntary
today can more easily become mandatory tomorrow.

Hmmm... I wonder what the support fees would be for such a "beast?"  ;-)


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

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

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

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

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

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

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

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

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

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

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

RE: Little Brother Larry sorta ON topic

[Christopher Spence]

I confess that as a recovering
libertarian I'm conflicted. We already have to prove our identity for
social
security cards and  driver's licenses (to a lessor degree and varying by
state). A national plan would just be taking a situation that already
exists
and making it bigger and more effecient. ;-| Of course what's voluntary
today can more easily become mandatory tomorrow.

Hmmm... I wonder what the support fees would be for such a "beast?"  ;-)


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

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

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

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

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

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

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

RE: Uncle Larry in the news

[Christopher Spence]

I agree 100% in using it, but I fear that it will be abused and we will
loose rights unjustly by it going overboard.

But used as described it great.  I actually would go so far as a small chip
in your wrist.  That has been described in the past.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 17, 2001 4:35 PM
To: Multiple recipients of list ORACLE-L

I guess I won't be a citizen if this goes into effect.  Talk about
rampant fascism!  Not to mention kissing any vestige of civil rights
goodbye...

--Scott Shafer
  San Antonio, TX


> "Koivu, Lisa" wrote:
> 
> http://www0.mercurycenter.com/local/center/id101701.htm
> 
> Lisa Koivu
> Oracle Data BORED Administrator
> Fairfield Resorts, Inc. (Right across from a post office that had an
> anthrax scare in Margate, FL)
> 954-935-4117

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

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

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

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

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

RE: Changing optimizer mode and collecting statistics

[Christopher Spence]

That would work, you may want to change the method opt as that will create
histograms on many columns which you may not want/need.

Good choice to use DBMS_STATS instead of analyze table.  There are some bugs
with the collection in analyze table, dbms_stats only gathers what is needed
for cbo so is faster, and it can be parallelized.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 18, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L

Hello 

We upgraded our Oracle version from 7.3 to Oracle 8.1.7 for a couple of
months ago. In Ora 7 environment we used optimizer mode RULE, but now we
would like to change to CHOOSE, and hopefully gain some performance. 

As far as I understand everything, we must collect statistics for the
different schemas in the database to have any advantage of the cost based
optimizer mode. Our plan is to do this once a week (is this good enought or
too often?). According to Oracle manual, I should use the dbms_stats package
to get statistics. So a run the following procedure to get statistics:

DBMS_STATS.GATHER_SCHEMA_STATS (ownname  => '',
estimate_percent => 10, 
block_sample => TRUE,
method_opt   => 'FOR ALL COLUMNS SIZE
1',
degree   => NULL,
granularity  => 'DEFAULT', 
cascade  =>  TRUE);

I plan to schedule this and run it once a week. Is this all I have to do? It
seem too easy.  There must some catch somewhere or ??

I'm thankfull for any help

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

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

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

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

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

RE: CTAS use of rollback

[Christopher Spence]

Not exactly.  The select statement can if there are concurrent transactions
and needs for read consistency like any other select statement.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 05, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L

Confirmed.

"Nicoll, Iain (Calanais)" wrote:

> Could anyone tell me whether Create table .. as select .. uses rollback.
>
> I initially thought it would (despite being a cross between ddl and dml)
but
> having created a 3.5 million row table and checked the sum of the writes
in
> v$rollstat it had only done ~130k writes between the start of the ctas and
> the end.  It also doesn't create the table initially but just has a
numbered
> object which it seems to rename only at the very end, so if it fails I
would
> have though it would just drop that object and if it completes
successfully
> then a commit would be done because of the ddl aspects of the command.
>
> I tried inserting 10k rows into the same table and this came back with
about
> 25k writes (seemed reasonable if it's only storing the rowid).  Given this
> it doesn't seem to be using rollback (other than recording changes to
> extents etc) but I'd appreciate confirmation.
>
> Iain Nicoll
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nicoll, Iain (Calanais)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


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

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

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

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

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

RE: Q about autoextent tablespaces and performance

[Christopher Spence]

Title: Q about autoextent tablespaces and performance









Accidently hit send before I finished my response...


Anyway, one thing I used to do is give them a CRETAB/CREIDX script and have them run it.

This will allow you to build the table and
indexes ahead of time, and of the size you
desire.  You can also have the script
create an initial setting of the size of the existing table.  Take a look at the cretab.sql script on my site which is what I used to use
when I had to do such things.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Schoen Volker
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 05, 2001 1:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: Q about autoextent
tablespaces and performance

 

Hi list, 

I need some opinions about following question.


I have a developer box with about 20 schemas.
Sometimes our customers send us a export of there data which I had to import
into our develop instance. My problem is that I don't now how much space I need
for those imports. My solution is to create tablespaces with about 50 MB and
set autoextent on (localy managed). I import the customers data first time and
tablespace may use 200 mb. After some weeks I get the next export. After
import, tablespace growth to 300 mb.

So now my question, is it better to create a large
tablespace, because of continouges db and hdd blocks, or does this have no
influence or small influence on performance. I prefer to build small
tablespaces with limited autoextent option. Reason is, that my cold backups
were quicker, cause I do not have to reserve a lot of unused space for my
tablespaces.

I have databases on Suse Linux, NT4 and W2K. This
question is for all platform. If there are some platform specific issues,
please let me know.

Hope you understand my question. 

TIA 

Volker Schoen

E-Mail:
mailto:[EMAIL PROTECTED] 
http://www.inplan.de


 

RE: Q about autoextent tablespaces and performance

[Christopher Spence]

Title: Q about autoextent tablespaces and performance









I generally add about 33% to the size of
the uncompressed export.  This gives
me some idea how much space it may take. 
Of course, this depends on how many indexes (as they are not stored in
export) and storage parameters on the database.

 

You could always ask them to give you an
idea (perhaps give them a query to run before exporting) of he size of the data
and indexes. 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Schoen Volker
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 05, 2001 1:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: Q about autoextent
tablespaces and performance

 

Hi list, 

I need some opinions about following question.


I have a developer box with about 20 schemas.
Sometimes our customers send us a export of there data which I had to import
into our develop instance. My problem is that I don't now how much space I need
for those imports. My solution is to create tablespaces with about 50 MB and
set autoextent on (localy managed). I import the customers data first time and
tablespace may use 200 mb. After some weeks I get the next export. After
import, tablespace growth to 300 mb.

So now my question, is it better to create a large
tablespace, because of continouges db and hdd blocks, or does this have no
influence or small influence on performance. I prefer to build small
tablespaces with limited autoextent option. Reason is, that my cold backups
were quicker, cause I do not have to reserve a lot of unused space for my
tablespaces.

I have databases on Suse Linux, NT4 and W2K. This
question is for all platform. If there are some platform specific issues,
please let me know.

Hope you understand my question. 

TIA 

Volker Schoen

E-Mail:
mailto:[EMAIL PROTECTED] 
http://www.inplan.de


 

RE: perplexing plan?

[Christopher Spence]

Your sort unique is to satisfy the DISTINCT against the table S15.

One thing may be a problem is you do a full scan of the index 7283, then
retrieve each and every row but one from the table.  There isn't really any
point of even using this index as it will only slow down the query as it has
to go through the index 33 Million times and read the 33 million rows one by
one.  It would be much more effective to just full table scan against the
table directly.  Perhaps look at using Partitioning and parallel query.

I would try removing the index hint for the 33 Million row table.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 05, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L

I'm a little perplexed by this query and it's associated plan.  It's also a
big
performance problem.  The problem is the 35 million row table clearly.  But
looking at the plan at the bottom, I'm not sure where the sorting is going
on.
Would anyone say the index full scan on the 35 million row table is being
sorted?  Or does it look more like it's being fed to a nested loops query?

Thanks,
Doug




SELECT /*+ ORDERED INDEX(S_ S15_IX1) INDEX(BUS_FID F15_UK1) INDEX(STREET
  A15_IX1) */  SDE.STREET.CFCC,  SDE.STREET.BUS_FID  ,S_.eminx,S_.eminy,
  S_.emaxx,S_.emaxy, BUS_FID.fid,BUS_FID.numofpts,BUS_FID.entity,
  BUS_FID.points,BUS_FID.rowid
FROM
 (SELECT /*+ INDEX(SP_ S15_IX1) */ DISTINCT sp_fid,eminx,eminy,emaxx,emaxy
  FROM SDE.S15 SP_   WHERE SP_.gx >= :1 AND SP_.gx <= :2 AND SP_.gy >= :3
AND
  SP_.gy <= :4 AND SP_.eminx <= :5 AND SP_.eminy <= :6 AND SP_.emaxx >= :7
  AND SP_.emaxy >= :8) S_,  SDE.STREET , SDE.F15 BUS_FID WHERE S_.sp_fid =
  BUS_FID.fid AND S_.sp_fid = SDE.STREET.BUS_FID


call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.00   0.00  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch   45473.15 475.04 223532   66153503  0
4494
--- --   -- -- -- --
--
total   47473.15 475.04 223532   66153503  0
4494

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20

Rows Row Source Operation
---  ---
   4494  HASH JOIN
   4494NESTED LOOPS
   4495  VIEW
   4495 SORT UNIQUE
   4817   INDEX RANGE SCAN (object id 7356)
   4494  TABLE ACCESS BY INDEX ROWID STREET
   8988INDEX UNIQUE SCAN (object id 7355)
33065402  TABLE ACCESS BY INDEX ROWID F15
33065403INDEX FULL SCAN (object id 7283)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Doug C
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Installation of designer 6.0 with personal oracle 8.1.6

[Christopher Spence]

I had a lot of problems mucking with designer, but I was told at the time to
Install Designer first, hope that helps, really the rest is just following
directions and crossing your fingers.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 05, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L

Hi all ,
I want to install designer 6.0 on my laptop with personal oracle 8.1.6.
I haven't got any documents which states that designer can be installed with
personal oracle .
I need help to install it with personal oracle .
Thanks in advance ..

--- Brajesh

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

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

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

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

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

RE: Restricted mode

[Christopher Spence]

Alter system enable restricted session;
Alter system disable restricted session;

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 05, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L


Is there a way to change a database from being up in restricted mode
to open for all without shutting down and restarting?

Thanks


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

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

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

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

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

RE: Backup Strategy

[Christopher Spence]

oing hot backups already I
would not shutdown my database just to get a cold.  There is a myth out
there that hot backups are not as reliable as cold backups and its false.
Your really not saving anything time wise if there is a crash (unless of
course all your disks crash as you are bring up the database).

Weekly cold backups are a good plan.


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

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

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

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

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

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

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

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

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

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

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




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

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

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

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

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

RE: Program field in v$session

[Christopher Spence]

DBMS_APPLICATION_INFO

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 05, 2001 7:40 AM
To: Multiple recipients of list ORACLE-L

This column is 64 characters in length - if for example the shortcut to a
program is longer than
this, it can't all be stored, so is there any way of getting this info?

Thanks,

Steven H.

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

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

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

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

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

RE: Intermedia Performance Benchmarks anyone ?

[Christopher Spence]

on on being able to deal with large volumes of
product
data (e.g. 1 million products in a retail application) and be able to
perform 'intelligent' searches against the metadata (things like
typographical error matching, synonyms etc.) as well as the more usual
parametric search (i.e. advanced search page with lots of metadata
specific
fields).

Indexing time and max throughput are also of interest.

Any data based on experience would be appreciated.

Thanks

Martin

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

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

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

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

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

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

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

RE: Output to Excel

[Christopher Spence]

 FYI:  If you use PL/SQL Developer you can save results sets right as CSV,
really sweet.  I use PL/SQL Developer for 90% of what I do.

And it is $50-$150 / license depending on how many you get, i would compare
it to toad ($750) or navigator ($5,000) any day of the week.

(Sorry quest people).

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

Hi Jared,

Excuse me for contact you directly not throug the list.

The past week you post an answer to someone trying to write to excel,
I took the example to generate a file comma separated, but getting an
error.

 CREATE OR REPLACE PACKAGE BODY PROCESAR_AGENCIAS AS
 PROCEDURE GENERAR_FACTURAS
  ( PGRUPO IN NUMBER,PCOMPANIAIN NUMBER,
PFECHA_INICIAL IN DATE,  PFECHA_FINAL IN DATE,
PAGENCIA   IN NUMBER ) AS
 CURSOR C_FACTURAS IS
   SELECT F.GRUPO||','||
  F.COMPANIA||','||
  F.TIPO_FACTURA||','||
  F.AGENCIA||','||
  F.FACTURA||','||
  F.CLIENTE||','||
  F.VENDEDOR||','||
  F.DOCUMENTO_COBRO||','||
  F.FECHA||','||
  F.FECHA_PAGO||','||
  F.FECHA_VENCIMIENTO||','||
  F.ESTATUS_COMISION||','||
  F.COMISION_VENDEDOR||','||
  F.MONTO||','||
  F.MONTO_PAGADO||','||
  F.IMPRESA||','
   FROM FACTURAS F
  WHERE
   F.GRUPO   = PGRUPO AND
   F.COMPANIA= PCOMPANIA  AND
   F.AGENCIA = PAGENCIA   AND
   F.FECHA BETWEEN PFECHA_INICIAL AND PFECHA_FINAL;
 CURSOR C_ITEM_FACTURAS IS
   SELECT I.GRUPO||','||
  I.COMPANIA||','||
  I.AGENCIA||','||
  I.TIPO_FACTURA||','||
  I.FACTURA||','||
  I.LOCALIDAD||','||
  I.ARTICULO||','||
  I.SECUENCIA||','||
  I.COSTO||','||
  I.PRECIO_VENTA||','||
  I.CANTIDAD||','||
  I.ITBIS||','||
  I.DESCTO||','
   FROM FACTURAS F, ITEM_FACTURAS I
  WHERE
   F.GRUPO = PGRUPO AND
   F.COMPANIA  = PCOMPANIA  AND
   F.AGENCIA   = PAGENCIA   AND
   F.FECHA BETWEEN   PFECHA_INICIAL AND
 PFECHA_FINAL   AND
   I.GRUPO = F.GRUPOAND
   I.COMPANIA  = F.COMPANIA AND
   I.TIPO_FACTURA  = F.TIPO_FACTURA AND
   I.FACTURA   = F.FACTURA;
   V_ARCHIVO UTL_FILE.FILE_TYPE;
   REGISTRO FACTURAS%ROWTYPE;  * I declare it here
   OUT_REC TYPE REGISTRO;  *

 BEGIN
 -- Loop para el archivo de Facturas
   V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','FACTURAS.TXT', 'W');
   FOR FT IN C_FACTURAS
 LOOP
   UTL_FILE.PUT_LINE(V_ARCHIVO, FT.OUT_REC);
 END LOOP;
   UTL_FILE.FCLOSE(V_ARCHIVO);
 -- Loop para el archivo de Item Facturas
   V_ARCHIVO := UTL_FILE.FOPEN('D:\EMBARQUES','ITEM_FACTURAS.TXT', 'W');
   FOR IFT IN C_ITEM_FACTURAS
 LOOP
   UTL_FILE.PUT_LINE(V_ARCHIVO, IFT.OUT_REC);
 END LOOP;
   UTL_FILE.FCLOSE(V_ARCHIVO);
 END GENERAR_FACTURAS;
 END PROCESAR_AGENCIAS;
/



PL/SQL: Statement ignored
PLS-00302: component 'OUT_REC' must be declared
PL/SQL: Statement ignored
PLS-00302: component 'OUT_REC' must be declared

How should I Declare it.

I did 

 REGISTRO FACTURAS%ROWTYPE;
 OUT_REC TYPE REGISTRO;

Is there something missing ?


Any help !!

Thanks in Advance,



Ramon E. Estevez
[EMAIL PROTECTED] 
Dominican Republic
809-565-3121



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

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

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

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

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

RE: inefficient SQL detector

[Christopher Spence]

Have a look at the following script:

http://www.vampired.net/scripts/php/tuning.php (badsql.sql)

It allows you to run it against any database (8.1.6+) without having to
adjust the buffer gets, executions, parsed calls to match the norm of the
database.  

On your script, it happens to return 0 rows on my test databases because of
the execution count and the buffer gets being higher than my norm.

HTH,

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L

Yesterday while on a search for inefficient SQL I developed the following
SQL;
which did a decent job of highlighting 1 - 2 dozen SQL statements that were
HIGHLY inefficient. The goal was to identify the SQL that did a "lot"
of buffer_gets (> 200); that ran "frequently" (> 100 times); that
only returned a "few" number of rows (1-2 per execution) and that did
"many" (> 1000) buffer_gets for each execution. You should adjust these
criteria to better match your own application & environment.

select disk_reads, buffer_gets, rows_processed, executions,
(buffer_gets/executions) ratio, sql_text
from v$sql
where buffer_gets> 200
 and  executions > 100
 and  executions*2   > rows_processed
group by disk_reads, buffer_gets, rows_processed, executions, sql_text
having (buffer_gets/executions) > 1000
order by 4
/

Alternatively this SQL can be order by 5

We are in the process of adding indexes that hopefully will GREATLY
increase the selectivity of the SQL, rather than doing cartesian
joins across tables.

HTH & YMMV!

-- 
Charlie MenglerMaintenance Warehouse  
[EMAIL PROTECTED]   10641 Scripps Summit Ct.
858-831-2229   San Diego, CA 92131
United WE Stand!   Justice WILL Be Served!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Max number of sessions

[Christopher Spence]

Title: Max number of sessions









Nope it is as I said, really do not know
why, but if you look at v$parameter and concepts
manuals it mentions this behavior.  I
think this is more so because of MTS environments, I hardly ever use MTS.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: George Schlossnagle
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001 3:56 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Max number of
sessions

 



Isn't that the inverse?  You
require one shadow process per session, plus the background processes. 
You should always have more procs than sessions (jn a non-MTS environment).






George





 







- Original Message ----- 





From: Christopher
Spence 





To: Multiple
recipients of list ORACLE-L 





Sent: Thursday,
October 04, 2001 2:50 PM





Subject: RE: Max
number of sessions





 



Oracle uses PROCESSES +
10% + 5 for setting the hard limit of the sessions parameter.



"Do not criticize
someone until you walked a mile in their shoes, that way when you criticize
them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Yuval Arnon
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001
2:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: Max number of sessions

 

Hi, 
I would like to find out how to
compute/estimate the maximum  number of sessions a db can handle.

Preferably based on the init.ora
params sessions and processes, size of sga, size of ram, the /etc/system params
etc. 
This is for a db running using MTS.


 

TIA 

Yuval. 

RE: Veritas Quickio and DB_BLOCK_SIZE

[Christopher Spence]

h.
> Some of the reasons should look familiar to you! ;)
> 
> Regards,
> Satar
> 
> 1. The OLTP app has lots of small rows (<2k)
> 
> 2. The OLTP app does massive scattered reads (you
> don't full scan in OLTP).  It
> reads a block here, a block there based on some
> primary key (after doing lots of
> scattered reads to walk an index structure)
> 
> 3. The OLTP app has 1,000 connected users -- each
> wants their current row(s) they
> are using in the cache. 
> 
> 4. A smaller block size in a database that does lots
> of scattered IO's (eg: an OLTP system) and random
> keyed reads can definitely benefit from smaller
> blocksizes.
> 
> 5. The indexes for the critical access paths fit
> exactly into an N-layer tree and allow an optimum
> buffering strategy when memory is limited.
> 
> 6. In almost all cases the data for a single index
> value will be (significantly) less than 2K and will
> all be found in the same block.
> 
> 7. Memory is at a premium.
> 
> --- Jonathan Lewis <[EMAIL PROTECTED]>
> wrote:
> > 
> > That's a fairly sweeping statement to make without
> > any justification - after all, at 2K:
> > 
> > The block header is a much larger percentage 
> > of the block size - so you lose space.
> > 
> > The probability of wasting space from the
> > PCTFREE 
> > setting increases - so you lose space.
> > 
> > The memory overhead due to x$bh is fixed per
> > block,
> > so you use more memory to hold the same volume
> > (block size x block count) of data.
> > 
> > Index depth may increase through having fewer 
> > entries per branch block.
> > 
> > Latch activity is likely to increase on range
> > scans
> > because leaf blocks hold fewer entries - you
> get
> > the same effect on tables with clustered data
> -
> > and the effectiveness of IOTs will
> particularly
> > be
> > reduced.
> > 
> > 
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> > 
> > Host to The Co-Operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> > 
> > Author of:
> > Practical Oracle 8i: Building Efficient Databases
> > 
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > Date: 02 October 2001 21:56
> > 
> > 
> > |If your application allows it, and if the
> > Application
> > |will not change in the future, then use a 2k
> block
> > |size for OLTP database.
> > |
> > |If you are not sure on the application needs,
> then
> > |stick with 4k to be safe.
> > |
> 
> 
> __
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: satar naghshineh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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




=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
http://www.osborne.com/database_erp/0072131454/0072131454.shtml

__
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Droping System User

[Christopher Spence]

Title: RE: Droping System User









The DBA_ tables are owned by SYS.

 

But a lot of features such as AQ and such
use objects owned by SYSTEM.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001
3:55 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Droping System User

 

> -Original Message- 
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]

> 
> The best way to tell if this
hurts is to create a test database for 
> yourself, and try it.

> 
> You may not get many
experienced replies for this probably because the 
> question is so far out of
reality that nobody thought to try 
> it.  I would

> think that if anyone
"accidently" did this to their own database, they 
> quickly followed the command
with a "Restore From Backup and Rebuild" 
> command. 

 

OK, I viewed this statement from Mr. Mercadante as a
challenge, so I tried it. 
I dropped user system, and was able
to do a select (*) from dba_objects, a create table, insert into the table, and
commit.

I could also disconnect and reconnect to the database
(though I did get the usual warning about Product_User_Profile being absent.)

What should I try to prove that my database is FUBAR?


SQL> connect jrk@sdjrk3 
Entrez le mot de passe : 

Connecté. 
SQL> drop user system cascade ;


Utilisateur supprimé. 

SQL> select count (*) from dba_objects ;


  COUNT(*) 
-- 
  2942


SQL> create table t (n number) ; 

Table créée. 

SQL> insert into t (n) values (1) ; 

1 ligne créée. 

SQL> commit ; 

Validation effectuée. 

SQL> disconnect 
Déconnecté de Oracle8i Enterprise
Edition Release 8.1.7.1.1 - Production 
With the Partitioning option

JServer Release 8.1.7.1.1 -
Production 
SQL> connect jrk@sdjrk3

Entrez le mot de passe : 

Erreur lors de l'accès à
PRODUCT_USER_PROFILE 
Attention : Informations du profil
utilisateur du produit non chargées! 
Vous devrez peut-être exécuter
PUPBLD.SQL en SYSTEM 
Connecté. 
SQL> select username from
dba_users ; 

USERNAME 
--

SYS 
OUTLN 
DBSNMP 
QUEST 
JRK 
A 

6 ligne(s) sélectionnée(s). 

RE: Max number of sessions

[Christopher Spence]

Title: RE: Max number of sessions









If you don't
modify the SESSSIONS parameter.


If you look at v$parameter you will notice Oracle
sets the parameter for "Sessions" to be 10% over the processes + 5.

 

But it will only be able to create the number of processes that is specified
for processes parameter.

For MTS this isn't
a problem.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001 2:58 PM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Max number of
sessions

 

Really
Christopher?  I have seen databases crap out at exactly the number of
sessions allowed by the processes parameter, including the background
processes.  That was on Solaris and on HP/UX.  Looked like there was
no wiggle room, period. 

Lisa Koivu 
Oracle Database
Administrator 
Fairfield Resorts, Inc.

954-935-4117


 

-Original Message- 
From:   Christopher Spence
[SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, October 04, 2001 2:50 PM

To: Multiple recipients
of list ORACLE-L 
Subject:   
RE: Max
number of sessions 

Oracle uses PROCESSES +
10% + 5 for setting the hard limit of the sessions parameter. 
"Do not criticize someone until
you walked a mile in their shoes, that way when you criticize them, you are a
mile a way and have their shoes."

Christopher R.
Spence
Oracle DBA
Phone: (978)
322-5744
Fax:   
(707) 885-2275 
Fuelspot
73 Princeton
Street
North,
Chelmsford 01863
  
-Original
Message-
From: Yuval Arnon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001
2:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: Max number of sessions

  
Hi,
I would like to find out how to compute/estimate the maximum 
number of sessions a db can handle.
Preferably based on the init.ora params sessions and processes, size of
sga, size of ram, the /etc/system params etc.
This is for a db running using MTS. 
  
TIA 
Yuval. 

RE: DISK IO?

[Christopher Spence]

Unix, sar and iostat
Windows, Performance Monitor tool

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L

Hi
How to monitor disk IO on Unix AND Win2000 platform?
Thanks
-Seema

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

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

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

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

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

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

RE: Localy managed TBS

[Christopher Spence]

Title: RE: Localy managed TBS









I updated my script on my site to include
LMT column, it is similar to Lisa's, but with an extra column.

 

http://www.vampired.net/scripts/php/tablespace.php

 

The only real different between Lisa's
script is I have object count, other than that, it is the same, just we used different
approaches.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Mercadante,
 Thomas F [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001
4:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Localy managed TBS

 

Lisa,

 

Nice simple script! 
;0

 

Actually, produces a very
nice, neat, concise report.

 

Very nice.

 



Thanks!



Tom Mercadante 
Oracle
Certified Professional 



-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001
4:06 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Localy managed TBS

in dba_tablespaces,
column extent_management 

below is a script I use
that has this bit of info included 

-- snip 
column
ts_name format a15 

select 
a.tablespace_name ts_name,extent_management lmt, mb_free, mb_total, pct_used

from 
( 
 select 
 tablespace_name, MB_FREE, MB_TOTAL,
round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used 
 from 
    (select tablespace_name,
trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024) MB_TOTAL

    from 
   
( 
   
(select tablespace_name, sum(bytes)/1024 free_bytes, 
   
00 total_bytes 
   
from dba_free_space 
   
group by tablespace_name) 
   
union 
   
(select     t.tablespace_name tablespace_name, 
   
   
    00
free_bytes, 
   
    sum(d.bytes)/1024 total_bytes 
   
from 
   
dba_tablespaces t, dba_data_files d 
   
where t.tablespace_name = d.tablespace_name 
   
group by T.EXTENT_MANAGEMENT, t.tablespace_name) 
   
) 
    group by tablespace_name) ) a,

dba_tablespaces t 
where t.tablespace_name = a.tablespace_name 
order by 1,2 
/ 

Lisa Koivu 
Oracle Database
Administrator 
Fairfield Resorts, Inc.

954-935-4117


 

-Original Message- 
From:   Hamid Alavi
[SMTP:[EMAIL PROTECTED]] 
Sent:   Wednesday, October 03, 2001 3:40 PM

To: Multiple recipients
of list ORACLE-L 
Subject:   
Localy
managed TBS 

List, 
How
can I find out which Tablespace managed localy or by Dictionary? 
Any
hint appreciate. 





Hamid Alavi 
Office
818 737-0526 
Cell   
818 402-1987 

The information contained in this message and any
attachments is intended 
only
for the use of the individual or entity to which it is addressed, and

may
contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

disclosure
under applicable law. If you have received this message in error,

you
are prohibited from copying, distributing, or using the information.

Please
contact the sender immediately by return e-mail and delete the 
original
message from your system. 
-- 
Please
see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author:
Hamid Alavi 
 
INET: [EMAIL PROTECTED] 

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


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

also
send the HELP command for other information (like subscribing). 

RE: Max number of sessions

[Christopher Spence]

Title: Max number of sessions









Oracle uses PROCESSES + 10% + 5 for
setting the hard limit of the sessions parameter.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Yuval Arnon
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001
2:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: Max number of sessions

 

Hi, 
I would like to find out how to
compute/estimate the maximum  number of sessions a db can handle.

Preferably based on the init.ora
params sessions and processes, size of sga, size of ram, the /etc/system params
etc. 
This is for a db running using MTS.


 

TIA 

Yuval. 

RE: Dropping table is not completing

[Christopher Spence]

What is the error?  Or does it just hang?
Have you looked at session wait events to see what is holding it up?
If it was locked, it would echo right back saying acquire with nowait
failed.  Perhaps trying to drop it with a trace behind it.  Or trace the
session as you wait from sys.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L

Hi All,

I am trying to drop a table. It is not locked and has very few records in
it.  I am trying to drop it but it will not.
What can I check to find out why it will not drop?

Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: question about explain plan ???

[Christopher Spence]

1.  Same way you always do, you just won't see bind variables.
But you can do a trace event 10046 at level 4 to see bind variables

2.  Cut the sql out and try it in explain plan.  Or use profiler to profile
it.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I'm not sure this issue came before or not.

1. How to run explain plan on a statement using bind
variable?  

explain plan  for select * from emp where id =
v_id

2. How to run explain plan on a stored procedure?


Thank you! Much appreciated.

Leslie

__
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: JDBC on Unix box

[Christopher Spence]

You need to goto Java.Sun.Com and download the SDK.  1.3 is stable, 1.4 is
beta (although I do use 1.4 and it works good, but I would recommend 1.3 for
production).  

You will need to unpack it, I generally install it in /usr/java1.4 and make
symbolic links in /usr/bin for all the common tools (java, javac, jdb).

I also modify profile scripts to have env JAVA_HOME /usr/java/1.4
And add the following to the path $JAVA_HOME/bin

At that point, you have the JDK/JVM installed.

You want to then get the classes12.zip from the $ORACLE_HOME/jdbc/lib
directory and put them some where on your system you want to connect with.

You need to modify the classpath to include this file, or specify it when
doing javac/java with the -cp option.

HTH,

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L

Our developers are running Tomcat on a Solaris system. They want to connect
to our Oracle database on another Unix server, using JDBC. Can someone give
me a clue as to what I need to install/configure on the Solaris system? I
realize this is a simple question, but I can't quite get my mind around
where I need to get started. Many thanks.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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

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

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

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

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

RE: Droping System User

[Christopher Spence]

Well first off, you can't just do drop user system, it would complain it has
objects and must use cascade.   If you use cascade, it will complain that
you must drop queue tables first, if you drop them, then you have intention
of dropping system and it is no longer an accident.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L


Hi list ,

  Sorry for posting this strange question , but  I am hopeful that I will
get some explanation ...

Question : Can we drop user SYSTEM ? How we will recover that ?( I know that
nobody should do that !!! )

Any response would be appreciated 

TIA
Gholam 


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

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

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

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

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

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

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

RE: please help me to unlock a table

[Christopher Spence]

What it prevents is DML creating shared locks on the table.
I cannot remember where table locks are in the docs, but that is what I
should say.  Perhaps it was miss-worded.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 12:20 AM
To: Multiple recipients of list ORACLE-L


Interesting, I didn't know about that.

It won't however, unlock a table.

What it will do is prevent DDL on the
table by disabling the use of exclusive
locks on the table.

20:17:08 jkstill@ts01 SQL> alter table x modify ( x not null );
alter table x modify ( x not null )
*
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for X

The Fine Documentation erroneously states that it 
will prevent DML, which it does not.

Jared


On Tuesday 02 October 2001 03:20, ASHRAF SALAYMEH wrote:
> Try this:
> Alter table table_name disable table lock;
>
> --- Ha Duy Thien <[EMAIL PROTECTED]> wrote:
> > Hi all
> >
> > Does anyone know how to unlock a locked table?
> >
> >
> > Thanks in advance
> >
> > Ha Duy Thien
> >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: When optimizer reevaluate SQL statement

[Christopher Spence]

If it is the same table through a synonym, Oracle is smart enough to avoid a
hard parse and will simply do a soft parse.

But if the objects are different, as shown below (as per my original
comment) then a hard parse will happen.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 6:10 PM
To: Multiple recipients of list ORACLE-L

Yes, but I think Chris' point was if each statement was accessing the *same*
table (say, through a public synonym) then running it under a different user
wouldn't cause a hard parse.

Maybe I'll have time to check this myself tomorrow, right now I have to
leave.

Jay Miller

-Original Message-
Sent: Wednesday, October 03, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L


In response to:

"I'm afraid I can't agree with the statement that two different users 
submitting the same SQL cause a hard parse."


I tried the following tests to confirm my comments.
Following through some simple SQL, the results are obvious.


Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as sys

SQL> create user  test1 identified test1 default tablespace users temporary
tablespace temp;

User created

SQL> create user  test2 identified by test2 default tablespace users
temporary tablespace temp;

User created

SQL> grant connect, resource to test1, test2;

Grant succeeded

SQL> grant plustrace to test1, test2;

Grant succeeded

SQL> create table test1.employee as select * from cspence.employee
sample(.5);

Table created

SQL> create table test2.employee as select * from cspence.employee
sample(.5);

Table created

SQL> connect test1/test1@jetfuel
Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as test1

select * 
  from employee
 where emp_id = 5
/

Hard Parse Count:   1

select * 
  from employee
 where emp_id = 5
/ 

Hard Parse Count:   0

SQL> connect test2/test2@jetfuel
Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as test2

select * 
  from employee
 where emp_id = 5
/

Hard Parse Count:   1

select * 
  from employee
 where emp_id = 5
/

As they say, the proof is in the pudding.

I use PL/SQL Developer, and didn't use "Auto trace" as the "PlusTrace" role
may have implied.  

Hope this helps clarify things.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Sunday, September 23, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L

I'm afraid I can't agree with the statement that two different users 
submitting the same SQL cause a hard parse. It is my 
understanding of the process that part of the parsing occurs when 
another user is submitting an identical SQL statement, but this 
does not constitute a hard parse, just a check of permissions, 
synonyms, etc. If there was a hard parse everytime a different user 
submitted identical SQL it would negate much of the benefit of 
using bind variables. Thus the answer is that there is reparsing, but 
not the kind that really does damage to performance.

Regards,
Chris Gait

On 14 Sep 2001, at 9:55, Christopher Spence wrote:

Date sent:  Fri, 14 Sep 2001 09:55:33 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> !! Please do not post Off Topic to this List !!
> 
> If the Oracle executing user is different, the execution plan will be
> different due to possibility of different objects and security.
> 
> Different sessions under the same user can share using bind variables.
> 
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Friday, September 14, 2001 12:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> !! Please do not post Off Topic to this List !!
> 
> Chris:
> 
> > If you are executing it under a different user the statement will be
> reparsed.
> 
> I'm puzzled. I always thought that different users submitting the
identical
&

RE: Export - Import from Oracle v8 to v731

[Christopher Spence]

Title: RE: Export - Import from Oracle v8 to v731









There is a compatible parameter for the
init.ora file.

The parameter is probably already there,
just set for your current version as it is generally included by default.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 04, 2001
8:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Export - Import from
Oracle v8 to v731

 

Hi christopher,


How i can make my orace8
server compatible with v731... is i can set any init.ora parameter


or something
different 

Nirma, 

-Original Message- 
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]

Sent:   Wednesday, October 03, 2001 8:30 PM

To: Multiple recipients
of list ORACLE-L 
Subject:   
RE:
Export - Import from Oracle v8 to v731 

Don't know if this would work, but here's a thought.


Go to the 731 box, set up a connect string to the v8
box.  Using the 731 
exp,
export the v8 database (after you set its compatible option to 7 and

bounce
it).  See if it will import using the 731 imp. 

I don't have any environment to test this in but I
think I remember that 
using
the 731 exp is the trick. 

 

      

   
Christopher   

   
Spence  
To: Multiple recipients of list
ORACLE-L  
   
   

   
@FuelSpot.com   
cc:  

   
>   
Subject: RE: Export - Import from Oracle v8  

   
Sent by: root    to
v731  

  

  

   
10/03/2001

   
12:25
PM  

   
Please

   
respond
to

   
ORACLE-L  

  

  








You generally cannot export from a higher
leveldatabase to a lower. 
Although
you can probably change the compatible option to 7.3.4 and do it 
that
way (from what I hear, never tried it). 

 

"Do not criticize someone until you walked a
mile in their shoes, that way 
when
you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence 
Oracle
DBA 
Phone:
(978) 322-5744 
Fax:   
(707) 885-2275 

Fuelspot 
73
Princeton Street 
North,
Chelmsford 01863 

 

-Original Message- 
Sent:
Wednesday, October 03, 2001 11:25 AM 
To:
Multiple recipients of list ORACLE-L 

 

Hi gurus, 

i need to transfer db design of a small application
from oracle v8(winnt) 
to
v731(vms=vax). 

I successfully completed the export process:


c:\>exp80 parfile=c:\exp_par.dat 

exp_par.dat 
---

userid=msalah/msalah@qtel

file=c:\test.dmp

tables=(ctv_tv_dockets)

grants=y

indexex=y


then am importing this dump file into oracle v731
which is running on 
vms-vax.


imp_par.dat 
-

userid="ops$cssdba/cssdba#act@csscli"

file=c:\test.dmp

tables=(*)

fromuser=msalah

touser=ops$cssdba


c:\>imp71 parfile=c:\imp_par.dat 

here it's giving problem: 

IMP-3: ORACLE error 12151 encountered

ORA-12154:
TNS: could not resolve service name 
IMP-0:
Import terminated unsucessfully 

Note that in interactive mode also i tried to import,
but it's also not 
working.


I'm expecting the problem is around 
-

userid="ops$cssdba/cssdba#act@csscli"



here
the password contains # symbol which refers comment usually. 
Before
once i handled it successfully, but i forgot that way. 

anyone have any idea... 

rgds, 
Nirmal.


 

-- 
Please
see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author:

 
INET: [EMAIL PROTECTED] 

Fat City Network Services    -- (858)
538-5051  FAX: (858) 5

RE: book?

[Christopher Spence]

Doht, for some reason I put your name instead of Harrison.

Oracle SQL High Performance Tuning (Guy Harrison)

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 04, 2001 5:15 AM
To: Multiple recipients of list ORACLE-L

Ummm, I wrote bits of "Oracle 8i Application Programming", not the
performance tuning one :0)

g


-Original Message-
Sent: Wednesday, October 03, 2001 9:58 PM
To: Multiple recipients of list ORACLE-L


There are many, I will name a few I like:

O'Reilly Performance Tuning  (Older but just awesome)
O'Reilly Oracle Internals (More focused and advanced, but great)
Oracle SQL High performance Tuning (Make sure you get the Guy Hammond
version, excellent SQL Book)
Oracle Press Oracle Performance Tuning (tusc) (Again, great book, more
up to
date, and detailed)
Unix and Oracle 8i Performance tuning (Great book for those newer to
Unix
but has some more advanced things as well).

These I have read and can vouch for, although there are some other books
I
must say are great and are not completely tuning related:

O'Reilly PL/SQL Programming
Practical Oracle 8i
Learning Korn Shell


And heard a lot of great things about Rachel's book forgive me if I get
the
name wrong, 

Oracle DBA 101


And finally, I must say BookPool.com is the best for getting books, I
get
things in 1 day even though I pay for 5 day ground (love 1 day ship
zones).

Plus their prices are 90% of the time 40% off and reasonable shipping
(they
use USPS as well).  Although they only have technical books it seems
(what
other books are worth while?  Besides maybe Lord of the Rings).


"Do not criticize someone until you walked a mile in their shoes, that
way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 4:29 PM
To: Multiple recipients of list ORACLE-L

Hi
Which book is good for Oracle DB tunning and Fragmentation removal?
Thanks
-Seema

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

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

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

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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 

RE: Measure parsing calls...

[Christopher Spence]

Without using TIMED_STATISTICS it is hard to weigh the costs of the parses.

Also, you want to get the parse count (total) as well, this will allow you
to find what percentage is hard parses and which are not.

That query you did, as is really doesn't tell you much.

582593 hard parses could be perfectly fine if you have 10 parses.

If parsing only takes up a few minutes over the life of the instance of a
few months, it may not be a problem even if they are re-parsing.

Once you have that information, then you can weigh it and determine if it is
a problem.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L

Hello folks

I'm trying to improve performance in our database, and the Oracle manual
gave me some queries and tips, but I don't realy know to interpet the
results.

The query 
SELECT * FROM V$SYSSTAT
WHERE NAME IN('parse time cpu', 'parse time elapsed', 'parse count (hard)')

gives me the following values: 
STATISTIC#  NAMECLASS   VALUE
177 parse time cpu  64  0
178 parse time elapsed  64  0
180 parse count (hard)  64  582593

So my problem should be parsing of sql-statements

To get the most paresed sql statements, I run the following query:
SELECT SQL_TEXT, PARSE_CALLS, EXECUTIONS 
FROM V$SQLAREA
ORDER BY PARSE_CALLS desc

and get the following result:
SQL_TEXT PARSE_CALLS
EXECUTIONS

-
savepoint S4 2573193   2573193

-
BEGIN 
.Print_Queue_API.Get_Job(:a0,:a1,:a2); 
END; 2537668   2537668

-
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,
cycle#=:5,order$=:6,cache=:7,
highwater=:8,audit$=:9 where obj#=:1  693313 693313

--
select sysdate + 30/86400 from dual   534042 534042

If I get everything right I should focus on the statement 'savepoint S4'
(the client applikations sets this befora a transaction is made). But how do
I do that? The other call is a external C program checking for printjobs in
the database. How can I can I improve this. These two statements are by far
the 'worst'.

If anyone managed to get to this point of the mail, I will supply the
technical details for our dear little db:
OS: WIN 2000 Advanced Server
DB: 8.1.7.1.3 Standard Edition
time_statistics is not on in production environment

Thankful for any input

Regards

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

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

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

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

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

RE: book?

[Christopher Spence]

There are many, I will name a few I like:

O'Reilly Performance Tuning  (Older but just awesome)
O'Reilly Oracle Internals (More focused and advanced, but great)
Oracle SQL High performance Tuning (Make sure you get the Guy Hammond
version, excellent SQL Book)
Oracle Press Oracle Performance Tuning (tusc) (Again, great book, more up to
date, and detailed)
Unix and Oracle 8i Performance tuning (Great book for those newer to Unix
but has some more advanced things as well).

These I have read and can vouch for, although there are some other books I
must say are great and are not completely tuning related:

O'Reilly PL/SQL Programming
Practical Oracle 8i
Learning Korn Shell


And heard a lot of great things about Rachel's book forgive me if I get the
name wrong, 

Oracle DBA 101


And finally, I must say BookPool.com is the best for getting books, I get
things in 1 day even though I pay for 5 day ground (love 1 day ship zones).

Plus their prices are 90% of the time 40% off and reasonable shipping (they
use USPS as well).  Although they only have technical books it seems (what
other books are worth while?  Besides maybe Lord of the Rings).


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 4:29 PM
To: Multiple recipients of list ORACLE-L

Hi
Which book is good for Oracle DB tunning and Fragmentation removal?
Thanks
-Seema

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

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

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

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

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

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

RE: When optimizer reevaluate SQL statement

[Christopher Spence]

In response to:

"I'm afraid I can't agree with the statement that two different users 
submitting the same SQL cause a hard parse."


I tried the following tests to confirm my comments.
Following through some simple SQL, the results are obvious.


Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as sys

SQL> create user  test1 identified test1 default tablespace users temporary
tablespace temp;

User created

SQL> create user  test2 identified by test2 default tablespace users
temporary tablespace temp;

User created

SQL> grant connect, resource to test1, test2;

Grant succeeded

SQL> grant plustrace to test1, test2;

Grant succeeded

SQL> create table test1.employee as select * from cspence.employee
sample(.5);

Table created

SQL> create table test2.employee as select * from cspence.employee
sample(.5);

Table created

SQL> connect test1/test1@jetfuel
Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as test1

select * 
  from employee
 where emp_id = 5
/

Hard Parse Count:   1

select * 
  from employee
 where emp_id = 5
/ 

Hard Parse Count:   0

SQL> connect test2/test2@jetfuel
Connected to Oracle8i Enterprise Edition Release 8.1.6.3.0 
Connected as test2

select * 
  from employee
 where emp_id = 5
/

Hard Parse Count:   1

select * 
  from employee
 where emp_id = 5
/

As they say, the proof is in the pudding.

I use PL/SQL Developer, and didn't use "Auto trace" as the "PlusTrace" role
may have implied.  

Hope this helps clarify things.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Sunday, September 23, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L

I'm afraid I can't agree with the statement that two different users 
submitting the same SQL cause a hard parse. It is my 
understanding of the process that part of the parsing occurs when 
another user is submitting an identical SQL statement, but this 
does not constitute a hard parse, just a check of permissions, 
synonyms, etc. If there was a hard parse everytime a different user 
submitted identical SQL it would negate much of the benefit of 
using bind variables. Thus the answer is that there is reparsing, but 
not the kind that really does damage to performance.

Regards,
Chris Gait

On 14 Sep 2001, at 9:55, Christopher Spence wrote:

Date sent:  Fri, 14 Sep 2001 09:55:33 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> !! Please do not post Off Topic to this List !!
> 
> If the Oracle executing user is different, the execution plan will be
> different due to possibility of different objects and security.
> 
> Different sessions under the same user can share using bind variables.
> 
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Friday, September 14, 2001 12:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> !! Please do not post Off Topic to this List !!
> 
> Chris:
> 
> > If you are executing it under a different user the statement will be
> reparsed.
> 
> I'm puzzled. I always thought that different users submitting the
identical
> SQL statement would use the same plan and not need to be reparsed. I
> understood that to be part of the reasoning behind bind variables and the
> big advantage of cursor sharing. Please explain.
> 
> Jon Walthour
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Walthour, Jon (GEAE, Compaq)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing

RE: Veritas Quickio and DB_BLOCK_SIZE

[Christopher Spence]

or of:
> Practical Oracle 8i: Building Efficient Databases
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: 02 October 2001 21:56
> 
> 
> |If your application allows it, and if the
> Application
> |will not change in the future, then use a 2k block
> |size for OLTP database.
> |
> |If you are not sure on the application needs, then
> |stick with 4k to be safe.
> |


__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

RE: intermediate table

[Christopher Spence]

You cannot use SQL against PL/SQL tables.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Shishir
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001 12:26 PM
To: Multiple recipients of list
ORACLE-L
Subject: intermediate table

 



Hi to all !





I have one small problem and i am
sure many of u can reply .My problem is :i am storing data from different
table into   intermediate table but the 





i want to use sql statements to
filter data from that intermediate table, I can access it as array of user
defined object . but i want to use sql statement for extracting the data so plz
help me out.





the below code is just prototype,not
actual one whoch is only one table TAX .





declare
type my_rec_type is record
(c1 tax.col_lbl%type,c2
tax.subj_carr%type);
type my_plsql_table_type is table
of my_rec_type index by
binary_integer;
v_table my_plsql_table_type;
rec my_rec_type ;
num number;
cursor r is select
rownum, col_lbl, subj_carr from
tax;
begin
open r;
loop
FETCH r INTO num ,rec.c1,rec.c2; 
EXIT WHEN r%NOTFOUND;
v_table(num).c1 := rec.c1;
v_table(num).c2 := rec.c2;
end loop;
/* I want to use sql statements for fetch record
like 
select rowi from v_table 
where condition =conditionname
*/
end; 

If  there is any alternative for intermediate
table let me know.

thanx in advance

shishir kumar mishra
[EMAIL PROTECTED]

 

RE: STATSPACK snap_id and time generated...

[Christopher Spence]

Take a look at the statsrep.sql script.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L

Hi,

Can some one pl help find the relation between the snap_id and the time it
was taken. I want ot generate a report for a period of time but having a
hard time trying to figure out the starting snap_id and the end snap_id
for the period.

Thanks in advance.

Anjan

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

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

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

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

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

RE: Export - Import from Oracle v8 to v731

[Christopher Spence]

Title: Export - Import from Oracle v8 to v731









You generally cannot export from a higher level database to a lower.  Although you can probably change the
compatible option to 7.3.4 and do it that way (from what I hear, never tried
it).

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001 11:25 AM
To: Multiple recipients of list
ORACLE-L
Subject: Export - Import from
Oracle v8 to v731

 

Hi gurus, 

i need to transfer db design of a small application
from oracle v8(winnt) to v731(vms=vax). 

I successfully completed the export process:


c:\>exp80 parfile=c:\exp_par.dat 

exp_par.dat 
---

userid=msalah/msalah@qtel

file=c:\test.dmp

tables=(ctv_tv_dockets)

grants=y

indexex=y


then am importing this dump file into oracle v731
which is running on vms-vax. 

imp_par.dat 
-

userid="ops$cssdba/cssdba#act@csscli"

file=c:\test.dmp

tables=(*)

fromuser=msalah

touser=ops$cssdba


c:\>imp71 parfile=c:\imp_par.dat 

here it's giving problem: 

IMP-3: ORACLE error 12151 encountered

ORA-12154:
TNS: could not resolve service name 
IMP-0:
Import terminated unsucessfully 

Note that in interactive mode also i tried to import,
but it's also not working. 

I'm expecting the problem is around 
-

userid="ops$cssdba/cssdba#act@csscli"



here
the password contains # symbol which refers comment usually. 
Before
once i handled it successfully, but i forgot that way. 

anyone have any idea... 

rgds, 
Nirmal.

RE: running catlog,catproc

[Christopher Spence]

Either is fine.

Although if users are logged in it can cause it to be very slow.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L

Hi lists

Is it mandatory that 
catlog.sql, catproc.sql 
should be run while database is in restricted mode.

should I run them while db is running in normal mode (users are logged
in )?

any problems!!! errors !!!


regards,
srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

[Christopher Spence]

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000









Metadink.  I believe it is under 8.1.7.1.0 product.


It lists 2, 3, 4, 5.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Don
 Granaman [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001 12:15 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Problems with
patchsets to 8.1.7.0.0 on Windows 2000

 



I successfully patched 8.1.7.0.0
-> 8.1.7.2.1 -> 8.1.7.2.2 - with the help of a few here (thanks!). 
The 8.1.7.2.1 patchset readme says that the minimal baseline is 8.1.7.0.0 - and
it worked.  Out of curiosity, where did you get 8.1.7.5?  8.1.7.2.2
is the most recent NT/2000 patchset I could find.





 





-Don Granaman





[OraSaurus - Honk if you remember
UFI!]







- Original Message ----- 





From: Christopher
Spence 





To: Multiple
recipients of list ORACLE-L 





Sent: Wednesday,
October 03, 2001 9:25 AM





Subject: RE:
Problems with patchsets to 8.1.7.0.0 on Windows 2000





 



I did 8.1.7.1 then did
8.1.7.5

 



"Do not criticize
someone until you walked a mile in their shoes, that way when you criticize
them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, October 02, 2001
6:26 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Problems with
patchsets to 8.1.7.0.0 on Windows 2000

 

From reading the instructions with 8.1.7.2.1 I had the
impression that you had to move to 8.1.7.1.1 first and then 8.1.7.2 ? In any
case, I had previously installed the Oracle Universal Installer that came with
8.1.7.0.0, and so I used that to apply the patch, because, like you, I was
unable to run the "setup.exe" that came with the patchset. (Windows
2000 server)

RE: Extents size.

[Christopher Spence]

See post which is similar, but per segment, each partition in a partition
table is a different segment.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L

Does the 505 extent "limit" apply to the whole of a partitioned table
or to the number of extents per partition?

For example if I had a table wth 371 partitions (53 weeks per year *
7 years) to hold invoice data for tax purposes, do the number of
extents per partition need to be kept at 1 to avoid exceeding the
505 extent value on the table as a whole?

Christopher Spence wrote:
> 
> LMT's have their own problems as well though.
> 
> Using LMT's, the bitmap on the tablespace is only used to manage free
space,
> used space is in the segment header of the segment which represents the
> extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
> headers (of all tables and indexes in the database) as well as all the
> additional extent maps.  This can cause a very large amount of physical
> reads in comparison to the dictionary-managed extents.
> 
> Although LMT's are great, they are not perfect and do have their share of
> concerns.  And like Connor pointed out, for a 8K block size, it is highly
> suggested to keep the extents to 505 which would only create a single
block
> for the segment header, anything further than that will create additional
> blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
> headers (be it one or two) as well as the extent maps.
> 
> The formula he used is (blocksize / 16)-7, which determine how many
extents,
> can fit in the segment header of a LMT tablespace.
> 
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
> 
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 5:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> True - but we're all using LMT's now anyway aren't we
> ?
> 
> :-)
> 
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > well, only when you are deleting massive amounts of
> > data or truncating
> > with drop storage.. then there is an impact because
> > of the hits on the
> > dictionary tables.
> >
> > but basically yes... I've been told by various
> > Oracle employees that up
> > to 4096 extents cause no problem whatsoever.
> >
> >
> > --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > > That is completely a myth.  There is no notable
> > performance different
> > > with a
> > > table with 10,000 extents and one with 1.
> > >
> > > The only problem is when it comes to the bitmaps
> > when dealing with
> > > LMT and
> > > cluster when dealing with dictionary managed.
> > When you query the
> > > extent
> > > views, or do space management type processes.
> > >
> > > "Do not criticize someone until you walked a mile
> > in their shoes,
> > > that way
> > > when you criticize them, you are a mile a way and
> > have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 7:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > May be it is good practice to keep number of
> > extents to be less than
> > > 50, no
> > > matter what the size of extent.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 3:35 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello,
> > >
> > > I'll do an reorganization of a database (about 140
> > gigs). Some people
> > > say
> > > that it'd be good to use 128K, 4M and 128M
> > extents. I saw somewhere
> > > 

RE: Extents size.

[Christopher Spence]

It depends on block size, but yes for each segment, which is for each index,
table, partition, etc.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 11:25 AM
To: Multiple recipients of list ORACLE-L

Christopher,

Is the guideline 505 extents for the tablespace or each table in the
tablespace?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Wednesday, October 03, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>
---

RE: Disk layout

[Christopher Spence]

DBA Handbook if I remember had a nice section on disk layouts starting out
with preferred and scaled down.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 10:35 AM
To: Multiple recipients of list ORACLE-L

Could anyone please point me towards documentation which discusses optimum
disk layouts for Oracle databases.

Thanks in advcance.

Steven.

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

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

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

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

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

RE: Veritas Quickio and DB_BLOCK_SIZE

[Christopher Spence]

I disagree in the 2k for OLTP as well, for similar reasons Jonathan
mentioned, as well as a few of the obvious.  Most OLTP are not PERFECTLY
tuned to only do indexes scans either.  And indexes are much more efficient
on the larger block sizes as well

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 8:55 PM
To: Multiple recipients of list ORACLE-L

Hi Jonathan,

Sweeping statement...maybe. It all depends on your
application. That's why I put an emphasis on his/her
application (meaning both physical structure and data)
requirements. As a GENERAL rule of thumb, I
(personally) suggest (if possible) 2k for OLTP
databases. It's like if you ask me what car to buy, I
would say a "Honda". But if you were to tell me that
you need speed, style and sex on wheels, I would
suggest a Benz. 

You and I, (especially you!) can argue the
benefits/disadvantages of using 2k block size...Which
I don't care to do. I've put the benefits/reasons of a
2k blocksize at the bottom of this reply just to show
some reverse examples of the ones you replied with.
Some of the reasons should look familiar to you! ;)

Regards,
Satar

1. The OLTP app has lots of small rows (<2k)

2. The OLTP app does massive scattered reads (you
don't full scan in OLTP).  It
reads a block here, a block there based on some
primary key (after doing lots of
scattered reads to walk an index structure)

3. The OLTP app has 1,000 connected users -- each
wants their current row(s) they
are using in the cache. 

4. A smaller block size in a database that does lots
of scattered IO's (eg: an OLTP system) and random
keyed reads can definitely benefit from smaller
blocksizes.

5. The indexes for the critical access paths fit
exactly into an N-layer tree and allow an optimum
buffering strategy when memory is limited.

6. In almost all cases the data for a single index
value will be (significantly) less than 2K and will
all be found in the same block.

7. Memory is at a premium.

--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
> 
> That's a fairly sweeping statement to make without
> any justification - after all, at 2K:
> 
> The block header is a much larger percentage 
> of the block size - so you lose space.
> 
> The probability of wasting space from the
> PCTFREE 
> setting increases - so you lose space.
> 
> The memory overhead due to x$bh is fixed per
> block,
> so you use more memory to hold the same volume
> (block size x block count) of data.
> 
> Index depth may increase through having fewer 
> entries per branch block.
> 
> Latch activity is likely to increase on range
> scans
> because leaf blocks hold fewer entries - you get
> the same effect on tables with clustered data -
> and the effectiveness of IOTs will particularly
> be
> reduced.
> 
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> Author of:
> Practical Oracle 8i: Building Efficient Databases
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: 02 October 2001 21:56
> 
> 
> |If your application allows it, and if the
> Application
> |will not change in the future, then use a 2k block
> |size for OLTP database.
> |
> |If you are not sure on the application needs, then
> |stick with 4k to be safe.
> |


__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

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

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

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

[Christopher Spence]

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000









I did 8.1.7.1 then did 8.1.7.5

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, October 02, 2001 6:26 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Problems with
patchsets to 8.1.7.0.0 on Windows 2000

 

From reading the instructions with 8.1.7.2.1 I had the
impression that you had to move to 8.1.7.1.1 first and then 8.1.7.2 ? In any
case, I had previously installed the Oracle Universal Installer that came with
8.1.7.0.0, and so I used that to apply the patch, because, like you, I was
unable to run the "setup.exe" that came with the patchset. (Windows
2000 server)

> -Original Message- 
> From: Don Granaman [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, October 02,
2001 11:29 AM 
> 
> I have Oracle 8.1.7.0.0
running on a Windows 2000 Pro (sp2).  
> I tried to install

> the 8.1.7.2.1 patchset
according to the "readme" directions 
> (shutdown all 
> Oracle* services first, etc.),
but when I try to run 
> "setup.exe", nothing

> happens.  The icon
flashes momentarily after being 
> double-clicked, but nothing

> ever actually runs.  I
tried it a number of times.  Then I 
> tried it with an

> older 8.1.7.1.1 patchset - and
the exactly same thing 
> happened.  These
patchsets 
> are for "Windows
NT", but I assumed they would work for 2000 
> as well.  (Am I

> wrong in this
assumption?)  Does anyone have any experience 
> with this and/or

> workarounds? 

RE: Extents size.

[Christopher Spence]

LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

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

RE: Extents size.

[Christopher Spence]

I have put together a summary of this thread as a tip on my website:

http://www.vampired.net/forums/viewtopic.php?topic=47&forum=15&0

For those who are interested in this.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L

Thanks.You are right

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:10:30 -0800

Yes, that is very true.  That is why I mentioned the performance will be
noticeable at times when dealing with the extent bitmaps for LMT and the
dictionary for dictionary managed, wither it be ad-hoc or recursive sql.

Unless your doing a lot of truncates or drops, I would bear performance
changes on DML and not DDL.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want t

RE: Please Help

[Christopher Spence]

This is covered very well and in detail in
the manuals, but in short it means you had a transaction write to a rollback
segment, then a long running query requested this information for read
consistency before the transaction (cause it was already started before the
transactions started) and it doesn't have the rollback information
available to rebuild the transaction. 
This usually happens when you have long running queries during heavy
transactional periods.

 

In short, increase your rollback segments
size or number of extents, but don't increase them so much as that they
are huge for your needs.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Riswandi
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 03, 2001
7:01 AM
To: Multiple recipients of list
ORACLE-L
Subject: Please Help

 



Hi lists ...





 





I got this error when I'm running
procedure.





 





- ORA-01555: snapshot too old
(rollback segment too small)





 





Rollback segments statistics:





 





 CLASS 
COUNT
 -- -
 system undo header 0
 system undo block  0
 undo
header   
3
 undo
block
0





 






 (db block gets + consistent gets)/100
 -

1041116.1





 






 SUBSTR(NAME,1,40)   
EXTENTS    RSSIZE AVEACTIVE   OPTSIZE
AVESHRINK   EXTENDS   SHRINKS
 -- - - - -
- - -
 RB0   
3   2170880    328140  
1572864
0
0 0
 RB1   
3   2170880   1828001   1048576  
6291456
7 1
 RB2   
2   1122304    202338   1048576  
1048576
2 2
 RB3   
2   1122304    309818   1048576  
1048576
1 1
 RB4   
2   1122304    352696   1048576  
2097152
2 1
 RB5   
2   1122304    309818   1048576  
1048576 1
1
 RB6   
2   1122304    309818   1048576  
1048576
1 1
 RB7   
2   1122304    320911   1048576  
1048576
1 1
 RB8   
2   1122304    374967   1048576  
1048576
1 1
 RB9   
2   1122304    275972   1048576  
1048576
1 1
 RB10  
2   1122304    254828  
1048576
0 0
0
 RB11  
3   2170880    277233  
1048576
0
1 0
 RB13  
2   1572864    275197  
1310720
0
0 0





 





 SEGMENT_NAME  
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
 -- -- --- ---
---
 RB0
57344 1048576  
2 100
 RB1
57344
1048576  
2 100
 RB2
57344
1048576  
2 100
 RB3
57344
1048576   2
100
 RB4
57344
1048576  
2 100
 RB5
57344
1048576  
2 100
 RB6
57344
1048576  
2 100
 RB7
57344
1048576  
2 100
 RB8
57344
1048576  
2 100
 RB9
57344
1048576  
2 100
 RB10   
57344 1048576  
2 100
 RB11   
57344 1048576  
2 100
 RB13  
524288 1048576  
2 100





 






Please help. ... ...

RE: Oracle -> SQL Server

[Christopher Spence]

Hmm, very interesting, that may be a good option.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L

Also, I believe there is JDBC for MSSQL now - previous there was some
sort of JDBC-ODBC bridging thing, or something like that. So you could
probably use Java stored procedures in Oracle, maybe with a PL/SQL
wrapper, and get at your MSSQL data like that via stored procedure
calls. Hmm.

g



-Original Message-
Sent: Tuesday, October 02, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L



Oh geez, here I go again.

This is trivial with Perl, DBD::Oracle and DBD::ODBC.

Whether it is useful to you depends on a number of things.

* can you use an Oracl copy of the SQL server data?
* does the data always need to be fresh?
* how fresh?
* how big is it?

Since it's temporary, this may work for you.

Jared


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

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

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

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

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

RE: Oracle -> SQL Server

[Christopher Spence]

What did you use for the generic connectivity?  Merant?

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


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

Generic connectivity works fine, I have tried this.
You can query MS SQL server tables, but if you want to execute
packages/procedures of SQL server then you have to use
Transparent Gateway for MS SQL server. This is a separate product by
oracle. (you can get more details about this at
www.oracle.com/gateways

As for as using HSODBC(heterogeneneous ODBC or Generic connectivity) if
your database in ORACLE, then ODBC driver for SQL server has to be used
on UNIX. MERANT is one such provider (www.merant.com).

regards
sunil s.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


Christopher,

What OS is your Oracle DB on?

If on NT and your version >= 816 then you can use the heterogeneous
services
- for some more information see Metalink / doco:

I found note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic
Connectivity using ODBC"
Also note 109730.1 - How to setup generic connectivity (Heterogeneous
Services) for Windows NT 

If your Oracle is on Unix then you could also use Heterogeneous
services,
provided you can get a SQL Server ODBC driver for Unix.

Regards,
Bruce Reardon

-Original Message-
Sent: Wednesday, 3 October 2001 7:25

I was thinking that same thing as the easiest way as I know transparent
isn't cheap and there probably isn't an easy way.

I was going to use Perl/Java to make something if there isn't any other
way
like the OPENQUERY option in SQL Server to look at oracle tables.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 
-Original Message-
Sent: Tuesday, October 02, 2001 4:14 PM
Cc: [EMAIL PROTECTED]

Oh geez, here I go again.

This is trivial with Perl, DBD::Oracle and DBD::ODBC.

Whether it is useful to you depends on a number of things.

* can you use an Oracl copy of the SQL server data?
* does the data always need to be fresh?
* how fresh?
* how big is it?

Since it's temporary, this may work for you.

Jared
 
---

I know there is a way in SQL server to query oracle tables, is there a
way
to do the reverse?

I am looking at trying to create access from an Oracle DB to SQL Server
data until we convert the SQL server database.

Anyone have any ideas on this, I searched technet (ms/oracle) and
metalink,
as well as some search engines without luck.

Christopher R. Spence
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: When optimizer reevaluate SQL statement

[Christopher Spence]

 Considering a SQL statement that is the same, but different users.  The
objects are different, thus a different execution plan is needed.  

I know it is in the manuals somewhere that if a statement has another
parsing user, it is considered a different statement and not sharable.

Either way, if I don't find it when I get in tomorrow, I will do a test in
my lab and show concrete results.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/23/01 10:45 AM

I'm afraid I can't agree with the statement that two different users 
submitting the same SQL cause a hard parse. It is my 
understanding of the process that part of the parsing occurs when 
another user is submitting an identical SQL statement, but this 
does not constitute a hard parse, just a check of permissions, 
synonyms, etc. If there was a hard parse everytime a different user 
submitted identical SQL it would negate much of the benefit of 
using bind variables. Thus the answer is that there is reparsing, but 
not the kind that really does damage to performance.

Regards,
Chris Gait

On 14 Sep 2001, at 9:55, Christopher Spence wrote:

Date sent:  Fri, 14 Sep 2001 09:55:33 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> !! Please do not post Off Topic to this List !!
> 
> If the Oracle executing user is different, the execution plan will be
> different due to possibility of different objects and security.
> 
> Different sessions under the same user can share using bind variables.
> 
> "Do not criticize someone until you walked a mile in their shoes, that
way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Friday, September 14, 2001 12:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> !! Please do not post Off Topic to this List !!
> 
> Chris:
> 
> > If you are executing it under a different user the statement will be
> reparsed.
> 
> I'm puzzled. I always thought that different users submitting the
identical
> SQL statement would use the same plan and not need to be reparsed. I
> understood that to be part of the reasoning behind bind variables and
the
> big advantage of cursor sharing. Please explain.
> 
> Jon Walthour
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Walthour, Jon (GEAE, Compaq)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


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

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

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

Fat City Network Services-- (858) 53

RE: Extents size.

[Christopher Spence]

Yes, that is very true.  That is why I mentioned the performance will be
noticeable at times when dealing with the extent bitmaps for LMT and the
dictionary for dictionary managed, wither it be ad-hoc or recursive sql.

Unless your doing a lot of truncates or drops, I would bear performance
changes on DML and not DDL.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

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

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

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

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

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

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

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


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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to 

RE: Oracle -> SQL Server

[Christopher Spence]

I was thinking that same thing as the easiest way as I know transparent
isn't cheap and there probably isn't an easy way.

I was going to use Perl/Java to make something if there isn't any other way
like the OPENQUERY option in SQL Server to look at oracle tables.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Oh geez, here I go again.

This is trivial with Perl, DBD::Oracle and DBD::ODBC.

Whether it is useful to you depends on a number of things.

* can you use an Oracl copy of the SQL server data?
* does the data always need to be fresh?
* how fresh?
* how big is it?

Since it's temporary, this may work for you.

Jared




 

    Christopher

Spence   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
 Subject: Oracle -> SQL Server

Sent by:

[EMAIL PROTECTED]

om

 

 

10/02/01 11:40

AM

Please respond

to ORACLE-L

 

 





I know there is a way in SQL server to query oracle tables, is there a way
to do the reverse?


I am looking at trying to create access from an Oracle DB to SQL Server
data until we convert the SQL server database.


Anyone have any ideas on this, I searched technet (ms/oracle) and metalink,
as well as some search engines without luck.





"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence


Oracle DBA


Phone: (978) 322-5744


Fax:(707) 885-2275


Fuelspot


73 Princeton Street


North, Chelmsford 01863












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

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

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

RE: Oracle -> SQL Server

[Christopher Spence]

It is for something which won't have a huge budget as the data is moving
over to Oracle eventually, but for now we want access to it.  I was thinking
about just building a java/perl replication engine for now.  It isn't a lot
of data.  But if there was something pre-packaged it would be nicer.

I think the transparent gateway was dropped, either way it is so expensive
and out of the range for such a small project.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L

Hi Christopher,

It can be done, Usually from third party software
companies. For example, Check out:
http://www.datamirror.com/products/tserver/

Back in the day (1996), Oracle had a "Mainframe &
Integration Technologies" group that handled such
problems. You might want to contact Oracle and see if
such a group still exists and if they can provide you
with a solution.

Regards,
Satar


--- Christopher Spence <[EMAIL PROTECTED]> wrote:
> I know there is a way in SQL server to query oracle
> tables, is there a way
> to do the reverse?
> 
> I am looking at trying to create access from an
> Oracle DB to SQL Server data
> until we convert the SQL server database.
> 
> Anyone have any ideas on this, I searched technet
> (ms/oracle) and metalink,
> as well as some search engines without luck.
> 
> 
> "Do not criticize someone until you walked a mile in
> their shoes, that way
> when you criticize them, you are a mile a way and
> have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> 
> 


__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

[Christopher Spence]

Same problem, go into the install directory and Win32 I think it was, the
install works fine from there. 

Just shear luck I just setup two Win2000 boxes in my lab for Replication,
heh.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L

I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2).  I tried to
install
the 8.1.7.2.1 patchset according to the "readme" directions (shutdown all
Oracle* services first, etc.), but when I try to run "setup.exe", nothing
happens.  The icon flashes momentarily after being double-clicked, but
nothing
ever actually runs.  I tried it a number of times.  Then I tried it with an
older 8.1.7.1.1 patchset - and the exactly same thing happened.  These
patchsets
are for "Windows NT", but I assumed they would work for 2000 as well.  (Am I
wrong in this assumption?)  Does anyone have any experience with this and/or
workarounds?

-Don Granaman
[OraSaurus - Honk if you remember UFI!]

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

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

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

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

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

Oracle -> SQL Server

[Christopher Spence]

Title: Oracle -> SQL Server





I know there is a way in SQL server to query oracle tables, is there a way to do the reverse?


I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database.

Anyone have any ideas on this, I searched technet (ms/oracle) and metalink, as well as some search engines without luck.


"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 

Oracle DBA

Phone: (978) 322-5744

Fax:    (707) 885-2275

Fuelspot

73 Princeton Street

North, Chelmsford 01863

 

RE: Loadjava utility

[Christopher Spence]

Doesn't matter, they get loaded into the java tables as lobs.
 
As long as the loadjava command has access to the file when you run it.
You can then delete the files if you so choice.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 2:25 PM
To: Multiple recipients of list ORACLE-L

Hello all,
I want to load in ther server two jar files, through the loadjava
utility. But, where should be this files physically stored? Should they
be in any folder under ORACLE_HOME directory?
A lot of thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

RE: pl/sql question

[Christopher Spence]

Use DBMS_SQL or EXECUTE IMMEDIATE

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L


Can I somehow use a variable for the table name in a cursor select?

Here is the example:

--Declaration Section

 sSrcTableName  VARCHAR2(50)   := iFeedNm||'_1_1_'
||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC';

 --cursor for tmo daily source records
 CURSOR cTMODaily IS
  SELECT*
  FROM   sSrcTableName;

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

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

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

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

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

RE: Meaning of V$WAITSTAT statistics

[Christopher Spence]

Save undo is when a tablespace has undo information, but is currently
offline.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L

Hello !
 I need to know what is the meaning of the "save undo block" and "save
undo header" statistics in the V$WAITSTAT view.

TIA.
Alejandra.




_
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

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

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

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

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

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

RE: Problem in setting PCTFREE and PCTUSED

[Christopher Spence]

You can not make an intelligent guess at what these values should be without
knowing:

1.  Average Row Length
2.  Blocks Size
3.  Average Rows/Block
4.  How active the table is for insert, deletes, updates.
5.  Average size of updates (1,2,3 columns, 1 byte, 10 bytes)

Without these pieces of information, you just as well keep the defaults, it
is just mere guessing to set them to anything else.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 7:40 AM
To: Multiple recipients of list ORACLE-L

Hello !
After having defined all the tables, now I have to parametrize each table.
I have some tables that every day must be deleted and reloaded through sql
loader.
I think to set PCTFREE = 0, but I don't know if I have to specify a
particular value for PCTUSED.
Anybody can give an advice about which value set PCTUSED ?

Thanks in advance,
Andrea
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Quaglio Andrea
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Extents size.

[Christopher Spence]

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1. 

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

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

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

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

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

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

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

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

RE: BEGIN BACKUP MODE !!

[Christopher Spence]

It freezes increasing the SCN of the data files associated with the
tablespace.  Then it writes full block data to the redo logs instead of the
standard old, new, operation data.  If the block has already been written
out, it will use an algorithm to avoid constantly writing out the same
blocks.

However, in nutshell, there is an increased log on the logs and archive logs
as well as their processes.  Transactions go along fine with no differences.
In addition, yes, data IS written to the data files while in begin backup
mode and thus corrupting the data files (that is why full blocks are written
out so they can be overlaid over the corrupted blocks in their entirety).

It is not recommended to do more than one tablespace in backup mode at the
same time on a highly transactional system.  Although this is highly system
dependant.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L



Hello All,


When you take begin back up of  tablespace what exactly oracle does
internally.

what happen the transcation in that period.

Please tell me .
Regards,
saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Those who like/dislike CA may be interested

[Christopher Spence]

1.27 million isn't much at all.

They will probably talk them down to 500k and just pay it off.
Cheaper than keeping lawyers on it for 3 years.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L

DOJ hits CA with antitrust lawsuit over Platinum buyout

The Department of Justice has hit Computer Associates with an antitrust
lawsuit
seeking up to $1.27 million in penalties related to its 1999 purchase of
Platinum Technology. The company quickly denied the charge.

http://computerworld.com/nlt/1%2C3590%2CNAV47_STO64375_NLTAM%2C00.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Searching across multiple columns

[Christopher Spence]

You might want to look into the Intermedia, it has full text search.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L

Does Oracle have a way to do a search across multiple columns/tables for
specific data?  I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?

Thanks for the information,

Rick Stephenson


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

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

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

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

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

RE: rollback segments during export

[Christopher Spence]

Think about it this way,


(Session 1)
SET TRANSACTION READ ONLY
Select * from emp;

22 rows selected.


(Session 2)
Delete from emp where dept = 20;

6 rows deleted.

Commit;

Commit complete.


(Session 1)
Select * from emp;

22 rows selected.


Export is the same as any other transaction, although unfortunately it does
not show up in v$transaction (which I think it should).

Export will attempt to maintain read consistency throughout the life of the
export cycle as well as throughout all the objects, although this isn't
always possible (running out of RBS) and sometimes this process fails.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


John,

You're making perfect sense, as that is the way I've
always thought it worked.  Based on some previous 
threads I read ( don't know if it was this list ) and
ambiguous language in the docs, I'm not sure if it
actually works that way.

Jared

On Monday 01 October 2001 00:50, John Kanagaraj wrote:
> Jared et al,
>
> My understanding could be flawed, but I think that setting 'CONSISTENT=Y'
> just adds a 'SET TRANSACTION READ ONLY' to the entire export process and
> thus ensures that all subsequent queries read all tables as of the time
the
> export started. Keep in mind that an export just does a 'select * from
>  along with a lot of other DDL generation.
> This is the reason you can expect ORA-01555 errors when trying to read
from
> a wrapped-around or shrunk rollback segment in the case a read-consistent
> read is required
>
> I hope I am making sense here
>
> John Kanagaraj
> Oracle Applications DBA
> DB Soft Inc
> Work : (408) 970 7002
>
> Listen to great, commercial-free christian music 24x7x365 at
> http://www.klove.com
>
> ** The opinions and facts contained in this message are entirely mine
> and do not reflect those of my employer or customers **
>
> >-Original Message-
>
> From: Jared Still [mailto:[EMAIL PROTECTED]]
>
> >Sent: Sunday, September 30, 2001 12:40 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Re: rollback segments during export
> >
> >
> >
> >Chris,
> >
> >> Just because there is a PK/FK between tables, it does not
> >
> >mean they will be
> >
> >> exported in the same transaction.  And thus, possibly out of sync.
> >
> >I didn't say there was. My implication was that your
> >tables would get out of sync.  Setting 'consistent=y'
> >
> >won't prevent that:
> >: If you specify CONSISTENT=N (the default), each table is
> >
> >usually exported
> >
> >: in a single transaction. However, if a table contains nested
> >
> >tables, th
> >
> >Now it *could* be that I'm misreading the docs.  It' been known
> >to happen, but that sentence says to me that each table is
> >exported as part of a single transaction.
> >
> >Anyone have proof to the contrary?  The tech writer is being
> >rather ambigous, at least I think so.
> >
> >Jared
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jared Still
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

RE: How much data can SQL*Server hold?

[Christopher Spence]

Title: How much data can SQL*Server hold?









I think SQL Server can hold up to 5Mb.

 

Just kidding, in 6.5 it is 1Tb, in 7.0 It is 1,048,516 TB

 

32k dbs/server

32gb file size in 6.5, and 4tb file size in 7.0

 

And a max of 2 billion objects if I remember correctly.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 01, 2001 11:50 AM
To: Multiple recipients of list
ORACLE-L
Subject: How
much data can SQL*Server hold?

 

Hello everyone, 

Any of you using SQL*Server on fairly large
databases? If so please email me directly. 

I have a consulting company telling me they can run
a 500GB+ database on SQL*Server with no problems and I'm pretty
skeptical.  What's the largest implementation of SQL*Server you've seen?
Does SQL*Server have parallel server functionality?

Lisa Koivu 
Oracle Database
Administrator 
Fairfield Resorts, Inc.

954-935-4117

RE: ORA-03113 when executing the initjvm script

[Christopher Spence]

I notice this happens when you don't have enough rollback space.
You may want to go through and check back and see what the original error
was.

You may want to increase your SP a little and decrease your JP a little.
Although it is recommended to have SP: 20M  JP: 30M for the install, 90M of
rollback, and if I remember 130M of System Tablespace.

Also, there is a bug on metadink regarding changing call to execute, seems
to cause this problem as well.  Forget the bug number.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L

Hello all of you,
I get  the ORA-03113 (end-of-file on communication channel) error when I
execute the initjvm script. This script is needed to use utl_smtp
package. Here is the output I get:
***
ERROR:
ORA-03114: not connected to ORACLE
create or replace java system;
*
ERROR en línea 1:
ORA-03113: end-of-file on communication channel
*

The script is composed of several calls to another scripts, and is in
the second one, the initjvm2.sql where the error appears.
I have checked the trace and log files, but there isn´t any one that
give me a clue on the problem.
I have read something about checking some parameters, here is the output
showing them:
**
SQL> select * from v$parameter
  2  where name like '%pool_size%';

   NUM
NAME
TYPE
--

--
VALUE



ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ
- - - -- -
DESCRIPTION

23
shared_pool_size
2
19643392
FALSE FALSE FALSE FALSE  FALSE
size in bytes of shared pool

28
large_pool_size
2
614400
FALSE FALSE FALSE FALSE  FALSE
size in bytes of the large allocation pool

30
java_pool_size
2
5250
FALSE FALSE FALSE FALSE  FALSE
size in bytes of the Java pool
*
I think they are setting correctly...
Has anyone faced this problem?
TIA,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

RE: rollback segments during export

[Christopher Spence]

Yes, under CONSISTENT=N they are exported as separate transactions, under
CONSISTENT=Y it is a large single transaction to keep read consistency
across the entire export.  Hence the redo generated is similar to a large
report and read consistent views.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Sunday, September 30, 2001 3:40 AM
To: Multiple recipients of list ORACLE-L


Chris,

> Just because there is a PK/FK between tables, it does not mean they will
be
> exported in the same transaction.  And thus, possibly out of sync.

I didn't say there was. My implication was that your 
tables would get out of sync.  Setting 'consistent=y'
won't prevent that:

: If you specify CONSISTENT=N (the default), each table is usually exported 
: in a single transaction. However, if a table contains nested tables, th

Now it *could* be that I'm misreading the docs.  It' been known
to happen, but that sentence says to me that each table is
exported as part of a single transaction.  

Anyone have proof to the contrary?  The tech writer is being
rather ambigous, at least I think so.

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

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

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

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

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

RE: DBA assessment - slightly OT

[Christopher Spence]

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

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

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

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

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

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

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

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

RE: VB/Oracle question

[Christopher Spence]

You will need to distribute the drivers as well, of course, it depends on
the type of interface, ADO, DAO, OLE.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, September 26, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L

If I was going to distribute a client VB application connecting to Oracle,
would I need to also distribute the Oracle Client tools or is there a small
driver package to install without all the tools?
Thanks,

Brian King
mailto:[EMAIL PROTECTED]


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

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

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

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

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

RE: Does start with/connect by uses full table scan?

[Christopher Spence]

You want to make sure there is an index on the start with and connect by
clauses.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, September 24, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L

List,

Does Oracle go for full table scan or does it use indexes when we use start
with/connect by clause?

Thanks,

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

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

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

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

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

RE: Physical access to servers for maintenance

[Christopher Spence]

 an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

RE: DBA assessment - slightly OT

[Christopher Spence]

1.  What is the difference between a lock and a latch?
2.  Explain what spinning is and why is it necessary?
3.  What is the PL/SQL catch all exception called?
4.  Where would you "read" about a deadlock that occurred?
5.  How would you verify your data files you just backed up are not corrupt?
6.  Explain what two significant things that occur when you do a BEGIN
BACKUP on a tablespace.
7.  Explain the use of DECODE function.
8.  What is a correlated sub query?
9.  Explain the "snapshot too old" error, and when does it commonly occur.
10. What three powerful Oracle tuning tools require timed_statistics?

These are off the top of my head, I had a nice drawn up list I spent more
time on, but it is at home I think.

HTH, 

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, September 26, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L

If you were to choose 10 questions to evaluate the competency of a DBA what
would they be given that the result would be their competence would be rated
as of the following:
 
- TERRIBLE  (I would not let them within 100 miles of a database)
- FAIR  (I'd show them some basic admin, but do it myself, they've a
lot to learn yet)
- GOOD  (I'd let them do some basic admin stuff by themselves but
monitor their performance regularly)
- VERY GOOD (I'd let them handle practically all admin type work and mentor
them as required)
- EXCELLENT (Hell, they could teach me a trick or too!)


Sean :)

Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too."  - BB King



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Physical access to servers for maintenance

[Christopher Spence]

8.1.6 and higher you must use the interactive installer, it will not work
through telnet.  As far as I have seen, it is the same for 9i as well,
unless I missed the documents on a new character based installer.

Unless something has changed recently.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, September 26, 2001 9:10 AM
To: Multiple recipients of list ORACLE-L

Ohhh, it works!
All you need is  ... ???

(Telnet server alias telnetd)
:-)))


JP
On Wed 26. September 2001 14:45, you wrote:
> This doesn't work for NT machines, and it with Unix you cannot install
> 8.1.6 without X access.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
> -Original Message-
> Sent: Tuesday, September 25, 2001 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
> What's wrong with telnetting in?
> -Original Message-
> Sent:   Tuesday, September 25, 2001 11:20 AM
> To: Multiple recipients of list ORACLE-L
>
> -- "Smith, Ron L." <[EMAIL PROTECTED]>
>
> > Our hardware people are cracking sown on access to the computer room.
> > They have decided the DBA group can do all their work without going to
> > the server itself.  This includes Unix and NT server running both Oracle
> > and SQL Server. We would have to use VNC Viewer and PC Anywhere.  I am
> > trying to put together a list of things we might need to do that would
> > make remote admin difficult as well as taking longer.  If you have any
> > ideas I would appreciate it.
>
> How about "Your Work"?
> Last time I looked it's rather hard to run svrmgrl without access to
> the command line.  So long as you don't want to start or stop the
> database this probably won't have any effect.
> Checking free disk space is also simpler with "df".  You can, perhaps,
> memorize the nubmber of blocks on every device and compare them to the
> free space reported by Oracle each morning.
> Simplest method would be to say "no we don't need it now, what is the
> pager number of someone we can use if we do need things done?"  Make
> a point of paging them every time you need something from the shell,
> day or night.  That person will, I'm sure, be happy to compile a list
> of the trivial things they've been forced to do that the DBA should have
> done for themselves at 3am...


Content-Type: text/html; name="Pøíloha: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

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

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

RE: Physical access to servers for maintenance

[Christopher Spence]

I do 99% of what I need from SSH as well, the only exception is hardware and
installs, which I have someone in the data center do.

Of course, under NT this is completely different.
Although Win2000 does have a funky Telnet.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, September 25, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L

At 12:25 PM 9/25/2001, Kimberly Smith wrote:
>Steven, although you need all that you say we need you
>sure don't need access to the server room for that.  At
>the very least there is telnet, which is what I use from
>home.  Then there are things like Exceed and Xterms, which
>is what I use at work.  By no means do you need access
>to the server itself to do the "day to day" stuff.

OK so i can do 95-98% of what i need to do without access to the servers. 
[i use SSH myself.]  but those few time i need access it's because 
something is badly wrong with either the server or the network, and those 
time i really need the access.  so i prefer to keep my access rather tan 
give it up.  they are after all , *my* databases, and i'm the one
responsible.




--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

The attention span of a computer is only as long as its power cord.



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

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

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

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

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

RE: Physical access to servers for maintenance

[Christopher Spence]

Title: RE: Physical access to servers for maintenance









This doesn't work for NT machines,
and it with Unix you cannot install 8.1.6 without X access.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, September 25, 2001
11:45 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Physical access to
servers for maintenance

 

What's wrong with
telnetting in?  

-Original Message- 
From:   Steven Lembark
[SMTP:[EMAIL PROTECTED]] 
Sent:   Tuesday, September 25, 2001 11:20 AM

To: Multiple recipients
of list ORACLE-L 
Subject:   
Re:
Physical access to servers for maintenance 

 

-- "Smith, Ron L." <[EMAIL PROTECTED]>


> Our hardware people are cracking sown on access
to the computer room. 
>
They have decided the DBA group can do all their work without going to

>
the server itself.  This includes Unix and NT server running both Oracle

>
and SQL Server. We would have to use VNC Viewer and PC Anywhere.  I am

>
trying to put together a list of things we might need to do that would

> make
remote admin difficult as well as taking longer.  If you have any

>
ideas I would appreciate it. 

How about "Your Work"? 

Last time I looked it's rather hard to run svrmgrl
without access to 
the
command line.  So long as you don't want to start or stop the

database
this probably won't have any effect. 

Checking free disk space is also simpler with
"df".  You can, perhaps, 
memorize
the nubmber of blocks on every device and compare them to the 
free
space reported by Oracle each morning. 

Simplest method would be to say "no we don't
need it now, what is the 
pager
number of someone we can use if we do need things done?"  Make

a
point of paging them every time you need something from the shell,

day or
night.  That person will, I'm sure, be happy to compile a list

of the
trivial things they've been forced to do that the DBA should have

done
for themselves at 3am... 

-- 
Steven
Lembark  
2930 W. Palmer 
Workhorse
Computing  
Chicago, IL 60647 
   
+1 800 762 1582 
-- 
Please
see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author:
Steven Lembark 
 
INET: [EMAIL PROTECTED] 

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


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

also
send the HELP command for other information (like subscribing). 

RE: Rachel - RE: 2nd DBA or ?

[Christopher Spence]

Geesh, and I got bashed (and still do) for being sarcastically egotistic.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> way too cynical.

Thanks! It's this personality (or lack of) that has
made me very sucessful at my age. I was driving a 45k
dollar car (which you rode in) and owned my first
house at age 23. Now at 26, I also own a new Benz
(valued at 75k) and own a second home. I hate to sound
egotistical (isn't that one of the traits of a good
DBA?), but I just want you to know where I am coming
from.

> One of the few things I learned in the management
> class I took was "you have to train the people
> below you to do your job if you ever want a
> promotion"

Who wants to work in Management? At my full-time job,
I make close to what my boss makes (he is the CIO) but
without all the responsibility and dealing with
personal problems. To me, if you know the basics of
Business Management and Child Psychology, you'll do
well in Management.
 
> If no one else can do what you do, then you can't
> move on to other things.

Maybe because I'm still young, but I always believe
that your future is in your own hands, not at your
company's discretion. If I don't get what I want, then
I move on to another company. It might change when I
get married and have kids, in which I have to worry if
my child eats Frosted Flakes cereal in the morning or
if he/she goes to school hungry. Until then, I am
free.
 
> On the other hand, Satar is a consultant.

I also have a full time job, but hopefully I can quit
my job soon if this project I'm currently working on
is sucessful. I have goals, and I am close to
self-actualizing them. 

> And looking at the world from that direction, you
> wouldn't want anyone else around to do what you do
> because you'd lose the contract if there were a
> full-timer around (you can have a fulltimer put in
> extra hours without having to pay more)

Nice philosophy. In a dog-eat-dog world, it's good not
to be a dog! Also, if you live in California, chances
are you are getting paid by the hour, along with
overtime. California residents, you might want to look
into California Assembly Bill 60 (AB 60) on the
internet.
 
> But as a full-time employee, I want someone else
> around. Because there is ALWAYS too much work for
> one person, at least in my shop.

The MIS managers or system admins can experience
Oracle Support if they can't get a hold of me.
Unfortunately, they put a lo-jack system (cell phone)
on me, so I am available to them 24/7. To date, after
1 and half years working for this company, none of my
databases have experienced any problems. I like to
think it's due to my expertise, or maybe I'm wrong,
and it's just luck.

Also, I hope this doesn't come across mean or
unappreciative, but if you remove yourself from the
list, you will give yourself so much more time to
tackle the work at your shop. As you might have
noticed, I removed myself from the list for 7-8 months
while my company gave me the responsibility of UK's
databases. I needed that time to go to the UK,
configure and tune the datbases, setup an automated
backup and recovery procedure, post application tuning
and provide remote support, along with other things. 

I do have to agree with Christopher Spence, if this is
a in-house Development, or continued developed oracle
application environment, then of course you will need
additional people to help you out.

I initially replied to this post, because I was given
the same opportunity to bring in another DBA for the
UK. I chose to do the job myself, eliminating a
part-time DBA that was positioned in the UK and also
removing the need for Oracle Support in the UK (which
is extremely expensive compared to the US). 

I made my suggestion based on my previous experiences
as a consultant working for corporate America. You may
call it cynical and paranoid, which is ok because
everyone is entitled to their own views, but this is
my reality.
 
> Rachel

Regards,
Satar

PS I'm glad to see you are OK from last week's
attacks. I was praying for everyone in NY and
Washington, especially for you. I hope you and your
family are doing well. 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar nagh

RE: Design Issue - Quick response appreciated

[Christopher Spence]

T spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

RE: Undo x Rollback Segments in 9i

[Christopher Spence]

I don't have a lot of extensive experience with 9i, but from what I red, you
can change it on the fly.  Don't quote me on it.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


Christopher,

Can you switch modes once the database has been in use for a while?
Or do you need to recreate the database in order to do that?

Thanks,

Cherie


 

    Christopher

    Spence   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>  
 Subject: RE: Undo x Rollback
Segments in 9i  
Sent by:

[EMAIL PROTECTED]

om

 

 

09/21/01 02:30

PM

Please respond

to ORACLE-L

 

 





There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old
method
of doing redo.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT "RBS01"  TABLESPACE "RBS"
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito!
http://explorer.msn.com.br

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

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

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

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

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




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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
t

RE: Undo x Rollback Segments in 9i

[Christopher Spence]

There are two modes of rollback in 9i, undo and rollback.  You either use
the old way, or the new automatic way, but not both.

You would need to turn off the new feature if you want to use the old method
of doing redo.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, September 20, 2001 9:40 PM
To: Multiple recipients of list ORACLE-L


Friends :

I tried to create a rollback segment in 9i and its said to me :

CREATE PUBLIC ROLLBACK SEGMENT "RBS01"  TABLESPACE "RBS"
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Well, i realized that Oracle created for me some resource like rollback 
segment automaticaly.

My doubt :

If i will put the instance in Manual Undo I can to create the rollback 
segment, but i will lost the resource automatic.

does anyone use it or know how to use Automatic Undo ?

What is the best option :

Rollback or Undo Automatic.
I know rollback but i don't know Undo Automatic

Regards

Eriovaldo

_
Chegou o novo MSN Explorer. Instale já. É gratuito! 
http://explorer.msn.com.br

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

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

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

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

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

RE: Waking SMON Not Doing Trick

[Christopher Spence]

blic Internet access / Mailing Lists

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

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

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

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

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

RE: Waking SMON Not Doing Trick

[Christopher Spence]

uru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

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

RE: Design Issue - Quick response appreciated

[Christopher Spence]

Then use a surrogate key, i.e. sequence
number.

 

Numbers that change are not candidates for
key, doing so introduces problems in which you are having as well as others.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001 2:30 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Design Issue - Quick
response appreciated

 



In our case, we do not
have any other columns --- 1. which could identify uniquely a record and yet do
not undergo a change.





 





Thanks,





 





Rao





-Original Message-----
From: Christopher Spence
[mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001
1:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Design Issue - Quick
response appreciated

Generally it is bad
practice to use columns in the primary key, which change.  They introduce many different problems.

 



"Do not criticize
someone until you walked a mile in their shoes, that way when you criticize
them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001
12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: Design Issue - Quick
response appreciated

 



List,





 





OLTP
application with 24x7 requirement. 300,000 records per day are inserted
into the transaction table. Environment: Solari 7. Oracle 817.





 





The
transaction table layout.





 





Security
ID  





Account
ID





Account
Type





Trade
Date





And other
columns in this table.





 





In the
above table, the primary key is -- Security ID + Account ID + Account Type +
Trade Date





 





There
are many to one relationships built to other child tables
from Transaction Table





 





Scenario:





 





User
inserts a record into transaction table.  In the first record, Account ID
value is "HP" and he might insert a record into the child table (Or
this transaction may not insert a record into a child table). After some time,
the user queries the original record with the primary key and then changes the
value in the column - Account ID to  "IBM".  Now, the
original transaction record is NOT UPDATED.  A record IS INSERTED with the
new values.  Also, he might or might not insert a record into a child table
with this new values of primary key.





 





Now the
user would query the transaction table with Account ID = IBM. 
But, the user wants to get all the previous records also; in this case, he
want to see the record with Account ID = "HP" also. Also, he want to
see the related records from the child tables. 





 





I tried
with the idea of sequence number generation but it was failing.





 





Any
ideas or suggestions are much appreciated.





 





Thanks,





 





Rao





Maheswara
Rao,





Oracle
DBA





SunGard
Securities
 

RE: coalesce tablespace

[Christopher Spence]

SMON very poorly does coalesce and a source of many problems.  
(ST Enqueue which is serial for atomic modification of the data dictionary).

I always set my PCTINCREASE 0, and manually coalesce or use LMT.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, September 21, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L

Yes, But in your case being pctincrease set as '1' you will most of the time

see 100% in your last column. Even if you don't coalesce manually, it will 
be done by smon internally with regular interval...

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 21 Sep 2001 03:23:27 -0800

Does this also apply to a temporary tablespace??  I have a temp TS that has
a percent extents coalesced of 1.

Thanks,

Dave

-Original Message-
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs

select substr(tablespace_name,1,10)TS_NAME,total_extents
"Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 20 Sep 2001 12:21:21 -0800

It would take contiguous free extents and make them larger extents, which
would be more likely to reuse.  Especially if there are many smaller ones,
this moot if using LMT.

It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

We have tablespaces in acceptance and production that are being resized for
growth.  Pctincrease is set at 0.  Would it also help to coalesce the
tablespace?  What are the benefits of this command?
Thanks,
Sandi

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

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

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

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

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


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

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

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

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

Fat City Network Services-- (858) 538-5051  FAX

RE: Design Issue - Quick response appreciated

[Christopher Spence]

Generally it is bad practice to use columns in the primary key, which
change.  They introduce many different
problems.

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 21, 2001 12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: Design Issue - Quick
response appreciated

 



List,





 





OLTP application with
24x7 requirement. 300,000 records per day are inserted into the
transaction table. Environment: Solari 7. Oracle 817.





 





The transaction table
layout.





 





Security ID  





Account ID





Account Type





Trade Date





And other columns in this
table.





 





In the above table, the
primary key is -- Security ID + Account ID + Account Type + Trade Date





 





There
are many to one relationships built to other child tables
from Transaction Table





 





Scenario:





 





User inserts a record
into transaction table.  In the first record, Account ID value is
"HP" and he might insert a record into the child table (Or this
transaction may not insert a record into a child table). After some time, the
user queries the original record with the primary key and then changes the
value in the column - Account ID to  "IBM".  Now, the
original transaction record is NOT UPDATED.  A record IS INSERTED with the
new values.  Also, he might or might not insert a record into a child
table with this new values of primary key.





 





Now the user would query
the transaction table with Account ID = IBM.  But, the user wants to
get all the previous records also; in this case, he want to see the record with
Account ID = "HP" also. Also, he want to see the related records from
the child tables. 





 





I tried with the idea of
sequence number generation but it was failing.





 





Any ideas or
suggestions are much appreciated.





 





Thanks,





 





Rao





Maheswara Rao,





Oracle DBA





SunGard Securities