date:20010531


It adds the datafile NAME only, not the file itself. And if the physical 
file has not been moved before the archived log that has that redo in it is 
applied, the recovery dies.




>From: Hatzistavrou Giannis <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rebuilding indexes
>Date: Thu, 31 May 2001 07:30:29 -0800
>
>You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and
>Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles
>states the following:
>
>"Adding a datafile to your primary database generates redo data that, when
>applied at your standby, automatically adds the datafile name to the 
>standby
>control file."
>There is also a detailed example on how to do it
>
> > -Original Message-
> > From:   Richard Huntley [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, May 31, 2001 16:01
> > To: Multiple recipients of list ORACLE-L
> > Subject:Rebuilding indexes
> >
> > For those of you that have implemented a standby database, what method 
>do
> > you use to rebuild your indexes tablespace.
> > My plan was to create a new tablespace and rebuild the indexes into the
> > new
> > tablespace and then reverse the process to move
> > back to the original tablespace after I drop and recreate it in order to
> > get
> > rid of fragmentation in the originally indexes tablespace.
> > However, creating the new datafile associated with the new tablespace,
> > cancels media recovery associated with the standby database...just
> > wondered
> > if anyone has a better method of defragging an index tablespace when 
>there
> > is a standby database catching the redo it generates.
> >
> > TIA,
> > Richard Huntley
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Richard Huntley
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be 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: Hatzistavrou Giannis
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Rebuilding indexes

2001-05-31 Thread The Oracle DBA


However, if you rebuild all the indexes for schema SALES on PRIMARY, what happens on 
STANDBY? Are they rebuilt? 

Cheers,

Earl
 
---

TheOracleDBA
[EMAIL PROTECTED]



On Thu, 31 May 2001 08:16:06  
 Rachel Carmichael wrote:
>there IS no way to do that with a standby database. Once you open it for 
>anything other than read-only (8i) you invalidate the standby status.
>
>
>
>
>>From: Richard Huntley <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: Rebuilding indexes
>>Date: Thu, 31 May 2001 06:00:56 -0800
>>
>>For those of you that have implemented a standby database, what method do
>>you use to rebuild your indexes tablespace.
>>My plan was to create a new tablespace and rebuild the indexes into the new
>>tablespace and then reverse the process to move
>>back to the original tablespace after I drop and recreate it in order to 
>>get
>>rid of fragmentation in the originally indexes tablespace.
>>However, creating the new datafile associated with the new tablespace,
>>cancels media recovery associated with the standby database...just wondered
>>if anyone has a better method of defragging an index tablespace when there
>>is a standby database catching the redo it generates.
>>
>>TIA,
>>Richard Huntley
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Richard Huntley
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(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).
>


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: 4 join methods?

2001-05-31 Thread Scott . Shafer


Cartesian Join?  

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Greg Moore [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 9:41 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  4 join methods?
> 
> Hi,
> 
> I just read there are four join methods.  I know three:
> 
> Nested loops
> Sort merge
> Hash join
> 
> What's the fourth?
> 
> - Greg
> 
--
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: Partition Elimination

2001-05-31 Thread Toepke, Kevin M


Dave:

Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.

Kevin

-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


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

How do I corrupt a block

2001-05-31 Thread novicedba




hi,
  This  may sound funny. I want to know 
how to corrupt a block. I want to test the different methods of identifying 
block corruption, but I don't have sample data blocks.
Please help me
 
novice

problem starting oracle database

2001-05-31 Thread Harvinder Singh


Hi,

When i am trying to start my database form svrmgrl ..
i am getting error: 
ORA-00205 error in identifying controlfile, check alert log for more info 

there is nothing in alert.log...
i have 3 control files all r in proper directory..
i am using proper SID
i tryied with only i control file in init.ora same error...
i am using startup pfile ...so it is using proper init.ora file
What might be the cause...

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

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

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

SQL problem: retrieve child records if existent

2001-05-31 Thread Helmut Daiminger


Hi!

I have a SQL problem here, which I can't solve.

I have a B-tree structure in a table (parentID, childID).

If a parent has kids then select those kids. If not, select this parent.

How do I code this in SQL? I tried using "connect by" but this doesn't
include start point.

Any idea?

This is 8.1.6 on Win2k.

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

Re: Snapshot Logs Explanation Needed

2001-05-31 Thread Mogens Nørgaard


Correct.

By the way: A good rule is to always keep the sequence "Table - Snapshot Log -
Snapshot", ie. don't break the sequence, for instance by dropping and
re-creating the snapshot log. If something happens to the snapshot log you
should drop the snapshot, create the snapshot log, then re-create the snapshot.

Mogens

"Norrell, Brian" wrote:

> Been a while since I worked with snapshots, but if I remember correctly,
> each record in a fast refresh snapshot keeps a mapping back to the rowid on
> the master.  If you drop and recreate the master table, the mapping is hosed
> and updates/deletes do not propagate to the snapshot.
>
> Brian Norrell
> Manager, MPI Development
> QuadraMed
> 511 E John Carpenter Frwy, Su 500
> Irving, TX 75062
> (972) 831-6600
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 5:48 PM
> To: Multiple recipients of list ORACLE-L
>
> I would like to reorg many tables which have snapshots associated with them.
> I
> understand that if the master table is dropped the snapshot log is also
> dropped.  When a log is dropped, oracle states that you need to do a
> complete
> refresh of the affected snapshot.  My question is why?  If you do not allow
> users to access the database with the master table, then you should not have
> any transactions that would be lost.  Why can't you create a new log and
> continue to do a fast refresh?   I am trying to avoid having to recreate all
> the snapshots due to the size and number that we have.  Any thoughts?
> Thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tracy Rahmlow
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Norrell, Brian
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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

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

RE: Fire your DBA's you don't need them anymore...

2001-05-31 Thread The Oracle DBA


I need to find the article I had saved about Oracle 6.0 (as we were preparing to 
upgrade from 5.1). It was something about how the 6.0 DBA would be bored and would now 
be able to help appdev.

Cheers,

Earl


---

TheOracleDBA
[EMAIL PROTECTED]



On Fri, 25 May 2001 09:28:53  
 Vergara, Michael (TEM) wrote:
>I can remember as far back as version 7.3 where Oracle was touting that
>"you won't need a DBA for our new database".  It hasn't happened yet, 
>has it?  Oh yes, it's easier, but we're still here!
> 
>And besides, what were they offering in the cold call?  Replacing your
>DBAs with their DBAs.  At (probably) twice the price.  Outsourcing Lives!
> 
>Just my $0.02 worth.
> 
>Mike
> 
>---
>===
>Michael P. Vergara  | I've got a PBS mind in an MTV world
>Oracle DBA  |
>Guidant Corporation |
>
>-Original Message-
>Sent: Friday, May 25, 2001 9:27 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Very stupid thing to do by Oracle, considering the fact that many Oracle
>purchasing decisions are made by Oracle DBAs. To shut us out like that will
>most certainly have an effect on Oracle Sales. Hell, you don't need me
>anymore? I'll switch political sides and jump the ship to IBM, or 
>Microsoft...
> 
>Far as their "superior" i-dba team, I sure hope those are different people
>from the ones you get on first line of Support...
> 
>Gary Weber
> 
>PS. Or maybe we should all become Oracle salesmen (saleswomen)
> 
>-Original Message-
>Sent: Friday, May 25, 2001 12:02 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>My boss just received a cold call from Oracle that he let me listen in on.
>They have a new push on for their i-dba support package.  For just a little
>more money (they did not define little), "we will replace your dba's with
>our superior support team that will monitor your database 24x7 and
>proactively eliminate problems.  This will allow you to redesign you office
>to offload these cumbersome DBA tasks and allow your workers to do other
>things.  You will never have another database problem."   I felt good when
>my boss indicated that we had no base problems but based on this, I guess we
>will have to become sqlserver DBAs or   developers...:)
>
>Ahh, Friday, wonderful Friday,  it seems like you've been away all week... 
>
>--Chris 
>[EMAIL PROTECTED] 
>
>


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: what's hash-join

2001-05-31 Thread Connor McDonald


The general school of thought is joining a large table
to a small one.  There is an article on Metalink thats
a little out of date now, but it describes the
good/the bad, and tuning of hash joins.

Look for doc 67134.1 and 41954.1

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: >
What's the performance (gain/loss) on such a join,
> when would you want to
> use one?
> Kev
> 
> -Original Message-
> McDonald
> Sent: Thursday, May 31, 2001 6:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> A method of joining two tables.  You scan each and
> use
> a hashing algorithm to isolate/match keys.
> 
> hth
> connor
> 
> --- Senthil Ganapathi
> <[EMAIL PROTECTED]> wrote: >
> > Hi Rukmini
> > could tell me what's that hash-join
> >
> > GSK
> >
> >
> >
> >
> > "Rukmini
> >
> > Devi"To:
> > Multiple recipients of list ORACLE-L
> >  > <[EMAIL PROTECTED]>
> > rain.com>cc:
> >
> > Sent by: Subject:
> >  Re: 4 join methods?
> > root@fatcity.
> >
> > com
> >
> >
> >
> >
> >
> > 31-05-01
> >
> > 09:55 AM
> >
> > Please
> >
> > respond to
> >
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > 1. Equi-join 2. Self-join 3. Outer-join 
> 4.
> > Hash-join
> >
> > rukmini
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Thursday, May 31, 2001 11:20 AM
> >
> >
> > > i feel the fourth one is self join.
> > >
> > > - Original Message -
> > > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > > Sent: Thursday, May 31, 2001 8:10 AM
> > >
> > >
> > > > Hi,
> > > >
> > > > I just read there are four join methods.  I
> know
> > three:
> > > >
> > > > Nested loops
> > > > Sort merge
> > > > Hash join
> > > >
> > > > What's the fourth?
> > > >
> > > > - Greg
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > > --
> > > > Author: Greg Moore
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > > San Diego, California-- Public
> Internet
> > access / Mailing Lists
> > > >
> >
>

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

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

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

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

Implementing Stored Procedures

2001-05-31 Thread Yttri, Lisa

Title: Implementing Stored Procedures





Hi -


I'd like some advice on implementing stored procedures containing application logic (ie. written by developers).  We have several applications where the developers use stored procedures for much of their coding.  We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema.   It has gotten to be a very time-consuming job.  We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want.

I am curious of how others are handling stored procedure additions and modifications.    Do you somehow allow developers this access?  If so, how do you restrict them from damaging other things?  If not, does the DBA do it?   Does anyone have an automated way?   Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed?

Thanks so much for your input -
Lisa

RE: Auto Extend

2001-05-31 Thread Brian MacLean

Title: RE: Auto Extend





See Note:62427.1, 2Gb or Not 2Gb - File limits in Oracle http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62427.1


-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Auto Extend



"Depends" is the standard answer.


Oracle can handle files over 2g, some unixes can, some
unixes cannot, some say they can but cannot etc etc...


To compound things, in some versions, Oracle will let
the file go beyond 2g, only then to complain because
the unix won't let Oracle get to the bits after 2G -
thus corrupt db.


Unless you're on raw, I'd recommend a ceiling of 2g on
any datafile - just to be safe


hth
connor


--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have
taken over an Oracle database that is setup
> with autoextend on the
> tablespaces.  Can anyone tell me what happens when
> the datafiles extend
> beyond 2G on Unix?
> 
> . 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California    -- Public Internet
> access / Mailing Lists
>

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

RE: Auto Extend

Title: RE: Auto Extend





Hi Ron, 


do you have large files enabled on your system? What unix are you running?  if large files are not enabled you're going to get an error but I can't tell you what it will be. 

Boy, autoextend reminds me of a monkey running around in your database.  I'd never do that, but it's just my personal preference.

Lisa Koivu
Oracle Database Administrator
954-935-4117


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. 



-Original Message-
From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject:    Auto Extend


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?


. 


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


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

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

RE: Rebuilding indexes

2001-05-31 Thread Richard Huntley


Hatzistavrou,

Thanks for you reply.  It was about 4am when I ran into that and discovered
what I needed to do, however, I knew it would take a while so I just stopped
at that point.  But, I was curious to find out if anyone had a BETTER way of
doing it.  It seems like a waste if I have to go through the hassle of
creating the tablespace on the standby if I'm just going to rebuild the
index with NOLOGGING, just extra steps and cleanup work on the standby
database.

Richard Huntley
E-mail: [EMAIL PROTECTED]



-Original Message-
Sent: Thursday, May 31, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L


You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and
Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles 
states the following:

"Adding a datafile to your primary database generates redo data that, when
applied at your standby, automatically adds the datafile name to the standby
control file."
There is also a detailed example on how to do it

> -Original Message-
> From: Richard Huntley [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 16:01
> To:   Multiple recipients of list ORACLE-L
> Subject:  Rebuilding indexes
> 
> For those of you that have implemented a standby database, what method do
> you use to rebuild your indexes tablespace.
> My plan was to create a new tablespace and rebuild the indexes into the
> new
> tablespace and then reverse the process to move
> back to the original tablespace after I drop and recreate it in order to
> get
> rid of fragmentation in the originally indexes tablespace.
> However, creating the new datafile associated with the new tablespace,
> cancels media recovery associated with the standby database...just
> wondered
> if anyone has a better method of defragging an index tablespace when there
> is a standby database catching the redo it generates.  
> 
> TIA,
> Richard Huntley
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Hatzistavrou Giannis
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Suggestions on SCSI

2001-05-31 Thread Connor McDonald


if you get 18's then you can just use the outer 9G
portion of each drive to get better performance.

The trick then is convincing management when more disk
is needed that you don't want to use the inner portion

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hi
all,
>   Just thought I would throw this one out there and
> see what all of you hot
> shots think.  I am going to rebuild a server into a
> DB Server.  Currently it
> has IDE drives in there and obviously I am not going
> to be using those.  So
> I need to invest in some new SCSI drives.  Here's
> what I had in mind:
> 
> Either 4 X 9.2 Gig 10K RPM with 2mb Cache
> OR 4 X 18.4 GIG 10K with 4MB cache
> 
> I was initially leaning towards the 9 gigs to save
> on cost, however someone
> pointed out that 18 would be a better idea for
> growth down the line.  Also I
> want to keep them all of the same size in case one
> goes down then I may have
> room on another.
>   What are your thoughts on this?  Does anyone know
> what "ultra fibre scsi"
> means?  Does anyone recommend brands to stear clear
> of?  I know that Seagate
> is a pretty good name, but I can't find any in Ultra
> 2?  Anyone know if
> Hitachi is a good name?
>   Thanks in advance.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> 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).


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

RE: ORACLE NAMES /LDAP

2001-05-31 Thread Jesse, Rich


Hi Ed,

Why do you say that OiD "is not cheap"?  I haven't seen any associated
costs, other than servers to put it on.  Can you explain?

The "complicated" part, though I definitely agree with!  :)

Thx!

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


-Original Message-
Sent: Thursday, May 31, 2001 10:51
To: Multiple recipients of list ORACLE-L


Vikas,

I just implemented Oracle Names (8.1.6) for Verizon
Wireless...corporate-wide.  I've setup three ONAMES servers: 

1.  At Corporate Headquarters in NJ.  This server contains the region
database for ONAMES.  It also serves as the "Secondary" ONAMES server
corporate-wide.

2.  In data center in NY.  This server provides "Primary" ONAMES services to
the corporate regions in both the North East and South areas.

3.  In data center in CA.  This server provides "Primary" ONAMES services to
the corporate regions in both the West and Midwest areas.

This infrastructure supports 26,000 users accessing 250+ databases
corporate-wide.

Oracle Names is making its' terminal release in 9i.  Oracle is recommending
that companies migrate to their LDAP (Oracle Internet Directory) solution.
This solution is not cheap...so we have decided to wait probably another
year or so before going this route.  OiD is also a bit more complicated to
setup and administer.

Ed Haskins
Oracle DBA
Verizon Wireless
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Automating Outlook express

2001-05-31 Thread Sergio Boix Moriano


Hi all,

Does anybody knows how to autmotize the outlook express from a Form,
to open a new mail and atach a file to it, leaving the subject and
destiny in blank, to be filled by the user, or where can I find any
guidelines to do it.

I have searched it at metalink , oraclefaq and the OTN, but the only
I have found are examples about sending a report by mail.

Thanks in advanced for all your responses.

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

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

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

RE: Unix File Open & Port Open

2001-05-31 Thread Jeremiah Wilton

I like lsof for this purpose.  You can see which processes have which
filehandles and ports open to which hosts.  It is an excellent utility.

ftp://vic.cc.purdue.edu/pub/tools/unix/lsof/README

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 31 May 2001, Mohan, Ross wrote:

> you could also look into using
> the /proc filesystem.
>
> that's what it's there forsorry, but
> this'll be another RTFM drill, I don't
> have my unix web site available for easy
> clicking.
>
> || -Original Message-
> || From: Kevin Lange [mailto:[EMAIL PROTECTED]]
> ||
> || You might try the netstat and the fuser commands.
> ||
> || I believe netstat -a will give you all the ports in use and
> || fuser will tell
> || you what processes have the files open in the current directory.
> ||
> || -Original Message-
> ||
> || This is an off topic, UNIX question.
> ||
> || Can any one please tell me how to get the Unix File Open and
> || Port Open in
> || SCO or AIX, or SUN? I am not sure whether they are part of
> || sar output, so
> || please help. I am not sure whether I can get this kind of
> || information.

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

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

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

No Subject

2001-05-31 Thread \"Himanshu H Shekhar\"


SET ORACLE-L NOMAIL



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: \"Himanshu H Shekhar\"
  INET: [EMAIL PROTECTED]

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

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

RE: Partition Elimination


Oracle could be doing partition elimination but the tools that you are using
to see the execution plan is not showing you the details you're looking for.

I usually do:

Truncate table plan_table;
explain plan for ;
select * from plan_table;


There should be two columns that indicate the partition-start_number and the
partition_stop_number for this full table scan.

If it's not working let's know.

Regards,

Waleed

-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


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

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

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

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

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

RE: About parallel server


I have heard rumors that OPS on 9i will allow you to use cooked files.

User group meeting next week, with a presentation on 9i new features. 
I'll ask

Rachel


>From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: About parallel server
>Date: Thu, 31 May 2001 06:06:38 -0800
>
>Dick,
>
>   What are you using for your source for this information?
>This does not jibe with other things I have read.
>If your not going to use a shared raw device for
>the online redo logs, how can one instance to instance recovery
>for another instance that fails?
>
>
>R. Matt Adams  - GE Appliances - [EMAIL PROTECTED]
>   Meddle not in the affairs of troff,
>   for it is subtle and quick to anger.
>
>
> > -->  Data files yes, redo and control files can be on cooked
> > file system.

_
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: Listener problems

2001-05-31 Thread Jacques Kilchoer

Title: RE: Listener problems





> -Original Message-
> From: zabair ahmed [mailto:[EMAIL PROTECTED]]
> 
> Has anybody come across the following error message in the 
> listener.log, and 
> know what the resolution is.
> 
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12540: TNS:internal limit restriction exceeded
> TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
> Solaris Error: 12: Not enough space
> 
> What is this Solaris Error 12?
> 
> I have nothing set in the listener.ora or sqlnet.ora (in fact 
> this dosn't 
> even exist) files.
> 
> 8.1.7 on Solaris 5.6


I posted this question to the list about a week ago. If you go to the archives at http://www.fatcity.com , enter the beta site, search ORACLE-L for messages in 2001 with "Sun Solaris 8 - Listener" in the subject line, you will find the messages related to the subject.

Here's a summary of the discussion from last week. Following that are some suggestions I found on Metalink.


--- From ORACLE-L -
I had the following suggestions:
- purge listener.log (Shahid Nasir)
- check max number of processes vs. max number of processes per user (John Kanagaraj)
- swap space being filled (Hagedorn, Linda)
- Use the "truss" command to trace the system calls when you get the ORA-12500. Example: truss -f -o error.log sqlplus (Narender Akula)

- increasing number of semaphores (eric harrington)


Narender Akula had also asked if we have Oracle 32-bit and Oracle 64-bit versions both running on the same server. Yes we do.

I tried all of the above except using truss. I will experiment with that later. What I did for now to fix the problem: I made the SGA smaller on several of the test databases and the problem went away (it looks like some of the init files were copied over from a production system with no changes. No, I didn't do it, so don't start throwing tomatoes at me.) I'm still not sure why this fixed the problem since ipcs -pmb showed a total of approx. 800MB being used and the machine has 4GB of physical memory.




 From Metalink -
Intermittent TNS-12500 errors are caused by a lack of  resources on the
server. Finding which resource is  depleted may be difficult. 


1. The TNS-12500 can be a result of the 'processes'  parameter in the
init.ora file being too low. 


2. If the init.ora 'processes' parameter seems ok then you may need to
increase the Unix kernel parameters for the maximum number of processes or
users (for example, nproc or maxuprc). Check the manuals for the Unix
operating system for more information on these parameters. 


3. Check that you have adequate swap space. 


4. Disable OTRACE. OTRACE is a tracing feature that can cause many problems.
OTRACE is enabled by default. To disable OTRACE: 


a. Stop the Oracle database. 
b. Go to the $ORACLE_HOME/otrace/admin directory. 
c. Delete all files with a '.dat' extension. 
d. Restart the Oracle database. 


5. Use the Multi-Threaded Server (MTS) option. 



Jacques R. Kilchoër
x8816

RE: Automating Outlook express

2001-05-31 Thread Post, Ethan


This can be done using the Outlook object model.  I have never done it with
express but have created lots of stuff with outlook.  Check out
msdn.microsoft.com for information on the model and examples (look in the
MSDN Library). 

- Ethan Post

-Original Message-
Sent: Thursday, May 31, 2001 10:08 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Does anybody knows how to autmotize the outlook express from a Form,
to open a new mail and atach a file to it, leaving the subject and
destiny in blank, to be filled by the user, or where can I find any
guidelines to do it.

I have searched it at metalink , oraclefaq and the OTN, but the only
I have found are examples about sending a report by mail.

Thanks in advanced for all your responses.

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

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

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

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

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

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

RE: Suggestions on SCSI

2001-05-31 Thread Kevin Kostyszyn


Now that sounds like a fantastic idea, now all that I have to do is figure
out how you do that?:0  Kev

-Original Message-
McDonald
Sent: Thursday, May 31, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L


if you get 18's then you can just use the outer 9G
portion of each drive to get better performance.

The trick then is convincing management when more disk
is needed that you don't want to use the inner portion

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hi
all,
>   Just thought I would throw this one out there and
> see what all of you hot
> shots think.  I am going to rebuild a server into a
> DB Server.  Currently it
> has IDE drives in there and obviously I am not going
> to be using those.  So
> I need to invest in some new SCSI drives.  Here's
> what I had in mind:
>
> Either 4 X 9.2 Gig 10K RPM with 2mb Cache
> OR 4 X 18.4 GIG 10K with 4MB cache
>
> I was initially leaning towards the 9 gigs to save
> on cost, however someone
> pointed out that 18 would be a better idea for
> growth down the line.  Also I
> want to keep them all of the same size in case one
> goes down then I may have
> room on another.
>   What are your thoughts on this?  Does anyone know
> what "ultra fibre scsi"
> means?  Does anyone recommend brands to stear clear
> of?  I know that Seagate
> is a pretty good name, but I can't find any in Ultra
> 2?  Anyone know if
> Hitachi is a good name?
>   Thanks in advance.
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
>
> --
> 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).


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

RE: DB2 vs Oracle

2001-05-31 Thread John Lewis


Ditto

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


I wouldn't mind a copy of that doc Mark?

-Original Message-
Sent: 31 May 2001 13:34
To: Multiple recipients of list ORACLE-L


Hi people,

A few weeks back somebody posted a message regarding an eval they are doing
comparing Oracle/DB2/SQLServer.

I came across a great document today for an Oracle/DB2 comparison, so if
that person - sorry I can't remember who it was - is interested, contact me
back channel, and I'll send it over to you.

Regards

Mark




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


E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to
be bound by its terms.

The information contained in this e-mail and any files transmitted with
it (if any) are confidential and intended for the addressee only.  If you
have
received this e-mail in error please notify the originator or telephone
0191 210 2060 or e-mail [EMAIL PROTECTED]  

This e-mail and any attachments have been scanned for certain 
viruses prior to sending but neither Northern Electric plc nor any of the
companies in the Northern Electric group of companies from whom this e-mail
originates shall be liable for any losses as a result of any viruses being
passed on.

No warranty of any kind is given in respect of any information contained in
this e-mail and you should be aware that that it might be incomplete, out of
date or incorrect. It is therefore essential that you verify all such
information with us before placing any reliance upon it.

Northern Electric plc
Carliol House
Market Street
Newcastle-upon-Tyne
NE1 6NE
Registered in England and Wales: Number 2366942




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Garner, John (NESL-IT)
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Snapshot Logs Explanation Needed

Hi Anita,
Ironically that is just what I am trying to do.  (ie implement a storage plan
which will address the issues discussed in the paper)  To your other point, I
understand oracle's position, but if I can prohibit changes to the master
during the reorg/rebuild, is this still an issue?
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:37 PM
---

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]

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

Tracy,

You may know that there were no modifications to the
master table made from the time the snapshot log was
dropped until it was recreated, but Oracle can't take
that chance, otherwise data could get out of sync.
That's why you have to either recreate your snapshot
or do a complete refresh if the snapshot log is
recreated.

To avoid recreating the snapshots I would ask why you
need to reorg your master tables (i.e. what do you
hope to accomplish by this)?  If you're doing it for
defragmentation reasons, I suggest you check out the
excellent white paper "How to stop defragmenting and
start living..." to see if this is really necessary.

http://www.vampired.net/articles/files/stopfrag.zip

HTH,

-- Anita

--- Tracy Rahmlow <[EMAIL PROTECTED]> wrote:
> I would like to reorg many tables which have
> snapshots associated with them.  I
> understand that if the master table is dropped the
> snapshot log is also
> dropped.  When a log is dropped, oracle states that
> you need to do a complete
> refresh of the affected snapshot.  My question is
> why?  If you do not allow
> users to access the database with the master table,
> then you should not have
> any transactions that would be lost.  Why can't you
> create a new log and
> continue to do a fast refresh?   I am trying to
> avoid having to recreate all
> the snapshots due to the size and number that we
> have.  Any thoughts?  Thanks
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tracy Rahmlow
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Rebuilding indexes

2001-05-31 Thread Richard Huntley


Rachel,

First, let me say that I just bought your book, so I definitely appreciate
any comments coming from you!!  :)  I'm simply trying to defrag the indexes
tablespace of the primary database, which I've done in the past as I
described below.  Now that I have a standby database out there, I just want
to make the rebuild as efficient as possible without a bunch of added steps,
if I can avoid them, so I thought I'd ask for suggestions for better ways of
doing this.  

At the moment, however, it's looking like I'll be forced to add the datafile
to the standby database, even though I'll use NOLOGGING to rebuild the
indexes.  The additional tablespace/datafile, I'll build on the primary and
do the rebuild to the new tablespace then back to the old after I drop and
recreate the old.  The problem comes in with the redo generated from the
creation of the new tablespace being carried to the standby database.  I was
hoping I wouldn't have to add the datafile to the standby database.  With
the standby database in mind, would you suggest that I do the index rebuild
with or without logging?

TIA,

Richard Huntley
E-mail: [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 31, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L


there IS no way to do that with a standby database. Once you open it for 
anything other than read-only (8i) you invalidate the standby status.




>From: Richard Huntley <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rebuilding indexes
>Date: Thu, 31 May 2001 06:00:56 -0800
>
>For those of you that have implemented a standby database, what method do
>you use to rebuild your indexes tablespace.
>My plan was to create a new tablespace and rebuild the indexes into the new
>tablespace and then reverse the process to move
>back to the original tablespace after I drop and recreate it in order to 
>get
>rid of fragmentation in the originally indexes tablespace.
>However, creating the new datafile associated with the new tablespace,
>cancels media recovery associated with the standby database...just wondered
>if anyone has a better method of defragging an index tablespace when there
>is a standby database catching the redo it generates.
>
>TIA,
>Richard Huntley
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Huntley
  INET: [EMAIL PROTECTED]

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

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

RE: Suggestions on SCSI

2001-05-31 Thread Christopher Spence


18Gb with the cache all the way, I would recommend Seagate for this.  The
cost difference is small between the 9Gb and 18Gb plus 18Gb will be
replaceable for longer time than 9Gb.

I would recommend more than 4 disks though.  Specially if your implementing
raid of some sort.
If at all possible.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Just thought I would throw this one out there and see what all of
you hot
shots think.  I am going to rebuild a server into a DB Server.  Currently it
has IDE drives in there and obviously I am not going to be using those.  So
I need to invest in some new SCSI drives.  Here's what I had in mind:

Either 4 X 9.2 Gig 10K RPM with 2mb Cache
OR 4 X 18.4 GIG 10K with 4MB cache

I was initially leaning towards the 9 gigs to save on cost, however someone
pointed out that 18 would be a better idea for growth down the line.  Also I
want to keep them all of the same size in case one goes down then I may have
room on another.
What are your thoughts on this?  Does anyone know what "ultra fibre
scsi"
means?  Does anyone recommend brands to stear clear of?  I know that Seagate
is a pretty good name, but I can't find any in Ultra 2?  Anyone know if
Hitachi is a good name?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

RE: Implementing Stored Procedures

2001-05-31 Thread Bala, Prakash


Lisa,
 
This is what we did in my last project:
 
1. Developers had access to the application schema where they created and
modified procedures/functions/triggers as needed
2. After their unit testing is done, the QA team would test it using the
front-end application.
3. Once QA team approves the new/enhanced functionality, the developers
would check in the code using PVCS and notify the DBA vith the PVCS version
number and the object name.
4. The DBA tracks the object version numbers along with the application
releases and implements the necessary changes in the production box.
Developers did not have any rights on the production box.
 
HTH!
 
Prakash

-Original Message-
Sent: Thursday, May 31, 2001 1:02 PM
To: Multiple recipients of list ORACLE-L



Hi - 

I'd like some advice on implementing stored procedures containing
application logic (ie. written by developers).  We have several applications
where the developers use stored procedures for much of their coding.  We let
the developers create or replace their procedures in a development
environment under their own schema (with access to all application tables,
etc.) to test the logic, but it currently requires a DBA to implement the
proc under the application schema.   It has gotten to be a very
time-consuming job.  We don't want to give out the schema owner password to
the developers, nor do we know of a way they could add them as the schema
owner without giving them more privileges than we want.

I am curious of how others are handling stored procedure additions and
modifications.Do you somehow allow developers this access?  If so, how
do you restrict them from damaging other things?  If not, does the DBA do
it?   Does anyone have an automated way?   Also, do you keep track of the
original "source code" for the procedure, or do you extract it out of the
database as needed?

Thanks so much for your input - 
Lisa 

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

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

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

2001-05-31 Thread Boivin, Patrice J


Thanks

I just found it interesting that here in Canada no one has asked for the
trial CD kit... and that Oracle Canada doesn't know what to do when we wish
to order one.


Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Shreter, Hilary [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 2:27 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Applications

Oracle Apps has been around since at least the early 90's. They
started with
financials only and they just kept adding new products all the time.
I have
5 years experience with OA and some of my teammates have more.

Because OA is off-the-shelf, I've been required to enable several
upgrades,
each with major "technology stack" overhauls, which might be the
experience
that the posting is really after. 

-Original Message-
Sent: Thursday, May 31, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L


Still no response from Oracle Canada, I left a message again - they
didn't
know what to do when people order CD Packs...

Meanwhile I saw on the 'net a job posting that had as one of the
competency
requirements:  4 years experience with Oracle Applications.

I guess this is supposed to be funny.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

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

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

RE: Suggestions on SCSI

2001-05-31 Thread Haskins, Ed


Kev,

1.  I have never heard of a cache directly on the hard drive (Which
certainly doesn't mean it doesn't exist).  I have heard of a cache on the
controller for the HD!

2.  I assume that you are looking at upgrading one of the Dell Workstations,
yes?  If so, I highly recommend calling Dell and ordering HD's from them
that are supported for that Workstation.  Dell uses high quality products
such as Seagate and IBM for HDs, so don't worry.  The main concern is
compatibility and continued support!!

3.  The majority of Dulcian's DBs are small development databases...so you
will likely never need 4x18 GB of space... 4x9 GB will suffice.  But, check
the pricing difference...if the price diff isn't too crazy...go with 18.
You should probably go with 1 9 GB for the OS and 3 18s for the database.

4.  Ultra Fibre SCSI...I'm not 100% on this, but I would say that these
drives are optimized for external storage where Fibre Channel is used to
connect the server to the storage cabinet (certainly not your case).

Ed Haskins
Oracle DBA
Verizon Wireless


-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Just thought I would throw this one out there and see what all of
you hot
shots think.  I am going to rebuild a server into a DB Server.  Currently it
has IDE drives in there and obviously I am not going to be using those.  So
I need to invest in some new SCSI drives.  Here's what I had in mind:

Either 4 X 9.2 Gig 10K RPM with 2mb Cache
OR 4 X 18.4 GIG 10K with 4MB cache

I was initially leaning towards the 9 gigs to save on cost, however someone
pointed out that 18 would be a better idea for growth down the line.  Also I
want to keep them all of the same size in case one goes down then I may have
room on another.
What are your thoughts on this?  Does anyone know what "ultra fibre
scsi"
means?  Does anyone recommend brands to stear clear of?  I know that Seagate
is a pretty good name, but I can't find any in Ultra 2?  Anyone know if
Hitachi is a good name?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

Re: Listener problems

You are out of space on that filesystem.

Check the size of your log files, as they are likely 
responsible for consuming a lot of space.  

Also check in the cdump directory for core files.

Jared

On Thursday 31 May 2001 09:16, zabair ahmed wrote:
> Has anybody come across the following error message in the listener.log,
> and know what the resolution is.
>
>
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12540: TNS:internal limit restriction exceeded
> TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
> Solaris Error: 12: Not enough space
>
> What is this Solaris Error 12?
>
> I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't
> even exist) files.
>
> 8.1.7 on Solaris 5.6
>
>
> regards
>
> Zabair
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Auto Extend

2001-05-31 Thread Kimberly Smith

Title: RE: Auto Extend

We had
an issue here where we had the Sun box to except files over 2G but got bitten in
the ass quickly by it. We use HP OmniBack to backup all our Unix boxes and
the agent on the Sun box could not handle the file size. So there is more
then just "Can the OS handle it" to keep into account. Thankfully nothing
had written to the extra portion and we were able to shrink it
again.

-Original Message-From: Lisa Koivu
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001
10:08 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Auto Extend
Hi Ron,
do you have large files enabled on
your system? What unix are you running? if large files are not enabled
you're going to get an error but I can't tell you what it will be.
Boy, autoextend reminds me of a
monkey running around in your database. I'd never do that, but it's just
my personal preference.
Lisa Koivu Oracle Database Administrator 954-935-4117
The information in the electronic mail message is
Cendant confidential and may be legally privileged, it is intended solely for
the addressee(s) access to this internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it is prohibited and may be unlawful.
The sender believes that this E-mail and any
attachments were free of any virus, worm, Trojan horse, and/or malicious code
when sent. This message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation or Affiliates are
not liable for any loss or damage arising in any way from this message or its
attachments.

-Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May
31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject: Auto Extend
I have taken over an Oracle database that is
setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles
extend beyond 2G on Unix?
.
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron
L. INET: [EMAIL PROTECTED]

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

Re: Partition Elimination

2001-05-31 Thread Jay Hostetter


Check optimizer_mode in v$parameter for your session.  I don't think it will eliminate 
partitions if it is RULE.

Here is an explain plan from a simple select on a partitioned table.  An index exists:

SELECT STATEMENT Optimizer=CHOOSE (Cost=1.69535189333285 Card=32 Bytes=3488)
  PARTITION RANGE (SINGLE)
TABLE ACCESS (BY LOCAL INDEX ROWID) OF DMS_AMA_RECORDS (Cost=1.69535189333285 
Card=32 Bytes=3488)
  BITMAP CONVERSION (TO ROWIDS)
BITMAP INDEX (SINGLE VALUE) OF DMS_AMA_RECORDS_UI1


Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA

>>> [EMAIL PROTECTED] 05/31/01 12:00PM >>>
Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


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

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

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


Take a look at /var/adm/messages for any reported errors

-Original Message-
Sent: Thursday, May 31, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L


Has anybody come across the following error message in the listener.log, and

know what the resolution is.


TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space

What is this Solaris Error 12?

I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't 
even exist) files.

8.1.7 on Solaris 5.6


regards

Zabair
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

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

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

Oracle 8.1.7 and Apache

2001-05-31 Thread Ken Ballard


Hi Folks,
I have just installed 8.1.7 on my HP-UX 11.00 box and have Apache running.
Now what?  How can I test to make sure apache is talking to oracle and
vice-versa?  The install documents don't really explain that part and I've
tried searching metalink but don't know what I'm looking for.  Help

Just sign me --  Confused in Virginia

Ken ([EMAIL PROTECTED])

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

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

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

Cartesian

2001-05-31 Thread Paul Baumgartel


I guess this has already been answered, but to clarify:

I believe "Cartesian" refers to a *product* ("Cartesian product"), not a
join.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


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

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

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

RE: select question

Title: RE: select question





I believe you'll want to rpad your return value.


select rpad(26.5,5,0) from dual


returns


26.50


or format it in SQL*Plus. 


HTH


Lisa Koivu
Oracle Database Administrator
954-935-4117


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. 







-Original Message-
From:   Keith Myers [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L
Subject:    select question


I have a select statement that is pulling a field called total, which
represents a total value to charge a persons account. The total column in
the db has the parameters Number(10,2) but when I pull the data out of the
db the value for the total 26.50 looks like this 26.5. Is there away to
force the data being pulled out to maintain the format 26.50?


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


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

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

Re: Rebuilding indexes


they should be, unless you do nologging operations -- which can mess up your 
standby database



>From: "The Oracle DBA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Rebuilding indexes
>Date: Thu, 31 May 2001 10:05:57 -0800
>
>However, if you rebuild all the indexes for schema SALES on PRIMARY, what 
>happens on STANDBY? Are they rebuilt?
>
>Cheers,
>
>Earl
>
>---
>
>TheOracleDBA
>[EMAIL PROTECTED]
>
>
>
>On Thu, 31 May 2001 08:16:06
>  Rachel Carmichael wrote:
> >there IS no way to do that with a standby database. Once you open it for
> >anything other than read-only (8i) you invalidate the standby status.
> >
> >
> >
> >
> >>From: Richard Huntley <[EMAIL PROTECTED]>
> >>Reply-To: [EMAIL PROTECTED]
> >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >>Subject: Rebuilding indexes
> >>Date: Thu, 31 May 2001 06:00:56 -0800
> >>
> >>For those of you that have implemented a standby database, what method 
>do
> >>you use to rebuild your indexes tablespace.
> >>My plan was to create a new tablespace and rebuild the indexes into the 
>new
> >>tablespace and then reverse the process to move
> >>back to the original tablespace after I drop and recreate it in order to
> >>get
> >>rid of fragmentation in the originally indexes tablespace.
> >>However, creating the new datafile associated with the new tablespace,
> >>cancels media recovery associated with the standby database...just 
>wondered
> >>if anyone has a better method of defragging an index tablespace when 
>there
> >>is a standby database catching the redo it generates.
> >>
> >>TIA,
> >>Richard Huntley
> >>
> >>--
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >>--
> >>Author: Richard Huntley
> >>   INET: [EMAIL PROTECTED]
> >>
> >>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >>San Diego, California-- Public Internet access / Mailing Lists
> >>
> >>To REMOVE yourself from this mailing list, send an E-Mail message
> >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >>the message BODY, include a line containing: UNSUB ORACLE-L
> >>(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).
> >
>
>
>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).

_
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: Partition Elimination


Yes it does.

The scan will be range of partitions and the execution plan will show
partition stop = key and partition start = key.

Regards,

Waleed

-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L


Can oracle do partition elimination when ysing bind variables?

Alex Hillman

-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Dave:

Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.

Kevin

-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


-- 
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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: How do I corrupt a block

2001-05-31 Thread K Gopalakrishnan

Hi !

The simple thing is you can edit the datablocks using
BBED editor. It is shipped with Oracle and You need a
password to use that utility. You can browse and edit
the data blocks.

$BBED will give the required details. BUT IT IS
DANGEROUS

--- novicedba <[EMAIL PROTECTED]> wrote:
> hi,
>   This  may sound funny. I want to know how to
> corrupt a block. I want to test the different
> methods of identifying block corruption, but I don't
> have sample data blocks.
> Please help me
> 
> novice
> 

=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

Re: 4 join methods?

2001-05-31 Thread PD Miller


At 9:07 -0800 31/5/01, Mogens Nørgaard wrote:
>There is certainly something new called an index join around in 8i.

An index join is a hash join on 2 or more indexes which between them
contain all the columns required to fulfill the query. It is new to
8i, and is considered to be an access pathl but strangely is not
considered to be a join method; probably because it is a hybrid of
the hash join using indices only.

Regards

Paul Miller
--
-
Carib Data Limited



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

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

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

2001-05-31 Thread Ron Rogers


Actually, Oracle 'Applications" or a flavor there of has been around for many years. 
10 + I believe. 
What CD PACK are you looking for?
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/31/01 10:50AM >>>
Still no response from Oracle Canada, I left a message again - they didn't
know what to do when people order CD Packs...

Meanwhile I saw on the 'net a job posting that had as one of the competency
requirements:  4 years experience with Oracle Applications.

I guess this is supposed to be funny.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

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

Materialized Views

2001-05-31 Thread Ron Thomas


I've been expirementing with MV for a couple of days.  Interesting gotcha's for fast 
refresh on
commit, but otherwise cool stuff.  Now for the question.

If I have a base table of 1 millions rows of time series data and I want to produce 
MVs for day,
month, and year aggregates, would it be better to:

a) base all the MVs back to the original table.  Only one mv-log this way but if I 
ever need to
perform a complete refresh, then this would require 3 scan/sort/group of the original 
table.

b) base the day MV on the original table, the month MV on the day MV, and the year MV 
on the month
MV.  Requires 3 mv-logs but a complete refresh would progressively scan/sort/group 
less data.

It may just boil down to a matter of taste.

Ron
[EMAIL PROTECTED]


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

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

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

RE: Partition Elimination

2001-05-31 Thread Hillman, Alex


Can oracle do partition elimination when ysing bind variables?

Alex Hillman

-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Dave:

Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.

Kevin

-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


-- 
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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

RE: Snapshot Logs Explanation Needed


If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete.  Thus eliminating the need to do a complete refresh of the snapshot.
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:29 PM
---

  PM PST

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


Been a while since I worked with snapshots, but if I remember correctly,
each record in a fast refresh snapshot keeps a mapping back to the rowid on
the master.  If you drop and recreate the master table, the mapping is hosed
and updates/deletes do not propagate to the snapshot.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Wednesday, May 30, 2001 5:48 PM
To: Multiple recipients of list ORACLE-L


I would like to reorg many tables which have snapshots associated with them.
I
understand that if the master table is dropped the snapshot log is also
dropped.  When a log is dropped, oracle states that you need to do a
complete
refresh of the affected snapshot.  My question is why?  If you do not allow
users to access the database with the master table, then you should not have
any transactions that would be lost.  Why can't you create a new log and
continue to do a fast refresh?   I am trying to avoid having to recreate all
the snapshots due to the size and number that we have.  Any thoughts?
Thanks


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

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

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

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

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

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

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

RE: Automating Outlook express

2001-05-31 Thread Jamadagni, Rajendra


Call Oracle support and ask for a document "Cracking Outlook Express", this
PDF will explain (thought not in complete details) how to implement this
interface. I am not sure if this file is available through Metalink
Libraries ... you can check though ...

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 !

*1

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

*1

-- 
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: Suggestions on SCSI

2001-05-31 Thread Kevin Kostyszyn


I was thinking the 18's where a better idea now that everyone agrees.
However, I can't go with more than 4 drives unfortunately, this is on a Dell
Precision 410.  I could try and add an additional scsi adapter, but I am not
sure that I would have a place for the drive, unless I went external.
Also, this is purely a development box, it's not like I need ultimate
performance, it's just a bunch of developers that will be complaining and I
can just blaim their code.  I will not be implementing any sort of raid
either.  Thanks again for the advice!!
Kev

-Original Message-
Spence
Sent: Thursday, May 31, 2001 3:24 PM
To: Multiple recipients of list ORACLE-L


18Gb with the cache all the way, I would recommend Seagate for this.  The
cost difference is small between the 9Gb and 18Gb plus 18Gb will be
replaceable for longer time than 9Gb.

I would recommend more than 4 disks though.  Specially if your implementing
raid of some sort.
If at all possible.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Just thought I would throw this one out there and see what all of
you hot
shots think.  I am going to rebuild a server into a DB Server.  Currently it
has IDE drives in there and obviously I am not going to be using those.  So
I need to invest in some new SCSI drives.  Here's what I had in mind:

Either 4 X 9.2 Gig 10K RPM with 2mb Cache
OR 4 X 18.4 GIG 10K with 4MB cache

I was initially leaning towards the 9 gigs to save on cost, however someone
pointed out that 18 would be a better idea for growth down the line.  Also I
want to keep them all of the same size in case one goes down then I may have
room on another.
What are your thoughts on this?  Does anyone know what "ultra fibre
scsi"
means?  Does anyone recommend brands to stear clear of?  I know that Seagate
is a pretty good name, but I can't find any in Ultra 2?  Anyone know if
Hitachi is a good name?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

Re: How many times has an index been used?



Steve,

If you are going to pull code from v$sqlarea, you will also want
to use v$sqltext.

In that case, look up the paper at www.hotsos.com about joining
v$sqltext and v$sqlarea, as the hash_value is defined as a 
different data type in each.  This affects all releases prior to
8.0.5.

Also, you have no doubt considered that you will need to capture
the current execution plan for each to do this, so as to see what
indexes are being used.

Jared


On Thursday 31 May 2001 03:10, Wilkes, Steve wrote:
> Hi,
>
> Thanks for the replies to this question. Looks like I need >= 8i or trawl
> through the v$sqlarea either by spending money or writing a simple bit of
> pl/sql.
>
> Thanks,
>
> Steve Wilkes
> npower
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: 29 May 2001 14:03
> To: Multiple recipients of list ORACLE-L
> Cc: [EMAIL PROTECTED]
>
>
> Hi All,
>
> A cheaper solution to this is to use an AFTER LOGON trigger to set
> CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE
> system
> privilege, you'll be able to see which indexes are being used in the
> DBA_OUTLINE_HINTS view.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
>
>
> -Original Message-
> Sent: Tuesday, 29 May 2001 19:55
> To: Multiple recipients of list ORACLE-L
>
>
> There is also one called The Big Picture - from Bit by Bit
> www.bitbybit.co.uk - that scans all source, and SQL, and stores all
> execution plans in a BDE database. It then scans through all the exectution
> plans to determine whether an index is used or not.
>
> It doesn't however tell you how many times the index has *actually* been
> used..
>
> Mark
>
> -Original Message-
> Sent: Friday, May 25, 2001 09:18
> To: Multiple recipients of list ORACLE-L
>
>
>
> There is commercial software for determining this.
>
> www.teleran.com
> www.pinecone.com
>
> Both rather spendy.
>
> Jared
>
> On Thursday 24 May 2001 06:10, Wilkes, Steve wrote:
> > Hi,
> >
> > Does anyone know how to determine how many times an index has been used
> > or if it has been used at all? I have seen previous attempts by taking
> > snapshots of v$sqlarea and then automating an explain plan and extracting
> > the information that way. I would have thought that there must be an x$
> > table that records this information somewhere?
> >
> > Any ideas?
> >
> > Thanks in advance.
> >
> > Steve Wilkes
> > ___
> > Oracle DBA
> > npower
> > email:[EMAIL PROTECTED]
>
> 
>
> This incoming e-mail (and any attachments) has been checked at
> npower, and has been found to be clean from any
> virus infection (using Sophos Sweep 3.45 + patches).
>
> npower Service Desk
>   (internal telephone 187, external 01384 275454,
>   or e-mail npower Postmasters [internally]
>   or [EMAIL PROTECTED] [externally])
>
>
> 
> =
> 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
> gpupower.co.uk or [EMAIL PROTECTED]
>
> This outgoing e-mail (and any attachments) has been checked
> (using Sophos Sweep 3.45 + patches) before leaving us (UK 08457 353637),
> and has been found to be clean from any virus infection.
>
> =
-- 
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: 4 join methods?



On Thursday 31 May 2001 10:07, Mogens Nørgaard wrote:
> There is certainly something new called an index join around in 8i.

That wouldn't be considered a new type of join though would it?

Just using indexes as a data source for the join.  They shoulda done
this a long time ago.

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: Re[2]: About parallel server


Dick, I am not sure which platform you where using for 
OPS, but you have to use raw device's. Unless you are 
using OpenVMS or Compaq TRU64 v5.1 you have to use raw 
devices for datafiles, controlfiles and online redo logs. 
Archive logs have to go to a file system. Now there are 
some unsupported things you can do to get Oracle 
datafiles on filesystems in an OPS environment but the 
key word here is unsupported.

Scott
>  Brian,
> 
>I was looking at parallel server for an application we were 
> developing last year.  In 8.1.6 at least the control and on-line redo 
> (not rollback segment) files no longer had to be on raw devices.  And I 
> stand corrected, there is one and only one standard unix command that 
> does work, dd.  It's just such a pile of alphabet soup.  That's why we 
> hired a couple of top notch Unix admins.  They handle it.
> 
> Dick Goulet
> -- Reply Separator --
> Author: Brian MacLean <[EMAIL PROTECTED]>
> Date: 5/30/01 3:50 PM
> 
> Your point 1:  
> 
> Unless things have changed redo and controlfiles must be raw.  When I 
> took
> the OPS course several years ago and worked with OPS we needed the
> redo/controlfiles to be on raw so that one instance could recover when
> another instance failed.
> 
> Your point 5:
> 
> The Unix command "dd" will do raw.
> 
> -Original Message-
> Sent: Wednesday, May 30, 2001 3:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Fernando,
> 
> Replies included in your original mail, but in addition:
> 
> Parallel server is a separately priced option from Oracle and it is
> pricey. 
> Second you may need specific software from you OS vendor to coordinate 
> the
> file
> sharing between the servers, again an additional expense.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Fernando Papa" <[EMAIL PROTECTED]>
> Date:   5/30/2001 2:07 PM
> 
> 
> Hi everybody!
> 
> I have some questions about parallel server. Now we have only one 
> instance
> "stand-alone" (no parallel), but we are thinking to switch to parallel
> server because we have a couple of sparc 3500 and nobody are using it, 
> and
> we think it's good for increase our processing power.
> 
> The problem is I didn't work with parallel server and I have a lot of
> questions about it:
> 
> 1) Is mandatory to use raw devices for control files, redo logs & data
> files?
> -->  Data files yes, redo and control files can be on cooked file 
> system.
> 
> 2) How we transfer our cooked data files to raw devices data files?
> import/export? or exist another better (fast) method?
> --> To the best of my knowledge your going to have to rebuild the 
> database
> from
> scratch so imp/exp is your only option.
> 
> 3) If I start with only one node, performance will be the same of one 
> single
> instance (no parallel)?
> --> Yes and NO, raw devices run a little faster than cooked files since 
> the
> OS's
> buffer cache is not in the middle.
> 
> 4) Somebody know how to work with raw devices under solaris? any link? I 
> try
> to found someting in metalink but there's no samples...
> --> Working with raw devices is very different from cooked file systems. 
>  If
> you
> don't have an experienced Unix admin you could be in serious trouble.
> 
> 5) What about backup? I can't put tablespaces in backup mode and copy 
> with
> cp... maybe it's time to use rman?
> --> Rman can handle the backups, but a file system level backup is
> different. 
> CP does not work anymore, nor does fbackup, or tar.  You'll need 
> specialized
> software for the purpose.
> 
> Thanks in advance!
> 
> --
> Fernando O. Papa
> DBA
> El Sitio - Infraestructura
> (54-11) 4339-3854
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fernando Papa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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

RE: problem starting oracle database

2001-05-31 Thread Kevin Kostyszyn


Is it possible that there is an error in your init file?  I have had this
problem before with Oracle 8.0.5 on NT, I had to reboot :) the machine and
then it worked, very strange.
Kev

-Original Message-
Singh
Sent: Thursday, May 31, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


Hi,

When i am trying to start my database form svrmgrl ..
i am getting error:
ORA-00205 error in identifying controlfile, check alert log for more info

there is nothing in alert.log...
i have 3 control files all r in proper directory..
i am using proper SID
i tryied with only i control file in init.ora same error...
i am using startup pfile ...so it is using proper init.ora file
What might be the cause...

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin 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).

Re: Snapshot Logs Explanation Needed

Hi Anita,
Ironically that is just what I am trying to do.  (ie implement a storage plan
which will address the issues discussed in the paper)  To your other point, I
understand oracle's position, but if I can prohibit changes to the master
during the reorg/rebuild, is this still an issue?
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:37 PM
---

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]

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

Tracy,

You may know that there were no modifications to the
master table made from the time the snapshot log was
dropped until it was recreated, but Oracle can't take
that chance, otherwise data could get out of sync.
That's why you have to either recreate your snapshot
or do a complete refresh if the snapshot log is
recreated.

To avoid recreating the snapshots I would ask why you
need to reorg your master tables (i.e. what do you
hope to accomplish by this)?  If you're doing it for
defragmentation reasons, I suggest you check out the
excellent white paper "How to stop defragmenting and
start living..." to see if this is really necessary.

http://www.vampired.net/articles/files/stopfrag.zip

HTH,

-- Anita

--- Tracy Rahmlow <[EMAIL PROTECTED]> wrote:
> I would like to reorg many tables which have
> snapshots associated with them.  I
> understand that if the master table is dropped the
> snapshot log is also
> dropped.  When a log is dropped, oracle states that
> you need to do a complete
> refresh of the affected snapshot.  My question is
> why?  If you do not allow
> users to access the database with the master table,
> then you should not have
> any transactions that would be lost.  Why can't you
> create a new log and
> continue to do a fast refresh?   I am trying to
> avoid having to recreate all
> the snapshots due to the size and number that we
> have.  Any thoughts?  Thanks
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tracy Rahmlow
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

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

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


nah. you aren't, the rest of us are :)


>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OT: Archiving not possible with SQL Server?
>Date: Thu, 31 May 2001 11:38:08 -0800
>
>
>I thought everyone would realize this is a joke.  It's been
>appearing with some regularity in a mocking tone of
>someone that posted it seriously a couple of weeks ago.
>
>Sigh...  Maybe I am just having a bad day.
>
>Jared
>
>
>On Wednesday 30 May 2001 23:50, Jared Still wrote:
> > Are you an idiot?
> >
> > Jared
> >
> > On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> > > >>Guess what happens when a long running transaction marks
> > >
> > > the log near the end, and not too long afterward the log
> > > needs truncated? If memory serves, ( hasn't worked too well lately :) 
>the
> > > database
> > > will hang.  It may just truncate back to the mark, and start from
> > > there, but you always have the possibility of another long
> > > transaction starting.<<
> > >
> > > HELP
> > >
> > > Gary Weber
> > > Senior DBA
> > > Charles Jones, LLC
> > > 609-530-1144, ext 5529
>--
>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 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: About parallel server


Rachel, OPS or in 9i RAC (Hate name changes confuses 
everyone) raw devices are a requirement of the OS not 
Oracle. So whether you are using 7, 8, 8i, 9i you can use 
filesystems for OPS (RAC) if the OS supports multiple 
concurrent mounts on the same filesystem from multiple 
nodes. This is the case in OpenVMS and Compaq TRU64 v5.1 
. If you use other OS's then the only way to share files 
is through raw devices. Now Veritas has their Cluster 
Files System(CFS) that allows multiple file systems to be 
mounted concurrently by multiple nodes. There is 
certification being conducted by Veritas and Oracle to 
support OPS in this configuration. There is more 
information about Veritas Cluster softerware at there 
site 
http://www.veritas.com/us/aboutus/pressroom/2001/01-05-15
-2.html . There is also some other information on VOS 
(Veritas, Oracle, Sun) at http://www.vosInitiative.com/ .

Scott 
> I have heard rumors that OPS on 9i will allow you to use cooked files.
> 
> User group meeting next week, with a presentation on 9i new features. 
> I'll ask
> 
> Rachel
> 
> 
> >From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: About parallel server
> >Date: Thu, 31 May 2001 06:06:38 -0800
> >
> >Dick,
> >
> >   What are you using for your source for this information?
> >This does not jibe with other things I have read.
> >If your not going to use a shared raw device for
> >the online redo logs, how can one instance to instance recovery
> >for another instance that fails?
> >
> >
> >R. Matt Adams  - GE Appliances - [EMAIL PROTECTED]
> >   Meddle not in the affairs of troff,
> >   for it is subtle and quick to anger.
> >
> >
> > > -->  Data files yes, redo and control files can be on cooked
> > > file system.
> 
> _
> 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: 
  INET: [EMAIL PROTECTED]

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

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

Re: About parallel server

2001-05-31 Thread Riyaj_Shamsudeen


Ray
        I think, you are referring to RAC, Real Application Cluster. Which is same as OPS with cache fusion for all scenarios. Please see my previous mail thread with the same subject..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Ray Stell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/31/01 11:36 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: About parallel server




I have heard from iouga attendees that there was is something
called "Rack" from oracle/compaq on the horizon with 9i which
is the next replication solution.  Can folks comment on this?
What is the architecture and how does this play with oracle?
Is this just an OPS on some alphastation?  Our compaq sales
droid didn't know the answer.  Thanks. 



On Wed, May 30, 2001 at 02:07:10PM -0800, Fernando Papa wrote:
> 
> Hi everybody!
> 
> I have some questions about parallel server. Now we have only one instance
> "stand-alone" (no parallel), but we are thinking to switch to parallel
> server because we have a couple of sparc 3500 and nobody are using it, and
> we think it's good for increase our processing power.
> 
> The problem is I didn't work with parallel server and I have a lot of
> questions about it:
> 
> 1) Is mandatory to use raw devices for control files, redo logs & data
> files?
> 2) How we transfer our cooked data files to raw devices data files?
> import/export? or exist another better (fast) method?
> 3) If I start with only one node, performance will be the same of one single
> instance (no parallel)?
> 4) Somebody know how to work with raw devices under solaris? any link? I try
> to found someting in metalink but there's no samples...
> 5) What about backup? I can't put tablespaces in backup mode and copy with
> cp... maybe it's time to use rman?
> 
> Thanks in advance!
> 
> --
> Fernando O. Papa
> DBA
> El Sitio - Infraestructura
> (54-11) 4339-3854
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fernando Papa
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

TOAD v/s PL/SQL Developer

2001-05-31 Thread Deshpande, Kirti


Folks,
 Just got an e-mail from my Damager that there is a concern about the cost
of TOAD licensees and an effort is being made to find a suitable
replacement. Evaluation of PL/SQL Developer by Allround Automations is
underway. Anyone knows the pros/cons of using this (PL/SQL Developer)
product in place of TOAD. We have been TOADing since it used to be a
freeware. 
All and any comments welcome..
Thanks

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

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

Re: SQL problem: retrieve child records if existent

2001-05-31 Thread Stephane Faroult


Helmut Daiminger wrote:
> 
> Hi!
> 
> I have a SQL problem here, which I can't solve.
> 
> I have a B-tree structure in a table (parentID, childID).
> 
> If a parent has kids then select those kids. If not, select this parent.
> 
> How do I code this in SQL? I tried using "connect by" but this doesn't
> include start point.
> 
> Any idea?
> 
> This is 8.1.6 on Win2k.
> 
> Thanks,
> Helmut
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Helmut Daiminger
>   INET: [EMAIL PROTECTED]


   select t.id, t.name
   from your_table t
   where t.id = what you are looking for
 and not exists (select null 
 from your_table t2
 where t2.parent_id = t.id)
   union
   select t.id, t.name
   from your_table t
   where t.parent_id = what you are looking for

 Index on parent_id, please.

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Re: OT: Archiving not possible with SQL Server?


I want to know if it is allowable to kill programmers who say "these are the 
rules for data in this column" but then don't enforce those same rules.

Rachel (rolling up her sleeves, putting on the rubber gloves to begin data 
scrubbing really BAD data)


>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OT: Archiving not possible with SQL Server?
>Date: Thu, 31 May 2001 11:38:08 -0800
>
>
>I thought everyone would realize this is a joke.  It's been
>appearing with some regularity in a mocking tone of
>someone that posted it seriously a couple of weeks ago.
>
>Sigh...  Maybe I am just having a bad day.
>
>Jared
>
>
>On Wednesday 30 May 2001 23:50, Jared Still wrote:
> > Are you an idiot?
> >
> > Jared
> >
> > On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> > > >>Guess what happens when a long running transaction marks
> > >
> > > the log near the end, and not too long afterward the log
> > > needs truncated? If memory serves, ( hasn't worked too well lately :) 
>the
> > > database
> > > will hang.  It may just truncate back to the mark, and start from
> > > there, but you always have the possibility of another long
> > > transaction starting.<<
> > >
> > > HELP
> > >
> > > Gary Weber
> > > Senior DBA
> > > Charles Jones, LLC
> > > 609-530-1144, ext 5529
>--
>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 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: Auto Extend

2001-05-31 Thread Gary Weber


Never say never :)

I opted for 4 GB files in a larger database which is living happily on EMC
Sym box. If hardware and software allow for fewer, easier managed large
files...why not? This is scratching the surface of course...

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

-Original Message-
Sent: Thursday, May 31, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


By the way ...   For your own sake . never use data files that big
!!My personal opinion is multiple files of 500 Megs or less .   Or, on a
system that has a file limit, 1 GB files as a Max.   Larger than that and
you can have problems with backup software   long running FTPs if you
duplicate DBs ...etc.

-Original Message-
Sent: Thursday, May 31, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L


What do you mean by 'the system is not set up'.  How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit.  Is it documented?
Please explain.  Thank you.

-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


If the system is not setup to allow files bigger than 2 GB then the
datafiles WILL NOT EXTEND and you will get an oracle error.

-Original Message-
Sent: Thursday, May 31, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?

.

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

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

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

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

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

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

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

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

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

RE: Auto Extend

2001-05-31 Thread lhoska


What do you mean by 'the system is not set up'.  How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit.  Is it documented?
Please explain.  Thank you.

-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


If the system is not setup to allow files bigger than 2 GB then the
datafiles WILL NOT EXTEND and you will get an oracle error.

-Original Message-
Sent: Thursday, May 31, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?

. 

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

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

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

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

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



It apparently is only on NT, and unless you have the password,
which is known only to Oracle Support Personnel, you can't
use it.

http://www.ixora.com.au/q+a/0101/23224038.htm

Jared


On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote:
> Hi !
>
>
> The simple thing is you can edit the datablocks using
> BBED editor. It is shipped with Oracle and You need a
> password to use that utility. You can browse and edit
> the data blocks.
>
>
> $BBED will give the required details. BUT IT IS
> DANGEROUS
>
> --- novicedba <[EMAIL PROTECTED]> wrote:
> > hi,
> >   This  may sound funny. I want to know how to
> > corrupt a block. I want to test the different
> > methods of identifying block corruption, but I don't
> > have sample data blocks.
> > Please help me
> >
> > novice
>
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Implementing Stored Procedures

2001-05-31 Thread Jamadagni, Rajendra

HTH
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 !

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

Title: Implementing Stored Procedures

We put
the code in a file on Unix (our server platform) and in the change request form,
provide the file name and location. The DBA will log in as the schema owner and
simply run the file. Any errors are reported back to developer who requested the
change. All the SQL code is archived using SCCS.
HTH
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 !

Re: OT: Archiving not possible with SQL Server?

I thought everyone would realize this is a joke.  It's been 
appearing with some regularity in a mocking tone of
someone that posted it seriously a couple of weeks ago.

Sigh...  Maybe I am just having a bad day.

Jared

On Wednesday 30 May 2001 23:50, Jared Still wrote:
> Are you an idiot?
>
> Jared
>
> On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> > >>Guess what happens when a long running transaction marks
> >
> > the log near the end, and not too long afterward the log
> > needs truncated? If memory serves, ( hasn't worked too well lately :) the
> > database
> > will hang.  It may just truncate back to the mark, and start from
> > there, but you always have the possibility of another long
> > transaction starting.<<
> >
> > HELP
> >
> > Gary Weber
> > Senior DBA
> > Charles Jones, LLC
> > 609-530-1144, ext 5529
-- 
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: About parallel server


Ray, Oracle9i RAC (Real Application Clusters) is or was 
(depending on your perspective) Oracle Parallel Server. 
Compaq is working with Oracle to pre-install and ship 
Oracle9i on there NT boxes (not sure about TRU64 or 
OpenVMS platforms), so you just turn it on and it works. 
Oracle9i replication is another animal all together. 
There are some major changes to way you can replicate in 
9i. 

Scott
> 
> 
> I have heard from iouga attendees that there was is something
> called "Rack" from oracle/compaq on the horizon with 9i which
> is the next replication solution.  Can folks comment on this?
> What is the architecture and how does this play with oracle?
> Is this just an OPS on some alphastation?  Our compaq sales
> droid didn't know the answer.  Thanks. 
> 
> 
> 
> On Wed, May 30, 2001 at 02:07:10PM -0800, Fernando Papa wrote:
> > 
> > Hi everybody!
> > 
> > I have some questions about parallel server. Now we have only one instance
> > "stand-alone" (no parallel), but we are thinking to switch to parallel
> > server because we have a couple of sparc 3500 and nobody are using it, and
> > we think it's good for increase our processing power.
> > 
> > The problem is I didn't work with parallel server and I have a lot of
> > questions about it:
> > 
> > 1) Is mandatory to use raw devices for control files, redo logs & data
> > files?
> > 2) How we transfer our cooked data files to raw devices data files?
> > import/export? or exist another better (fast) method?
> > 3) If I start with only one node, performance will be the same of one single
> > instance (no parallel)?
> > 4) Somebody know how to work with raw devices under solaris? any link? I try
> > to found someting in metalink but there's no samples...
> > 5) What about backup? I can't put tablespaces in backup mode and copy with
> > cp... maybe it's time to use rman?
> > 
> > Thanks in advance!
> > 
> > --
> > Fernando O. Papa
> > DBA
> > El Sitio - Infraestructura
> > (54-11) 4339-3854
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Fernando Papa
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> -- 
> ===
> Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ray Stell
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
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).

digital tru64 unix

Title: digital tru64 unix





Hello everyone, 


Anyone out there running Oracle on this flavor of Unix?  If so can you please email me directly?
I don't have a Unix box to play with and I have a few simple performance questions.   I'm also looking in the online doco and I don't see what I'm looking for (yet).

Thanks in advance


Lisa Koivu
Oracle Database Administrator
954-935-4117


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.

Re: what's hash-join

2001-05-31 Thread Shevtsov, Eduard

Title: RE: what's hash-join

Hi Lisa,

You're correct.
I'm sure you know, but I'd like to add that 

hash join usually works faster than over 
methods
when there are no good selective conditions 
in the
clause WHERE.

Regards,
Ed

  Hi Kevin, 
  It's quick if you have the temp space 
  to support it.  however with larger tables my experience has been that it 
  blows temp, isn't that much faster even if you do have the temp space, and in 
  most cases you are better off with index-driven nested loops join.  It 
  works well with small to medium-sized tables.
  Just my .02 
  List, if I'm wrong, please correct 
  me. 
  Lisa Koivu Oracle Database Administrator 954-935-4117 
  The information in the electronic mail message is 
  Cendant confidential and may be legally privileged, it is intended solely for 
  the addressee(s) access to this internet electronic mail message by anyone 
  else is unauthorized. If you are not the intended recipient, any disclosure, 
  copying, distribution or any action taken or omitted to be taken in reliance 
  on it is prohibited and may be unlawful.
  The sender believes that this E-mail and any 
  attachments were free of any virus, worm, Trojan horse, and/or malicious code 
  when sent. This message and its attachments could have been infected during 
  transmission. By reading the message and opening any attachments, the 
  recipient accepts full responsibility for taking protective and remedial 
  action about viruses and other defects. Cendant Corporation or Affiliates are 
  not liable for any loss or damage arising in any way from this message or its 
  attachments. 

-Original Message- From:   Kevin 
Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, May 
31, 2001 9:34 AM To: Multiple recipients of list ORACLE-L Subject:    RE: what's hash-join 
What's the performance (gain/loss) on such a 
join, when would you want to use 
one? Kev 
-Original Message- McDonald Sent: 
Thursday, May 31, 2001 6:00 AM To: 
Multiple recipients of list ORACLE-L 
A method of joining two tables.  You scan 
each and use a hashing algorithm to 
isolate/match keys. 
hth connor 
--- Senthil Ganapathi <[EMAIL PROTECTED]> wrote: > > Hi Rukmini > 
could tell me what's that hash-join > > GSK > > 
> > > 
"Rukmini > > 
Devi"    
To: > Multiple recipients of list 
ORACLE-L > 
 > 
<[EMAIL PROTECTED]> > 
rain.com>    
cc: > > 
Sent 
by: 
Subject: >  Re: 4 join 
methods? > 
root@fatcity. > > 
com > > > > > 
> 
31-05-01 > > 
09:55 AM > > 
Please > > 
respond to > > 
ORACLE-L > > > > > 
> > > > > 1. 
Equi-join 2. Self-join 3. 
Outer-join  4. > Hash-join 
> > 
rukmini > - Original Message 
- > To: "Multiple recipients of 
list ORACLE-L" > 
<[EMAIL PROTECTED]> > Sent: 
Thursday, May 31, 2001 11:20 AM > > > > i feel the fourth one is self join. 
> > > > - Original Message - > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Sent: Thursday, May 31, 2001 8:10 AM 
> > > > > > > 
Hi, > > > > > > I just read there are four join 
methods.  I know > three: 
> > > > > > Nested loops > 
> > Sort merge > > > Hash 
join > > > > > > What's the fourth? > > > > 
> > - Greg > > > 
> > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > 
> > Author: Greg Moore > > 
>   INET: [EMAIL PROTECTED] > > > > > > Fat 
City Network Services    -- (858) 538-5051 > FAX: (858) 538-5051 > > > San Diego, 
California    -- Public 
Internet > access / Mailing 
Lists > > > >  
> > > To REMOVE yourself from this 
mailing list, send > an E-Mail 
message > > > to: 
[EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > 
> the message BODY, include a line containing: > UNSUB ORACLE-L > > > (or the name of mailing list you want to be 
> 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: Saurabh Sharma > 
>   INET: [EMAIL PROTECTED] > > > > Fat City 
Network Services    -- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, 
California    -- Public 
Internet > access / Mailing 
Lists > > >  
> > To REMOVE yourself from this mailing 
list, send an > E-Mail message

RE: 4 join methods?


I think you mean bitmap join indexes which is a new feature in 9i.

Regards,

Waleed

-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


There is certainly something new called an index join around in 8i.

[EMAIL PROTECTED] wrote:

> I wonder if their thinking of the star join??
>
> Dick Goulet
>
> Reply Separator
> Author: =?iso-8859-1?q?Connor=20McDonald?= <[EMAIL PROTECTED]>
> Date:   5/31/2001 5:00 AM
>
> And with all the "hoopla" that Oracle are spouting,
> I'm sure they'll be trying to convince us that (8i)
> partition wise join is a "new" type as well..
>
> :-)
>
> Connor
>
> --- PD Miller <[EMAIL PROTECTED]> wrote: > At
> 22:55 -0800 30/5/01, Rukmini Devi wrote:
> > >1. Equi-join 2. Self-join 3. Outer-join  4.
> > Hash-join
> >
> > Outer join is a logical type not an access method.
> >
> > the four types of join that Oracle can use:
> >
> > Nested Loops join
> > Sort Merge join (equi-join only)
> > Cluster join (equi-join on cluster key only)
> > Hash join (equijoin, cost-based only)
> >
> > Regards
> >
> > Paul Miller
> > --
> > -
> > Carib Data Limited
> >
> > 
> > 
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: PD Miller
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (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:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Rebuilding indexes


Richard,

Thanks! Now let me know if the book is actually useful...

I think you are going to have to bite the bullet and do the rebuild with 
logging. And, since this is something you may have to do over and over 
again, I'd create that extra tablespace and datafile and leave them there on 
both the primary and standby databases, as long as you have the disk space 
to do so.

I see why you don't want to have to add the datafile to the standby 
database, as you want to end up with the index back where it was. BUT... 
nologging operations don't carry over properly, you can end up needing to do 
recovery and have corrupted blocks.

I did a quick check on metalink, advanced search looking for standby 
database nologging:

Doc ID Note:126041.1
Clause

this was last updated March 6, 2001 so it's pretty current:


"In some SQL statements, you have the option of specifying the NOLOGGING 
clause, which indicates that the database operation is not logged in the 
redo log file.  Even though you specify the NOLOGGING clause, a redo log 
record is still written to the redo log.  However, when the redo log file is 
transferred to the standby site and applied to the standby database, a 
portion of the datafile is unusable and marked unrecoverable. "

and from one of the forums:

"Please note that the object is created and logged, however the population 
of the object is not and after a recovery operation the blocks occupied by 
the object are marked as corrupted. Attempts to access the object should 
encounter an error.

The behavior with regards to a standby database is not really any different 
than a recovery operation on the primary database.

NOLOGGING operations are discussed in the Oracle8i Standby Database White 
Paper which is available from the Oracle Server Enterprise Edition Generic 
Technical Library under White Papers -> Center of Expertise Articles

Oracle8i Standby Database
Note:76451.1 "

Sorry

hth

Rachel

>From: Richard Huntley <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rebuilding indexes
>Date: Thu, 31 May 2001 10:21:00 -0800
>
>Rachel,
>
>First, let me say that I just bought your book, so I definitely appreciate
>any comments coming from you!!  :)  I'm simply trying to defrag the indexes
>tablespace of the primary database, which I've done in the past as I
>described below.  Now that I have a standby database out there, I just want
>to make the rebuild as efficient as possible without a bunch of added 
>steps,
>if I can avoid them, so I thought I'd ask for suggestions for better ways 
>of
>doing this.
>
>At the moment, however, it's looking like I'll be forced to add the 
>datafile
>to the standby database, even though I'll use NOLOGGING to rebuild the
>indexes.  The additional tablespace/datafile, I'll build on the primary and
>do the rebuild to the new tablespace then back to the old after I drop and
>recreate the old.  The problem comes in with the redo generated from the
>creation of the new tablespace being carried to the standby database.  I 
>was
>hoping I wouldn't have to add the datafile to the standby database.  With
>the standby database in mind, would you suggest that I do the index rebuild
>with or without logging?
>
>TIA,
>
>Richard Huntley
>E-mail: [EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Thursday, May 31, 2001 12:16 PM
>To: Multiple recipients of list ORACLE-L
>
>
>there IS no way to do that with a standby database. Once you open it for
>anything other than read-only (8i) you invalidate the standby status.
>
>
>
>
> >From: Richard Huntley <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Rebuilding indexes
> >Date: Thu, 31 May 2001 06:00:56 -0800
> >
> >For those of you that have implemented a standby database, what method do
> >you use to rebuild your indexes tablespace.
> >My plan was to create a new tablespace and rebuild the indexes into the 
>new
> >tablespace and then reverse the process to move
> >back to the original tablespace after I drop and recreate it in order to
> >get
> >rid of fragmentation in the originally indexes tablespace.
> >However, creating the new datafile associated with the new tablespace,
> >cancels media recovery associated with the standby database...just 
>wondered
> >if anyone has a better method of defragging an index tablespace when 
>there
> >is a standby database catching the redo it generates.
> >
> >TIA,
> >Richard Huntley
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Richard Huntley
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note E

OFF TOPIC: freeware search

2001-05-31 Thread Charlie Mengler


I'm looking for recommendations for Windows based s/w
that does the equivalent of SCCS/RCS on Unix. A command
line interface is a requirement; GUI is optional.

TIA & HAND!

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Perl is great.  It lets you turn line noise into useful code.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

RE: Rebuilding indexes

2001-05-31 Thread Jeremiah Wilton

No need to copy the whole file to the standby when adding a datafile!  Just wait
for recovery to fail on the new file (ORA-01670), then type on the standby (in
'mount standby database' mode):

SQL> alter database create datafile '' as '';

As long as you are using identical paths on both primary and standby, both
filenames are the same.  Our standby log applier does this automatically, so no
manual intervention is required.

If you use logical volumes or raw, just make sure the volume is where the system
expects it to be on the standby.

If the original poster wants to create a scratch tablespace where the indexes
will be initially rebuilt, then move the indexes back into the "real"
tablespace, he can probably just 'offline drop' the datafiles for the scratch
space on the standby when recovery encounters them.  Once the indexes have all
been rebuilt nologging into the original tablespace, all that's left is to
refresh the datafiles for that tablespace onto the primary.  When the scratch
tablespace is dropped on the primary, the offline dropped datafile records in
the standby's controlfile will also disappear.

With regard to logging/nologging, with index rebuilds, I would rebuild the
indexes NOLOGGING, and when you are all done, refresh the datafiles for the
newly reorganized tablespace onto the standby.  That saves on space, operations,
time and reduces the logs you have to back up.

Nologging operations are not harmful to the standby - you just have to keep
track of nologging operations and refresh datafiles on the standby accordingly.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 31 May 2001, Rachel Carmichael wrote:

> It adds the datafile NAME only, not the file itself. And if the physical
> file has not been moved before the archived log that has that redo in it is
> applied, the recovery dies.
>
> >From: Hatzistavrou Giannis <[EMAIL PROTECTED]>
> >
> >You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and
> >Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles
> >states the following:
> >
> >"Adding a datafile to your primary database generates redo data that, when
> >applied at your standby, automatically adds the datafile name to the
> >standby
> >control file."
> >There is also a detailed example on how to do it
> >
> > > -Original Message-
> > > From: Richard Huntley [SMTP:[EMAIL PROTECTED]]
> > >
> > > For those of you that have implemented a standby database, what method
> >do
> > > you use to rebuild your indexes tablespace.
> > > My plan was to create a new tablespace and rebuild the indexes into the
> > > new
> > > tablespace and then reverse the process to move
> > > back to the original tablespace after I drop and recreate it in order to
> > > get
> > > rid of fragmentation in the originally indexes tablespace.
> > > However, creating the new datafile associated with the new tablespace,
> > > cancels media recovery associated with the standby database...just
> > > wondered
> > > if anyone has a better method of defragging an index tablespace when
> >there
> > > is a standby database catching the redo it generates.

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

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

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

Re: How to send email from pl/sql in 806?



As Kevin Lange pointed out, you need the correct access to UTL_TCP.

If you have access to this package through a role, you won't be
able to do this.  You must login as sys and give an explicit grant:

  e.g. grant execute on sys.utl_tcp to scott;

Whe you say that the package is shown as valid in dba_objects
for sys, I assume you are talking about the UTL_TCP package.

That doesn't matter; if you don't have the explicit grant, you can't
create a stored procedure using this package.

Jared



On Thursday 31 May 2001 01:21, Saurabh Sharma wrote:
> hi Jared,
>
> my execution cmd goes like..
> EXECUTE
> SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello')
>
> it's giving the following error msgs..
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYS.UTL_TCP" does not exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "SYS.SEND_MAIL", line 10
> ORA-06512: at line 2
>
> the package is shown as valid in dba_objects for sys.
>
>
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 12:05 PM
>
> > Your procedure is masking the error in the exception block.
> >
> > Comment out the exception block to see the real error.
> >
> > Jared
> >
> > On Wednesday 30 May 2001 22:18, you wrote:
> > > it gives other error msg which are defined in the exception body inside
>
> the
>
> > > procedure.
> > > here it goes..
> > >
> > > EXCEPTION
> > >   when others then
> > >raise_application_error(-2,'Unable to send e-mail message
>
> from
>
> > > pl/sql');
> > >
> > > this msg is returned with ora 06512
> > >
> > > any suggestions..
> > > - Original Message -
> > > From: Jared Still <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>; Saurabh Sharma <[EMAIL PROTECTED]>
> > > Sent: Wednesday, May 30, 2001 9:43 PM
> > > Subject: Re: How to send email from pl/sql in 806?
> > >
> > > > On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote:
> > > > > should i give it all four arguments. but it still not executing
>
> saying
>
> > > > > ora-06512
> > > >
> > > > There are always other error messages accompanying an ORA-6512.
> > > >
> > > > What are they?
> > > >
> > > > Jared
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: How to encrypt Password in Export script file ?

2001-05-31 Thread Nirmal Kumar Muthu Kumaran




> -Original Message-
> From: Fisher, Julie [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:16 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How to encrypt Password in Export script file ?
> 
> I also did this on all my databases - works very slick.
> 
> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA - OCP8i
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
> 
> 
> -Original Message-
> Sent: May 31, 2001 7:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> instead of that, I create an account in the database that is identified 
> externally (can only run from that server, and does not have a login 
> password). You will need a matching Unix account for it, if the unix
> account
> 
> is "exportacct" then create the database account as "ops$exportacct"
> 
> grant this account create session and exp_full_database
> 
> then change your shell script to read userid="/"  and run the script from 
> the exportacct account
> 
> this way you don't need to hardcode a password ANYWHERE
> 
> Rachel
> 
> 
> >From: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: How to encrypt Password in Export script file ?
> >Date: Thu, 31 May 2001 00:50:22 -0800
> >
> >Hi Unix Gurus,
> >
> >My daily export file (daily_exp.sh) contains :
> >exp userid='system/password' file=file_name.dmp grants=y rows=y
> >constraints=y compress=y full=y inctype=complete log=file_name.log
> >
> >The system password is stated clearly in the export script file. Has
> anyone
> >encrypt/decrypt the system password before passing it as a variable to
> the
> >export script ? If yes, could I have a copy of your script ? Thanks.
> >
> >Regds,
> >New Bee in Unix
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: CHAN Chor Ling Catherine (CSC)
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(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).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fisher, Julie
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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).

deadlock error in oracle8.1.7 on sun solaris

2001-05-31 Thread Seema Singh


Hi
Some time I am receiving the following information in alert logs.
"ORA-60: Deadlock detected." and .trc file generated.Let me know what to 
do to prevent such error.
Thanks
-seema

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

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

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

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

RE: About parallel server


Fernando, If your current resources are limited and the 
app is partitioned, you should have very few problems 
implementing the App in OPS (famous last words). If HA is 
a requirement and fast failover times OPS is a good pick.  
Just make sure the ends justify the means. Some people 
have good experiences with OPS and others may not have 
had great experiences. 

Scott
> 
> We have a couple of independent applications running over the same instance
> now (it's better to do it because our resources cant' support two instances
> over the same machine), we think if we use parallel server, we can make
> "partition" of this applications, one for each node or someting like that...
> And, of course, we are thinking about automatic failover and high
> availability over parallel server...
> 
> --
> Fernando O. Papa
> DBA
> El Sitio - Infraestructura
> (54-11) 4339-3854
> 
> > -Mensaje original-
> > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Rachel
> > Carmichael
> > Enviado el: miércoles, 30 de mayo de 2001 23:50
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re:About parallel server
> >
> >
> >
> > Even more importantly, if you are planning on implementing
> > parallel server
> > just "to increase your processing power" then you are going to be in
> > trouble!
> >
> > If you haven't specifically designed your application for
> > parallel server,
> > you can end up DECREASING performance by increasing locking and pings.
> >
> > This is not something you do lightly once an app has been
> > installed into
> > production.
> >
> > Rachel
> >
> > >From: [EMAIL PROTECTED]
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: Re:About parallel server
> > >Date: Wed, 30 May 2001 14:48:03 -0800
> > >
> > >Fernando,
> > >
> > > Replies included in your original mail, but in addition:
> > >
> > > Parallel server is a separately priced option from
> > Oracle and it is
> > >pricey.
> > >Second you may need specific software from you OS vendor to
> > coordinate the
> > >file
> > >sharing between the servers, again an additional expense.
> > >
> > >Dick Goulet
> > >
> > >Reply Separator
> > >Author: "Fernando Papa" <[EMAIL PROTECTED]>
> > >Date:   5/30/2001 2:07 PM
> > >
> > >
> > >Hi everybody!
> > >
> > >I have some questions about parallel server. Now we have
> > only one instance
> > >"stand-alone" (no parallel), but we are thinking to switch
> > to parallel
> > >server because we have a couple of sparc 3500 and nobody are
> > using it, and
> > >we think it's good for increase our processing power.
> > >
> > >The problem is I didn't work with parallel server and I have a lot of
> > >questions about it:
> > >
> > >1) Is mandatory to use raw devices for control files, redo
> > logs & data
> > >files?
> > >-->  Data files yes, redo and control files can be on cooked
> > file system.
> > >
> > >2) How we transfer our cooked data files to raw devices data files?
> > >import/export? or exist another better (fast) method?
> > >--> To the best of my knowledge your going to have to
> > rebuild the database
> > >from
> > >scratch so imp/exp is your only option.
> > >
> > >3) If I start with only one node, performance will be the
> > same of one
> > >single
> > >instance (no parallel)?
> > >--> Yes and NO, raw devices run a little faster than cooked
> > files since the
> > >OS's
> > >buffer cache is not in the middle.
> > >
> > >4) Somebody know how to work with raw devices under solaris?
> > any link? I
> > >try
> > >to found someting in metalink but there's no samples...
> > >--> Working with raw devices is very different from cooked
> > file systems.
> > >If you
> > >don't have an experienced Unix admin you could be in serious trouble.
> > >
> > >5) What about backup? I can't put tablespaces in backup mode
> > and copy with
> > >cp... maybe it's time to use rman?
> > >--> Rman can handle the backups, but a file system level backup is
> > >different.
> > >CP does not work anymore, nor does fbackup, or tar.  You'll need
> > >specialized
> > >software for the purpose.
> > >
> > >Thanks in advance!
> > >
> > >--
> > >Fernando O. Papa
> > >DBA
> > >El Sitio - Infraestructura
> > >(54-11) 4339-3854
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Fernando Papa
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access /
> > Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from).  You may
> > >also send the HELP command for other infor

Re: About parallel server

2001-05-31 Thread Ray Stell

On Thu, May 31, 2001 at 11:17:30AM -0800, [EMAIL PROTECTED] wrote:
> Ray
> I think, you are referring to RAC, Real Application Cluster. Which 
> is same as OPS with cache fusion for all scenarios. Please see my previous 
> mail thread with the same subject..

-- 
 index oracle-l
The archive for this mailing list exists, but cannot be accessed.  This may be
due to the server being down or some other network problem.  Please contact

[EMAIL PROTECTED]

for further assistance.  Sorry for the inconvenience.

--
anybody got a copy of this thread I can borrow.  I'll give it
back!
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

Resizing Log file

2001-05-31 Thread Nirmal Kumar Muthu Kumaran


hi dba's,

In my DB, oracle 816, NT4,  the redolog member's size is only 50kb. I'm
having only two groups with a single member each.

I tried with alter database command, there is only options for adding and
droping log group or member...

How can i resize it.. to increase the size 5mb.

Regards,
Nirmal.
-- 
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: Partition Elimination

2001-05-31 Thread Toepke, Kevin M


At parse time, the optimizer determines that partition elimination can be
done -- which partitions to use is determined after the values are bound to
the query.

-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L


Can oracle do partition elimination when ysing bind variables?

Alex Hillman

-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Dave:

Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.

Kevin

-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Can anyone help me with this.

I have range partitioned a table (no indexes) and then computed statistics.
I have now queried the table using the partition key as the only criteria in
the where clause.  Why does Oracle still do a full table scan, why is it not
clever enough to only scan the partition(s) effected by the where
condition?.

The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs.  If anyone can point me
to a section of the documentation that covers this I would be grateful.  

Many Thanks,

Dave Leach


** 
The above information is confidential to the addressee and may be
privileged.  Unauthorised access and use is prohibited. 

Internet communications are not secure and therefore this Company does not
accept legal responsibility for the contents of this message. 

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. 

Hogg Robinson PLC 
Registered Office: Abbey House, 282 Farnborough Road, 
Farnborough, 
Hampshire GU14 7NJ 
Registered in England and Wales No 3249700 

** 


-- 
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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

Title: RE: Resizing Log file





Nirmal, 


you need to add new groups with a new redo log size, force the switch, and drop the small redo log groups once they are not active and have been archived.  Check the doco for exact syntax.  You can't just resize them iirc. 

Be sure to have at least two logs in each group, unless you don't want to keep your redo logs :)
Lisa Koivu
Oracle Database Administrator
954-935-4117


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. 



-Original Message-
From:   Nirmal Kumar  Muthu Kumaran [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L
Subject:    Resizing Log file


hi dba's,


In my DB, oracle 816, NT4,  the redolog member's size is only 50kb. I'm
having only two groups with a single member each.


I tried with alter database command, there is only options for adding and
droping log group or member...


How can i resize it.. to increase the size 5mb.


Regards,
Nirmal.
-- 
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: Snapshot Logs Explanation Needed


If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete.  Thus eliminating the need to do a complete refresh of the snapshot.
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:29 PM
---

  PM PST

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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


Been a while since I worked with snapshots, but if I remember correctly,
each record in a fast refresh snapshot keeps a mapping back to the rowid on
the master.  If you drop and recreate the master table, the mapping is hosed
and updates/deletes do not propagate to the snapshot.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Wednesday, May 30, 2001 5:48 PM
To: Multiple recipients of list ORACLE-L


I would like to reorg many tables which have snapshots associated with them.
I
understand that if the master table is dropped the snapshot log is also
dropped.  When a log is dropped, oracle states that you need to do a
complete
refresh of the affected snapshot.  My question is why?  If you do not allow
users to access the database with the master table, then you should not have
any transactions that would be lost.  Why can't you create a new log and
continue to do a fast refresh?   I am trying to avoid having to recreate all
the snapshots due to the size and number that we have.  Any thoughts?
Thanks


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

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

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

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

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

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

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

Re: select question

2001-05-31 Thread Ron Rogers


If you know the size of the number (in position count not value) you can use the 
RPAD(sum(field),count,0) to populate the right end of the return value to zero.  
ex. the sum value is = 2.5 and you want 2.50 rpad(sum(fd1,4,'0') return 2.50

BUT if the return value = 25.5 and you want 25.50 and have used the 2.50 
rpad(sum(fd1,4,'0')  the return 25.5  will be returned. You could always use
2.50 rpad(sum(fd1,6,'0') and then drop the unneeded zeroes.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/31/01 12:21PM >>>
I have a select statement that is pulling a field called total, which
represents a total value to charge a persons account. The total column in
the db has the parameters Number(10,2) but when I pull the data out of the
db the value for the total 26.50 looks like this 26.5. Is there away to
force the data being pulled out to maintain the format 26.50?

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

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

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

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

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

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

RE: OT: Archiving not possible with SQL Server?

2001-05-31 Thread Gary Weber

Jared/all,

A joke is exactly how I read it and is how I meant my request for HELP to
come across :).

Btw, thanks to everyone for interesting replies, reaffirming my grim
suspicions about MS idea of "archiving"...

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

-Original Message-
Sent: Thursday, May 31, 2001 2:39 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]

I thought everyone would realize this is a joke.  It's been
appearing with some regularity in a mocking tone of
someone that posted it seriously a couple of weeks ago.

Sigh...  Maybe I am just having a bad day.

Jared

On Wednesday 30 May 2001 23:50, Jared Still wrote:
> Are you an idiot?
>
> Jared
>
> On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> > >>Guess what happens when a long running transaction marks
> >
> > the log near the end, and not too long afterward the log
> > needs truncated? If memory serves, ( hasn't worked too well lately :)
the
> > database
> > will hang.  It may just truncate back to the mark, and start from
> > there, but you always have the possibility of another long
> > transaction starting.<<
> >
> > HELP
> >
> > Gary Weber
> > Senior DBA
> > Charles Jones, LLC
> > 609-530-1144, ext 5529

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

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

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

RE: 4 join methods?

2001-05-31 Thread Christopher Spence


i don't think it is considered a join, from what I remember it was called
"merging indexes".

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 31, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L



On Thursday 31 May 2001 10:07, Mogens Nørgaard wrote:
> There is certainly something new called an index join around in 8i.

That wouldn't be considered a new type of join though would it?

Just using indexes as a data source for the join.  They shoulda done
this a long time ago.

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

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

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

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

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

RE: Rebuilding indexes

2001-05-31 Thread Thater, William


On Thu, 31 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->It adds the datafile NAME only, not the file itself. And if the physical
->file has not been moved before the archived log that has that redo in it is
->applied, the recovery dies.

so if you got the file in the right place first, it wouldn't barff?
--
Bill Thater Certifiable 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.
~~
Software engineer: One who engineers others into writing the code for him/her.

-- 
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: Suggestions on SCSI

2001-05-31 Thread Christopher Spence


1.  Most all drives have cache on the drive.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 31, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L


Kev,

1.  I have never heard of a cache directly on the hard drive (Which
certainly doesn't mean it doesn't exist).  I have heard of a cache on the
controller for the HD!

2.  I assume that you are looking at upgrading one of the Dell Workstations,
yes?  If so, I highly recommend calling Dell and ordering HD's from them
that are supported for that Workstation.  Dell uses high quality products
such as Seagate and IBM for HDs, so don't worry.  The main concern is
compatibility and continued support!!

3.  The majority of Dulcian's DBs are small development databases...so you
will likely never need 4x18 GB of space... 4x9 GB will suffice.  But, check
the pricing difference...if the price diff isn't too crazy...go with 18.
You should probably go with 1 9 GB for the OS and 3 18s for the database.

4.  Ultra Fibre SCSI...I'm not 100% on this, but I would say that these
drives are optimized for external storage where Fibre Channel is used to
connect the server to the storage cabinet (certainly not your case).

Ed Haskins
Oracle DBA
Verizon Wireless


-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Hi all,
Just thought I would throw this one out there and see what all of
you hot
shots think.  I am going to rebuild a server into a DB Server.  Currently it
has IDE drives in there and obviously I am not going to be using those.  So
I need to invest in some new SCSI drives.  Here's what I had in mind:

Either 4 X 9.2 Gig 10K RPM with 2mb Cache
OR 4 X 18.4 GIG 10K with 4MB cache

I was initially leaning towards the 9 gigs to save on cost, however someone
pointed out that 18 would be a better idea for growth down the line.  Also I
want to keep them all of the same size in case one goes down then I may have
room on another.
What are your thoughts on this?  Does anyone know what "ultra fibre
scsi"
means?  Does anyone recommend brands to stear clear of?  I know that Seagate
is a pretty good name, but I can't find any in Ultra 2?  Anyone know if
Hitachi is a good name?
Thanks in advance.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

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

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

Re: Resizing Log file

2001-05-31 Thread Dennis M. Heisler


Add new log groups (I'd go with at least 3 groups of 2) with 5MB files,
then drop the old log groups.

Dennis


Nirmal Kumar Muthu Kumaran wrote:
> 
> hi dba's,
> 
> In my DB, oracle 816, NT4,  the redolog member's size is only 50kb. I'm
> having only two groups with a single member each.
> 
> I tried with alter database command, there is only options for adding and
> droping log group or member...
> 
> How can i resize it.. to increase the size 5mb.
> 
> Regards,
> Nirmal.
> --
> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis M. Heisler
  INET: [EMAIL PROTECTED]

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

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

RE: Implementing Stored Procedures

2001-05-31 Thread Diana_Duncan



There's an excellent tool by the company Kintana that automates the
deployment of software (which can include stored packages and procedures,
as well as shell scripts, SQL*Loader, whatever).  The developer creates a
"release" with the file names and version numbers in PVCS or ClearCase, and
the tool extracts and runs the approprate files on other servers as
determined by "workflows" -- so you can use this tool to go from dev to QA
to production, etc.  Very nice tool, I'd highly recommend it.  And no, I am
not affiliated, just a happy user.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   

"Bala, Prakash"

   
gular.com>   cc:   

Sent by: Fax to:   

[EMAIL PROTECTED] Subject: RE: Implementing Stored 
Procedures   
   

   

05/31/2001 02:46   

PM 

Please respond to  

ORACLE-L   

   

   





Lisa,

This is what we did in my last project:

1. Developers had access to the application schema where they created and
modified procedures/functions/triggers as needed
2. After their unit testing is done, the QA team would test it using the
front-end application.
3. Once QA team approves the new/enhanced functionality, the developers
would check in the code using PVCS and notify the DBA vith the PVCS version
number and the object name.
4. The DBA tracks the object version numbers along with the application
releases and implements the necessary changes in the production box.
Developers did not have any rights on the production box.

HTH!

Prakash

-Original Message-
Sent: Thursday, May 31, 2001 1:02 PM
To: Multiple recipients of list ORACLE-L



Hi -

I'd like some advice on implementing stored procedures containing
application logic (ie. written by developers).  We have several
applications
where the developers use stored procedures for much of their coding.  We
let
the developers create or replace their procedures in a development
environment under their own schema (with access to all application tables,
etc.) to test the logic, but it currently requires a DBA to implement the
proc under the application schema.   It has gotten to be a very
time-consuming job.  We don't want to give out the schema owner password to
the developers, nor do we know of a way they could add them as the schema
owner without giving them more privileges than we want.

I am curious of how others are handling stored procedure additions and
modifications.Do you somehow allow developers this access?  If so, how
do you restrict them from damaging other things?  If not, does the DBA do
it?   Does anyone have an automated way?   Also, do you keep track of the
original "source code" for the procedure, or do you extract it out of the
database as needed?

Thanks so much for your input -
Lisa

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

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

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

RE: Cartesian

2001-05-31 Thread Kevin Lange


When you say "Cartesian Join" you are basically speaking, like you said, of
a "Cartesian Product of two Matrixes".   Each row joined to each row of each
Matrix.Cartesian Joins in Relational DBs are basically 2 or more tables
in query without a join condition so that each row in the first table is
joined to every row in the other table.

So basically "Cartesian Join" = "Cartesian Product"

-Original Message-
Sent: Thursday, May 31, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


I guess this has already been answered, but to clarify:

I believe "Cartesian" refers to a *product* ("Cartesian product"), not a
join.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


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

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

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

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

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

Re: How to encrypt Password in Export script file ?

2001-05-31 Thread Stephane Faroult


"CHAN Chor Ling Catherine (CSC)" wrote:
> 
> Hi Unix Gurus,
> 
> My daily export file (daily_exp.sh) contains :
> exp userid='system/password' file=file_name.dmp grants=y rows=y
> constraints=y compress=y full=y inctype=complete log=file_name.log
> 
> The system password is stated clearly in the export script file. Has anyone
> encrypt/decrypt the system password before passing it as a variable to the
> export script ? If yes, could I have a copy of your script ? Thanks.
> 
> Regds,
> New Bee in Unix
>

Create an externally identified Oracle account with the suitable
privileges, and run your script from this account using 
userid=/

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

RE: Auto Extend

Title: RE: Auto Extend





Thanks Kimberly for correcting me.  I had a feeling there was a real reason it was frowned upon in the solaris environment I used to work on (instead of 'just don't do it, I said so') but everything was so overwhemling at that time I just let it go.

LK



-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Auto Extend


We had an issue here where we had the Sun box to except files over 2G but got bitten in the ass quickly by it.  We use HP OmniBack to backup all our Unix boxes and the agent on the Sun box could not handle the file size.  So there is more then just "Can the OS handle it" to keep into account.  Thankfully nothing had written to the extra portion and we were able to shrink it again.

-Original Message-
From: Lisa Koivu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 10:08 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Auto Extend




Hi Ron, 


do you have large files enabled on your system? What unix are you running?  if large files are not enabled you're going to get an error but I can't tell you what it will be. 

Boy, autoextend reminds me of a monkey running around in your database.  I'd never do that, but it's just my personal preference.

Lisa Koivu
Oracle Database Administrator
954-935-4117 


The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.

The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. 



-Original Message-
From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject:    Auto Extend 


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix? 


. 


--
Please see the official ORACLE-L FAQ: 
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED] 


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

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

Re: deadlock error in oracle8.1.7 on sun solaris