Re: Perl DBA Tools

[Jared Still]

While that would be a worthwhile endeavor, I'm looking for 
stuff that is specific to Oracle operations, internal or external,
as it relates to DBA tasks.

Jared


On Monday 23 April 2001 17:25, Patrick Housholder wrote:
 I just am starting into the perl land.
 *
 my project/tool:
   From oracle forms, call perl to remote login into a HOST(vms, sun,
 whatever)
   once i've login, run a script on the host with args.
   exit back to forms.
   -
   scan the host when-timer-expire to see the state of a host...
   -
 *
 os: window nt 4.0 sp6a
 *
 can this be done? or should i go w/pathwork?

 patrick
 *


 ===
 Patrick Housholder
 Sr. Staff Anl Tech Spt Design
 United Airlines Flight Training Center
 Denver CO


 *-Original Message-
 *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seley,
 *Linda
 *Sent: Monday, April 23, 2001 2:50 PM
 *To: Multiple recipients of list ORACLE-L
 *Subject: RE: Perl DBA Tools
 *
 *
 *Well, I'm 75% of the way through creating scripts to automatically clone
 a *database.  It's all in the korn shell and yes, I've been thinking
 'there *must be a better way'!  (besides the fact that soon I'm gonna need
 to put *this through end-to-end testing and would like help)
 *
 *Linda
 *
 *-Original Message-
 *Sent: Monday, April 23, 2001 1:02 PM
 *To: Multiple recipients of list ORACLE-L
 *
 *
 *
 *Hello List,
 *
 *For those of you that use Perl or would like to use Perl for your
 *regular DBA tasks, I have a request.
 *
 *Do you have any tasks you perform with a series of SQL scripts,
 *shell scripts, etc, that you feel are somewhat of a kludge?
 *
 *Have you every asked yourself  There must be a better way to
 *do this?
 *
 *Or do you just have a wishlist of tools that would make day to day
 *DBA life easier, but feel that it's too complex or unwieldy to tackle
 *with PL/SQL and SQL*Plus?
 *
 *I'm looking for just those kinds of ideas for a project I'm working on.
 *
 *No ideas too silly or complicated.  Granted, they may be too silly or
 *complicated to actually implement, but you never know.  No idea is
 *a bad idea until it's thought through.
 *
 *Come to think of it, the same holds true for good ideas also.
 *
 *Anyway, let's hear it!
 *
 *Some examples of tools that I have used in Perl:
 *
 ** Create multiple users from a CSV file generated from MS Excel.  Works
 *  great when someone asks for 100 users to be created.
 *
 ** Monitor databases for SNIPED sessions then KILL them.
 *
 ** Monitor  the alert.log for Errors and mail to DBA's and or selectect
 *   other individuals.  Errors can be filtered by type and selectively
 *mailed.
 *   I've used this for duhvelopers that don't want to be bothered with
 *   error trapping and send hundreds of emails to the DBA's due to their
 *   error messages.  Que's up messages for 5 minutes or 100 messages,
 *   whichever comes first ( avoids swamping the mail server in a crisis )
 *
 **  How about a way to serve up passwords to users for use with command
 *   line utilities in a secure manner?  Oh wait, I don't have that one
 yet. *
 *As you can see, I have a wishlist too.  Lemme hear what you would like!
 *
 *TIA
 *
 *Jared
 *
 *--
 *Please see the official ORACLE-L FAQ: http://www.orafaq.com
 *--
 *Author: Jared Still
 *  INET: [EMAIL PROTECTED]
 *
 *Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 *San Diego, California-- Public Internet access / Mailing Lists
 *
 *To REMOVE yourself from this mailing list, send an E-Mail message
 *to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 *the message BODY, include a line containing: UNSUB ORACLE-L
 *(or the name of mailing list you want to be removed from).  You may
 *also send the HELP command for other information (like subscribing).
 *--
 *Please see the official ORACLE-L FAQ: http://www.orafaq.com
 *--
 *Author: Seley, Linda
 *  INET: [EMAIL PROTECTED]
 *
 *Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 *San Diego, California-- Public Internet access / Mailing Lists
 *
 *To REMOVE yourself from this mailing list, send an E-Mail message
 *to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 *the message BODY, include a line containing: UNSUB ORACLE-L
 *(or the name of mailing list you want to be 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] 

RE: RMAN list command doesn't show any backupsets although backup

[Zvizdenco, Ghenadie]

Hi,
I'm using RMAN 8.0.5. I deleted with change...delete the backupsets then
unregistered using the dbms_rcvcat.unregisterdatabase package. After the new
registration I made backups but they are not showed in the RMAN. I looked in
the recovery catalog database and foud these backupsets, but they somehow
got the STATUS 'D' - deleted. Even if I change myself the status to 'A', I
get no backupset whe n i run list command in the RMAN. So, the backup goes
OK, but the backupsets get the DELETED STATUS. 

Thanx
Ghenadie Zvizdenco

-Original Message-
Sent: Tuesday, April 24, 2001 1:01 AM
To: Multiple recipients of list ORACLE-L
backup goe


what RMAN version?
i'm using 8.1.6 for several months, to backup 5 remote db's.
Never heard something like that.
Do you unregister using packagedbms_rcvcat.unregisterdatabase ??
And then new registration?, did you make any backups after new registration?
It seems a kinda bug.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 8:20 AM


 Hi,
 I'm having a problem with the recovery manager after registering the
 database for the second time with the same recovery catalog:
 RMAN list command doesn't show any backupsets although backup goes without
 any errors.
 The problems started when i made a mistake and i did an incremental backup
 level 1 after after i added the second datafile to one the tablespaces.
The
 problem then was that i couldn't see any backupset for the first datafile
of
 that tablespace with the list command. Then I thought that unregistering
and
 re-registering the database could solve the problem, but it didn't... now
i
 can't see any backupsets at all although they exist in the recovery
catalog
 database and there are backupsets with the status is 'A'(active). I also
 tried to validate the backupset of the controlfile (restore controlfile to
 '/disk/contolfile' validate) and it worked ok and used the recent
backupset.


 has anyone experienced such problem?
 Thanks
 Ghenadie Zvizdenco
 Junior DBA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Zvizdenco, Ghenadie
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: Claudio Roca
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Zvizdenco, Ghenadie
  INET: [EMAIL PROTECTED]

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

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

RE: ORA-04030

[paquette stephane]

The ORA 4030 is about a process not having enough
room.
It's been a bug on Oracle (Oracle 8.0.5 on hpux 10.20
had that) or your opening a cursor in a loop and
you're forgetting to close it  or something similar.


--- Kevin Kostyszyn [EMAIL PROTECTED] a écrit : 
Acutally, 8.1.5 won't install either.  I mean it
 will, but it will tell you
 that it is a bad idea.
 Kev
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Monday, April 23, 2001 2:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 128MB of memory is killing you!  Oracle's stated
 minimum requirements are
 128MB (but they recommend 256MB).  In fact, the
 Oracle Installer won't even
 run without 128MB (in 8.1.6 and higher).
 
 Ed Haskins
 Oracle DBA
 Verizon Wireless
 
 
 
 -Original Message-
 Sent: Monday, April 23, 2001 12:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 What did you try and resize it to?  Remember, you
 only have 128 mbs.
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Monday, April 23, 2001 12:02 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 How big is your shared pool size ? Do you have many
 dynamic SQLs ? You may
 want to keep the sys packages in the shared pool, so
 that your shared pool
 won't be fragmented by dynamic SQLs.
 
 Thanks
 Riyaj Re-yas Shamsudeen
 Certified Oracle DBA
 i2 technologies   www.i2.com
 
 
 
 Dorozhkin, Anton
 Anton.Dorozhkin@artificia  
  To: Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]
 l-life.ru  
  cc:
 Sent by: [EMAIL PROTECTED]   
  Subject: ORA-04030
 
 
 04/21/01 07:05 AM
 Please respond to ORACLE-L
 
 
 
 
 
 
 I've got a such error when run a PL/SQL scripts
 on Windows 2000, Orcale 8.1.7 with 128MB memory
 
 ORA-04030: out of process memory when trying to
 allocate 257280 bytes (PLS
 non-lib hp,PAR.C:parchk:ptb)
 
 I've tried to change settings in init.ora but this
 didn't help.
 
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Dorozhkin, Anton
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be 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: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be 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: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists

RE: import and strange PK violation error ???

[Nirmal Kumar Muthu Kumaran]

Hi vadim,

Are you sure, when you disable unique constraint, the related index won't be
deleted?.
Hope that the index will be deleted, i tested in Oracle815, NT.

Nirmal.


 -Original Message-
 From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, April 20, 2001 12:50 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: import and strange PK violation error ???
 
 Hi Andrea,
 Does it happen after rows are actually imported? You may set im option
 CONSTRAINTS=N, otherwise constraints will be enabled (or fail ot be
 enabled)
 at the end of import. Also, be aware if you have UNIQUE constraints, the
 disabling UNIQUE constraint doesnt drop corresponding index (unlike
 PRIMARY
 KEY), and this index may be unique.
 HTH
 Vadim Gorbounov
 Oracle DBA
 
 -Original Message-
 Sent: Thursday, April 19, 2001 4:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 All,
 
 I'm import from a dmp file.  I already disable PK, FK
 on all the tables, but when I import I still got:
 unique constraint (ICSSOWNER.PK_ACCOUNT_PROFILE)
 
 and PK_ACCOUNT_PROFILE is already disabled.  Any idea?
 
 Thanks.
 
 Andrea
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - buy the things you want at great prices
 http://auctions.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Andrea Oracle
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vadim Gorbounov
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: [EMAIL PROTECTED]

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

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

Re: Fwd: Re: Where can I find real-life-examples about ORACLE

[paquette stephane]

Well, I'm an admitted purist too.

The dev team has done the datawarehouse first phase by
themselves ignoring my recommandations. Hey who am i
to tell how do things to a team 100% composed of one
of the biggest consulting firm in the world (cgey)
with no Oracle knowledge and very little DW knowledge.


Each time I was trying to bring on my point of view
they were telling me that it was too theoritical. 

Now we have a nice hybrid data model and before Oracle
do a star join on their tables it will snow cows. 

On the good side, damagement has read my audit and
from now on we'll do things the good way. (It will be
nice to change those dimension tables 5 fields primary
key...)

Denormalisation is a solution to identified problems
not a designing/programming style. 


--- Tim Sawmiller [EMAIL PROTECTED] a écrit : 

 ATTACHMENT part TEXT message/rfc822 
 Date: Mon, 23 Apr 2001 14:27:50 -0400
 
 I'm an admitted purist...I look at denormalized and
 unnormalized as being the same.  I've been on
 projects that wanted to introduce denormalization
 because the developers expected a performance issue.
  After I look at it and disagree, then the war
 begins.  On the other hand, on my latest project, I
 agreed with a suggested denormalization after I
 heard all the facts.  I like your point about
 calling it structured denormalization.  Makes sense
 to me.
 
 As far as people making business decisions, why do
 they need to know about denormalization?  That's an
 implementation issue.  If they hired good IT people,
 then they're ok. If they didn't, they're screwed.  
 Such is life in the big city.  We need to get some
 successes under our belt so we can preach  with
 confidence and  having refenceable clients
 available.
 
  Eric D. Pierce [EMAIL PROTECTED] 04/23/01
 02:06PM 
 And I'd be curious to know why you are curious!
 
 What I have gathered so far from the discussion is
 that normalization
 zealotry, probably similar to other purist
 perspectives in life,
 doesn't get any particularly huge respect in the
 real world.
 
 In other words, people that make business decisions
 have never heard
 of any conventional wisdom that violating
 normalized db designs will
 automatically wreck their organization. Like many
 other things, their
 IT infrastructure will inefficiently plod along, and
 suffer the burden
 of crappy models (grumbling dbas and all) in
 spite of a lack of
 conformance to theoretical orthodoxy.
 
 I would guess that in some cases, an organization's
 IT folks might be
 able to present a coherent business case for zealous
 normalization,
 but doing so is probably a rare skill, and perhaps
 even more rarely
 appreciated by the organization.
 
 Unfortunately the situation for structured
 denormalization is 
 probably about the same, except that it may not have
 quite the 
 political baggage, and so can just be used as a
 technical method.
 
 ep
 
 ps, don't forget that the word structured needs to
 be in front
 of denormalized. on the other hand, unnormalized
 (non-normal)
 by definition can't be structured. unnormalized
 implies a
 *lack* of methodology, whereas structured
 denormalization implies
 method/rules/order/metrics/analysis/etc.
 
 pss, do you remember reading the Oracle Magazine
 article on 
 denormalization by Ulka Rogers back in the Oracle v6
 (or maybe
 early v7) days?
 
 On 23 Apr 2001, at 10:15, Tim Sawmiller wrote:
 
 Date sent:Mon, 23 Apr 2001 10:15:29 -0800
 To:   Multiple recipients of list
 ORACLE-L [EMAIL PROTECTED]
 ORACLE
 
  I'd be curious to see your definitions of
 un-normalized and de-normalized...
  
  
  
   [EMAIL PROTECTED] 04/23/01 01:55PM 
  
  On 20 Apr 2001, at 19:15, Jared Still wrote:
  
  Date sent:  Fri, 20 Apr 2001 19:15:20 -0800
  To: Multiple recipients of list
 ORACLE-L [EMAIL PROTECTED]
  
   
Well, why would you *not* want to denormalize
 during design? It seems
to me that (theoretically) ***if*** you are
 doing structured
denormalization correctly, that is exactly
 when you would want to do
it, no?
   
   Unless you detect a performance problem, why
 denormalize at all?
   
   We always have folks that want to denormalize
 because they *think*
   there will be a performance problem.   This
 usually occurs because
   they think that joining 3 or 4 tables will be
 too slow.
  
  
  I guess I've been under the impression that a good
 design
  process would be done with proper methods,
 including having
  (legitimately tested) performance metrics.
  
  Are you saying that is an overly idealistic
 approach for most
  real world situations? :)
  
  ...
  
   ...  Only one table was highly denormalized, and
   that was nobody could figure out a reasonable
 way to normalize it.  Not sure
   if I could yet.  :)
  
  Well, as i said before, my understanding is that
 it was 
  unnormalized, which is different from
 denormalized.
 
 ...
 
 
 --
 Please see the official ORACLE-L FAQ:
 

pcscfg.cfg needed

[C.S.Venkata Subramanian]

Dear List,
Any one of can send pcscfg.cfg file for Red hatLinux6.2 running Oracle 8.1.6 and also 
for Sun solaris.

Treat this as urgent.

TIA





Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

pcscfg.cfg needed

[C.S.Venkata Subramanian]

Dear List,
Any one of can send pcscfg.cfg file for Red hatLinux6.2 running Oracle 8.1.6 and also 
for Sun solaris.

Treat this as urgent.

TIA





Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

RE: Perl DBA Tools

[Lord David]

Jared

Don't have any suggestions (except for enterprise manager that works, fast),
but if you're looking for perl development help, I'd be interested.

David Lord

-Original Message-
Sent: 23 April 2001 20:02
To: Multiple recipients of list ORACLE-L



Hello List,

For those of you that use Perl or would like to use Perl for your
regular DBA tasks, I have a request.  

Do you have any tasks you perform with a series of SQL scripts,
shell scripts, etc, that you feel are somewhat of a kludge?

Have you every asked yourself  There must be a better way to
do this?

Or do you just have a wishlist of tools that would make day to day
DBA life easier, but feel that it's too complex or unwieldy to tackle
with PL/SQL and SQL*Plus?

I'm looking for just those kinds of ideas for a project I'm working on.

No ideas too silly or complicated.  Granted, they may be too silly or
complicated to actually implement, but you never know.  No idea is
a bad idea until it's thought through.

Come to think of it, the same holds true for good ideas also.

Anyway, let's hear it!

Some examples of tools that I have used in Perl:

* Create multiple users from a CSV file generated from MS Excel.  Works
  great when someone asks for 100 users to be created.

* Monitor databases for SNIPED sessions then KILL them.  

* Monitor  the alert.log for Errors and mail to DBA's and or selectect
   other individuals.  Errors can be filtered by type and selectively
mailed.
   I've used this for duhvelopers that don't want to be bothered with 
   error trapping and send hundreds of emails to the DBA's due to their
   error messages.  Que's up messages for 5 minutes or 100 messages,
   whichever comes first ( avoids swamping the mail server in a crisis )

*  How about a way to serve up passwords to users for use with command
   line utilities in a secure manner?  Oh wait, I don't have that one yet.

As you can see, I have a wishlist too.  Lemme hear what you would like!

TIA

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).
**
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
the system manager.

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

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

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

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

RE: c compiler problem Solaris not found

[Sinardy Xing]

Hi Miller,

Thank you for your help.

My Solaris only having 1 cc file which is inside /usr/ucb
I have Solaris CD with me now is the C compiler included in the package ? or
do I have to download ? do you have the URL ?


Thank You

Sinardy

-Original Message-
Sent: Tuesday, 24 April 2001 2:56 PM
To: LazyDBA mailing list


At 11:44 +0800 24/4/01, Sinardy Xing wrote:
$ cc test.c test
/usr/ucb/cc: language optional software package not installed

Change your PATH environment variable to get to your real cc before
/usr/ucb (in fact take /usr/ucb out of your path completely unless
absolutely required).

Regards

Paul Miller
--
-
Carib Data Limited

mailto:[EMAIL PROTECTED]
http://www.caribdata.co.uk


Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com


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

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

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

RE: cdump, bdump, udump

[Venkat_Kalepalli]

Title: RE: cdump, bdump, udump





Hello folks!


I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer.

I want to know what are the advantages we get on this and what are the steps to implement this? 


Any help is grateful...


Rgd
Venkat
DBA.

MTSCost based Optimzer

[Venkat_Kalepalli]

Title: MTSCost based Optimzer





Hello folks!


I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer.

I want to know what are the advantages we get on this and what are the steps to implement this? 


Any help is grateful...


Rgd
Venkat
DBA.

RE: Perl DBA Tools

[Mark Leith]

Jared,

Adding on to monitoring the alertSID.log, how about also monitoring the
Archive log directory for free space - and size, then alert by email when
say 90% full. Or go one step further - and when it reaches 90% full ftp the
older logs to a backup directory.

I'm still thinking about this one - we have loads of requests for
functionality in tools that just seem outrageous - shall I send them all to
you in a great big list? :-)

Cheers

Mark

-Original Message-
Sent: Tuesday, April 24, 2001 09:46
To: Multiple recipients of list ORACLE-L


Jared

Don't have any suggestions (except for enterprise manager that works, fast),
but if you're looking for perl development help, I'd be interested.

David Lord

-Original Message-
Sent: 23 April 2001 20:02
To: Multiple recipients of list ORACLE-L



Hello List,

For those of you that use Perl or would like to use Perl for your
regular DBA tasks, I have a request.

Do you have any tasks you perform with a series of SQL scripts,
shell scripts, etc, that you feel are somewhat of a kludge?

Have you every asked yourself  There must be a better way to
do this?

Or do you just have a wishlist of tools that would make day to day
DBA life easier, but feel that it's too complex or unwieldy to tackle
with PL/SQL and SQL*Plus?

I'm looking for just those kinds of ideas for a project I'm working on.

No ideas too silly or complicated.  Granted, they may be too silly or
complicated to actually implement, but you never know.  No idea is
a bad idea until it's thought through.

Come to think of it, the same holds true for good ideas also.

Anyway, let's hear it!

Some examples of tools that I have used in Perl:

* Create multiple users from a CSV file generated from MS Excel.  Works
  great when someone asks for 100 users to be created.

* Monitor databases for SNIPED sessions then KILL them.

* Monitor  the alert.log for Errors and mail to DBA's and or selectect
   other individuals.  Errors can be filtered by type and selectively
mailed.
   I've used this for duhvelopers that don't want to be bothered with
   error trapping and send hundreds of emails to the DBA's due to their
   error messages.  Que's up messages for 5 minutes or 100 messages,
   whichever comes first ( avoids swamping the mail server in a crisis )

*  How about a way to serve up passwords to users for use with command
   line utilities in a secure manner?  Oh wait, I don't have that one yet.

As you can see, I have a wishlist too.  Lemme hear what you would like!

TIA

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).
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

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

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

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

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

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

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

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

RE: Oracle on NT/2000 Service shutdown

[Mark Leith]

As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

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

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

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

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

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

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

RE: cdump, bdump, udump

[Sinardy Xing]

Hi all,

When those logs will created ?

Thank you

Sinardy


-Original Message-
Sent: Tuesday, 24 April 2001 9:41 AM
To: LazyDBA mailing list


Hi DBAs and SAs,

I had a task to do housekeep ...\bdump\alertSID.log
What logs usually Oracle system need to housekeep, and what are these
directory
cdump,
bdump and
udump
for ?


Thank you for your time

Sinardy




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 on NT/2000 Service shutdown

[Szecsy Tamas]

Cann't it be that shutdown goes quickly and startup is slow? 
If I remember it well there is a possibility with Oracle 8.1.x(x=?) to set
startup time for a database. This is to garantee startup time.

Tamas Szecsy

-Original Message-
Sent: 2001.04.24. 12:40 PM
To: Multiple recipients of list ORACLE-L


As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

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

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

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

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

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

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

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

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

Re: cdump, bdump, udump

[Joseph S. Testa]

read the tuning guide and the administrators guide.

nowadays this is a valid answer now that oracle docs are online, NO ONE
HAS AN EXCUSE to not read the docs unlike back in the days when you had
to pay thousands of dollars for paper docs.

joe
 Venkat_Kalepalli wrote:
 
 Hello folks!
 
 I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement
 MTS on the Oracle server.  Next we are running with Rule based
 optimizer and we want to change to costbased optimizer.
 
 I want to know what are the advantages we get on this and what are the
 steps to implement this?
 
 Any help is grateful...
 
 Rgd
 Venkat
 DBA.

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. 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).

Oracle DBA Needed in St. Louis-Great Opportunity..

[OraStaff]

Well known brand name company in St. Louis, Missouri, is currently looking for 
an outstanding Oracle DBA who is well versed in physical or logical Oracle
DBA work. 
You will be working on a team of DBA's as well as with a group of Data Analysts,
fine tuning several Oracle databases which receive data from international
and national
locations. 

*Requirements: 
- 3 years as either a physical or logical Oracle DBA
- Excellent communication skills 
- Prefer Oracle 8 experience as well as some experience with the internet 
- At least 5 years of total IT experience to be considered 
- U.S. citizenship or permanent residency

*This position offers:
- A base salary up to 75K and potential 15-20% bonuses
  of your base pay per year, as well as a pension and savings plan matching
  60% (up to 7% of your annual salary)...also other very good benefits. 
- They have a a team environment, a warm atmosphere and an opportunity 
  to expand your skill set.

NO sub contracting positions available.

Please do not send your resume if you are not in the United States.

For  immediate consideration, please email your resume as an attachment to:

Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. (Please do not call if you need sponsorship)
Please Use Job Code: One/St. Louis/DBA/Andersen

*We pay referral fees.
So please contact us if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law
Oracle Placement Specialist
OraStaff, Inc.- The Proven Connection to Oracle Opportunity
 




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

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

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

RE: cdump, bdump, udump

[Lanteigne, Mike]

I must be 'old' because I miss my paper docs. I still print out some of the
pdf docs, must be a confort thing!

Mike

The views expressed here are mine and do not reflect the official position
of my employer or the organization through which the internet was accessed.



 -Original Message-
 From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 8:50 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: cdump, bdump, udump
 
 read the tuning guide and the administrators guide.
 
 nowadays this is a valid answer now that oracle docs are online, NO ONE
 HAS AN EXCUSE to not read the docs unlike back in the days when you had
 to pay thousands of dollars for paper docs.
 
 joe
  Venkat_Kalepalli wrote:
  
  Hello folks!
  
  I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement
  MTS on the Oracle server.  Next we are running with Rule based
  optimizer and we want to change to costbased optimizer.
  
  I want to know what are the advantages we get on this and what are the
  steps to implement this?
  
  Any help is grateful...
  
  Rgd
  Venkat
  DBA.
 
 -- 
 Joe Testa  http://www.oracle-dba.com
 Performing Remote DBA Services, need some backup DBA support?
 For Sale: Oracle-dba.com domain, its not going cheap but feel free to
 ask :)
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joseph S. 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: Lanteigne, Mike
  INET: [EMAIL PROTECTED]

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mohan, Ross]

 Ed, 

Ever since ZBR, the need to use the outside of the disk ( to
reduce seeks ) is significantly reduced. 

Ross

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/24/2001 12:00 AM

Dick,

Thanks!

SAME also suggests using the outer half of each disk for data
storage...as
I/O performance is increased due to the natural circular shape of the
platter.  My question...how do you specify which sections of each disk
are
utilized?  From what I've been able to read, I'm guessing that hyper
volumes could be used for this??  I'm not sure...haven't had the
opportunity to play with this yet.  Anyone have an answer for this?

Ed Haskins
Oracle DBA
Verizon Wireless



-Original Message-
Sent: Friday, April 20, 2001 5:04 PM
To: Haskins; Ed; Multiple recipients of list ORACLE-L


ED,

Damn good question!  No I won't take it as sarcastic at all.

Now to your point:  We had to implement this particular strategy
about 4
years ago due to the vendor we bought a disk array from (IPL).  They
were
somewhat ahead of the curve here.  Simple theory, they configured the
30GB
array
as one very large disk drive with all of the disks striped and mirrored.
Simply
put the SAME principle.  Problem, there was only one SCSI channel into
the
array, OOPS, bottle neck par excellence!  Again not too far in the
recent
past
we did a similar thing with some EMC disk, but this time we used 4 SCSI
cables
with EMC's Power Path software.  OH FUDGE, the 4 hyper volumes were all
on
the
same spindle, Damn, bottle neck par excellence again.

So as you can see, it makes a wonderful theory, but I haven't seen
the
pudding, yet.  Still trying!

Dick Goulet

Reply Separator
Author: Haskins; Ed [EMAIL PROTECTED]
Date:   4/20/2001 9:25 AM

Dick,

Don't take this the wrong way...it's NOT meant to be sarcastic:

You said SAME is a great theory, but I can't and haven't seen it
perform
well in practice, yet.

My question to you:  Have you seen it in practice at all?  An actual
working
implementation?

For that matter; has ANYONE seen it implemented in a production
environment?
I'm sure it must be somewhere, but I'm curious if anyone knows where.

This is a subject that I'm really into right now...that's why I'm
prodding a
bit!

Thanks,

Ed Haskins
Oracle DBA
Verizon Wireless



-Original Message-
Sent: Friday, April 20, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L


Steve,

I heard about this SAME philosophy at the last NorthEast Oracle
Users
Group
meeting from a individual who works on the utilities for Oracle in the
New
England Development Office.  Although we did not get deeply into the
philosophy,
I'll agree that it is not the silver bullet, actually it can become a
performance detractor.  The individual who wrote the paper for Oracle
(Anjo
Kolk) is a LONG time Oracle person, actually wrote the core of the
kernel,
so I
believe he's probably writing from a purely theoretical point of view.
In
that
light what he's saying would be true, stripe  mirror everything and
theoretically you should never have an io bottleneck.  BUT, many
hardware
platforms don't handle mirroring very well unless your using a disk
array
like
EMC's.  Now that handles the mirror internally so we've alleviated that
problem,
but EMC likes to break their drives into 'hyper volumes' so your
stripping
may
or may not be across physical drives.  Also your stripes can still have
the
bottle neck of the number of SCSI cards in the computer.  In any case
taking
a
little time to insure that redo logs, archive logs, indexes, and data
are
all
REALLY spread out across devices is the only way to go.  SAME is a great
theory,
but I can't and haven't seen it perform well in practice, yet.

Dick Goulet

Reply Separator
Author: Steve Adams [EMAIL PROTECTED]
Date:   4/19/2001 11:25 PM

Hi All,

The author (Anjo Kolk) is an advocate of SAME (stripe and mirror
everything).
The SAME philosophy is that everything should be striped across all
the
disks
available. Separating indexes from their tables is contrary to that
philosophy.
I don't agree with it, but that's where he's coming from anyway.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 20 April 2001 6:56
To: Multiple recipients of list ORACLE-L


Whoaaa, I sure hope someone can, because I have never heard that before?
Kev

-Original Message-
Ghosalkar
Sent: Thursday, April 19, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


Guys,

i was checking my statspack report on oraperf and i came across this
statement.

Never split index and data files to different sets of disks.

can anyone xplain the logic behind this.

Thanks
Mandar

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

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

Re: MTSCost based Optimzer

[Rachel Carmichael]

turning on cost-based is easy:  set the optimizer_mode parameter to choose 
in your init.ora, stop and start your database and then analyze all your 
tables.

HOWEVER (and this is a biggie) this will not automatically make all your 
queries run faster. You will need to examine each and every query to see if 
it needs to be rewritten to take advantage of CBO. In fact, sometimes there 
are queries that run faster in rule-based, and I have had to include hints 
in queries to force the optimizer to run rule.

From: Venkat_Kalepalli [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 02:25:25 -0800

  Hello folks!
 
  I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement MTS
  on the Oracle server.  Next we are running with Rule based optimizer and
  we want to change to costbased optimizer.
 
  I want to know what are the advantages we get on this and what are the
  steps to implement this?
 
  Any help is grateful...
 
  Rgd
  Venkat
  DBA.
 
 
 

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Idle time

[Mark Leith]

If I understand your question - the commmand column relates to the last
command that the user sent to the database - therefore the select entry
would mean the last statement sent to the database by that user was a select
statement.

HTH

Mark

-Original Message-
Vaidya
Sent: Tuesday, April 24, 2001 01:56
To: Multiple recipients of list ORACLE-L




Hi,
That is precisely what i thought.

The reason I am putting this question is   in the OEM Top sessions
the command is select , instead of  UNKNOWN.


But the command shows select.What does that mean ?.

  shreepad





To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Shreepad Vaidya/EMEA/ALLTELCORP)



Idle means the database didnt have to do anything to
service this session, basically, they didn't run any
sql

hth
connor

--- Shreepad Vaidya [EMAIL PROTECTED]
wrote: 

 Hi List,

 I have set idle time as 15 minutes by creating a
 profile and assigning
 it to a user.

 In OEM  Oracle Top session the status is sniped.

 My question is what is considered as idle time . ?
 No activity on the
 machine  or no statements running in the background
 or foreground for
 that particular session.

 The reason I am putting this question is   in the
 OEM Top sessions
 the command is select  , instead of UNKNOWN .

 I might have to reconsider my settings.


 Anyone  with any inputs or pointers  ?


   shreepad

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

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


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 days you're the pigeon, some days you're the statue


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Shreepad Vaidya
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: Perl DBA Tools

[Rachel Carmichael]

truncating listener logs -- or even starting a secondary listener, stopping 
the one with the log that is too large and removing the log, then restarting 
the original listener


From: Mark Leith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Perl DBA Tools
Date: Tue, 24 Apr 2001 02:40:25 -0800

Jared,

Adding on to monitoring the alertSID.log, how about also monitoring the
Archive log directory for free space - and size, then alert by email when
say 90% full. Or go one step further - and when it reaches 90% full ftp the
older logs to a backup directory.

I'm still thinking about this one - we have loads of requests for
functionality in tools that just seem outrageous - shall I send them all to
you in a great big list? :-)

Cheers

Mark

-Original Message-
Sent: Tuesday, April 24, 2001 09:46
To: Multiple recipients of list ORACLE-L


Jared

Don't have any suggestions (except for enterprise manager that works, 
fast),
but if you're looking for perl development help, I'd be interested.

David Lord

-Original Message-
Sent: 23 April 2001 20:02
To: Multiple recipients of list ORACLE-L



Hello List,

For those of you that use Perl or would like to use Perl for your
regular DBA tasks, I have a request.

Do you have any tasks you perform with a series of SQL scripts,
shell scripts, etc, that you feel are somewhat of a kludge?

Have you every asked yourself  There must be a better way to
do this?

Or do you just have a wishlist of tools that would make day to day
DBA life easier, but feel that it's too complex or unwieldy to tackle
with PL/SQL and SQL*Plus?

I'm looking for just those kinds of ideas for a project I'm working on.

No ideas too silly or complicated.  Granted, they may be too silly or
complicated to actually implement, but you never know.  No idea is
a bad idea until it's thought through.

Come to think of it, the same holds true for good ideas also.

Anyway, let's hear it!

Some examples of tools that I have used in Perl:

* Create multiple users from a CSV file generated from MS Excel.  Works
   great when someone asks for 100 users to be created.

* Monitor databases for SNIPED sessions then KILL them.

* Monitor  the alert.log for Errors and mail to DBA's and or selectect
other individuals.  Errors can be filtered by type and selectively
mailed.
I've used this for duhvelopers that don't want to be bothered with
error trapping and send hundreds of emails to the DBA's due to their
error messages.  Que's up messages for 5 minutes or 100 messages,
whichever comes first ( avoids swamping the mail server in a crisis )

*  How about a way to serve up passwords to users for use with command
line utilities in a secure manner?  Oh wait, I don't have that one yet.

As you can see, I have a wishlist too.  Lemme hear what you would like!

TIA

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).
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

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

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

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

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

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

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

RE: how to install Oracle Developer2000 on Windows98 ?

[Sonja ehovi]

Well, I remember that I had such installation problems. 
To begin with, you must have CD for Win98 . It really annoyed me when I
realized that you can't install Developer from CD for Win95/NT.
HTH,
Sonja

-Original Message-
Sent: Saturday, April 21, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


dear listers,

any body knows how to install Oracle Developer2000 on Windows98 ?

I installed it on my machine but I can't even connect to my database 

thanks in advance ,


regards,

bambang


 Bambang Setiawan 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: =?windows-1250?Q?Sonja_=8Aehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

Drop table problem

[Ramasamy, Baskar]

Hi

Could anyone tell me how to solve the below problem.
I am trying to drop the table and I am getting the error ora 2266. I have
disabled all the foreign key constraints also, but still I am getting the
same error,
Early response much appreciated

Baskar

-Original Message-
Sent: 23 April 2001 20:02
To: Multiple recipients of list ORACLE-L



Hello List,

For those of you that use Perl or would like to use Perl for your
regular DBA tasks, I have a request.  

Do you have any tasks you perform with a series of SQL scripts,
shell scripts, etc, that you feel are somewhat of a kludge?

Have you every asked yourself  There must be a better way to
do this?

Or do you just have a wishlist of tools that would make day to day
DBA life easier, but feel that it's too complex or unwieldy to tackle
with PL/SQL and SQL*Plus?

I'm looking for just those kinds of ideas for a project I'm working on.

No ideas too silly or complicated.  Granted, they may be too silly or
complicated to actually implement, but you never know.  No idea is
a bad idea until it's thought through.

Come to think of it, the same holds true for good ideas also.

Anyway, let's hear it!

Some examples of tools that I have used in Perl:

* Create multiple users from a CSV file generated from MS Excel.  Works
  great when someone asks for 100 users to be created.

* Monitor databases for SNIPED sessions then KILL them.  

* Monitor  the alert.log for Errors and mail to DBA's and or selectect
   other individuals.  Errors can be filtered by type and selectively
mailed.
   I've used this for duhvelopers that don't want to be bothered with 
   error trapping and send hundreds of emails to the DBA's due to their
   error messages.  Que's up messages for 5 minutes or 100 messages,
   whichever comes first ( avoids swamping the mail server in a crisis )

*  How about a way to serve up passwords to users for use with command
   line utilities in a secure manner?  Oh wait, I don't have that one yet.

As you can see, I have a wishlist too.  Lemme hear what you would like!

TIA

Jared

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

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

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

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

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

sort_area_size + temp tablespace extent sizing

[Adrian Roe]

Hi List,

Quick question regarding temp tablespace extent sizing.

I have always assumed that the extent size for a temporary tablespace needs
to be equal to the size that sort_area_size is set to. A sort that can't fit
into memory then goes and grabs temp tablespace extents of a size equal to
sort_area_size. However, I have read somewhere that the extent size should
be equal to sort_area_size + block size (the block being used for header
infomation or something like that) eg. 8k block size and 64k sort area size
results in 72K temp tablespace extent size.

So, assume I have a sort area size of 128K and block size of 8k, do I need
to set temp tablespace extent sizes to 128K or 136K, or doesn't it really
matter.

Thanks,

Ade


--
The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer

==

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

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

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

ORA-01458

[Sonja ehovi]

Hi all!
Oracle 8.1.7 on WinNT.
When I try to copy one table from one schema to another I get this error
message.
ORA-01458: invalid length inside variable character string

Description is "very informative"
01458, 0, "invalid length inside variable character string"
// *Cause:
// *Action:

This is what I did:
copy from [EMAIL PROTECTED]
to [EMAIL PROTECTED]
create abc using select * from abc;

Do you have any suggestions?
TIA,
Sonja

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mark Leith]

Care to elaborate on ZBR for those of us with enquiring minds and absolutely
no idea what you are on about :)

Cheers

Mark

-Original Message-
Sent: Tuesday, April 24, 2001 01:56
To: Multiple recipients of list ORACLE-L


 Ed,

Ever since ZBR, the need to use the outside of the disk ( to
reduce seeks ) is significantly reduced.

Ross

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/24/2001 12:00 AM

Dick,

Thanks!

SAME also suggests using the outer half of each disk for data
storage...as
I/O performance is increased due to the natural circular shape of the
platter.  My question...how do you specify which sections of each disk
are
utilized?  From what I've been able to read, I'm guessing that hyper
volumes could be used for this??  I'm not sure...haven't had the
opportunity to play with this yet.  Anyone have an answer for this?

Ed Haskins
Oracle DBA
Verizon Wireless



-Original Message-
Sent: Friday, April 20, 2001 5:04 PM
To: Haskins; Ed; Multiple recipients of list ORACLE-L


ED,

Damn good question!  No I won't take it as sarcastic at all.

Now to your point:  We had to implement this particular strategy
about 4
years ago due to the vendor we bought a disk array from (IPL).  They
were
somewhat ahead of the curve here.  Simple theory, they configured the
30GB
array
as one very large disk drive with all of the disks striped and mirrored.
Simply
put the SAME principle.  Problem, there was only one SCSI channel into
the
array, OOPS, bottle neck par excellence!  Again not too far in the
recent
past
we did a similar thing with some EMC disk, but this time we used 4 SCSI
cables
with EMC's Power Path software.  OH FUDGE, the 4 hyper volumes were all
on
the
same spindle, Damn, bottle neck par excellence again.

So as you can see, it makes a wonderful theory, but I haven't seen
the
pudding, yet.  Still trying!

Dick Goulet

Reply Separator
Author: Haskins; Ed [EMAIL PROTECTED]
Date:   4/20/2001 9:25 AM

Dick,

Don't take this the wrong way...it's NOT meant to be sarcastic:

You said SAME is a great theory, but I can't and haven't seen it
perform
well in practice, yet.

My question to you:  Have you seen it in practice at all?  An actual
working
implementation?

For that matter; has ANYONE seen it implemented in a production
environment?
I'm sure it must be somewhere, but I'm curious if anyone knows where.

This is a subject that I'm really into right now...that's why I'm
prodding a
bit!

Thanks,

Ed Haskins
Oracle DBA
Verizon Wireless



-Original Message-
Sent: Friday, April 20, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L


Steve,

I heard about this SAME philosophy at the last NorthEast Oracle
Users
Group
meeting from a individual who works on the utilities for Oracle in the
New
England Development Office.  Although we did not get deeply into the
philosophy,
I'll agree that it is not the silver bullet, actually it can become a
performance detractor.  The individual who wrote the paper for Oracle
(Anjo
Kolk) is a LONG time Oracle person, actually wrote the core of the
kernel,
so I
believe he's probably writing from a purely theoretical point of view.
In
that
light what he's saying would be true, stripe  mirror everything and
theoretically you should never have an io bottleneck.  BUT, many
hardware
platforms don't handle mirroring very well unless your using a disk
array
like
EMC's.  Now that handles the mirror internally so we've alleviated that
problem,
but EMC likes to break their drives into 'hyper volumes' so your
stripping
may
or may not be across physical drives.  Also your stripes can still have
the
bottle neck of the number of SCSI cards in the computer.  In any case
taking
a
little time to insure that redo logs, archive logs, indexes, and data
are
all
REALLY spread out across devices is the only way to go.  SAME is a great
theory,
but I can't and haven't seen it perform well in practice, yet.

Dick Goulet

Reply Separator
Author: Steve Adams [EMAIL PROTECTED]
Date:   4/19/2001 11:25 PM

Hi All,

The author (Anjo Kolk) is an advocate of SAME (stripe and mirror
everything).
The SAME philosophy is that everything should be striped across all
the
disks
available. Separating indexes from their tables is contrary to that
philosophy.
I don't agree with it, but that's where he's coming from anyway.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 20 April 2001 6:56
To: Multiple recipients of list ORACLE-L


Whoaaa, I sure hope someone can, because I have never heard that before?
Kev

-Original Message-
Ghosalkar
Sent: Thursday, April 19, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


Guys,

i was checking my statspack report on oraperf and i came across this
statement.

Never split index and data files to different sets of disks.

can 

Re: HYPER VOLUMES - RE: Never split index and data files ...

[Nuno Souto]

- Original Message - 


 Ever since ZBR, the need to use the outside of the disk ( to
 reduce seeks ) is significantly reduced. 
 

PMFJI.
The reason for using the outside of the disk is the increased 
linear velocity there re the heads. Larger circle, same angular 
velocity, larger linear velocity.  Which means you get faster 
read data transfer rate.  Nothing at all to do with reducing 
seeks.  What you end up with is less rotational latency and 
significantly faster (up to 30% best case) data transfer speed 
from the silver to the disk cache.  From there on to the disk 
controller and the buffers, it's all the same.

This was explained to me by a guy that works on firmware
for Seagate.  He sent me the best disk speed measure program
I've ever seen!

Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den


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

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

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

Listener.log

[Nguyen Thanh-truc]

Hello everyone,

After moving the listener.log and compressed, there is no more log for the 
listener. Could anyone help me please ? Thanks.

Nguyen 

pool package from database

[Gregory Faktor]

Hi All!
I looking for script witch will extract package and package body from
user_source view  and generate create or replace package  and create or
replace package body scripts.
Thanks.
Greg.

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

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

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

Oracle vs DB2

[Dennis Taylor]

Disclaimer: I am *not* trying to start a religious war, and I am *not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer
to determine our future direction. Here's a datum that makes a significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet through
a web page, you have to buy an unlimited-user enterprise license. We had a
senior sales person in our office yesterday, and we asked this question a
number of different ways. He bobbed and he weaved, but he did not deny it.
And the quote he supplied afterwards does not address the issue at all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1
user), and something called WE Internet Access, for a total price of $6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

RE: MTSCost based Optimzer

[Rachel Carmichael]

definitely all or nothing -- if you have analyzed the large table and join 
it to an unanalyzed small table, you are going to get rule based


From: Tim Sawmiller [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 07:51:18 -0800

I wouldn't... analyze all or nothing...

  [EMAIL PROTECTED] 04/24/01 09:46AM 
How would you decide that out of total big and small tables (say 1500) 
these
are the tables need to be analysed and these are not, as in our case
Transaction types are both OLTP and DSS ??


-Original Message-
Carmichael
Sent: Tuesday, April 24, 2001 6:46 PM
To: Multiple recipients of list ORACLE-L



turning on cost-based is easy:  set the optimizer_mode parameter to choose
in your init.ora, stop and start your database and then analyze all your
tables.

HOWEVER (and this is a biggie) this will not automatically make all your
queries run faster. You will need to examine each and every query to see if
it needs to be rewritten to take advantage of CBO. In fact, sometimes there
are queries that run faster in rule-based, and I have had to include hints
in queries to force the optimizer to run rule.

 From: Venkat_Kalepalli [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: MTSCost based Optimzer
 Date: Tue, 24 Apr 2001 02:25:25 -0800
 
   Hello folks!
  
   I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement 
MTS
   on the Oracle server.  Next we are running with Rule based optimizer 
and
   we want to change to costbased optimizer.
  
   I want to know what are the advantages we get on this and what are the
   steps to implement this?
  
   Any help is grateful...
  
   Rgd
   Venkat
   DBA.
  
  
  

_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Tim Sawmiller
   INET: [EMAIL PROTECTED]

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

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

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

-- 
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: cdump, bdump, udump

[David A. Barbour]

Sinardy,

Some logs are generated by default (alert_SID.log) but actions
triggering entries can be adjusted through either initialization
parameters in the initSID.ora file, via commands issued by the DBA, or
by users who have been granted specific privileges/roles (commands like
ALTER DATABASE, ALTER SESSION and the dbms_trace package come to mind
here).

If you were able to get the doc on OFA, you now need to go and get the
docs on Initialization Parameters and Oracle Supplied Packages as a
minimum. 

Regards,

David A. Barbour
Oracle DBA

Sinardy Xing wrote:
 
 Hi all,
 
 When those logs will created ?
 
 Thank you
 
 Sinardy
 
 -Original Message-
 Sent: Tuesday, 24 April 2001 9:41 AM
 To: LazyDBA mailing list
 
 Hi DBAs and SAs,
 
 I had a task to do housekeep ...\bdump\alertSID.log
 What logs usually Oracle system need to housekeep, and what are these
 directory
 cdump,
 bdump and
 udump
 for ?
 
 Thank you for your time
 
 Sinardy
 
 
 Think you know someone who can answer the above question? Forward it to
 them!
 to unsubscribe, send a blank email to [EMAIL PROTECTED]
 to subscribe send a blank email to [EMAIL PROTECTED]
 Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
 Tell yer mates about http://www.farAwayJobs.com
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sinardy Xing
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

RE: Listener.log

[Mark Leith]

Moving 
the listenet.log file will not stop the listener to stop writing to this file 
(like the alertSID.log), you will either need to start  stop the listener 
(if you get a chance to) or there is another lsnrctl command; something like: 
lsnrctl listener_name reload, which will reload the listener and force it to 
create a new log file in its proper directory.

HTH

Mark

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Nguyen Thanh-trucSent: 
  Tuesday, April 24, 2001 04:47To: Multiple recipients of list 
  ORACLE-LSubject: Listener.log
  Hello everyone,
  
  After moving the listener.log and compressed, there is no more log for 
  the listener. Could anyone help me please ? Thanks.
  
  Nguyen 

RE: Oracle vs DB2

[Boivin, Patrice J]

Well,

This is on topic - www.wired.com http://www.wired.com  today has an
article re. IBM announced that it is buying Informix for $1Billion.

Ah, if only I had that kind of money myself - I could take more Oracle
courses!

I don't know what will happen with Informix then, does that mean they will
gobble it up and DB2 will be the only option in a couple of years?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 24, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Oracle vs DB2

Disclaimer: I am *not* trying to start a religious war, and I am
*not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs
SQLServer
to determine our future direction. Here's a datum that makes a
significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet
through
a web page, you have to buy an unlimited-user enterprise license. We
had a
senior sales person in our office yesterday, and we asked this
question a
number of different ways. He bobbed and he weaved, but he did not
deny it.
And the quote he supplied afterwards does not address the issue at
all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition
(1
user), and something called WE Internet Access, for a total price of
$6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line
with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

RE: cdump, bdump, udump

[Yosi]

Wow. I feel just the opposite. When I had the paper docs, I could
take one on the train, take it home, know what I read, feel like
I'd accomplished something when I'd read a chunk, etc. I had a
relationship with the books, my tuning guide had a corner bent, the
app dev guide was missing a cover. 

With this electronic stuff, I can't 'sit down and study', I find
its hard to get a feel of what I should read because it all looks
and feels the same.

I really miss the hard copy docs.

My two pence.

Yosi


 -Original Message-
 From: Joseph S. Testa [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 8:50 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: cdump, bdump, udump
 
 
 read the tuning guide and the administrators guide.
 
 nowadays this is a valid answer now that oracle docs are 
 online, NO ONE
 HAS AN EXCUSE to not read the docs unlike back in the days 
 when you had
 to pay thousands of dollars for paper docs.
 
 joe
  Venkat_Kalepalli wrote:
  
  Hello folks!
  
  I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement
  MTS on the Oracle server.  Next we are running with Rule based
  optimizer and we want to change to costbased optimizer.
  
  I want to know what are the advantages we get on this and 
 what are the
  steps to implement this?
  
  Any help is grateful...
  
  Rgd
  Venkat
  DBA.
 
 -- 
 Joe Testa  http://www.oracle-dba.com
 Performing Remote DBA Services, need some backup DBA support?
 For Sale: Oracle-dba.com domain, its not going cheap but feel free to
 ask :)
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joseph S. 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: 
  INET: [EMAIL PROTECTED]

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

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

Re: sort_area_size + temp tablespace extent sizing

[paquette stephane]

The extent size of the temp tablespace should be a
multiple of the sort_area_size parameter + 1 block.

If your sort_area_size is 128K and if you need to go
to temp tablespace that means that 128K is not enough
so you should allocate for more than 128K.

temp extent = (sort_area_size*n)+ 1 block
   where n goes from 2 to usually 4,5
   depending on your situation



--- Adrian Roe [EMAIL PROTECTED] a écrit : 
Hi List,
 
 Quick question regarding temp tablespace extent
 sizing.
 
 I have always assumed that the extent size for a
 temporary tablespace needs
 to be equal to the size that sort_area_size is set
 to. A sort that can't fit
 into memory then goes and grabs temp tablespace
 extents of a size equal to
 sort_area_size. However, I have read somewhere that
 the extent size should
 be equal to sort_area_size + block size (the block
 being used for header
 infomation or something like that) eg. 8k block size
 and 64k sort area size
 results in 72K temp tablespace extent size.
 
 So, assume I have a sort area size of 128K and block
 size of 8k, do I need
 to set temp tablespace extent sizes to 128K or 136K,
 or doesn't it really
 matter.
 
 Thanks,
 
 Ade
 
 

--
 The information transmitted is intended only for the
 person or entity to which it is addressed and may
 contain confidential and/or privileged material.
 Statements and opinions expressed in this e-mail may
 not represent those of the company. Any review,
 retransmission, dissemination or other use of, or
 taking of any action in reliance upon, this
 information by persons or entities other than the
 intended recipient is prohibited. If you received
 this in error, please contact the sender immediately
 and delete the material from any computer
 

==
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Adrian Roe
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

Re: MTSCost based Optimzer

[David A. Barbour]

If you have the time and horsepower, analyze the database.  If not, wait
until somebody complains and run a trace/tkprof against their SQL.  You
may want to consider using histograms on selected tables.  There was a
discussion on using histograms earlier this month.  Steve Adams wrote a
script to help in identifying possible candidates for histogram
creation.  It's on his web site at:

http://www.ixora.com.au/scripts/query_opt.htm#consider_histogram

Be judicious with its use.  

In general, I've found it useful to consider running an analysis of
large tables used frequently in the select and where clauses of SQL
statements.

Regards,

David A. Barbour
Oracle DBA


Deepender Kr Gupta wrote:
 
 How would you decide that out of total big and small tables (say 1500) these
 are the tables need to be analysed and these are not, as in our case
 Transaction types are both OLTP and DSS ??
 
 -Original Message-
 Carmichael
 Sent: Tuesday, April 24, 2001 6:46 PM
 To: Multiple recipients of list ORACLE-L
 
 turning on cost-based is easy:  set the optimizer_mode parameter to choose
 in your init.ora, stop and start your database and then analyze all your
 tables.
 
 HOWEVER (and this is a biggie) this will not automatically make all your
 queries run faster. You will need to examine each and every query to see if
 it needs to be rewritten to take advantage of CBO. In fact, sometimes there
 are queries that run faster in rule-based, and I have had to include hints
 in queries to force the optimizer to run rule.
 
 From: Venkat_Kalepalli [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: MTSCost based Optimzer
 Date: Tue, 24 Apr 2001 02:25:25 -0800
 
   Hello folks!
  
   I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement MTS
   on the Oracle server.  Next we are running with Rule based optimizer and
   we want to change to costbased optimizer.
  
   I want to know what are the advantages we get on this and what are the
   steps to implement this?
  
   Any help is grateful...
  
   Rgd
   Venkat
   DBA.
  
  
  
 
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.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).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Deepender Kr Gupta
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

Re: Fwd: Re: Where can I find real-life-examples about ORACLE

[Dennis Taylor]

At 12:25 AM 4/24/01 -0800, you wrote:
do a star join on their tables it will snow cows. 


Bwahh hahah! Thanks for the morning laugh. I've never heard that particular
expression before.


Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

RE: cdump, bdump, udump

[Gogala, Mladen]

I'm taking yoga classes and being much happier and less cynical, I'm
much less inclined to reply with RTFM, despite the fact that this 
question more then deserves such an answer.

-Original Message-
Sent: Tuesday, April 24, 2001 12:40 AM
To: Multiple recipients of list ORACLE-L


Uh oh - here's one for Mladen.  Sinardy, have you ever heard of OFA? 
Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */

David A. Barbour
Oracle DBA

Sinardy Xing wrote:
 
 Hi DBAs and SAs,
 
 I had a task to do housekeep ...\bdump\alertSID.log
 What logs usually Oracle system need to housekeep, and what are these
 directory
 cdump,
 bdump and
 udump
 for ?
 
 Thank you for your time
 
 Sinardy
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sinardy Xing
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Haskins, Ed]

Here's some info I was able to dig up!

Ed Haskins
Oracle DBA
Verizon Wireless


Zoned Bit Recording

One way that capacity and speed have been improved on hard disks over time
is by improving the utilization of the larger, outer tracks of the disk. The
first hard disks were rather primitive affairs and their controllers
couldn't handle complicated arrangements that changed between tracks. As a
result, every track had the same number of sectors. The standard for the
first hard disks was 17 sectors per track.

Of course, the tracks are concentric circles, and the ones on the outside of
the platter are much larger than the ones on the inside--typically double
the circumference or more. Since there is a constraint on how tight the
inner circles can be packed with bits, they were packed as tight as was
practically possible given the state of technology, and then the outer
circles were set to use the same number of sectors by reducing their bit
density. This means that the outer tracks were greatly underutilized,
because in theory they could hold many more sectors given the same linear
bit density limitations.

To eliminate this wasted space, modern hard disks employ a technique called
zoned bit recording (ZBR), also sometimes called multiple zone recording or
even just zone recording. With this technique, tracks are grouped into zones
based on their distance from the center of the disk, and each zone is
assigned a number of sectors per track. As you move from the innermost part
of the disk to the outer edge, you move through different zones, each
containing more sectors per track than the one before. This allows for more
efficient use of the larger tracks on the outside of the disk.

More (http://www.pcguide.com/ref/hdd/geom/tracksZBR-c.html)
--
Placing Data at the Beginning of ZBR Disks
Data is most quickly transferred when it is located at the beginning of
zone-based recording (ZBR) disks. Placing data at the beginning of these
disks improves the bandwidth for sequential data transfers. 
---
Disk geometry refers to how sectors and tracks are organized for each
cylinder in a disk drive. The UFS organizes itself to use disk geometry
efficiently. If slices in a concatenated metadevice have different disk
geometries, DiskSuite uses the geometry of the first slice. This fact may
decrease the UFS file system efficiency. 

Note - Disk geometry differences do not matter with disks that use Zone Bit
Recording (ZBR), because the amount of data on any given cylinder varies
with the distance from the spindle. Most disks now use ZBR. 

Use Outer Disk Cylinders First
Because of the Zone Bit Recording (ZBR) technology used by Sun, outer
cylinders tend to outperform inner cylinders. The outer cylinders are
cylinders 0, 1, and 3, as opposed to 4, 5, 6, and 7.

CAUTION: Remember, don't use cylinder 2, the overlap cylinder, because it
retains the total size of the disk. Some programs are baffled when this
cylinder gets changed. 





-Original Message-
Sent: Tuesday, April 24, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L


- Original Message - 


 Ever since ZBR, the need to use the outside of the disk ( to
 reduce seeks ) is significantly reduced. 
 

PMFJI.
The reason for using the outside of the disk is the increased 
linear velocity there re the heads. Larger circle, same angular 
velocity, larger linear velocity.  Which means you get faster 
read data transfer rate.  Nothing at all to do with reducing 
seeks.  What you end up with is less rotational latency and 
significantly faster (up to 30% best case) data transfer speed 
from the silver to the disk cache.  From there on to the disk 
controller and the buffers, it's all the same.

This was explained to me by a guy that works on firmware
for Seagate.  He sent me the best disk speed measure program
I've ever seen!

Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Haskins, Ed
  INET: [EMAIL PROTECTED]

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

MTS and Cost Based Analyzer

[David A. Barbour]

Why would you be looking to change/implement something if you're not
aware of the advantages/disadvantages?  

Changing to the cost based optimizer requires that both the DBA(s) and
the Developer(s) understand how and why it works.  Although a simple
change to your initSID.ora file (yet another reference to that pesky
animal) will enable cost based optimization, you'll probably need to set
up some maintenance tasks (table/schema/database analysis comes to mind)
and review slow running SQL to see how the change has affected some of
your queries.  There are additional initialization parameters you may or
may not want to set in connection with the change. 

MTS is enable through another initialization parameter (I'd go to OTN
and print out the doc on Initialization Parameters and become VERY
familiar with it).  There are however numerous other considerations,
including client configuration and setup of your listener.  Again, go to
OTN and check out the docs.

Regards,

David A. Barbour
Oracle DBA

 Venkat_Kalepalli wrote:
 
 Hello folks!
 
 I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement
 MTS on the Oracle server.  Next we are running with Rule based
 optimizer and we want to change to costbased optimizer.
 
 I want to know what are the advantages we get on this and what are the
 steps to implement this?
 
 Any help is grateful...
 
 Rgd
 Venkat
 DBA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

RE: sort_area_size + temp tablespace extent sizing

[DEMANCHE Luc (Cetelem)]

Title: RE: sort_area_size + temp tablespace extent sizing





Stephane,


What situation would make you choose a certain value (i.e.: using '3' versus '4.5')?


-Message d'origine-
De: paquette stephane [mailto:[EMAIL PROTECTED]]
Date: Tuesday, April 24, 2001 6:03 PM
À: Multiple recipients of list ORACLE-L
Objet: Re: sort_area_size + temp tablespace extent sizing



The extent size of the temp tablespace should be a
multiple of the sort_area_size parameter + 1 block.


If your sort_area_size is 128K and if you need to go
to temp tablespace that means that 128K is not enough
so you should allocate for more than 128K.


temp extent = (sort_area_size*n)+ 1 block
 where n goes from 2 to usually 4,5
 depending on your situation




--- Adrian Roe [EMAIL PROTECTED] a écrit : 
Hi List,
 
 Quick question regarding temp tablespace extent
 sizing.
 
 I have always assumed that the extent size for a
 temporary tablespace needs
 to be equal to the size that sort_area_size is set
 to. A sort that can't fit
 into memory then goes and grabs temp tablespace
 extents of a size equal to
 sort_area_size. However, I have read somewhere that
 the extent size should
 be equal to sort_area_size + block size (the block
 being used for header
 infomation or something like that) eg. 8k block size
 and 64k sort area size
 results in 72K temp tablespace extent size.
 
 So, assume I have a sort area size of 128K and block
 size of 8k, do I need
 to set temp tablespace extent sizes to 128K or 136K,
 or doesn't it really
 matter.
 
 Thanks,
 
 Ade
 
 

--
 The information transmitted is intended only for the
 person or entity to which it is addressed and may
 contain confidential and/or privileged material.
 Statements and opinions expressed in this e-mail may
 not represent those of the company. Any review,
 retransmission, dissemination or other use of, or
 taking of any action in reliance upon, this
 information by persons or entities other than the
 intended recipient is prohibited. If you received
 this in error, please contact the sender immediately
 and delete the material from any computer
 

==
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Adrian Roe
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX:
 (858) 538-5051
 San Diego, California -- Public Internet
 access / Mailing Lists


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



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


___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
 INET: [EMAIL PROTECTED]


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

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

RE: Listener.log

[Gogala, Mladen]

touch $ORACLE_HOME/network/log/listener.log 

-Original Message-
Sent: Tuesday, April 24, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


Hello everyone,
 
After moving the listener.log and compressed, there is no more log for the
listener. Could anyone help me please ? Thanks.
 
Nguyen 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 - spool file name - use variable

[Gogala, Mladen]

How about spool report_id.dat ?

-Original Message-
Sent: Monday, April 23, 2001 6:22 PM
To: Multiple recipients of list ORACLE-L



I'm writing a sql script file (first run couple of queries, insert results
into a temp table), at last, the data need to spool out to separate files.
the requirement was want the report name to be able to change depend on the
query. Therefore, I have a variable in the temp table. Now I want to be able
to enclose this variable name in my report name. like:

temp table has: report_id, division, room ...

So, the report will like:

SPOOL C:\c\CYCLE_COUNT_${REPORT_id}.DAT  ... ( for report 1)

SPOOL C:\c\CYCLE_COUNT_${REPORT_id}.DAT ... ( for report 2)

however,  when I'm coding now, the '${REPORT_id} is unknown. The value
variable will get at run time. I don't know how to be dynamic.

Hope I explain better this time. Thanks a lot.


  Diego Cutrone [EMAIL PROTECTED] wrote: 







Hi,

 

 

I don't quite understand your question, so here's what I understood:

 

Just enclose the variable name with { } , here's an example

 

/home/oracle export temp_variable=TEST
/home/oracle echo this_is_a_$temp_variable_only
this_is_a_
-- wrong
/home/oracle echo this_is_a_${temp_variable}_only
this_is_a_TEST_only
/home/oracle

 

Hope it helps



- Original Message - 


To: Multiple  mailto:[EMAIL PROTECTED] recipients of list ORACLE-L 

Sent: Monday, April 23, 2001 2:50 PM





 Hello: 



I'm trying to spool out couple of files from my temp table. Part of the file
name is coming from a variable from the temp table. I use: 



spool C:\CYCLE_COUNT_$temp_variable.DAT 



but it's only one physical name instead of using the variable. 



How can I code the variable name as part of (spool) file name? 



Thanks 



 






  _  


Do You Yahoo!?
Yahoo!  http://auctions.yahoo.com/ Auctions - buy the things you want at
great prices




  _  

Do You Yahoo!?
Yahoo!  http://auctions.yahoo.com/ Auctions - buy the things you want at
great prices

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

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

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

RE: Listener.log

[blair]

Don't worry.  Everything will be all right.  The listener.log is still cached in
memory.  The next time you bounce (cleanly) Oracle it will start a new one
listener.log.

..tom


 -Original Message-
 From: Nguyen Thanh-truc [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 11:47 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Listener.log
 
 Hello everyone,
  
 After moving the listener.log and compressed, there is no more log for the
 listener. Could anyone help me please ? Thanks.
  
 Nguyen 
-- 
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: Oracle vs DB2

[Dan . Hubler]

Why the enterprise license for Oracle?






Dennis Taylor [EMAIL PROTECTED]@fatcity.com on 04/24/2001 10:57:11 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Disclaimer: I am *not* trying to start a religious war, and I am *not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer
to determine our future direction. Here's a datum that makes a significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet through
a web page, you have to buy an unlimited-user enterprise license. We had a
senior sales person in our office yesterday, and we asked this question a
number of different ways. He bobbed and he weaved, but he did not deny it.
And the quote he supplied afterwards does not address the issue at all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1
user), and something called WE Internet Access, for a total price of $6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Tim Sawmiller]

Thank you for the very informative and detailed explanation.

 [EMAIL PROTECTED] 04/24/01 12:51PM 
Oops, I guess I was just too obtuse and brief. Sorry 'bout that!

Here is an amplification and correction of what I sent another lister 
who contacted me offline.

Folks, please feel free to correct and amend if you know more/better.

thanks!

Ross


#

Zone-Based Recording, or ZBR refers to the increase in the number of
sectors per 
track within a given annular ring ( or zone ) on a disk. Why is this done?

Since a disk spins at constant angular velocity, the *linear* velocity under
the
R/W heads increases as the head moves from the spindle to the outer rim (
track 0).

In OLD disks, there was no ZBR, so sectors per track was CONSTANT, and
streaming
data rate was constant across the disk. In current disks, the disk is
divided by
hardware manufacturers into cylindrical rings or zones in which the
sector per
track is constant. However, the closer the zone is to Track 0, the greater
the
number of sectors per track. A denser way of saying this is that the areal
information
density is roughly stepwise constant across the disk. This makes better use
of magnetic
real estate, but requires changes in the drive electronics ( which has to
map a 
zone-dependent number of sectors per track now ) and their speed ( linear
speed at
Track 0 can be 10x that near the spindle, and the streaming data rate is
correspondingly
higher).

What is the upshot for databases?

Well, for STREAMING I/O...full table scans, index range scans, and the like,
putting data
on the OUTSIDE of the disk is better -- the throughput is fastest there. 

For random, small OLTP I/O there is a slight preference for the middle or
inner parts
of the disks. Why?  Because access time ( once you have the head's attention
) is a combination
of seek ( find the track ) and latency ( wait for the sectors to spin under
the stationary
head ) times. Track-to-track seek times are constant across the disk, but
under random I/O
you are more likely to *need* to seek when near the spindle. Access times
increase linearly
from the spindle out. So, for OLTP hits, time-averaged seek times DECREASE
from the spindle
out, and access times INCREASE from the spindle out, making a sweet spot
for OLTP near
roughly near the center of the disk. 

The kicker isthis stuff used to matter enormously. Now, with the advent
of larger
and smarter on disk cache...controller cachehigher disk speeds...smaller
disk form
factors...all of these pure disk geometry considerations take less and less
precedence in tuning. 

Having said that, if I was streaming video from my DB, or doing pure
long-haul OLAP/DSS work, and
needed every last scrap of juice out of the lemon, i'd stay near the outside
of the disks. 
Contrariwise, if i were doing pure, random, small transaction OLTP, i'd put
data and index
near the spindle and middle, and the TEMP, ROLL, and log files near the
outsides.

As for filesystem and disk optimizations in general, the smarter OSes under
stand which files
are sequentially and frequently accessed, and put these near track 0. Those
less frequently used
may be stored near the spindle. 


'nuff said!






|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]] 
|| Sent: Tuesday, April 24, 2001 10:36 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: HYPER VOLUMES - RE: Never split index and data 
|| files ...
|| 
|| 
|| Care to elaborate on ZBR for those of us with enquiring 
|| minds and absolutely
|| no idea what you are on about :)
|| 
|| Cheers
|| 
|| Mark
|| 
|| -Original Message-
|| Sent: Tuesday, April 24, 2001 01:56
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
||  Ed,
|| 
|| Ever since ZBR, the need to use the outside of the disk ( to
|| reduce seeks ) is significantly reduced.
|| 
|| Ross
|| 
|| -Original Message-
|| To: Multiple recipients of list ORACLE-L
|| Sent: 4/24/2001 12:00 AM
|| 
|| Dick,
|| 
|| Thanks!
|| 
|| SAME also suggests using the outer half of each disk for data
|| storage...as
|| I/O performance is increased due to the natural circular shape of the
|| platter.  My question...how do you specify which sections of 
|| each disk
|| are
|| utilized?  From what I've been able to read, I'm guessing that hyper
|| volumes could be used for this??  I'm not sure...haven't had the
|| opportunity to play with this yet.  Anyone have an answer for this?
|| 
|| Ed Haskins
|| Oracle DBA
|| Verizon Wireless
|| 
|| 
|| 
|| -Original Message-
|| Sent: Friday, April 20, 2001 5:04 PM
|| To: Haskins; Ed; Multiple recipients of list ORACLE-L
|| 
|| 
|| ED,
|| 
|| Damn good question!  No I won't take it as sarcastic at all.
|| 
|| Now to your point:  We had to implement this particular strategy
|| about 4
|| years ago due to the vendor we bought a disk array from (IPL).  They
|| were
|| somewhat ahead of the curve here.  

RE: Oracle on NT/2000 Service shutdown

[Kimberly Smith]

I have not noticed this with Win 2000 but I have noticed it on HP.
Granted the machine we are running it on is quicker then the one 
with 8.0.6 but it was very quick to fail over to the other server.
Up and down quick.

-Original Message-
Sent: Tuesday, April 24, 2001 3:40 AM
To: Multiple recipients of list ORACLE-L


As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

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

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

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

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

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

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

[Murali Vallath]

Boivin,

Not true, when Oracle purchased Rdb from Digital 10 years ago. This was the 
talk, Rdb will die in 7 years.

Today it is being enhanced every version/release.

SO DON'T KNOW, what IBM will do.

Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 24 Apr 2001 08:45:27 -0800

Well,

This is on topic - www.wired.com http://www.wired.com  today has an
article re. IBM announced that it is buying Informix for $1Billion.

Ah, if only I had that kind of money myself - I could take more Oracle
courses!

I don't know what will happen with Informix then, does that mean they will
gobble it up and DB2 will be the only option in a couple of years?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 24, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Oracle vs DB2

Disclaimer: I am *not* trying to start a religious war, and I am
*not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs
SQLServer
to determine our future direction. Here's a datum that makes a
significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet
through
a web page, you have to buy an unlimited-user enterprise license. We
had a
senior sales person in our office yesterday, and we asked this
question a
number of different ways. He bobbed and he weaved, but he did not
deny it.
And the quote he supplied afterwards does not address the issue at
all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition
(1
user), and something called WE Internet Access, for a total price of
$6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line
with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

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

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

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

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

RE: ORA-01458

[Vadim Gorbounov]

Sonja, this is bug. Promised to be fixed in 8.1.6, and back again :(
Workaround is to 
create table .. as select ..  OR simply create table,  than insert...
HTH
Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Tuesday, April 24, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L


Hi all!
Oracle 8.1.7 on WinNT.
When I try to copy one table from one schema to another I get this error
message.
ORA-01458: invalid length inside variable character string

Description is "very informative"
01458, 0, "invalid length inside variable character string"
// *Cause:
// *Action:

This is what I did:
copy from [EMAIL PROTECTED]
to [EMAIL PROTECTED]
create abc using select * from abc;

Do you have any suggestions?
TIA,
Sonja

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

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

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

OT RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mohan, Ross]

Title: OT RE: HYPER VOLUMES - RE: Never split index and data files ...





Zymurgy Beats Recidivism?


|| -Original Message-
|| From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 11:51 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: HYPER VOLUMES - RE: Never split index and data 
|| files ...
|| 
|| 
|| Zebra Boisterous Rout
|| Zebra Blues Routine
|| 
|| Hmm it's hard to come up with meaninful acronyms, usually 
|| it's easier...
|| 
|| : )
|| 
|| Patrice Boivin
|| Systems Analyst (Oracle Certified DBA)
|| 
|| 
|| 
||  -Original Message-
||  From: Mark Leith [SMTP:[EMAIL PROTECTED]]
||  Sent: Tuesday, April 24, 2001 11:35 AM
||  To: Multiple recipients of list ORACLE-L
||  Subject: RE: HYPER VOLUMES - RE: Never split 
|| index and data
|| files ...
|| 
||  Care to elaborate on ZBR for those of us with enquiring 
|| minds and
|| absolutely
||  no idea what you are on about :)
|| 
||  Cheers
|| 
||  Mark
|| 
||  
|| -- 
|| 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: MTSCost based Optimzer

[Rachel Carmichael]

Well, I was on 7.3.4 at the time.. so stored outlines were not an option. I 
haven't used them since, as the 8i databases I have are all new and we coded 
for cost-based to begin with.

Rachel


From: Mark Leith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 08:21:57 -0800

Rachel

I recently heard about something called a Stored Outline that supposedly 
can
be used to lock the execution path that a query runs with. One of the uses
of this was apparently to aid people moving from rule to cost based
optimisation, where the rule execution path may be the better option to go
down.

Did/have you looked at these as an alternative to the hint? I am curious to
see if anybody has used this option and what feedback they may have?

Cheers

Mark

-Original Message-
Carmichael
Sent: Tuesday, April 24, 2001 02:16
To: Multiple recipients of list ORACLE-L



turning on cost-based is easy:  set the optimizer_mode parameter to choose
in your init.ora, stop and start your database and then analyze all your
tables.

HOWEVER (and this is a biggie) this will not automatically make all your
queries run faster. You will need to examine each and every query to see if
it needs to be rewritten to take advantage of CBO. In fact, sometimes there
are queries that run faster in rule-based, and I have had to include hints
in queries to force the optimizer to run rule.

 From: Venkat_Kalepalli [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: MTSCost based Optimzer
 Date: Tue, 24 Apr 2001 02:25:25 -0800
 
   Hello folks!
  
   I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement 
MTS
   on the Oracle server.  Next we are running with Rule based optimizer 
and
   we want to change to costbased optimizer.
  
   I want to know what are the advantages we get on this and what are the
   steps to implement this?
  
   Any help is grateful...
  
   Rgd
   Venkat
   DBA.
  
  
  

_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

2 RMAN questions

[Glasrot, Nechama]

hi listers ...
1/ i had to delete archived logs before i could back them up thru rman ...my
? is how do i notify rman that these logs no longer exist ... do i
crosscheck (mark as expired) all previous logs and then issue a complete
resynch ... or do i just resynch ... or ?

2/ i am changing the archived logs destination ... is it sufficient to
shutdown and restart the database, and then take a backup thru rman ... or
do i need to do something else ...

i am having trouble finding documentation that addresses these issues
specifically ... so tia for help and/or place to research ...

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 
nglasrot @seisint.com mailto:[EMAIL PROTECTED]  
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695


This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you


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

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

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

RE: Listener.log

[Vadim Gorbounov]

Hello, 

You 
have to restart your listener. It continues towrite to "invisible" file 
(inode without any reference from directories). Welcome to 
UNIX.
HTH
Vadim 
Gorbounov
Oracle 
DBA 


  -Original Message-From: Nguyen Thanh-truc 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 11:47 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Listener.log
  Hello everyone,
  
  After moving the listener.log and compressed, there is no more log for 
  the listener. Could anyone help me please ? Thanks.
  
  Nguyen 

Grumble - OTN is now as ugly as Oracle.com

[Yosi]

WHINE MODE

Why do they insist on making these sites unreadable,
blinding to the eye, and so on? There's nowhere on
the NEW! OTN to rest your eye, to focus, to stabilize,
etc...

Why would anyone want their site to look like this?

/WHINE MODE

Sorry, and thanks for letting me vent (like you had
a choice...)

Yosi
-- 
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: Perl DBA Tools

[Jared Still]

On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote:
 truncating listener logs -- or even starting a secondary listener, stopping
 the one with the log that is too large and removing the log, then
 restarting the original listener


Good idea.  Thanks Rachel

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: Awfully annoying SQLLDR problem

[David A. Barbour]

Tom,

Just cogitating and ruminating...

You mentioned that you're executing the load as part of a larger
procedure.  Couldn't you execute a shell script that would ftp the file
to the target server and run sqlldr via rsh -c?  Another thought would
be to have the target file on an NFS-mounted drive that could be
accessed by the target and have sqlldr kicked off on the target via a
trigger on a simple insert by the source into a DATA_LOAD_REQUIRED table
on the target?   

Regards,

David A. Barbour
Oracle DBA

[EMAIL PROTECTED] wrote:
 
 Thank you ever-so-much to Tim, Kirk, Peter, and especially Kirti for your
 intelligent responses.  I'm going to open a TAR on Metalink.  I'll probably get
 the quick and easy response We don't support it anymore.  I'm no fan of Oracle
 but would not blame them for giving me that response.
 
 We will have upgraded our source database to 8.1.6.2 by mid July.  Perhaps my
 project will have to wait till then.
 
 thanks again,
 
 ..tom
 
  -Original Message-
  From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
  Sent: Monday, April 23, 2001 3:08 PM
  To:   Multiple recipients of list ORACLE-L
  Subject:  RE: Awfully annoying SQLLDR problem
 
  The missing verb is think, as in I don't think you can avoid
 
   [EMAIL PROTECTED] 04/23/01 02:46PM 
  I don't you *can* avoid the larger issue.  Oracle 8 has undergone some radical
  changes underneath the covers.  I would expect SQLLDR to have changed just as
  radically...
 
   [EMAIL PROTECTED] 04/23/01 02:06PM 
  No you are reading correctly.  I have the data on a server with a 7.3.2.3
  database and am using that databases' binary sqlldr to load into the 8.1.5
  database.  The problem is a timing issue.  I need to execute the load from the
  7.3.2.3 server as part of a larger script.  I cannot ensure that the load will
  be executed i a timely manner if it is run on the distant server.
 
  Whether or not you agree with the timing issue I describe, I'd really
  appreciate
  an answer to the Oracle problem.  I don't want to get into the larger issue of
  why I have to run it from one server vs. another.  From an Oracle POV it
  should
  work either way.
 
  thanks,
 
  ..tom
 
 
 
   -Original Message-
   From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]]
   Sent:   Monday, April 23, 2001 12:27 PM
   To: Multiple recipients of list ORACLE-L
   Subject:RE: Awfully annoying SQLLDR problem
  
   Ok,maybe i am lazy or a poor reader, but are you
   using 732 sqlldr binaries to load an 815 db?
  
   Why not the 815 sqlldr binaries?
  
   I mean, it sounds like you have to ship data over the
   wire no matter what you do, so...why not use the latest
   version of the sqlldr bits?
  
  
  
   ==   -Original Message-
   ==   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
   ==   Sent: Monday, April 23, 2001 11:10 AM
   ==   To: Multiple recipients of list ORACLE-L
   ==   Subject: Awfully annoying SQLLDR problem
   ==
   ==
   ==   I am executing a SQLLDR shell file from a server ::
   ==   sourceserv; RDBMS 7.3.2.3
   ==   AIX 4.3.2
   ==   into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3
   ==   using a SQL*Net connect string destserv_destSID.
   ==
   ==   This connect string is defined in the local tnsnames.ora
   ==   and works.  I confirmed
   ==   this by doing sqlplus user/pass@destserv_destSID and
   ==   verifying that I am
   ==   connected to the correct instance.
   ==
   ==   The target table exists.  I am connecting as the owner
   ==   of the target table. That
   ==   owner has DBA.
   ==
   ==   but when I run
   ==
   ==   sqlldr userid=tabowner/pass@destserv_destSID
   ==   CONTROL=localcontrolfile.ctl
   ==   (controlfile is below)
   ==
   ==   I get SQL*Loader-925: Error while parsing a cursor (via ocisq3)
   ==   ORA-00942: table or view does not exist
   ==
   ==   Help!  Does anyone have any ideas?
   ==
   ==   tia,
   ==
   ==   ..tom
   ==
   ==   here's the controlfile
   ==
   ==   LOAD DATA
   ==   INFILE data1.dat BADFILE load.bad
   ==   DISCARDFILE load.dsc
   ==   INSERT
   ==   INTO TABLE OWNER.TEST_LOAD
   ==   FIELDS TERMINATED BY ','
   ==   TRAILING NULLCOLS
   ==   (COL1,COL2,COL3)
   ==
   ==
   ==   --
   ==   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 

RE: cdump, bdump, udump

[Mohan, Ross]

Title: RE: cdump, bdump, udump





karma, prana, hatha, or ayurvedic yoga?


Most people just think of hatha yoga when
they talk about it. 


Ross


p.s. let me know when you can do the Royal Pigeon


|| -Original Message-
|| From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 12:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: cdump, bdump, udump
|| 
|| 
|| I'm taking yoga classes and being much happier and less cynical, I'm
|| much less inclined to reply with RTFM, despite the fact that this 
|| question more then deserves such an answer.
|| 
|| -Original Message-
|| Sent: Tuesday, April 24, 2001 12:40 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? 
|| Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */
|| 
|| David A. Barbour
|| Oracle DBA
|| 
|| Sinardy Xing wrote:
||  
||  Hi DBAs and SAs,
||  
||  I had a task to do housekeep ...\bdump\alertSID.log
||  What logs usually Oracle system need to housekeep, and 
|| what are these
||  directory
||  cdump,
||  bdump and
||  udump
||  for ?
||  
||  Thank you for your time
||  
||  Sinardy
||  
||  --
||  Please see the official ORACLE-L FAQ: http://www.orafaq.com
||  --
||  Author: Sinardy Xing
||  INET: [EMAIL PROTECTED]
||  
||  Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
||  San Diego, California -- Public Internet access / 
|| Mailing Lists
||  
|| 
||  To REMOVE yourself from this mailing list, send an E-Mail message
||  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
||  the message BODY, include a line containing: UNSUB ORACLE-L
||  (or the name of mailing list you want to be 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: David A. Barbour
|| INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be 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: Gogala, Mladen
|| INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from). You may
|| also send the HELP command for other information (like subscribing).
|| 

(Fwd) Re: OT - MIME - outbound prep utility for database appl

[Eric D. Pierce]

--- Forwarded message follows ---
F r o m : Martin Ireland  m a r t i n . i r e l a n d @ g o v . a b . c a 
Organization:   Alberta, Innovation  Science
T o : Eric D. Pierce  P i e r c e E D @ C S U S . E D U 
Date sent:  Tue, 24 Apr 2001 09:04:40 -0600

See the utility progams MPack/Munpack which will decompose a file into a Mime 
stream and reverse back to the original file. Get the programs/source from
 ftp.andrew.cmu.edu in directory /pub/mpack

HTH

Martin
==

Date sent:  Mon, 23 Apr 2001 16:29:26 -0700

Does anyone have any references to info about programmer
utilities that prepare a file in MIME format (attachment)?

This is OT in the sense that the utility would be used to
prepare an attachment for use in an internal Oracle database
application for autosending by Oracle (probably via SMTP).

Thanks/sorry for any lack of clarity,
ep

On 21 Apr 2001, at 0:00, Automatic digest processor wrote:


 There are 35 messages totalling 1531 lines in this issue.
...

--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

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

RE: cdump, bdump, udump

[Thater, William]

On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

-Wow. I feel just the opposite. When I had the paper docs, I could
-take one on the train, take it home, know what I read, feel like
-I'd accomplished something when I'd read a chunk, etc. I had a
-relationship with the books, my tuning guide had a corner bent, the
-app dev guide was missing a cover.
-
-With this electronic stuff, I can't 'sit down and study', I find
-its hard to get a feel of what I should read because it all looks
-and feels the same.
-
-I really miss the hard copy docs.
-
-My two pence.
-
-Yosi

maybe someone should convert them to Palm DOC format and we can load
them on our Palms to carry with us *everywhere*.;-)

--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Stock item: We shipped it once before, and we can do it again, probably.

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

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mohan, Ross]

My pleasure Tim. How nice of you to say soreally
I could do this once a week and never repay the value
I get from the list.

|| -Original Message-
|| From: Tim Sawmiller [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 1:27 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: HYPER VOLUMES - RE: Never split index and data 
|| files ...
|| 
|| 
|| Thank you for the very informative and detailed explanation.
|| 
||  [EMAIL PROTECTED] 04/24/01 12:51PM 
|| Oops, I guess I was just too obtuse and brief. Sorry 'bout that!
|| 
|| Here is an amplification and correction of what I sent 
|| another lister 
|| who contacted me offline.
|| 
|| Folks, please feel free to correct and amend if you know more/better.
|| 
|| thanks!
|| 
|| Ross
|| 
|| #
|| ###
|| #
|| 
|| Zone-Based Recording, or ZBR refers to the increase in the 
|| number of
|| sectors per 
|| track within a given annular ring ( or zone ) on a disk. 
|| Why is this done?
|| 
|| Since a disk spins at constant angular velocity, the 
|| *linear* velocity under
|| the
|| R/W heads increases as the head moves from the spindle to 
|| the outer rim (
|| track 0).
|| 
|| In OLD disks, there was no ZBR, so sectors per track was 
|| CONSTANT, and
|| streaming
|| data rate was constant across the disk. In current disks, the disk is
|| divided by
|| hardware manufacturers into cylindrical rings or zones in which the
|| sector per
|| track is constant. However, the closer the zone is to Track 
|| 0, the greater
|| the
|| number of sectors per track. A denser way of saying this is 
|| that the areal
|| information
|| density is roughly stepwise constant across the disk. This 
|| makes better use
|| of magnetic
|| real estate, but requires changes in the drive electronics ( 
|| which has to
|| map a 
|| zone-dependent number of sectors per track now ) and their 
|| speed ( linear
|| speed at
|| Track 0 can be 10x that near the spindle, and the streaming 
|| data rate is
|| correspondingly
|| higher).
|| 
|| What is the upshot for databases?
|| 
|| Well, for STREAMING I/O...full table scans, index range 
|| scans, and the like,
|| putting data
|| on the OUTSIDE of the disk is better -- the throughput is 
|| fastest there. 
|| 
|| For random, small OLTP I/O there is a slight preference 
|| for the middle or
|| inner parts
|| of the disks. Why?  Because access time ( once you have the 
|| head's attention
|| ) is a combination
|| of seek ( find the track ) and latency ( wait for the 
|| sectors to spin under
|| the stationary
|| head ) times. Track-to-track seek times are constant across 
|| the disk, but
|| under random I/O
|| you are more likely to *need* to seek when near the spindle. 
|| Access times
|| increase linearly
|| from the spindle out. So, for OLTP hits, time-averaged 
|| seek times DECREASE
|| from the spindle
|| out, and access times INCREASE from the spindle out, making 
|| a sweet spot
|| for OLTP near
|| roughly near the center of the disk. 
|| 
|| The kicker isthis stuff used to matter enormously. Now, 
|| with the advent
|| of larger
|| and smarter on disk cache...controller cachehigher disk 
|| speeds...smaller
|| disk form
|| factors...all of these pure disk geometry considerations 
|| take less and less
|| precedence in tuning. 
|| 
|| Having said that, if I was streaming video from my DB, or doing pure
|| long-haul OLAP/DSS work, and
|| needed every last scrap of juice out of the lemon, i'd stay 
|| near the outside
|| of the disks. 
|| Contrariwise, if i were doing pure, random, small 
|| transaction OLTP, i'd put
|| data and index
|| near the spindle and middle, and the TEMP, ROLL, and log 
|| files near the
|| outsides.
|| 
|| As for filesystem and disk optimizations in general, the 
|| smarter OSes under
|| stand which files
|| are sequentially and frequently accessed, and put these near 
|| track 0. Those
|| less frequently used
|| may be stored near the spindle. 
|| 
|| 
|| 'nuff said!
|| 
|| 
|| 
|| 
|| 
|| 
|| || -Original Message-
|| || From: Mark Leith [mailto:[EMAIL PROTECTED]] 
|| || Sent: Tuesday, April 24, 2001 10:36 AM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: HYPER VOLUMES - RE: Never split index and data 
|| || files ...
|| || 
|| || 
|| || Care to elaborate on ZBR for those of us with enquiring 
|| || minds and absolutely
|| || no idea what you are on about :)
|| || 
|| || Cheers
|| || 
|| || Mark
|| || 
|| || -Original Message-
|| || Sent: Tuesday, April 24, 2001 01:56
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| ||  Ed,
|| || 
|| || Ever since ZBR, the need to use the outside of the disk ( to
|| || reduce seeks ) is significantly reduced.
|| || 
|| || Ross
|| || 
|| || -Original Message-
|| || To: Multiple recipients of list ORACLE-L
|| || Sent: 4/24/2001 12:00 AM
|| || 
|| || Dick,
|| || 
|| || Thanks!
|| || 
|| || SAME also suggests using 

Re: Listener.log

[Ruth Gramolini]

When the listener needs to make a log entry he will create a new log.

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 11:47 AM


Hello everyone,

After moving the listener.log and compressed, there is no more log for the
listener. Could anyone help me please ? Thanks.

Nguyen


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

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

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

Re: Perl DBA Tools

[Jared Still]

On Tuesday 24 April 2001 03:40, Mark Leith wrote:

 I'm still thinking about this one - we have loads of requests for
 functionality in tools that just seem outrageous - shall I send them all to
 you in a great big list? :-)


Thanks for your thought Mark.  As for the others, go ahead
and send them, I'm open to anything.

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: cdump, bdump, udump

[Eric D. Pierce]

what's wrong with your printer? 

what's wrong with just spending a bunch of money on hardcopy
documentation like you used to do




On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote:

Date sent:  Tue, 24 Apr 2001 08:15:54 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

...
 With this electronic stuff, I can't 'sit down and study', I find
 its hard to get a feel of what I should read because it all looks
 and feels the same.
 
 I really miss the hard copy docs.
...

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

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

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

RE: Perl DBA Tools

[Toepke, Kevin M]

Run EXPLAIN PLAN... email me if you want to integrate my version in your
tool.

Kevin Toepke


-Original Message-
Sent: Tuesday, April 24, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L


On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote:
 truncating listener logs -- or even starting a secondary listener,
stopping
 the one with the log that is too large and removing the log, then
 restarting the original listener


Good idea.  Thanks Rachel

Jared

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

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

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

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

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

[Weaver, Walt]

Not true. You can use the Standard Edition for serving web pages. We're
doing it. 

Costs much less than $160,000, although still more than $6,000 Cdn.

One thing I don't get: it's $6,000 Cdn for a 1-user license, right? How is a
1-user license going to do you any good if you're serving web pages? Just
interested in how the WE Internet Access works.

We had some IBM guys in here late last year, and they couldn't give us any
better pricing than what we could get Oracle Standard Edition for.

--Walt Weaver
  Bozeman, Montana


Dennis Taylor [EMAIL PROTECTED]@fatcity.com on 04/24/2001 10:57:11 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:

With Oracle, in order to make a database accessible to the internet through
a web page, you have to buy an unlimited-user enterprise license. We had a
senior sales person in our office yesterday, and we asked this question a
number of different ways. He bobbed and he weaved, but he did not deny it.
And the quote he supplied afterwards does not address the issue at all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1
user), and something called WE Internet Access, for a total price of $6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

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

RE: Listener.log

[Patricia Ashe]

Only if the listener has been restarted after moving or removing the
listener.log
Patricia 

-Original Message-
Sent: Tuesday, April 24, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


When the listener needs to make a log entry he will create a new log.

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 11:47 AM


Hello everyone,

After moving the listener.log and compressed, there is no more log for the
listener. Could anyone help me please ? Thanks.

Nguyen


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Patricia Ashe
  INET: [EMAIL PROTECTED]

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mark Leith]

Zealous Bumf Router?

-Original Message-
Patrice J
Sent: Tuesday, April 24, 2001 04:51
To: Multiple recipients of list ORACLE-L


Zebra Boisterous Rout
Zebra Blues Routine

Hmm it's hard to come up with meaninful acronyms, usually it's easier...

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 24, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: HYPER VOLUMES - RE: Never split index and data
files ...

Care to elaborate on ZBR for those of us with enquiring minds and
absolutely
no idea what you are on about :)

Cheers

Mark


-- 
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: Mark Leith
  INET: [EMAIL PROTECTED]

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

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

RE: sort_area_size + temp tablespace extent sizing

[Deshpande, Kirti]

Hi Ade,
The formula that I use is: 
 extent size = Multiples of sort_area_size. 

 If the data file for the temp tablespace is configured with the additional
db block size for the overhead, then the remaining space would take all
possible extents without wasting any disk space. 

In your case you can consider the extent size to be some multiple of 128k,
to minimize dynamic extent allocation for the temp segments.
 
Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Adrian Roe [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 10:01 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  sort_area_size + temp tablespace extent sizing
 
 Hi List,
 
 Quick question regarding temp tablespace extent sizing.
 
 I have always assumed that the extent size for a temporary tablespace
 needs
 to be equal to the size that sort_area_size is set to. A sort that can't
 fit
 into memory then goes and grabs temp tablespace extents of a size equal to
 sort_area_size. However, I have read somewhere that the extent size should
 be equal to sort_area_size + block size (the block being used for header
 infomation or something like that) eg. 8k block size and 64k sort area
 size
 results in 72K temp tablespace extent size.
 
 So, assume I have a sort area size of 128K and block size of 8k, do I need
 to set temp tablespace extent sizes to 128K or 136K, or doesn't it really
 matter.
 
 Thanks,
 
 Ade
 
 
 --
 
 The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential and/or privileged
 material.
 Statements and opinions expressed in this e-mail may not represent those
 of the company. Any review, retransmission, dissemination or other use of,
 or taking of any action in reliance upon, this information by persons or
 entities other than the intended recipient is prohibited. If you received
 this in error, please contact the sender immediately and delete the
 material from any computer
 
 ==
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Adrian Roe
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: 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).

News flash - IBM buys Informix

[The Oracle DBA]

It has been announced today that IBM has purchased Informix. See your local tech news 
service later today for details.

H. Wonder what Larry thinks about this?


Cheers,


Earl



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

RE: sort_area_size + temp tablespace extent sizing

[Vadim Gorbounov]

Hello, Ade, 
You are right, Oracle needs one-block header, and you have to add this block
to optimize performance.
The extent size my be 
  one block + N*SORT_AREA_SIZE 
N depends on size of typical sort operations.

HTH
Vadim Gorbounov
Oracle DBA 
  

-Original Message-
Sent: Tuesday, April 24, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Hi List,

Quick question regarding temp tablespace extent sizing.

I have always assumed that the extent size for a temporary tablespace needs
to be equal to the size that sort_area_size is set to. A sort that can't fit
into memory then goes and grabs temp tablespace extents of a size equal to
sort_area_size. However, I have read somewhere that the extent size should
be equal to sort_area_size + block size (the block being used for header
infomation or something like that) eg. 8k block size and 64k sort area size
results in 72K temp tablespace extent size.

So, assume I have a sort area size of 128K and block size of 8k, do I need
to set temp tablespace extent sizes to 128K or 136K, or doesn't it really
matter.

Thanks,

Ade



--
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer


==

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

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

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

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

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

RE: cdump, bdump, udump

[Gogala, Mladen]

Oh, my god! I think that I should return to my beloved threadmill

-Original Message-
Sent: Tuesday, April 24, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L



karma, prana, hatha, or ayurvedic yoga? 

Most people just think of hatha yoga when 
they talk about it. 

Ross 

p.s.  let me know when you can do the Royal Pigeon 

|| -Original Message- 
|| From: Gogala, Mladen [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
] 
|| Sent: Tuesday, April 24, 2001 12:16 PM 
|| To: Multiple recipients of list ORACLE-L 
|| Subject: RE: cdump, bdump, udump 
|| 
|| 
|| I'm taking yoga classes and being much happier and less cynical, I'm 
|| much less inclined to reply with RTFM, despite the fact that this 
|| question more then deserves such an answer. 
|| 
|| -Original Message- 
|| Sent: Tuesday, April 24, 2001 12:40 AM 
|| To: Multiple recipients of list ORACLE-L 
|| 
|| 
|| Uh oh - here's one for Mladen.  Sinardy, have you ever heard of OFA? 
|| Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */ 
|| 
|| David A. Barbour 
|| Oracle DBA 
|| 
|| Sinardy Xing wrote: 
||  
||  Hi DBAs and SAs, 
||  
||  I had a task to do housekeep ...\bdump\alertSID.log 
||  What logs usually Oracle system need to housekeep, and 
|| what are these 
||  directory 
||  cdump, 
||  bdump and 
||  udump 
||  for ? 
||  
||  Thank you for your time 
||  
||  Sinardy 
||  
||  -- 
||  Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com  
||  -- 
||  Author: Sinardy Xing 
||INET: [EMAIL PROTECTED] 
||  
||  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
||  San Diego, California-- Public Internet access / 
|| Mailing Lists 
||  
||  
||  To REMOVE yourself from this mailing list, send an E-Mail message 
||  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
||  the message BODY, include a line containing: UNSUB ORACLE-L 
||  (or the name of mailing list you want to be 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
http://www.orafaq.com  
|| -- 
|| Author: David A. Barbour 
||   INET: [EMAIL PROTECTED] 
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
|| San Diego, California-- Public Internet access / 
|| Mailing Lists 
||  
|| To REMOVE yourself from this mailing list, send an E-Mail message 
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
|| the message BODY, include a line containing: UNSUB ORACLE-L 
|| (or the name of mailing list you want to be 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
http://www.orafaq.com  
|| -- 
|| Author: Gogala, Mladen 
||   INET: [EMAIL PROTECTED] 
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
|| San Diego, California-- Public Internet access / 
|| Mailing Lists 
||  
|| To REMOVE yourself from this mailing list, send an E-Mail message 
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
|| the message BODY, include a line containing: UNSUB ORACLE-L 
|| (or the name of mailing list you want to be 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

Re:RE: Oracle vs DB2

[dgoulet]

Patrice,

I just read that from IBM's WEB site
(http://www.ibm.com/news/2001/04/24.phtml) for those interested.  Looks like the
DB market in the near future will be Oracle  DB2, with a little SQL*Server
sprinkled in for spice.  My retirement fund may get better, but will I be able
to survive the feeding frenzy that ensues???

Dick Goulet

Reply Separator
Author: Boivin; Patrice J [EMAIL PROTECTED]
Date:   4/24/2001 8:45 AM

Well,

This is on topic - www.wired.com http://www.wired.com  today has an
article re. IBM announced that it is buying Informix for $1Billion.

Ah, if only I had that kind of money myself - I could take more Oracle
courses!

I don't know what will happen with Informix then, does that mean they will
gobble it up and DB2 will be the only option in a couple of years?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 24, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Oracle vs DB2

Disclaimer: I am *not* trying to start a religious war, and I am
*not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs
SQLServer
to determine our future direction. Here's a datum that makes a
significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet
through
a web page, you have to buy an unlimited-user enterprise license. We
had a
senior sales person in our office yesterday, and we asked this
question a
number of different ways. He bobbed and he weaved, but he did not
deny it.
And the quote he supplied afterwards does not address the issue at
all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition
(1
user), and something called WE Internet Access, for a total price of
$6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line
with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

--
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:Oracle vs DB2

[dgoulet]

Dennis,

First off I will totally agree with your last statement, Oracle is not in
line with the market  needs a severe case of reality check across the board. 
What their doing to my retirement fund is close to criminal.  

But, I believe your comparing apples to oranges.  DB2 UDB Workgroup is not
the equal of Oracle Enterprise.  If you want to compare apples  apples, try
Oracle Standard edition, now your getting closer to but still not equals.  I'll
assume you did not get any special discounts, they don't happen do they???  At
which to burn $160,000 Cdn ($103,381.28 US) you must need 1034 UPU's which in a
standard edition license is $15,510 US ($24,001.75 Cdn).  Also, what specials
did IBM pull out of their backsides to get your business, and what extra's
will you need to match Oracle's total package??  Their WEB page prices workgroup
differently than enterprise by several thousand $ US and there's a lot of
accessories that you'll need to purchase, or not, that come standard with
Oracle.  They also seem to have a different price depending on the OS, which is
not something Oracle does.

You've got to watch those sales droids, they'll take your T-shirt without
even mussing your hair!! :-)

Dick Goulet

Reply Separator
Author: Dennis Taylor [EMAIL PROTECTED]
Date:   4/24/2001 7:57 AM

Disclaimer: I am *not* trying to start a religious war, and I am *not*
trying to advocate DB2. I am simply offended. Thus this post.

As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer
to determine our future direction. Here's a datum that makes a significant
difference to us, dollar-wise.

With Oracle, in order to make a database accessible to the internet through
a web page, you have to buy an unlimited-user enterprise license. We had a
senior sales person in our office yesterday, and we asked this question a
number of different ways. He bobbed and he weaved, but he did not deny it.
And the quote he supplied afterwards does not address the issue at all.

Cost of unlimited-user Enterprise version for our installation (your
mileage may vary) = Approx $160,000 Cdn.

IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1
user), and something called WE Internet Access, for a total price of $6000
Cdn. I have a written quote from an IBM salescritter to this effect.

$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line with
market realities, and may have to undergo significant revision.



Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

Re: Listener.log

[David A. Barbour]

Okay, you moved the old one.  Perhaps you haven't had any activity that
would cause an entry to be generated for the log?  Or have you changed
any of the parameters in your listener.ora file?

Regards,

David A. Barbour
Oracle DBA

 Nguyen Thanh-truc wrote:
 
 Hello everyone,
 
 After moving the listener.log and compressed, there is no more log for
 the listener. Could anyone help me please ? Thanks.
 
 Nguyen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

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

Re:OT RE: HYPER VOLUMES - RE: Never split index and data fi

[dgoulet]

Aright, someone pass the snow shovel!!  It's getting deep in here!! :-)

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   4/24/2001 9:36 AM

Zymurgy Beats Recidivism?

|| -Original Message-
|| From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 11:51 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: HYPER VOLUMES - RE: Never split index and data 
|| files ...
|| 
|| 
|| Zebra Boisterous Rout
|| Zebra Blues Routine
|| 
|| Hmm it's hard to come up with meaninful acronyms, usually 
|| it's easier...
|| 
|| : )
|| 
|| Patrice Boivin
|| Systems Analyst (Oracle Certified DBA)
|| 
|| 
|| 
||  -Original Message-
||  From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
||  Sent:   Tuesday, April 24, 2001 11:35 AM
||  To: Multiple recipients of list ORACLE-L
||  Subject:RE: HYPER VOLUMES - RE: Never split 
|| index and data
|| files ...
|| 
||  Care to elaborate on ZBR for those of us with enquiring 
|| minds and
|| absolutely
||  no idea what you are on about :)
|| 
||  Cheers
|| 
||  Mark
|| 
||  
|| -- 
|| 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).
|| 
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
HTML
HEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1
META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12
TITLEOT RE: HYPER VOLUMES - RE: quot;Never split index and data files
...quot;/TITLE
/HEAD
BODY

PFONT SIZE=2Zymurgy Beats Recidivism?/FONT
/P

PFONT SIZE=2|| -Original Message-/FONT
BRFONT SIZE=2|| From: Boivin, Patrice J [A
HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/F
ONT
BRFONT SIZE=2|| Sent: Tuesday, April 24, 2001 11:51 AM/FONT
BRFONT SIZE=2|| To: Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=2|| Subject: RE: HYPER VOLUMES - RE: quot;Never split index and
data /FONT
BRFONT SIZE=2|| files ...quot;/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| Zebra Boisterous Rout/FONT
BRFONT SIZE=2|| Zebra Blues Routine/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| Hmm it's hard to come up with meaninful acronyms, usually
/FONT
BRFONT SIZE=2|| it's easier.../FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| : )/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| Patrice Boivin/FONT
BRFONT SIZE=2|| Systems Analyst (Oracle Certified DBA)/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; -Original Message-/FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; From:nbsp;nbsp; Mark Leith
[SMTP:[EMAIL PROTECTED]]/FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; Sent:nbsp;nbsp; Tuesday, April
24, 2001 11:35 AM/FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; To:nbsp;nbsp;nbsp;nbsp;
Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp;
Subject:nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; RE: HYPER VOLUMES - RE:
quot;Never split /FONT
BRFONT SIZE=2|| index and data/FONT
BRFONT SIZE=2|| files ...quot;/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; Care to elaborate on ZBR for those
of us with enquiring /FONT
BRFONT SIZE=2|| minds and/FONT
BRFONT SIZE=2|| absolutely/FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; no idea what you are on about
:)/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; Cheers/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; Mark/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| nbsp;nbsp;nbsp;nbsp; /FONT
BRFONT SIZE=2|| -- /FONT
BRFONT SIZE=2|| Please see the official ORACLE-L FAQ: A
HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT
BRFONT SIZE=2|| -- /FONT
BRFONT SIZE=2|| Author: Boivin, Patrice J/FONT
BRFONT SIZE=2||nbsp;nbsp; INET: [EMAIL PROTECTED]/FONT
BRFONT SIZE=2|| /FONT
BRFONT SIZE=2|| Fat City Network Servicesnbsp;nbsp;nbsp; -- (858)
538-5051nbsp; FAX: (858) 538-5051/FONT
BRFONT SIZE=2|| San Diego,
Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access /
/FONT
BRFONT SIZE=2|| Mailing Lists/FONT
BRFONT SIZE=2||
/FONT
BRFONT SIZE=2|| To REMOVE yourself from this mailing list, send an E-Mail
message/FONT
BRFONT SIZE=2|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in/FONT
BRFONT SIZE=2|| the message BODY, include a line 

RE: cdump, bdump, udump

[Eric D. Pierce]

Does everybody else need to wear a really big hat?

On 24 Apr 2001, at 10:15, Mohan, Ross wrote:


 p.s.  let me know when you can do the Royal Pigeon

...


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

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

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

Re: Perl DBA Tools

[John Carlson]

How about wrapping this is a script of your 
choice:

ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log
lsnrctl set log_file listener2.logmv listener.log 
$ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set 
log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME
This way, you don't have to stop the listener and you don't loose 
anything. Remember, in Unix, when you rename a file, any program that has 
it open still points to it.

Regards,
John
 [EMAIL PROTECTED] 04/24/01 10:20AM On 
Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: truncating 
listener logs -- or even starting a secondary listener, stopping the one 
with the log that is too large and removing the log, then restarting the 
original listenerGood idea. Thanks 
RachelJared-- 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-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

RE: cdump, bdump, udump

[Yosi]

Printer's not the same. I understand this is all ethereal, 
but it's not the same. I've got a collection of the docs in
big black looseleaf binders with a label I printed on the
side that says which book it is.

It's not as carriable as a smaller book, (try opening one
of those on a subway...) and all the books look alike -
since all the looseleafs are identical. (Maybe I should
get colored looseleafs...)

As for buying the books - no way management wants to pay
for them any more than Oracle does. And that's probably
justifiable.

I'll live - I just liked the hardcopy way better.


 -Original Message-
 From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 24, 2001 2:11 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: cdump, bdump, udump
 
 
 what's wrong with your printer? 
 
 what's wrong with just spending a bunch of money on hardcopy
 documentation like you used to do
 
 
 
 
 On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote:
 
 Date sent:Tue, 24 Apr 2001 08:15:54 -0800
 To:   Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 
 ...
  With this electronic stuff, I can't 'sit down and study', I find
  its hard to get a feel of what I should read because it all looks
  and feels the same.
  
  I really miss the hard copy docs.
 ...
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Eric D. Pierce
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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).

Re: 2 RMAN questions

[Ruth Gramolini]

I'll try to answer these;

You can uncatalog any archivelogs you have removed without using rman. This
will accomplish what you wish.  But for the future, try to an rman
archivelog backup with the delete option. This put the archivelogs in a
backupset and then deletes them.  Rman know right where they are for
recovery this way.

As long as you have changed the archivelog destination in your init.ora file
then it is recorded in the dictionary and rman can find the new destination.
You don't have to do anything else.

Hope this helped,

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 1:10 PM


 hi listers ...
 1/ i had to delete archived logs before i could back them up thru rman
...my
 ? is how do i notify rman that these logs no longer exist ... do i
 crosscheck (mark as expired) all previous logs and then issue a complete
 resynch ... or do i just resynch ... or ?

 2/ i am changing the archived logs destination ... is it sufficient to
 shutdown and restart the database, and then take a backup thru rman ... or
 do i need to do something else ...

 i am having trouble finding documentation that addresses these issues
 specifically ... so tia for help and/or place to research ...

 Nechama Glasrot
 Oracle DBA
 Seisint, Inc.
 6601 Park of Commerce Blvd.
 Boca Raton, Florida 33487
 nglasrot @seisint.com mailto:[EMAIL PROTECTED]
 Direct 561.999.3977
 Main 561.999.4400
 Fax 561.999.4695


 This transmission may contain information that is privileged, confidential
 and exempt from disclosure under applicable law.
 If you are not the intended recipient, you are hereby notified that any
 disclosure, copying, distribution, or use of the information contained
 herein (including any reliance thereon) is STRICTLY PROHIBITED.
 If you received this transmission in error, please immediately contact the
 sender and destroy the material in its entirety, whether in electronic or
 hard copy format.
 Thank you


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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

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

RE: Listener.log

[Patricia Ashe]

You have to reload or stop/start the listener to create a new log.

-Original Message-
Sent: Tuesday, April 24, 2001 8:47 AM
To: Multiple recipients of list ORACLE-L


Hello everyone,
 
After moving the listener.log and compressed, there is no more log for the
listener. Could anyone help me please ? Thanks.
 
Nguyen 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 - spool file name - use variable

[Helen Zhung]

I tried, but didnot work.
I hard code them now.
Thanks
 "Gogala, Mladen" [EMAIL PROTECTED] wrote: 
How about "spool report_id.dat" ?-Original Message-Sent: Monday, April 23, 2001 6:22 PMTo: Multiple recipients of list ORACLE-LI'm writing a sql script file (first run couple of queries, insert resultsinto a temp table), at last, the data need to spool out to separate files.the requirement was want the report name to be able to change depend on thequery. Therefore, I have a variable in the temp table. Now I want to be ableto enclose this variable name in my report name. like:temp table has: report_id, division, room ...So, the report will like:SPOOL C:\c\CYCLE_COUNT_${REPORT_id}.DAT ... ( for report 1)SPOOL C:\c\CYCLE_COUNT_${REPORT_id}.DAT ... ( for report 2)however, when I'm coding now, the '${REPORT_id}" is unknown. The valuevariable will get at run time. I don't know how to be dynami!
!
c.Hope I explain better this time. Thanks a lot.Diego Cutrone <[EMAIL PROTECTED]>wrote: Hi,I don't quite understand your question, so here's what I understood:Just enclose the variable name with "{ }" , here's an example/home/oracle export temp_variable=TEST/home/oracle echo "this_is_a_$temp_variable_only"this_is_a_-- wrong/home/oracle echo "this_is_a_${temp_variable}_only"this_is_a_TEST_only/home/oracleHope it helps- Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, April 23, 2001 2:50 PMHello: I'm trying to spool out couple of files from my temp table. Part of the filename is coming from a variable from the temp table. I use: spool C:\CYCLE_COUNT_$temp_vari!
!
able.DAT but it's only one physical name instead of using the variable. How can I code the variable name as part of (spool) file name? Thanks _ Do You Yahoo!?Yahoo! Auctions - buy the things you want atgreat prices_ Do You Yahoo!?Yahoo! Auctions - buy the things you want atgreat prices-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gogala, MladenINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe me!
!
ssage BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices

RE: Oracle vs DB2

[Jamadagni, Rajendra]

Now we know how Oracle saved a billion $$ ??

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, April 24, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L

[snip]
$6000. $160,000. $6000. $160,000. Hm. Let me think.

I respectfully submit that Oracle's pricing structure is out of line with
market realities, and may have to undergo significant revision.

[snip]

*

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 ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

*

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

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

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

RE: MTSCost based Optimzer

[Miller, Jay]

Hi Rachel,

It was my impresssion that joining an analyzed and unanalyzed tables will
used CBO, but the choice of access path will be badly skewed since the
assumptions Oracle makes about the unanalyzed table will probably be nowhere
near reality.
Obviously this can result in a terrible access path.

Jay Miller

-Original Message-
Sent: Tuesday, April 24, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


definitely all or nothing -- if you have analyzed the large table and join 
it to an unanalyzed small table, you are going to get rule based


From: Tim Sawmiller [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 07:51:18 -0800

I wouldn't... analyze all or nothing...

  [EMAIL PROTECTED] 04/24/01 09:46AM 
How would you decide that out of total big and small tables (say 1500) 
these
are the tables need to be analysed and these are not, as in our case
Transaction types are both OLTP and DSS ??


-Original Message-
Carmichael
Sent: Tuesday, April 24, 2001 6:46 PM
To: Multiple recipients of list ORACLE-L



turning on cost-based is easy:  set the optimizer_mode parameter to choose
in your init.ora, stop and start your database and then analyze all your
tables.

HOWEVER (and this is a biggie) this will not automatically make all your
queries run faster. You will need to examine each and every query to see if
it needs to be rewritten to take advantage of CBO. In fact, sometimes there
are queries that run faster in rule-based, and I have had to include hints
in queries to force the optimizer to run rule.

 From: Venkat_Kalepalli [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: MTSCost based Optimzer
 Date: Tue, 24 Apr 2001 02:25:25 -0800
 
   Hello folks!
  
   I am working in SUN solaris 5.6 with Oracle 8i.  I want to implement 
MTS
   on the Oracle server.  Next we are running with Rule based optimizer 
and
   we want to change to costbased optimizer.
  
   I want to know what are the advantages we get on this and what are the
   steps to implement this?
  
   Any help is grateful...
  
   Rgd
   Venkat
   DBA.
  
  
  

_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Tim Sawmiller
   INET: [EMAIL PROTECTED]

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

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

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

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

RE: List of user sessions

[dieter . oberkofler]

hi mainak!

you might want to have a look at my shareware
osession on my web page at: www.materialdreams.com

cheers

do

-Original Message-
[EMAIL PROTECTED]
Sent: Monday, April 23, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L


Hi,

i want to know that how will i get to know how many users (along with their
identities) who are logged in at any one particular moment of time.

mainak


__
123India.com - India's Premier Portal
Get your Free Email Account at http://www.123india.com


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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*net ??? , Y2K installer??? / RE: how to install Oracle Developer2000 on Windows98 ?

[Eric D. Pierce]

I think the original question was about failed SQL*Net, but
it was to vague to know for sure.

Anyway, all of the Developer/2000 CDs I have ever seen are
for windows 95/98/NT (american english).

If you have an old Developer/2000 CD, you might get
problems because earlier versions of the installer were
not ***Y2K*** compliant.

see the information at the below sites to get a Y2K compliant
installer for Win 95/98/NT:

---begin included file---
(4/11/2000 E.P.)

ftp://oracle-ftp.oracle.com/dev_tools/patchsets/Installer/32bit/33110c.zip

and

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=74900.1


(Also see ftp://oracle-ftp.oracle.com/dev_tools/patchsets/dev2k/Win95NT/ )

---end included file---


On 24 Apr 2001, at 5:40, Sonja wrote:

Date sent:  Tue, 24 Apr 2001 05:40:24 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

 Well, I remember that I had such installation problems.
 To begin with, you must have CD for Win98 . It really annoyed me when I
 realized that you can't install Developer from CD for Win95/NT.
 HTH,
   Sonja

 -Original Message-
 Sent: Saturday, April 21, 2001 11:16 AM
 To: Multiple recipients of list ORACLE-L


 dear listers,

 any body knows how to install Oracle Developer2000 on Windows98 ?

 I installed it on my machine but I can't even connect to my database


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

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

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

RE: HYPER VOLUMES - RE: Never split index and data files ...

[Mohan, Ross]

Tim, 

The outside track contains more data. 

Think of it this way: there is X bits per
square cm of disk real estate. 

a track is constant thickness, but steadily
increasing circumference, so the area of the
track -- and therefore the data storable there --
increases. 

-- Ross

|| -Original Message-
|| From: Tim Sawmiller [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 1:05 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: HYPER VOLUMES - RE: Never split index and data 
|| files ...
|| 
|| 
|| Ok, enlighten me...an outside track holds the same amount of 
|| data as an inside track does, right?  
-- 
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: REP: Locally Managed Tablespaces

[The Oracle DBA]

A couple of threads here and in other lists have mentioned this. A person puts LMTSs 
up and sets uniform extents on and sets it to, say 1M. Later they notice that not all 
extents are 1M. 

Thanks,

Earl

---

TheOracleDBA
[EMAIL PROTECTED]



On Mon, 23 Apr 2001 11:01:37  
 Jared Still wrote:
On Monday 23 April 2001 11:40, The Oracle DBA wrote:
 Are you using uniform extents? We are told they are not really = and
 actually are not the same at all over time.


Do you have a source for this information?  A number of us have been
using LMT's with uniform extents, and have not seen that.

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



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: The Oracle DBA
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle vs DB2

[Tim Sawmiller]

FYI, the Oracle Marketing spiel... 

Price Does Not Equal Cost 
Databases store, protect, manage and provide access to a company's most important 
business asset * information. There is no other product that a company will buy that 
has a greater effect on information systems. Selecting the wrong database product can 
compromise business growth and profitability. It would make sense to select a database 
product based on price alone if database products were the predominant part of the 
overall information technology expenditures. But this is simply not the case. Software 
costs (including upgrades and technical support) typically represent less than 15% of 
an IT budget and are small compared to the overall costs of hardware, operations and 
maintenance, consulting and training.  

 IBM DB2's Hidden Costs 
IBM never talks about the hidden costs of running an application on DB2: 
DB2 needs a more expensive hardware infrastructure to deliver the same level of 
service as Oracle. Oracle database is faster and more efficient than IBM DB2 on the 
same hardware configuration.  Oracle database supports more users and handles a 
greater workload with a smaller and less expensive hardware configuration. The real 
proof is IBM using Oracle database, not DB2, to benchmark its Unix hardware platforms. 
Oracle offers a more complete solution for high availability than IBM. DB2 lacks high 
availability features and makes IBM rely on hardware to deliver high availability. As 
a result, DB2 requires a more expensive hardware configuration to deliver the same 
level of availability as Oracle. According to an IBM-sponsored study by the Standish 
Group, even modest increases in availability can amount to millions of dollars saved 
each year. You can depend on Oracle to keep your business running and keep your IT 
budget under control.  
Oracle has far superior security features compared to DB2. Oracle has 13 security 
certifications from independent and internationally recognized organizations, IBM has 
none. Delivering a 100% secure solution with DB2 means additional software and 
consulting costs. IT Managers should be aware that security breaches amount to 
billions of dollars in losses every year for businesses around the world.  
DB2 lacks the advanced and automated system resource management capabilities than 
Oracle can deliver. Using DB2 means higher on-going maintenance costs.  
Choosing DB2 as a strategic database provider locks IT organizations into IBM's world: 
DB2's lack of third-party applications means more expensive development costs or 
inability to handle critical business processes. More than 17,000 applications from 
independent software vendors run on Oracle providing a pool of solutions unequaled by 
IBM.  
DB2 has limited functionality and is not optimized on non-IBM platforms such as HP or 
Sun which are IBM' s fierce competitors in the hardware market. As a result, DB2 locks 
you into IBM hardware at higher cost and risk of low performance.  
DB2 is not DB2 is not DB2.  DB2's code base is different on Unix and NT than on AS/400 
and the mainframe. This platform incompatibility leads to higher costs. While IBM 
claims 90% compatibility, the last 10% can mean a lot of wasted time for developers. 
Most applications are prototyped on NT first, then extended to the platform they will 
be deployed on. With IBM, developers know they will have to rewrite part of their 
code.  
There are more trained DBAs for Oracle than for DB2, making it easier to deploy and 
manage application running on Oracle database. Oracle has nurtured a 1.4 million 
strong developer community which is now is a deep pool of talent that IBM cannot 
offer. Gartner summarizes it all in a review of DB2: While IBM's per-processor 
pricing model makes DB2 especially attractive to the midrange and high-end markets, 
users should carefully weigh their anticipated total cost of ownership factoring in 
the difficulty of finding experienced DB2 developers and administrators.  
IBM's solutions are far less integrated than Oracle's and require additional time and 
resources before they can go live. Let's take security as an example. Oracle Advanced 
Security and Oracle database are fully integrated. These two products are developed by 
the same teams. To get access to security that are  functionally comparable to Oracle, 
IBM's customers need to acquire IBM Secureway, which comes from a totally different 
product line. 

 Quality Equals Economy 
Because a database is such a key technology, quality matters more than just software 
price. Who wants to run a general ledger application on an infrastructure that cannot 
handle peak loads? Who wants to run a global e-commerce or customer support 
application on a system that must go offline every week for maintenance? Who wants to 
run an HR system on a database that compromises on data integrity? 
An application running on Oracle costs less to operate than an application running on 
DB2 simply 

Re:Oracle vs DB2

[Dennis Taylor]

At 01:13 PM 4/24/01 -0400, you wrote:
But, I believe your comparing apples to oranges.  DB2 UDB Workgroup is
not
the equal of Oracle Enterprise.  If you want to compare apples  apples, try

Yes, but in order to put an Oracle database on the web, I HAVE TO USE
ENTERPRISE EDITION! The salescritters say so. It has to be unlimited users.
To repeat: I cannot (legally) put an Oracle database on an
internet-accessible web page unless it is an unlimited-user
(power-units-based) Enterprise edition version of Oracle. Let me put it
another way: I HAVE TO USE ENTERPRISE EDITION!

Now, it may be that every salescritter I've talked to is wrong about that,
but if so, what can I do? Reach through the phone, grab them by the throat,
and demand answers? (Not to say I don't *want* to)

I'm not actually comparing apples to oranges if you look at it from my POV:
I'm comparing the lowest cost to do what I want using Oracle, to the lowest
cost to do what I want using DB2. If Oracle demands that I use Enterprise
Edition with unlimited users, then that's their price.



Dennis Taylor

Beware of false economies.

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

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

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

RE: Listener.log

[Adams, Matthew (GEA, 088130)]

No, you do 
not have to restart the listener.
touch the 
listener.log file (we do a 'cp /dev/null 
$ORACLE_HOME/network/log/listener.log)
and the 
listener will start writing to it again.

R. Matt Adams - GE Appliances - 
[EMAIL PROTECTED] Meddle not in the affairs of troff, 
for it is subtle and quick to anger.


  -Original Message-From: Vadim Gorbounov 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 
  2001 12:28 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Listener.log
  Hello, 
  You 
  have to restart your listener. It continues towrite to "invisible" file 
  (inode without any reference from directories). Welcome to 
  UNIX.
  HTH
  Vadim Gorbounov
  Oracle DBA 
  
  
-Original Message-From: Nguyen Thanh-truc 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 11:47 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Listener.log
Hello everyone,

After moving the listener.log and compressed, there is no more log for 
the listener. Could anyone help me please ? Thanks.

Nguyen 

Re: cdump, bdump, udump

[Jared Still]

On Tuesday 24 April 2001 09:15, Gogala, Mladen wrote:
 I'm taking yoga classes and being much happier and less cynical, I'm
 much less inclined to reply with RTFM, despite the fact that this
 question more then deserves such an answer.

Really?  I thought you might engage in a little Greco Roman 
wrestling to get the aggression out.  :)

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: Oracle vs DB2

[Dan . Hubler]

Maybe I am wrong here but..

My understanding is that you can use standard or enterprise for any
appication you wish.

If your application communicates with the Web/internet, you have to license
the
product based on UPU's;  they will not accept a named user license.

???






Dennis Taylor [EMAIL PROTECTED]@fatcity.com on 04/24/2001 01:22:56 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


At 09:31 AM 4/24/01 -0800, you wrote:


Why the enterprise license for Oracle?


Because that's what they require.


Dennis Taylor

Don't be fooled by old cliches - He who laughs last may have
just figured out the joke.

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

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

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

Re: Re[2]:Oracle vs DB2

[Dennis Taylor]

At 01:35 PM 4/24/01 -0400, you wrote:
Dennis,

OK, but your sales critter is DEAD wrong.  We bought a Standard
edition from

Yep. Based on your statement, I checked with the critter. He says yes, you
can do it with Standard version. Which costs (ballpark) $33K Cdn for the
unlimited user version, vs $6K for DB2. Closer. Close enough that if you
already had a large investment in Oracle, you'd probably grit your teeth
and pay it.

The remaining issue as far as I'm concerned is the fact of having to pay
Oracle more $$ if I replace my server at any time, even if only with one
with a faster cpu.


Dennis Taylor

Beware of false economies.

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

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

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

OT RE: cdump, bdump, udump

[Mohan, Ross]

Title: OT RE: cdump, bdump, udump





LoL! No, but it is hellaciously hard
to do. And extremely rewarding!


|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, April 24, 2001 3:13 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: cdump, bdump, udump
|| 
|| 
|| Does everybody else need to wear a really big hat?
|| 
|| On 24 Apr 2001, at 10:15, Mohan, Ross wrote:
|| 
|| 
||  p.s. let me know when you can do the Royal Pigeon
|| 
|| ...
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
|| INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from). You may
|| also send the HELP command for other information (like subscribing).
|| 

Physical Data Layout

[Chris Rezek]

Hello all,

We are moving our production database onto new disks to improve
performance.  It is a high transction OLTP environment using Oracle8i on
a SPARC Solaris box.  We are divided about which parts of Oracle to put
where for the best performance.  We have come up with two basic
designs.  

A-C are SCSI controllers, 0-18 are 36GB hard disks.  B  C each are
connected to hardware RAID controllers.  A has two disks mirrored
through software.

SETUP I:

A0: Solaris  Oracle Software
A1: A0 soft mirror
B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs
C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK
(extra disks used in other systems)

SETUP II:

A0: Solaris  Oracle Software
A1: A0 soft mirror
B[RAID 0+1]2-7: DATA
B[RAID 1]8-9: REDO logs, SYSTEM
C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS
C[RAID 1]16-17: ROLLBACK

Or is there an even better way to arrange the data? 

Thanks,

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

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

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

RE: cdump, bdump, udump

[Ed . Haskins]

Yeah, as soon as Palm increases the amount of Memory to something like 1GB.

;-)

Ed Haskins
Oracle DBA
Verizon Wireless





maybe someone should convert them to Palm DOC format and we can load
them on our Palms to carry with us *everywhere*.;-)

--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Stock item: We shipped it once before, and we can do it again, probably.

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

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

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

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

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

RE: ORA-01458

[Gogala, Mladen]

Try upgrading to 8.1.7.1 if it's out for NT. Quite a few bugs were fixed

-Original Message-
Sent: Tuesday, April 24, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


Sonja, this is bug. Promised to be fixed in 8.1.6, and back again :(
Workaround is to 
create table .. as select ..  OR simply create table,  than insert...
HTH
Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Tuesday, April 24, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L


Hi all!
Oracle 8.1.7 on WinNT.
When I try to copy one table from one schema to another I get this error
message.
ORA-01458: invalid length inside variable character string

Description is "very informative"
01458, 0, "invalid length inside variable character string"
// *Cause:
// *Action:

This is what I did:
copy from [EMAIL PROTECTED]
to [EMAIL PROTECTED]
create abc using select * from abc;

Do you have any suggestions?
TIA,
Sonja

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Recall: Listener.log

[Adams, Matthew (GEA, 088130)]

Title: Recall: Listener.log





Adams, Matthew (GEA, 088130) would like to recall the message, Listener.log.