date:20020117


 Hi
i am trying to recover the database from the loss of  SYSTEM datafile.
After mounting the database ,I tried recovery using RMAN
RMAN> run
2> {
3> allocate channel c1 type disk ;
4> restore tablespace "system";
5> recover tablespace "system";
6> sql 'alter database open';
7> release channel c1;
8> }

I have a Incremental level 0 backup and also a incremental level 1 database
backup.
i got the following error while recpovering
MAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=11 devtype=DISK

RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202:
tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "system"

Any ideas why this error occurs
The intersting thing is that if i use "recover datafile" ,the recovery goes
thru.

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

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

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

smtp via PL/SQL

2002-01-17 Thread Steve McClure


I am digging into the docs I can find on utl_smtp and utl_tcp, but I am
really not finding much.  I have Oracle's package reference docs, but that
doesn't shed all that much light on the subject.  I am pretty well a newbie
to tcp and smtp.

Geeze all that talking and no question yet.  Can anyone recommend a book or
white paper on implementing 'email' from within an Oracle database?  I have
downloaded some sample code from Orafaq, and actually gotten it working on
our db.  I would just like to actually understand what I am doing, and
expand on what we have.

Steve McClure

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

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

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

RE: used segment space in bytes

2002-01-17 Thread Deepak Thapliyal


Hi Do,

Here is the breakup for a space usage for a segment:

1. Allocated size (use dba_segments)

2 Used Blocks in segments(use dba_tables.blocks)
 --> Truly Used ( ??)
 --> Free Blocks (??)

3. Unused Blocks (use dba_tables.empty_blocks)

the caveat i guess is in step 2. The used block number
is based on the high watermark. which means that the
number you will get for point 2. above will also
include "space that contains no rows" becuz its below
the high water mark.

Afaik, there is'nt a way to find these "free blocks"
below the high water mark.. unless you re-build table
and then get the value from dba_tables.blocks .. 

feel free to correct me .. 

Deepak

> -Original Message-
> Sent: Thursday, January 17, 2002 12:12 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> hi guys!
>  
> what would be the easiest way to compute the space
> in bytes used by a segment?
> it is rather easy to determine the # of used blocks
> by a specific segment by looking at the dba_extents
> for example. but how many blocks have been really
> used
> in one of those extents. i guess i would be able
> to compute the free blocks by using the dbms_space
> package but it just seems to complicated.
> any hints ... ?
>  
> thank you
>  
> -do
>  
> 
> 


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: multiple extents are OK, dagnabbit!

2002-01-17 Thread Jack C. Applewhite

Title: Message



Jerry,
 
If 
they want to pay you to reduce their extents, then let 'em!    
;-)    "A fool and his money are soon 
parted."
 
If 
they employ you and want you to work weekends on this, then it's worth the 
effort to educate them.  I'm surprised an official Oracle white paper 
didn't convince them.  You may just be out of luck - adamant, entrenched 
misinformation is sometimes difficult to dislodge.
 
If my 
anecdotal situation could be of any help, here it is.
 
We 
just moved our production 8.1.6.0.0 database to 8.1.7.2.5 on a new, but almost 
identical server.
Old 
server's OS was Windows 2000 Server with Service Pack 2 - new server, the 
same.
Old 
server had dual 550MHz Xeon CPUs - new server, the same.
Old 
server had 2GB RAM - new server has 4GB RAM (of which Oracle can only use 2GB 
anyway).
Old 
server had eighteen 36GB drives - new server has twenty 36GB drives.  In 
both cases configured as JBOD (Just a Bunch Of Drives - no RAID, no mirroring, 
no striping of any kind).
 
Our 6 
documents tables each had (and has) its own drive 
and each had (and has) about 2 million rows.  The out-of-line 
CLOB documents take up about 20-30GB for each table.  Each of those 
segments had between 20,000 and 30,000 1MB extents.  For the year we 
operated that way, we never had a problem with performance, even with a full 
interMedia Text index on the CLOB column.
 
When 
we moved the DB to 8.1.7.2.5, I pre-created those tables with 100MB 
extents for the CLOB segments before I imported the documents.  So, now 
we're down to a few hundred extents per segment, instead of tens of 
thousands.  It hasn't made any noticeable difference on performance.  
If numbers of extents really mattered, a 100 to 1 reduction would have made an 
impact - it didn't.
 
What did make a difference was spreading the main 
token table (DR$...$I) of the interMedia Text index across 3 drives, instead of 
one.  Distributing I/O has significant impact.  Number of extents per 
segment has close to zero impact.  The Oracle white paper is dead-on 
accurate.
 
Hope 
my experience helps convince your boneheaded clients.   
;-)
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Cunningham, 
  GeraldSent: Thursday, January 17, 2002 3:46 PMTo: 
  Multiple recipients of list ORACLE-LSubject: multiple extents are 
  OK, dagnabbit!
  Hi there - 
  
   
  I'm trying to 
  convince a client that multiple extents for a table will not hurt their 
  performance. It's a PeopleSoft app, and PeopleSoft is telling them that they 
  need to reorg any object with greater than 10 extents (even indexes). This 
  Oracle 8.1.6.
   
  I've referenced 
  the "How to Stop Defragmenting and Start Living: The Definitive Word on 
  Fragmentation" white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. 
  That didn't convince them. I tried to explain that Oracle reads BUFFERS and 
  not extents, etc., but that didn't work.
   
  I'm about to open 
  a vein.
   
  Does anybody have 
  any references that they can point me to? (Something from PeopleSoft would be 
  ideal, though I would be suprised if it existed.) I read a rant on somebody's 
  web site a while back that was really good, but alas I cannot remember his 
  name or URL. (I blame my kids for my failing memory).
   
   
  Thanks!
   
  - 
  Jerry

Re: multiple extents are OK, dagnabbit!

2002-01-17 Thread Jeremiah Wilton


Here's my swing at it:

http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html

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

On Thu, 17 Jan 2002, Cunningham, Gerald wrote:

> I'm trying to convince a client that multiple extents for a table will not
> hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling
> them that they need to reorg any object with greater than 10 extents (even
> indexes). This Oracle 8.1.6.
>  
> I've referenced the "How to Stop Defragmenting and Start Living: The
> Definitive Word on Fragmentation" white paper by Bhaskar Himatsingka and
> Juan Loaiza of Oracle. That didn't convince them. I tried to explain that
> Oracle reads BUFFERS and not extents, etc., but that didn't work.
>  
> I'm about to open a vein.
>  
> Does anybody have any references that they can point me to? (Something from
> PeopleSoft would be ideal, though I would be suprised if it existed.) I read
> a rant on somebody's web site a while back that was really good, but alas I
> cannot remember his name or URL. (I blame my kids for my failing memory).

-- 
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: Import taking up too much room with local managed tablespace

2002-01-17 Thread Peter . McLarty

go to the following link and have a read of this, Your extent size is most likely way to big for the data you have

http://otn.oracle.com/deploy/availability/pdf/defrag.pdf

if it is for general testing and not much data you could use 128k extents for everything but if it is for a production system then you will need to do your homework

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

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

"Conrad, Ben" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
18/01/2002 04:05 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Fax to:
Subject: Import taking up too much room with local managed tablespace

Hi,
I created a tablespaces in a test database to be locally managed with an extent size of 20544K. A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the local it has run out of space with the (2) 6GB files that I allocated to it. I noticed that during the import the datafiles were filling up quite fast (too fast). Data file 1 was filling up about 4x as fast as data file 2 during the import.
Why did this happen? FYI, I have the compress=y set on the export if that makes any difference.
Thanks,
Ben.

Benjamin Conrad
Sr. Network Administrator
USPowerSolutions
mailto:[EMAIL PROTECTED]
617.547.3800 x195

This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.

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

RE: multiple extents are OK, dagnabbit!

2002-01-17 Thread Post, Ethan

Title: Message



Search Tom Kytes 
asktom.oracle.com and there is also paper at hotsos.com.  Also check 
out http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html. 
 
- 
Ethan
 
 -Original Message-From: 
Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Thursday, 
January 17, 2002 3:46 PMTo: Multiple recipients of list 
ORACLE-LSubject: multiple extents are OK, 
dagnabbit!
Hi there - 

 
I'm trying to 
convince a client that multiple extents for a table will not hurt their 
performance. It's a PeopleSoft app, and PeopleSoft is telling them that they 
need to reorg any object with greater than 10 extents (even indexes). This 
Oracle 8.1.6.
 
I've referenced the 
"How to Stop Defragmenting and Start Living: The Definitive Word on 
Fragmentation" white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. 
That didn't convince them. I tried to explain that Oracle reads BUFFERS and not 
extents, etc., but that didn't work.
 
I'm about to open a 
vein.
 
Does anybody have 
any references that they can point me to? (Something from PeopleSoft would be 
ideal, though I would be suprised if it existed.) I read a rant on somebody's 
web site a while back that was really good, but alas I cannot remember his name 
or URL. (I blame my kids for my failing memory).
 
 
Thanks!
 
- 
Jerry

RE: multiple extents are OK, dagnabbit!

Title: Message



hit 
metalink...there are things there
 
 

  -Original Message-From: Cunningham, Gerald 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 
  4:46 PMTo: Multiple recipients of list ORACLE-LSubject: 
  multiple extents are OK, dagnabbit!
  Hi there - 
  
   
  I'm trying to 
  convince a client that multiple extents for a table will not hurt their 
  performance. It's a PeopleSoft app, and PeopleSoft is telling them that they 
  need to reorg any object with greater than 10 extents (even indexes). This 
  Oracle 8.1.6.
   
  I've referenced 
  the "How to Stop Defragmenting and Start Living: The Definitive Word on 
  Fragmentation" white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. 
  That didn't convince them. I tried to explain that Oracle reads BUFFERS and 
  not extents, etc., but that didn't work.
   
  I'm about to open 
  a vein.
   
  Does anybody have 
  any references that they can point me to? (Something from PeopleSoft would be 
  ideal, though I would be suprised if it existed.) I read a rant on somebody's 
  web site a while back that was really good, but alas I cannot remember his 
  name or URL. (I blame my kids for my failing memory).
   
   
  Thanks!
   
  - 
  Jerry

RE: SPACE FREE HOW?

2002-01-17 Thread Post, Ethan


Deleting records from a table does not free up space in the database.
Search for high water mark in the concepts manual and you should find an
explanation of how this works.  The statement below only frees up space
above the high water mark on the table.

You can...

create table foo nologging as (select * from big_table);

truncate table big_table;

insert into big_table (select * from foo);

drop table foo;


-Ethan

-Original Message-
Sent: Thursday, January 17, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L


ALTER TABLE table DEALLOCATE UNUSED KEEP integer;
the keep clause is optional.

-sunil

-Original Message-
Sent: Thursday, January 17, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L


Hi
I deleted millions of rows from diffrent tables and I have not seen any 
impact on database size.What I have to do to get that free space?
Is it necessary to shutdown the database?
Thx
-Seema

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


intended

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

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

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

multiple extents are OK, dagnabbit!

2002-01-17 Thread Cunningham, Gerald

Title: Message



Hi there - 

 
I'm trying to 
convince a client that multiple extents for a table will not hurt their 
performance. It's a PeopleSoft app, and PeopleSoft is telling them that they 
need to reorg any object with greater than 10 extents (even indexes). This 
Oracle 8.1.6.
 
I've referenced the 
"How to Stop Defragmenting and Start Living: The Definitive Word on 
Fragmentation" white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. 
That didn't convince them. I tried to explain that Oracle reads BUFFERS and not 
extents, etc., but that didn't work.
 
I'm about to open a 
vein.
 
Does anybody have 
any references that they can point me to? (Something from PeopleSoft would be 
ideal, though I would be suprised if it existed.) I read a rant on somebody's 
web site a while back that was really good, but alas I cannot remember his name 
or URL. (I blame my kids for my failing memory).
 
 
Thanks!
 
- 
Jerry

Re: SPACE FREE HOW?


Seema,
 The table has set it'd HWM where the old data resided. The easiest?
method of recovering the space is to export the table and then truncate
the table followed by importing the table data back into the table. The
truncate function will remove all of the data and re-establish the size
back to original.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/17/02 03:57PM >>>
Hi
I deleted millions of rows from diffrent tables and I have not seen any

impact on database size.What I have to do to get that free space?
Is it necessary to shutdown the database?
Thx
-Seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Seema Singh
  INET: oracledbam@hotmReceived: from CONNECT-MTA by galotterail.com 

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

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

2002-01-17 Thread Gogala, Mladen


Unfortunately, your space will remain the same because delete
doesn't deallocate the free space allocated to the table whether
you shut the database down or not. The ways to deallocate space
would be to 
a) Rebuild the table in another tablespace with significantly reduced
   storage parameters (8i and newer)
b) Truncate the table, which is almost equivalent to dropping and recreating
   the table. The good news is that you don't have to re-issue grants or
   re-create indexes.


-Original Message-
Sent: Thursday, January 17, 2002 3:58 PM
To: Multiple recipients of list ORACLE-L


Hi
I deleted millions of rows from diffrent tables and I have not seen any 
impact on database size.What I have to do to get that free space?
Is it necessary to shutdown the database?
Thx
-Seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

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

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

Re: SPACE FREE HOW?

2002-01-17 Thread Raghu Kota


If you deleted rows, you can't see space unless untill you reoraganize that 
objects..If you truncate you can see free space immediately!!


>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: SPACE FREE HOW?
>Date: Thu, 17 Jan 2002 12:57:56 -0800
>
>Hi
>I deleted millions of rows from diffrent tables and I have not seen any
>impact on database size.What I have to do to get that free space?
>Is it necessary to shutdown the database?
>Thx
>-Seema
>
>
>_
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>
>--
>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).




Raghu Kota
OCP DBA.


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

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

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

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

RE: SPACE FREE HOW?

2002-01-17 Thread Sunil_Nookala


ALTER TABLE table DEALLOCATE UNUSED KEEP integer;
the keep clause is optional.

-sunil

-Original Message-
Sent: Thursday, January 17, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L


Hi
I deleted millions of rows from diffrent tables and I have not seen any 
impact on database size.What I have to do to get that free space?
Is it necessary to shutdown the database?
Thx
-Seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

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

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

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

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

Re: Using RMAN


Ruth,
I have a couple of questions

1. As I understand from your email ,you do incremental level 0 backups in
the morning and level 1 backups in the evening and night everyday using
RMAN...right.
You mentioned that you also take the backups  (i.e level 0 and 2 level 1's
for a day )on tape every morning. Do you use RMAN to take the tape backups?
If not then RMAN doesn't remember the tape backup .
If you had a failure in the evening then you would just restore the level 0
and then apply the subsequent level 1 backup and the archived logs
,...right?

My question is how big is your production database? How much time does it
take to do
1. level 0 backup
2 level 1 backups

Also how resource intensive are the incremenatal level 0 and level 1 backups
like in terms of CPU,I/O etc since you do it in the middle of the day.

Could you please tell me more about the tape backups that you do?Like what
media magmt sortware are you using .We will be using Veritas Netbackup here.

Thanks
 Sona

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 11:55 AM


> We use rman to backup all of our databases.  But most importantly, we use
it
> for production.  Production databases are in archivelog mode.  We do a
level
> 1 backup at the end of the work day and prior to nitely batch processing.
> We do a level 0 backup early in the morning after batch and before users
get
> on.
>
> We but a full days worth of backups, including the archivelog backups, on
a
> tape in the morning.  There is one tape for each day of the week, Mon-Fri.
> We delete archivlogs from the archive log destination after backing them
up.
>
> Production is backed up while it is open.  Test and developement databases
> are not in archivelog mode so we have to back them up while they are not
> available to users.
>
> HTH,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 17, 2002 12:45 PM
>
>
> > See currently we are using Unix scripts to do our hot backups .We take
the
> > backup on disk and everynight after the disk backup we copy the backup
on
> > tape using Veritas Net Backup.
> > Presently we keep 2 days worth of backups on the disk and 3 days of
> archive
> > logs.That means at any point in time i have the last 2 days backup on
disk
> > (just for fatster recovery so that we can aviod going to tapes in case
of
> a
> > failure).
> > Now if we start using RMAN ,we would be taking hot backups (mostly using
> > increamental strategy) using RMAN.So for e.g. we start on say sunday
> taking
> > an incremental level 0 backup  on disk.RMAN only remmbers the disk
backup
> > ...right Note that we will also be copying the backups on tape but
> that
> > will be independent of RMAN since it is not done using RMAN.
> > Say the next 3 days of the week ,we do increamental level 1 backups .On
> the
> > 3 rd day  (i.e. Wednesday) i would have only Monday's and Tuesdays'
backup
> > on disk (which are the inceemental llevel 1 backups since the whole
ideas
> is
> > to keep last 2 days backup om disk).
> > So if we have a failure on Wednesday then RMAN would look for the
> > incremental level 0 backup of Sunday on the disk but that backup is not
> > present on the disk now.
> > I hope i have cleared it up enough.
> > Now my question is can we maintain the same policy of keeping 2 days
> backup
> > on disk by using RMAN.
> > What kind of backup strategies do RMAN users follow? Are RMAN backups
> > usually taken on tape directly ? Is it faster to take backups on tape
> rather
> > on disk while using RMAN?
> >
> > Could RMAN users share their backup/recovery  strategies ,please.
> >
> >
> > TIA
> >
> >
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, January 17, 2002 5:55 AM
> >
> >
> > > If you are using a recovery catalog then rman keeps track of
everything
> > > there.  He knows if you've been naughty, he know if you've been nice,
he
> > > knowsOOOPS I got carried away.  But  when you do a restore using
> rman
> > he
> > > will tell you what backup sets you will need.
> > >
> > > Ruth
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, January 16, 2002 6:20 PM
> > >
> > >
> > > Hi
> > > Currently we are using Unix scripts to do backups.We keep last 2 days
of
> > > backups on the disk and also take the backups on tape daily.
> > > We are planning to use RMAN for backups and would like to maintain the
> the
> > > same policy of 2 days backup on disk and daily tape backups.
> > > Is it possible to implement this using RMAN? Which backup will RMAN
> > remember
> > > (while restore) the disk backup or the tape backup?
> > > If we try to use the incremental strategy ,then how would RMAN
remember
> > the
> > > last incremental level 0 backup ? It will not be present on disk since

SPACE FREE HOW?

2002-01-17 Thread Seema Singh


Hi
I deleted millions of rows from diffrent tables and I have not seen any 
impact on database size.What I have to do to get that free space?
Is it necessary to shutdown the database?
Thx
-Seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

Anybody in DOUG?

2002-01-17 Thread Post, Ethan


Anybody on this list in the Dallas Oracle Users Group?  Just wondering if it
is worth attending from your perspective.  I am over at Park Central and I
noticed the meetings are way over in Las Colinas area.  In San Diego they
were only a few doors down, hey but the houses are bigger...

Thanks,
Ethan
-- 
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: Checkpoint & Redo ratio(High)

2002-01-17 Thread Peter Gram

Seema

First remember the old rule : If it's not broken don't fix it.

There is a rule of thumb that redo log switches should happened app. 
every 30 minutes, but if you se redo log switches
happening more often at some times and nobody is complaining then just 
ignore the it. If you have a performance problem
and you se redo log switches then create bigger redo logs so that 
switches happen app. every 30 minute.

Seema Singh wrote:

> Hi
> I checked my database and see redo ratio is high.
> I ran the folling query
> select (req.value * 5000) / entries.value "Redo Ratio"
>   from v$sysstat req, v$sysstat entries
>   where req.name = 'redo log space requests'
>   and entries.name = 'redo entries';
> But the
> background checkpoints completed  and background checkpoints started 
> are having diffrence 1.
> When I do large insert and delete I receive message in alert log
> "Checkpoint not completed." but not regulary.
> My redo log file size is 20m.
> oracle is running on 8.1.6 on unix.
> LEt me know group suggestion.
> Thanks
> -Seema
>
>
>
> _
> Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp.
>

-- 
Best regards

Peter Gram

Miracle A/S
http://MiracleAS.dk
Tel: +45 2527 7107

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

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

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

RE: Partitions


intended

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

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

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

2002-01-17 Thread Ruth Gramolini


We use rman to backup all of our databases.  But most importantly, we use it
for production.  Production databases are in archivelog mode.  We do a level
1 backup at the end of the work day and prior to nitely batch processing.
We do a level 0 backup early in the morning after batch and before users get
on.

We but a full days worth of backups, including the archivelog backups, on a
tape in the morning.  There is one tape for each day of the week, Mon-Fri.
We delete archivlogs from the archive log destination after backing them up.

Production is backed up while it is open.  Test and developement databases
are not in archivelog mode so we have to back them up while they are not
available to users.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 12:45 PM


> See currently we are using Unix scripts to do our hot backups .We take the
> backup on disk and everynight after the disk backup we copy the backup on
> tape using Veritas Net Backup.
> Presently we keep 2 days worth of backups on the disk and 3 days of
archive
> logs.That means at any point in time i have the last 2 days backup on disk
> (just for fatster recovery so that we can aviod going to tapes in case of
a
> failure).
> Now if we start using RMAN ,we would be taking hot backups (mostly using
> increamental strategy) using RMAN.So for e.g. we start on say sunday
taking
> an incremental level 0 backup  on disk.RMAN only remmbers the disk backup
> ...right Note that we will also be copying the backups on tape but
that
> will be independent of RMAN since it is not done using RMAN.
> Say the next 3 days of the week ,we do increamental level 1 backups .On
the
> 3 rd day  (i.e. Wednesday) i would have only Monday's and Tuesdays' backup
> on disk (which are the inceemental llevel 1 backups since the whole ideas
is
> to keep last 2 days backup om disk).
> So if we have a failure on Wednesday then RMAN would look for the
> incremental level 0 backup of Sunday on the disk but that backup is not
> present on the disk now.
> I hope i have cleared it up enough.
> Now my question is can we maintain the same policy of keeping 2 days
backup
> on disk by using RMAN.
> What kind of backup strategies do RMAN users follow? Are RMAN backups
> usually taken on tape directly ? Is it faster to take backups on tape
rather
> on disk while using RMAN?
>
> Could RMAN users share their backup/recovery  strategies ,please.
>
>
> TIA
>
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 17, 2002 5:55 AM
>
>
> > If you are using a recovery catalog then rman keeps track of everything
> > there.  He knows if you've been naughty, he know if you've been nice, he
> > knowsOOOPS I got carried away.  But  when you do a restore using
rman
> he
> > will tell you what backup sets you will need.
> >
> > Ruth
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 16, 2002 6:20 PM
> >
> >
> > Hi
> > Currently we are using Unix scripts to do backups.We keep last 2 days of
> > backups on the disk and also take the backups on tape daily.
> > We are planning to use RMAN for backups and would like to maintain the
the
> > same policy of 2 days backup on disk and daily tape backups.
> > Is it possible to implement this using RMAN? Which backup will RMAN
> remember
> > (while restore) the disk backup or the tape backup?
> > If we try to use the incremental strategy ,then how would RMAN remember
> the
> > last incremental level 0 backup ? It will not be present on disk since
we
> > only keep the last 2 days backup on it.
> > How do i use RMAN to do restore/recovery in this case?
> >
> >
> > I heard that taking backups on tape is faster than on disk when using
> RMAN?
> > Is it true?
> >
> > Could RMAN users share their backup/recovery  strategies ,please.
> >
> > TIA
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sona
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> -

Re: UNION

2002-01-17 Thread Regina Harter


Use
ORDER BY 1  (ie, the first column)

At 10:31 AM 1/17/02 -0800, you wrote:
>Hi,
>
>I try to use union and order by first column of first select statment and
>also first column of second select statment but get error, Any Idea how to
>do this??
>
>SELECT A,B,C FROM TABLEABC
>UNION
>SELECT D,E,F FROM TABLEDEF
>ORDER BY A,D
>
>
>
>
>Hamid Alavi
>Office 818 737-0526
>Cell818 402-1987
>
>The information contained in this message and any attachments is intended
>only for the use of the individual or entity to which it is addressed, and
>may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
>disclosure under applicable law. If you have received this message in error,
>you are prohibited from copying, distributing, or using the information.
>Please contact the sender immediately by return e-mail and delete the
>original message from your system.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

Re: UNION

2002-01-17 Thread Igor Neyman


SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 1:31 PM


> Hi,
>
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
>
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
>
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Using RMAN

2002-01-17 Thread Jay Hostetter


I have gone through this process.  We used to backup to disk using scripts as 
described in Velpuri's book.  We now use RMAN to backup to disk.  Your backups will be 
faster and smaller in size, because RMAN will skip unused blocks and it also allows 
you to specify mutilple channels.  I can backup a 70 Gb database in about 60 to 90 
minutes.  Here is a sample script:

run 
{
allocate channel ch1 type disk format '/bkup9/oracle/%d/full_s%s_p%p_%t';
allocate channel ch2 type disk format '/bkup3/oracle/%d/full_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1 Gb.
set limit channel ch2 kbytes=100;
backup full database 
 tag='daily_full_backup';
allocate channel ch3 type disk format '/bkup3/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch3 kbytes=100;
backup (archivelog until time 'sysdate-1/24' delete input
channel ch3
   );
}

I do archivelog backups with a separate command, because RMAN can be a bit touchy when 
it comes to archivelogs.  If none exist for the time specified, then the backup will 
fail.  This way my database backup will be successful if there is a problem with the 
archivelog backup.

I would skip the incremental stuff.  Just do full backups unless you are talking huge 
databases.

To tell RMAN what backup files are available on disk, prior to a restore, run this 
command:

# Check which backups are available on disk.
allocate channel for maintenance type disk;
crosscheck backup;
release channel;

or this one if you are in noarchivelog mode:

# Check which backups are available on disk.
allocate channel for maintenance type disk;
crosscheck backup of database;
crosscheck backup of controlfile;
release channel;

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

>>> [EMAIL PROTECTED] 01/17/02 12:45PM >>>
See currently we are using Unix scripts to do our hot backups .We take the
backup on disk and everynight after the disk backup we copy the backup on
tape using Veritas Net Backup.
Presently we keep 2 days worth of backups on the disk and 3 days of archive
logs.That means at any point in time i have the last 2 days backup on disk
(just for fatster recovery so that we can aviod going to tapes in case of a
failure).
Now if we start using RMAN ,we would be taking hot backups (mostly using
increamental strategy) using RMAN.So for e.g. we start on say sunday  taking
an incremental level 0 backup  on disk.RMAN only remmbers the disk backup
...right Note that we will also be copying the backups on tape but that
will be independent of RMAN since it is not done using RMAN.
Say the next 3 days of the week ,we do increamental level 1 backups .On the
3 rd day  (i.e. Wednesday) i would have only Monday's and Tuesdays' backup
on disk (which are the inceemental llevel 1 backups since the whole ideas is
to keep last 2 days backup om disk).
So if we have a failure on Wednesday then RMAN would look for the
incremental level 0 backup of Sunday on the disk but that backup is not
present on the disk now.
I hope i have cleared it up enough.
Now my question is can we maintain the same policy of keeping 2 days backup
on disk by using RMAN.
What kind of backup strategies do RMAN users follow? Are RMAN backups
usually taken on tape directly ? Is it faster to take backups on tape rather
on disk while using RMAN?

Could RMAN users share their backup/recovery  strategies ,please.


TIA




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 5:55 AM


> If you are using a recovery catalog then rman keeps track of everything
> there.  He knows if you've been naughty, he know if you've been nice, he
> knowsOOOPS I got carried away.  But  when you do a restore using rman
he
> will tell you what backup sets you will need.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 16, 2002 6:20 PM
>
>
> Hi
> Currently we are using Unix scripts to do backups.We keep last 2 days of
> backups on the disk and also take the backups on tape daily.
> We are planning to use RMAN for backups and would like to maintain the the
> same policy of 2 days backup on disk and daily tape backups.
> Is it possible to implement this using RMAN? Which backup will RMAN
remember
> (while restore) the disk backup or the tape backup?
> If we try to use the incremental strategy ,then how would RMAN remember
the
> last incremental level 0 backup ? It will not be present on disk since we
> only keep the last 2 days backup on it.
> How do i use RMAN to do restore/recovery in this case?
>
>
> I heard that taking backups on tape is faster than on disk when using
RMAN?
> Is it true?
>
> Could RMAN users share their backup/recovery  strategies ,please.
>
> TIA
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858)

RE: UNION


Did a little testing.
I think that the columns names are decided by the first select only.
The union adds the rows from the second select to the result set 
created by the first select.
That's mean that your columns are a , b , c.
So order by 'a' will work. It did in my test.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, January 17, 2002 8:31 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  UNION
> 
> Hi,
> 
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
> 
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
> 
> 
> 
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
> error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

Re: UNION

2002-01-17 Thread Marin Dimitrov



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 20:31


> 
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D

SELECT A as ord_col,B,C FROM TABLEABC
UNION
SELECT D as ord_col,E,F FROM TABLEDEF
ORDER BY ord_col?


hth,

Marin


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


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

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

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

Checkpoint & Redo ratio(High)

2002-01-17 Thread Seema Singh


Hi
I checked my database and see redo ratio is high.
I ran the folling query
select (req.value * 5000) / entries.value "Redo Ratio"
   from v$sysstat req, v$sysstat entries
   where req.name = 'redo log space requests'
   and entries.name = 'redo entries';
But the
background checkpoints completed  and background checkpoints started are 
having diffrence 1.
When I do large insert and delete I receive message in alert log
"Checkpoint not completed." but not regulary.
My redo log file size is 20m.
oracle is running on 8.1.6 on unix.
LEt me know group suggestion.
Thanks
-Seema



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

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

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

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

Re: UNION

2002-01-17 Thread Scott Canaan


Try:
select a,b,c from tableabc
union
select d,e,f from tabledef
order by 1;

Hamid Alavi wrote:

> Hi,
>
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
>
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" -
Tom Lehrer


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

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

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

RE: UNION

2002-01-17 Thread Jamadagni, Rajendra


You have to use ORDER BY column position as in

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1

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!



*2

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

*2

Re: UNION

2002-01-17 Thread Stephane Faroult

Hamid Alavi wrote:
> 
> Hi,
> 
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
> 
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 

Hamid,

  Remember that the purpose of a union is to bring back rows from
several tables as if they were coming from a single table - a bit like a
join returns columns from several tables as if they were coming from a
single table. By convention, the column names which are assigned come
from the first table in the union. In your example, columns will be
named (A,B,C) even if actually the first part of the UNION returns no
row. Syntactically, to order the output of a union you must specified
column by position number in the select list, not by name - on your
example, it will be 'order by 1' ('1' refering to A or D indistinctly).

If you always want rows from TABLEABC to be returned before rows from
TABLEDEF, you must cheat and add a dummy column :

SELECT 1 dummy, A, B, C FROM TABLEABC
UNION
SELECT 2, D, E, F FROM TABLEDEF
ORDER BY 1, 2

(you can make the dummy column disappear from the output with SQL*Plus
by defining 
   col dummy noprint
In a program, just ignore it).
Note that there is a drawback to the dummy column use: with a standard
UNION (as opposed to UNION ALL) if a row in the first table is strictly
identical to a row in another table from the UNION, it appears only once
(duplicates are eliminated). With a dummy column, only duplicates from
the same table can be removed.

HTH

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

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

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

RE: UNION

2002-01-17 Thread Mercadante, Thomas F


Hamid,

Look in the Sql manual.

For UNION clauses, you must ORDER BY the item number:

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1   <=  lookee here

hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, January 17, 2002 1:31 PM
To: Multiple recipients of list ORACLE-L


Hi,

I try to use union and order by first column of first select statment and
also first column of second select statment but get error, Any Idea how to
do this??

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY A,D




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

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

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

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

RE: UNION

2002-01-17 Thread Mac Isaac, John


select * from (
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF) x
ORDER BY A,D


> -Original Message-
> From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 17, 2002 12:31 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  UNION
> 
> Hi,
> 
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
> 
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
> 
> 
> 
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
> error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mac Isaac, John
  INET: [EMAIL PROTECTED]

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

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

RE: UNION

2002-01-17 Thread Kevin Lange


In the order by section use the relative column numbers.  Plus, you can not
individually order by a single column from each union.  Its a comprehensive
sort of the entire column.

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1

-Original Message-
Sent: Thursday, January 17, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L


Hi,

I try to use union and order by first column of first select statment and
also first column of second select statment but get error, Any Idea how to
do this??

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY A,D



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

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

2002-01-17 Thread Gene Sais


I also heard of horror stories regarding Sun Clusters.  I worked w/ HP MC Service 
guard, good product.  Now working w/ IBM HACMP, also good product, although more 
complicated to set up (but then again I am not a IBM'er).  IBM tends to do everything 
their way ;).  

In the future when I upgrade to 9i, I will use Oracle's Data Guard or maybe look at a 
3rd party product such as shareplex (good reviews, but pricey).

Gene

>>> [EMAIL PROTECTED] 01/17/02 01:05PM >>>
Thanks for your help everyone. Very useful advice, although your scaring me
of Sun Clusters.

At the minute, Parallel server looks the best, with a standby database
remotely for disaster.

Does anyone know what the HP solution is like (MC Service Guard)? I think
some one on this list gave it a good review in the past .


Thanks,

Jim


-Original Message-
Sent: 17 January 2002 17:12
To: Multiple recipients of list ORACLE-L


IBM HACMP works well.

Ooops. guess that means you'll have to change some things. ;-)

Seriously, we *did* get the Sun "clustering" working, but it
required some serious feet-to-fire holding and gyrations.


-Original Message-
Sent: Thursday, January 17, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Thanks for the advice everyone.

So what do you recommend on a Sun cluster/machines for failover other than
OPS?
Quest Shareplex?
Standby database?
Any others?

Thanks,

Jim



-Original Message-
Sent: 17 January 2002 16:22
To: Multiple recipients of list ORACLE-L


I concur with BB.yea, I ran Sun "cluster" at  and
it broke ALOT.

Kept me and two full time Sun Engineers (they got paid ALOT more)
in consulting dollars, but i made a mental note not to use
it in "my business".

Caveat:  this was 1.5 years ago. Things change.

Mit Gluck, mein freund...


- Ross "mit schuss" Mohan

-Original Message-


Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]] 
> Reply To: [EMAIL PROTECTED] 
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
>
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
>
> Note, this is not a standby database.
>
> From the book it seams to work in the following way...
>
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
>
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
>
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
>
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
>
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
>
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
>
> The disk pack is RAID, and we may also have a standby database off site.
>
> Has anyone any recommendations?
>
>
> Thanks,
>
> Jim
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: James McCann
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE

RE: used segment space in bytes

Title: Dieter Oberkofler Stationery



Hi Dieter:
    As you've said, you can use dbms_space 
for this job.
This package tells you how many blocks has the object and 
where's the HWM. And if you use the dbms_space.free_blocks() procedure, it will 
also report how many blocks below the HWM are in the freelists.
    You can also use this query to 
know how many blocks hold at least one row:
 
(ORACLE 7) SELECT COUNT(DISTINCT 
SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8)) FROM TABLE.
 
    You can easily change it to work in 
Oracle 8 too by using the dbms_rowid package.
 
HTH 
Greetings
Diego Cutrone
 

  - Original Message - 
  From: 
  Oberkofler, Dieter 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, January 17, 2002 2:11 
  PM
  Subject: used segment space in 
bytes
  
  hi guys!
   
  what would be the easiest way to compute 
  the space
  in bytes used by a segment?
  it is rather easy to determine the # of 
  used blocks
  by a specific segment by looking at the 
  dba_extents
  for example. but how many blocks have been 
  really used
  in one of those extents. i guess i would 
  be able
  to compute the free blocks by using the 
  dbms_space
  package but it just seems to 
  complicated.
  any hints ... ?
   
  thank you
   
  -do

UNION

2002-01-17 Thread Hamid Alavi


Hi,

I try to use union and order by first column of first select statment and
also first column of second select statment but get error, Any Idea how to
do this??

SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY A,D




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

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

Re: Oracle 8.1.7 install error

2002-01-17 Thread Günter Huerkamp


And always shutdown Antivirus-Clients.
Günter

Seefelt, Beth wrote:

 >I get a lot of those when installing on NT.  I usually go into explorer,
 >rename the existing file to .old and hit Retry and the install 
continues on.
 >
 >Sometimes that won't work if the file is truly locked by another process.
 >In that case you have to find who has locked the file.  I use the HandleEx
 >tool available from www.sysinternals.com to find out which process has the
 >file locked and stop it before continuing the installation.
 >
 >-Original Message-
 >Sent: Wednesday, January 16, 2002 9:10 AM
 >To: Multiple recipients of list ORACLE-L
 >
 >I keep getting the following error while trying to install Oracle 8.1.7 on
 >my NT server.
 >There is over 1G of freespace on the drive.  If I say ignore, the 
installer
 >continues to run.
 >Any ideas?
 >
 >Error in writing to file c:\winnt\system32\ctl3d32.dll
 >
 >Ron
 >


-- 
---
Dipl.-Inform.  Günter Huerkamp

Web: http://guenter-huerkamp.bei.t-online.de

Email
privat : mailto:[EMAIL PROTECTED]
privat : mailto:[EMAIL PROTECTED]
dienstlich : mailto:[EMAIL PROTECTED]

---




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?G=FCnter?= Huerkamp
  INET: [EMAIL PROTECTED]

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

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

8.0.5 to 8.1.7 migration problem

2002-01-17 Thread Kevin Lange


Evening gang;
  Why would the Oracle Database Migration Assistant (odma) be telling me
that I am migrating a database from 8.1.5 to 8.1.7 when it is actually only
a version 8.0.5 database ??

Thanks
Kevin
-- 
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: used segment space in bytes

2002-01-17 Thread Khedr, Waleed

Title: Dieter Oberkofler Stationery



What about dba_segments?

  -Original Message-From: Oberkofler, Dieter 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 
  2002 12:12 PMTo: Multiple recipients of list 
  ORACLE-LSubject: used segment space in bytes
  hi guys!
   
  what would be the easiest way to compute 
  the space
  in bytes used by a segment?
  it is rather easy to determine the # of 
  used blocks
  by a specific segment by looking at the 
  dba_extents
  for example. but how many blocks have been 
  really used
  in one of those extents. i guess i would 
  be able
  to compute the free blocks by using the 
  dbms_space
  package but it just seems to 
  complicated.
  any hints ... ?
   
  thank you
   
  -do

RE: Partitions

2002-01-17 Thread Martin Kendall


Hamid,

You need to think about how meaningful a range is
if it is just based on Sequence Numbers as opposed to Creation Date.

Martin http://www.oracle-rescue.com/

-Original Message-
Sent: 17 January 2002 16:29
To: Multiple recipients of list ORACLE-L


Thanks Ron,
So it's better I put partitions in deffrent tablespace and also for better
performance in diffrent physical disks, it will helps.
I am going to do the partition on Creation date or on Primary Key(PK is a
sequence number), don't know can we use PK as a range for partitioning or
not?
Thanks again for your help.


-Original Message-
Sent: Thursday, January 17, 2002 6:02 AM
To: Multiple recipients of list ORACLE-L


Hamid,
Partitions are basically for the use of Oracle. It allows you to break
apart a large table into several smaller sections to help in the
management of the table data and to help Oracle find the data you
requested. Under ideal conditions, Oracle will only select the smallest
area to search for the data you have requested. If the table is 1
tablespace and large in size, it can take an enormous amount of
resources to find the data you selected. If the table is partitioned
correctly, Oracle will only search the partition/s that it needs to find
your data.
The application code does not need to be changed. The application will
request data from a table and Oracle will determine which partition to
use.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/16/02 04:06PM >>>
List,
If we use partitioning for a big tables after finish development, do we
have
to change the code for accReceived: from CONNECT-MTA by galotteressing
diffrent partition or this will handle
by
oracle itself.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

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

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

To REMOVE yourself from this ma

RE: Using RMAN

2002-01-17 Thread Mercadante, Thomas F


Sona,

I am using Rman to backup directly (via EDM software) to a tape.  It is
working very nicely.  Recovery has not been an issue (haven't had to recover
yet), but we perform weekly Rman Validate Recovery to be sure that we can
read the tape.

The reason to use tape backup is that I don't need to get into the dance
that you need to do when performing disk backup (deleting aged backup files,
keeping last few days etc).  I know this can easily be done with simple
unix/nt scripting, but Edm is working nicely for us, and I don't feel the
need to change.

As for your plan of keeping only 3 days of backup on disk, I would change it
to 5 days if you are doing a full, followed by two incremental backups.  Why
cut the time so close?  If disk space is an issue, compress the backup file
after the Rman backup has completed (be sure and test Validate Backup from
the Uncompressed file to make sure all is well).  Either that, or buy more
disk - it is cheap now-a-days.

As for what is faster - tape or disk - it all depends on what kind of tape
drive you use.  Intuitively, I would say disk is faster.  But then, tape is
safer - pretty easy to delete a disk file - not as easy to delete a tape
file.  I currently backup a 10 gig database in about 20 minutes on NT, using
StorageTek tape library.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, January 17, 2002 12:46 PM
To: Multiple recipients of list ORACLE-L


See currently we are using Unix scripts to do our hot backups .We take the
backup on disk and everynight after the disk backup we copy the backup on
tape using Veritas Net Backup.
Presently we keep 2 days worth of backups on the disk and 3 days of archive
logs.That means at any point in time i have the last 2 days backup on disk
(just for fatster recovery so that we can aviod going to tapes in case of a
failure).
Now if we start using RMAN ,we would be taking hot backups (mostly using
increamental strategy) using RMAN.So for e.g. we start on say sunday  taking
an incremental level 0 backup  on disk.RMAN only remmbers the disk backup
...right Note that we will also be copying the backups on tape but that
will be independent of RMAN since it is not done using RMAN.
Say the next 3 days of the week ,we do increamental level 1 backups .On the
3 rd day  (i.e. Wednesday) i would have only Monday's and Tuesdays' backup
on disk (which are the inceemental llevel 1 backups since the whole ideas is
to keep last 2 days backup om disk).
So if we have a failure on Wednesday then RMAN would look for the
incremental level 0 backup of Sunday on the disk but that backup is not
present on the disk now.
I hope i have cleared it up enough.
Now my question is can we maintain the same policy of keeping 2 days backup
on disk by using RMAN.
What kind of backup strategies do RMAN users follow? Are RMAN backups
usually taken on tape directly ? Is it faster to take backups on tape rather
on disk while using RMAN?

Could RMAN users share their backup/recovery  strategies ,please.


TIA




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 5:55 AM


> If you are using a recovery catalog then rman keeps track of everything
> there.  He knows if you've been naughty, he know if you've been nice, he
> knowsOOOPS I got carried away.  But  when you do a restore using rman
he
> will tell you what backup sets you will need.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 16, 2002 6:20 PM
>
>
> Hi
> Currently we are using Unix scripts to do backups.We keep last 2 days of
> backups on the disk and also take the backups on tape daily.
> We are planning to use RMAN for backups and would like to maintain the the
> same policy of 2 days backup on disk and daily tape backups.
> Is it possible to implement this using RMAN? Which backup will RMAN
remember
> (while restore) the disk backup or the tape backup?
> If we try to use the incremental strategy ,then how would RMAN remember
the
> last incremental level 0 backup ? It will not be present on disk since we
> only keep the last 2 days backup on it.
> How do i use RMAN to do restore/recovery in this case?
>
>
> I heard that taking backups on tape is faster than on disk when using
RMAN?
> Is it true?
>
> Could RMAN users share their backup/recovery  strategies ,please.
>
> TIA
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line cont

RE: Standby Instance questions and HA

2002-01-17 Thread James McCann


Thanks for your help everyone. Very useful advice, although your scaring me
of Sun Clusters.

At the minute, Parallel server looks the best, with a standby database
remotely for disaster.

Does anyone know what the HP solution is like (MC Service Guard)? I think
some one on this list gave it a good review in the past .


Thanks,

Jim


-Original Message-
Sent: 17 January 2002 17:12
To: Multiple recipients of list ORACLE-L


IBM HACMP works well.

Ooops. guess that means you'll have to change some things. ;-)

Seriously, we *did* get the Sun "clustering" working, but it
required some serious feet-to-fire holding and gyrations.


-Original Message-
Sent: Thursday, January 17, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Thanks for the advice everyone.

So what do you recommend on a Sun cluster/machines for failover other than
OPS?
Quest Shareplex?
Standby database?
Any others?

Thanks,

Jim



-Original Message-
Sent: 17 January 2002 16:22
To: Multiple recipients of list ORACLE-L


I concur with BB.yea, I ran Sun "cluster" at  and
it broke ALOT.

Kept me and two full time Sun Engineers (they got paid ALOT more)
in consulting dollars, but i made a mental note not to use
it in "my business".

Caveat:  this was 1.5 years ago. Things change.

Mit Gluck, mein freund...


- Ross "mit schuss" Mohan

-Original Message-


Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
>
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
>
> Note, this is not a standby database.
>
> From the book it seams to work in the following way...
>
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
>
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
>
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
>
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
>
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
>
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
>
> The disk pack is RAID, and we may also have a standby database off site.
>
> Has anyone any recommendations?
>
>
> Thanks,
>
> Jim
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: James McCann
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

To R

Import taking up too much room with local managed tablespace

2002-01-17 Thread Conrad, Ben

Title: Import taking up too much room with local managed tablespace





Hi,


I created a tablespaces in a test database to be locally managed with an extent size of 20544K.  A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the local it has run out of space with the (2) 6GB files that I allocated to it.  I noticed that during the import the datafiles were filling up quite fast (too fast).  Data file 1 was filling up about 4x as fast as data file 2 during the import.

Why did this happen?  FYI, I have the compress=y set on the export if that makes any difference.


Thanks,


Ben.




Benjamin Conrad
Sr. Network Administrator
USPowerSolutions
mailto:[EMAIL PROTECTED] 
617.547.3800 x195






 This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above.  If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited.  If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.

Re: USER DUMP HOW?

2002-01-17 Thread Dale Edgar


Hi Diego

> Or you can write your own scripts, I have found this one between my
scripts,
> I have never tested, I prefer to use Import/Export for that kind of job.

The easy way to do this is to get the Freeware DBATool. It will read an
export file (created ROWS=N) and present you with the DDL contents in a
nicely formatted and intuitive manner.

It does lots of other things as well - you can generate recreate scripts for
all or part of a schema. (for example: a script that recreates a role and
every grant it has). The DBATool can strip of storage clause information
from every DDL bit code with a single button press or dump the entire schema
out to an HTML tree and just browse through the DDL as it suits you.

The DBATool is currently in beta. The second beta release (which cleaned up
a lot of 9i issues) was just released today. Download the DBATool from
http://www.databee.com/dt_home.htm

Cheers
Dale Edgar
Net 2000 Ltd.
[EMAIL PROTECTED]

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

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

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

RE: Freeable memory


Hi Michael:
  Why don't you use this Steve Adams' script to check the fragmentation
of your shared pool, it may be badly
fragmented and this problem could generate a lot of pressure at the shared
pool latch.
And this situation can also generate contention at a lower level latch (like
the library cache latch).
Make sure the session has been up and running for some time before running
it and don't execute any
shared pool flush before running it, or your data would be misleading.
   Here's the script, or you can dowload it from IXORA site.
www.ixora.com.au


--

---
--
-- Script: shared_pool_free_lists.sql
-- Purpose: to check the length of the shared pool free lists
-- For:  8.0 and higher
--
-- Copyright: (c) 2000 Ixora Pty Ltd
-- Author: Steve Adams
--
-- Warning: This script queries x$ksmsp which causes it to take the
--  shared pool latch for a fairly long time.
--  Think twice before running this script on a large system
--  with potential shared pool problems -- you may make it worse.
--

---
@save_sqlplus_settings

select
  decode(sign(ksmchsiz - 80), -1, 0, trunc(1/log(ksmchsiz - 15, 2)) - 5)
bucket,
  sum(ksmchsiz)  free_space,
  count(*)  free_chunks,
  trunc(avg(ksmchsiz))  average_size,
  max(ksmchsiz)  biggest
from
  sys.x_$ksmsp
where
  inst_id = userenv('Instance') and
  ksmchcls = 'free'
group by
  decode(sign(ksmchsiz - 80), -1, 0, trunc(1/log(ksmchsiz - 15, 2)) - 5)
/

@restore_sqlplus_settings

-


HTH
Diego Cutrone



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 7:10 PM


> All,
>   In trying to solve some Library Cache latch contention issues, I've been
> stumped on the following issues:
>
>   1) Do freeable chunks get coalesced during an ALTER SYSTEM FLUSH
> SHARED_POOL.
>   2) If freeable chunks are freed when a session disconnects, is there a
way
> to determine chunks per session? The idea here is better memory management
> through better session management.
>
>   I've aleviated the majority of latch contention by altering the
> _kgl_latch_count parameter, but haven't addressed what I think is the root
> cause: an oversized shared pool. I've found scripts that show the amount
of
> memory occupied by the sql area and library cache, and most if the memory
is
> in freeable chunks. Before downsizing the shared pool, I'd like to have a
> better understanding of how these chunks are managed.
>
> Regards,
>   Mike G
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Michael Ghelli
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: Raw I/O

2002-01-17 Thread Dejam, Ruth


I had responded to Witold privately but it seems that people want more so
here goes:

We went raw with our production billing system a few months ago 
because the vendor told damagement that it would be faster.  We also
converted our failover and testing environments because we do some
combination of SRDFs and BCVs of the production system (we are an HP shop).
FWIW, each of these monsters is a 2.4T OLTP database. 

Their code was crappy in a cooked database, and unbelievable as 
it may seems, performs slightly less crappy in a raw database. 

We have few SAs and DBAs that have ever worked with raw devices.  
Despite excellent documentation, configuring aio was *challenging*. 
The lack of experience has also given us ample opportunity to practice 
backups and restores. 

The good news is that our failover has worked flawlessly.  :) 

The upshot is yes, we've gotten slight performance gains.  Can you imagine
what would happen if we tuned the code, make a few database architectural
changes, etc?  In the meantime, it was easier and faster to go raw rather
than fix the code.  Add in the poor resources and you have a weiner!

My personal opinion is that we will not realize enough gains to justify
going raw.  I imagine it's only a matter of time before our business grows
enough to bring the system to a screeching halt again.  By them we will have
implemented yet another version or 2 and will not be able to figure out
exactly what to do.  I guess, at that time, we can go back to cooked.  :)

It was probably done for the vendor's own job security and most of our
management is totally clueless.  For me personally, it's been great because
I'm one of 3 DBAs here who have worked with raw before so I have more things
to play with now.

If you decide to go this route, make sure your SAs and DBAs are educated and
careful and get thyself some good backup software. 

You can check out past discussions about raw vs cooked at 
http://www.fatcity.com/ListGuru/login.php 

hth, 
~Ruth 

Ruth Dejam 
Senior Oracle DBA 
VoiceStream Wireless 

Do not meddle in the affairs of dragons for you are crunchy and taste good
with ketchup. 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 1/17/02 6:50 AM

I have been searching for the same answers for a long time and have
downloaded a lot of papers on the "raw vs cooked" and to get definitive
answers is a complicated task. Simple methods and opinions and examples
will go a long way in the understanding of a controversial and
complicated subject. Yes, I know that it is faster, more complicated, a
bear to administer but the answer is "it is used today in quite a few
shops". More informative answers would be appreciated and would help in
the decision process of "should we or shouldn't we use raw devices" and
what are the pitfalls and advantages if we do. A guide ,reference, or
link to help in the decisions would be a blessing.
ROR mª¿ªm


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

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

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

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

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

RE: Session info


Maybe it has something to do with the client.
I just did the same (ora81634 on NT) and the program contain only the
program name, 
not the whole path.
Our clients are sqlnet that came with 734 or 816.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Aldi Barco [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, January 17, 2002 6:54 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Session info
> 
> I did that from sqlplus.
> In 816 Linux that is varchar2(48).
> The output is truncated so I don't know the name of the application from
> the 
> client (it just showing
> C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D).
> 
> Aldi
> 
> -Original Message-
> Sent: Thursday, January 17, 2002 10:07 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I just did describe v$session and the program field is 64 bytes long.
> Maybe you are using a tool that limits the value to 48 bytes.
> Oracle 8.1.6 on NT.
> 
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
> 
> >-Original Message-
> >From:Aldi Barco [SMTP:[EMAIL PROTECTED]]
> >Sent:Thu, January 17, 2002 5:12 PM
> >To:  Multiple recipients of list ORACLE-L
> >Subject: Session info
> >
> >Hi Listers,
> >We can find the program executed from Client in 'program' field in 
> >v$session. But the problem is the field length just 48 character. Is
> there
> >
> >any other dictionary (v$ or x$ ?) to find 'the client program' completely
> 
> >(more than 48 character) ?
> >Thanks.
> >
> >Aldi
> >
> >_
> >Join the world's largest e-mail service with MSN Hotmail. 
> >http://www.hotmail.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Aldi Barco
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >  This e-mail was scanned by the eSafe Mail Gateway 
> >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Aldi Barco
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

Re: Disaster recovery using RMAN


Dennis,
Could you please share your regular backup strategies with me for me to
understand this better?

Thanks

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 9:00 AM


>
> Dennis,
>
> I hope you can clarify something in your plan for me.
>
> Why are you backing up to disk?  By doing so, you are losing one of the
> chief benefits of RMAN.  RMAN keeps a catalog of the tapes and knows
> which tapes to request to restore a backup, and which files to retrieve
> from those tapes.
>
> Do you backup the disk files to tape without the benefit of any tape
> management software?  Do you manually label the tapes?
>
> Thanks,
>
> Jared
>
>
>
>
>
> DENNIS WILLIAMS
> 
> TOUCH.COM>cc:
> Sent by:  Subject: RE: Disaster
recovery using  RMAN
> [EMAIL PROTECTED]
> m
>
>
> 01/17/02 05:05
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Sona - I am planning to test a disaster recovery using RMAN also. My
> company
> won't completely trust it until I can. Like you, I currently use RMAN to
> back up to disk, and write the backup to tape, keeping a Level 0 backup on
> disk. Here are the steps I am planning for disaster recovery.
>
> 1. Export the RMAN catalog and FTP a copy to the target system each time
> nightly backups are complete.
> 2. Back the Level 0 backup to tape, along with RMAN catalog export.
> 3. Mount the tape on the disaster recovery test system.
> 4. Assume that same version of Oracle is installed on the disaster
recovery
> test system.
> 5. Create an RMAN user and import the RMAN catalog export.
> 6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same
> path as on the original machine. If not, create a link so it looks like
the
> same location to the system.
> 7. Begin RMAN recovery, changing disk locations for the data files, as
> needed.
>
> I'm just listing these off the top of my head, so I may have left
something
> out. If you or any other listers see anything amiss with my plans, please
> point that out.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> Sent: Wednesday, January 16, 2002 5:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi
>
> Here in my company we are planning to put together a disaster recovery
plan
> using RMAN would like to test various recovery scenarios using RMAN.
>
> Could anyone provide the information on the procedures followed in a
> testing
> like this?
>
> TIA
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sona
  INET: [EMAIL PROTECTED]

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

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

RE: DBA Experiences with Oracle and RAID 0+1

Mogens:
Just let me disagree with you at only one point. According to my
experience, I think that the size of the disks in an array does matter
sometimes. It's not the same to have 24 9GB disks that to have only 3 of
73GB. You have 24 spindles againts 3, the first option (in a well configured
system of course) will give you better performance in enviroments where you
have a lot of concurrency and many users.
However I think that what I've written above might not be correct (may
be it should be tested) if the 73GB outstands for a long way the 9GB disks
in terms of seek time and transfer rate.
Take a look at an extract of Gaja's paper "Implementing RAID on Oracle":

"5) Procure the smallest drive money can buy, keeping in mind scalability,
limits of the host
machine, the disk array and growth projections for the database. This is a
tough one these
days, with 18 GB drives considered as small drives.

6) Bigger and faster drives are not always better than smaller slower
drives, as the seek times
for larger and faster drives with larger form factors, may be more than
their smaller and
slower counterparts. This is not that big of an issue, if your drives
support a built-in track
buffer cache for storing an entire track's worth of data from read
request(s)."

HTH
Greeting
Diego Cutrone

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 10:25 PM

> Jon,
>
> It's one of those "how many bags will I need in the supermarket?"
> questions - it depends.
>
> Consider:
>
> - RAID 1+0 is much better than 0+1.
> - Three disks is not much w.r.t. IO capability. If you have three
> concurrent users you'll be OK :)
> - Size doesn't matter (who cares if it's 10, 36 or 73 Gig disks? It's
> the IO capabilitity that counts)
> - I'm new to this list, so I don't know if this will work, but I've
> attached a brilliant presentation by our old friend James Morle (check
> out www.ScaleAbilities.com) regarding SAN, NAS and RAS (Random Acronym
> Seminar).
> - If you're only striping across three disks (is that really a SAN?)
> just SAME (Stripe And Mirror Everything). It might not be good, but it's
> simple.
>
> Jon Behnke wrote:
>
> >We are in the process of setting up a SAN using RAID 0+1 for our
database.
> >In our current environment, we are able to separate our tables, indexes,
> >rollback segments, and archive logs on different disks.  On the SAN we
would
> >have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable
> >space (3 disks worth of space).
> >
> >Some white papers that I have read suggest attempting to separate the
data,
> >indexes, and rollback segments on separate RAID volumes, and others
simply
> >suggest that the performance boost of striping will supercede the
separation
> >of these items.
> >
> >Can anyone offer any comments or suggestions?
> >
> >Jon Behnke
> >Applications Development Manager
> >Industrial Electric Wire & Cable
> >Phone (262) 957-1147  Fax (262) 957-1647
> >[EMAIL PROTECTED]
> >
>
>
>

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

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

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

Re: Using RMAN


See currently we are using Unix scripts to do our hot backups .We take the
backup on disk and everynight after the disk backup we copy the backup on
tape using Veritas Net Backup.
Presently we keep 2 days worth of backups on the disk and 3 days of archive
logs.That means at any point in time i have the last 2 days backup on disk
(just for fatster recovery so that we can aviod going to tapes in case of a
failure).
Now if we start using RMAN ,we would be taking hot backups (mostly using
increamental strategy) using RMAN.So for e.g. we start on say sunday  taking
an incremental level 0 backup  on disk.RMAN only remmbers the disk backup
...right Note that we will also be copying the backups on tape but that
will be independent of RMAN since it is not done using RMAN.
Say the next 3 days of the week ,we do increamental level 1 backups .On the
3 rd day  (i.e. Wednesday) i would have only Monday's and Tuesdays' backup
on disk (which are the inceemental llevel 1 backups since the whole ideas is
to keep last 2 days backup om disk).
So if we have a failure on Wednesday then RMAN would look for the
incremental level 0 backup of Sunday on the disk but that backup is not
present on the disk now.
I hope i have cleared it up enough.
Now my question is can we maintain the same policy of keeping 2 days backup
on disk by using RMAN.
What kind of backup strategies do RMAN users follow? Are RMAN backups
usually taken on tape directly ? Is it faster to take backups on tape rather
on disk while using RMAN?

Could RMAN users share their backup/recovery  strategies ,please.


TIA




- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 5:55 AM


> If you are using a recovery catalog then rman keeps track of everything
> there.  He knows if you've been naughty, he know if you've been nice, he
> knowsOOOPS I got carried away.  But  when you do a restore using rman
he
> will tell you what backup sets you will need.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 16, 2002 6:20 PM
>
>
> Hi
> Currently we are using Unix scripts to do backups.We keep last 2 days of
> backups on the disk and also take the backups on tape daily.
> We are planning to use RMAN for backups and would like to maintain the the
> same policy of 2 days backup on disk and daily tape backups.
> Is it possible to implement this using RMAN? Which backup will RMAN
remember
> (while restore) the disk backup or the tape backup?
> If we try to use the incremental strategy ,then how would RMAN remember
the
> last incremental level 0 backup ? It will not be present on disk since we
> only keep the last 2 days backup on it.
> How do i use RMAN to do restore/recovery in this case?
>
>
> I heard that taking backups on tape is faster than on disk when using
RMAN?
> Is it true?
>
> Could RMAN users share their backup/recovery  strategies ,please.
>
> TIA
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sona
  INET: [EMAIL PROTECTED]

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

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

Backup Strategy

2002-01-17 Thread Hamid Alavi


Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or link
I realy appreciate.




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

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

Oracle Financials DBA with 11i Needed in Tampa, Florida area..

2002-01-17 Thread OraStaff


Come work for a great company in the Tampa Florida area (Clearwater) that
needs an Oracle Financials DBA to join it's I.T. Team.
You will work with Oracle Applications and must have experience with 11i and
Excellent communications skills.

Looking for someone with very solid hands-on experience.

*Company want someone who is willing to work in Clearwater,
stay for 1 to 1 1/2 years, and be open to relocate to another
east-coast city after that.  

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

Requirements:
* Need to have 5 years DBA exp. and 3 years+ applications, 2 years 11i. 
* EXCELLENT COMMUNICATION SKILLS
* U.S. citizenship or permanent residents only

This position offers:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base salary-70-100K D.O.E., and great benefits.
   
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
ph: 1-800 -549-8502
Please use job code One/Tampa/Fin.DBA/Raush

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law







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

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

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

Partitioning and tkprof

2002-01-17 Thread Robertson Lee - lerobe




All,
 
Could of any of you 
ladies and gents take a peek at this and give me idea of what the explain 
plan is getting at  ??
 
Rows Execution Plan---  
---  
0  SELECT STATEMENT   GOAL: 
CHOOSE  0   PARTITION 
(CONCATENATED)  0    TABLE 
ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID) 
OF   
'PG_UK_CATEGORY_VENDOR'  
0 INDEX   GOAL: ANALYZED (RANGE SCAN) 
OF    
'PG_UK_CATEGORY_VENDOR_K' (NON-UNIQUE)
 
My limited knowledge 
would lead me to guess that this is going to all the partitions (well more than 
one anyway) to find the info. it is looking for. There is a problem with this 
process as it tends to take quite a bit of time. I was just hoping to be nudged 
in the right direction. FYI. The partition key is not part of the index on the 
table.
 
Regards
 
Lee

 

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

RE: USER DUMP HOW?


yes, you can use TOAD or SQL*NAVIGATOR for that.

Or you can write your own scripts, I have found this one between my scripts,
I have never tested, I prefer to use Import/Export for that kind of job.

HTH
DC





- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 3:41 PM


>
> Hi
> Is there any way to take user dump which containts
> indexes,tables,constraints etc like "create table tablename ...
like".I
> don't want to use import option.Can I do thru export only or not?
> Thanks
> -sEEMA
>
>
> _
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> 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).



Create_all_procs.sql
Description: Binary data

RE: Standby Instance questions and HA


IBM HACMP works well. 

Ooops. guess that means you'll have to change some things. ;-)

Seriously, we *did* get the Sun "clustering" working, but it
required some serious feet-to-fire holding and gyrations. 


-Original Message-
Sent: Thursday, January 17, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L


Thanks for the advice everyone.

So what do you recommend on a Sun cluster/machines for failover other than
OPS?
Quest Shareplex?
Standby database?
Any others?

Thanks,

Jim



-Original Message-
Sent: 17 January 2002 16:22
To: Multiple recipients of list ORACLE-L


I concur with BB.yea, I ran Sun "cluster" at  and
it broke ALOT.

Kept me and two full time Sun Engineers (they got paid ALOT more)
in consulting dollars, but i made a mental note not to use
it in "my business".

Caveat:  this was 1.5 years ago. Things change.

Mit Gluck, mein freund...


- Ross "mit schuss" Mohan

-Original Message-


Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
>
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
>
> Note, this is not a standby database.
>
> From the book it seams to work in the following way...
>
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
>
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
>
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
>
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
>
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
>
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
>
> The disk pack is RAID, and we may also have a standby database off site.
>
> Has anyone any recommendations?
>
>
> Thanks,
>
> Jim
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: James McCann
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

RE: OT -: SQL BackTrack info

2002-01-17 Thread Jared . Still




I'm glad to hear your success story with support on SQL*Backtrack, bacause
it is a very good product, usually.

A year ago the support was *very* bad.  Maybe they got the message
and got some people trained on the product.

Jared




   
 
Brian Wisniewski   
 

YAHOO.COM>   cc:   
 
Sent by: Subject: RE: OT -: SQL BackTrack info 
 
[EMAIL PROTECTED]   
 
   
 
   
 
01/17/02 06:50 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




We must have been lucky because BMC support really saved our butt a few
months back when we got a copy of LOGMASTER to recover some data from
some archived redo logs (long story).

We were really impressed with their support and everyone within our
group commented on how helpful and knowledgeable they were and how we
wished Oracle support was the same.

Never called for support on the SQL*Backtrack product but we have it
and love it.

Maybe it was a fluke that we got good support from BMC but I expect so
little from corporations technical support staff that I was really
blown away with theirs on that occasion.  Oracle support has made me a
very jaded person. ;-)

- Brian


--- [EMAIL PROTECTED] wrote:
>
> Ok, you guys are really missing the support issue.  :)
>
> The support is very bad.  Yes, you don't need it often.
>
> But when you do need it, they don't have it.
>
> SQL*Backtrack is normally run as a menu to the
> back end tools.  As I recall, even most of the commands
> used in cron for scheduled backups are wrappers to
> the back end tools.
>
> There are recovery situations that cannot be peformed from
> the SQL*Backtrack menu.  If you run into one of those, and
> cannot figure it out, support will be unable to help you.
>
> They know how to use the menu mode, and that's about it.
>
> Just after leaving a previous job where SQL*Backslack is
> still in use,  a tablespace in the data warehouse was trashed.
>
> It took 30+ days to recover it.  This is mostly due to inept support
> from BMC.  They like to do a lot of finger pointing, such as
> 'Your Legato indexes need rebuilt', even though that does
> not fix the problem.
>
> It used to be a great tool, and probably still is.  I would not but
> it based simply on support issues.
>
> Jared
>
>
>
>
>
>
> "Smith, Ron
>
> L."  To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]   cc:
>
> om>  Subject: RE: OT -: SQL
> BackTrack info
> Sent by:
>
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 01/16/02 11:13
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> We have been using it for about 5 years on both Unix and NT.  We have
> it
> connected to Netbackup to handle the tapes.  We love it.  I agree
> that the
> support is not what it used to be but we hardly ever need support.
> Although, the last time we called we got a support person that knew
> more
> about Oracle than
> we did and knew SQL Backtrack inside and out.  It's a great tool!
>
> Ron Smith
> Kerr-McGee Corp
>
> -Original Message-
> Sent: Wednesday, January 16, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I am looking for some guidance from people who use this product. Is
> it a
> value add to the organization or not. If possible also let me know
> how in
> the hell does it do a online object extraction from the backup.
>
> Would appreciate all your comments and recommendations
>
> Thx
> Gautam
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: S

used segment space in bytes

2002-01-17 Thread Oberkofler, Dieter

Title: Dieter Oberkofler Stationery



hi guys!
 
what would be the easiest way to compute the 
space
in bytes used by a segment?
it is rather easy to determine the # of used 
blocks
by a specific segment by looking at the 
dba_extents
for example. but how many blocks have been 
really used
in one of those extents. i guess i would be 
able
to compute the free blocks by using the 
dbms_space
package but it just seems to 
complicated.
any hints ... ?
 
thank you
 
-do

RE: Disaster recovery using RMAN

2002-01-17 Thread Jared . Still



Dennis,

I hope you can clarify something in your plan for me.

Why are you backing up to disk?  By doing so, you are losing one of the
chief benefits of RMAN.  RMAN keeps a catalog of the tapes and knows
which tapes to request to restore a backup, and which files to retrieve
from those tapes.

Do you backup the disk files to tape without the benefit of any tape
management software?  Do you manually label the tapes?

Thanks,

Jared




   
  
DENNIS WILLIAMS
  

TOUCH.COM>cc:  
  
Sent by:  Subject: RE: Disaster recovery using  
RMAN 
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
01/17/02 05:05 
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Sona - I am planning to test a disaster recovery using RMAN also. My
company
won't completely trust it until I can. Like you, I currently use RMAN to
back up to disk, and write the backup to tape, keeping a Level 0 backup on
disk. Here are the steps I am planning for disaster recovery.

1. Export the RMAN catalog and FTP a copy to the target system each time
nightly backups are complete.
2. Back the Level 0 backup to tape, along with RMAN catalog export.
3. Mount the tape on the disaster recovery test system.
4. Assume that same version of Oracle is installed on the disaster recovery
test system.
5. Create an RMAN user and import the RMAN catalog export.
6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same
path as on the original machine. If not, create a link so it looks like the
same location to the system.
7. Begin RMAN recovery, changing disk locations for the data files, as
needed.

I'm just listing these off the top of my head, so I may have left something
out. If you or any other listers see anything amiss with my plans, please
point that out.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, January 16, 2002 5:21 PM
To: Multiple recipients of list ORACLE-L



Hi

Here in my company we are planning to put together a disaster recovery plan
using RMAN would like to test various recovery scenarios using RMAN.

Could anyone provide the information on the procedures followed in a
testing
like this?

TIA

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

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

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




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

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

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

2002-01-17 Thread Gogala, Mladen


Don't be afraid. I'm not hungry today.

-Original Message-
Sent: Thursday, January 17, 2002 11:31 AM
To: Multiple recipients of list ORACLE-L


Oh, no!   Not Gogala M Laden!

-Original Message-

Stephane...  

You're mean...

:-)

-Original Message-
Sent: Thursday, January 17, 2002 6:25 AM
To: Multiple recipients of list ORACLE-L


Seema Singh wrote:
> 
> Hi
> At time of export i am getting following error
> "EXP-8: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too
> small"
> 
> Please suggest
> Thanks
> -Seema

Mladen, any idea ?
-- 
Regards,

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

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

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

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

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

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

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

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

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

RE: snapshot too old

2002-01-17 Thread Gogala, Mladen


There are several ideas, but I'm working on my charming and
likable personality. I must do something before the duhveleopers 
organize a lynch mob and burn me at stake.

-Original Message-
Sent: Thursday, January 17, 2002 11:11 AM
To: Multiple recipients of list ORACLE-L


Stephane...  

You're mean...

:-)

-Original Message-
Sent: Thursday, January 17, 2002 6:25 AM
To: Multiple recipients of list ORACLE-L


Seema Singh wrote:
> 
> Hi
> At time of export i am getting following error
> "EXP-8: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too
> small"
> 
> Please suggest
> Thanks
> -Seema

Mladen, any idea ?
-- 
Regards,

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

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

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

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

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

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread Rachel Carmichael


we had it with FirstWatch from Veritas on top -- sometimes disks didn't
get dismounted from the first server, or remounted on the second one..
then we had database failures


--- "Baker, Barbara" <[EMAIL PROTECTED]> wrote:
> 
> Jim:
> Sorry, you're not gonna like this answer.  HA is a Sun product, not
> an
> Oracle product. Under Sun's High Availability, you can configure
> several
> modules like Sybase and Oracle.  (The Oracle product is Sun Cluster
> HA-DBMS
> for Oracle.)  It does require what I believe Sun calls a cluster but
> (IMHO)
> is a bastardization of the term.  It truly is failover, not cluster.
> 
> We've had lots of problems with it.  It's caused us lots of grief,
> and only
> in a few instances gained us anything.  It is NOT OPS, as the
> database does
> not run in parallel, but only on 1 box at a time.  (Everything is
> double
> cabled, and so the drives are re-mounted on the 2nd box if a failover
> occurs.)  Your users still get disconnected.  You'd probably lose
> less data
> than with a standby (since you pick up with the same drives mounted
> on the
> other box), but it depends on how you have the standby implemented.  
> 
> There's no additional cost from Oracle to run this crap, but you'll
> be
> paying Sun great sums of money.  The Sun web site has more info on
> HA.
> 
> 
> Let me know if you need more info.
> Good luck!
> 
> Barb
> 
> 
> > --
> > From:   James McCann[SMTP:[EMAIL PROTECTED]]
> > Reply To:   [EMAIL PROTECTED]
> > Sent:   Thursday, January 17, 2002 5:40 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Standby Instance questions and HA
> > 
> > Hi,
> >   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> > Standby
> > Instances.
> > 
> > Note, this is not a standby database.
> > 
> > From the book it seams to work in the following way...
> > 
> > There is only one database.
> > The database files exist on a shared disk pack. One machine is the
> primary
> > instance, and if this instance dies, a new instance is started on
> the
> > second
> > machine using the datafiles on the shared disk.
> > 
> > The problem is that I can't find anything in the Oracle docs about
> this,
> > or
> > on Meta Link.
> > 
> > I also want to know if this method of HA requires a clustered
> environment
> > (I
> > think it does, but just want to be sure)?
> > 
> > Also, does it come with an Enterprise Edition license?
> > Or is it something which each hardware vendor implements in their
> own way,
> > at extra cost?
> > 
> > We have a requirement for a fail over method on Sun Solaris.
> > We do not want to loose any committed data (i.e. a standby database
> could
> > loose some), and want the fail over to be as automatic as possible.
> > 
> > We don't want the expense of Parallel Server (Anyone know how
> expensive it
> > is these days?).
> > 
> > The disk pack is RAID, and we may also have a standby database off
> site.
> > 
> > Has anyone any recommendations?
> > 
> > 
> > Thanks,
> > 
> > Jim
> > 
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: James McCann
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Baker, Barbara
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
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 PROTECTE

Re: Maximum number of redo log members

2002-01-17 Thread Joan Hsieh


I got this query from the list. I can try it.  

JOan

select 
decode (indx,
3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY 
') , rsnum from x$kccrs 
where indx in (3,4,2,9) 
union all 
select 'MAXLOGMEMBERS ',dimlm from x$kccdi 
/ 

Rachel Carmichael wrote:
> 
> I believe that the only way to see that information is to do an alter
> database backup controlfile to trace
> 
> as it is stored only in the controlfiles. This was true in 7.3 and 8.x
> --- Sinard Xing <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ?
> >
> > I mean which views or tables (DD) to query from.
> >
> >
> >
> >
> > Note:
> > Oracle doc said "see your operating system-specific Oracle
> > documentation",
> > which is I don't have any : (
> >
> >
> > Thank you
> >
> > Sinardy
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sinard Xing
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> --
> 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: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

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

RE: Session info

2002-01-17 Thread Aldi Barco


I did that from sqlplus.
In 816 Linux that is varchar2(48).
The output is truncated so I don't know the name of the application from the 
client (it just showing C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D).

Aldi

-Original Message-
Sent: Thursday, January 17, 2002 10:07 AM
To: Multiple recipients of list ORACLE-L


I just did describe v$session and the program field is 64 bytes long.
Maybe you are using a tool that limits the value to 48 bytes.
Oracle 8.1.6 on NT.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

>-Original Message-
>From:  Aldi Barco [SMTP:[EMAIL PROTECTED]]
>Sent:  Thu, January 17, 2002 5:12 PM
>To:Multiple recipients of list ORACLE-L
>Subject:   Session info
>
>Hi Listers,
>We can find the program executed from Client in 'program' field in 
>v$session. But the problem is the field length just 48 character. Is there
>
>any other dictionary (v$ or x$ ?) to find 'the client program' completely 
>(more than 48 character) ?
>Thanks.
>
>Aldi
>
>_
>Join the world's largest e-mail service with MSN Hotmail. 
>http://www.hotmail.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Aldi Barco
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread James McCann


Thanks for the advice everyone.

So what do you recommend on a Sun cluster/machines for failover other than
OPS?
Quest Shareplex?
Standby database?
Any others?

Thanks,

Jim



-Original Message-
Sent: 17 January 2002 16:22
To: Multiple recipients of list ORACLE-L


I concur with BB.yea, I ran Sun "cluster" at  and
it broke ALOT.

Kept me and two full time Sun Engineers (they got paid ALOT more)
in consulting dollars, but i made a mental note not to use
it in "my business".

Caveat:  this was 1.5 years ago. Things change.

Mit Gluck, mein freund...


- Ross "mit schuss" Mohan

-Original Message-


Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
>
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
>
> Note, this is not a standby database.
>
> From the book it seams to work in the following way...
>
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
>
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
>
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
>
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
>
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
>
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
>
> The disk pack is RAID, and we may also have a standby database off site.
>
> Has anyone any recommendations?
>
>
> Thanks,
>
> Jim
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: James McCann
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Standby Instance questions and HA

2002-01-17 Thread Rachel Carmichael


It's not an Oracle thing, so there wouldn't be anything in the docs

yes, you need a clustered environment, or at the least the ability for
the disks to be mounted on the second server when the first one goes
down.

As long as the disk that oracle has been installed on is one of the
ones that moves, or the install is identical, you can do this.

--- James McCann <[EMAIL PROTECTED]> wrote:
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
> 
> Note, this is not a standby database.
> 
> From the book it seams to work in the following way...
> 
> There is only one database.
> The database files exist on a shared disk pack. One machine is the
> primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
> 
> The problem is that I can't find anything in the Oracle docs about
> this, or
> on Meta Link.
> 
> I also want to know if this method of HA requires a clustered
> environment (I
> think it does, but just want to be sure)?
> 
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own
> way,
> at extra cost?
> 
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database
> could
> loose some), and want the fail over to be as automatic as possible.
> 
> We don't want the expense of Parallel Server (Anyone know how
> expensive it
> is these days?).
> 
> The disk pack is RAID, and we may also have a standby database off
> site.
> 
> Has anyone any recommendations?
> 
> 
> Thanks,
> 
> Jim
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: James McCann
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
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: Standby Instance questions and HA

2002-01-17 Thread Jenkins, Michael


We have this in place on Sun as well.  It is similar to a cluster in that it
has a separate box (Ultra 2) monitoring a heartbeat between both database
servers.  You will have a significant impact during failover.  All drives
common to both boxes will be unmounted on the primary and remounted on the
secondary (which then becomes the primary).  Since a "fsck" is run for each
file system it can take upwards of 30 minutes for the failover.  The
database is shut down and brought back up so all connections are severed
which means an interruption of service.

If I wanted H/A on Sun I would move to 9i and implement a RAC.  No
application changes are necessary with this new version of OPS.

Good luck.

--Michael

-Original Message-
Sent: Thursday, January 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L



Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.  

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
> 
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
> 
> Note, this is not a standby database.
> 
> From the book it seams to work in the following way...
> 
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
> 
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
> 
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
> 
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
> 
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
> 
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
> 
> The disk pack is RAID, and we may also have a standby database off site.
> 
> Has anyone any recommendations?
> 
> 
> Thanks,
> 
> Jim
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: James McCann
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

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

RE: Partitions

2002-01-17 Thread Hamid Alavi


Thanks Ron,
So it's better I put partitions in deffrent tablespace and also for better
performance in diffrent physical disks, it will helps.
I am going to do the partition on Creation date or on Primary Key(PK is a
sequence number), don't know can we use PK as a range for partitioning or
not?
Thanks again for your help.


-Original Message-
Sent: Thursday, January 17, 2002 6:02 AM
To: Multiple recipients of list ORACLE-L


Hamid,
Partitions are basically for the use of Oracle. It allows you to break
apart a large table into several smaller sections to help in the
management of the table data and to help Oracle find the data you
requested. Under ideal conditions, Oracle will only select the smallest
area to search for the data you have requested. If the table is 1
tablespace and large in size, it can take an enormous amount of
resources to find the data you selected. If the table is partitioned
correctly, Oracle will only search the partition/s that it needs to find
your data.
The application code does not need to be changed. The application will
request data from a table and Oracle will determine which partition to
use.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/16/02 04:06PM >>>
List,
If we use partitioning for a big tables after finish development, do we
have
to change the code for accReceived: from CONNECT-MTA by galotteressing
diffrent partition or this will handle
by
oracle itself.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

RE: snapshot too old


Oh, no!   Not Gogala M Laden!

-Original Message-

Stephane...  

You're mean...

:-)

-Original Message-
Sent: Thursday, January 17, 2002 6:25 AM
To: Multiple recipients of list ORACLE-L


Seema Singh wrote:
> 
> Hi
> At time of export i am getting following error
> "EXP-8: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too
> small"
> 
> Please suggest
> Thanks
> -Seema

Mladen, any idea ?
-- 
Regards,

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

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

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

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

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

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

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

RE: Standby Instance questions and HA


I concur with BB.yea, I ran Sun "cluster" at  and 
it broke ALOT. 

Kept me and two full time Sun Engineers (they got paid ALOT more)
in consulting dollars, but i made a mental note not to use
it in "my business". 

Caveat:  this was 1.5 years ago. Things change. 

Mit Gluck, mein freund...


- Ross "mit schuss" Mohan 

-Original Message-


Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.  

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
> 
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
> 
> Note, this is not a standby database.
> 
> From the book it seams to work in the following way...
> 
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
> 
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
> 
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
> 
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
> 
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
> 
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
> 
> The disk pack is RAID, and we may also have a standby database off site.
> 
> Has anyone any recommendations?
> 
> 
> Thanks,
> 
> Jim
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: James McCann
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: procedure error


Hello Lance

This one works:

CREATE OR REPLACE PROCEDURE Primus_Report
AS
begin
execute immediate 'Drop Table PRIMUS_TEMP_DUMP';
execute immediate 'CREATE TABLE PRIMUS_TEMP_DUMP (SOLUTION_ID VARCHAR2 (85)
NOT NULL)
  TITLEVARCHAR2 (3498)),
  OWNERVARCHAR2 (255),
  P_TYPE   VARCHAR2 (96),
  AUTHOR   VARCHAR2 (255),
  MODIFIED_BY  VARCHAR2 (255),
  ESCALATION_GROUP VARCHAR2 (255),
  TECH_RESOURCEVARCHAR2 (255),
  P_PARTITION  VARCHAR2 (96),
  STATUS   VARCHAR2 (96),
  HyperLinksVARCHAR2 (96),
  Style_reviewer VARCHAR2 (96),
  DATE_CREATED DATE,
  DATE_MODIFIEDDATE,
  ALERTVARCHAR2 (96),
  URGENCY  VARCHAR2 (96),
  NO_PAGEVIEWS_LAST_MONTH  VARCHAR2 (255),
  NO_PAGEVIEWS_QUARTER VARCHAR2 (255),
  NO_LINKS_LAST_WEEK   VARCHAR2 (255),
  NO_LINKS_LAST_MONTH  VARCHAR2 (255) )';
execute immediate 'INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT
pc_solution_id, pc_title FROM pt_solution';
end;
/


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Lance Prais [SMTP:[EMAIL PROTECTED]]
> Sent: Wed, January 16, 2002 11:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  procedure error
> 
>   Why in toad when I try to create a stored proc where I drop and
> create a table I get the following error:  
>
>   PLS-00103: Encountered the symbol "DROP" when expecting one of the
> following:
>  begin function package pragma procedure subtype type use
>cur
>
>
>   Here is my code:
>
>   CREATE OR REPLACE PROCEDURE Primus_Report
>   AS
>   Drop Table PRIMUS_TEMP_DUMP;
>   CREATE TABLE PRIMUS_TEMP_DUMP (
> SOLUTION_ID  VARCHAR2 (85)  NOT NULL,
> TITLEVARCHAR2 (3498),
> OWNERVARCHAR2 (255),
> P_TYPE   VARCHAR2 (96),
> AUTHOR   VARCHAR2 (255),
> MODIFIED_BY  VARCHAR2 (255),
> ESCALATION_GROUP VARCHAR2 (255),
> TECH_RESOURCEVARCHAR2 (255),
> P_PARTITION  VARCHAR2 (96),
> STATUS   VARCHAR2 (96),
> HyperLinksVARCHAR2 (96),
> Style_reviewer VARCHAR2 (96),
> DATE_CREATED DATE,
> DATE_MODIFIEDDATE,
> ALERTVARCHAR2 (96),
> URGENCY  VARCHAR2 (96),
> NO_PAGEVIEWS_LAST_MONTH  VARCHAR2 (255),
> NO_PAGEVIEWS_QUARTER VARCHAR2 (255),
> NO_LINKS_LAST_WEEK   VARCHAR2 (255),
> NO_LINKS_LAST_MONTH  VARCHAR2 (255) );
>   INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT
> pc_solution_id, pc_title FROM pt_solution;
>   end;
>   /
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

2002-01-17 Thread Johnston, Tim


Stephane...  

You're mean...

:-)

-Original Message-
Sent: Thursday, January 17, 2002 6:25 AM
To: Multiple recipients of list ORACLE-L


Seema Singh wrote:
> 
> Hi
> At time of export i am getting following error
> "EXP-8: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too
> small"
> 
> Please suggest
> Thanks
> -Seema

Mladen, any idea ?
-- 
Regards,

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

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

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

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread Johnston, Tim


Veritas also has a product that will do this for you...

-Original Message-
Sent: Thursday, January 17, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L


Check the Sun web site.  Sun has clustering.  I do not know the name
of the product off the top of my head since I use HP MC/ServiceGuard.


-Original Message-
McCann
Sent: Thursday, January 17, 2002 7:06 AM
To: Multiple recipients of list ORACLE-L


I think your right. But does anyone know what is use on Solaris?

Thanks,

Jim

-Original Message-
Sent: 17 January 2002 15:00
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



What you are describing sounds like Oracle FailSafe.  It is free from
Oracle, does not require Oracle Enterprise version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.





"James McCann"

lecom.com>  cc:
Sent by:Subject: Standby Instance
questions and HA
[EMAIL PROTECTED]


01/17/2002 06:40
AM
Please respond
to ORACLE-L






Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby
Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary
instance, and if this instance dies, a new instance is started on the
second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or
on Meta Link.

I also want to know if this method of HA requires a clustered environment
(I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license?
Or is it something which each hardware vendor implements in their own way,
at extra cost?

We have a requirement for a fail over method on Sun Solaris.
We do not want to loose any committed data (i.e. a standby database could
loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it
is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?


Thanks,

Jim




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

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

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





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

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

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

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

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

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

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

RE: Session info


I just did describe v$session and the program field is 64 bytes long.
Maybe you are using a tool that limits the value to 48 bytes.
Oracle 8.1.6 on NT.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Aldi Barco [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, January 17, 2002 5:12 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Session info
> 
> Hi Listers,
> We can find the program executed from Client in 'program' field in 
> v$session. But the problem is the field length just 48 character. Is there
> 
> any other dictionary (v$ or x$ ?) to find 'the client program' completely 
> (more than 48 character) ?
> Thanks.
> 
> Aldi
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Aldi Barco
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread Baker, Barbara



Jim:
Sorry, you're not gonna like this answer.  HA is a Sun product, not an
Oracle product. Under Sun's High Availability, you can configure several
modules like Sybase and Oracle.  (The Oracle product is Sun Cluster HA-DBMS
for Oracle.)  It does require what I believe Sun calls a cluster but (IMHO)
is a bastardization of the term.  It truly is failover, not cluster.

We've had lots of problems with it.  It's caused us lots of grief, and only
in a few instances gained us anything.  It is NOT OPS, as the database does
not run in parallel, but only on 1 box at a time.  (Everything is double
cabled, and so the drives are re-mounted on the 2nd box if a failover
occurs.)  Your users still get disconnected.  You'd probably lose less data
than with a standby (since you pick up with the same drives mounted on the
other box), but it depends on how you have the standby implemented.  

There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money.  The Sun web site has more info on HA.


Let me know if you need more info.
Good luck!

Barb


> --
> From: James McCann[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, January 17, 2002 5:40 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Instance questions and HA
> 
> Hi,
>   I was reading in the book "Oracle 24/7 Tips and Techniques" about
> Standby
> Instances.
> 
> Note, this is not a standby database.
> 
> From the book it seams to work in the following way...
> 
> There is only one database.
> The database files exist on a shared disk pack. One machine is the primary
> instance, and if this instance dies, a new instance is started on the
> second
> machine using the datafiles on the shared disk.
> 
> The problem is that I can't find anything in the Oracle docs about this,
> or
> on Meta Link.
> 
> I also want to know if this method of HA requires a clustered environment
> (I
> think it does, but just want to be sure)?
> 
> Also, does it come with an Enterprise Edition license?
> Or is it something which each hardware vendor implements in their own way,
> at extra cost?
> 
> We have a requirement for a fail over method on Sun Solaris.
> We do not want to loose any committed data (i.e. a standby database could
> loose some), and want the fail over to be as automatic as possible.
> 
> We don't want the expense of Parallel Server (Anyone know how expensive it
> is these days?).
> 
> The disk pack is RAID, and we may also have a standby database off site.
> 
> Has anyone any recommendations?
> 
> 
> Thanks,
> 
> Jim
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: James McCann
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

RE: Standby Instance questions and HA


"Full Moon.  "

(it's going through stages, waxing. give me a break.)

Supposedly they named it that because wolves howl at 
the moon. Get it? "Wolfpack" is microsoft's clustering
moniker. Give me another break. Doesn't Scott McNealy
have a jacuzzi at home he can spend time in?)

-Original Message-

Check the Sun web site.  Sun has clustering.  I do not know the name
of the product off the top of my head since I use HP MC/ServiceGuard.


-Original Message-
McCann
Sent: Thursday, January 17, 2002 7:06 AM
To: Multiple recipients of list ORACLE-L


I think your right. But does anyone know what is use on Solaris?

Thanks,

Jim

-Original Message-
Sent: 17 January 2002 15:00
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



What you are describing sounds like Oracle FailSafe.  It is free from
Oracle, does not require Oracle Enterprise version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.





"James McCann"

lecom.com>  cc:
Sent by:Subject: Standby Instance
questions and HA
[EMAIL PROTECTED]


01/17/2002 06:40
AM
Please respond
to ORACLE-L






Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby
Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary
instance, and if this instance dies, a new instance is started on the
second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or
on Meta Link.

I also want to know if this method of HA requires a clustered environment
(I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license?
Or is it something which each hardware vendor implements in their own way,
at extra cost?

We have a requirement for a fail over method on Sun Solaris.
We do not want to loose any committed data (i.e. a standby database could
loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it
is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?


Thanks,

Jim




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

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

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





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

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

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

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

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

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

To REMOVE yourself from this mailing list, send an

RE: Database Views

2002-01-17 Thread SRAJENDRAN

Thank you all for your opinions.

The tables that I want to consolidate are 15 Million rows each.  So five
tables put together will constitute 75 million rows in one table.  I will
have to consider partitioning after that for optimum performance.  Also
Materialized view would take a long time to refresh all these tables
especially if it is a complete refresh.

- Srini

-Original Message-
Sent: Thursday, January 17, 2002 10:21 AM
To: Multiple recipients of list ORACLE-L

This is why data marts were created.

You would be much better off to create a reporting database
based on the data you need to see.

You won't be happy doing this with views from several databases.

It won't perform well.  As Rachel pointed out it will be inconsistent.

At the very least you could create snapshots of these tables so that
all of the data would be locally available.

Just my $0.02.

Jared

On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote:
> I would like get your opinion on what would be the best way provide access
> to data across multiple databases on just on Node (database).
>
> One way that I have tried is create a view on one database that reads
> tables across remaining four databases using Dblinks.  Let us say there is
> a table called CUSTOMER that resides on five databases, in order to make
it
> easier to generate reports, a combined view can be created with dblinks on
> these tables using UNION ALL on one database.
>
> Only concern I have is that when using Dblinks, Oracle might copy the
> entire remote table to the local database and then retrieve the data based
> on where clause.  This might be a significant performance issue especially
> if the tables are very BIG.
>
> If there are better ways to accomplish this or any ideas on this one will
> be greatly appreciated.
>
> Thank you,
> Srini
-- 
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: 
  INET: [EMAIL PROTECTED]

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread Kimberly Smith


Check the Sun web site.  Sun has clustering.  I do not know the name
of the product off the top of my head since I use HP MC/ServiceGuard.


-Original Message-
McCann
Sent: Thursday, January 17, 2002 7:06 AM
To: Multiple recipients of list ORACLE-L


I think your right. But does anyone know what is use on Solaris?

Thanks,

Jim

-Original Message-
Sent: 17 January 2002 15:00
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



What you are describing sounds like Oracle FailSafe.  It is free from
Oracle, does not require Oracle Enterprise version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.





"James McCann"

lecom.com>  cc:
Sent by:Subject: Standby Instance
questions and HA
[EMAIL PROTECTED]


01/17/2002 06:40
AM
Please respond
to ORACLE-L






Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby
Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary
instance, and if this instance dies, a new instance is started on the
second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or
on Meta Link.

I also want to know if this method of HA requires a clustered environment
(I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license?
Or is it something which each hardware vendor implements in their own way,
at extra cost?

We have a requirement for a fail over method on Sun Solaris.
We do not want to loose any committed data (i.e. a standby database could
loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it
is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?


Thanks,

Jim




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

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

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





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

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

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

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

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

RE: Database Views


Hello Rachel

1) Yes.
You can also change your application to update the new table whenever
something
change in one of the file.
Since personal do not change every day (hopefully) one day lag is OK for
us.
2) This is done with SQL program that do delete and then insert and commit.
Either the program works and I have a new copy or it didn't work and I
am left with yesterday data.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, January 17, 2002 4:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Database Views
> 
> that works as long as you can live with possibly inconsistent data in
> the joint table due to either
> 
> 1) updates to the employee data on either site during the day not 
> reflected in the joint table until the nightly processing is done
>  
> 2) nightly process failing and data in the joint table either
> non-existent or wrong
> 
> 
> --- àãø_éçéàì <[EMAIL PROTECTED]> wrote:
> > Hello Srini
> > 
> > We had a case like this where one of the tables was in a database
> > that
> > reside in a remote site.
> > Our solution was to create a table that combine employees tables from
> > 2 site
> > into one TABLE in the local site.
> > 
> > This way the select and join is done ONCE at night.
> > 
> > Yechiel Adar, Mehish Computer Services
> > [EMAIL PROTECTED]
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wed, January 16, 2002 10:05 PM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  Database Views
> > > 
> > > I would like get your opinion on what would be the best way provide
> > access
> > > to data across multiple databases on just on Node (database).
> > > 
> > > One way that I have tried is create a view on one database that
> > reads
> > > tables
> > > across remaining four databases using Dblinks.  Let us say there is
> > a
> > > table
> > > called CUSTOMER that resides on five databases, in order to make it
> > easier
> > > to generate reports, a combined view can be created with dblinks on
> > these
> > > tables using UNION ALL on one database.  
> > > 
> > > Only concern I have is that when using Dblinks, Oracle might copy
> > the
> > > entire
> > > remote table to the local database and then retrieve the data based
> > on
> > > where
> > > clause.  This might be a significant performance issue especially
> > if the
> > > tables are very BIG.  
> > > 
> > > If there are better ways to accomplish this or any ideas on this
> > one will
> > > be
> > > greatly appreciated.
> > > 
> > > Thank you,
> > > Srini
> > > 
> > > -- 
> > > 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).
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >  This e-mail was scanned by the eSafe Mail Gateway 
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> -- 
> 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

Re: Database Views

2002-01-17 Thread Jared Still

This is why data marts were created.

You would be much better off to create a reporting database
based on the data you need to see.

You won't be happy doing this with views from several databases.

It won't perform well.  As Rachel pointed out it will be inconsistent.

At the very least you could create snapshots of these tables so that
all of the data would be locally available.

Just my $0.02.

Jared

On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote:
> I would like get your opinion on what would be the best way provide access
> to data across multiple databases on just on Node (database).
>
> One way that I have tried is create a view on one database that reads
> tables across remaining four databases using Dblinks.  Let us say there is
> a table called CUSTOMER that resides on five databases, in order to make it
> easier to generate reports, a combined view can be created with dblinks on
> these tables using UNION ALL on one database.
>
> Only concern I have is that when using Dblinks, Oracle might copy the
> entire remote table to the local database and then retrieve the data based
> on where clause.  This might be a significant performance issue especially
> if the tables are very BIG.
>
> If there are better ways to accomplish this or any ideas on this one will
> be greatly appreciated.
>
> Thank you,
> Srini
-- 
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: SQL Loader Direct Load - Problem with Index Rebuild


Hello Jay

Here is a little script that will generate the commands needed to rebuild
the indexes:

spool rebuild.sql

select distinct 'alter table '||table_name||' modify partition
'||p.partition_name||' rebuild unusable local indexes;'
from user_ind_partitions p, user_TAB_PARTITIONS t
where p.status='UNUSABLE' and p.partition_name=t.partition_name;

select distinct 'alter index '||index_name||' rebuild;'
from user_indexes where status='INVALID' or status='UNUSABLE';

spool off


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Miller, Jay [SMTP:[EMAIL PROTECTED]]
> Sent: Wed, January 16, 2002 5:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  SQL Loader Direct Load - Problem with Index Rebuild
> 
> Hi,
> 
> Okay, this is the second time this has happened and while I have a guess
> I'd
> appreciate any feedback on the issue.  Last night during a direct load to
> one of our datawarehouse tables 4 of the index partition rebuilds failed
> with the following errors (the remaining partitions were fine, as were all
> the other indexes):
> 
> index EIS.IDX_BKP_TRANS_DATE partition BOOK2001OCT was made unusable due
> to:
> ORA-01652: unable to extend temp segment by 320 in tablespace
> TS_BOOKKEEPING_FACT_IDX
> index EIS.IDX_BKP_TRANS_DATE partition BOOK2001NOV was made unusable due
> to:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> TS_BOOKKEEPING_FACT_IDX
> index EIS.IDX_BKP_TRANS_DATE partition BOOK2001DEC was made unusable due
> to:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> TS_BOOKKEEPING_FACT_IDX
> index EIS.IDX_BKP_TRANS_DATE partition BOOK2002JAN was made unusable due
> to:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> TS_BOOKKEEPING_FACT_IDX
> 
> I was able to manually rebuild the index partitions with no problem.  
> 
> There are currently 1,881 free extents of the size 320 blocks in that
> tablespace.  The entire index (including all partitions) only takes up 473
> extents.  We have degrees=1 on the index.
> 
> There's a metalink Forum thread (ORA 1652 During Direct Load) where a
> similar problem occurred.  It seems to imply each index may be claiming 2x
> it's required space while being rebuilt and that SMON might not clean up
> that space right away.  This could certainly have caused there to be not
> enough space available if it required the tablespace to be 2x the size of
> *all* the indexes.  In that case the fact that SMON cleaned it up before I
> did the manual rebuild would explain why the latter worked.
> Looking at the tablespace I see that it is currently almost 2x the size so
> it's possible that's why I had avoided the problem for the last few
> months.
> 
> Has anyone else had this problem and is there a workaround short of
> dropping
> the indexes before the load and recreating them?  I'd rather avoid that
> since it's usually only a few partitions that need to be rebuilt.
> 
> I'm on Oracle 8.1.6.3, Solaris 2.6.
> 
> Thanks,
> Jay Miller
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

Re: [Q] can ORACLE FORMS 2.1 and 6i run under same NT computer?

2002-01-17 Thread Jared Still

The only way this could work is to have a separate Oracle
home for the Forms 2.1, with the appropriate binaries.

And since this is a very old version of Oracle, you would need
another box to put it on.

And then it still might not work.

Jared

On Thursday 17 January 2002 04:55, dist cash wrote:
> Has anyone installed and run ORACLE FORMS 2.1 and 6i run time version
> under same NT compter?
>
> Will any problem happen?
>
>
> Thanks.
>
>
>
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.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: Raw I/O

2002-01-17 Thread Jared Still

Tuning apps and SQL will nearly always yield a much bigger
performance gain than using raw filesystems rather than cooked.

It's not too unusual to find a very few pieces of code or SQL in
an app that can provide dramatic improvements.

Even with 3rd party apps there are often opportunities for 
improving data access via indexes and partitioning.

Jared

On Thursday 17 January 2002 06:50, Ron Rogers wrote:
> I have been searching for the same answers for a long time and have
> downloaded a lot of papers on the "raw vs cooked" and to get definitive
> answers is a complicated task. Simple methods and opinions and examples
> will go a long way in the understanding of a controversial and
> complicated subject. Yes, I know that it is faster, more complicated, a
> bear to administer but the answer is "it is used today in quite a few
> shops". More informative answers would be appreciated and would help in
> the decision process of "should we or shouldn't we use raw devices" and
> what are the pitfalls and advantages if we do. A guide ,reference, or
> link to help in the decisions would be a blessing.
> ROR mª¿ªm
-- 
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).

Oracle8i and the Jserv demos

2002-01-17 Thread Ben Poels


Hi

I have installed Oracle 8.1.7.0 on an AIX 4.3 box and the Jserv
demos do not work. I looked at the jserv.log and it seems to
not be finding the java executables. I downloaded Java.rte for AIX
from IBM and put it in the $ORACLE_HOME/Apache/jdk/bin directory
but it still doesn't work. I am not too familiar with AIX so can
anyone explain to me how and where to install java on an AIX box.
I would open a tar but we renewed our licenses and ever since I have
been unable to get registered properly with MetaLink.

Thanks,

Ben


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

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

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

Session info

2002-01-17 Thread Aldi Barco


Hi Listers,
We can find the program executed from Client in 'program' field in 
v$session. But the problem is the field length just 48 character. Is there 
any other dictionary (v$ or x$ ?) to find 'the client program' completely 
(more than 48 character) ?
Thanks.

Aldi

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

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

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

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

RE: Standby Instance questions and HA

2002-01-17 Thread James McCann


I think your right. But does anyone know what is use on Solaris?

Thanks,

Jim

-Original Message-
Sent: 17 January 2002 15:00
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



What you are describing sounds like Oracle FailSafe.  It is free from
Oracle, does not require Oracle Enterprise version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.





"James McCann"

lecom.com>  cc:
Sent by:Subject: Standby Instance
questions and HA
[EMAIL PROTECTED]


01/17/2002 06:40
AM
Please respond
to ORACLE-L






Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby
Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary
instance, and if this instance dies, a new instance is started on the
second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or
on Meta Link.

I also want to know if this method of HA requires a clustered environment
(I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license?
Or is it something which each hardware vendor implements in their own way,
at extra cost?

We have a requirement for a fail over method on Sun Solaris.
We do not want to loose any committed data (i.e. a standby database could
loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it
is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?


Thanks,

Jim




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

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

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





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

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

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

AW: Database Views

2002-01-17 Thread Schoen Volker


You also can use materialized views (snapshots), which can be populated
every night.

regards

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



-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Gesendet: Donnerstag, 17. Januar 2002 14:51
An: Multiple recipients of list ORACLE-L
Betreff: RE: Database Views


Hello Srini

We had a case like this where one of the tables was in a database that
reside in a remote site. Our solution was to create a table that combine
employees tables from 2 site into one TABLE in the local site.

This way the select and join is done ONCE at night.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wed, January 16, 2002 10:05 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Database Views
> 
> I would like get your opinion on what would be the best way provide 
> access to data across multiple databases on just on Node (database).
> 
> One way that I have tried is create a view on one database that reads 
> tables across remaining four databases using Dblinks.  Let us say 
> there is a table
> called CUSTOMER that resides on five databases, in order to make it easier
> to generate reports, a combined view can be created with dblinks on these
> tables using UNION ALL on one database.  
> 
> Only concern I have is that when using Dblinks, Oracle might copy the 
> entire remote table to the local database and then retrieve the data 
> based on where
> clause.  This might be a significant performance issue especially if the
> tables are very BIG.  
> 
> If there are better ways to accomplish this or any ideas on this one 
> will be greatly appreciated.
> 
> Thank you,
> Srini
> 
> --
> 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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Standby Instance questions and HA

2002-01-17 Thread Allen R. Lucas



What you are describing sounds like Oracle FailSafe.  It is free from
Oracle, does not require Oracle Enterprise version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.

As for Sun Solaris, I know nothing so will be of no help to you there.




   
  
"James McCann" 
  
  
lecom.com>  cc:
  
Sent by:Subject: Standby Instance questions 
and HA   
[EMAIL PROTECTED]   
  
   
  
   
  
01/17/2002 06:40   
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hi,
  I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby
Instances.

Note, this is not a standby database.

>From the book it seams to work in the following way...

There is only one database.
The database files exist on a shared disk pack. One machine is the primary
instance, and if this instance dies, a new instance is started on the
second
machine using the datafiles on the shared disk.

The problem is that I can't find anything in the Oracle docs about this, or
on Meta Link.

I also want to know if this method of HA requires a clustered environment
(I
think it does, but just want to be sure)?

Also, does it come with an Enterprise Edition license?
Or is it something which each hardware vendor implements in their own way,
at extra cost?

We have a requirement for a fail over method on Sun Solaris.
We do not want to loose any committed data (i.e. a standby database could
loose some), and want the fail over to be as automatic as possible.

We don't want the expense of Parallel Server (Anyone know how expensive it
is these days?).

The disk pack is RAID, and we may also have a standby database off site.

Has anyone any recommendations?


Thanks,

Jim




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

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

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




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

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

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

2002-01-17 Thread Brian Wisniewski


We must have been lucky because BMC support really saved our butt a few
months back when we got a copy of LOGMASTER to recover some data from
some archived redo logs (long story).

We were really impressed with their support and everyone within our
group commented on how helpful and knowledgeable they were and how we
wished Oracle support was the same.

Never called for support on the SQL*Backtrack product but we have it
and love it.

Maybe it was a fluke that we got good support from BMC but I expect so
little from corporations technical support staff that I was really
blown away with theirs on that occasion.  Oracle support has made me a
very jaded person. ;-)

- Brian


--- [EMAIL PROTECTED] wrote:
> 
> Ok, you guys are really missing the support issue.  :)
> 
> The support is very bad.  Yes, you don't need it often.
> 
> But when you do need it, they don't have it.
> 
> SQL*Backtrack is normally run as a menu to the
> back end tools.  As I recall, even most of the commands
> used in cron for scheduled backups are wrappers to
> the back end tools.
> 
> There are recovery situations that cannot be peformed from
> the SQL*Backtrack menu.  If you run into one of those, and
> cannot figure it out, support will be unable to help you.
> 
> They know how to use the menu mode, and that's about it.
> 
> Just after leaving a previous job where SQL*Backslack is
> still in use,  a tablespace in the data warehouse was trashed.
> 
> It took 30+ days to recover it.  This is mostly due to inept support
> from BMC.  They like to do a lot of finger pointing, such as
> 'Your Legato indexes need rebuilt', even though that does
> not fix the problem.
> 
> It used to be a great tool, and probably still is.  I would not but
> it based simply on support issues.
> 
> Jared
> 
> 
> 
> 
>  
>   
> "Smith, Ron  
>   
> L."  To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]   cc: 
>   
> om>  Subject: RE: OT -: SQL
> BackTrack info  
> Sent by: 
>   
> [EMAIL PROTECTED]   
>   
> om   
>   
>  
>   
>  
>   
> 01/16/02 11:13   
>   
> AM   
>   
> Please respond   
>   
> to ORACLE-L  
>   
>  
>   
>  
>   
> 
> 
> 
> 
> We have been using it for about 5 years on both Unix and NT.  We have
> it
> connected to Netbackup to handle the tapes.  We love it.  I agree
> that the
> support is not what it used to be but we hardly ever need support.
> Although, the last time we called we got a support person that knew
> more
> about Oracle than
> we did and knew SQL Backtrack inside and out.  It's a great tool!
> 
> Ron Smith
> Kerr-McGee Corp
> 
> -Original Message-
> Sent: Wednesday, January 16, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I am looking for some guidance from people who use this product. Is
> it a
> value add to the organization or not. If possible also let me know
> how in
> the hell does it do a online object extraction from the backup.
> 
> Would appreciate all your comments and recommendations
> 
> Thx
> Gautam
> 
> --
> 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-Mai

Re: index hint

2002-01-17 Thread Igor Neyman


Try to use table alias in your hint instead of table name.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 8:45 AM


>
>
> > -Oorspronkelijk bericht-
> > Van: Jeroen van Sluisdam
> > Verzonden: donderdag 17 januari 2002 14:40
> > Aan: '[EMAIL PROTECTED]'
> > Onderwerp: index hint
> >
> > Hi,
> >
> > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working
> > again
> > on same performance after an index has been added in order to get around
> > possible
> > deadlocks because of use of a foreign key relation.
> > I tried adding an hint but this doesn't work, am I making typos?
> > DB is on choose optimizer
> >
> > delete from plan_table;
> > explain plan
> > set statement_id = 'test' for
> > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */
> > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime ,
> > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full
,
> > oa.option_type
> > FROM
> > bedfinder_published_objects bo,
> > option_allotments oa
> > WHERE
> > bo.contract_id = oa.contract_id
> > AND
> > bo.so_id = oa.so_id
> > AND
> >datetime >= trunc(sysdate)
> > ORDER BY 2,3,4,5
> >
> > Tia,
> >
> > Jeroen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeroen van Sluisdam
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: RMAN backup and restore Q?

2002-01-17 Thread nlzanen1



Hi


My problem went away when I did a startup mount of the database.

I have Rman user in TEST2 just for testing purposes (same username password
on target & catalog is easier with ctrl C & ctrl V)

One more question if I may.

Do you or anybody else have an example of  a very complex rman command(most
of the features used) and an example of cloning a database on the same host
with renaming of the log& datafiles? Documentation explains a lot but is
very limited in the examples and the syntax errors are easy to make.


TIA

Jack





"Jay Hostetter" <[EMAIL PROTECTED]>@fatcity.com on 16-01-2002
14:10:24

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

What version of the database are you using?  My info here is based on
8.1.7.

I connect to my databases as internal to do the backups.  I fire up RMAN
with either one of these commands:

rman target / catalog rman/rman@test1  (SID must be set correctly)
rman target internal/pwd@test2  catalog rman/rman@test1

I'm not sure why you have an rman user in test2, unless you set up a second
catalog so that you can backup your first catalog.

To test your restore, shutdown test2 and delete all the .dbf, .log, .arc,
and .ctl files.  Then startup nomount the test2 database.  Then try this:

rman target internal/pwd@test2 catalog rman/rman@test
run {
allocate channel ch1 type disk;
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}

If you did a hot backup, you may need your archivelog backups.  This
command backs up the archivelogs:

run
{
allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1 Gb.
backup archivelog until time 'sysdate-1/24' delete input;
backup archivelog from time 'sysdate-1/24';
}



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

>>> [EMAIL PROTECTED] 01/16/02 07:25AM >>>

Hi All,


I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database

I have created the catalogs and registered the database with the catalog.

I than mad a full backup of the database TEST2 (is in Archivelog mode)
with the following syntax
**BACKUP
rman

RE: Raw I/O