RE: help

[Robertson Lee - lerobe]

HELP !!


-Original Message-
Sent: 17 December 2001 22:50
To: Multiple recipients of list ORACLE-L


You're kidding, right?


--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
 Does this mean that I am no longer on the mailing list?
 Thanks you for your help
 Mer
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:26
 To: Multiple recipients of list ORACLE-L
 
 
 Please remove me from the mailing list,
 Thank you
 Mer
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:11
 To: Multiple recipients of list ORACLE-L
 
 
 
 HELP 
 
 ** 
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 **
 
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 
 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

RE: RECOMPILE INVALID OBJECTS

[Christian Trassens]

You can use the $OH/rdbms/admin/utlrp.sql even in 7.X.
However in this last case you must edit and change
where you find type# for type without #. App has a
similar procedure.

Regards.


--- Glenn Travis [EMAIL PROTECTED] wrote:
 If you've got a big schema (READ: Apps), this will
 cripple you.  Been there, done that, and will never
 do it again in an Apps database.
 
 I have found it always better to generate my own
 recompile sql (see script at bottom of my notes). 
 
 Footnote:  Read the docs for 8.1.7 as Oracle has
 added another parameter to this command.
 
 DBMS_UTILITY.COMPILE_SCHEMA (schema, FALSE); 
 
 The newer version of DBMS_UTILITY.COMPILE_SCHEMA
 (schema) has an extra boolean argument which
 defaults to TRUE (compile everything) for backwards
 compatibility, However, due to the problem of object
 dependancies being circular in the sys.dependancy$
 table (causing the original problem with
 sys.ORDER_OBJECT_BY_DEPENDENCY view), Many objects
 are actually INVALIDATED by the default usage. 
 
 Solution: 
 Running DBMS_UTILITY.COMPILE_SCHEMA (schema,
 FALSE) will only compile the INVALID objects and
 seems to work much better. 
 
 RECOMPILE SCRIPT:
 
 set heading off 
 set pagesize 0 
 set lines 79 
 set verify off 
 set echo off 
 set feedback off
  
 spool comp_all.tmp
 select
 decode( OBJECT_TYPE, 'PACKAGE BODY',
 'alter package ' || OWNER||'.'||OBJECT_NAME || '
 compile body;',
 'alter ' || OBJECT_TYPE || ' ' ||
 OWNER||'.'||OBJECT_NAME || ' compile;'
 )
 from
 dba_objects a,
 sys.order_object_by_dependency b
 where
 A.OBJECT_ID = B.OBJECT_ID(+) and
 STATUS = 'INVALID' and
 OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE',
 'FUNCTION', 'PROCEDURE',
   'TRIGGER', 'VIEW' )
 order by
 DLEVEL DESC,
 OBJECT_TYPE,
 OBJECT_NAME;
  
 spool off
  
 @comp_all.tmp
 
 
 
  -Original Message-
  From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
  Sent: Monday, December 17, 2001 2:25 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: RECOMPILE INVALID OBJECTS
  
  
  just out of curiousity, does this buy one
 something extra over/above:
  
  execute dbms_utility.compile_schema('user');
  
  
  
  
  
  
  -Original Message-
  Sent: Monday, December 17, 2001 1:58 PM
  To: Multiple recipients of list ORACLE-L
  
  
     start
 --
  set heading off
  set pagesize 0
  set linesize 79
  set verify off
  set echo off
  spool recomp_all.tmp
  select decode( OBJECT_TYPE, 'PACKAGE BODY',
  'alter package ' || OWNER||'.'||OBJECT_NAME ||
 ' compile body;',
  'alter ' || OBJECT_TYPE || ' ' ||
 OWNER||'.'||OBJECT_NAME 
  || ' compile;'
  )
  from dba_objects A, sys.order_object_by_dependency
 B
  where A.OBJECT_ID = B.OBJECT_ID(+) and
   STATUS = 'INVALID' and
   OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE',
 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
  order by DLEVEL DESC, OBJECT_TYPE, OBJECT_NAME;
  spool off
  
  @recomp_all.tmp
   end 
  Raj
 

__
  Rajendra Jamadagni  MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN dot com
  Any opinion expressed here is personal and doesn't
 reflect 
  that of ESPN Inc.
  
  QOTD: Any clod can have facts, but having an
 opinion is an art!
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  -- 
  Author: Mohan, Ross
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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


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


=
ENG. Christian Trassens
Senior DBA
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +34-699240979
+34-649824704

__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your 

RE: Redo logs lost, old backups

[K Gopalakrishnan]

Yes. There are ways to recover the database (of course , unsupported) . let
me know the following details by offline,
I will be able to help you.

What is the current state of the database?
What is the size of the redo logs?
Was the last shutdown (if the database is down) is immediate or abort?
Which version of Oracle and OS?
Do you have the trace of the control file ?
Do you know the locations of ALL datafiles?
Do you have the alert log in place?


Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
(SEA)
Sent: Monday, December 17, 2001 8:10 PM
To: Multiple recipients of list ORACLE-L

HELP!  I got hit with something or someone today and all the redologs for 2
of my production databases disappeared.  I have no idea how, and will leave
it to the SysAdmin
to figure out what happened and how to prevent it from happening again.  I
am not in archivelog mode and normally take nightly cold backups.  If at all
possible, I need to recover these databases.  The other problem is that my
backup script was broken and (during my absence, I should never have taken a
2 week honeymoon!) no backups were taken.
So, I'm working with 2 week old cold backup, and wondered if anyone knows a
way (unsupported, of course) to recover the tablespaces that hold data with
the old system datafile?
I have tried all methods of recovery I could come up with to get the
database to start without the logfiles, (using recover ... using backup
controlfile, rebuilding controlfile) ... but always end up with a message
that the system tablespace needs media recovery.

I took a cold backup of the mess before I started tinkering with it, and I'm
willing to try anything.  Any ideas?


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maser, Donna  (SEA)
  INET: [EMAIL PROTECTED]

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

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


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

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

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

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

RE: Calling Host

[Thomas, Kevin]

This is something that has appeared on this list a few times. If you check
the archives, I posted an explanation on how to do this using a couple of
shell scripts and a stored procedure.

Regards,
Kev.

-Original Message-
Sent: 17 December 2001 20:35
To: Multiple recipients of list ORACLE-L


Hi Listers,

Can we call operating system command from store procedure or trigger ?
I have created the following simple store procedure :

CREATE OR REPLACE  PROCEDURE PROCTES is
begin
HOST('ls');
end;

But I got the error :
Line # = 3 Column # = 6 Error Text = PLS-00201: identifier 'LS' must be 
declared
Line # = 3 Column # = 1 Error Text = PL/SQL: Statement ignored


Thanks for any clue.

Aldi

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

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

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

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

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

RE: RECOMPILE INVALID OBJECTS

[Rahul Mehendale]

I ran the script below :

-
select decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME ||
' compile body;',
'alter ' || OBJECT_TYPE || ' ' ||
OWNER||'.'||OBJECT_NAME
|| ' compile;'
)
from dba_objects A, sys.order_object_by_dependency B
where A.OBJECT_ID = B.OBJECT_ID(+) and
STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE','FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
order by DLEVEL DESC, OBJECT_TYPE, OBJECT_NAME
/

---

I get the following error:
ERROR at line 8:
ORA-01436: CONNECT BY loop in user data

Whats this error ???

-rM


-Original Message-
Trassens
Sent: Tuesday, December 18, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L


You can use the $OH/rdbms/admin/utlrp.sql even in 7.X.
However in this last case you must edit and change
where you find type# for type without #. App has a
similar procedure.

Regards.


--- Glenn Travis [EMAIL PROTECTED] wrote:
 If you've got a big schema (READ: Apps), this will
 cripple you.  Been there, done that, and will never
 do it again in an Apps database.

 I have found it always better to generate my own
 recompile sql (see script at bottom of my notes).

 Footnote:  Read the docs for 8.1.7 as Oracle has
 added another parameter to this command.

 DBMS_UTILITY.COMPILE_SCHEMA (schema, FALSE);

 The newer version of DBMS_UTILITY.COMPILE_SCHEMA
 (schema) has an extra boolean argument which
 defaults to TRUE (compile everything) for backwards
 compatibility, However, due to the problem of object
 dependancies being circular in the sys.dependancy$
 table (causing the original problem with
 sys.ORDER_OBJECT_BY_DEPENDENCY view), Many objects
 are actually INVALIDATED by the default usage.

 Solution:
 Running DBMS_UTILITY.COMPILE_SCHEMA (schema,
 FALSE) will only compile the INVALID objects and
 seems to work much better.

 RECOMPILE SCRIPT:

 set heading off
 set pagesize 0
 set lines 79
 set verify off
 set echo off
 set feedback off

 spool comp_all.tmp
 select
 decode( OBJECT_TYPE, 'PACKAGE BODY',
 'alter package ' || OWNER||'.'||OBJECT_NAME || '
 compile body;',
 'alter ' || OBJECT_TYPE || ' ' ||
 OWNER||'.'||OBJECT_NAME || ' compile;'
 )
 from
 dba_objects a,
 sys.order_object_by_dependency b
 where
 A.OBJECT_ID = B.OBJECT_ID(+) and
 STATUS = 'INVALID' and
 OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE',
 'FUNCTION', 'PROCEDURE',
   'TRIGGER', 'VIEW' )
 order by
 DLEVEL DESC,
 OBJECT_TYPE,
 OBJECT_NAME;

 spool off

 @comp_all.tmp



  -Original Message-
  From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
  Sent: Monday, December 17, 2001 2:25 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: RECOMPILE INVALID OBJECTS
 
 
  just out of curiousity, does this buy one
 something extra over/above:
 
  execute dbms_utility.compile_schema('user');
 
 
 
 
 
 
  -Original Message-
  Sent: Monday, December 17, 2001 1:58 PM
  To: Multiple recipients of list ORACLE-L
 
 
     start
 --
  set heading off
  set pagesize 0
  set linesize 79
  set verify off
  set echo off
  spool recomp_all.tmp
  select decode( OBJECT_TYPE, 'PACKAGE BODY',
  'alter package ' || OWNER||'.'||OBJECT_NAME ||
 ' compile body;',
  'alter ' || OBJECT_TYPE || ' ' ||
 OWNER||'.'||OBJECT_NAME
  || ' compile;'
  )
  from dba_objects A, sys.order_object_by_dependency
 B
  where A.OBJECT_ID = B.OBJECT_ID(+) and
   STATUS = 'INVALID' and
   OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE',
 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
  order by DLEVEL DESC, OBJECT_TYPE, OBJECT_NAME;
  spool off
 
  @recomp_all.tmp
   end 
  Raj
 

__
  Rajendra Jamadagni  MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN dot com
  Any opinion expressed here is personal and doesn't
 reflect
  that of ESPN Inc.
 
  QOTD: Any clod can have facts, but having an
 opinion is an art!
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Mohan, Ross
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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

Re: Redo logs lost, old backups

[Rachel Carmichael]

how much money do you want to spend?

If you are willing to spend a lot (like $5K for every 8 hours with a
minimum of 16 hours -- price might have gone up, it was that about 3
years ago)

call Tech Support, ask to speak to someone in Field Support about Data
Unloader.

This is what it does perfectly -- mines the existing datafiles and
generates either sqlloader flat file input (if you don't have LONG
columns) or export dumps that can be imported.

You can restore using one of the old backups and truncate every table,
then use the Data Unloader outputs to recreate.

it will take time. Took me about 48 hours (some of which was spent
waiting for people to arrive) from the time my database crashed because
the redo logs were corrupted to the time we were back up and running.

if you want more details, email me offlist.

Rachel


--- Maser, Donna  (SEA) [EMAIL PROTECTED] wrote:
 HELP!  I got hit with something or someone today and all the redologs
 for 2
 of my production databases disappeared.  I have no idea how, and will
 leave
 it to the SysAdmin
 to figure out what happened and how to prevent it from happening
 again.  I
 am not in archivelog mode and normally take nightly cold backups.  If
 at all
 possible, I need to recover these databases.  The other problem is
 that my
 backup script was broken and (during my absence, I should never have
 taken a
 2 week honeymoon!) no backups were taken.
 So, I'm working with 2 week old cold backup, and wondered if anyone
 knows a
 way (unsupported, of course) to recover the tablespaces that hold
 data with
 the old system datafile?  
 I have tried all methods of recovery I could come up with to get the
 database to start without the logfiles, (using recover ... using
 backup
 controlfile, rebuilding controlfile) ... but always end up with a
 message
 that the system tablespace needs media recovery.
 
 I took a cold backup of the mess before I started tinkering with it,
 and I'm
 willing to try anything.  Any ideas?
 
 
 The information contained in this email is intended for the
 personal and confidential use of the addressee only. It may
 also be privileged information. If you are not the intended
 recipient then you are hereby notified that you have received
 this document in error and that any review, distribution or
 copying of this document is strictly prohibited. If you have
 received  this communication in error, please notify Celltech
 Group immediately on:
 
 +44 (0)1753 534655, or email '[EMAIL PROTECTED]'
 
 Celltech Group plc
 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
 
 Registered Office as above. Registered in England No. 2159282
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Maser, Donna  (SEA)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle Expert and FK indexes

[Boivin, Patrice J]

I didn't do what the Oracle Expert told me to do... no time to experiment.

I will ask Oracle Support what is going on, thanks for reminding me.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Shreter, Hilary [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 17, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Expert and FK indexes

Hello, Patrice -- I realize that you wrote this last month.  Did you
ever
draw any conclusions about this behavior?

I am trodding the foreign key ground right now hoping to find the
golden key
to a huge performance issue.
I found many unindexed foreign keys (using the scripts per
Note:16428.1),
however none were in the areas I was researching.

I wonder if Expert wanted you to drop them if your table has few
rows or if
it has very little variability in the values.
Did you ever find the answer to why Expert suggested this?  Just
wondering.

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


Does someone know why the Oracle Expert would recommend dropping
indexes on
FK columns?

Maybe it calculates there is a low likelihood of the table being
locked
during referential integrity checks ?

I thought it was a good idea to have indexes on FK columns... this
is an old
7.3.4.5. database.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

return single record

[Shishir]

Hi Gurus!

i want to return a SQL which will call a function 
which returns one and only record.
like select function(arguments list) 
from dual; (or something similar to that);
I am not supoosed to use ref cursor or object 
(collection type) or pl-sql  table 
.
This funtion will certainly return use a user 
defined data type ( i am guessing ) but i want it to be used in SQL 
statement.
thanx in advance..


Shishir Kumar MishraAgni Software (P) 
Ltd.,Bangalore-560055, India
Email :[EMAIL PROTECTED]

RE: unused blocks BELOW HWM - Thanks

[Gene Gurevich]

Hi.

This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 

thank you all (you know who you are)


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: return single record

[Jamadagni, Rajendra]

Hmmm... let me have it clearly ...

1. You want to execute a function using SELECT
2. This function will return only one record.
3. This function will return a *user-defined-record*

Well, Oracle doesn't have a problem with 1  maybe 2 but it certainly does
have a problem with 3. SELECT can't handle data structures it doesn't know
about. 

Call me old timer, but what stops you from using the simple way ... why
SQL?

my_rec := my_users_function(arglist);

You could do this dynamically too ...

Okay ... what am I missing in this picture?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-Original Message-
Sent: Tuesday, December 18, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus!

i want to return a SQL which will call a function which returns one and only
record.
like select   function(arguments list)  from dual; (or something similar to
that);
I am not supoosed to use ref cursor or object (collection type) or pl-sql
table .
This funtion will certainly return use a user defined data type ( i am
guessing ) but i want it to be used  in SQL statement.
thanx in advance..


Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
Email :[EMAIL PROTECTED]



 



*1

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: Change PCTINCREAE for SYSTEM Tablespace

[Mercadante, Thomas F]

Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

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

RE: Change PCTINCREAE for SYSTEM Tablespace

[Ken Janusz]

I agree, I am leaving the SYSTEM tablespace alone.  Hands off.

Ken

 -Original Message-
Sent:   Tuesday, December 18, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change PCTINCREAE for SYSTEM Tablespace

Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

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

Re:RE: Change PCTINCREAE for SYSTEM Tablespace

[dgoulet]

Tom,

I agree and disagree with you, respectfully.  Oracle does allow some changes
to be made to sql.bsq and they always leave the option open to make changes
after database creation and I don't see this request as all that odd.  But for
the most part if you do as recommended and leave the system tablespace to sys
only you should not have a problem.  That is until migration time!!

Dick Goulet

Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date:   12/18/2001 5:30 AM

Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

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

synonym for a user-defined data type?

[Feldhausen, Hans]

We're working with Oracle v8.1.6.2. 
 

How can we declare a synonym for a user-defined data type? We would like to 
create a public synonym for a user-defined data type so that when this  
data-type is created under one schema it is accessible to all schemas

without having to prefix it.
 
TIA!  

Hans Feldhausen 
GEICO DBA
(301) 986-3746
[EMAIL PROTECTED]


 
This email/fax message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution of this email/fax is prohibited. If
you are not the intended recipient, please contact the sender by email/fax
and destroy all paper and electronic copies of the original message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Feldhausen, Hans
  INET: [EMAIL PROTECTED]

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

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

RE: PL/SQL Cursor

[Ken Janusz]

Raj:

Here is the code when I run it.  Any idea what the problem is?

Thanks, Ken

DECLARE
  cursor ok_sos_hist_reg_nbr_cur is
select tsh.tm_hist_reg_number,
   tdh.tm_hist_reg_number,
   trh.tm_hist_reg_number,
   d.tm_hist_reg_number
from   tm_status_history tsh,
   trademark_data_history tdh,
   trademark_registrant_history trh,
   document d
where  tsh.tm_hist_reg_number = tdh.tm_hist_reg_number
  and  tdh.tm_hist_reg_number = trh.tm_hist_reg_number
  and  trh.tm_hist_reg_number = d.tm_hist_reg_number
ORA-06550: line 14, column 0:
PLS-00103: Encountered the symbol end-of-file when expecting one of the
following:

   . ( * @ %  - + ; / at for mod rem an exponent (**) and or
   group having intersect minus order start union where connect
   ||

BEGIN
  if not ok_sos_hist_reg_nbr_cur%ISOPEN
  then
open ok_sos_hist_reg_nbr_cur
ORA-06550: line 5, column 0:
PLS-00103: Encountered the symbol end-of-file when expecting one of the
following:

   . ( % ; for


end if
end if
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
ORA-00900: invalid SQL statement


close ok_sos_hist_reg_nbr_cur
close ok_sos_hist_reg_nbr_cur
ORA-00900: invalid SQL statement


END
END
ORA-00900: invalid SQL statement


.
.
ORA-00900: invalid SQL statement





 -Original Message-
Sent:   Monday, December 17, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQL Cursor

  File: ESPN_Disclaimer.txt  This means that you are using some (bind)
variables but haven't supplied
values for them. Please post the code along with the open statement for the
cursor.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

RE: PL/SQL Cursor

[Ken Janusz]

Bind variables.  In Feuerstein's book in some of the code he shows the use
of the bind variable and in some he doesn't.  What is the rule on when to
use a bind variable?  The book doesn't discuss this.

Thanks,
Ken


 -Original Message-
Sent:   Monday, December 17, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: PL/SQL Cursor

It's all in the docs.  Read on DBMS_SQL package.
As for the error, you are getting, it is exactly, what it says: you didn't
bind variables (DBMS_SQL.BIND_VARIABLE(...)).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 4:26 PM


 I have written an explicit cursor - declare . . . begin . . . end.  When I
 try to run it I get this error:

 ORA-01008: not all variables bound

 I'm new to cursors, so I need some basic help.

 Thanks,
 Ken Janusz, CPIM
 Database Conversion Lead
 Sufficient System, Inc.
 Minneapolis, MN





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

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

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

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

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

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

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

RE: PL/SQL Cursor

[Jamadagni, Rajendra]

Isn't there a semicolon missing at the end of this line?

 and  trh.tm_hist_reg_number = d.tm_hist_reg_number

Due to missing semicolon oracle things the statement (of cursor definition)
is not yet complete and that's why you get the error.

???
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, December 18, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L


Raj:

Here is the code when I run it.  Any idea what the problem is?

Thanks, Ken

DECLARE
  cursor ok_sos_hist_reg_nbr_cur is
select tsh.tm_hist_reg_number,
   tdh.tm_hist_reg_number,
   trh.tm_hist_reg_number,
   d.tm_hist_reg_number
from   tm_status_history tsh,
   trademark_data_history tdh,
   trademark_registrant_history trh,
   document d
where  tsh.tm_hist_reg_number = tdh.tm_hist_reg_number
  and  tdh.tm_hist_reg_number = trh.tm_hist_reg_number
  and  trh.tm_hist_reg_number = d.tm_hist_reg_number
ORA-06550: line 14, column 0:
PLS-00103: Encountered the symbol end-of-file when expecting one of the
following:

   . ( * @ %  - + ; / at for mod rem an exponent (**) and or
   group having intersect minus order start union where connect
   ||

BEGIN
  if not ok_sos_hist_reg_nbr_cur%ISOPEN
  then
open ok_sos_hist_reg_nbr_cur
ORA-06550: line 5, column 0:
PLS-00103: Encountered the symbol end-of-file when expecting one of the
following:

   . ( % ; for


end if
end if
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
ORA-00900: invalid SQL statement


close ok_sos_hist_reg_nbr_cur
close ok_sos_hist_reg_nbr_cur
ORA-00900: invalid SQL statement


END
END
ORA-00900: invalid SQL statement


.
.
ORA-00900: invalid SQL statement




*2

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

Encryption - Question about the key

[Jamadagni, Rajendra]

Hi all,

I am investigating using dbms_obfuscation_toolkit in my application. Now, I
need a key to encrypt and decrypt the key. The question is how to protect
the key? The data will be accessed from Forms application, reports, SQR
reports, SQLPLUS scripts.

I need to find a mechanism to 
* hide the key from developers (or non authorized persons))
* preferable fetch the key from database
* make this fetching and storing key as non-intrusive as possible. 

What are my options? A column on application users table that is not
accessible? Hard coding the key is out of question. Also I need to separate
keys for production and development servers.

As I am clueless, any ideas are most welcome.

Happy Holidays
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!




*2

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: Change PCTINCREAE for SYSTEM Tablespace

[Kimberly Smith]

I think even Oracle would disagree with you on that one.  While it
is unsupported to change anything in the sql.bsq script (except with
Trusted Oracle where its required to actually get it to create a database)
anything that
is changeable after the fact is fair game.  As a matter of fact,
for all those GUI freaks out there;-) its one of the things you actually
get to change when creating the SYSTEM tablespace using dbassist.
Oracle had to pick a default so they chose 50.  They also chose a
default for the SGA but up until now it was pretty much a useless
default.  No where do they say that 50 for pctincrease is recommended
or that it should stay that way.  Don't forget, this is not
SQL Server.  We are encouraged by Oracle to set the system up
for optimal performance.

-Original Message-
Thomas F
Sent: Tuesday, December 18, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

RE: tns-12545

[Sherman, Edward]

Some questions for you:

What are you using to try to connect to Oracle?
Are you trying to use SQL*PLUS or and application that uses ODBC?
Is the user who can successfully connect on the same domain as you or
different domain?
Does you connection go through an oracle names server?
Can you post an entry from the sqlnet.log file that shows what happens when
the connection fails?

For starters, back up your tnsnames.ora file, get a copy of the tnsnames.ora
from machine that connects and copy to your machine and try to connect.
(Never mind that your tnsnames is correct... just try it).
Some machines can have multiple copies of tnsnames.ora. Make sure you got
the right one.

If the tnsnames has a hostname in the HOST= paramter then try using the IP
address of the target machine instead.

Example1.world = 
  (DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = 
  (COMMUNITY = tcp.world)
  (PROTOCOL = TCP)
  (Host = Production1)    hostname
  (Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
  )

Example1.world = 
  (DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = 
  (COMMUNITY = tcp.world)
  (PROTOCOL = TCP)
  (Host = 172.16.17.100)    use IP address instead.
  (Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
  )


 __   _ =
 -o)/ /  (_)__  __   __ | Ed Sherman    |
 /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |
_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
    | Tel: (407) 859-7410 x2708 |
    =
Supporter of the coalition for grumpiness where grumpiness is due

  




-Original Message-
Sent: Friday, December 14, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L


hi,

   can anybody help me w/ this error:
TNS-12545: Connect failed because target host or object does not exist
  this message pops up when i try to login into my nt database .
   i've already checked the tnsnames and the entry is correct.

 thanks.

Best Regards,
Grace Lim
Suy Sing Comm'l Corp.
(632)-2474134

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

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

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

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

RE: help

[Henry Poras]

Yeah, but you can be aged out.

-Original Message-
Sent: Monday, December 17, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L


There is no escape.  In the buffer pool, no one can hear you scream...


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 4:50 PM


 You're kidding, right?
 
 
 --- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
 [EMAIL PROTECTED] wrote:
  Does this mean that I am no longer on the mailing list?
  Thanks you for your help
  Mer
  
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:26
  To: Multiple recipients of list ORACLE-L
  
  
  Please remove me from the mailing list,
  Thank you
  Mer
  
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:11
  To: Multiple recipients of list ORACLE-L
  
  
  
  HELP 
  
  ** 
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
  
  **
  
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
  
  
  **
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
  
  
 
 
 __
 Do You Yahoo!?
 Check out Yahoo! Shopping and Yahoo! Auctions for all of
 your unique holiday gifts! Buy at http://shopping.yahoo.com
 or bid at http://auctions.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Paul Baumgartel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

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

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

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

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

Re: Change PCTINCREAE for SYSTEM Tablespace

[Jared Still]

The Oracle8i Admin Guide, Chapter 19, General Management of Schema Objects:

Give guidelines for setting storage parameters for data dictionary tables.

Setting PCINCREASE to 50 is an artifact from Oracle 6 and early releases of 7
which had a rather limited number of extents.

Jared


On Tuesday 18 December 2001 05:30, Mercadante, Thomas F wrote:
 Kimberly,

 I would agree with you if an experienced DBA makes the decision to change
 the storage parameters, and they absolutely know what the benfits would be.

 Generally speaking though, I think changing anything in the SYSTEM
 tablespace is bad practice.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Monday, December 17, 2001 8:45 PM
 To: Multiple recipients of list ORACLE-L


 Actually, I would not ignore the storage parameters of the SYSTEM
 tablespace.
 There are legit reasons to change the pctincrease to 0.  If you leave it at
 50 then SMON (or PMON can't remember at the moment) will try to coalesce
 the tablespace every time it wakes up.  Its work it has to do that it
 really does
 not need to do.  Better off scheduling to happen at your time schedule.

 -Original Message-
 Thomas F
 Sent: Monday, December 17, 2001 7:45 AM
 To: Multiple recipients of list ORACLE-L


 Ken,

 Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The
 ONLY thing you should concern yourself in regard with the SYSTEM tablespace
 is if the file needs to extend itself because it is too full.  All other
 storage parameters are created by Oracle at database create time and should
 not be changed.

 For other tablespaces, you can change this parameter anytime after the
 tablespace has been created.  It will not, however, change existing
 extents, but will be used when new extents are allocated.

 Hope this helps.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Monday, December 17, 2001 10:16 AM
 To: Multiple recipients of list ORACLE-L


 Is there any way that I can change the PCTINCREASE for the SYSTEM
 tablespace without recreating the DB?  For some reason the person who
 created the DB I am working on set PCTINCREASE to 50 (or didn't did not
 include this parameter).I am using this DB for a data conversion so
 there is no software connected to it and in turn no users on it.

 Thanks,
 Ken Janusz, CPIM
 Database Conversion Lead
 Sufficient Systems, Inc.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ken Janusz
   INET: [EMAIL PROTECTED]

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

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

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

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

Re: help

[Jared Still]

Are you an idiot?

Jared

;)

On Monday 17 December 2001 23:45, Robertson Lee - lerobe wrote:
 HELP !!


 -Original Message-
 Sent: 17 December 2001 22:50
 To: Multiple recipients of list ORACLE-L


 You're kidding, right?


 --- Boag, Merridy [SMTP:[EMAIL PROTECTED]]

 [EMAIL PROTECTED] wrote:
  Does this mean that I am no longer on the mailing list?
  Thanks you for your help
  Mer
 
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:26
  To: Multiple recipients of list ORACLE-L
 
 
  Please remove me from the mailing list,
  Thank you
  Mer
 
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:11
  To: Multiple recipients of list ORACLE-L
 
 
 
  HELP
 
  **
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
 
  **
 
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
 
 
  **
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]

 __
 Do You Yahoo!?
 Check out Yahoo! Shopping and Yahoo! Auctions for all of
 your unique holiday gifts! Buy at http://shopping.yahoo.com
 or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: unused blocks BELOW HWM - Thanks

[DENNIS WILLIAMS]

Gene - Now that you've gotten your answer, would you mind to post both of
the methods that you found to work so that the rest of us could learn?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L


Hi.

This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 

thank you all (you know who you are)


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: return single record

[Shishir]

Hi  Raj !
 Actually I had similar problems some days back where i was supposed to
treturn recordset(more than one) . At that time i created object and
collection of object and then using cast operator and the operator i was
able to return recodset from function . I could have used that  function in
sql statement also;
Actually i am Delphi programmar and our client does not want to use like
that. Moreover they don't want to use ref cursor or any PL sql table
 i hope  u will sugeest some thing on it.
thanx in advance
Shishir Kumar Mishra
Software Engineer
Agni Software (P) Ltd.,
25/1,  11th Main,18th Cross,
Malleswaram,
Bangalore-560055, India

Phone : +91-80-344 4576, 346 1126,346 1127
Fax   : +91-80-334 2049
Email :[EMAIL PROTECTED]
--



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 6:45 PM


 Hmmm... let me have it clearly ...

 1. You want to execute a function using SELECT
 2. This function will return only one record.
 3. This function will return a *user-defined-record*

 Well, Oracle doesn't have a problem with 1  maybe 2 but it certainly does
 have a problem with 3. SELECT can't handle data structures it doesn't know
 about.

 Call me old timer, but what stops you from using the simple way ... why
 SQL?

 my_rec := my_users_function(arglist);

 You could do this dynamically too ...

 Okay ... what am I missing in this picture?

 Raj
 __
 Rajendra Jamadagni  MIS, ESPN Inc.
 Rajendra dot Jamadagni at ESPN dot com
 Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

 QOTD: Any clod can have facts, but having an opinion is an art!

 -Original Message-
 Sent: Tuesday, December 18, 2001 7:25 AM
 To: Multiple recipients of list ORACLE-L


 Hi Gurus!

 i want to return a SQL which will call a function which returns one and
only
 record.
 like select   function(arguments list)  from dual; (or something similar
to
 that);
 I am not supoosed to use ref cursor or object (collection type) or pl-sql
 table .
 This funtion will certainly return use a user defined data type ( i am
 guessing ) but i want it to be used  in SQL statement.
 thanx in advance..


 Shishir Kumar Mishra
 Agni Software (P) Ltd.,
 Bangalore-560055, India
 Email :[EMAIL PROTECTED]






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

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

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

Re: Fw: tns-12545

[Kim_Thompson]

 Also see Metalink note 91554.1:
 
 Problem Description:
   =
 
 Trying a SQL*Plus connection from a Windows NT/95/98 client
 workstation to a WINDOWS NT 8.0.x/8.1.x DB server results
 in the following error code:
 
 ORA-12545: TNS: name lookup failure.
 Cause: The address specified is not valid, or the program being 
connected to does not exist. 
 Action: Ensure the ADDRESS parameters have been entered correctly; 
 the most likely incorrect parameter is the node name. 
 Ensure that the executable for the server exists (perhaps 
 oracle is missing.) If the protocol is TCP/IP, edit the 
 TNSNAMES.ORA file to change the host name to a numeric 
 IP address and try again.
 
 On the client workstation, make sure the IP address of the
 DB server is referenced in the TNSNAMES.ora file for each 
 aliasname.
 
 At the DB server, make sure the ip address of the server is
 referenced in the listener.ora file.
 

 Solution Explanation:
 =

 In this particular situation, the ip address was referenced
 in the tnsnames.ora file on the client workstation. According to 
 the trace file, on the redirect packet from the listener, it could
 not resolve the hostname provided in the listener.ora file. It 
 reported a hostname lookup failure, with main error code 12545.
 
 By placing the ip address into the listener.ora file, it had no 
 problem resolving the ip. After bouncing the listener, SQL*Plus
 should be able to connect with no further errors.
   .
 
 Kim Thompson
 City and County of San Francisco



__ Reply Separator 
_
Author:  grace [EMAIL PROTECTED] at ~ctl-internet-po
Date:12/17/01 6:40 PM




 wat do u mean by that the

 executable for the server exists (perhaps oracle is missing.) 
 i was able to ping the address and other user can login except for 
me... 

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  
Sent: Sunday, December 16, 2001 1:15 AM


 
  0:28-sherlock:ts01:jkstill-4  oerr tns 12545
  12545, 0, Connect failed because target host or object does 
not  exist
  // *Cause: The address specified is not valid, or the program 
being   // connected to does not exist.
  // *Action: Ensure the ADDRESS parameters have been entered 
correctly; the
  // most likely incorrect parameter is the node name.  Ensure that 
the   // executable for the server exists (perhaps oracle is 
missing.)
  // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change 
the   // host name to a numeric IP address and try again.
  [ /home/jkstill/tmp ]
 
  9:15-sherlock:ts01:jkstill-4 
 
 
  The error message indicates that your tnsnames.ora is in   all 
likelihood  incorrect.
 
  If you post the listener.ora from the server and the relevant   
portion of the tnsnames.ora file, someone will probably be
  able to point it out to you.
 
  Jared
 
 
 
  On Friday 14 December 2001 18:20, grace wrote:hi,
  
  can anybody help me w/ this error:
   TNS-12545: Connect failed because target host or object does 
not  exist
 this message pops up when i try to login into my nt database . 
  i've already checked the tnsnames and the entry is correct.
  
thanks.
  
   Best Regards,
   Grace Lim
   Suy Sing Comm'l Corp.
   (632)-2474134
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  --
  Author: Jared Still
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists 
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may 
  also send the HELP command for other information (like subscribing). 

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

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

RE: unused blocks BELOW HWM - Thanks

[Mohan, Ross]

Uh, amen. Isn't that the purpose of the list?

Or is there a *third* list, one on topic, a second 
off topic, and a third where all the answers really
are?

-Original Message-
Sent: Tuesday, December 18, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Gene - Now that you've gotten your answer, would you mind to post both of
the methods that you found to work so that the rest of us could learn?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L


Hi.

This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 

thank you all (you know who you are)


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: help

[Mohan, Ross]

HELP

-Original Message-
Sent: Monday, December 17, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L


You're kidding, right?


--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
 Does this mean that I am no longer on the mailing list?
 Thanks you for your help
 Mer
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:26
 To: Multiple recipients of list ORACLE-L
 
 
 Please remove me from the mailing list,
 Thank you
 Mer
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:11
 To: Multiple recipients of list ORACLE-L
 
 
 
 HELP 
 
 ** 
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 **
 
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 
 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]
 
 


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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

Error accessing package DBMS_APPLICATION_INFO

[Hamid Alavi]

List,

Do you have any idea, can I flush the memory before running the package, I
got this error when I wanted to run a package.
Here is teh error message:

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)


Begin
*
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

RE: help

[Boivin, Patrice J]

Mer, 

The listserv is just like a mail redirector, it takes any message and send a
copy to everyone on its list.

If you are receiving the messages, you are on its list of recipients.

As long as you get the e-mails... you are on the listserv.

Otherwise you wouldn't get them anymore.

Don't worry about all the crazy, obnoxious, unpleasant people on this
listserv.  They treat everyone the same way, even each other.

Some of them actually know a little bit about Oracle, they played with it on
their iMacs and their Windows9x PCs, so it's a good idea to subscribe to
this list anyway.

: )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

RE: unused blocks BELOW HWM - Thanks

[Gene Gurevich]

Sure,

I haven't got around to using the dbms procedure yet,
but these are two queries I ended up with. I have
checked them on several tables and the results are the

same:

here, of course, 1 is the table name and 2 is the
owner. the tables need to be analyzed before running
these queries

select TOTAL_B_HWM - USED_B_HWM
from
(select blocks TOTAL_B_HWM from dba_tables
where table_name = UPPER('1') and owner=
UPPER('2')),
(select
count(unique(substr(dbms_rowid.rowid_to_restricted(rowid,0),15,4)
||
   
substr(dbms_rowid.rowid_to_restricted(rowid,0),1,8)))
USED_B_HWM
from   2..1);

OR

select TOTAL - TOTAL_A_HWM - 1 - USED_B_HWM
from
(select blocks TOTAL FRom dba_segments
where segment_name = UPPER('1') and owner=
UPPER('2')),
(select empty_blocks TOTAL_A_HWM from dba_tables
where table_name = UPPER('1')),
(select
count(unique(substr(dbms_rowid.rowid_to_restricted(rowid,0),15,4)
||
   
substr(dbms_rowid.rowid_to_restricted(rowid,0),1,8)))
USED_B_HWM
from   2..1);
undef 1 2

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Gene - Now that you've gotten your answer, would you
 mind to post both of
 the methods that you found to work so that the rest
 of us could learn?
 Thanks.
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 
 -Original Message-
 Sent: Tuesday, December 18, 2001 7:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi.
 
 This is just to thank all who replied to my post.
 Based on what I read, I have got two different ways
 of
 calculating that number and they seem to produce the
 same result. 
 
 thank you all (you know who you are)
 
 
 =
 
 
 __
 Do You Yahoo!?
 Check out Yahoo! Shopping and Yahoo! Auctions for
 all of
 your unique holiday gifts! Buy at
 http://shopping.yahoo.com
 or bid at http://auctions.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Gene Gurevich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: unused blocks BELOW HWM - Thanks

[Gene Gurevich]

Sure,

I haven't got around to using the dbms procedure yet,
but these are two queries I ended up with. I have
checked them on several tables and the results are the

same:

here, of course, 1 is the table name and 2 is the
owner. the tables need to be analyzed before running
these queries

select TOTAL_B_HWM - USED_B_HWM
from
(select blocks TOTAL_B_HWM from dba_tables
where table_name = UPPER('1') and owner=
UPPER('2')),
(select
count(unique(substr(dbms_rowid.rowid_to_restricted(rowid,0),15,4)
||
   
substr(dbms_rowid.rowid_to_restricted(rowid,0),1,8)))
USED_B_HWM
from   2..1);

OR

select TOTAL - TOTAL_A_HWM - 1 - USED_B_HWM
from
(select blocks TOTAL FRom dba_segments
where segment_name = UPPER('1') and owner=
UPPER('2')),
(select empty_blocks TOTAL_A_HWM from dba_tables
where table_name = UPPER('1')),
(select
count(unique(substr(dbms_rowid.rowid_to_restricted(rowid,0),15,4)
||
   
substr(dbms_rowid.rowid_to_restricted(rowid,0),1,8)))
USED_B_HWM
from   2..1);
undef 1 2

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Gene - Now that you've gotten your answer, would you
 mind to post both of
 the methods that you found to work so that the rest
 of us could learn?
 Thanks.
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 
 -Original Message-
 Sent: Tuesday, December 18, 2001 7:05 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi.
 
 This is just to thank all who replied to my post.
 Based on what I read, I have got two different ways
 of
 calculating that number and they seem to produce the
 same result. 
 
 thank you all (you know who you are)
 
 
 =
 
 
 __
 Do You Yahoo!?
 Check out Yahoo! Shopping and Yahoo! Auctions for
 all of
 your unique holiday gifts! Buy at
 http://shopping.yahoo.com
 or bid at http://auctions.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Gene Gurevich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

RE: Change PCTINCREAE for SYSTEM Tablespace

[Rachel Carmichael]

the default of 50 for pctincrease, like the (before 8.1.6) default
block size for database creation of 2k is legacy.

It harkens back to the olden days when you couldn't have lots of
extents or autoextend.

I'd be much more likely to change the maxextents parameter on the
SYSTEM tables or to put autoextend on the datafiles in the SYSTEM
tablespace.


--- Kimberly Smith [EMAIL PROTECTED] wrote:
 I think even Oracle would disagree with you on that one.  While it
 is unsupported to change anything in the sql.bsq script (except with
 Trusted Oracle where its required to actually get it to create a
 database)
 anything that
 is changeable after the fact is fair game.  As a matter of fact,
 for all those GUI freaks out there;-) its one of the things you
 actually
 get to change when creating the SYSTEM tablespace using dbassist.
 Oracle had to pick a default so they chose 50.  They also chose a
 default for the SGA but up until now it was pretty much a useless
 default.  No where do they say that 50 for pctincrease is recommended
 or that it should stay that way.  Don't forget, this is not
 SQL Server.  We are encouraged by Oracle to set the system up
 for optimal performance.
 
 -Original Message-
 Thomas F
 Sent: Tuesday, December 18, 2001 5:30 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Kimberly,
 
 I would agree with you if an experienced DBA makes the decision to
 change
 the storage parameters, and they absolutely know what the benfits
 would be.
 
 Generally speaking though, I think changing anything in the SYSTEM
 tablespace is bad practice.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Monday, December 17, 2001 8:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Actually, I would not ignore the storage parameters of the SYSTEM
 tablespace.
 There are legit reasons to change the pctincrease to 0.  If you leave
 it at
 50 then SMON (or PMON can't remember at the moment) will try to
 coalesce the
 tablespace every time it wakes up.  Its work it has to do that it
 really
 does
 not need to do.  Better off scheduling to happen at your time
 schedule.
 
 -Original Message-
 Thomas F
 Sent: Monday, December 17, 2001 7:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ken,
 
 Do yourself a favor.  Ignore the SYSTEM tablespace storage params. 
 The ONLY
 thing you should concern yourself in regard with the SYSTEM
 tablespace is if
 the file needs to extend itself because it is too full.  All other
 storage
 parameters are created by Oracle at database create time and should
 not be
 changed.
 
 For other tablespaces, you can change this parameter anytime after
 the
 tablespace has been created.  It will not, however, change existing
 extents,
 but will be used when new extents are allocated.
 
 Hope this helps.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Monday, December 17, 2001 10:16 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Is there any way that I can change the PCTINCREASE for the SYSTEM
 tablespace
 without recreating the DB?  For some reason the person who created
 the DB I
 am working on set PCTINCREASE to 50 (or didn't did not include this
 parameter).I am using this DB for a data conversion so there is
 no
 software connected to it and in turn no users on it.
 
 Thanks,
 Ken Janusz, CPIM
 Database Conversion Lead
 Sufficient Systems, Inc.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ken Janusz
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Kimberly Smith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public 

Deciding what columns to partition on

[Cherie_Machler]

We are doing a redesign of our 200-Gig data warehouse in 9i.

One of the things we're thinking about is changing which
columns we partition on.

Currently, we partition exclusively on date fields.  This has
proven extremely helpful for doing maintenance, purging
old data, archiving, etc.   However, I feel that we're getting
minimal benefit with regard to partition pruning.

Very few of our most-used queries and reports even include
the date field that we are partitioning on.   Instead, we usually
query primarily on account number, rep number, etc. which
is a much more selective column.   With indexes
(and little partition pruning), we are getting
response times that are not fantastic but are within tolerable
range.   However, as the warehouse gets larger, these response
times get less and less acceptable.  Hence this redesign.

Many of our indexes are not even locally partitioned.   I can change
them to be locally partitioned.   The primary key ones can't be locally
partitioned unless they include the columns (date) that the table is
partitioned on.
Although the queries that use these primary key indexes don't even include
date clauses, I could still add the date field to the index so that it can
be locally partitioned.

However, this doesn't seem like a great idea in most cases.

Currently, we seldom seem to be doing any partition pruning in our
explain plans.  We seem to use indexes that don't include date columns
instead.   I'm not sure if
the indexes would work better if they had the date column in them,
especially
if the date column had to be the leading column in the index.   Although
the
partitions would then be pruned, I don't think the query would perform as
well as it would with a global partitioned index (or even a non-partitioned
index) where the acct_no (or whatever highly selective column) is the
leading column in the index.

I've tried to do some testing on this but the results haven't been
conclusive
because I can't test in production and I don't think my test database is
large
enough to give correct test results.

Now to my question:   In this sort of situation, should I settle for being
able
to either use date partitioning for maintenance benefits only, or to
partition
by the columns that I most often query on like acct_no so that I can prune
by partition.   Or is there some magical hybrid situation where I can have
both ease of maintenance and partition pruning for performance?  If yes,
what
sort of magical partitioning strategy do I need to use?

Thanks for any insights you can offer.

Also, I've been reading Scaling Oracle8i but it's more aimed at OLTP.
Can anyone offer a reference for a good data warehousing book, web site,
white papers,
etc. that covers 9i?   Or even 8i for that matter?

Thanks in advance for your feedback.

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

RE: Change PCTINCREAE for SYSTEM Tablespace

[Wong, Bing]

I have to agree with Kimberly.  Knowing your storage parameters is the way
to go.  Don't just settle for defaults.  

Bing


-Original Message-
Sent: Tuesday, December 18, 2001 7:10 AM
To: Multiple recipients of list ORACLE-L


I think even Oracle would disagree with you on that one.  While it
is unsupported to change anything in the sql.bsq script (except with
Trusted Oracle where its required to actually get it to create a database)
anything that
is changeable after the fact is fair game.  As a matter of fact,
for all those GUI freaks out there;-) its one of the things you actually
get to change when creating the SYSTEM tablespace using dbassist.
Oracle had to pick a default so they chose 50.  They also chose a
default for the SGA but up until now it was pretty much a useless
default.  No where do they say that 50 for pctincrease is recommended
or that it should stay that way.  Don't forget, this is not
SQL Server.  We are encouraged by Oracle to set the system up
for optimal performance.

-Original Message-
Thomas F
Sent: Tuesday, December 18, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

hard disk configuration question

[Steve McClure]

We are in the process of buying new hardware, and our original configuration
called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
some sales pressure to change this to 5 36 GB disks.  Now I was planning to
spread our DB out over as many mirrored pairs as possible, or maybe even
including one RAID1+0 array.  The sales folks at Hitachi are telling us that
with their new drive array technology, spreading our Data files over as many
disks as possible is not necessary. I am supposed to talk to one of their
engineers in an hour or so.

I am just wondering if there really is some magic bullet technology I have
missed out on, or is there sales guy full of hooey?


They are also pushing the presence of two internal(not in the drive cabinet)
drives as alleviating any space concerns.  I am wondering what I can use
those drives for.  I don't think I want to software mirror them, but maybe
Sun does this better than I think.  Without some kind of redundancy I am
reluctant to use these disks for any DB purposes.  Any thoughts here are
appreciated as well.

Thanks,

Steve McClure

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

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

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

RE: unused blocks BELOW HWM - Thanks

[DENNIS WILLIAMS]

Naaah, I'm just the proverbial lazy DBA. Gene received many replies,
including it can't be done. Since he happened to point out that two of
them worked and produced the same results (an excellent sanity check), I
thought it would benefit everyone by telling us which ones worked. I realize
that we could have each tried each of the strategies and discovered the two
for ourselves, but my principle is if there is an easier way, why not?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L


Uh, amen. Isn't that the purpose of the list?

Or is there a *third* list, one on topic, a second 
off topic, and a third where all the answers really
are?

-Original Message-
Sent: Tuesday, December 18, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Gene - Now that you've gotten your answer, would you mind to post both of
the methods that you found to work so that the rest of us could learn?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L


Hi.

This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 

thank you all (you know who you are)


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

ACM SIGMOD-papers of interest #2 with demo URLs

[Henry Poras]

Continuing my previous post, here are a few short reviews, some continaining
betas/demo URLs.

PREFER: A System for the Efficient Execution of Multiparametric Ranked
Queries
V. Hristidis, N. Koudas, Y. Papakonstantinou

This paper deals with the best way to return a result set quickly for
weighted queries. The example given describes a house purchase. If the most
important factor in my purchase is price (weighted 50%), but I also care
about location, age of the house, ... a normal SQL query would need to read
the entire table(s), and apply a weighted function to each row before being
able to return a result set. Most of the time the query is just ordered by a
single attribute. This paper claims that using materialized views improve
performance dramatically. A demo and beta(?) version of the application are
available at www.db.ucsd.edu/PREFER 

I had trouble getting the application to work. (I ran it against an 8.1.6
database, not the recommended 8.1.7. I'd be interested if anyone else had
luck with this.)


COSIMA - Your Smart, Speaking E-Salesperson
W. Kiessling,  S. Holland, S. Fischer, T. Ehm

This is a new user interface for e-shopping that advises customers like a
real salesperson (hope they never visited Durgin Park). COSIMA can present
the best match and present it using proper voice output. The software can be
downloaded from www.myCOSIMA.com


Online Query Processing: A Tutorial
P. Haas, J. Hellerstein

The authors discuss the ability to compute online aggregation queries.
Instead of waiting for the calculation to complete, their goal is to provide
incremental results via estimations of the final result, along with the
statistical confidence values. See http://control.cs.berkeley.edu 


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

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

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

RE: unused blocks BELOW HWM - Thanks

[Mohan, Ross]

I agree with larry wall on the laziness of programmers (and DBAs, by
association?) is a virtue..



-Original Message-
Sent: Tuesday, December 18, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L


Naaah, I'm just the proverbial lazy DBA. Gene received many replies,
including it can't be done. Since he happened to point out that two of
them worked and produced the same results (an excellent sanity check), I
thought it would benefit everyone by telling us which ones worked. I realize
that we could have each tried each of the strategies and discovered the two
for ourselves, but my principle is if there is an easier way, why not?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L


Uh, amen. Isn't that the purpose of the list?

Or is there a *third* list, one on topic, a second 
off topic, and a third where all the answers really
are?

-Original Message-
Sent: Tuesday, December 18, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Gene - Now that you've gotten your answer, would you mind to post both of
the methods that you found to work so that the rest of us could learn?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 18, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L


Hi.

This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 

thank you all (you know who you are)


=


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

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

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

RE: hard disk configuration question

[Ken Janusz]

This guy is full of it.  According to Loney  Theriault in Oracle8i DBA
Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
The ideal is 22.   You are much better off with more smaller size drives
than with fewer larger sized drives.

My $0.02 worth,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc.  
Minneapolis, MN


 -Original Message-
Sent:   Tuesday, December 18, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject:hard disk configuration question

We are in the process of buying new hardware, and our original configuration
called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
some sales pressure to change this to 5 36 GB disks.  Now I was planning to
spread our DB out over as many mirrored pairs as possible, or maybe even
including one RAID1+0 array.  The sales folks at Hitachi are telling us that
with their new drive array technology, spreading our Data files over as many
disks as possible is not necessary. I am supposed to talk to one of their
engineers in an hour or so.

I am just wondering if there really is some magic bullet technology I have
missed out on, or is there sales guy full of hooey?


They are also pushing the presence of two internal(not in the drive cabinet)
drives as alleviating any space concerns.  I am wondering what I can use
those drives for.  I don't think I want to software mirror them, but maybe
Sun does this better than I think.  Without some kind of redundancy I am
reluctant to use these disks for any DB purposes.  Any thoughts here are
appreciated as well.

Thanks,

Steve McClure

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

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

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

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

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

Re: Encryption - Question about the key

[Jared . Still]

Welcome to the security conundrum.

When it comes right down to it, there has to be someone
you can trust to have the keys to the kingdom.

Create a separate Oracle account with a single table
with one row in it;  your key.  Create a package containing
a function that can use the key to encrypt/decrypt data.

Grant 'execute ' on the package to the application account
or users that are trusted to use it.

Users can decrypt and encrypt data only by the interface
you provide.  Since they don't have the key, the data
cannot be decrypted outside of the database, and false
encrypted data cannot be inserted into the database
without going through your interface.

This gives you the opportunity to examine any data
inserted into encrypted columns if you like in the event
that you could identify obviously false data.

I'm not a security expert, this is just where I would start
with really sensitive data, and then try to find ways to
break the security.

When it comes down to it though, you still have to know
who you can trust.

Jared






   
  
Jamadagni,
  
Rajendra To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
Rajendra.Jamadagni   cc:  
  
@espn.comSubject: Encryption - Question about 
the key   
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
12/18/01 08:10 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Hi all,

I am investigating using dbms_obfuscation_toolkit in my application. Now, I
need a key to encrypt and decrypt the key. The question is how to protect
the key? The data will be accessed from Forms application, reports, SQR
reports, SQLPLUS scripts.

I need to find a mechanism to
* hide the key from developers (or non authorized persons))
* preferable fetch the key from database
* make this fetching and storing key as non-intrusive as possible.

What are my options? A column on application users table that is not
accessible? Hard coding the key is out of question. Also I need to separate
keys for production and development servers.

As I am clueless, any ideas are most welcome.

Happy Holidays
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

(See attached file: ESPN_Disclaimer.txt)




ESPN_Disclaimer.txt
Description: Binary data

RE: help

[Jared . Still]

Another idiot!

Guess I better stop before the list owner chastises me
and I get banished to OT land.




   
 
Mohan, Ross  
 
MohanR@STARS-   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
SMI.com cc:   
 
Sent by: Subject: RE: help 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/18/01 09:15 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




HELP

-Original Message-
Sent: Monday, December 17, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L


You're kidding, right?


--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
 Does this mean that I am no longer on the mailing list?
 Thanks you for your help
 Mer

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:26
 To: Multiple recipients of list ORACLE-L


 Please remove me from the mailing list,
 Thank you
 Mer

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:11
 To: Multiple recipients of list ORACLE-L



 HELP

 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]

 **

 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]


 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]




__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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




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

Fat City Network 

RE: hard disk configuration question

[Post, Ethan]

Hold on a minute.  I run Oracle on my laptop just fine with a single drive.
It would also scream with an EMC disk array attached to it.  It really
depends on the application(s)/user(s) you are supporting.  If they can save
a bunch of money and the performance impact is minimal there is no trouble
with the cheaper solution.  There are plenty of Oracle installations
supporting small transactional systems.  - Ethan

-Original Message-
Sent: Tuesday, December 18, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


This guy is full of it.  According to Loney  Theriault in Oracle8i DBA
Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
The ideal is 22.   You are much better off with more smaller size drives
than with fewer larger sized drives.

My $0.02 worth,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc.  
Minneapolis, MN

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

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

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

Omniback and RMAN integration

[Adams, Matthew (GEA, 088130)]

Title: Omniback and RMAN integration





I've got Omniback 3.5 and Oracle 8.0.5 with RMAN on
one machine, along with the Omniback/RMAN
integration piece from HP.


I run 


util_oracle8.exe -CONFIG (bunch of parameters)


everything looks fine. No appearant errors.


I immediately try to run


util_oracle8.exe -CHKCONF (sid) 


and get 


Cnnection string:Permission Denied
(svrmgr banner stuff)
MGR-04546: invalid connect string


Where can I find what Omniback is attempting to 
use as the connect string here? Shouldn't
it store the connect string supplied with the 
first command, which did appear to work?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
The thrill is gone - B. B. King
If the thrill is gone, then it's time to take it back. - Meatloaf

Re: Deciding what columns to partition on

[Stephane Faroult]

[EMAIL PROTECTED] wrote:
 
 We are doing a redesign of our 200-Gig data warehouse in 9i.
 
 One of the things we're thinking about is changing which
 columns we partition on.
 

Cherie,

   I am not sure that this really relates to your problem but if I think
that you should consider partitioning more in relation to physical
degradation (containment) and ease of maintenance (especially the
ability to truncate partitions) than in terms of pure performance,
especially on a 'clean' database. I have never found the argument 'you
scan a single partition' very compelling when your data is properly
indexed.
   I have carried out experiments recently and I was surprised to
discover that the best results I had were gained by partitioning on a
column which was updated (allowing for row migration) and not on the one
I thought was the obvious candidate. Update was unsurprisingly twice as
costly as in the other cases, but given the special mix of queries is
still was the best overall, especially after a lot of inserts and
deletes. Experiment carefully.
-- 
Regards,

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

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

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

RE: help

[Baker, Barbara]

Naw.
Just Ross.
and we'd all agree he needs help.


 --
 From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Tuesday, December 18, 2001 12:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: help
 
 
 
 Another idiot!
 
 Guess I better stop before the list owner chastises me
 and I get banished to OT land.
 
 
 
 
  
 
 Mohan, Ross
 
 MohanR@STARS-   To: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]
 SMI.com cc:
 
 Sent by: Subject: RE: help
 
 [EMAIL PROTECTED]
 
 om
 
  
 
  
 
 12/18/01 09:15
 
 AM
 
 Please respond
 
 to ORACLE-L
 
  
 
  
 
 
 
 
 
 HELP
 
 -Original Message-
 Sent: Monday, December 17, 2001 5:50 PM
 To: Multiple recipients of list ORACLE-L
 
 
 You're kidding, right?
 
 
 --- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
 [EMAIL PROTECTED] wrote:
  Does this mean that I am no longer on the mailing list?
  Thanks you for your help
  Mer
 
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:26
  To: Multiple recipients of list ORACLE-L
 
 
  Please remove me from the mailing list,
  Thank you
  Mer
 
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 18 December 2001 10:11
  To: Multiple recipients of list ORACLE-L
 
 
 
  HELP
 
  **
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
 
  **
 
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
 
 
  **
  [This message and any attachment is confidential between the sender
  and the
  person it is intended for. If we have sent you this message by
  mistake,
  please let us know by return email, and erase all copies of this
  message and
  its attachments. Thank you.]
 
 
 
 
 __
 Do You Yahoo!?
 Check out Yahoo! Shopping and Yahoo! Auctions for all of
 your unique holiday gifts! Buy at http://shopping.yahoo.com
 or bid at http://auctions.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Paul Baumgartel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from 

Re: Slightly OT : RDA from Oracle

[A. Bardeen]

OK, John, you've let the cat out of the bag so I might
as well stop trying to remain incognito ;)

Yes, indeed I did package RDA although you can tell
that my Unix skills aren't that great or I would have
chosen a less revealing directory structure.

RDA is one of the projects I'll be managing in my new
role.  I hope to keep what's left of my brain and
avoid becoming a PHM, but I'm sure I can count on
y'all to point out any signs that I'm becoming a
damager ;)

To address some of the issues John brought up about
RDA...

 (one little
 script that sets up and one *large* script that
 actually does the stuff)
  That's the current incarnation, but it will be
changing in the next few months.  We intend to make it
more modular so that other areas in Oracle Support can
add plug-ins to capture information specific to their
needs.  We also intend to have the setup portion allow
users to skip certain areas of the report if they're
not wanted or needed.

 Anyone been asked to run this yet?
  Anyone logging an iTar related to the Oracle Server
product should automatically be requested to provide
RDA output as part of the iTar logging process.  You
may also be requested to provide it by the analyst
assigned to your iTar.  You are, of course, welcome to
run RDA for your own benefit as well.

Obviously it's not relevant for all types of tars
(e.g. RTFM tars), but it does provide a nice overview
of the server environment for many other types of
tars.

 Will Oracle Support listen to us if we request 
 enhancements?
  Absolutely!!  Just please don't use an iTar for your
forum.  Instead send feedback (positive and negative)
to  [EMAIL PROTECTED]  

Currently I maintain that email account so I'll be the
one responding.  Try not to be too brutal ;)

I will warn you now that I won't be able to please
everyone so I'm not stupid enough to try.  I have
constraints on what I can do with RDA and one of the
major ones is that I can't require any third party
products to be used so, sorry Jared, but there's no
Perl in RDA's future.

For those of you VMS fans, you'll be happy to know
that a version of RDA for VMS is in the works and we
hope to have that released by the end of January 2002.

RDA is available only via MetaLink:

Note: 139597.1 Remote Diagnostic Agent (RDA) for
Unix
Note: 153091.1 Remote Diagnostic Agent (RDA) for
Windows

For those of you who may have used RDA in the past,
version 2.71 was just released for Unix last week.  We
will have new versions for both Unix and NT/Win2K at
the end of the month.

There will probably be new versions every month for
the next few months, so be sure to check the above
notes for the most recent version.

While I have your attention, feel free to send
feedback regarding the ORA-600 Lookup tool to me as
well (use [EMAIL PROTECTED]).

Note: 153788.1 ORA-600 Lookup

Thanks,

-- Anita
 
--- John Kanagaraj [EMAIL PROTECTED] wrote:
 Hi all,
 
 I was looking at the recently released RDA (Remote
 Diagnostic Agent) from
 Oracle Support. Basically, this consists of a couple
 of scripts (one little
 script that sets up and one *large* script that
 actually does the stuff)
 that probes a lot of details (both OS and database)
 and writes this out as
 both Text and Html files. These can then be uploaded
 to Oracle Support for
 analysis in support of an iTAR.
 
  tar tvf rda.tar
 -rw-r--r-- abardeen/dba 94 2001-08-22 02:48
 false.gif
 -rw-r--r-- abardeen/dba   5841 2001-12-11 13:29
 instructions.html
 -rwxr--r-- abardeen/dba 179187 2001-12-10 06:49
 rda.sh--- Big script
 -rwxr-xr-- abardeen/dba  11407 2001-11-13 09:58
 setup.sh  --- Small
 script
 -rw-r--r-- abardeen/dba   2575 2001-12-07 09:27
 setup.txt.orig
 -rw-r--r-- abardeen/dba 91 2001-08-22 02:48
 true.gif
 
 If you haven't caught it by now, it seems that our
 very own Anita Bardeen
 packaged it as can be seen from the 'tar' listing
 above. Originally, this
 seems to have come out of that very excellent group
 - the Centre Of
 Excellence... It is even intelligent enough to
 recognize APPS Databases,
 although it does seem to lack features to skip Web
 based probes during
 setup.
 
 Now to the Questions: Anyone been asked to run this
 yet? Any comments from
 the Gurus? Will Oracle Support listen to us if we
 request enhancements?
 
 Thanks,
 John Kanagaraj
 Oracle Applications DBA
 DBSoft Inc
 (W): 408-970-7002
 
 Wanna know the reason for the season? Click on
 'http://www.needhim.org'
 
 ** The opinions and statements above are entirely my
 own and not
 those of my employer or clients **


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public 

Re: Change PCTINCREAE for SYSTEM Tablespace

[Connor McDonald]

http://www.ixora.com.au/tips/creation/bsq.htm

suggests that a non-zero pctincrease may be viable,
with the reasoning being based on deferred rollback
segments.

Rumour has it, Oracle 9i.2 will have a lmt system
tablespace which will make the argument moot.

hth
connor

 --- Jared Still [EMAIL PROTECTED] wrote:  
 The Oracle8i Admin Guide, Chapter 19, General
 Management of Schema Objects:
 
 Give guidelines for setting storage parameters for
 data dictionary tables.
 
 Setting PCINCREASE to 50 is an artifact from Oracle
 6 and early releases of 7
 which had a rather limited number of extents.
 
 Jared
 
 
 On Tuesday 18 December 2001 05:30, Mercadante,
 Thomas F wrote:
  Kimberly,
 
  I would agree with you if an experienced DBA makes
 the decision to change
  the storage parameters, and they absolutely know
 what the benfits would be.
 
  Generally speaking though, I think changing
 anything in the SYSTEM
  tablespace is bad practice.
 
  Tom Mercadante
  Oracle Certified Professional
 
 
  -Original Message-
  Sent: Monday, December 17, 2001 8:45 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Actually, I would not ignore the storage
 parameters of the SYSTEM
  tablespace.
  There are legit reasons to change the pctincrease
 to 0.  If you leave it at
  50 then SMON (or PMON can't remember at the
 moment) will try to coalesce
  the tablespace every time it wakes up.  Its work
 it has to do that it
  really does
  not need to do.  Better off scheduling to happen
 at your time schedule.
 
  -Original Message-
  Thomas F
  Sent: Monday, December 17, 2001 7:45 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Ken,
 
  Do yourself a favor.  Ignore the SYSTEM tablespace
 storage params.  The
  ONLY thing you should concern yourself in regard
 with the SYSTEM tablespace
  is if the file needs to extend itself because it
 is too full.  All other
  storage parameters are created by Oracle at
 database create time and should
  not be changed.
 
  For other tablespaces, you can change this
 parameter anytime after the
  tablespace has been created.  It will not,
 however, change existing
  extents, but will be used when new extents are
 allocated.
 
  Hope this helps.
 
  Tom Mercadante
  Oracle Certified Professional
 
 
  -Original Message-
  Sent: Monday, December 17, 2001 10:16 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Is there any way that I can change the PCTINCREASE
 for the SYSTEM
  tablespace without recreating the DB?  For some
 reason the person who
  created the DB I am working on set PCTINCREASE to
 50 (or didn't did not
  include this parameter).I am using this DB for
 a data conversion so
  there is no software connected to it and in turn
 no users on it.
 
  Thanks,
  Ken Janusz, CPIM
  Database Conversion Lead
  Sufficient Systems, Inc.
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Ken Janusz
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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


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


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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some 

Re: hard disk configuration question

[lembark]

-- Steve McClure [EMAIL PROTECTED] on 12/18/01 11:00:22 -0800

 We are in the process of buying new hardware, and our original configuration
 called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
 some sales pressure to change this to 5 36 GB disks.  Now I was planning to
 spread our DB out over as many mirrored pairs as possible, or maybe even
 including one RAID1+0 array.  The sales folks at Hitachi are telling us that
 with their new drive array technology, spreading our Data files over as many
 disks as possible is not necessary. I am supposed to talk to one of their
 engineers in an hour or so.
 
 I am just wondering if there really is some magic bullet technology I have
 missed out on, or is there sales guy full of hooey?
 
 
 They are also pushing the presence of two internal(not in the drive cabinet)
 drives as alleviating any space concerns.  I am wondering what I can use
 those drives for.  I don't think I want to software mirror them, but maybe
 Sun does this better than I think.  Without some kind of redundancy I am
 reluctant to use these disks for any DB purposes.  Any thoughts here are
 appreciated as well.

You are almost always better off with more spindles to 
spread the load over. With fewer disks you get the same
total storage but less flexability in how the I/O is 
partitioned between devices. Since Oracle is such an I/O
hog the added flexability can be a real lifesaver.

Hitachi's claim that there isn't any benefit to spreading
out the I/O may be valid with huge amounts of cache. The
technology for disk I/O manglement is always improving,
so is the quantity of... er... hooey available from 
sales reps; the answer to your question is probably both :-)

Personally I'd go with more disks using RAID5 w/ a stripe
size equal to the O/S page (e.g., 4x1K or 8x1b for a 4KB
file i/o page or 8x1k for an 8K system page). This avoids 
extra overhead from the RAID5 parity writes (you have to 
hit all the disks every time anyway) and gives you back 
a lot of extra storage over mirroring. Using the RAID5
w/ a reasonable stripe also allows you to spread the I/O
over multiple RAID's to balance the load -- sine the RAID
set is the PV managed by your LVM system. The extra disks
come in handy at this point because you can create more 
RAID sets for balancing the load.

In theory if you have enough cache none of the disk parameters
matter at all. Then it depends largely on your budget for 
cache and how well the current Hitachi controllers manage it.
If you don't have infinte faith in their cache management 
system then more disks is the better bet.



--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: hard disk configuration question

[Jared . Still]

Steve,

You'll have to do the math, and that's still not a complete
answer.

By 'math' I mean figure out the maximum throughput of their
configuration version the one you really want.

Also keep in mind that 5 36 gig disks means RAID 5.  Being
somewhat familiar with that app, I feel fairly confidant
in saying that's probably not a good choice, at least not
on one volume like they are proposing.

On several volumes, you could get away with it, but one
is pretty dicey.  That app is pretty write intenisive and
there's a 400% or so write penalty on RAID 5.

The sales critter will of course tell you that the cache
will take care of it.  Been through that with IBM on
the Shark:  after doing the math it became clear that
the only possible way they could meet their throughput
claim was with 100% cache hit ratio.

Just my $0.02 worth.

By the way, why not stick with Clariion?  It will work
with other Vendors besides DG.

Jared



 -Original Message-
Sent:   Tuesday, December 18, 2001 1:00 PM
To:Multiple recipients of list ORACLE-L

We are in the process of buying new hardware, and our original
configuration
called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
some sales pressure to change this to 5 36 GB disks.  Now I was planning to
spread our DB out over as many mirrored pairs as possible, or maybe even
including one RAID1+0 array.  The sales folks at Hitachi are telling us
that
with their new drive array technology, spreading our Data files over as
many
disks as possible is not necessary. I am supposed to talk to one of their
engineers in an hour or so.

I am just wondering if there really is some magic bullet technology I have
missed out on, or is there sales guy full of hooey?


They are also pushing the presence of two internal(not in the drive
cabinet)
drives as alleviating any space concerns.  I am wondering what I can use
those drives for.  I don't think I want to software mirror them, but maybe
Sun does this better than I think.  Without some kind of redundancy I am
reluctant to use these disks for any DB purposes.  Any thoughts here are
appreciated as well.

Thanks,

Steve McClure

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


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

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

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

Re: The code doesn't work in the package

[Csillag Zsolt]

Hi,

Thank you for your help. Now it works.

At 11:00 2001.12.16. -0800, you wrote:
You need to read on up on permissions.

privileges that you get thru a role does not work for stored objects, like 
proces/pkgs.

joe




Csillag Zsolt wrote:

Hi,
The following code work as you can see below, but if I put this
code in a package ( a procedure in a package) then I got
ORA-01031 insufficient privileges error.
This is absurd for me because it's the same user (an administrator) that
owns the package, tablespace, table and everything.
  From a pl/sql block it works perfectly with the same user.

*Declare
*  Command *VarChar2*(*1000*) ;
*Begin

*Command := *'create table PROBA1
(
   PROBA1_1 NUMBER,
   PROBA1_2 VARCHAR2(50)
)
tablespace XXX
   pctfree 10
   pctused 40
   initrans 1
   maxtrans 255
   storage
   (
 initial 64K
 minextents 1
 maxextents unlimited
   )'* ;


  *Execute* *Immediate* Command ;

*end* ;


--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

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

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

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

SQL Loader Load Problem

[Ken Janusz]

I have a data file of 11 fields to load into a table of 8 columns.  I only
have to load 3 of the input fields.  How do I handle the extra input fields?
I cannot use the DB table column for filler more than once.  Can I just
ignore the input fields I don't have to load?  I am using trailing nulls
and options direct=true.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

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

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

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

Re: hard disk configuration question

[Ray Stell]

I have sun sales giving me the same line.  I challenged them to 
prove it yesterday.  I hope to have some data on this soon and
will follow up.

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




On Tue, Dec 18, 2001 at 11:30:43AM -0800, Ken Janusz wrote:
 This guy is full of it.  According to Loney  Theriault in Oracle8i DBA
 Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
 The ideal is 22.   You are much better off with more smaller size drives
 than with fewer larger sized drives.
 
 My $0.02 worth,
 
 Ken Janusz, CPIM 
 Database Conversion 
 Lead Sufficient System, Inc.  
 Minneapolis, MN
 
 
  -Original Message-
 Sent: Tuesday, December 18, 2001 1:00 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  hard disk configuration question
 
 We are in the process of buying new hardware, and our original configuration
 called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
 some sales pressure to change this to 5 36 GB disks.  Now I was planning to
 spread our DB out over as many mirrored pairs as possible, or maybe even
 including one RAID1+0 array.  The sales folks at Hitachi are telling us that
 with their new drive array technology, spreading our Data files over as many
 disks as possible is not necessary. I am supposed to talk to one of their
 engineers in an hour or so.
 
 I am just wondering if there really is some magic bullet technology I have
 missed out on, or is there sales guy full of hooey?
 
 
 They are also pushing the presence of two internal(not in the drive cabinet)
 drives as alleviating any space concerns.  I am wondering what I can use
 those drives for.  I don't think I want to software mirror them, but maybe
 Sun does this better than I think.  Without some kind of redundancy I am
 reluctant to use these disks for any DB purposes.  Any thoughts here are
 appreciated as well.
 
 Thanks,
 
 Steve McClure
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steve McClure
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ken Janusz
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

RE: conversion from oracle to sql server

[Kevin Fries]

SQL Server comes with DTS (Data Transformation Service). See www.swynk.com
for more info or look at SQL Server docs if you have them.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seema Singh
 Sent: Tuesday, December 18, 2001 2:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: conversion from oracle to sql server


 Hi
 Any one converted oracle database to sql server database?If yes
 let me know
 how please?Do you used any third party tools?
 Thanks
 -seema



 _
 Join the world’s largest e-mail service with MSN Hotmail.
 http://www.hotmail.com

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

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


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

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

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

SQL Loader Load Problem

[Ken Janusz]

I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

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

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

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

RE: Encryption - Question about the key

[Jamadagni, Rajendra]

Believe it or not Jared, one of your script gave me following idea (the
wrapper sql for decrypt/encrypt on your site).

1. I have a system users table, I can add a column to store user's key in a
column that only that user has access to.
2. Create a DBA owned package to handle encryption/decryption.
3. The key will be picked up in this package and used (maybe I'll use user
key is used to derive the actual key).
4. The package will be deployed as 'wrapped' in production, so by looking at
dba_source you won't find much.

I'll have to test this though but I think this will make it a bit more
secure.

The question is Can I trust myself? The answer is 'Yes.

Can someone see any drawbacks?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!



*2

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

Revert from 8.1.6 to 8.0.5

[Ed]

Looks like we have to revert an 8.1.6 database that was upgraded over the
weekend back to 8.0.5, but we need to export/import so we don't lose data
from the last 2 days.  Anything I need to know?  The plan is to export using
the 8.0.5 export utility before importing back into 8.0.5.  Does this make
sense?

Thanks,

Ed


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

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

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

conversion from oracle to sql server

[Seema Singh]

Hi
Any one converted oracle database to sql server database?If yes let me know 
how please?Do you used any third party tools?
Thanks
-seema



_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

Re: found dead multi-threaded server

[Brian Haas]

I've gotten these errors (most notably 16365) on numerous occasions and I'm 
running 8.1.7.0 I've also  gotten this error on 8.1.6 with and without the 
patchset. The main cause of this error is a half-duplex protocol error and,
according to Oracle, tends to be application related.See notes 
155513.1, 300867.999 on metalink for more information. Since the upgrade has not 
fixed this for us, my guess is that it is an application problem (perl in our case). 
We 
only occasionally get them, but if you get them all the time, you may want to 
check your app.

HTH,

-Brian



On Mon, 17 Dec 2001, prashast gujrati wrote:
Hi Gurus,

We have recently upgraded our DBs from old 7.3.2 version to 8.1.6.0
and have moved from dedicated to MTS.

since then we are getting ORA-600s in alert.log of all the DBs with
various first arguments some of which I'll list here : 15429, 15439,
16365, 16375, 17034, 17182, 17280, 17281, 17285, kohlnm120, kohcpi298
etc. These are the most frequent ones. Though the DBs are up and running
these errors are being consistently logged in alert.

None of the instances have crashed ever since we have upgraded.

I've opened up a TAR on metalink and have been told that 8.1.6.3 patchset
is to be applied.

Now what I want to know is if others have also encountered these errors
and if applying this patchset has solved the problems. If not then what
are the other things to be done (I mean does moving to 8.1.7.3 will
necessarily solve the problem ? We are reluctant as this will mean another
period of downtime for the users...)

Also what is the source of these errors ? Will moving into dedicated arch
solve our problems ?

(I somehow tend to trust this list more than Metalink !!)

TIA,


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

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

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

RE: help

[Mohan, Ross]

LoL!  Jared, you're OUT OF CONTROL today, mate!

G

-Original Message-
Sent: Tuesday, December 18, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L




Another idiot!

Guess I better stop before the list owner chastises me
and I get banished to OT land.




 

Mohan, Ross

MohanR@STARS-   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
SMI.com cc:

Sent by: Subject: RE: help

[EMAIL PROTECTED]

om

 

 

12/18/01 09:15

AM

Please respond

to ORACLE-L

 

 





HELP

-Original Message-
Sent: Monday, December 17, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L


You're kidding, right?


--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
 Does this mean that I am no longer on the mailing list?
 Thanks you for your help
 Mer

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:26
 To: Multiple recipients of list ORACLE-L


 Please remove me from the mailing list,
 Thank you
 Mer

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 18 December 2001 10:11
 To: Multiple recipients of list ORACLE-L



 HELP

 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]

 **

 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]


 **
 [This message and any attachment is confidential between the sender
 and the
 person it is intended for. If we have sent you this message by
 mistake,
 please let us know by return email, and erase all copies of this
 message and
 its attachments. Thank you.]




__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

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

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




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

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

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

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

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

RE: return single record

[Jamadagni, Rajendra]

I think using 'the' on the collection would be my second choice after ref
cursor. Why does your client doesn't want to use ref cursor? I can't think
of anything else, as returning arbitrary data structure would be a problem
in select.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, December 18, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Hi  Raj !
 Actually I had similar problems some days back where i was supposed to
treturn recordset(more than one) . At that time i created object and
collection of object and then using cast operator and the operator i was
able to return recodset from function . I could have used that  function in
sql statement also; Actually i am Delphi programmar and our client does not
want to use like that. Moreover they don't want to use ref cursor or any PL
sql table i hope  u will sugeest some thing on it. thanx in advance



*1

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: Slightly OT : RDA from Oracle

[Jared . Still]

constraints on what I can do with RDA and one of the
major ones is that I can't require any third party
products to be used so, sorry Jared, but there's no
Perl in RDA's future.

And I was just getting ready to ask.  :)

Ya know, if you used Perl, you could even
make this work on Windoze.


Jared





   
 
A. Bardeen   
 
abardeen1@yah   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
oo.com  cc:   
 
Sent by: Subject: Re: Slightly OT : RDA from 
Oracle 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/18/01 01:45 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




OK, John, you've let the cat out of the bag so I might
as well stop trying to remain incognito ;)

Yes, indeed I did package RDA although you can tell
that my Unix skills aren't that great or I would have
chosen a less revealing directory structure.

RDA is one of the projects I'll be managing in my new
role.  I hope to keep what's left of my brain and
avoid becoming a PHM, but I'm sure I can count on
y'all to point out any signs that I'm becoming a
damager ;)

To address some of the issues John brought up about
RDA...

 (one little
 script that sets up and one *large* script that
 actually does the stuff)
  That's the current incarnation, but it will be
changing in the next few months.  We intend to make it
more modular so that other areas in Oracle Support can
add plug-ins to capture information specific to their
needs.  We also intend to have the setup portion allow
users to skip certain areas of the report if they're
not wanted or needed.

 Anyone been asked to run this yet?
  Anyone logging an iTar related to the Oracle Server
product should automatically be requested to provide
RDA output as part of the iTar logging process.  You
may also be requested to provide it by the analyst
assigned to your iTar.  You are, of course, welcome to
run RDA for your own benefit as well.

Obviously it's not relevant for all types of tars
(e.g. RTFM tars), but it does provide a nice overview
of the server environment for many other types of
tars.

 Will Oracle Support listen to us if we request
 enhancements?
  Absolutely!!  Just please don't use an iTar for your
forum.  Instead send feedback (positive and negative)
to  [EMAIL PROTECTED]

Currently I maintain that email account so I'll be the
one responding.  Try not to be too brutal ;)

I will warn you now that I won't be able to please
everyone so I'm not stupid enough to try.  I have
constraints on what I can do with RDA and one of the
major ones is that I can't require any third party
products to be used so, sorry Jared, but there's no
Perl in RDA's future.

For those of you VMS fans, you'll be happy to know
that a version of RDA for VMS is in the works and we
hope to have that released by the end of January 2002.

RDA is available only via MetaLink:

Note: 139597.1 Remote Diagnostic Agent (RDA) for
Unix
Note: 153091.1 Remote Diagnostic Agent (RDA) for
Windows

For those of you who may have used RDA in the past,
version 2.71 was just released for Unix last week.  We
will have new versions for both Unix and NT/Win2K at
the end of the month.

There will probably be new versions every month for
the next few months, so be sure to check the above
notes for the most recent version.

While I have your attention, feel free to send
feedback regarding the ORA-600 Lookup tool to me as
well (use [EMAIL PROTECTED]).

Note: 153788.1 ORA-600 Lookup

Thanks,

-- Anita

--- John Kanagaraj [EMAIL PROTECTED] wrote:
 Hi all,

 I was looking at the 

RE: Encryption - Question about the key

[Craig Munday]

Title: RE: Encryption - Question about the key





Jared + Ragendra,


One option that you might have is to use a Host Security Module HSM such as those from Thales or Eracomm (cheaper PC based card ~$2000AUD). Essentially this is a piece of cryptographic hardware connected to your host that performs cryptographic functions and key management.

In terms of key management (which is what you were asking about), the keys reside within the memory of the HSM and can be loaded in component form. Meaning that a key is split between a number of people so no one person knows all of the key. The memory is typically non-volatile so you don't have to load the keys each time you re-boot. And most HSMs have a motion detector that will clear the keys from memory if the unit is moved.

When performing encryption functions the keys never leave the HSM. An application calls a crypto function with the data that it wants to encrypt (for example) and the NAME of the key to use. The HSM performs the encryption and returns the encrypted data. Thus, the keys are never stored in the clear within the application's memory.

Now, I'm not too sure how you will get this integrated with Oracle. Typically it is the application that interfaces with the HSM. Who knows you might find a product - I'd be interested in hearing about it if you do.

Cheers,
Craig.
 




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 December 2001 6:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Encryption - Question about the key




Welcome to the security conundrum.


When it comes right down to it, there has to be someone
you can trust to have the keys to the kingdom.


Create a separate Oracle account with a single table
with one row in it; your key. Create a package containing
a function that can use the key to encrypt/decrypt data.


Grant 'execute ' on the package to the application account
or users that are trusted to use it.


Users can decrypt and encrypt data only by the interface
you provide. Since they don't have the key, the data
cannot be decrypted outside of the database, and false
encrypted data cannot be inserted into the database
without going through your interface.


This gives you the opportunity to examine any data
inserted into encrypted columns if you like in the event
that you could identify obviously false data.


I'm not a security expert, this is just where I would start
with really sensitive data, and then try to find ways to
break the security.


When it comes down to it though, you still have to know
who you can trust.


Jared

Re: Revert from 8.1.6 to 8.0.5

[Joe Testa]

break out the migration guide, there is(if i remember correctly, since i 
  pretty much play with 9i anymore), a down grade script.

check out the migration guide for details.

joe


Ed wrote:

 Looks like we have to revert an 8.1.6 database that was upgraded over the
 weekend back to 8.0.5, but we need to export/import so we don't lose data
 from the last 2 days.  Anything I need to know?  The plan is to export using
 the 8.0.5 export utility before importing back into 8.0.5.  Does this make
 sense?
 
 Thanks,
 
 Ed
 
 
 


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

RE: Encryption - Question about the key

[Jared . Still]

 Can someone see any drawbacks?

What if a satellite falls out of the
sky and hits you on the head?

Or your significant other can't stand
your face for one more day and whacks
you with a frying pan?
( narcissists need not worry )

The point being of course, who will know
how to access the data if you don't show
up for work?

At our site the SA's have a master password
database for that kind of stuff.

Many folks put this kind of thing on a
piece of paper and seal it in an envelope,
and hand it to damagement for safe keeping.

Jared




   
  
Jamadagni,
  
Rajendra To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
Rajendra.Jamadagni   cc:  
  
@espn.comSubject: RE: Encryption - Question 
about the key   
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
12/18/01 01:55 PM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Believe it or not Jared, one of your script gave me following idea (the
wrapper sql for decrypt/encrypt on your site).

1. I have a system users table, I can add a column to store user's key in a
column that only that user has access to.
2. Create a DBA owned package to handle encryption/decryption.
3. The key will be picked up in this package and used (maybe I'll use user
key is used to derive the actual key).
4. The package will be deployed as 'wrapped' in production, so by looking
at
dba_source you won't find much.

I'll have to test this though but I think this will make it a bit more
secure.

The question is Can I trust myself? The answer is 'Yes.

Can someone see any drawbacks?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
(See attached file: ESPN_Disclaimer.txt)




ESPN_Disclaimer.txt
Description: Binary data

Re: hard disk configuration question

[Rodd Holman]

WRT the 2 internals,
  We mirror those and load only the OS and OS patches.  All other stuff
goes on the arrays.  That allows us to swap machines if necessary by
just exporting and importing the RAID volumes.

Rodd Holman
On Tue, 2001-12-18 at 14:25, Ray Stell wrote:
I have sun sales giving me the same line.  I challenged them to 
prove it yesterday.  I hope to have some data on this soon and
will follow up.

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




On Tue, Dec 18, 2001 at 11:30:43AM -0800, Ken Janusz wrote:
 This guy is full of it.  According to Loney  Theriault in Oracle8i DBA
 Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
 The ideal is 22.   You are much better off with more smaller size drives
 than with fewer larger sized drives.
 
 My $0.02 worth,
 
 Ken Janusz, CPIM 
 Database Conversion 
 Lead Sufficient System, Inc.  
 Minneapolis, MN
 
 
  -Original Message-
 Sent: Tuesday, December 18, 2001 1:00 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  hard disk configuration question
 
 We are in the process of buying new hardware, and our original configuration
 called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
 some sales pressure to change this to 5 36 GB disks.  Now I was planning to
 spread our DB out over as many mirrored pairs as possible, or maybe even
 including one RAID1+0 array.  The sales folks at Hitachi are telling us that
 with their new drive array technology, spreading our Data files over as many
 disks as possible is not necessary. I am supposed to talk to one of their
 engineers in an hour or so.
 
 I am just wondering if there really is some magic bullet technology I have
 missed out on, or is there sales guy full of hooey?
 
 
 They are also pushing the presence of two internal(not in the drive cabinet)
 drives as alleviating any space concerns.  I am wondering what I can use
 those drives for.  I don't think I want to software mirror them, but maybe
 Sun does this better than I think.  Without some kind of redundancy I am
 reluctant to use these disks for any DB purposes.  Any thoughts here are
 appreciated as well.
 
 Thanks,
 
 Steve McClure
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steve McClure
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ken Janusz
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

Re: hard disk configuration question

[Paul Baumgartel]

Although I agree with these recommendations, I don't agree that Oracle
is such an I/O hog.  Oracle was designed to perform I/O efficiently
and generally does so.  Poorly-written SQL can create an I/O
bottleneck, but it's not the fault of the RDBMS.


--- [EMAIL PROTECTED] wrote:
 You are almost always better off with more spindles to 
 spread the load over. With fewer disks you get the same
 total storage but less flexability in how the I/O is 
 partitioned between devices. Since Oracle is such an I/O
 hog the added flexability can be a real lifesaver.
 
 Hitachi's claim that there isn't any benefit to spreading
 out the I/O may be valid with huge amounts of cache. The
 technology for disk I/O manglement is always improving,
 so is the quantity of... er... hooey available from 
 sales reps; the answer to your question is probably both :-)
 
 Personally I'd go with more disks using RAID5 w/ a stripe
 size equal to the O/S page (e.g., 4x1K or 8x1b for a 4KB
 file i/o page or 8x1k for an 8K system page). This avoids 
 extra overhead from the RAID5 parity writes (you have to 
 hit all the disks every time anyway) and gives you back 
 a lot of extra storage over mirroring. Using the RAID5
 w/ a reasonable stripe also allows you to spread the I/O
 over multiple RAID's to balance the load -- sine the RAID
 set is the PV managed by your LVM system. The extra disks
 come in handy at this point because you can create more 
 RAID sets for balancing the load.
 
 In theory if you have enough cache none of the disk parameters
 matter at all. Then it depends largely on your budget for 
 cache and how well the current Hitachi controllers manage it.
 If you don't have infinte faith in their cache management 
 system then more disks is the better bet.
 
 
 
 --
 Steven Lembark  2930 W. Palmer
 Workhorse Computing  Chicago, IL 60647
+1 800 762 1582


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

RE: Encryption - Question about the key

[Austin, Steve S]

What we do is have the application manage the encryption keys.  The DBA
therefore only has access to the encrypted data.  Being the DBA in this
equation, I am exonerated from having easy access to the keys, and therefore
exonerated when it comes time to hunt down perpetrators (well, nearly!) :).
I further suggested that they split the key into parts and allow the DBA,
root, and the application owner to put in parts to derive the actual key
that is not stored anywhere, but exists only in the memory of the app.  This
did not go over well.  :)  We're also looking at procedures to change the
keys, since any set of encrypted data is a target, and if you change the
keys, it's a moving target.

hope this is interesting if not amusing.
sa

-Original Message-
Sent: Tuesday, December 18, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


Believe it or not Jared, one of your script gave me following idea (the
wrapper sql for decrypt/encrypt on your site).

1. I have a system users table, I can add a column to store user's key in a
column that only that user has access to.
2. Create a DBA owned package to handle encryption/decryption.
3. The key will be picked up in this package and used (maybe I'll use user
key is used to derive the actual key).
4. The package will be deployed as 'wrapped' in production, so by looking at
dba_source you won't find much.

I'll have to test this though but I think this will make it a bit more
secure.

The question is Can I trust myself? The answer is 'Yes.

Can someone see any drawbacks?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: [EMAIL PROTECTED]

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

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

Help

[Hamid Alavi]

Any idea what this means ?


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)


Begin
*
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3


PasswordNotification12172001.txt: No such file or directory
PasswordNotification12172001.err: No such file or directory




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

RE: Help

[Kimberly Smith]

Your SGA has become fragmented.  You would not per chance be running
8.1.7 would you?  If so I would go and do some searching on Metalink.
I see an upgrade in your future.  You could try flushing the SGA but
if its what I think it is it won't help.  A restart will for a while.


-Original Message-
Sent: Tuesday, December 18, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Any idea what this means ?


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)


Begin
*
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3


PasswordNotification12172001.txt: No such file or directory
PasswordNotification12172001.err: No such file or directory




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: Deciding what columns to partition on

[Jared Still]

On Tuesday 18 December 2001 12:55, Stephane Faroult wrote:
  I have never found the argument 'you
 scan a single partition' very compelling when your data is properly
 indexed.

Stephane,

This is assuming that you are using global indexes on your
partitioned tables.  If using local indexes and searching by
something other than the partition key, all indexes will
be scanned if used at all.  

Cherie, do your users generally limit their queries by
a date, even if they are searching on other keys?

In a DW I would expect them to.  Do all of their queries
really need to scan entire tables?

I'm just giving you things to consider rather than actual
suggestions, cuz I know nothing about your system.

Why not build some prototype partitions and pull some
typical queries from the SGA and compare them against
different configurations?

Jared

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

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

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

Re: hard disk configuration question

[Jared Still]

I was the DBA for 3 years for the app Steve is
working on.  It won't be happy on one RAID4
volume with 5 disks.

Jared

On Tuesday 18 December 2001 12:40, Post, Ethan wrote:
 Hold on a minute.  I run Oracle on my laptop just fine with a single drive.
 It would also scream with an EMC disk array attached to it.  It really
 depends on the application(s)/user(s) you are supporting.  If they can save
 a bunch of money and the performance impact is minimal there is no trouble
 with the cheaper solution.  There are plenty of Oracle installations
 supporting small transactional systems.  - Ethan

 -Original Message-
 Sent: Tuesday, December 18, 2001 1:31 PM
 To: Multiple recipients of list ORACLE-L


 This guy is full of it.  According to Loney  Theriault in Oracle8i DBA
 Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
 The ideal is 22.   You are much better off with more smaller size drives
 than with fewer larger sized drives.

 My $0.02 worth,

 Ken Janusz, CPIM
 Database Conversion
 Lead Sufficient System, Inc.
 Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: Encryption - Question about the key

[Jared Still]

This sounds great until something doesn't work properly.

Bet it's difficult to toubleshoot.

Has this setup given you any problems in that regard?

Jared

On Tuesday 18 December 2001 16:25, Austin, Steve S wrote:
 What we do is have the application manage the encryption keys.  The DBA
 therefore only has access to the encrypted data.  Being the DBA in this
 equation, I am exonerated from having easy access to the keys, and
 therefore exonerated when it comes time to hunt down perpetrators (well,
 nearly!) :). I further suggested that they split the key into parts and
 allow the DBA, root, and the application owner to put in parts to derive
 the actual key that is not stored anywhere, but exists only in the memory
 of the app.  This did not go over well.  :)  We're also looking at
 procedures to change the keys, since any set of encrypted data is a target,
 and if you change the keys, it's a moving target.

 hope this is interesting if not amusing.
 sa

 -Original Message-
 Sent: Tuesday, December 18, 2001 3:55 PM
 To: Multiple recipients of list ORACLE-L


 Believe it or not Jared, one of your script gave me following idea (the
 wrapper sql for decrypt/encrypt on your site).

 1. I have a system users table, I can add a column to store user's key in a
 column that only that user has access to.
 2. Create a DBA owned package to handle encryption/decryption.
 3. The key will be picked up in this package and used (maybe I'll use user
 key is used to derive the actual key).
 4. The package will be deployed as 'wrapped' in production, so by looking
 at dba_source you won't find much.

 I'll have to test this though but I think this will make it a bit more
 secure.

 The question is Can I trust myself? The answer is 'Yes.

 Can someone see any drawbacks?

 Raj
 __
 Rajendra JamadagniMIS, ESPN Inc.
 Rajendra dot Jamadagni at ESPN dot com
 Any opinion expressed here is personal and doesn't reflect that of ESPN
 Inc.

 QOTD: Any clod can have facts, but having an opinion is an art!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: hard disk configuration question

[Steve McClure]

 Well we had our meeting with the Hitachi Sales critter, and engineer.  I
discovered that they were trying to push a 5 disk raid array and one hot
spare at us, because my IT director was really trying to squeeze them on the
price of my 10 18GB disk configuration.  After the sales guy and engineer
went on about how their 4 separate IO paths would make our raid 5 perform as
well as any mirrored pair, I got to ask a few questions.  Well it turns out
that their RAID performs that well with extra large database block sizes.
When I pointed out that we currently have a block size of 2k(I didn't build
the db), and would be rebuilding the database on the new platform with 8k
blocks, he said that with a small block size like 8k you will really get
the best performance out of mirrors or a 1+0.  I am sure the sales guy
kicked him under the table ;-).

The end result is this.  We will probably go with the 6 36 GB DISKS.  It
flat out comes down to the cost of the whole system is just a little over
budget, and the drives are where the adjustment gets made.  I suspect that I
will have much less trouble getting a few extra disks once the system is in
the building.  I may also mess with things a bit and configure a 1+0 and a
mirrored pair.

So after that discussion, and all your helpful input I still have two
questions.

First what use are the two internal drives that aren't in the disk array?
Someone suggested to WRT them, and I am not familiar with that term.
Again I am not sure I want to mirror them, and if they aren't redundant how
useful can they really be?

Second.  If an 8k database block size is tiny, what is a large database
block size?  8k is as large as I can go without raw file systems, isn't it?

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

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

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

Re: Help

[Jared Still]

Your SGA is too small.

'alter system flush shared_pool' will temporarily fix
this problem, while booting all of  your carefully cached
sql out of the pool at the same time.

Consider:
  making shared_pool_size larger

  making reserved_pool_size larger and pinning
  some objects in memory

  looking up the OERR-4031 on MetaLink

Jared


On Tuesday 18 December 2001 16:30, Hamid Alavi wrote:
 Any idea what this means ?


 Error accessing package DBMS_APPLICATION_INFO
 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)


 Begin
 *
 ERROR at line 1:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 ORA-06508: PL/SQL: could not find program unit being called
 ORA-06512: at line 3


 PasswordNotification12172001.txt: No such file or directory
 PasswordNotification12172001.err: No such file or directory




 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987

 The information contained in this message and any attachments is intended
 only for the use of the individual or entity to which it is addressed, and
 may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
 disclosure under applicable law. If you have received this message in
 error, you are prohibited from copying, distributing, or using the
 information. Please contact the sender immediately by return e-mail and
 delete the original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Different clocks for different instances.

[Kevin Pollard]

Gooday Oraclers,
is it possible to have different instances, on the same dB server,
operating with different clocks - ie different date/times?


Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20

---
   Kevin Pollard  |  PODBA (Pretend Oracle DBA)
  mailto:[EMAIL PROTECTED]  |  Administrative Systems Unit
Phone:+61 (02) 6620 3969  |  Southern Cross University
  FAX:+61 (02) 6626 9122  |  P.O. Box 157
Room: R1-40a  |  Lismore NSW 2480, Australia
  http://staff.scu.edu.au/asu/index.html


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

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

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

Re: Help

[Joe Testa]

RTFM, but i'm in a decent mood, so i cut paste the explanation from 
oerr(if you're on windoze, move to unix, then you'll have oerr).

04031, 0, unable to allocate %s bytes of shared memory 
(\%s\,\%s\,\%s\,\%s\)
// *Cause:  More shared memory is needed than was allocated in the shared
//  pool.
// *Action: If the shared pool is out of memory, either use the
//  dbms_shared_pool package to pin large packages,
//  reduce your use of shared memory, or increase the amount of
//  available shared memory by increasing the value of the
//  INIT.ORA parameters shared_pool_reserved_size and
//  shared_pool_size.
//  If the large pool is out of memory, increase the INIT.ORA
//  parameter large_pool_size.



joe


Hamid Alavi wrote:

 Any idea what this means ?
 
 
 Error accessing package DBMS_APPLICATION_INFO
 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 
 
 Begin
 *
 ERROR at line 1:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 ORA-06508: PL/SQL: could not find program unit being called
 ORA-06512: at line 3
 
 
 PasswordNotification12172001.txt: No such file or directory
 PasswordNotification12172001.err: No such file or directory
 
 
 
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
 The information contained in this message and any attachments is intended
 only for the use of the individual or entity to which it is addressed, and
 may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
 disclosure under applicable law. If you have received this message in error,
 you are prohibited from copying, distributing, or using the information.
 Please contact the sender immediately by return e-mail and delete the
 original message from your system.
 


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






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

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

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

RE: Deciding what columns to partition on

[Khedr, Waleed]

Did you consider partitioned IOT?

Have fun,

Waleed

-Original Message-
Sent: Tuesday, December 18, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L



We are doing a redesign of our 200-Gig data warehouse in 9i.

One of the things we're thinking about is changing which
columns we partition on.

Currently, we partition exclusively on date fields.  This has
proven extremely helpful for doing maintenance, purging
old data, archiving, etc.   However, I feel that we're getting
minimal benefit with regard to partition pruning.

Very few of our most-used queries and reports even include
the date field that we are partitioning on.   Instead, we usually
query primarily on account number, rep number, etc. which
is a much more selective column.   With indexes
(and little partition pruning), we are getting
response times that are not fantastic but are within tolerable
range.   However, as the warehouse gets larger, these response
times get less and less acceptable.  Hence this redesign.

Many of our indexes are not even locally partitioned.   I can change
them to be locally partitioned.   The primary key ones can't be locally
partitioned unless they include the columns (date) that the table is
partitioned on.
Although the queries that use these primary key indexes don't even include
date clauses, I could still add the date field to the index so that it can
be locally partitioned.

However, this doesn't seem like a great idea in most cases.

Currently, we seldom seem to be doing any partition pruning in our
explain plans.  We seem to use indexes that don't include date columns
instead.   I'm not sure if
the indexes would work better if they had the date column in them,
especially
if the date column had to be the leading column in the index.   Although
the
partitions would then be pruned, I don't think the query would perform as
well as it would with a global partitioned index (or even a non-partitioned
index) where the acct_no (or whatever highly selective column) is the
leading column in the index.

I've tried to do some testing on this but the results haven't been
conclusive
because I can't test in production and I don't think my test database is
large
enough to give correct test results.

Now to my question:   In this sort of situation, should I settle for being
able
to either use date partitioning for maintenance benefits only, or to
partition
by the columns that I most often query on like acct_no so that I can prune
by partition.   Or is there some magical hybrid situation where I can have
both ease of maintenance and partition pruning for performance?  If yes,
what
sort of magical partitioning strategy do I need to use?

Thanks for any insights you can offer.

Also, I've been reading Scaling Oracle8i but it's more aimed at OLTP.
Can anyone offer a reference for a good data warehousing book, web site,
white papers,
etc. that covers 9i?   Or even 8i for that matter?

Thanks in advance for your feedback.

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

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

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

Re: Revert from 8.1.6 to 8.0.5

[hemantchitale]

Check out the Chapter on downgrading in the 8i Migration manual
The 8.1.6 manual pages are still online at
http://otn.oracle.com/doc/oracle8i_816/server.816/a76957/migdowng.htm#15124

You need to remove whatever 8i features you may have implemented that are
not available in 8.0.5
Depending on what changes you may have made, you may or may not be able to
downgrade.  Try
the downgrade on reviewing the doc. It would be faster than rebuilding the
database (unless the upgrade
from 8.0.5 to 8.1.6 was itself a rebuild !!).


Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Ed [EMAIL PROTECTED]  19/12/2001 05:30 AM
Sent by: [EMAIL PROTECTED]




Looks like we have to revert an 8.1.6 database that was upgraded over the
weekend back to 8.0.5, but we need to export/import so we don't lose data
from the last 2 days.  Anything I need to know?  The plan is to export
using
the 8.0.5 export utility before importing back into 8.0.5.  Does this make
sense?

Thanks,

Ed


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






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

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

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

RE: Help

[Wong, Bing]

If you are running 8.1.7.1, it has memory leak problem.  Need to upgrade to
8.1.7.2.0.

 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/18/01 5:50 PM

Your SGA has become fragmented.  You would not per chance be running
8.1.7 would you?  If so I would go and do some searching on Metalink.
I see an upgrade in your future.  You could try flushing the SGA but
if its what I think it is it won't help.  A restart will for a while.


-Original Message-
Sent: Tuesday, December 18, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Any idea what this means ?


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer)


Begin
*
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3


PasswordNotification12172001.txt: No such file or directory
PasswordNotification12172001.err: No such file or directory




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is
intended
only for the use of the individual or entity to which it is addressed,
and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

RE: hard disk configuration question

[hemantchitale]

Resending the email  (it bounced back with a locking problem) at fatcity.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on
19/12/2001 11:48 AM -
CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group19/12/2001 11:07 AM

Where are you putting the RDBMS and application code ?  Best mirror the two
internal disks and put the RDBMS and application code there.
You could also consider putting your Redo Logs --- particularly if you have
a RAID-5
array, it would definitely be better to put your Redo Logs on mirrored
disks seperate
from the database files.

How naive and honest the engineer was 

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Steve McClure [EMAIL PROTECTED]  19/12/2001 10:25 AM
Sent by: [EMAIL PROTECTED]




 Well we had our meeting with the Hitachi Sales critter, and engineer.  I
discovered that they were trying to push a 5 disk raid array and one hot
spare at us, because my IT director was really trying to squeeze them on
the
price of my 10 18GB disk configuration.  After the sales guy and engineer
went on about how their 4 separate IO paths would make our raid 5 perform
as
well as any mirrored pair, I got to ask a few questions.  Well it turns out
that their RAID performs that well with extra large database block sizes.
When I pointed out that we currently have a block size of 2k(I didn't build
the db), and would be rebuilding the database on the new platform with 8k
blocks, he said that with a small block size like 8k you will really get
the best performance out of mirrors or a 1+0.  I am sure the sales guy
kicked him under the table ;-).

The end result is this.  We will probably go with the 6 36 GB DISKS.  It
flat out comes down to the cost of the whole system is just a little over
budget, and the drives are where the adjustment gets made.  I suspect that
I
will have much less trouble getting a few extra disks once the system is in
the building.  I may also mess with things a bit and configure a 1+0 and a
mirrored pair.

So after that discussion, and all your helpful input I still have two
questions.

First what use are the two internal drives that aren't in the disk array?
Someone suggested to WRT them, and I am not familiar with that term.
Again I am not sure I want to mirror them, and if they aren't redundant how
useful can they really be?

Second.  If an 8k database block size is tiny, what is a large database
block size?  8k is as large as I can go without raw file systems, isn't it?

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








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

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

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

Re: Different clocks for different instances.

[hemantchitale]

Resending.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on
19/12/2001 11:49 AM -

Change the TZ variable in the Unix environment and restart the instance.
My guess
is that it should work.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Kevin Pollard [EMAIL PROTECTED]  19/12/2001 10:50 AM
Sent by: [EMAIL PROTECTED]



Gooday Oraclers,
is it possible to have different instances, on the same dB server,
operating with different clocks - ie different date/times?


Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20

---
   Kevin Pollard  |  PODBA (Pretend Oracle DBA)
  mailto:[EMAIL PROTECTED]  |  Administrative Systems Unit
Phone:+61 (02) 6620 3969  |  Southern Cross University
  FAX:+61 (02) 6626 9122  |  P.O. Box 157
Room: R1-40a  |  Lismore NSW 2480, Australia
  http://staff.scu.edu.au/asu/index.html


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







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

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

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

[no subject]

[James]

Hello Gurus,

I am working on a little project using the package utl_http, so far I have 
had limited success using this package.
The below http call fails for some reason, it is supposed to download a 
page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not 
sure why...

Any ideas ?? is it because that site is trying to plant/read a cookie or 
something on those lines ??

any help on this is much appreciated.


declare
 v_htm_pieces utl_http.html_pieces ;
begin

 pv_htm_pieces := 
utl_http.request_pieces('http://table.finance.yahoo.com/t?a=01b=01c=01d=01e=31f=01g=ds=ADCTy=0z=%5Eixic');

end;



Peace,

James Reddi


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

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

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

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

RE: SQL Loader Load Problem

[Deshpande, Kirti]

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

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

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

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

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

recovery during refresh

[Tatireddy, Shrinivas (MED, Keane)]

Hi lists,

I need to refresh a test database from production. (test1 from prod1 db)

I took the hotbackup files and online redo logs. I created the
controlfile using these files. After that I performed recovery.

Here I applied online logs instead of archive logs. (There are 7 grous
of online redo logs each contains 3 members). When I tried to open the
db, it asked that datafile needs recovery. 

I applied online redo log instead of archive log. The next day I
observed that indexes got corrupted (This msg is from another dba group
who are working with this new test database)

My doubt is : applying online redo logs instead of archive logs lead to
this index corruption?

can anybody come across such any situation. Now I need to do refresh
again in another way applying archive logs.

Thnx and regards,

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

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

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

RE: recovery during refresh

[Molina, Gerardo]

Run the following via svrmgrl or sqlplus

alter database backup controlfile to trace;

This generates a trace file in udump directory.

edit trace file:

1) strip out all lines prior to STARTUP NOMOUNT...

2) change all references to SID to test instance.

3) change all reference to file names to appropriate names for test
instance.

4) make appropriate changes if there are any differences in number and size
of
online redo logs.

5) Remove these lines from end of trace file
RECOVER DATABASE  
ALTER SYSTEM ARCHIVE LOG ALL; 
ALTER DATABASE OPEN;  

6) copy hotbackup files only (do not copy online redo logs) to test file
directories.

7) remove all online redo logs and control files for test instance.

8) make sure number of rollback segments in init.ora for test instance
matches
number of rollback segments in prod.

9) from svrmgrl or sqlplus

@edited trace_file

10) issue following command:
recover using backup controlfile until cancel;

11) when prompted for archive redo log, ftp it over from production to test
(renaming it appropriately).

12) apply as many arhive redo logs that you feel you want

13) CANCEL   (this ends recovery) if you get error, then you need apply more
logs (see 10).

14) alter database open resetlogs;

This will recreate online redo logs and startup the database;

This is a proven procedure.

HTH,
Gerardo


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L


Hi lists,

I need to refresh a test database from production. (test1 from prod1 db)

I took the hotbackup files and online redo logs. I created the
controlfile using these files. After that I performed recovery.

Here I applied online logs instead of archive logs. (There are 7 grous
of online redo logs each contains 3 members). When I tried to open the
db, it asked that datafile needs recovery. 

I applied online redo log instead of archive log. The next day I
observed that indexes got corrupted (This msg is from another dba group
who are working with this new test database)

My doubt is : applying online redo logs instead of archive logs lead to
this index corruption?

can anybody come across such any situation. Now I need to do refresh
again in another way applying archive logs.

Thnx and regards,

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

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

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

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

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

RE: recovery during refresh

[Tatireddy, Shrinivas (MED, Keane)]

Hi Gerardo,

Thnq for responding.

My doubt is , if I apply online logs , will it cause index corruptions.
(ora - 600 error).

In my last refresh , I applied online redo log. I got the message when I
apply this log is Media recovery completed.

After that I opened the db with resetlogs. Everything went fine.

But later when the team is working that some indexes got corrupted and
returning ora-600 errors.

But in production db they are ok. 

Can you explain why this happened.?

Srinivas

-Original Message-
Sent: Wednesday, December 19, 2001 3:50 AM
To: Multiple recipients of list ORACLE-L


Run the following via svrmgrl or sqlplus

alter database backup controlfile to trace;

This generates a trace file in udump directory.

edit trace file:

1) strip out all lines prior to STARTUP NOMOUNT...

2) change all references to SID to test instance.

3) change all reference to file names to appropriate names for test
instance.

4) make appropriate changes if there are any differences in number and
size
of
online redo logs.

5) Remove these lines from end of trace file
RECOVER DATABASE  
ALTER SYSTEM ARCHIVE LOG ALL; 
ALTER DATABASE OPEN;  

6) copy hotbackup files only (do not copy online redo logs) to test file
directories.

7) remove all online redo logs and control files for test instance.

8) make sure number of rollback segments in init.ora for test instance
matches
number of rollback segments in prod.

9) from svrmgrl or sqlplus

@edited trace_file

10) issue following command:
recover using backup controlfile until cancel;

11) when prompted for archive redo log, ftp it over from production to
test
(renaming it appropriately).

12) apply as many arhive redo logs that you feel you want

13) CANCEL   (this ends recovery) if you get error, then you need apply
more
logs (see 10).

14) alter database open resetlogs;

This will recreate online redo logs and startup the database;

This is a proven procedure.

HTH,
Gerardo


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L


Hi lists,

I need to refresh a test database from production. (test1 from prod1 db)

I took the hotbackup files and online redo logs. I created the
controlfile using these files. After that I performed recovery.

Here I applied online logs instead of archive logs. (There are 7 grous
of online redo logs each contains 3 members). When I tried to open the
db, it asked that datafile needs recovery. 

I applied online redo log instead of archive log. The next day I
observed that indexes got corrupted (This msg is from another dba group
who are working with this new test database)

My doubt is : applying online redo logs instead of archive logs lead to
this index corruption?

can anybody come across such any situation. Now I need to do refresh
again in another way applying archive logs.

Thnx and regards,

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

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

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

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

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

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

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