date:20030613

Hey its always nice to put faces to the names.

Now I know how 1 List member looks like.

:-)

Regards
Naveen

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Friday, June 13, 2003 12:20 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: World premier performance of the BAARF party logo
 
 
 Here are pics if interested.
 
 http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg
 http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg
 
 I too do not understand why vendors push RAID 5 when 
 RAID 10 is clearly more profitable.  I speculate that they
 may be afraid of being accused of overselling when 
 PHB's discover the RAID 10's they just purchased could
 have been RAID 5's for less money.
 
 
 Jared
 
 
 
 
 
 Niall Litchfield [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  06/12/2003 10:04 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: World premier performance of the 
 BAARF party logo
 
 
 Jared writes
  At the meeting last week I wore my 'No RAID 5' hat.
  
  Those of you at IOUG 99 in Denver may have seen it, I 
  wore it every day there.  ;)
 
 I'm curious now. Pictures required.
 
 Meanwhile I have never understood why storage vendors would prefer
 selling RAID5 over RAID10. More disks=more profit surely? Also 10  5
 therefore self evidently twice as good for all applications. Meanwhile
 we have this strange situation where performance consultants are
 publicising the fact that you have less need for performance 
 consultants
 with RAID10 than with RAID5. 
 
 Niall 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Niall Litchfield
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


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

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

Re: Trigger double firing apparently double inserts

2003-06-13 Thread Ryan

your doing an insert select. have you checked to see if you are selecting
two records? you can add where rownum  2

and you can verify that two records are being inserted by added a primary
key to the recipient table and you should get a constraint error if this is
correct.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 3:09 AM


 Hi Listers

 I have a trigger that is an on update trigger that is somehow writing two
 records when a record is updated in the table that the trigger is
 associated with.
 I have run the select statement to see if it will retrieve multiple
 records and the msf071 table that has the record that causes the trigger
 to fire has only on record for the equip_no
 Why does it do this and how do I fix it.
 As you might notice it inserts across a link
 I have had a loom at Metalink but wasn't able to locate anything

 Trigger code below

 create or replace trigger msf071_archibus_update
   after update on msf071
   for each row
 declare
   -- local variables here
   v_equip_number msf071.ENTITY_value%TYPE;
  v_equip_class  msf600.equip_class%TYPE;
  v_attrib_value MSF6A4.Attrib_value%TYPE;
  v_ref_value  msf071.Ref_code%TYPE;
  v_entity_type msf071.entity_type%TYPE;



 begin

 v_equip_number := :old.Entity_value;
 v_entity_type := :old.entity_type;
 v_ref_value := :new.ref_code;
 IF  v_ref_value = ('U')  AND v_entity_type = 'EQP' THEN

 INSERT INTO [EMAIL PROTECTED] (equip_no,
  dstrct_code,
  NAME,
  assoc_value,
  equip_status,
  active_flag,
  parent_equip,
  equip_classif_3,
  sizecell,
  sizem,
  aream,
  suburb,
  postcode,
  street_no,
  street_name,
  state)
   SELECT c.equip_no,
  dstrct_code,
  c.item_name_1,
  substr(h.assoc_rec, 1, 1),
  equip_status,
  active_flg,
  parent_equip,
  equip_classifx3,
  to_number(d.attrib_value_num_9),
  To_number(e.attrib_value_num_9) SIZE,
  to_number(f.attrib_value_num_9) AREASQM,
  substr(g.suburb, 1, 30),
  substr(g.zip_code, 1, 4),
  street_no,
  substr((g.street_name|| ' ' || a.table_desc)
 ,1,50)STREET_TYPE,
  substr(b.table_desc, 1, 30) STATE
 FROM MSF600 c, view_MSF6a4_cellsize d, view_msf6a4_size e,
 view_msf6a4_area f, MSF011 g, view_msf010_assoc_value h,
 view_msf010_streettype a, view_msf010_state b
 WHERE c.equip_no = v_equip_number AND
 c.Equip_no = d.equip_no(+) AND
 c.Equip_no = e.equip_no(+) AND
 c.Equip_no = f.equip_no(+)AND
 c.equip_class = h.table_code  AND
 c.location = g.location(+) AND
 g.street_type = a.table_code(+) AND
 g.state = b.table_code(+) ;

 /*end loop;*/

 END IF;

 end msf071_archibus_update;




 --
 =
 Peter McLarty   E-mail: [EMAIL PROTECTED]
 Technical ConsultantWWW: http://www.mincom.com
 APAC Technical Services Phone: +61 (0)7 3303 3461
 Brisbane,  AustraliaMobile: +61 (0)402 094 238
 Facsimile: +61 (0)7 3303 3048
 =
 A great pleasure in life is doing what people say you cannot do.

 - Walter Bagehot (1826-1877 British Economist)
 =
 Mincom The People, The Experience, The Vision

 =

 This transmission is for the intended addressee only and is confidential
 information. If you have received this transmission in error, please
 delete it and notify the sender. The contents of this e-mail are the
 opinion of the writer only and are not endorsed by the Mincom Group of
 companies unless expressly stated otherwise.


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

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

Re: World premier performance of the BAARF party logo

2003-06-13 Thread Mogens Nørgaard





Dear Paul,

Welcome to the Party! You have just become member (and a Bold Member as it
were) no 24 (that's 42 backwards).

Thanks. EiE (Enough is Enough).

Mogens

Paul Baumgartel wrote:

  Dear Mogens,

When I arrived at my new job, I found RAID 5 everywhere, and a sys
admin who wanted to build my new database servers that way...I smote
the old systems and set the new ones on the right path.  I would be
proud to be associated with your movement.


--- Mogens_Nrgaard [EMAIL PROTECTED] wrote:
  
  
Friends,

James Morle has done it again. Nobody does it better.

For the first public showing of his BAARF animation, please GoTo 
www.MiracleAS.dk . Then get back to your work or mailing list fast
:-).

Let me know if you want to become a BAARF party member, and I'll
assign 
you a BAARF party membership number right away. You can reach Bold 
Membership Status if you can argue that you've been fighting RAID-F
for 
a long time, a medium time, a short time or an extremely short time.

Best regards,

Mogens

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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

  
  

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread jo_holvoet

There's a new sys priv in 9i called grant any object privilege that can 
be used for this.

regards
Jo






Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/13/2003 06:34
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: SYS not able to GRANT -- Strange !


its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.

i think that has changed in 9i but its late and my brain is fuzzy.

joe


Prem Khanna J wrote:

Guys,

CONNECT SYS AS SYSDBA;

create user testuser1 identified by testuser1 ;
grant connect, resource to testuser1;

create user testuser2 identified by testuser2 ;
grant create session to testuser2;

create table testuser1.table1 ( a int ) ;

grant select on testuser1.table1 to testuser2;
error at line 1:
ora-01031: insufficient privileges

WHERE AS :

connect testuser1/testuser1;

grant select on testuser1.table1 to testuser2;

grant succeeded.


why is it so ? 
why sys is not able to GRANT ?
seems to be strange !

the env. is 8.1.6.0./win2k.

Jp.


 


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


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

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




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

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

2003-06-13 Thread Hemant K Chitale


No user, not even SYS, can grant on another user's objects.

You have two options

1.  Login as the owner of the object on which
grants are to be provided and provide the grants

2.  Create a grants package[which can
give grants on specified objects] in the owner's
schema, grant execute on that package to SYS
or whichever DBA account you use and then use
the package from SYS or the DBA account. 
The package runs in Owner's Rights !

Hemant

--- Prem Khanna J [EMAIL PROTECTED] wrote:

 Guys,
 
 CONNECT SYS AS SYSDBA;
 
   create user testuser1 identified by testuser1 ;
   grant connect, resource to testuser1;
 
   create user testuser2 identified by testuser2 ;
   grant create session to testuser2;
 
   create table testuser1.table1 ( a int ) ;
 
   grant select on testuser1.table1 to testuser2;
   error at line 1:
   ora-01031: insufficient privileges
 
 WHERE AS :
 
   connect testuser1/testuser1;
 
   grant select on testuser1.table1 to testuser2;
 
   grant succeeded.
 
 
 why is it so ? 
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Prem Khanna J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like
 subscribing).
 



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

Re: World premier performance of the BAARF party logo

2003-06-13 Thread Mogens Nørgaard

You have just become member # 26 in the BAARF Party. You have been 
raised to Bold Member status. You seem to both deserver it and need it :-)))

[EMAIL PROTECTED] wrote:

Our storage team won't even respond to me anymore when I ask for the
manufacturer's rating for non-cached I/Os per second  number of
controllers, RAID level, striping, etc...  All I get is 'why do you want to
know that' and 'what application is this for'...  BARRF will stop the
debilitating headaches since I will just refuse to talk about it anymore.
Happy Day!!
 
 Mogens Nørgaard 
 [EMAIL PROTECTED]   T  
  To:   Multiple recipients of list ORACLE-L 
 Sent by: [EMAIL PROTECTED] 
 [EMAIL PROTECTED]cc:
 
  bcc:   
  Subject:  World
 06/10/03 06:19 PMpremier performance of the BAARF party logo
 Please respond to   
 ORACLE-L
 
 





Friends,

James Morle has done it again. Nobody does it better.

For the first public showing of his BAARF animation, please GoTo
www.MiracleAS.dk . Then get back to your work or mailing list fast :-).
Let me know if you want to become a BAARF party member, and I'll assign
you a BAARF party membership number right away. You can reach Bold
Membership Status if you can argue that you've been fighting RAID-F for
a long time, a medium time, a short time or an extremely short time.
Best regards,

Mogens

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




 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-13 Thread Yechiel Adar

DO NOT USE AUTOEXTEND on these datafiles.

There is a bug when datafile autoextend into 2GB or 4GB (I do not remember
exactly now) on NT.
We had a database down permanently because of this.

We do not work with any X OS here so I am talking about NT only.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 7:34 PM


 FWIW, we use 2048m here.

 --Walt (who feels obligated to make some posts since Steve's off today)
Weaver
   Bozeman, Montana

  -Original Message-
  From: Jared Still [mailto:[EMAIL PROTECTED]
  Sent: Sunday, June 08, 2003 11:00 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
 
 
 
  Just curious how you arrived at the 1900 meg number.
 
  Why not use 2000m?
 
  Oracle defines gigabytes in binary, not decimal as
  drive mfg's do, so 2000m would be fine.
 
  Not a criticism, just wondering.
 
  Jared
 
  On Sunday 08 June 2003 09:29, Yechiel Adar wrote:
   We have been hit by a bug in autoextend that corrupted a
  database (8.1.6)
   on NT.
   It seems that the bug was exported to Linux as well.
  
   We now use all datafiles with autoextend up to 1900 MB.
   We also define a second datafile with 200MB initial and
  autoextend to 1900
   MB.
   Whenever the last datafile starts to grow we define a new
  one with 200MB
   etc.
  
   Seems to work so far.
  
   Yechiel Adar
   Mehish
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Wednesday, June 04, 2003 5:40 PM
  
I've just been informed that there is a 2GB datafile size
  limit with
  
   Oracle 8.1.7 on Linux... PERIOD. This despite the fact that
  we've had files
   in excess of this for some time and they work just fine.
  The problem occurs
   when the autoextend feature reaches the 2GB threshhold.
  Of course, Oracle
   didn't tell me this until after about 4 days of back and
  forth testing for
   them. (There is no such O/S file size limit.) I've reviewed
  the Linux
   release notes, the Linux install guide, the Linux admin
  guide and the
   contents of $ORACLE_HOME/relnotes and I don't find any such
  limitation in
   the documentation. Did I miss it? Can anyone find any such published
   limitation in the docs? Is this a secret?
  
Peeved at Oracle... AGAIN,
Steve Orr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Orr, Steve
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- 858-538-5051
  http://www.fatcity.com
San Diego, California-- Mailing list and web
  hosting services
   
  -
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed
  from).  You may
also send the HELP command for other information (like
  subscribing).
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jared Still
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Weaver, Walt
   INET: [EMAIL PROTECTED]

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

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

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

RE: db file sequential read [WAS:wait event puzzler]

Senthil,

Could you please send me the script which can modify col$.NAME?

I tried this (of course on a trashable DB) but it doesn't work, and as far as
my understanding goes(looking at the error), NOTHING can make it work.
Following is the error I get in 8.1.7.0.0

SQL alter table col$ modify name varchar2(60);
alter table col$ modify name varchar2(60)
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

Regards
Naveen


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

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

Mail delivery problem

2003-06-13 Thread Senthil Kumar D

I'm getting all the fatcity mails twice.

Y is like this??? strange

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

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

2003-06-13 Thread VIVEK_SHARMA

Dennis , List 

What may be the OTHER forms of fragmentation ?

What Number of Extents may be considered Critical warranting RE-Organization for 
Manually Sized Objects existing in LMTs ? 

Thanks for the great paper . Had read it previously though .

Thanks


-Original Message-
Sent: Wednesday, June 11, 2003 8:25 PM
To: Multiple recipients of list ORACLE-L


Vivek
   Make sure you've read How to Stop Defragmenting and Start Living 
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
The authors point out that uniform extents stop fragmentation at the
tablespace level. However they point out that there are other forms of
fragmentation.

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


-Original Message-
Sent: Wednesday, June 11, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L



Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE =
UNIFORM OVER dba_tablespaces.ALLOCATION_TYPE = USER ?

With ALLOCATION_TYPE = UNIFORM , NEXT_EXTENT Size of the Object can NOT be
Manually defined in the Table Creation Script storage (NEXT Value) , 
which is allowed when having allocation_type=USER . 

Allocation_type=USER allows Objects with Different NEXT_EXTENT Sizes to be Created 
in the SAME LOCALLY managed Tablespace  thus reduces Total Number of Extents for
the respective Table. Our Application does have Objects of Dissimilar Sizes
Existing tin the Same Tablespace .

Does ALLOCATION_TYPE = UNIFORM automatically imply NO Fragmentation
Irrespective of the Number of Extents of the Object (in a Locally Managed
Tablespace) ? Does it further imply NO further need to Look at Number of
Extents of an Object in a Locally Managed Tablespace ?

NOTE Allocation_type can be made = USER by using the stored procedures :- 
dbms_space_admin.tablespace_migrate_from_local /
dbms_space_admin.tablespace_migrate_to_local

Am i still Lost in the World of Oracle 7 ?

Thanks



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

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

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

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

RE: db file sequential read [WAS:wait event puzzler]

Bhaskar,

Wisely you chose to take 30 char limit in your stride but I'm sure the name
translation algorithm suggestion was intended as a joke and so was doing
away with DDL. 

Don't make things overly complicated. Have good naming conventions and
shorten the name wherever wise. Name translation is going to make more
problems than name abbreviation. Can you give a brief of what problems you
anticipate by shortening the names?

Agreed, that 30 chars is a bit too mean, but thats the way it is. So better
learn to live with it rather than doing fancy things with a DB. 

Regards
Naveen
 -Original Message-
 From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED]
 Sent: Friday, June 13, 2003 12:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: db file sequential read [WAS:wait event puzzler]
 
 
 
 Hi,
 
 Thanks to all for you responses.
 
 To sum up the suggestions:
 
 1)You can modify col$.NAME to varchar2(60) and try..  
 2)I do agree with you. But some times we may need go beyond the
 scopes.
   For testing purpose we can do these kind of RD's.(alterning the
 col.Cname size)
   Nothing wrong in this.
 3)That is a Very Good Idea...
   We will do away with DDL Stmts will start writing directly into
 the Data Dictionary ...
 4)Oracle does not support column names that are longer than 30
 characters.  
   This is a hard standard and can not be changed.
 5)Ur not supposed to Update Data Dictionaly Tables Directly ... 
   Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your
 Columns within 30 Chrs... 
 6)Updating a data dictionary is simply not done. Remember, we're 
   the DBA (you will be assimilated) and not fun loving students
 who can play with their alma mater's equipment. 
   Updating the data dictionary directly would cause the database
 to lose support from 
   Oracle Corp. and the perpetrator would be liable.
 7)telling him to do a Update on COL$... He Ends up Doing that in
 his Production Database.. 
   And he is going to be in a HOT soup
 8)Write a compress / decompress algorithm that will take your
 200-character table names from 
   the application and pass them to the database as = 30
 characters; then uncompress them from 
   the database back to the application.
 9)references to DB naming conventions.
 
 I would want to go with the majority. Do not Do it!!.
 
 But then, the problem is like, I cannot afford to shorten 
 names as there
 are a lot of other problems which crops up.
 Though right now, thatz what we do and which is what I am 
 attempting to
 avoid.
 Ofcourse, the suggestion to have an algo. translate the names 
 is a good
 one, which is thought of and is the current
 Decision. 
 
 Whew!, if oralce supports more than 30 characters for column 
 names, life
 would be easier.
 
 Can somebody explain in brief, why this is being restricted to 30
 characters?
 
 And once again, thanks a lot!
 
 Baski
 
 -Original Message-
 Sent: Thursday, June 12, 2003 7:10 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Modifying  data dictionary tables is definitely not a  good 
 idea and I 
 am sure Oracle will not support this.
 
 CP
 
 
 [EMAIL PROTECTED] wrote:
 
 Dear Bhaskar,
 
 You can modify col$.NAME to varchar2(60) and try.
 
 If this fails, I'll give a procedure you can use that to 
 change it to 
 whatever size you want.
 
 Senthil Kumar
 Sr Oracle DBA
 Summitworks Technologies Pvt Ltd
 
 -Original Message-
 Bhaskar Viswanathan
 Sent: Thursday, June 12, 2003 4:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 hi,
 
 We use Oracle 8 DB.
 
 I am not a Oracle technical guy. So lemme try explaining the problem.
 
 We need to create tables with columns, whose names(column-names) are 
 more than 30 characters long. This is being restricted because, all 
 columns of all tables have entries in a table called 'col'.
 Thit table is defined as:
 
 SQL desc col
  Name  Null?Type
  - 
 
  TNAME NOT NULL VARCHAR2(30)
  COLNO NOT NULL NUMBER
  CNAME NOT NULL VARCHAR2(30)
  COLTYPEVARCHAR2(106)
  WIDTH NOT NULL NUMBER
  SCALE  NUMBER
  PRECISION  NUMBER
  NULLS  VARCHAR2(19)
  DEFAULTVAL LONG
  CHARACTER_SET_NAME VARCHAR2(44)
 SQL
 
 since CNAME is defined as VARCHAR2(30), we are forced to 
 retrict column
 
 names to a max of 30 characters long.
 
 For eg. create table T1(x31 
 varchar2(50)); 
 The above statement will be rejected with the error:

Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread Hemant K Chitale


No user, not even SYS, can grant on another user's objects.

You have two options

1.  Login as the owner of the object on which
grants are to be provided and provide the grants

2.  Create a grants package[which can
give grants on specified objects] in the owner's
schema, grant execute on that package to SYS
or whichever DBA account you use and then use
the package from SYS or the DBA account. 
The package runs in Owner's Rights !

Hemant

--- Prem Khanna J [EMAIL PROTECTED] wrote:

 Guys,
 
 CONNECT SYS AS SYSDBA;
 
   create user testuser1 identified by testuser1 ;
   grant connect, resource to testuser1;
 
   create user testuser2 identified by testuser2 ;
   grant create session to testuser2;
 
   create table testuser1.table1 ( a int ) ;
 
   grant select on testuser1.table1 to testuser2;
   error at line 1:
   ora-01031: insufficient privileges
 
 WHERE AS :
 
   connect testuser1/testuser1;
 
   grant select on testuser1.table1 to testuser2;
 
   grant succeeded.
 
 
 why is it so ? 
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Prem Khanna J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like
 subscribing).
 



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread Rachel Carmichael

haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA
privs -- have to try it) can definitely grant privileges on other
owner's objects.

Makes my scripts that have to pass through a hosting company easy
now... they have the system password, and I don't have to tell anyone
the schema owner password

Rachel

--- Joe Testa [EMAIL PROTECTED] wrote:
 its always been that way, its not strange, sys has NEVER been able to
 grant privs on other owner's objects.
 
 i think that has changed in 9i but its late and my brain is fuzzy.
 
 joe
 
 
 Prem Khanna J wrote:
 
 Guys,
 
 CONNECT SYS AS SYSDBA;
 
  create user testuser1 identified by testuser1 ;
  grant connect, resource to testuser1;
 
  create user testuser2 identified by testuser2 ;
  grant create session to testuser2;
 
  create table testuser1.table1 ( a int ) ;
 
  grant select on testuser1.table1 to testuser2;
  error at line 1:
  ora-01031: insufficient privileges
 
 WHERE AS :
 
  connect testuser1/testuser1;
 
  grant select on testuser1.table1 to testuser2;
 
  grant succeeded.
 
 
 why is it so ? 
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
   
 
 
 -- 
 Joseph S Testa
 Chief Technology Officer
 Data Management Consulting
 614-791-9000
 It's all about the CACHE
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Single Block Read

 -Original Message-
 From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]
 
 Starting from 8i the db file sequential read is always a single block
 read which TYPICALLY happens during index scans..
 
 K Gopalakrishnan

KG,

What are the scenarios other than index scans when a single block read can
happen (8i as you said) and hence db file sequential read be reported?

Regards
Naveen


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

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

RE: db file sequential read [WAS:wait event puzzler]

2003-06-13 Thread Senthil Kumar D

Hi,

Finally our group concluded this is not possible, let it as it is.

But it is possible by cheating the oracle kernel.

So let me take a back. :-))

Senthil





-Original Message-
Naveen Nahata
Sent: Friday, June 13, 2003 3:50 PM
To: Multiple recipients of list ORACLE-L


Senthil,

Could you please send me the script which can modify col$.NAME?

I tried this (of course on a trashable DB) but it doesn't work, and as far
as
my understanding goes(looking at the error), NOTHING can make it work.
Following is the error I get in 8.1.7.0.0

SQL alter table col$ modify name varchar2(60);
alter table col$ modify name varchar2(60)
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

Regards
Naveen


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

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

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

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

2003-06-13 Thread K Gopalakrishnan

Naveen:

Table Access by INDEX ROWID

Best Regards,
K Gopalakrishnan




-Original Message-
Naveen Nahata
Sent: Friday, June 13, 2003 3:21 AM
To: Multiple recipients of list ORACLE-L


 -Original Message-
 From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]

 Starting from 8i the db file sequential read is always a single block
 read which TYPICALLY happens during index scans..

 K Gopalakrishnan

KG,

What are the scenarios other than index scans when a single block read can
happen (8i as you said) and hence db file sequential read be reported?

Regards
Naveen


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

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


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

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

Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread Darrell Landrum

Try granting to sys with grant option


SQL create user t1 identified by t1 quota unlimited on users;

User created.

SQL create user t2 identified by t2;

User created.

SQL grant connect to t1;

Grant succeeded.

SQL grant connect to t2;

Grant succeeded.

SQL
SQL create table t1.firsttab(col1 varchar2(10)) tablespace users;

Table created.

SQL insert into t1.firsttab values('somedata');

1 row created.

SQL
SQL connect t1/t1;
Connected.
SQL GRANT SELECT ON T1.FIRSTTAB TO SYS WITH GRANT OPTION;

Grant succeeded.

SQL
SQL connect sys/password;
Connected.
SQL
SQL grant select on t1.firsttab to t2;

Grant succeeded.

SQL connect t2/t2
Connected.
SQL select * from t1.firsttab;

COL1
--
somedata

1 row selected.





 [EMAIL PROTECTED] 06/13/03 05:20AM 

No user, not even SYS, can grant on another user's objects.

You have two options

1.  Login as the owner of the object on which
grants are to be provided and provide the grants

2.  Create a grants package[which can
give grants on specified objects] in the owner's
schema, grant execute on that package to SYS
or whichever DBA account you use and then use
the package from SYS or the DBA account. 
The package runs in Owner's Rights !

Hemant

--- Prem Khanna J [EMAIL PROTECTED] wrote:

 Guys,
 
 CONNECT SYS AS SYSDBA;
 
   create user testuser1 identified by testuser1 ;
   grant connect, resource to testuser1;
 
   create user testuser2 identified by testuser2 ;
   grant create session to testuser2;
 
   create table testuser1.table1 ( a int ) ;
 
   grant select on testuser1.table1 to testuser2;
   error at line 1:
   ora-01031: insufficient privileges
 
 WHERE AS :
 
   connect testuser1/testuser1;
 
   grant select on testuser1.table1 to testuser2;
 
   grant succeeded.
 
 
 why is it so ? 
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net 
 -- 
 Author: Prem Khanna J
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
 San Diego, California-- Mailing list and web hosting
 services

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



Hemant K Chitale
http://hkchital.tripod.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED] 

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

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

Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread Mladen Gogala

At least it cannot until 9.2:

$ sqlplus /

SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jun 13 07:55:40 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
 SQL
SQL
SQL grant select on scott.emp to public;
 Grant succeeded.
 SQL

On 2003.06.13 06:20, Hemant K Chitale wrote:
No user, not even SYS, can grant on another user's objects.

You have two options

1.  Login as the owner of the object on which
grants are to be provided and provide the grants
2.  Create a grants package[which can
give grants on specified objects] in the owner's
schema, grant execute on that package to SYS
or whichever DBA account you use and then use
the package from SYS or the DBA account.
The package runs in Owner's Rights !
Hemant

--- Prem Khanna J [EMAIL PROTECTED] wrote:

 Guys,

 CONNECT SYS AS SYSDBA;

create user testuser1 identified by testuser1 ;
grant connect, resource to testuser1;

create user testuser2 identified by testuser2 ;
grant create session to testuser2;

create table testuser1.table1 ( a int ) ;

grant select on testuser1.table1 to testuser2;
error at line 1:
ora-01031: insufficient privileges

 WHERE AS :

connect testuser1/testuser1;

grant select on testuser1.table1 to testuser2;

grant succeeded.


 why is it so ?
 why sys is not able to GRANT ?
 seems to be strange !

 the env. is 8.1.6.0./win2k.

 Jp.


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

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



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

Re: World premier performance of the BAARF party logo

2003-06-13 Thread Daniel W. Fink

Mogens,
   As a futuristic thinker, I challenge you to go beyond todays 
technology and consider what the next millenium may bring. While it is 
all good and well to be against RAID-Free/Four/Five, we should also 
issue a policy statement against the newer, though not currently 
production ready, configurations listed below.

RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred ninety 
nine (inclusive), Free thousand through Five thousand nine hundred 
ninety nine (inclusive) and all RAIDS that are powers of Free/Four/Five.

Dan

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

RE: utl_file performance

2003-06-13 Thread Regis Biassala

You could do alter session set UTL_FILE_DIR  for instancebut the ora
docs has it all

-Original Message-
Sent: Friday, June 13, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L


I am told that utl_file performance is improved under Oracle 9 .

Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and
9.2?

John


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
*
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error, 
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**

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

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

utl_file performance

2003-06-13 Thread John Dunn

I am told that utl_file performance is improved under Oracle 9 .

Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and
9.2?

John


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

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

2003-06-13 Thread rgaffuri

there was a debate on here 2 weeks ago where it was concluded that until you get to 
thousands of extents it just doesnt matter how many you have. 

 From: VIVEK_SHARMA [EMAIL PROTECTED]
 Date: 2003/06/13 Fri AM 06:39:36 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Fragmentation ?

 Dennis , List 

 What may be the OTHER forms of fragmentation ?

 What Number of Extents may be considered Critical warranting RE-Organization for 
 Manually Sized Objects existing in LMTs ? 

 Thanks for the great paper . Had read it previously though .

 Thanks

 -Original Message-
 Sent: Wednesday, June 11, 2003 8:25 PM
 To: Multiple recipients of list ORACLE-L

 Vivek
Make sure you've read How to Stop Defragmenting and Start Living 
 http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
 The authors point out that uniform extents stop fragmentation at the
 tablespace level. However they point out that there are other forms of
 fragmentation.

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

 -Original Message-
 Sent: Wednesday, June 11, 2003 9:15 AM
 To: Multiple recipients of list ORACLE-L

 Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE =
 UNIFORM OVER dba_tablespaces.ALLOCATION_TYPE = USER ?

 With ALLOCATION_TYPE = UNIFORM , NEXT_EXTENT Size of the Object can NOT be
 Manually defined in the Table Creation Script storage (NEXT Value) , 
 which is allowed when having allocation_type=USER . 

 Allocation_type=USER allows Objects with Different NEXT_EXTENT Sizes to be Created 
 in the SAME LOCALLY managed Tablespace  thus reduces Total Number of Extents for
 the respective Table. Our Application does have Objects of Dissimilar Sizes
 Existing tin the Same Tablespace .

 Does ALLOCATION_TYPE = UNIFORM automatically imply NO Fragmentation
 Irrespective of the Number of Extents of the Object (in a Locally Managed
 Tablespace) ? Does it further imply NO further need to Look at Number of
 Extents of an Object in a Locally Managed Tablespace ?

 NOTE Allocation_type can be made = USER by using the stored procedures :- 
 dbms_space_admin.tablespace_migrate_from_local /
 dbms_space_admin.tablespace_migrate_to_local

 Am i still Lost in the World of Oracle 7 ?

 Thanks

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

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

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

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

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

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

RE: Rebuilding MLOG tables


Didn't know about this one.  Thanky thanky.

So now we have dbms_refresh, dbms_repcat, and dbms_mview (more?) each with
its own bucket of procedures.  It gives one the impression that there is
some significant developer turnover at Oracle with each new batch of
programmers imposing their own ideas about things ought to done.

I guess, for this to work, a master group (as opposed to a refresh group on
the client) must be created, eh?

 -Original Message-
 
 The safest and recommended way is to queisce the replication 
 master group by
 
 dbms_repcat.suspend_master_activity('GroupName');
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: Oracle Names

2003-06-13 Thread Goulet, Dick

Dennis,

Your welcome, Now if only I could get 10% of the response on HP  EMC Sans 
that you got on Names!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, June 12, 2003 7:04 PM
To: Multiple recipients of list ORACLE-L


Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, Mladen, Ravi,
John, Gene, Dick, and anyone I left out. Thanks very much for sharing the
information on not only Oracle Names but the other alternatives. You have
given me a gold mine of information to approach this issue. This list is
WONDERFUL!! Thanks everyone.
   Even if we choose not to implement Names, it will give me some incentive
to study those chapters for the OCP Net Administration module, which is the
only one I have left.

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


-Original Message-
Sent: Thursday, June 12, 2003 2:42 PM
To: Multiple recipients of list ORACLE-L


Re pushing the tnsnames.ora out to desktops:

I considered that, but there were too many versions of it out there, 
and the users may have ODBC DSN' s dependent on the contents
of their tnsnames.ora.

Re the share drive:  Considered that too, but it's too easy for
net admins to re-arrange drives without advance warning.
( it has happened )

I compromised.  The tnsnames.ora stays on the desktops.

The sqlnet.ora has this line:


NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)

so that their tnsnames will still work, but I can make changes
in the name servers without worrying about their tnsnames files.

Updating the names servers is pretty simple, and I don't have
to schedule a change to all the desktops.

Works for me anyway.

Jared





Stephen Lee [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 06/12/2003 12:01 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Oracle Names



I never liked names, but that's just me.  I thought keeping the names
servers up to date, and making sure every client was configured to use the
name servers, was a pain in the butt.  You can have multiple names servers
to eliminate a single point of failure.

The method I liked the best was to have the PC admin people push a new
tnsnames.ora out to client machines using push software.  Let THEM fuss 
with
it!

Another method that works is to have the tnsnames.ora on a share and stick 
a
shortcut on the client desktop that will update the local tnsnames.ora 
when
the user clicks on it.

 -Original Message-
 
 1. Are any of you using the Oracle Names?
 2. Is it as easy to configure as Oracle makes it sound, or is 
 it difficult?
 3. Is Names reasonably robust? I can see this as yet another 
 single point of
 failure.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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



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

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

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

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

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

RE: db file sequential read [WAS:wait event puzzler]


Oh no!  I was just kidding!

OK how about this one:
This will not work for columns, but let's say you need to have table names
that exceed 30 characters but do not exceed 61 characters.  If you don't
mind a '.' in the name, then you can have table names like

EENY_MEENY_MINEY_MOE_CATCH.WHATEVER_BY_THE_TOE_YEEHAAA

And all you have to do is create a database user for whatever is in front
the dot.  Now, you can have a 100% Dilbert approved database.

 -Original Message-
 Ofcourse, the suggestion to have an algo. translate the names 
 is a good
 one, which is thought of and is the current
 Decision. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Performance improvement required :-)

2003-06-13 Thread Craig Healey

It's Friday, and I'm having a brain storm. Just to check:
The developers are using ADO to connect to a VB application and want to
pull back a record set. Using ADO means they can't use bind variables.
Returning more than 1 record means they can't use a function (which
WOULD use bind variables). Am I correct in saying that other than tuning
the SQL (done that, it isn't a complex query) or playing around with
Oracle session parameters, there isn't anything else I can do?
(The query takes 1 second the first time it is run, but 10 ms after. It
is used all the time in the callcentre to search postcodes.)

TIA

Craig Healey


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

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

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

2003-06-13 Thread MacGregor, Ian A.

System can definitely grant privileges in another schema before 9.  It just takes some 
preparation.

As system create a procedure in  the other schema

CREATE OR  REPLACE procedure  other_schema.grantit
(privilege in varchar2, object in varchar2, grantee in varchar2) is
begin
execute immediate ('grant ' ||privilege ||' on ' ||object ||' to ' ||grantee);
end;
/

Then as system invoke it as

exec other_schema.grantit(privilege, object, grantee)

This works beause the  procedure runs under the security domain of the other user,  
and of course because system has the ability to create and execute privileges  in 
other schemas.

Are you on 9.0.1 or 9.2?  I thought the ability to do the granting without using a 
procedure was available beginning with 9.2.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, June 13, 2003 3:55 AM
To: Multiple recipients of list ORACLE-L


haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA privs -- have 
to try it) can definitely grant privileges on other owner's objects.

Makes my scripts that have to pass through a hosting company easy now... they have the 
system password, and I don't have to tell anyone the schema owner password

Rachel

--- Joe Testa [EMAIL PROTECTED] wrote:
 its always been that way, its not strange, sys has NEVER been able to 
 grant privs on other owner's objects.
 
 i think that has changed in 9i but its late and my brain is fuzzy.
 
 joe
 
 
 Prem Khanna J wrote:
 
 Guys,
 
 CONNECT SYS AS SYSDBA;
 
  create user testuser1 identified by testuser1 ;
  grant connect, resource to testuser1;
 
  create user testuser2 identified by testuser2 ;
  grant create session to testuser2;
 
  create table testuser1.table1 ( a int ) ;
 
  grant select on testuser1.table1 to testuser2;
  error at line 1:
  ora-01031: insufficient privileges
 
 WHERE AS :
 
  connect testuser1/testuser1;
 
  grant select on testuser1.table1 to testuser2;
 
  grant succeeded.
 
 
 why is it so ?
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
   
 
 
 --
 Joseph S Testa
 Chief Technology Officer
 Data Management Consulting
 614-791-9000
 It's all about the CACHE
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from).  You may also send 
 the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). 
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

2003-06-13 Thread muscat

Try Unsubscribing and Subscribing again. Might help.

Govindan

 I'm getting all the fatcity mails twice.

 Y is like this??? strange

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

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


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

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

RE: Rebuilding MLOG tables


Mebbe this has something to do with the implicit commit stuff associated
with DDL (iirc)?

I keep coming back to what Einstein said (I think it was him): Education is
what is left over after you have forgotten everything you have learned.
(quote might not be exactly correct)

 -Original Message-
 
 IIRC you need to lock the parent table in one session and 
 then do whatever 
 you need to do to the mlog table in a SECOND session 
 (because, as another 
 poster pointed out, the lock will be released too soon otherwise).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: Oracle Names

2003-06-13 Thread Gogala, Mladen

Now, what do you want to now about HP  EMC? Oxford is running 8.1.7.1.0 
on HP-UX 11 (4x9000/N, OPS) and our disks are on EMC.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 13, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L


Dennis,

Your welcome, Now if only I could get 10% of the response on HP 
EMC Sans that you got on Names!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Thursday, June 12, 2003 7:04 PM
To: Multiple recipients of list ORACLE-L


Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, Mladen, Ravi,
John, Gene, Dick, and anyone I left out. Thanks very much for sharing the
information on not only Oracle Names but the other alternatives. You have
given me a gold mine of information to approach this issue. This list is
WONDERFUL!! Thanks everyone.
   Even if we choose not to implement Names, it will give me some incentive
to study those chapters for the OCP Net Administration module, which is the
only one I have left.

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


-Original Message-
Sent: Thursday, June 12, 2003 2:42 PM
To: Multiple recipients of list ORACLE-L


Re pushing the tnsnames.ora out to desktops:

I considered that, but there were too many versions of it out there, 
and the users may have ODBC DSN' s dependent on the contents
of their tnsnames.ora.

Re the share drive:  Considered that too, but it's too easy for
net admins to re-arrange drives without advance warning.
( it has happened )

I compromised.  The tnsnames.ora stays on the desktops.

The sqlnet.ora has this line:


NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)

so that their tnsnames will still work, but I can make changes
in the name servers without worrying about their tnsnames files.

Updating the names servers is pretty simple, and I don't have
to schedule a change to all the desktops.

Works for me anyway.

Jared





Stephen Lee [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 06/12/2003 12:01 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Oracle Names



I never liked names, but that's just me.  I thought keeping the names
servers up to date, and making sure every client was configured to use the
name servers, was a pain in the butt.  You can have multiple names servers
to eliminate a single point of failure.

The method I liked the best was to have the PC admin people push a new
tnsnames.ora out to client machines using push software.  Let THEM fuss 
with
it!

Another method that works is to have the tnsnames.ora on a share and stick 
a
shortcut on the client desktop that will update the local tnsnames.ora 
when
the user clicks on it.

 -Original Message-
 
 1. Are any of you using the Oracle Names?
 2. Is it as easy to configure as Oracle makes it sound, or is 
 it difficult?
 3. Is Names reasonably robust? I can see this as yet another 
 single point of
 failure.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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



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

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

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

RE: Performance improvement required :-)

2003-06-13 Thread Seefelt, Beth


Why can't you use bind variables?  I thought using .Parameters method
(property?) of ADODB.Command would use bind variables.

What function, and where can't you use it?


-Original Message-
Sent: Friday, June 13, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L


It's Friday, and I'm having a brain storm. Just to check:
The developers are using ADO to connect to a VB application and want to
pull back a record set. Using ADO means they can't use bind variables.
Returning more than 1 record means they can't use a function (which
WOULD use bind variables). Am I correct in saying that other than tuning
the SQL (done that, it isn't a complex query) or playing around with
Oracle session parameters, there isn't anything else I can do?
(The query takes 1 second the first time it is run, but 10 ms after. It
is used all the time in the callcentre to search postcodes.)

TIA

Craig Healey



**

This email and any files transmitted with it are confidential and
intended solely
for the use of the individual or entity to whom they are addressed and
may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination
or other use of, or taking of any action in reliance upon, this
information by 
persons or entities other than the intended recipient is prohibited.
Statements
and opinions expressed in this e-mail may not represent those of the
company.
  
If you have received this email in error please notify
[EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)


***

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

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

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

Title: RE: World premier performance of the BAARF party logo





Nice going there Dan,


After reading this 'Free/Four/Five ...' stuff only thing that comes to my mind is ... 'What the F..ive'? 
or maybe someone can be insulted by calling them 'you-raid-five-loving-zealot' ... 


TGIF
Raj

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



-Original Message-
From: Daniel W. Fink [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 13, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: World premier performance of the BAARF party logo



Mogens,
 As a futuristic thinker, I challenge you to go beyond todays 
technology and consider what the next millenium may bring. While it is 
all good and well to be against RAID-Free/Four/Five, we should also 
issue a policy statement against the newer, though not currently 
production ready, configurations listed below.


RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred ninety 
nine (inclusive), Free thousand through Five thousand nine hundred 
ninety nine (inclusive) and all RAIDS that are powers of Free/Four/Five.


Dan



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

RE: Query Tuning Question - new discovery

2003-06-13 Thread Meng, Dennis

I did a sql trace and tkprof and here is the output. It looks like 'bitmap conversion 
to rowids' is the hogger. Anybody know what this implies? Should I try dropping and 
recreating the index as b-tree? We don't have an identical test system here so I need 
a 'warm and fuzzy' before doing that in our production.
Dennis

0  SORT GROUP BY
  0   NESTED LOOPS
  0NESTED LOOPS
  0 NESTED LOOPS
  0  HASH JOIN
  0   HASH JOIN
  7INDEX RANGE SCAN (object id 44819)
  0NESTED LOOPS
156 NESTED LOOPS
  9  HASH JOIN
  2   TABLE ACCESS FULL REG_MGR
  9   TABLE ACCESS FULL SHIPTO_SALESTYP
164  TABLE ACCESS BY INDEX ROWID CUST_SHIPTO
164   INDEX RANGE SCAN (object id 447931)
231 TABLE ACCESS BY INDEX ROWID INVC_LINE
1323618  BITMAP CONVERSION TO ROWIDS
346   BITMAP INDEX SINGLE VALUE
  0   TABLE ACCESS FULL SALESREP_DTL
  0  TABLE ACCESS BY INDEX ROWID MTL
  0   INDEX UNIQUE SCAN (object id 46433)
  0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO
  0  INDEX UNIQUE SCAN (object id 89347)
  0TABLE ACCESS BY INDEX ROWID INVC_LINE_ATTRB
  0 INDEX UNIQUE SCAN (object id 43441)

-Original Message-
Sent: Thursday, June 12, 2003 3:41 PM
To: Multiple recipients of list ORACLE-L


has anythign changed in the table? inserts, updates, deletes? if so considering doing 
a move on the table to rebuild it and possibly rebuilding the indexes in question. 

have you gather statistics lately? Is it using the same plan it was using a fwe weeks 
ago? 


 
 From: Meng, Dennis [EMAIL PROTECTED]
 Date: 2003/06/12 Thu PM 03:54:59 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Query Tuning Question
 
 Hi fellow DBAs,
 This is kind of the follow-up of my last E-mail on wait event. 
 I have a query that is taking hours to complete and the plan looks ok. While one of 
 the tables is huge (267mil rows) it is being accessed using one of its indexes.
 I recorded some stats from v$session_wait while the query is running to see which 
 segment is query is hanging up on and the result is the big table with 267mil rows.
 Funny thing is, according to the user community, this query took only minutes to run 
 couple of weeks ago.
 What could be the cause of this wait? When index is being used, oracle will go 
 directly to the data block and retrieve the data, which should be very efficient 
 correct? 
  
  
 TIA
  
 Dennis
 
  
 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Meng, Dennis
  INET: [EMAIL PROTECTED]

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

2003-06-13 Thread Igor Neyman

I thought question was about performance comparison...

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Regis Biassala
Sent: 13. júna 2003 9:09
To: Multiple recipients of list ORACLE-L

You could do alter session set UTL_FILE_DIR  for instancebut the ora
docs has it all

-Original Message-
Sent: Friday, June 13, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L


I am told that utl_file performance is improved under Oracle 9 .

Does anyone have any comparisons of UTL_FILE performance between 8.1.7
and
9.2?

John


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
*
This electronic transmission is strictly confidential and intended
solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error, 
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**

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

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


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

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

RE: Performance improvement required :-)

Title: RE: Performance improvement required :-)





Craig,


any query when run first time will take more time, because it has to do _all_ the work, i.e. do physical reads. Subsequent executions usually benefit from finding the required data blocks in buffer cache, thus minimizing physical reads and hence may be faster.

Nothing wrong with that.
Raj

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



-Original Message-
From: Craig Healey [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 13, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Performance improvement required :-)



It's Friday, and I'm having a brain storm. Just to check:
The developers are using ADO to connect to a VB application and want to
pull back a record set. Using ADO means they can't use bind variables.
Returning more than 1 record means they can't use a function (which
WOULD use bind variables). Am I correct in saying that other than tuning
the SQL (done that, it isn't a complex query) or playing around with
Oracle session parameters, there isn't anything else I can do?
(The query takes 1 second the first time it is run, but 10 ms after. It
is used all the time in the callcentre to search postcodes.)


TIA


Craig Healey



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

RE: [SPAM:#] Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread Rachel Carmichael

Sorry, I meant without having to do anything special... according to
the docs it's a DBA account, so it might work with any account granted
DBA. I haven't looked through the docs to see if there is a grant all
privilege equivalent to create any etc... It might just be part of
the kernel code

I'm on 9.2  We skipped 9.0 entirely, mostly based on the reports I'd
heard of all the problems.


--- MacGregor, Ian A. [EMAIL PROTECTED] wrote:
 System can definitely grant privileges in another schema before 9. 
 It just takes some preparation.
 
 As system create a procedure in  the other schema
 
 CREATE OR  REPLACE procedure  other_schema.grantit
 (privilege in varchar2, object in varchar2, grantee in varchar2) is
 begin
 execute immediate ('grant ' ||privilege ||' on ' ||object ||' to '
 ||grantee);
 end;
 /
 
 Then as system invoke it as
 
 exec other_schema.grantit(privilege, object, grantee)
 
 This works beause the  procedure runs under the security domain of
 the other user,  and of course because system has the ability to
 create and execute privileges  in other schemas.
 
 Are you on 9.0.1 or 9.2?  I thought the ability to do the granting
 without using a procedure was available beginning with 9.2.
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Friday, June 13, 2003 3:55 AM
 To: Multiple recipients of list ORACLE-L
 
 
 haven't tried it with SYS but in 9i SYSTEM (maybe any account with
 DBA privs -- have to try it) can definitely grant privileges on other
 owner's objects.
 
 Makes my scripts that have to pass through a hosting company easy
 now... they have the system password, and I don't have to tell anyone
 the schema owner password
 
 Rachel
 



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Want to BAARF - Recommendations for 10 36G Drive config

2003-06-13 Thread Dave Phillips

A client runs our app with the following layout. Since their intial 6
drive config they have procured more drives for a total of 10 36Gig
Drives. They have also upgraded memory from 1 to 4 gig. I have the
opportunity to recommend changes to the current structure to improve
performance. 
So, any recommendations from the BAARF committee are welcome. 

Current System

Ora 8.1.7
Win 2k
Size 30Gig
Logical Array 1 - Raid 1 - OS and Oracle
Logical Array 2 - Raid 1 - App and Index TS
Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc)




David Phillips
Support DBA
BAARF member wanna-be
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dave Phillips
  INET: [EMAIL PROTECTED]

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

Title: RE: RE: Fragmentation ?

Depends ... who you ask ...

If you ask Microsoft
1. you are fragmented if you have at-least _one_ non-windows server in your corporation
2. Your thinking is fragmented if you are even _considering_ LINUX

If you ask SCO
1. You are fragmented if you use AIX
2. You are fragmented if you read every line of GPL

If you ask Oracle Experts
1. Some will say Do you have a problem? if none, don't worry
2. Some will say More than x extents is bad but X varies from 2 to 1024 to 4096
3. Some will advise use LMT with Uniform extents and live happily there after.

I could think of some political ones, but this is a technical list ...
TGIF
Raj

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

From: VIVEK_SHARMA [EMAIL PROTECTED]
Date: 2003/06/13 Fri AM 06:39:36 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Fragmentation ?

Dennis , List
What may be the OTHER forms of fragmentation ?
What Number of Extents may be considered Critical warranting RE-Organization for Manually Sized Objects existing in LMTs ?

Thanks for the great paper . Had read it previously though .
Thanks

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

RE: RE: Fragmentation ?

2003-06-13 Thread DENNIS WILLIAMS

Well said. For people that can only comprehend a simple solution, it is much
more comfortable to have a single answer. The old reorganize to a single
extent was always easy to understand. Along the way as a side-effect it
cured other types of fragmentation, but if the underlying causes of the
fragmentation are understood, then fewer reorganizations would be needed.
   The paper Stop Defragmenting . . . isn't one of those you can skim and
then set aside. It needs to be intensively studied. LMT isn't completely
foolproof, so you need to understand the underlying premises. As to the
types of fragmentation, read the introduction. It explains which chapter
discusses which type of fragmentation.

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


-Original Message-
Sent: Friday, June 13, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


there was a debate on here 2 weeks ago where it was concluded that until you
get to thousands of extents it just doesnt matter how many you have. 
 
 From: VIVEK_SHARMA [EMAIL PROTECTED]
 Date: 2003/06/13 Fri AM 06:39:36 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Fragmentation ?
 
 Dennis , List 
 
 What may be the OTHER forms of fragmentation ?
 
 What Number of Extents may be considered Critical warranting
RE-Organization for Manually Sized Objects existing in LMTs ? 
 
 Thanks for the great paper . Had read it previously though .
 
 Thanks
 
 
 -Original Message-
 Sent: Wednesday, June 11, 2003 8:25 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Vivek
Make sure you've read How to Stop Defragmenting and Start Living 
 http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
 The authors point out that uniform extents stop fragmentation at the
 tablespace level. However they point out that there are other forms of
 fragmentation.
 
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 
 -Original Message-
 Sent: Wednesday, June 11, 2003 9:15 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE =
 UNIFORM OVER dba_tablespaces.ALLOCATION_TYPE = USER ?
 
 With ALLOCATION_TYPE = UNIFORM , NEXT_EXTENT Size of the Object can NOT
be
 Manually defined in the Table Creation Script storage (NEXT Value) , 
 which is allowed when having allocation_type=USER . 
 
 Allocation_type=USER allows Objects with Different NEXT_EXTENT Sizes to
be Created 
 in the SAME LOCALLY managed Tablespace  thus reduces Total Number of
Extents for
 the respective Table. Our Application does have Objects of Dissimilar
Sizes
 Existing tin the Same Tablespace .
 
 Does ALLOCATION_TYPE = UNIFORM automatically imply NO Fragmentation
 Irrespective of the Number of Extents of the Object (in a Locally Managed
 Tablespace) ? Does it further imply NO further need to Look at Number of
 Extents of an Object in a Locally Managed Tablespace ?
 
 NOTE Allocation_type can be made = USER by using the stored procedures
:- 
 dbms_space_admin.tablespace_migrate_from_local /
 dbms_space_admin.tablespace_migrate_to_local
 
 Am i still Lost in the World of Oracle 7 ?
 
 Thanks
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: VIVEK_SHARMA
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: VIVEK_SHARMA
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and

Re: Performance improvement required :-)

2003-06-13 Thread Thomas Day


Just guessing, but it seems as if the longer initial run is because the
data is being pulled into the buffers.  After that the query is being
answered without disk i/o.  See if you can cache the table and if that gets
rid of the initial long run.




   

  Craig Healey   

  c.healeyTo:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @hhsuk.com  cc: 

  Sent by: Subject: Performance improvement 
required :-)   
  ml-errors

   

   

  06/13/2003 09:59 

  AM   

  Please respond   

  to ORACLE-L  

   

   





It's Friday, and I'm having a brain storm. Just to check:
The developers are using ADO to connect to a VB application and want to
pull back a record set. Using ADO means they can't use bind variables.
Returning more than 1 record means they can't use a function (which
WOULD use bind variables). Am I correct in saying that other than tuning
the SQL (done that, it isn't a complex query) or playing around with
Oracle session parameters, there isn't anything else I can do?
(The query takes 1 second the first time it is run, but 10 ms after. It
is used all the time in the callcentre to search postcodes.)

TIA

Craig Healey


**


This email and any files transmitted with it are confidential and intended
solely
for the use of the individual or entity to whom they are addressed and may
contain
confidential and/or privileged material.  Any review, retransmission,
dissemination
or other use of, or taking of any action in reliance upon, this information
by
persons or entities other than the intended recipient is prohibited.
Statements
and opinions expressed in this e-mail may not represent those of the
company.

If you have received this email in error please notify
[EMAIL PROTECTED]

This footnote also confirms that this email message has been swept by
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***


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

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





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

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

standby archivelogs

2003-06-13 Thread Jim Neugebauer

I would like to pose a question to the group in hopes of saving some testing time. I am reconfiguring an 8.1.7 managed standby server after moving it to a new data center. The network link between the primary and standby is now 1/4 of what it used to be and I think this is going to be an issue. During periods of intense activity we can generate a LOT of archive logs very quickly.

relevent parameters:
log_archive_max_processes = 5log_archive_dest_1 = 'LOCATION=/oradata/xxx/arch MANDATORY REOPEN=120'log_archive_dest_2 = "service=X reopen=300"log_archive_min_succeed_dest = 1

my question is this.. will the primary database hang if all the redo logs are full and the archive process cannot keep up due to the slw network connection to the standby? i.e. will all 5 archive processes get tied up writing to the standby and be unavailable to archive local logs? do archivers give priority to local logs somehow? Is there a way to separate local archive processes vs. remote archive processes? I do not want to increase the number of archiversbecause this will only saturate the network more... 

Thanks!

Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

Re: Rebuilding MLOG tables

2003-06-13 Thread Arup Nanda

You are very welcome.

I agree, Oracle must have had a wave of those PHBs in their development side
each with their own trumpet to blow and each left his or her legacy with a
new package.  Otherwise why they cose to have so many of these packages to
do a few simple, very correlated things beats me. Even though I have been
doing replication for seven years now, I have a hard time remembering which
package has what.

As to the last part of your post (the question actually), you always had to
create a master group and associate a refresh group to that. The decision to
include which tables in a master group depends on the relationship among the
tables and whether they must be refreshed in one shot to maintain logical
integerity. But I almost always found it better to have a group per a table.

HTH.

Arup Nanda
www.proligence.com

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:09 AM



 Didn't know about this one.  Thanky thanky.

 So now we have dbms_refresh, dbms_repcat, and dbms_mview (more?) each with
 its own bucket of procedures.  It gives one the impression that there is
 some significant developer turnover at Oracle with each new batch of
 programmers imposing their own ideas about things ought to done.

 I guess, for this to work, a master group (as opposed to a refresh group
on
 the client) must be created, eh?

  -Original Message-
 
  The safest and recommended way is to queisce the replication
  master group by
 
  dbms_repcat.suspend_master_activity('GroupName');
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]

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

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

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

Title: RE: utl_file performance





John,


http://tinyurl.com/e8d1 ... not much info there. But mostly performance cannot be general, because everyone's processign is different.

Raj

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


-Original Message-
Sent: Friday, June 13, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L



I am told that utl_file performance is improved under Oracle 9 .


Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2?


John



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

Re: standby archivelogs

2003-06-13 Thread Arup Nanda




Jim,

Modify the parameter log_archive_dest_2 to "service=X optional reopen=300". Note the 
keyword "optional". This will ensure that even if the archive has not created 
the file at the standby location, the primary will not hang.

HTH.

Arup Nanda
www.proligence.com

  - Original Message - 
  From: 
  Jim Neugebauer 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, June 13, 2003 12:14 
PM
  Subject: standby archivelogs
  
  I would like to pose a question to the group in hopes of saving some 
  testing time. I am reconfiguring an 8.1.7 managed standby server 
  after moving it to a new data center. The network link between the 
  primary and standby is now 1/4 of what it used to be and I think this is going 
  to be an issue. During periods of intense activity we can generate a LOT 
  of archive logs very quickly.
  
  relevent parameters:
  log_archive_max_processes = 
  5log_archive_dest_1 
  = 'LOCATION=/oradata/xxx/arch MANDATORY 
  REOPEN=120'log_archive_dest_2 
  = "service=X reopen=300"log_archive_min_succeed_dest 
  = 1
  
  my question is this.. will the primary database hang if all the redo logs 
  are full and the archive process cannot keep up due to the slw network 
  connection to the standby? i.e. will all 5 archive processes get tied up 
  writing to the standby and be unavailable to archive local logs? do 
  archivers give priority to local logs somehow? Is there a way to 
  separate local archive processes vs. remote archive processes? I do not 
  want to increase the number of archiversbecause this will only saturate 
  the network more... 
  
  Thanks!
  
  Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp
  
  
  Do you Yahoo!?The New 
  Yahoo! Search - Faster. Easier. Bingo.

RE: Oracle Names

2003-06-13 Thread Matthew Zito


What do you need to know about EMC SANs?  If I don't know the answer, I
can probably point you in the right direction of who to talk to @ EMC.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Goulet, Dick
 Sent: Friday, June 13, 2003 9:20 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle Names
 
 
 Dennis,
 
   Your welcome, Now if only I could get 10% of the 
 response on HP  EMC Sans that you got on Names!!
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 Sent: Thursday, June 12, 2003 7:04 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, 
 Mladen, Ravi, John, Gene, Dick, and anyone I left out. Thanks 
 very much for sharing the information on not only Oracle 
 Names but the other alternatives. You have given me a gold 
 mine of information to approach this issue. This list is 
 WONDERFUL!! Thanks everyone.
Even if we choose not to implement Names, it will give me 
 some incentive to study those chapters for the OCP Net 
 Administration module, which is the only one I have left.
 
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 
 -Original Message-
 Sent: Thursday, June 12, 2003 2:42 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Re pushing the tnsnames.ora out to desktops:
 
 I considered that, but there were too many versions of it out there, 
 and the users may have ODBC DSN' s dependent on the contents
 of their tnsnames.ora.
 
 Re the share drive:  Considered that too, but it's too easy 
 for net admins to re-arrange drives without advance warning. 
 ( it has happened )
 
 I compromised.  The tnsnames.ora stays on the desktops.
 
 The sqlnet.ora has this line:
 
 
 NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)
 
 so that their tnsnames will still work, but I can make 
 changes in the name servers without worrying about their 
 tnsnames files.
 
 Updating the names servers is pretty simple, and I don't have 
 to schedule a change to all the desktops.
 
 Works for me anyway.
 
 Jared
 
 
 
 
 
 Stephen Lee [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  06/12/2003 12:01 PM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Oracle Names
 
 
 
 I never liked names, but that's just me.  I thought keeping 
 the names servers up to date, and making sure every client 
 was configured to use the name servers, was a pain in the 
 butt.  You can have multiple names servers to eliminate a 
 single point of failure.
 
 The method I liked the best was to have the PC admin people 
 push a new tnsnames.ora out to client machines using push 
 software.  Let THEM fuss 
 with
 it!
 
 Another method that works is to have the tnsnames.ora on a 
 share and stick 
 a
 shortcut on the client desktop that will update the local 
 tnsnames.ora 
 when
 the user clicks on it.
 
  -Original Message-
  
  1. Are any of you using the Oracle Names?
  2. Is it as easy to configure as Oracle makes it sound, or is
  it difficult?
  3. Is Names reasonably robust? I can see this as yet another 
  single point of
  failure.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting

RE: Performance improvement required :-)

2003-06-13 Thread Craig Healey

 
 
 Why can't you use bind variables?  I thought using .Parameters method
 (property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?

 
 What function, and where can't you use it?
 
Stored Procedure type function (i.e. user-written) called from VB. 'Cos
it's a Stored Procedure it will use bind variables, but you can't return
a result set to VB.

Craig


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

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

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

2003-06-13 Thread Igor Neyman

With the limited number of drives, that you have, 
I'd at least:
- move RBS from Raid5 onto first Raid1 (with OA and Oracle);
- move redo from Raid5 onto second Raid1;
- move Index TS back onto Raid5


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Dave Phillips
Sent: 13. júna 2003 10:26
To: Multiple recipients of list ORACLE-L

A client runs our app with the following layout. Since their intial 6
drive config they have procured more drives for a total of 10 36Gig
Drives. They have also upgraded memory from 1 to 4 gig. I have the
opportunity to recommend changes to the current structure to improve
performance. 
So, any recommendations from the BAARF committee are welcome. 

Current System

Ora 8.1.7
Win 2k
Size 30Gig
Logical Array 1 - Raid 1 - OS and Oracle
Logical Array 2 - Raid 1 - App and Index TS
Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc)




David Phillips
Support DBA
BAARF member wanna-be
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dave Phillips
  INET: [EMAIL PROTECTED]

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


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

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

how to hint a unique index scan?

2003-06-13 Thread rgaffuri

Is there anyway to hint a specific type of scan? I know you can hint a fast full scan. 

I have something odd happening. I made a copy of a tablespace and transported that 
copy with in the same instance. So in the one instance. I have two copies of this 
tablespace.

I have two tables that are 99% identical. IE one has about 1% more records and if you 
validate the indexes on each they are also less than 1% apart. 

Now in one tablespace an update does an Unique Scan and in the other the EXACT same 
update does a full scan and runs ALOT slower. I want to mess around.

anyway to force a unique index scan? Both tables are analyzed. 

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

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

RE: Rebuilding MLOG tables


It looks like I must carefully go through all the replication stuff in the
O'Reilly Oracle Built-in Packages and pick this stuff apart.  This book puts
the DBMS_REPCAT biz under Advanced Replication, so I have to see what
differences there are (if any) and/or how applicable it is when doing simple
snapshot replication -- which is what we have in this case.  We have refresh
groups on the clients, but since there is so much shuffling things around
and changing things that goes on here, I really don't want to hard code any
stuff in the script so it goes out to each client and tells them to lay low
while I fiddle with the master.  I guess I could have the script dig through
dba_registered_snapshots to see what clients are out there, but geez, do I
really have to make it that big of a chore?  I'm trying to write a robust,
reliably automated thing here. (What's the point in running Unix if you
don't script all maintenance?)

One of the Murphy's Law issues I was thinking about was: What if I don't do
anything with the clients and one of them decides the best time to update a
snapshot is exactly the same time the MLOG table is getting moved around
(Well sure!)?  Does that get handled gracefully; or does it get handled like
a bug on the windshield of high speed car?

There seems to be a dearth of info out there on the finer points of tidying
up MLOG files.

 -Original Message-
 From: Arup Nanda [mailto:[EMAIL PROTECTED]
 Sent: Friday, June 13, 2003 10:50 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Rebuilding MLOG tables
 
 
 You are very welcome.
 
 I agree, Oracle must have had a wave of those PHBs in their 
 development side
 each with their own trumpet to blow and each left his or her 
 legacy with a
 new package.  Otherwise why they cose to have so many of 
 these packages to
 do a few simple, very correlated things beats me. Even though 
 I have been
 doing replication for seven years now, I have a hard time 
 remembering which
 package has what.
 
 As to the last part of your post (the question actually), you 
 always had to
 create a master group and associate a refresh group to that. 
 The decision to
 include which tables in a master group depends on the 
 relationship among the
 tables and whether they must be refreshed in one shot to 
 maintain logical
 integerity. But I almost always found it better to have a 
 group per a table.
 
 HTH.
 
 Arup Nanda
 www.proligence.com
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, June 13, 2003 10:09 AM
 
 
 
  Didn't know about this one.  Thanky thanky.
 
  So now we have dbms_refresh, dbms_repcat, and dbms_mview 
 (more?) each with
  its own bucket of procedures.  It gives one the impression 
 that there is
  some significant developer turnover at Oracle with each new batch of
  programmers imposing their own ideas about things ought to done.
 
  I guess, for this to work, a master group (as opposed to a 
 refresh group
 on
  the client) must be created, eh?
 
   -Original Message-
  
   The safest and recommended way is to queisce the replication
   master group by
  
   dbms_repcat.suspend_master_activity('GroupName');
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Stephen Lee
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Arup Nanda
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: Fragmentation ?


That's one thing good about the databases here.  Tablespace fragmentation is
rarely a problem.  Most of the database here are a Database Roach Motel:
Data checks in.  It doesn't check out.  Somehow, the data purge part of
the application -- that they intended to put in one of these days -- never
got written.



(For non-USA dwellers, Roach Motel is a trap for roaches.  It has a sticky
floor, and the sales motto is Roaches check in. They don't check out.)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Re: Listener showing 2 service handlers for the same service

2003-06-13 Thread Ravi Kulkarni

Naveen,

Do you have local_listener set in your init.ora file?

-Ravi.
--- Naveen Nahata [EMAIL PROTECTED] wrote:
 Hi All,
 
 When I start the listener, after sometimes the
 instance registers itself with
 the listener. After this the status of the listener
 shows 2 service handlers
 for the same service.
 
 For the sake of clarity I'm pasting the output and
 listener.ora file.
 
 Initial Status:
 ---
 Services Summary...
   PLSExtProchas 1 service handler(s)
 The command completed successfully
 
 After instance registers itself:
 
 Services Summary...
   PLSExtProchas 1 service handler(s)
   salesnet  has 2 service handler(s)
 The command completed successfully
 
 listener.ora
 -
 SID_LIST_817_LISTENER =
   (SID_LIST =
 (SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = F:\Oracle\Ora817)
   (PROGRAM = extproc)
 )
   )
 
 817_LISTENER =
   (DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST =
 DT309-NaveenN)(PORT = 1521))
   )
   (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
 )
   )
 
 Any help or pointers on what can be the issue?
 
 Regards
 Naveen
 
 
 
 DISCLAIMER:
 This message (including attachment if any) is
 confidential and may be privileged. Before opening
 attachments please check them for viruses and
 defects. MindTree Consulting Private Limited
 (MindTree) will not be responsible for any viruses
 or defects or any forwarded attachments emanating
 either from within MindTree or outside. If you have
 received this message by mistake please notify the
 sender by return  e-mail and delete this message
 from your system. Any unauthorized use or
 dissemination of this message in whole or in part is
 strictly prohibited.  Please note that e-mails are
 susceptible to change and MindTree shall not be
 liable for any improper, untimely or incomplete
 transmission.
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Naveen Nahata
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

2003-06-13 Thread Igor Neyman

Using REFCURSOR you can return result set from stored procedure.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Craig Healey
Sent: 13. júna 2003 12:20
To: Multiple recipients of list ORACLE-L

 
 
 Why can't you use bind variables?  I thought using .Parameters method
 (property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?

 
 What function, and where can't you use it?
 
Stored Procedure type function (i.e. user-written) called from VB. 'Cos
it's a Stored Procedure it will use bind variables, but you can't return
a result set to VB.

Craig



**

This email and any files transmitted with it are confidential and
intended solely
for the use of the individual or entity to whom they are addressed and
may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination
or other use of, or taking of any action in reliance upon, this
information by 
persons or entities other than the intended recipient is prohibited.
Statements
and opinions expressed in this e-mail may not represent those of the
company.
  
If you have received this email in error please notify
[EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)


***

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

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


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

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

RE: Want to BAARF - Recommendations for 10 36G Drive config


Put SQL Server files on RAID5, Oracle files on the good stuff.  Then stand
around and say Well gosh, I guess that SQL Server is just crappy and slow.

 -Original Message-
 So, any recommendations from the BAARF committee are welcome. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: Performance improvement required :-)

2003-06-13 Thread Seefelt, Beth


I'm sure you can.  You should see it in an ODBC trace log, or you can
use trace events on the database.  Here's a really simplistic test I did
to verify it.  I ran this VB code that executes a really dumb query that
could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE
DUMMY = 'X'  but passed 'X' as a bind variable

Private Sub Form_Load()

Dim conn1 As New ADODB.Connection
Dim cmd1 As New ADODB.Command
Dim rs1 As New ADODB.Recordset
Dim STRSQLSTRING As String
Dim param1 As New Parameter

strConnect = UID=produser;PWD=prodpass;DSN=WAREHOUSE;
STRSQLSTRING = SELECT DUMMY FROM DUAL WHERE DUMMY = ?

With conn1
.ConnectionTimeout = 0
.CommandTimeout = 0
.CursorLocation = adUseClient
.Mode = adModeRead
.Open strConnect
End With
If Err.Number Then
  MsgBox Err.Number
  Exit Sub
End If
With cmd1
.ActiveConnection = conn1
.CommandText = STRSQLSTRING
.CommandType = adCmdText
Set param1 = .CreateParameter(DummyValue, adChar,
adParamInput, 1, X)
param1.Value = X
.Parameters.Append param1
Set rs1 = .Execute
End With

MsgBox rs1.Fields(DUMMY)

End Sub


Afterward, executed this on the database -


SQL select sql_text from v$sqlarea where sql_text like 'SELECT DUMMY
%';

SQL_TEXT



SELECT DUMMY FROM DUAL WHERE DUMMY = :1


It shows the parameter was definitely passed as a bind variable.


Check out this document on Metalink -
Retrieving Record Set from Stored Proc Using ADO and VB (SCR 782)

It appears to have an example of passing a cursor back to a recordset,
though I've never tried it.


HTH.

Beth


-Original Message-
Sent: Friday, June 13, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


 
 
 Why can't you use bind variables?  I thought using .Parameters method
 (property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?

 
 What function, and where can't you use it?
 
Stored Procedure type function (i.e. user-written) called from VB. 'Cos
it's a Stored Procedure it will use bind variables, but you can't return
a result set to VB.

Craig


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

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

RE: Query Tuning Question - new discovery

2003-06-13 Thread Barbara Baker

not necessarily.

can you post the lines immediately above those you've
provided? (call, count, cpu, elapsed, etc.)

 It looks like 'bitmap conversion to rowids' is the
 hogger. 

Anybody know what this implies? Should I try
 dropping and recreating the index as b-tree? We
 don't have an identical test system here so I need a
 'warm and fuzzy' before doing that in our
 production.
 Dennis
 
 0  SORT GROUP BY
   0   NESTED LOOPS
   0NESTED LOOPS
   0 NESTED LOOPS
   0  HASH JOIN
   0   HASH JOIN
   7INDEX RANGE SCAN (object id 44819)
   0NESTED LOOPS
 156 NESTED LOOPS
   9  HASH JOIN
   2   TABLE ACCESS FULL REG_MGR
   9   TABLE ACCESS FULL SHIPTO_SALESTYP
 164  TABLE ACCESS BY INDEX ROWID
 CUST_SHIPTO
 164   INDEX RANGE SCAN (object id
 447931)
 231 TABLE ACCESS BY INDEX ROWID
 INVC_LINE
 1323618  BITMAP CONVERSION TO ROWIDS
 346   BITMAP INDEX SINGLE VALUE
   0   TABLE ACCESS FULL SALESREP_DTL
   0  TABLE ACCESS BY INDEX ROWID MTL
   0   INDEX UNIQUE SCAN (object id 46433)
   0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO
   0  INDEX UNIQUE SCAN (object id 89347)
   0TABLE ACCESS BY INDEX ROWID
 INVC_LINE_ATTRB
   0 INDEX UNIQUE SCAN (object id 43441)
 
 -Original Message-
 Sent: Thursday, June 12, 2003 3:41 PM
 To: Multiple recipients of list ORACLE-L
 
 
 has anythign changed in the table? inserts, updates,
 deletes? if so considering doing a move on the table
 to rebuild it and possibly rebuilding the indexes in
 question. 
 
 have you gather statistics lately? Is it using the
 same plan it was using a fwe weeks ago? 
 
 
  
  From: Meng, Dennis [EMAIL PROTECTED]
  Date: 2003/06/12 Thu PM 03:54:59 EDT
  To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
  Subject: Query Tuning Question
  
  Hi fellow DBAs,
  This is kind of the follow-up of my last E-mail on
 wait event. 
  I have a query that is taking hours to complete
 and the plan looks ok. While one of the tables is
 huge (267mil rows) it is being accessed using one of
 its indexes.
  I recorded some stats from v$session_wait while
 the query is running to see which segment is query
 is hanging up on and the result is the big table
 with 267mil rows.
  Funny thing is, according to the user community,
 this query took only minutes to run couple of weeks
 ago.
  What could be the cause of this wait? When index
 is being used, oracle will go directly to the data
 block and retrieve the data, which should be very
 efficient correct? 
   
   
  TIA
   
  Dennis
  
   
  
  
  
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Meng, Dennis
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

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

RE: Query Tuning Question - new discovery

Title: RE: Query Tuning Question - new discovery





A Ha ...


it is refers to _B_TREE_BITMAP_PLANS variable ... it is true by default and what you see is the side effect. If you are not using BMI, set it to false.


http://tinyurl.com/e8ws for more info


Raj

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



-Original Message-
From: Meng, Dennis [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 13, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Query Tuning Question - new discovery



I did a sql trace and tkprof and here is the output. It looks like 'bitmap conversion to rowids' is the hogger. Anybody know what this implies? Should I try dropping and recreating the index as b-tree? We don't have an identical test system here so I need a 'warm and fuzzy' before doing that in our production.

Dennis


0 SORT GROUP BY
 0 NESTED LOOPS
 0 NESTED LOOPS
 0 NESTED LOOPS
 0 HASH JOIN
 0 HASH JOIN
 7 INDEX RANGE SCAN (object id 44819)
 0 NESTED LOOPS
 156 NESTED LOOPS
 9 HASH JOIN
 2 TABLE ACCESS FULL REG_MGR
 9 TABLE ACCESS FULL SHIPTO_SALESTYP
 164 TABLE ACCESS BY INDEX ROWID CUST_SHIPTO
 164 INDEX RANGE SCAN (object id 447931)
 231 TABLE ACCESS BY INDEX ROWID INVC_LINE
1323618 BITMAP CONVERSION TO ROWIDS
 346 BITMAP INDEX SINGLE VALUE
 0 TABLE ACCESS FULL SALESREP_DTL
 0 TABLE ACCESS BY INDEX ROWID MTL
 0 INDEX UNIQUE SCAN (object id 46433)
 0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO
 0 INDEX UNIQUE SCAN (object id 89347)
 0 TABLE ACCESS BY INDEX ROWID INVC_LINE_ATTRB
 0 INDEX UNIQUE SCAN (object id 43441)


-Original Message-
Sent: Thursday, June 12, 2003 3:41 PM
To: Multiple recipients of list ORACLE-L



has anythign changed in the table? inserts, updates, deletes? if so considering doing a move on the table to rebuild it and possibly rebuilding the indexes in question. 

have you gather statistics lately? Is it using the same plan it was using a fwe weeks ago? 



 
 From: Meng, Dennis [EMAIL PROTECTED]
 Date: 2003/06/12 Thu PM 03:54:59 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Query Tuning Question
 
 Hi fellow DBAs,
 This is kind of the follow-up of my last E-mail on wait event. 
 I have a query that is taking hours to complete and the plan looks ok. While one of the tables is huge (267mil rows) it is being accessed using one of its indexes.

 I recorded some stats from v$session_wait while the query is running to see which segment is query is hanging up on and the result is the big table with 267mil rows.

 Funny thing is, according to the user community, this query took only minutes to run couple of weeks ago.
 What could be the cause of this wait? When index is being used, oracle will go directly to the data block and retrieve the data, which should be very efficient correct? 

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


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



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

RE: Fragmentation ?

2003-06-13 Thread Seefelt, Beth


I think those guys work here now  :-)

-Original Message-
Sent: Friday, June 13, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L



That's one thing good about the databases here.  Tablespace
fragmentation is
rarely a problem.  Most of the database here are a Database Roach Motel:
Data checks in.  It doesn't check out.  Somehow, the data purge part
of
the application -- that they intended to put in one of these days --
never
got written.



(For non-USA dwellers, Roach Motel is a trap for roaches.  It has a
sticky
floor, and the sales motto is Roaches check in. They don't check out.)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

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

2003-06-13 Thread Jacques Kilchoer

We should probably clarify this.
1 - has bee

 -Original Message-
 From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED]
 Sent: vendredi, 13. juin 2003 00:29
 To: Multiple recipients of list ORACLE-L
 Subject: RE: db file sequential read [WAS:wait event puzzler]

 Hi,

 Thanks to all for you responses.

 To sum up the suggestions:

 1)You can modify col$.NAME to varchar2(60) and try..  
 2)I do agree with you. But some times we may need go beyond the
 scopes.
   For testing purpose we can do these kind of RD's.(alterning the
 col.Cname size)
   Nothing wrong in this.
 3)That is a Very Good Idea...
   We will do away with DDL Stmts will start writing directly into
 the Data Dictionary ...
 4)Oracle does not support column names that are longer than 30
 characters.  
   This is a hard standard and can not be changed.
 5)Ur not supposed to Update Data Dictionaly Tables Directly ... 
   Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your
 Columns within 30 Chrs... 
 6)Updating a data dictionary is simply not done. Remember, we're 
   the DBA (you will be assimilated) and not fun loving students
 who can play with their alma mater's equipment. 
   Updating the data dictionary directly would cause the database
 to lose support from 
   Oracle Corp. and the perpetrator would be liable.
 7)telling him to do a Update on COL$... He Ends up Doing that in
 his Production Database.. 
   And he is going to be in a HOT soup
 8)Write a compress / decompress algorithm that will take your
 200-character table names from 
   the application and pass them to the database as = 30
 characters; then uncompress them from 
   the database back to the application.
 9)references to DB naming conventions.

 I would want to go with the majority. Do not Do it!!.

 But then, the problem is like, I cannot afford to shorten 
 names as there
 are a lot of other problems which crops up.
 Though right now, thatz what we do and which is what I am 
 attempting to
 avoid.
 Ofcourse, the suggestion to have an algo. translate the names 
 is a good
 one, which is thought of and is the current
 Decision. 

 Whew!, if oralce supports more than 30 characters for column 
 names, life
 would be easier.

 Can somebody explain in brief, why this is being restricted to 30
 characters?

 And once again, thanks a lot!

 Baski

 -Original Message-
 Sent: Thursday, June 12, 2003 7:10 PM
 To: Multiple recipients of list ORACLE-L

 Modifying  data dictionary tables is definitely not a  good 
 idea and I 
 am sure Oracle will not support this.

 CP

 [EMAIL PROTECTED] wrote:

 Dear Bhaskar,

 You can modify col$.NAME to varchar2(60) and try.

 If this fails, I'll give a procedure you can use that to 
 change it to 
 whatever size you want.

 Senthil Kumar
 Sr Oracle DBA
 Summitworks Technologies Pvt Ltd

 -Original Message-
 Bhaskar Viswanathan
 Sent: Thursday, June 12, 2003 4:00 PM
 To: Multiple recipients of list ORACLE-L

 hi,

 We use Oracle 8 DB.

 I am not a Oracle technical guy. So lemme try explaining the problem.

 We need to create tables with columns, whose names(column-names) are 
 more than 30 characters long. This is being restricted because, all 
 columns of all tables have entries in a table called 'col'.
 Thit table is defined as:

 SQL desc col
  Name  Null?Type
  - 

  TNAME NOT NULL VARCHAR2(30)
  COLNO NOT NULL NUMBER
  CNAME NOT NULL VARCHAR2(30)
  COLTYPEVARCHAR2(106)
  WIDTH NOT NULL NUMBER
  SCALE  NUMBER
  PRECISION  NUMBER
  NULLS  VARCHAR2(19)
  DEFAULTVAL LONG
  CHARACTER_SET_NAME VARCHAR2(44)
 SQL

 since CNAME is defined as VARCHAR2(30), we are forced to 
 retrict column

 names to a max of 30 characters long.

 For eg. create table T1(x31 
 varchar2(50)); 
 The above statement will be rejected with the error:
  *
 ERROR at line 1:
 ORA-00972: identifier is too long

 However, the statement create table 
 T1(30 
 varchar2(50)) Succeeds in creating the table;

 I guess this table col is created by the system itself. how can we 
 change this size So that the 30 character restriction in 
 column names 
 can be avoided???

 baski

 **Disclaimer*
 **
 *

 Information contained in this E-MAIL being proprietary to 
 Wipro Limited

 is 'privileged'

RE: db file sequential read [WAS:wait event puzzler]

2003-06-13 Thread Jacques Kilchoer

Clarifying:
1 - has been shown to be impossible.
2 - Most people on the list disagree with this. Even if someone wants to try it for 
testing it won't help you in production.
3 - Was a JOKE!
4 - True.
5 - True.
6 - True.
7 - True. Dangerous advice should always be accompanied by a ton of caveats.
8 - was a JOKE!
9 - good advice. Read The Fine Manual.

Summary - updating the data dictionary directly means that Oracle will not support 
your database. Unless you're not paying for any support, nothing you do is worth that 
risk.

Why is the limit 30 characters? It has always been that way. Who decided 30 characters 
when Oracle was first built? The answer is probably lost in the mists of time. Why is 
it still 30 characters? I am guessing because changing that size would cause millions 
of lines of code (Oracle software, third-party software, customer homegrown software) 
to have to be modified and there is not enough demand for Oracle to make that change.

 -Original Message-
 From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED]
 
 To sum up the suggestions:
 
 1)You can modify col$.NAME to varchar2(60) and try..  
 2)I do agree with you. But some times we may need go beyond the
 scopes.
   For testing purpose we can do these kind of RD's.(alterning the
 col.Cname size)
   Nothing wrong in this.
 3)That is a Very Good Idea...
   We will do away with DDL Stmts will start writing directly into
 the Data Dictionary ...
 4)Oracle does not support column names that are longer than 30
 characters.  
   This is a hard standard and can not be changed.
 5)Ur not supposed to Update Data Dictionaly Tables Directly ... 
   Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your
 Columns within 30 Chrs... 
 6)Updating a data dictionary is simply not done. Remember, we're 
   the DBA (you will be assimilated) and not fun loving students
 who can play with their alma mater's equipment. 
   Updating the data dictionary directly would cause the database
 to lose support from 
   Oracle Corp. and the perpetrator would be liable.
 7)telling him to do a Update on COL$... He Ends up Doing that in
 his Production Database.. 
   And he is going to be in a HOT soup
 8)Write a compress / decompress algorithm that will take your
 200-character table names from 
   the application and pass them to the database as = 30
 characters; then uncompress them from 
   the database back to the application.
 9)references to DB naming conventions.
 
 I would want to go with the majority. Do not Do it!!.
 
 But then, the problem is like, I cannot afford to shorten 
 names as there
 are a lot of other problems which crops up.
 Though right now, thatz what we do and which is what I am 
 attempting to
 avoid.
 Ofcourse, the suggestion to have an algo. translate the names 
 is a good
 one, which is thought of and is the current
 Decision. 
 
 Whew!, if oralce supports more than 30 characters for column 
 names, life
 would be easier.
 
 Can somebody explain in brief, why this is being restricted to 30
 characters?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

RE: Want to BAARF - Recommendations for 10 36G Drive config

2003-06-13 Thread Niall Litchfield

I figure you have disks set out so

Drive 1 + Drive 2 = OS
Drive 2 + Drive 3 = Two tablespaces
Drive 4 + 5 + 6   = Oracle Default Tablespaces. 

And you have bought 4 more disks. 

I theorize, like test this to infinity and beyond, that changing this
to the following will improve IO performance.
Drive 1 + Drive 2 = OS
Drive 3 + Drive 4 = swap + archive logs
Drive 5 + Drive 6 (mirroring) Drive 7 + Drive 8 = oracle data files. 
Drive 9 + Drive 10 = redo logs. 

I.E. stick your data on raid 10,stick redo and archive on two separate
mirror sets and separate swap from os. 

At which point you will no doubt discover that your IO capacity was fine
and it was the damn data that was the issue. 

Niall

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Dave Phillips
 Sent: 13 June 2003 16:26
 To: Multiple recipients of list ORACLE-L
 Subject: Want to BAARF - Recommendations for 10 36G Drive config
 
 
 A client runs our app with the following layout. Since their 
 intial 6 drive config they have procured more drives for a 
 total of 10 36Gig Drives. They have also upgraded memory from 
 1 to 4 gig. I have the opportunity to recommend changes to 
 the current structure to improve performance. 
 So, any recommendations from the BAARF committee are welcome. 
 
 Current System
 
 Ora 8.1.7
 Win 2k
 Size 30Gig
 Logical Array 1 - Raid 1 - OS and Oracle
 Logical Array 2 - Raid 1 - App and Index TS
 Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc)
 
 
 
 
 David Phillips
 Support DBA
 BAARF member wanna-be
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Dave Phillips
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 

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

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

2003-06-13 Thread Basavaraja, Ravindra

Hi All,

I am an Oracle DBA/Developer.I want to start setting up and using Oracle JMS.How do I 
get started.
I have a database Oracle EE 8.1.7.4.Do I have to install anything,how to configure for 
oracle jms?
Any available documents that gives a tutorial on this .I have checked metalink and 
didn't find
anything good.

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

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

ADO and bind variables (was RE: Performance improvement required :-))

2003-06-13 Thread Pardee, Roy E

This is interesting--if I use ADO with the ODBC provider (as the code does
below), I get the same results.  But if I use just ADO (that is, ms' OLE DB
provider for oracle (MSDAORA.1)) then I don't get bind vars.

(I'm doing INSERTs in my code, not SELECTs).

I wonder if oracle's native OLE DB provider works any differently--I would
bet that it does...

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, June 13, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L



I'm sure you can.  You should see it in an ODBC trace log, or you can
use trace events on the database.  Here's a really simplistic test I did
to verify it.  I ran this VB code that executes a really dumb query that
could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE
DUMMY = 'X'  but passed 'X' as a bind variable

Private Sub Form_Load()

Dim conn1 As New ADODB.Connection
Dim cmd1 As New ADODB.Command
Dim rs1 As New ADODB.Recordset
Dim STRSQLSTRING As String
Dim param1 As New Parameter

strConnect = UID=produser;PWD=prodpass;DSN=WAREHOUSE;
STRSQLSTRING = SELECT DUMMY FROM DUAL WHERE DUMMY = ?

With conn1
.ConnectionTimeout = 0
.CommandTimeout = 0
.CursorLocation = adUseClient
.Mode = adModeRead
.Open strConnect
End With
If Err.Number Then
  MsgBox Err.Number
  Exit Sub
End If
With cmd1
.ActiveConnection = conn1
.CommandText = STRSQLSTRING
.CommandType = adCmdText
Set param1 = .CreateParameter(DummyValue, adChar,
adParamInput, 1, X)
param1.Value = X
.Parameters.Append param1
Set rs1 = .Execute
End With

MsgBox rs1.Fields(DUMMY)

End Sub


Afterward, executed this on the database -


SQL select sql_text from v$sqlarea where sql_text like 'SELECT DUMMY
%';

SQL_TEXT



SELECT DUMMY FROM DUAL WHERE DUMMY = :1


It shows the parameter was definitely passed as a bind variable.


Check out this document on Metalink -
Retrieving Record Set from Stored Proc Using ADO and VB (SCR 782)

It appears to have an example of passing a cursor back to a recordset,
though I've never tried it.


HTH.

Beth


-Original Message-
Sent: Friday, June 13, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


 
 
 Why can't you use bind variables?  I thought using .Parameters method
 (property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?

 
 What function, and where can't you use it?
 
Stored Procedure type function (i.e. user-written) called from VB. 'Cos
it's a Stored Procedure it will use bind variables, but you can't return
a result set to VB.

Craig


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

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

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

2003-06-13 Thread Niall Litchfield

I worked with a really smart guy once whom I won't name for obvious
reasons. He had previously worked for a software co that said Our
product includes an archive routine. It didn't, they never had to write
one because hey disks held 3 times the storage for half the price before
anyone wanted to archive anything - at which point you just bought some
more storage. 

I also probably ought to include the ongoing marital dispute that I am
having regarding books, my wife maintains that anything I haven't
accessed for a decade could be disposed of (think Tolkien, Donaldson,
Asimov, Shakespeare, Auden).  *I* maintain well we could always buy
another bookcase. Logic tends to dictate my wifes approach, management
I feel confident would say ah well doesn't cost much lets buy another
bookcase. 

In summary Niall's 2nd rule states that data always goes in but never
comes out. It's parkinsons law for databases

Niall

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Stephen Lee
 Sent: 13 June 2003 18:45
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Fragmentation ?
 
 
 
 That's one thing good about the databases here.  Tablespace 
 fragmentation is rarely a problem.  Most of the database here 
 are a Database Roach Motel: Data checks in.  It doesn't 
 check out.  Somehow, the data purge part of the application 
 -- that they intended to put in one of these days -- never 
 got written.
 
 
 
 (For non-USA dwellers, Roach Motel is a trap for roaches.  It 
 has a sticky floor, and the sales motto is Roaches check in. 
 They don't check out.)
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 

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

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

Title: RE: db file sequential read [WAS:wait event puzzler]





A Wild guess ... are those people who want more than thirtycharacternamesfortablecolumn by any chance used to work with JAVA or VB? 

One of our developer complained here that the limit of 30 characters on procedure name was too small (he had landed in an Oracle shop from MS shop), so we gently hinted to him that a column name is a column name, we have Microsoft Word installed to write position papers and technical memos ... he was a good sport though .. that helped.

Raj

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



-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 13, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: db file sequential read [WAS:wait event puzzler]



Clarifying:
1 - has been shown to be impossible.
2 - Most people on the list disagree with this. Even if someone wants to try it for testing it won't help you in production.

3 - Was a JOKE!
4 - True.
5 - True.
6 - True.
7 - True. Dangerous advice should always be accompanied by a ton of caveats.
8 - was a JOKE!
9 - good advice. Read The Fine Manual.


Summary - updating the data dictionary directly means that Oracle will not support your database. Unless you're not paying for any support, nothing you do is worth that risk.

Why is the limit 30 characters? It has always been that way. Who decided 30 characters when Oracle was first built? The answer is probably lost in the mists of time. Why is it still 30 characters? I am guessing because changing that size would cause millions of lines of code (Oracle software, third-party software, customer homegrown software) to have to be modified and there is not enough demand for Oracle to make that change.


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

RE: SYS not able to GRANT -- Strange !

2003-06-13 Thread Freeman Robert - IL

Yep, 9i allows sys to grant privs on objects in other schemas.

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/12/2003 11:34 PM

its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.

i think that has changed in 9i but its late and my brain is fuzzy.

joe


Prem Khanna J wrote:

Guys,

CONNECT SYS AS SYSDBA;

   create user testuser1 identified by testuser1 ;
   grant connect, resource to testuser1;

   create user testuser2 identified by testuser2 ;
   grant create session to testuser2;

   create table testuser1.table1 ( a int ) ;

   grant select on testuser1.table1 to testuser2;
   error at line 1:
   ora-01031: insufficient privileges

WHERE AS :

   connect testuser1/testuser1;

   grant select on testuser1.table1 to testuser2;

   grant succeeded.


why is it so ? 
why sys is not able to GRANT ?
seems to be strange !

the env. is 8.1.6.0./win2k.

Jp.


  


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


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

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

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

RE: Want to BAARF - Recommendations for 10 36G Drive config

2003-06-13 Thread Richard Ji

At which point you will no doubt discover that your IO capacity was fine
and it was the damn data that was the issue. 

That can be simply resolved by certain truncate commands. :)

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Dave Phillips
 Sent: 13 June 2003 16:26
 To: Multiple recipients of list ORACLE-L
 Subject: Want to BAARF - Recommendations for 10 36G Drive config

 A client runs our app with the following layout. Since their 
 intial 6 drive config they have procured more drives for a 
 total of 10 36Gig Drives. They have also upgraded memory from 
 1 to 4 gig. I have the opportunity to recommend changes to 
 the current structure to improve performance. 
 So, any recommendations from the BAARF committee are welcome. 

 Current System

 Ora 8.1.7
 Win 2k
 Size 30Gig
 Logical Array 1 - Raid 1 - OS and Oracle
 Logical Array 2 - Raid 1 - App and Index TS
 Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc)

 David Phillips
 Support DBA
 BAARF member wanna-be
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Dave Phillips
   INET: [EMAIL PROTECTED]

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

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

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

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

RE: Fragmentation ?

2003-06-13 Thread Rachel Carmichael

your wife's rule wouldn't work in my case... every few years (usually
less than 10 but on occasion 10 works too) I go on a re-reading
spree. back to old friends, comfort food of books.

I'd have to buy all new copies if I threw books out.

I do, on rare occasion, get rid of books. My oracle books that tell me
how to tune Version 7 are one example :)

--- Niall Litchfield [EMAIL PROTECTED] wrote:
 I worked with a really smart guy once whom I won't name for obvious
 reasons. He had previously worked for a software co that said Our
 product includes an archive routine. It didn't, they never had to
 write
 one because hey disks held 3 times the storage for half the price
 before
 anyone wanted to archive anything - at which point you just bought
 some
 more storage. 
 
 I also probably ought to include the ongoing marital dispute that I
 am
 having regarding books, my wife maintains that anything I haven't
 accessed for a decade could be disposed of (think Tolkien, Donaldson,
 Asimov, Shakespeare, Auden).  *I* maintain well we could always buy
 another bookcase. Logic tends to dictate my wifes approach,
 management
 I feel confident would say ah well doesn't cost much lets buy
 another
 bookcase. 
 
 In summary Niall's 2nd rule states that data always goes in but
 never
 comes out. It's parkinsons law for databases
 
 Niall
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
  Behalf Of Stephen Lee
  Sent: 13 June 2003 18:45
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Fragmentation ?
  
  
  
  That's one thing good about the databases here.  Tablespace 
  fragmentation is rarely a problem.  Most of the database here 
  are a Database Roach Motel: Data checks in.  It doesn't 
  check out.  Somehow, the data purge part of the application 
  -- that they intended to put in one of these days -- never 
  got written.
  
  
  
  (For non-USA dwellers, Roach Motel is a trap for roaches.  It 
  has a sticky floor, and the sales motto is Roaches check in. 
  They don't check out.)
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Stephen Lee
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
  and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed 
  from).  You may also send the HELP command for other 
  information (like subscribing).
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Niall Litchfield
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Inverse 9i Question

2003-06-13 Thread Freeman Robert - IL

Just in the mood to do one of these
Which of the following is *not* a feature of Oracle 9i?

a. The ability to Rename a Column
b. The ability to Rename a Constraint
c. The ability to rename a tablespace
d. The ability to drop a column
e. The utl_xplan function to format execution plans from the SQL prompt.

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

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

RE: Fragmentation ?

2003-06-13 Thread John Kanagaraj

Aaah - now I understand. The LRU rule does not hold good once the Goddess
applies her personal touch and 'accesses' these blocks (sorry - books) :)
So they need to stay in the DB B(l)ock buffer cache as they now migrate to
the MRU end of the cache chain... The blocks that do need to go out of the
(book) cache are actually those that have been updated!

Couldn't resist the rambling - it is Friday! 

John

 -Original Message-
 From: Rachel Carmichael [mailto:[EMAIL PROTECTED]
 Sent: Friday, June 13, 2003 12:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Fragmentation ?
 
 
 your wife's rule wouldn't work in my case... every few years (usually
 less than 10 but on occasion 10 works too) I go on a re-reading
 spree. back to old friends, comfort food of books.
 
 I'd have to buy all new copies if I threw books out.
 
 I do, on rare occasion, get rid of books. My oracle books that tell me
 how to tune Version 7 are one example :)
 
 --- Niall Litchfield [EMAIL PROTECTED] wrote:
  I worked with a really smart guy once whom I won't name for obvious
  reasons. He had previously worked for a software co that said Our
  product includes an archive routine. It didn't, they never had to
  write
  one because hey disks held 3 times the storage for half the price
  before
  anyone wanted to archive anything - at which point you just bought
  some
  more storage. 
  
  I also probably ought to include the ongoing marital dispute that I
  am
  having regarding books, my wife maintains that anything I haven't
  accessed for a decade could be disposed of (think Tolkien, 
 Donaldson,
  Asimov, Shakespeare, Auden).  *I* maintain well we could always buy
  another bookcase. Logic tends to dictate my wifes approach,
  management
  I feel confident would say ah well doesn't cost much lets buy
  another
  bookcase. 
  
  In summary Niall's 2nd rule states that data always goes in but
  never
  comes out. It's parkinsons law for databases
  
  Niall
  
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
   Behalf Of Stephen Lee
   Sent: 13 June 2003 18:45
   To: Multiple recipients of list ORACLE-L
   Subject: RE: Fragmentation ?
   
   
   
   That's one thing good about the databases here.  Tablespace 
   fragmentation is rarely a problem.  Most of the database here 
   are a Database Roach Motel: Data checks in.  It doesn't 
   check out.  Somehow, the data purge part of the application 
   -- that they intended to put in one of these days -- never 
   got written.
   
   
   
   (For non-USA dwellers, Roach Motel is a trap for roaches.  It 
   has a sticky floor, and the sales motto is Roaches check in. 
   They don't check out.)
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   -- 
   Author: Stephen Lee
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051 
http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
  and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed 
  from).  You may also send the HELP command for other 
  information (like subscribing).
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Niall Litchfield
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: Inverse 9i Question