date:20011203


Dennis,

And even if there is a problem with the Rman trying to use a link, pointing
to another directory, you can always create a new mount point /ora01 on the
box provided to you, right?  I think what you are trying to do is very
feasible and covered within the Oracle docs.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, November 30, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L


 I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
 SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN 
 will be fine with that?

I vaguely recall that prior versions of the docs did not support this but
now I see no such non-support warning from Oracle (in the 817 docs) so
symbolic links should be fine as long as you ensure that they resolve to
the same name as occurs in the control files. Quoting page 10-123 of the
manual:

If datafile filenames are symbolic links, that is, files that point to
other files, then the control file contains the filenames of the link files
but RMAN performs I/O on the datafiles pointed to by the link files. If a
link file is lost and you restore a datafile without first re-creating the
symbolic link, however, then RMAN restores the datafile to the location of
the link file rather than to the location pointed to by the link.

Of course you should test this... and let us know how it turns out. :-)

If you have trouble with the symbolic links then you can always fall back to
the Oracle sanctioned method Tom pointed out. It's in the section titled,
Moving the Target Database to a New Host with a Different File System,
page 6-7. I did this using control files (nocatalog) and it worked just
fine.

For comfort factor, I'd recommend that you create the smallest test database
you can and prove the 11 steps in this section by restoring your small test
DB to another machine. Besides, it's a fun thing to do. :-)

Steve Orr
Bozeman, MT


P.S. 
Speaking of backups, I got my OOW badge and I'm leaving Walt here to hold
down the fort. Between the two of us we've somehow fooled damagement into
thinking that they really need us... but the down side is that we can't both
be out of town at the same time. So when Walt goes to IOUG I have to stay
here as his backup. If you have any more questions about RMAN for the next
week feel free to pummel Walt. Along with other folks on this list, he's one
of the gurus listed in the Acknowledgments of the new Oracle RMAN Pocket
Reference from O'Reilly. :-) 



-Original Message-
Sent: Friday, November 30, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L

Thanks for the input, Cherie, Kimberly, Tom

The part I'm still uncertain is as follows - see the sentence in caps below:
On my current system let's say I have RMAN write its backup file to
a disk location /ora01. I also have my RMAN catalog on a separate server,
and have written an export to my backup tape also.
After my disaster, my hardware vendor offers me the use of a
comparable system at a different location. I grab my backup tape and get in
the car. And if it is a real disaster, maybe it is the older backup out of
the off-site vault.
Let's assume that Oracle is already installed on this new system
just to move the story along as Hollywood would say.
I load my RMAN catalog.
I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be
fine with that?
I fire up RMAN and start the recovery process. Using the syntax Tom
provided, I should be able to account for any other device naming or path
naming problems.

Kimberly - we aren't quite talking about the need for a standby database.
This manager's point, and I feel it is a good one, is that if you have been
making backups and storing them off-site, you should be able to mount those
backups on a new machine and get your system back. Eventually. Given a lot
of time. If something catastrophic happens and you say that because the
company didn't spend the big bucks for a duplicate remote data center with a
standby database, the recovery will take a week, that would be survivable.
But if you say that because you switched to this really keen backup method
there is just no way to ever get the data back, well you better make sure
your resume was off-site as well. 
Naturally before we quit making weekly cold backups we are going to
have to actually test this scenario. I assume that the same applies to your
sites also.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, November 30, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L

Also, if that is the type of recovery he wants then sell him on
a standby database.  If you lose your server that severely you
will only be able to get back to the last backup regardless of
where your recovery catalog is (hopefully on another server or
at least

RE: UTL_FILE_DIR problem

2001-12-03 Thread Ball, Terry


It seems to me, I remember something like this.  If I do remember correctly,
you need the execute permissions for the directory, so it would need to be
775.

Terry

-Original Message-
Sent: Monday, December 03, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message saying that I can't write to the directory.
the /customer/ShopA directory permission is  set to 664.
Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as
another user ?
If I'm not wrong, the program will try to write into the directory using
oracle unix account.
Note : I don't want to set the write permission to other group.
I have tried to include oracle in A1 group using secondary group, but it
couldn't work.

Can somebody tell me how to let oracle write into the directory and the file
as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks  Regards
Herman









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

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

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

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

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

RE: UTL_FILE_DIR problem

2001-12-03 Thread Thomas, Kevin


if I set UTL_FILE_DIR = *
would there be any security issue ?

In a word yes...this allows read/write access to *all* directories and there
is bound to be particular ones you don't want people to see.



-Original Message-
Sent: 03 December 2001 11:40
To: Multiple recipients of list ORACLE-L


Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message saying that I can't write to the directory.
the /customer/ShopA directory permission is  set to 664.
Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as
another user ?
If I'm not wrong, the program will try to write into the directory using
oracle unix account.
Note : I don't want to set the write permission to other group.
I have tried to include oracle in A1 group using secondary group, but it
couldn't work.

Can somebody tell me how to let oracle write into the directory and the file
as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks  Regards
Herman









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

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

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

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

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

RE: Doubts reg :Export and import

2001-12-03 Thread SARKAR, Samir


Mark,

The COMPRESS=Y option is basically used to combine multiple extents into a 
single large extent while importing...it is useful when u r trying to 
defragment the segment.
If u export 5 extents of 100MB using this option, it will b imported 
as one single extent of 500 MB which means that the initial extent of
the storage clause of the extent will b changed to 500M.
There is a flipside to this. If u have a large table, and the size of the 
table is greater than the largest block of free space in ur database, then
u wont b able to import it back as one single extent and ur import will fail
since extents cannot span datafiles.

Hope this helps.

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 03 December 2001 10:50
To: Multiple recipients of list ORACLE-L


OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..

When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to 5
extents of 100Mb - or one of 500Mb?

My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)

Cheers

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L


If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:

 Another one that apparently has access to e-mail but not to the
internet to
 RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
 read e-mails but cannot read FM etc.

 Alex Hillman

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
  Sent: Wednesday, November 28, 2001 12:16 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Doubts reg :Export and import
 
 
  hi list,
 
  what is the exact use of mentioning 'compress' yes
  or no while exportingwill this store the .dmp file
  in compressed format in system,if given 'yes'.
 
  while importing the dumpfile why is it necessary to
  give 'fromuser',is 'touser' not enough.
 
  sangeetha
 
  __
  Do You Yahoo!?
  Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
  http://geocities.yahoo.com/ps/info1
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: sangeetha
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be 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: Alex Hillman
   INET: [EMAIL PROTECTED]

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

--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
  INET: [EMAIL PROTECTED]

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

RE: Deleting files on w2k

Title: RE: Deleting files on w2k





Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there... I'm stuck with this one. 

-Original Message-
From: Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting files on w2k


Um, port it to Unix


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Friday, November 30, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Deleting files on w2k




I'm trying to test out backup and recovery on w2k.  However, I can't remove or rename a file while the database is running!  It says file in use.  

Am I missing something or is there a way to force this?  


Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

RE: Deleting files on w2k

2001-12-03 Thread Kimberly Smith

Title: RE: Deleting files on w2k



Go 
with Linux. That way you could use your same servers:-) Ain't I so 
useful! HA

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Monday, December 03, 2001 6:20 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Deleting files on w2k
  Believe me, I wish... if we could get a 
  bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be 
  there... I'm stuck with this one. 
  
-Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting files on w2k 
Um, port it to Unix 

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, 
  LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple 
  recipients of list ORACLE-LSubject: Deleting files on 
  w2k
  I'm trying to test out backup and recovery on 
  w2k. However, I can't remove or rename a file while the database is 
  running! It says "file in use". 
  Am I missing something or is there a way to force 
  this? 
  Thanks 
  Lisa KoivuOracle Database MonkeyFairfield Resorts, 
  Inc.954-935-4117

RE: Deleting files on w2k

2001-12-03 Thread Adrian Roe

Title: RE: Deleting files on w2k

Unlike
UNIX, NT will not let you delete a file while another process (ie.
Oracle)has got a hold on it. I assume Win2K is the
same.

-Original Message-From: Koivu,
Lisa [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001
14:20To: Multiple recipients of list ORACLE-LSubject: RE:
Deleting files on w2k

Believe me, I wish... if we could get a
bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be
there... I'm stuck with this one.

-Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting files on w2k
Um, port it to Unix

-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu,
LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple
recipients of list ORACLE-LSubject: Deleting files on
w2k
I'm trying to test out backup and recovery on
w2k. However, I can't remove or rename a file while the database is
running! It says "file in use".
Am I missing something or is there a way to force
this?
Thanks
Lisa KoivuOracle Database MonkeyFairfield Resorts,
Inc.954-935-4117

--
Live Life in Broadband
www.telewest.co.uk

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

RE: UTL_FILE_DIR problem

2001-12-03 Thread Connor McDonald


In particular,

declare
  f utl_file.file_type;
begin
for i in ( select name from v$datafile
 order by file# desc ) loop
   f := utl_file.fopen(
 substr(i.name,1,instr(i.name,'/',-1)),
 substr(i.name,instr(i.name,'/',-1)+1),
 'W');
  utl_file.fclose(f);
end loop;
end;
/

which (pending fixing any compile errors) will do its
best to reduce all datafiles in the database to 0
bytes finishing with SYSTEM.

Cheers
Connor


 --- Thomas, Kevin [EMAIL PROTECTED]
wrote:  if I set UTL_FILE_DIR = *
 would there be any security issue ?
 
 In a word yes...this allows read/write access to
 *all* directories and there
 is bound to be particular ones you don't want people
 to see.
 
 
 
 -Original Message-
 Sent: 03 December 2001 11:40
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 
 I got one problem about UTL_FILE_DIR.
 My oracle version is 8i 8.1.6
 Platform is unix sun solaris.
 
 I have set UTL_FILE_DIR to : /customer/ShopA
 and I write PL/SQL code to write a log file (A.txt
 )into /customer/ShopA
 When I execute the PL/SQL job through SQLPLUS,
 I hit error message saying that I can't write to the
 directory.
 the /customer/ShopA directory permission is  set to
 664.
 Let's say owner is A, and the group is A1
 
 Can I tell the program to access the directory and
 write to the file as
 another user ?
 If I'm not wrong, the program will try to write into
 the directory using
 oracle unix account.
 Note : I don't want to set the write permission to
 other group.
 I have tried to include oracle in A1 group using
 secondary group, but it
 couldn't work.
 
 Can somebody tell me how to let oracle write into
 the directory and the file
 as well without
 changing the directory / file permission.
 
 if I set UTL_FILE_DIR = *
 would there be any security issue ?
 
 Any help will be greatly appreciated.
 
 Thanks  Regards
 Herman
 
 
 
 
 
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Herman Susantio
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

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

Some days you're the pigeon, some days you're the statue


Nokia 5510 looks weird sounds great. 
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! 
The competition ends 16 th of December 2001.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

Re: Buffer Busy Waits -- Sanity check please

Jared
Say, process A is interested in reading a block, then it hashes the data block address of the block to find the hash bucket in the buffer cache. If that specific block is in the buffer cache, then it must be attached with that hash bucket. Holding the hash bucket latch, the process A will look for the buffer in that hash chain with that data block address . If the buffer is found in the buffer cache, then that process has to examine the state of the buffer before proceeding further.
If another process B is operating on the buffer, i.e. reading a database block from the disk in to the buffer (for FTS or otherwise), then the process B will pin the buffer and the buffer is not available until the read is completed. So, the process A will wait for the buffer to be unpinned, posting 'buffer busy event'. Since this event can happen in various points in the buffer lifecycles, p3 indicates details about the wait itself.
Point being that, two processes can not operate on the same buffer simultaneously. Even though readers do not block readers in terms of locks, they could be blocked due to buffer unavailability, but this event is usually very brief.
As malcolm suggested, probably, the processes are chasing one another.

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

Jared Still [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/02/01 10:15 PM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Buffer Busy Waits -- Sanity check please

Interesting. Any idea of what the point is in preventing other processes
from reading a block in the buffer?

Jared

On Saturday 01 December 2001 20:10, MacGregor, Ian A. wrote:
The P3 value of 130 on the buffer busy waits does indicate that the block
is being read by another process as Malcolm stated that's the process doing
the scattered read (Full table scan). Oracle needs to protect the block
while it is being read. The others sessions are waiting until the read of
that block is complete.

For a definition of the P3 values see Steve Adam's website
http://www.ixora.com.au/

His full explanation of P3 id 130 is

1013 Block is being read by another session and no other
or 130 suitable block image was found, so we wait until the read
is completed. This may also occur after a buffer cache
assumed deadlock. The kernel can't get a buffer in a
certain amount of time and assumes a deadlock. Therefore it
will read the CR version of the block.

Ian MacGregor

-Original Message-
Sent: Saturday, December 01, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L

Malcolm,

The paragraph below would indicate that readers are blocking.

Readers don't block in Oracle. The only reason I can think of at
the moment for a SELECT to cause buffer busy waits is delayed
block cleanout, of which there has been a lot of discussion lately.

I could be all mixed up here I guess, it's Saturday and I dont' want
to think too hard about all this. Don't have time to break out the FM
so I'll just sit back and wait for you to agree or refute. ;)

Jared

On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote:
Jeff,

The 3 sessions are doing the same (or similar) queries. In this case
count(*) which is forcing a full table scan of the table in each session.
The 3 sessions are thus trying to access the same blocks from the SGA,
in the same order. Only 1 session can access a block in the SGA at a
time - this is the session showing 'db file scattered read'. The other 2
sessions need to wait for the block (these waits show as 'buffer busy
waits' - ie waiting for the block in the SGA). You will see the block id
(and perhaps the file id) changing as the FTS's progress. Thus the
sessions are 'chasing' each other through the blocks - holding each other
up with SGA block contention - which shows up as 'buffer busy waits'.
Hope that explains things.

Regards,

Malcolm

-Original Message-
Sent: Monday, November 26, 2001 11:21 PM
To: Multiple recipients of list ORACLE-L

We recently had a new website go live. Since then, I'm seeing constant
buffer busy waits
and after a period of time, I see sessions hung on the same block#.
The SQL query
is always a COUNT(*) (below). It's almost as though one session has a
lock

of some sort in the buffer cache and other sessions are blocked.
Although, I've checked and
there's no DML ongoing, so I'm unsure as to why we would see this. Note
that v$session shows
78 and 393 to be INACTIVE, while 159 is ACTIVE. So it's like 159 can't
write to
the buffer cache because 78 and 393 have a lock there. Note that these
are all defined
as persistent connections, via the Vignette front-end. I'm sure all the
clues are there
but my brain is too fuzzed to piece it together.

SID SQL_TEXT

DISK LAYOUT

2001-12-03 Thread Harvinder Singh

Title: RE: Deleting files on w2k



Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for 
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot 
disks).4 400MHZ cpu's
Expected database size is 250G..
1) Which raid level to use ...only for performance so may be no 
mirroring..
2) did i have to split hard disks on 2 sets for indexes and tables or single 
set of RAID 0 etc...
3) Where to place the log files , control files, oracle software , OS , 
tablespaces - System , Users(tables) , Temp, Indx (Indexes) , Rbs , 
Tools.

Thanks
-Harvinder

RE: UTL_FILE_DIR problem

2001-12-03 Thread Larry Elkins


Connor,

Can you please test your code before posting ;-)

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Connor
 McDonald
 Sent: Monday, December 03, 2001 9:00 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: UTL_FILE_DIR problem
 
 
 In particular,
 
 declare
   f utl_file.file_type;
 begin
 for i in ( select name from v$datafile
  order by file# desc ) loop
f := utl_file.fopen(
  substr(i.name,1,instr(i.name,'/',-1)),
  substr(i.name,instr(i.name,'/',-1)+1),
  'W');
   utl_file.fclose(f);
 end loop;
 end;
 /
 
 which (pending fixing any compile errors) will do its
 best to reduce all datafiles in the database to 0
 bytes finishing with SYSTEM.
 
 Cheers
 Connor

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

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

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

RE: Deleting files on w2k

Title: RE: Deleting files on w2k





You are! The problem is, by going with an os other than windoze of some sort, I am almost guaranteed that the production hardware and software support will be outsourced  moved to Denver, CO to IBM's datacenter there. This stupid company believes in paying ibm to do everything they are afraid to or can't do. I think I should go work for IBM. The dev servers I will still have. 

Ill have a linux server at home yet :)


-Original Message-
From: Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting files on w2k


Go with Linux.  That way you could use your same servers:-)  Ain't I so useful!  HA


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Monday, December 03, 2001 6:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting files on w2k




Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there...  I'm stuck with this one.  

-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 30, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Deleting files on w2k 


Um, port it to Unix 


-Original Message-
From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Friday, November 30, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Deleting files on w2k




I'm trying to test out backup and recovery on w2k.  However, I can't remove or rename a file while the database is running!  It says file in use.  

Am I missing something or is there a way to force this?  


Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

RE: Resume issues - (Not posting my resume)


Bambi,

Excellent one. Great. Printed it and filed in my personal file.

Rao

-Original Message-
Sent: Friday, November 30, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Dennis --

I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on nearly 24 years of experience to you folks in case you find
it of value.  If so, great, if not, oh well, but they were lessons learned
over the years and apply to all jobs, contract and perm.

If you have a boodle of experience, great.  Don't hide it.  But if your
resume is going to be over two pages, go ahead and add a page to the front.
The first page should be all the buzzwords that people are looking for,
broken up into categories:

Education
Hardware
Databases
Languages
Software
Security Clearances
Certifications
Publications
Major Industries That You Know Well (ie., not just database administration
but a good knowledge of a good segment of the industry itself)

That way, nobody has to fish on your resume for words like Oracle, Unix,
C++, PeopleSoft or Oil and Gas.  If HR people are looking through a pile
of resumes for those buzzwords, the faster you can get into the smaller pile
of people who have those skills, the better off you are.  If someone has to
wade through 4 pages just to see a skill they're looking for, you can pretty
much assume they're not going to take the time.  A-Number-One rule in
job-hunting is Make Your Resume Friendly to The People Making Small Piles of
Big Piles.  The person you're actually going to be working for won't get to
be impressed by all the cool stuff you've done if he/she never gets the
resume.

Work experience (if you've been an employee most of your professional
career) or project experience (if you've been a consultant most of your
professional career) should follow.  Write about the major things you've
done at your jobs/clients in paragraphs.  Use whole sentences.  Pretend that
you are as comfortable with the written word as you are with grep and awk.
Some people say bullet points with action verbs are the way to go; I don't
agree.  You have a small amount of space to demonstrate verbal and written
communication skills (which is a requirement for EVERY JOB), make the most
of it.

As for which jobs to list and which not to, my rule of thumb is that if
you've been at a particular job/client for more than 6 months, it should be
listed by name, you might want to modify that to suit your experience.
Regardless, if you've been doing a bunch of short-term projects, you can
clump them in together in a single paragraph that shows a particular chunk
of time with only your major clients listed by name in there.  If you have
minor clients (companies nobody's ever heard of) in that chunk of time,
don't bother listing them, even if you have no major clients in there.
There's no shame in saying small business or mid-size corporation rather
than Joe's Barbershop or Peppers Waterbeds.  When you have client with a
household name, their name should appear in the paragraph.

If you did vastly different things for different clients on a short-term
basis, it is still better to cluster them together than not to.  You'd
rather look like a stable person with a variety of skills than a huge
job-hopper who never stays anywhere very long (even if the latter is
substantially more true than the former).

One mistake to avoid:  if you've been at a client for 12 years, the
paragraph doesn't have to be long to prove it.  You may have a shorter
paragraph for a long job where your job function was clearly defined than a
much shorter job where you were a maverick/firefighter/janitor.

And if your resume has to be 5 pages, then it has to be 5 pages.  There's a
limit to how small you can make the type and how short you can make the
paragraphs.  You still need your resume to be your representative, and if
you've been in the field for a long time, you sometimes just can't be
represented by one page.  

Hope this helps...
Bambi.

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

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

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

Re: Has anyone heard of Mirror Accessible?

2001-12-03 Thread Ed


The Logical Standby Database is listed in Oracle 9i's New Features
documentation on Technet, but there is nothing about it in the actual Data
Guard manual that I have found. Maybe it is a 9.0.2 feature as someone else
already indicated.

Best,

Ed

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, December 01, 2001 9:35 PM


 AFAIK, 9iDataGuard in the current release is only a Physical Standby
 database
 (not logical standby database).  This is similar to 8i except for the
 fact that, if you
 ensure that you do a clean failover-and-failback (ie have the controlfiles
 and
 online redo log files available) you can actually switch to and from the
 standby.

 Never tried it and wouldn't try it till 9.0.2 (at the minimum)

 Hemant



 Miller, Jay [EMAIL PROTECTED]01/12/2001 05:45 AM
 Sent by: [EMAIL PROTECTED]

 Please respond to ORACLE-L

  To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
  Subject: RE: Has anyone heard of Mirror Accessible?








 Can anyone confirm this?  I've been searching technet and metalink and
 can't
 turn up any details.

 -Original Message-
 Sent: Friday, November 30, 2001 3:01 PM
 To: Multiple recipients of list ORACLE-L


 Isn't that just in release 2 though?  My understanding is that its not out
 yet.

 -Original Message-
 Sent: Friday, November 30, 2001 11:36 AM
 To: Multiple recipients of list ORACLE-L


 Ah, this sounds likely.  And it might explain why they were keen on having
 us upgrade to 9i.  That's the problem with receiving the request filtered
 through two additional levels of people.

 Jay Miller

 -Original Message-
 Sent: Friday, November 30, 2001 1:56 PM
 To: Multiple recipients of list ORACLE-L


 9i has a new feature on standby databases that let's you run reports in
 read
 only while continuing the managed recovery.  I think they call it a
logical
 standby database.  See the 9i DataGuard manual for more information.  (I
 just happened to be looking into this lately).  This might be what they
are
 talking about.

 Best,

 Ed

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, November 30, 2001 12:05 PM


  Only thing I can think of off the top of my head is a standby database
  opened in read only mode.  Its one of the purposes totted for that
 
  -Original Message-
  Sent: Friday, November 30, 2001 9:47 AM
  To: Multiple recipients of list ORACLE-L
 
 
  My CIO woes continue. My manager has been told by the CIO that Oracle
has
 a
  product called mirror accessible which allows the database to be
 mirrored
  for reporting purposes. He wants us to use this product.
 
  Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle
Standby
  and Oracle Replication but he says it isn't any of these. Any idea what
 he
  might be talking about?
 
  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).
  --
  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: Ed
   INET: [EMAIL PROTECTED]

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

rman restore arclogs

Title: rman restore  arclogs





Good morning all - 


I've been practicing rman restores. It's a lot easier than I originally thought. I've noticed that when you restore and the arclogs are needed, it restores them. Which is expected. However, when I take another backup, these arclogs are included in the backup set. This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery? I can verify what arclogs are where in the backup sets with a report. 

Any comments are appreciated. Thanks


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

RE: Determinants of control file


Hi
v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except maxlogmembers. Here is the query to pull the information..

select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs
where indx in (3,4,2,9)
/
DECODE(INDX,3   RSNUM
- --
MAXINSTANCES   8
MAXLOGFILES 32
MAXDATAFILES 1022
MAXLOGHISTORY907

which is matching with my controlfile dump.

CREATE CONTROLFILE REUSE DATABASE mydb NORESETLOGS ARCHIVELOG
  MAXLOGFILES 32
  MAXLOGMEMBERS 2
  MAXDATAFILES 1022
  MAXINSTANCES 8
  MAXLOGHISTORY 907

I am not sure where maxlogmembers is stored. I will do some more digging to find that..

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






Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/01/01 08:25 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Determinants of control file


No. i already checked the view v$control_record_section, 
This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc
Nirmal. 
-Original Message- 
t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] 
Sent:  Thursday, November 29, 2001 11:27 PM 
To:   Multiple recipients of list ORACLE-L 
oman">RE: Determinants of control file 
Other than dumping/ tracing the control file, you can find the required details in the 
dynamic view V$controlfile_record_section. This view has all the information you want 
  
  
Best Regards, 
K Gopalakrishnan 
  
  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane)
Sent: Thursday, November 29, 2001 3:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Determinants of control file 
  
Hi Nirmal, 
  
   Use 
  
alter database backup controlfile to trace; 
    
    You can find these details in the trace file, that will be dumped to your udump destination. 
  
HTH 
Srinivas. 
  
   
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 7:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Determinants of control file 
Hi all, 
The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., 
But after creation of control files, where should i get details about these parameter values?... 
i checked in v$controlfile and v$database... i didn't get enough info on it. 
And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
Where will i get the sequence# of other control files then... 
Nirmal,

RE: Determinants of control file


All right, Here is the complete query to get the information from the control file.

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
/

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






Riyaj Shamsudeen
12/03/01 09:46 AM


To:[EMAIL PROTECTED]
cc:
Subject:RE: Determinants of control fileLink

Hi
v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except maxlogmembers. Here is the query to pull the information..

select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs
where indx in (3,4,2,9)
/
DECODE(INDX,3   RSNUM
- --
MAXINSTANCES   8
MAXLOGFILES 32
MAXDATAFILES 1022
MAXLOGHISTORY907

which is matching with my controlfile dump.

CREATE CONTROLFILE REUSE DATABASE mydb NORESETLOGS ARCHIVELOG
  MAXLOGFILES 32
  MAXLOGMEMBERS 2
  MAXDATAFILES 1022
  MAXINSTANCES 8
  MAXLOGHISTORY 907

I am not sure where maxlogmembers is stored. I will do some more digging to find that..

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






Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/01/01 08:25 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Determinants of control file


No. i already checked the view v$control_record_section, 
This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc
Nirmal. 
-Original Message- 
t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] 
Sent:  Thursday, November 29, 2001 11:27 PM 
To:   Multiple recipients of list ORACLE-L 
oman">RE: Determinants of control file 
Other than dumping/ tracing the control file, you can find the required details in the 
dynamic view V$controlfile_record_section. This view has all the information you want 
  
  
Best Regards, 
K Gopalakrishnan 
  
  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane)
Sent: Thursday, November 29, 2001 3:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Determinants of control file 
  
Hi Nirmal, 
  
   Use 
  
alter database backup controlfile to trace; 
    
    You can find these details in the trace file, that will be dumped to your udump destination. 
  
HTH 
Srinivas. 
  
   
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 7:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Determinants of control file 
Hi all, 
The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., 
But after creation of control files, where should i get details about these parameter values?... 
i checked in v$controlfile and v$database... i didn't get enough info on it. 
And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
Where will i get the sequence# of other control files then... 
Nirmal,

Deleting Oracle8 on NT(cleaning Oracle8)

2001-12-03 Thread Raghu Kota



Hi Friends,

I need to clean Oracle8 database size 3Gb on one of my NT server, Is it 
possible that shutdown the database and delete all datafiles and all 
directories??? Or Is there any other way to clean all files and 
directories?? I appreciate all suggestions and responses.

Thanks in advance
Raghu.



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

OT- Service Level Agreements

2001-12-03 Thread Praveen Gautam


All:

Has anyone service level agreements with theirdDatabase users and would be willing to 
share some
information?  I am in the processing of creating SLA with my Oracle database users and 
am looking
for templates.

TIA

-- 
+===+
|  Praveen K. Gautam|
|  Tellabs, Inc.|
+===+
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen Gautam
  INET: [EMAIL PROTECTED]

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

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

RE: Possibly moving to Sun Equipment


Steve,

We have a three 420R boxes, two 450 boxes, three 6500's. Each of our 420R's
configuration is ---  4 cpu's - 450 MHZ, 4 GB RAM.  We are using 420R boxes
for our development.  We have Oracle 817, WebLogic 6.1 and some middle tier
software loaded onto these 420Rs.  

These 420R boxes come initially with one disk controller card.  If you want
to add additional disks, then, you would need to purchase additional
controller cards.

Now, regarding performance, we were trying to benchmark how many TPS 420R
could send via WebLogic.  I cannot post the exact TPS figures to the list as
the damagement might interpret as revealing confidential info.

But, my opinion is the number of TPS are very less or throughput is very
less compared to E6500's.

Rao

-Original Message-
Sent: Thursday, November 29, 2001 7:00 PM
To: Multiple recipients of list ORACLE-L


Well I have just returned from the Sun site, and checked out the two
systems.  The 420r is a rackmount server in the Enterprise Server series.
It uses Sparciii processors, up to 4 at 450mhz.  I don't' think I would
consider this configuration an upgrade.  I also doubt you'd classify this
one as a screamer.

The 880 is one of the Sunfire series of servers sporting a pair of 2 900mhz
64 bit UltraSparciii processors.  This one sounds much more exciting to me.

As I type this, I am informed that the powers that be are also looking at
some HP UX boxes.  Well either way we go I don't think it will be too
traumatic for me.  I am hoping for that Sun 880 now.



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

Steve - Is the 420R part of the new Sun Serengeti series? We had a test box
here and I recall the model number as being similar. If it is the same
thing, that box was a real screamer.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



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

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

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

SQL Loader Input File Situation

2001-12-03 Thread Ken Janusz


8.1.7

I am loading an input file to a single DB table.  The input file is
different than the table I'm loading and contains fields I don't need to
load.  I do not want to load some of the input fields.  The input file has
11 cols. and I need to ignore 5 of them.  The DB table has 15 cols and I
know how to ignore them with the filler clause.  The input file is a
delimited flat file.  How do I tell SQL*Loader not to load various input
fields?

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


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

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

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

Re: portable statistics

2001-12-03 Thread Ruth Gramolini


The database in question is cloned so I don't have to worry.  Thanks!  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 30, 2001 12:16 PM


 If you genuinely clone a database ie copy the
 datafiles, then the stats will also be transferred.
 Other than that, you would need dbms_stats which comes
 only at 8.1+.

 You could always hack the internal sys tables -
 probably not the wisest option to persue :-)

 Cheers
 Connor

  --- Ruth Gramolini [EMAIL PROTECTED]
 wrote:  Good morning again,
 
  I know that in 8i you can move statistics where you
  clone a database.  Is it
  possible in 8.0.6.3?
 
  Thanks!
  Ruth
 
  --
  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).

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

 Some days you're the pigeon, some days you're the statue

 __
 Do You Yahoo!?
 Everything you'll ever need on one web page from News and Sport to Email
and Music Charts
 http://uk.my.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   INET: [EMAIL PROTECTED]

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

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

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

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

RE:Deleting Oracle8 on NT(cleaning

2001-12-03 Thread BINAY . KUMAR


Can you please tell us which version of NT you are working on??
also throw some info about type of database, number of users (generally as
well as concurrently)??
if possible, give a brief description about the character of your SYSADMIN???

regards



***
Binay Kumar
Focus 3 -Technical Support
P  O Nedllyods Limited
London
+44 02 7441 1648
***



---

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

We reserve the right to monitor all e-mail communications through
our network.

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

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

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

function help ???

2001-12-03 Thread Andrea Oracle


Hi, Could any one show me how to write the following
function?  Thank you very, very much!  

The GPA Function

1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.

2.Repeat_delete Policy: A student may repeat a course
as many times as he
wants. However, if the first grade he receives on this
course is a D or F,
then the second grade will automatically replaces the
first grade, and the
first enrollment will not go into his GPA calculation.
Under any other
circumstances, his grades will be considered as a
regular grade and be
taken into consideration for GPA.

create table Enrollment(
Student# NUMBER (7),
SNUM NUMBER (5),
Call# NUMBER (7),
Semester char (8),
GRADE char (3),
Credit number,
Withdraw_Date Date);

SNUM + Call# represents one class.

 Insert into Enrollment
values('58001','111','70070','Sp2000','F',3, null);
Insert into Enrollment
values('58001','111','70070','Fa2000','B',3, null);
Insert into Enrollment
values('58003','222','70070','Sp2000','A',2, null);
Insert into Enrollment
values('58004','333','80025','Fa2000','A',2, null);
Insert into Enrollment
values('58005','222','80025','Fa2000','C',3, null);




__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

RE: SQL Loader Input File Situation

Title: RE: SQL Loader Input File Situation





Don't include them in your control file.


-Original Message-
From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL Loader Input File Situation


8.1.7


I am loading an input file to a single DB table. The input file is
different than the table I'm loading and contains fields I don't need to
load. I do not want to load some of the input fields. The input file has
11 cols. and I need to ignore 5 of them. The DB table has 15 cols and I
know how to ignore them with the filler clause. The input file is a
delimited flat file. How do I tell SQL*Loader not to load various input
fields?


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



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


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

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

RE: DISK LAYOUT

2001-12-03 Thread Mark Leith


Well I think it's time for you to start reading papers discussing OFA
(Optimal Flexible Architecture).

http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82846/a
ppa_ofa.htm

The above link is for the LINUX OFA document, but the concepts are the same,
and you will probably find one specific to your platform simply by searching
at http://otn.oracle.com

Regarding RAID - there is a good paper (already mentioned on the list
lately) by Gaja at www.quest.com

HTH

Mark

P.S. Actually, thinking about it - you already asked this? How about having
a read as people have already suggested? There is only a finite amount that
we can put in to an email (hey - we all have to work too!).

-Original Message-
Sent: 03 December 2001 15:15
To: Multiple recipients of list ORACLE-L


Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot
disks).4 400MHZ cpu's
Expected database size is 250G..
1) Which raid level to use ...only for performance so may be no
mirroring..
2) did i have to split hard disks on 2 sets for indexes and tables or single
set of RAID 0 etc...
3) Where to place the log files , control files, oracle software , OS ,
tablespaces - System , Users(tables) , Temp, Indx (Indexes) , Rbs , Tools.

Thanks
-Harvinder

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

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

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

RE: Buffer Busy Waits -- Sanity check please

2001-12-03 Thread Khedr, Waleed


Enabling parallel=2 or higher on this table could resolve the problem for
the original poster.

Regards,

Waleed

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



Malcolm,

The paragraph below would indicate that readers are blocking.

Readers don't block in Oracle.  The only reason I can think of at
the moment for a SELECT to cause buffer busy waits is delayed
block cleanout, of which there has been a lot of discussion lately.

I could be all mixed up here I guess,  it's Saturday and I dont' want
to think too hard about all this. Don't have time to break out the FM 
so I'll just sit back and wait for you to agree or refute.  ;)

Jared

On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote:
 Jeff,

 The 3 sessions are doing the same (or similar) queries.  In this case
 count(*) which is forcing a full table scan of the table in each session.
 The 3 sessions are thus trying to access the same blocks from the SGA,  in
 the same order.  Only 1 session can access a block in the SGA at a time -
 this is the session showing 'db file scattered read'. The other 2 sessions
 need to wait for the block (these waits show as 'buffer busy waits' - ie
 waiting for the block in the SGA).  You will see the block id (and perhaps
 the file id) changing as the FTS's progress.  Thus the sessions are
 'chasing' each other through the blocks - holding each other up with SGA
 block contention - which shows up as 'buffer busy waits'.  Hope that
 explains things.

 Regards,

 Malcolm

 -Original Message-
 Sent: Monday, November 26, 2001 11:21 PM
 To: Multiple recipients of list ORACLE-L



 We recently had a new website go live.   Since then, I'm seeing constant
 buffer busy waits
 and after a period of time, I see sessions hung on the same block#.The
 SQL query
 is always a COUNT(*) (below).   It's almost as though one session has a
 lock

 of some sort in the buffer cache and other sessions are blocked.  
 Although, I've checked and
 there's no DML ongoing, so I'm unsure as to why we would see this.   Note
 that v$session shows
 78 and 393 to be INACTIVE, while 159 is ACTIVE.So it's like 159 can't
 write to
 the buffer cache because 78 and 393 have a lock there.   Note that these
 are all defined
 as persistent connections, via the Vignette front-end.   I'm sure all the
 clues are there
 but my brain is too fuzzed to piece it together.

  SID SQL_TEXT O/S
 User
 - 
 ---
   159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT   FROM BBN.BBN_SRV
 vignette
   159 _PAID_WARR_CLAIM  WHERE CUSTOMER_ID = :b1  AND ENTERPRISE_CD = :
 vignette
   159 b2  AND (CHECK_ID IS NOT NULL   AND CHECK_ID != 'PENDING' )
 vignette

  SID EVENT   P1TEXT   P1 P2TEXT  P2 P3TEXT
 P3
 - --  -- --- -- -
 --
78 buffer busy waitsfile#  72 block#  109177  id
 130
   393 buffer busy waitsfile#  72 block#  109177  id
 130
   159 db file scattered read   file#  72 block#  109177
blocks
 8


 
 Jeffery D Thomas
 DBA
 Thomson Information Services
 Thomson multimedia Inc.

 Email: [EMAIL PROTECTED]
 DBA Quickplace: http://gkmqp.tce.com/tis_dba
http://gkmqp.tce.com/tis_dba

 



***
* E mail Disclaimer

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

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

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

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

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



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

Fat City Network Services-- (858)

Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Kevin Bass




I have 
just started a project and have encountered a database problem. The previous DBA 
did not create any backup scripts or backup and recovery plans. 
Is there a way to get around this problem without 
re-creating the database?


When 
executing my script to get corrupted data block information , I get the 
following:
ORA-01578: ORACLE data block corrupted (file # 1, block 
# 2660)ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf' 



Trace 
file information.

Dump 
file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trcOracle8 Release 
8.0.5.0.0 - ProductionPL/SQL Release 8.0.5.0.0 - ProductionORACLE_HOME = 
/u01/app/oracle/product/8.0.5System name: SunOSNode 
name: 
edi-01Release: 
5.7Version: 
Generic_106541-17Machine: 
sun4uInstance name: TIERedo thread mounted by this instance: 1Oracle 
process number: 12Unix process pid: 11859, image: 
oracleTIE

*** 
SESSION ID:(13.50289) 2001.11.30.15.00.00.000***Corrupt block relative 
dba: 0x0180af98 file=6. blocknum=44952.Bad header found during buffer 
readData in bad block - type:0. format:0. rdba:0x00090255last change 
scn:0x.3c07e0da seq:0x0 flg:0xb1consistancy value in tail 
0xcheck value in block header: 0x10, check value not 
calculatedspare1:0x0, spare2:0x0, spare2:0xd40Reread of rdba=180af98 
file=6. blocknum=44952. found same corupted data***
Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data***Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data***Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data*** 
Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data


Kevin

Re: killing system user


Hi Jared

why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...

Thx
Deepak
--- Jared Still [EMAIL PROTECTED] wrote:
 
 The session is rolling back, you can't kill it.
 
 This is why the serial# is changing.
 
 The following query can be used to track its
 progress.
 
 select s.osuser
   ,s.username
   ,s.sid
   ,r.segment_name
   ,t.space
   ,t.recursive
   ,t.noundo
   ,t.used_ublk
   ,t.used_urec
   ,t.log_io
   ,t.phy_io
   ,substr(sa.sql_text,1,200) txt
 from v$session s,
  v$transaction t,
  dba_rollback_segs r,
  v$sqlarea sa
 where s.taddr=t.addr
 and   t.xidusn=r.segment_id(+)
 and   s.sql_address=sa.address(+);
 
 Jared
 
 
 On Sunday 02 December 2001 22:55, Tatireddy,
 Shrinivas (MED, Keane) wrote:
  Hi lists,
 
  Solaris 2.7
  oracle 8i
 
  I have a session SYSTEM doing import into a
 table. (logged into server
  thru telnet from win 98 PC)
 
  Suddenly the power outage occurred to my PC.
 
  When I logged into the server thru telnet, I found
 that the session is
  active.
  By mistake, I killed the process at o/s level.
 
  For somereasons,I tried to drop the table. But I
 failed to do it, as it
  is locked by import process.
 
  I tried to kill the user SYSTEM. But the oracle
 is giving  error that
  there is not user with such sid and serial number.
 
  The serial# number is often getting changed when I
 query from v$session.
 
  Is there a way to kill this user, without shutting
 down the database.
 
  And why different serial# number each time, I
 query v$SESSION.?
 
  Any clues?
 
  Thnx and Regards,
 
  Srinivas
 -- 
 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).


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
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).

_delete_me=true


_delete_me=true

__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
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).

Oracle for Sun/64 Bit Question


All,

I have the install disks for 8.1.7 for Sun SPARC Solaris.  

Are these disks (2 of them) the same for Sun 64bit?

I looked on TechNet, and I do not see any other 817 release for Sun.

I do see, however, 64 bit for Oracle for 9i.

Thanks!

Tom Mercadante
Oracle Certified Professional

-- 
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: Deleting Oracle8 on NT(cleaning Oracle8)

2001-12-03 Thread Dwayne Cox


Raghu,

By shutting down the database and stopping the listener, you can delete all 
the data files and directories without a problem.  This will remove your 
database.

If you want to remove Oracle8 software, that will require purging the 
registry.  I don't think I have ever successfully removed ALL Oracle software 
from NT.

HTH

On Monday 03 December 2001 10:55 am, you wrote:
 Hi Friends,

 I need to clean Oracle8 database size 3Gb on one of my NT server, Is it
 possible that shutdown the database and delete all datafiles and all
 directories??? Or Is there any other way to clean all files and
 directories?? I appreciate all suggestions and responses.

 Thanks in advance
 Raghu.


-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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

HP-UX 11/8.1.7/Recovery

2001-12-03 Thread Vergara, Michael (TEM)


Hi All!

We had an interesting sequence of events last night, and I was 
hoping somebody could tell me if what we saw was what should've 
happened.  Clear?  As mud?  Ok...

System is up and running.
The backup process starts, and puts the datafiles in backup mode.
The system crashes.  Hard.  Memory fault.
When the database comes back up, it successfully performs media
recovery and pronounces itself OK.
We check, and the datafiles are NOT in backup mode.

So we're wondering...does media recovery take the datafiles out
of backup mode automatically?  Can you point me to a doco on this?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

2001-12-03 Thread Ruth Gramolini


Lisa,

We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs.  We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.

Have a look at rman's tables and views. You should be able to query them and
get what you want.

Yours in rman,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 03, 2001 10:30 AM


 Good morning all -

 I've been practicing rman restores.  It's a lot easier than I originally
 thought.  I've noticed that when you restore and the arclogs are needed,
it
 restores them.  Which is expected.  However, when I take another backup,
 these arclogs are included in the backup set.  This is unnecessary in my
 opinion and makes my backup files larger than they need to be.

 Is it standard practice to just delete the arclogs that were already in a
 backup set prior to taking the immediate backup after a recovery?  I can
 verify what arclogs are where in the backup sets with a report.

 Any comments are appreciated.  Thanks

 Lisa Koivu
 Oracle Database Monkey
 Fairfield Resorts, Inc.
 954-935-4117



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

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

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

Re: _delete_me=true

2001-12-03 Thread Jan Pruner


Does he think - UNSUBSCRIBE?

:-))
On Mon  3. December 2001 18:55, you wrote:
 _delete_me=true

 __
 Do You Yahoo!?
 Buy the perfect holiday gifts at Yahoo! Shopping.
 http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

Re: Deleting Oracle8 on NT(cleaning Oracle8)

2001-12-03 Thread Rodd Holman


Removing Oracle on NT (or any Windoze for that matter)
1. shutdown all oracle services (db, listener, etc.)
2. use the oracle installer and deinstall everything - this gets rid
   of a large portion of oracle
3. use regedit and remove the key HKEY_LOCAL_MACHINE\software\oracle
4. search the registry for oracle (delete every key related to
   the oracle install)
   do not delete keys related to Microsoft's Oracle ODBC (if
   installed it comes with VB) this is NOT an oracle product.
5. search the registry for ORANT (delete these keys)
6. SOUNDLY CURSE the ?genius? at M$ who came up with the idea
   for the registry.
7. search the registry for ORADAC - this is the oracle objects for ole
   data access controller (delete these keys)
8. delete the directories of oracle datafiles, software, installer
   (usually in Program Files), and in the Start Menu.
9. remove any references to oracle in the autoexec.bat
10. Since this is Windoze reboot the machine.

Now oracle is gone. ;)

Rodd Holman

On Mon, 2001-12-03 at 12:10, Dwayne Cox wrote:
Raghu,

By shutting down the database and stopping the listener, you can delete all 
the data files and directories without a problem.  This will remove your 
database.

If you want to remove Oracle8 software, that will require purging the 
registry.  I don't think I have ever successfully removed ALL Oracle software 
from NT.

HTH

On Monday 03 December 2001 10:55 am, you wrote:
 Hi Friends,

 I need to clean Oracle8 database size 3Gb on one of my NT server, Is it
 possible that shutdown the database and delete all datafiles and all
 directories??? Or Is there any other way to clean all files and
 directories?? I appreciate all suggestions and responses.

 Thanks in advance
 Raghu.


-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: Deleting Oracle8 on NT(cleaning Oracle8)


Raghu,

If you just want to delete one oracle database from an NT machine, do as you
suggest - delete all of the files (control, log, data), init.ora, and any
directories that held these files.  Then, be sure and run ORADIM -delete
{sid} to remove the instance from the registry.  That should do it.

If you wish to remove a version of Oracle software completely from an NT
machine, I sent a document over this list last week that outlines how to do
this.  Pretty simple and straoghtforward - it has always worked for me.  If
you want this doc, let me know and I will send it to you.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


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



Hi Friends,

I need to clean Oracle8 database size 3Gb on one of my NT server, Is it 
possible that shutdown the database and delete all datafiles and all 
directories??? Or Is there any other way to clean all files and 
directories?? I appreciate all suggestions and responses.

Thanks in advance
Raghu.



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

FIRST_ROWS vs. ALL_ROWS

2001-12-03 Thread Carle, William T (Bill), NLCIO


Howdy,

I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
determined the query was not using the indexes I thought it should. When I
changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
to minimize total execution time. I'm trying to figure out the difference.
Using FIRST_ROWS, this is the output from tkprof:

select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID =
rs.objid
and rownum  5 and ra.startdate is not null

call count   cpuelapsed   disk  query
currentrows
--- --   -- -- --
--  --
Parse1  0.00   0.01  0  0
0   0
Execute  1  0.00   0.00  0  0
0   0
Fetch2  0.00   0.00  0 35
0   4
--- --   -- -- --
--  --
total4  0.00   0.01  0 35
0   4

Misses in library cache during parse: 1
Optimizer goal: FIRST_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  4   NESTED LOOPS
  4NESTED LOOPS
  2 NESTED LOOPS
  1  TABLE ACCESS BY INDEX ROWID
ROUTINGASSIGNMENTPERSISTENT
  1   INDEX RANGE SCAN (object id 16976)
  2  TABLE ACCESS BY INDEX ROWID ROUTE
  2   INDEX RANGE SCAN (object id 16962)
  5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
  5  INDEX RANGE SCAN (object id 16971)
4   TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
7 INDEX UNIQUE SCAN (object id 16965)


Rows Execution Plan
---
---
  0  SELECT STATEMENT   GOAL: FIRST_ROWS
  4   COUNT (STOPKEY)
  4NESTED LOOPS
  4 NESTED LOOPS
  2  NESTED LOOPS
  1   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF

'ROUTINGASSIGNMENTPERSISTENT'
  1INDEX   GOAL: ANALYZED (RANGE
SCAN) OF

'IX_ROUTINGASSIGNMENTPERSIST5' (NON-UNIQUE)
  2   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
  'ROUTE'
  2INDEX   GOAL: ANALYZED (RANGE
SCAN) OF 'IX_ROUTE4'
   (NON-UNIQUE)
  5  TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
 'ROUTESEGMENTROUTE'
  5   INDEX   GOAL: ANALYZED (RANGE
SCAN) OF
  'IX_ROUTESEGMENTROUTE3'
(NON-UNIQUE)   
  4 TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
'ROUTESEGMENTPERSISTENT'
  7  INDEX   GOAL: ANALYZED (UNIQUE
SCAN) OF
 'IX_ROUTESEGMENTPERSISTENT'
(UNIQUE)

Using the ALL_ROWS mode, this is the tkprof
output from the same query:

select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
C' and

Message at the start of svrmgrl

2001-12-03 Thread Anand Prakash




I have just done installation of 8.1.7.0 on a Compaq 
Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. 
When I start svrmgrl I see a line "inst emulated pid=175364...".

--$ svrmgrlinst emulated pid=175364 svrmgrl 
va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights 
Reserved.

Oracle8i Enterprise Edition Release 8.1.7.2.0 - ProductionWith the 
Partitioning optionJServer Release 8.1.7.2.0 - Production

SVRMGR ^DServer Manager complete.


Any ideas?

Anand Prakash

Re: Corrupted data blocks in tablespace SYSTEM

Your error message indicates file #1 associated with the system tablespace and the trace file indicates the file #6. I would do the following
1. Check the OS error message for any hardware errors.
2. Find what objects are corrupted. To get this information use dba_extents and the given file and block#.Here is the script for the same:
---
accept h_file_id prompt ' Enter file_id =='
accept h_block_id prompt ' Enter block_id=='
set verify off
column owner format A10
column segment_name format A20
column segment_type format A10
column hdrfile format
column curfile format
column curblk format
column hdrblock format
select owner, segment_name, segment_type, file_id,block_id from dba_extents
where file_id = h_file_id and
block_id = h_block_id and
block_id + blocks h_block_id;
set verify on

3. Since the errors are in two different files, check whether these files are in the same disk or controller..
4. Decide the course of action depending upon the above outcome.. It is possible for the disk /controller to give back the bad data. If it is an hardware problem, correct the hardware problem and then try again.

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

Kevin Bass [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/03/01 11:50 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Corrupted data blocks in tablespace SYSTEM

I have just started a project and have encountered a database problem. The previous DBA did not create any backup scripts or backup and recovery plans. Is there a way to get around this problem without re-creating the database?

When executing my script to get corrupted data block information , I get the following:
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'

Trace file information.

Dump file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trc
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name: SunOS
Node name: edi-01
Release:5.7
Version:Generic_106541-17
Machine:sun4u
Instance name: TIE
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 11859, image: oracleTIE

*** SESSION ID:(13.50289) 2001.11.30.15.00.00.000
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data

Kevin

RE: rman restore arclogs

Title: rman restore & arclogs



Lisa,

I 
guess I'm lazy (or cautious) in that I would allow the first backup to take this 
archive log files back to tape where they belong, rather than determine (by 
running reports) which log files I may delete (by hand).

The 
cautious part of me says that if Rman decided to back these monkeys up within 
the first save set after the recovery, it may have decided that it needs them 
for a future recovery. If you did remove them by hand, Rman may complain 
that it was expecting them and did not find them. Did you try this - 
remove one that was restored by the recovery process and then tried a 
backup?

Depending on the kind of restore you do - a full, 
or a point in time - the archivelog may be of no use anyway (a point in time 
makes them invalid because you had to perform an "open db reset logs", while a 
full restore could still use these again).

Glad 
you are at least experimenting with the tool before you put it in production - 
it actually is fun to do a restore as it happens so 
infrequently!

Good 
Luck!
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  rman restore  arclogs
  Good morning all - 
  I've been practicing rman restores. It's a lot 
  easier than I originally thought. I've noticed that when you restore and 
  the arclogs are needed, it restores them. Which is expected. 
  However, when I take another backup, these arclogs are included in the backup 
  set. This is unnecessary in my opinion and makes my backup files larger 
  than they need to be. 
  Is it standard practice to just delete the arclogs that 
  were already in a backup set prior to taking the immediate backup after a 
  recovery? I can verify what arclogs are where in the backup sets with a 
  report. 
  Any comments are appreciated. Thanks 
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117

Re: FIRST_ROWS vs. ALL_ROWS

2001-12-03 Thread Stephane Faroult


Carle, William T (Bill), NLCIO wrote:
 
 Howdy,
 
 I have a query which was taking an extremely long time
 to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
 meaning it will use the ALL_ROWS method to determine its access paths. I
 determined the query was not using the indexes I thought it should. When I
 changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
 second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
 to minimize total execution time. I'm trying to figure out the difference.
 Using FIRST_ROWS, this is the output from tkprof:
 

Bill,

   very roughly, FIRST_ROWS favours nested loop over hash join and
ALL_ROWS does the reverse. Hash join is by far the most efficient when
you do a 'full join' on big tables. By 'full join', I mean that there is
no screening condition but the joind condition (or something which is
not very discriminant). However, a hash join means a first pass on the
smallest table to build a hash table, then a full scan on the second
table, hashing the key each time and checking the hash table. It can
take sometime before the first line pops up (actually, all the
preliminary work of building the hash table). A nested loop answers
faster. The factor which makes the difference in your case is 'rownum 
5' - if you say that hash join as a high fixed cost and a low marginal
one compared to nested loops, the rownum condition do not let you return
enough rows to make the gain on marginal cost counterbalance the loss on
fixed one.
-- 
HTH,

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

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

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

rman oddities

Title: rman oddities





Hi Ruth, thanks so much for responding. 


Yes, I wrote the scripts to do an arclog backup delete. I'm concerned about the arclogs hanging around after a restore and taking up disk space, along with unnecessarily inflating the size of my backup files. (I'm testing backup to disk right now)

It's more of a nice to know, not necessary. I'm seeing some weird stuff that I didn't expect and the monkey in me wants to know why... No, not the baby :) Here's some other odd behavior I've seen:

1. Instance failure during a backup leaves the rman files intact but the backup itself is not reflected in the catalog. The database recovers nicely from this since no tablespaces are in hotbackup mode (yes) The end result is orphan rman files that the catalog knows nothing about. 

2. Initially these files are created the size of all datafiles combined. As the backup progresses, the size of the files shrink down considerably. For example, I allocate 3 channels to disk and setsize to 2GB, but the files start out at 1.5GB and shrink down to ~500 MB. I wonder if that behavior happens on tape? Anyone? I'll be able to test this later this week. 

3. Can restore and recovery really be this easy? Sheesh


Thanks again for your response. And list, please correct me if I am wrong on any of this.


yours in Monkeying Around,
Lisa


-Original Message-
From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: rman restore  arclogs


Lisa,


We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs. We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.


Have a look at rman's tables and views. You should be able to query them and
get what you want.


Yours in rman,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 03, 2001 10:30 AM



 Good morning all -

 I've been practicing rman restores. It's a lot easier than I originally
 thought. I've noticed that when you restore and the arclogs are needed,
it
 restores them. Which is expected. However, when I take another backup,
 these arclogs are included in the backup set. This is unnecessary in my
 opinion and makes my backup files larger than they need to be.

 Is it standard practice to just delete the arclogs that were already in a
 backup set prior to taking the immediate backup after a recovery? I can
 verify what arclogs are where in the backup sets with a report.

 Any comments are appreciated. Thanks

 Lisa Koivu
 Oracle Database Monkey
 Fairfield Resorts, Inc.
 954-935-4117




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

FIRST_ROWS vs. ALL_ROWS

2001-12-03 Thread Carle, William T (Bill), NLCIO


Howdy,

I have a query which was taking an extremely long time to complete. The
OPTIMIZER_MODE in the init.ora file is set to CHOOSE, meaning it will use
the ALL_ROWS method to determine its access paths. I determined the query
was not using the indexes I thought it should. When I changed to use the
FIRST_ROWS optimizer_mode, the query ran in under a second. Now FIRST_ROWS
is used to minimize response time; ALL_ROWS is used to minimize total
execution time. I'm trying to figure out the difference. Using FIRST_ROWS,
this is the output from tkprof:

select ra.originatingclli, ra.terminatingclli, r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits, rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs where networktype
= 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID = rs.objid
and rownum  5 and ra.startdate is not null

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.00   0.01  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch2  0.00   0.00  0 35  0
4
--- --   -- -- -- --
--
total4  0.00   0.01  0 35  0
4

Misses in library cache during parse: 1
Optimizer goal: FIRST_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  4   NESTED LOOPS
  4NESTED LOOPS
  2 NESTED LOOPS
  1  TABLE ACCESS BY INDEX ROWID ROUTINGASSIGNMENTPERSISTENT
  1   INDEX RANGE SCAN (object id 16976)
  2  TABLE ACCESS BY INDEX ROWID ROUTE
  2   INDEX RANGE SCAN (object id 16962)
  5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
  5  INDEX RANGE SCAN (object id 16971)
4   TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
7 INDEX UNIQUE SCAN (object id 16965)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: FIRST_ROWS
  4   COUNT (STOPKEY)
  4NESTED LOOPS
  4 NESTED LOOPS
  2  NESTED LOOPS
  1   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
  'ROUTINGASSIGNMENTPERSISTENT'
  1INDEX   GOAL: ANALYZED (RANGE SCAN) OF
   'IX_ROUTINGASSIGNMENTPERSIST5'
(NON-UNIQUE)
  2   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
  'ROUTE'
  2INDEX   GOAL: ANALYZED (RANGE SCAN) OF
'IX_ROUTE4'
   (NON-UNIQUE)
  5  TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
 'ROUTESEGMENTROUTE'
  5   INDEX   GOAL: ANALYZED (RANGE SCAN) OF
  'IX_ROUTESEGMENTROUTE3' (NON-UNIQUE)   
  4 TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
'ROUTESEGMENTPERSISTENT'
  7  INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
 'IX_ROUTESEGMENTPERSISTENT' (UNIQUE)

Using the ALL_ROWS mode, this is the tkprof output from the
same query:

select ra.originatingclli, ra.terminatingclli, r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits, rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs where networktype
= 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID = rs.objid
and rownum  5 and ra.startdate is not null

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.02   0.01  0  0  0
0
Execute  2  0.05   0.06  0  0  5
0
Fetch2 40.91 471.49 197287 803265   3128
4
--- --   -- -- -- --
--
total5 40.98 471.56 197287 803265   3133
4

Misses in library cache during parse: 1
Optimizer goal: ALL_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  4

Re: Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Stephane Faroult


 Kevin Bass wrote:
 
 I have just started a project and have encountered a database problem.
 The previous DBA did not create any backup scripts or backup and
 recovery plans. Is there a way to get around this problem without
 re-creating the database?
 
 
 When executing my script to get corrupted data block information , I
 get the following:
 ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
 ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
 

Kevin,

   Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,

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

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

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

Re: Buffer Busy Waits -- Sanity check please




Thanks for the explanation.  I usually try to avoid delving
that deep into the internals, but I guess it's necessary on
occasion just to understand what's going on.

Jared



   
 
Riyaj_Shamsude 
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Re: Buffer Busy Waits -- Sanity 
check please  
om 
 
   
 
   
 
12/03/01 07:00 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Jared
Say, process A is interested in reading a block, then it hashes the
data block address of the block to find the hash bucket in the buffer
cache. If that specific block is in the buffer cache, then it must be
attached with that hash bucket. Holding the hash bucket latch, the process
A will look for the buffer in that hash chain with that data block address
. If the buffer is found in the buffer cache, then that process has to
examine the state of the buffer before proceeding further.
If another process B is operating on the buffer, i.e. reading a
database block from the disk in to the buffer (for FTS or otherwise), then
the process B will pin the buffer and the buffer is not available until the
read is completed. So, the process A will wait for the buffer to be
unpinned, posting 'buffer busy event'. Since this event can happen in
various points in the buffer lifecycles, p3 indicates details about the
wait itself.
Point being that, two processes can not  operate on the same buffer
simultaneously. Even though readers do not block readers in terms of locks,
they could be blocked due to buffer unavailability, but this event is
usually very brief.
As malcolm suggested, probably, the processes are chasing one
another.

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

   
   Jared Still 
   [EMAIL PROTECTED] To:Multiple recipients of list 
   Sent by: ORACLE-L [EMAIL PROTECTED]
   [EMAIL PROTECTED] cc:
Subject:Re: Buffer Busy Waits  
-- Sanity check please 
   12/02/01 10:15 PM   
   Please respond to   
   ORACLE-L
   






Interesting.  Any idea of what the point is in preventing other processes
from reading a block in the buffer?

Jared

On Saturday 01 December 2001 20:10, MacGregor, Ian A. wrote:
 The P3 value of 130 on the buffer busy waits does indicate that the block
 is being read by another process as Malcolm stated that's the process
doing
 the scattered read (Full table scan).  Oracle needs to protect the block
 while it is being read.   The others sessions are waiting until the read
of
 that block is complete.

 For a definition of the P3 values see Steve Adam's website
 http://www.ixora.com.au/

 His full explanation of P3 id 130 is


1013Block is being read by another session and no other
  or 130suitable block image was found, so we wait until the read
is completed. This may also occur after a buffer cache
assumed deadlock. The kernel can't get a buffer in a
certain amount of time and assumes a deadlock. Therefore

RE: Message at the start of svrmgrl

2001-12-03 Thread Hand, Michael T




Anand,

I installed the same(? 
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this 
result. However, I do remember this kind of result with a earlier upgrade 
to 8.0.x in the distant past. I believe it is a verbose linking option 
with no negative impact. Is svrmgrl the only executable responding like 
this. If so, try relinking.

Mike Hand
Polaroid 
Corp.

  -Original Message-
  
  I have just done installation of 8.1.7.0 
  on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no 
  installation errors. When I start svrmgrl I see a line "inst emulated 
  pid=175364...".
  
  --$ svrmgrlinst emulated pid=175364 
  svrmgrl va=0x11fffa358 pc=0x1205c0148 
  inst=0x327e0028
  
  Oracle Server Manager Release 3.1.7.0.0 - 
  Production
  
  Copyright (c) 1997, 1999, Oracle Corporation. All 
  Rights Reserved.

RE: FIRST_ROWS vs. ALL_ROWS

2001-12-03 Thread Larry Elkins


Bill,

Besides statistics and how they are gathered, and other information, there
are numerous parameters that influence the CBO and it's decisions. And just
to clarify, you said the query ran in under a second when using FIRST_ROWS
(and thus a nested loops indexed lookup approach if possible). And you had a
rownum  5 in there so I don't doubt it. Would you normally have that
stopkey in there?

The reason I ask is that when a nested loops approach is used (and you
aren't ordering on non-indexed columns, aggregating, etc) you can start
returning rows immediately before the query completes. Hence the
FIRST_ROWS hint favoring the execution plan you see -- you get the first
rows quickly. When join choices such as merge or hash are used, all the data
must be accessed before rows start returning. Depending upon the selectivity
of your data, and if you aren't normally using the rownum  5, total
throughput might be better with the ALL_ROWS method. It's hard to say
without knowing your data. But, I just wanted to make sure that you aren't
falling into a trap by immediately seeing results when using the FIRST_ROWS
approach.

For an exaggerated example, assume I am joining two 100,000 row tables with
no constraining criteria other than the join between them. If I use
first_rows, thus a very good chance of an indexed nested loops approach, I
will start seeing results immediately. But in reality since I want every row
in each table, I would be better off (in a report for example) with full
table scans and hash joins. The mistake that one can make is to think the
first rows approach is faster since they immediately see results. When in
reality, for this example, it would take the query much longer to complete
than if the FTS and HJ approach was used.

Or, maybe this is just one of those cases where the CBO is making a bad
choice, and even without the rownum5, a nested loops approach is still the
preferred method. It wouldn't be the first time the CBO made a bad choice.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle,
 William T (Bill), NLCIO
 Sent: Monday, December 03, 2001 12:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: FIRST_ROWS vs. ALL_ROWS


   Howdy,

   I have a query which was taking an extremely long time
 to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
 meaning it will use the ALL_ROWS method to determine its access paths. I
 determined the query was not using the indexes I thought it should. When I
 changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
 second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
 to minimize total execution time. I'm trying to figure out the difference.
 Using FIRST_ROWS, this is the output from tkprof:

   select ra.originatingclli, ra.terminatingclli,
 r.originatingclli,
   r.terminatingclli, r.deletedigits, r.prefixdigits,
 rs.originatingclli,
   rs.terminatingclli from routingassignmentpersistent ra,
   route r, routesegmentroute rs1, routesegmentpersistent rs
 where networktype = 'A
   C' and networksubtype
   = 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
   r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID =
 rs.objid
   and rownum  5 and ra.startdate is not null

   call count   cpuelapsed   disk  query
 currentrows
   --- --   -- -- --
 --  --
   Parse1  0.00   0.01  0  0
 0   0
   Execute  1  0.00   0.00  0  0
 0   0
   Fetch2  0.00   0.00  0 35
 0   4
   --- --   -- -- --
 --  --
   total4  0.00   0.01  0 35
 0   4

   Misses in library cache during parse: 1
   Optimizer goal: FIRST_ROWS
   Parsing user id: 29  (NTOPBIG)

   Rows Row Source Operation
   ---  ---
 4  COUNT STOPKEY
 4   NESTED LOOPS
 4NESTED LOOPS
 2 NESTED LOOPS
 1  TABLE ACCESS BY INDEX ROWID
 ROUTINGASSIGNMENTPERSISTENT
 1   INDEX RANGE SCAN (object id 16976)
 2  TABLE ACCESS BY INDEX ROWID ROUTE
 2   INDEX RANGE SCAN (object id 16962)
 5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
 5  INDEX RANGE SCAN (object id 16971)
 4 TABLE ACCESS BY INDEX ROWID

RE: _delete_me=true

2001-12-03 Thread April Wells


NO, no no... it is Holy Unsubscribe Batman!



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


Gee, how do I unsubscribe?  Oh-yeah!  Its at the bottom of every piece of
mail!!!  
Holy Cow BatMan!

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


-Original Message-
Sent: Monday, December 03, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Does he think - UNSUBSCRIBE?

:-))
On Mon  3. December 2001 18:55, you wrote:
 _delete_me=true

 __
 Do You Yahoo!?
 Buy the perfect holiday gifts at Yahoo! Shopping.
 http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Title: RE: rman restore  arclogs





Thanks Tom. I did try removing the arclogs and then running a backup - no complaints. The arclogs in question were still present in the catalog via past backups. I'm guessing this is because the last scn of the last backup was larger than the scn's included in the arclogs in question. 

However, a crosscheck report caused failure for all those logs. Not a big deal, but once this all goes into production I want to see all my reports  lists sent to me every day with no FAILURE or anything of that nature in it. Erring conservative is probably better anyway, unless i'm really tight on disk. 

Restoring is kinda fun :) I take that back, being a dba is kinda fun. Once I actually got to start doing it, that is. 



-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman restore  arclogs


Lisa,
 
I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand).

 
The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery.  If you did remove them by hand, Rman may complain that it was expecting them and did not find them.  Did you try this - remove one that was restored by the recovery process and then tried a backup?

 
Depending on the kind of restore you do  - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an open db reset logs, while a full restore could still use these again).

 
Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently!

 
Good Luck!


Tom Mercadante
Oracle Certified Professional 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject: rman restore  arclogs




Good morning all - 


I've been practicing rman restores.  It's a lot easier than I originally thought.  I've noticed that when you restore and the arclogs are needed, it restores them.  Which is expected.  However, when I take another backup, these arclogs are included in the backup set.  This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery?  I can verify what arclogs are where in the backup sets with a report.  

Any comments are appreciated.  Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

Quick Question on hotbackup

2001-12-03 Thread Seema Singh


Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to 
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and passwd file
-All archive log files
Is any things missing in this list?
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: DISPLAY under AIX 4.3.3, was Fwd: urgent!!




1. ping fbsrv to make sure the host can be found

2. it should be 'export DISPLAY', not 'export $DISPLAY'

3. make sure that an X server is running on fbsrv

how to test this varies from system to system.  If you
log on to the box in a graphical environment, then
X is running.

HTH

Jared





   
 
Jonathan   
 
Gennick  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
jonathan@genn   cc:   
 
ick.com Subject: DISPLAY under AIX 4.3.3, was 
Fwd: urgent!!
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/01/01 08:20 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Normally I don't forward reader emails that I receive, but
in this case the problem seems to be urgent. Is there anyone
using AIX on this list that might have a solution for Alex

--
Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

Saturday, December 01, 2001, 12:16:24 AM, [EMAIL PROTECTED] wrote:
Sir,

We are installing Oracle 8i under AIX 4.3.3 but we encounter DISPLAY
variable error.
It read something like 'Can't connect to fbsrv server as the value of
DISPLAY variable. We followed the Oracle manual
by defining DISPLAY=fbsrv:0.0 and enter the command export $DISPLAY. We
also tried xhost +fbsrv command, but still we encountered the same error.

What shall we do? We need your help.

Thanks,

Alex Almendras

Energy Development Corp. - Philippines.

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

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

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

2001-12-03 Thread HAWKINS, JAMES W [IT/1000]

Title: rman restore & arclogs



I just 
wanted to throw something else out there - it may have already come up 
though. We backup the archivelogs first without deleting them, and then 
immediately backup another set with the "delete" specified. Obviously, 
this is because anything can happen to that first set (corruptions, etc.), and 
if that's your only set, then you're screwed. The chances ofthe same 
archivelog being corrupt in both sets is very low (unless the source archivelog 
is corrupted), but at least you are protected against all the copy errors. 
Also, it's very probable (for us, anyway) that each copy of the archivelog will 
be on different physical tapes, which in itself is important to us since 
operations is outsourced ; )

Jim

__ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise 
Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 
694-4417 Cellular (314) 724-9664 Pager (314) 
294-9797 
[EMAIL PROTECTED] 

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
  12:56 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: rman restore  arclogs
  Lisa,
  
  I 
  guess I'm lazy (or cautious) in that I would allow the first backup to take 
  this archive log files back to tape where they belong, rather than determine 
  (by running reports) which log files I may delete (by 
  hand).
  
  The 
  cautious part of me says that if Rman decided to back these monkeys up within 
  the first save set after the recovery, it may have decided that it needs them 
  for a future recovery. If you did remove them by hand, Rman may complain 
  that it was expecting them and did not find them. Did you try this - 
  remove one that was restored by the recovery process and then tried a 
  backup?
  
  Depending on the kind of restore you do - a 
  full, or a point in time - the archivelog may be of no use anyway (a point in 
  time makes them invalid because you had to perform an "open db reset logs", 
  while a full restore could still use these again).
  
  Glad 
  you are at least experimenting with the tool before you put it in production - 
  it actually is fun to do a restore as it happens so 
  infrequently!
  
  Good 
  Luck!
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
10:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: rman restore  arclogs
Good morning all - 
I've been practicing rman restores. It's a lot 
easier than I originally thought. I've noticed that when you restore 
and the arclogs are needed, it restores them. Which is expected. 
However, when I take another backup, these arclogs are included in the 
backup set. This is unnecessary in my opinion and makes my backup 
files larger than they need to be. 
Is it standard practice to just delete the arclogs 
that were already in a backup set prior to taking the immediate backup after 
a recovery? I can verify what arclogs are where in the backup sets 
with a report. 
Any comments are appreciated. Thanks 
Lisa Koivu Oracle 
Database Monkey Fairfield Resorts, Inc. 
954-935-4117

RE: Doubts reg :Export and import




Mark,

With an LMT using UES of 100M, you will get 5 extents.

Jared



   
 
Mark Leith   
 
mark@cool-too   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
ls.co.ukcc:   
 
Sent by: Subject: RE: Doubts reg :Export and 
import 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/03/01 02:50 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..

When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to
5
extents of 100Mb - or one of 500Mb?

My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)

Cheers

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L


If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:

 Another one that apparently has access to e-mail but not to the
internet to
 RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
 read e-mails but cannot read FM etc.

 Alex Hillman

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
  Sent: Wednesday, November 28, 2001 12:16 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Doubts reg :Export and import
 
 
  hi list,
 
  what is the exact use of mentioning 'compress' yes
  or no while exportingwill this store the .dmp file
  in compressed format in system,if given 'yes'.
 
  while importing the dumpfile why is it necessary to
  give 'fromuser',is 'touser' not enough.
 
  sangeetha
 
  __
  Do You Yahoo!?
  Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
  http://geocities.yahoo.com/ps/info1
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: sangeetha
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be 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: Alex Hillman
   INET: [EMAIL PROTECTED]

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

RE: FIRST_ROWS vs. ALL_ROWS

Title: RE: FIRST_ROWS vs. ALL_ROWS





Hi Bill, 


It's been a while since I messed with the optimizer but I'll take a stab. 


FIRST_ROWS is for something like forms, where returning something quickly, even if it is just a few rows, is important. 

ALL_ROWS is meant for throughput. The execution plan for ALL_ROWS looks like something you may see in a data mart/warehouse. (I have rarely seen the STAR join actually work.) Remember in dm/dw split-second reports are not realistic. 

What type of app is this? How fresh are your stats? When was the last time you deleted stats and re-analyzed? Any histograms? There are a ton of things to take into account here. 

Anyway I hope I helped somehow. 


Lisa Koivu
Oracle Database Monkey.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject: FIRST_ROWS vs. ALL_ROWS


  Howdy,


   I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
determined the query was not using the indexes I thought it should. When I
changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
to minimize total execution time. I'm trying to figure out the difference.
Using FIRST_ROWS, this is the output from tkprof:


  select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
  r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
  rs.terminatingclli from routingassignmentpersistent ra,
  route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
  C' and networksubtype
  = 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
  r.objid = ROUTE_OBJID and ROUTESEGMENTPERSISTENT_OBJID =
rs.objid
  and rownum  5 and ra.startdate is not null


  call count cpu elapsed disk query
current rows
  --- --  -- -- --
-- --
  Parse 1 0.00 0.01 0 0
0 0
  Execute 1 0.00 0.00 0 0
0 0
  Fetch 2 0.00 0.00 0 35
0 4
  --- --  -- -- --
-- --
  total 4 0.00 0.01 0 35
0 4


  Misses in library cache during parse: 1
  Optimizer goal: FIRST_ROWS
  Parsing user id: 29 (NTOPBIG)


  Rows Row Source Operation
  --- ---
   4 COUNT STOPKEY
   4 NESTED LOOPS
   4 NESTED LOOPS
   2 NESTED LOOPS
   1 TABLE ACCESS BY INDEX ROWID
ROUTINGASSIGNMENTPERSISTENT
   1 INDEX RANGE SCAN (object id 16976)
   2 TABLE ACCESS BY INDEX ROWID ROUTE
   2 INDEX RANGE SCAN (object id 16962)
   5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
   5 INDEX RANGE SCAN (object id 16971)
4 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
7 INDEX UNIQUE SCAN (object id 16965)



Rows Execution Plan
---
---
 0 SELECT STATEMENT GOAL: FIRST_ROWS
 4 COUNT (STOPKEY)
 4 NESTED LOOPS
 4 NESTED LOOPS
 2 NESTED LOOPS
 1 TABLE ACCESS GOAL: ANALYZED
(BY INDEX ROWID) OF
 
'ROUTINGASSIGNMENTPERSISTENT'
 1 INDEX GOAL: ANALYZED (RANGE
SCAN) OF
 
'IX_ROUTINGASSIGNMENTPERSIST5' (NON-UNIQUE)
 2 TABLE ACCESS GOAL: ANALYZED
(BY INDEX ROWID) OF
 'ROUTE'
 2 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'IX_ROUTE4'
 (NON-UNIQUE)
 5 TABLE ACCESS GOAL: ANALYZED
(BY INDEX ROWID) OF
 'ROUTESEGMENTROUTE'
 5 INDEX GOAL: ANALYZED (RANGE
SCAN) OF
 'IX_ROUTESEGMENTROUTE3'
(NON-UNIQUE) 
 4 TABLE ACCESS GOAL: ANALYZED
(BY INDEX ROWID) OF
 'ROUTESEGMENTPERSISTENT'
 7 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF
 'IX_ROUTESEGMENTPERSISTENT'
(UNIQUE)


Using the ALL_ROWS mode, this is the tkprof
output from the same query:


  select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
  r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
  rs.terminatingclli from routingassignmentpersistent ra,
  route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
  C' and networksubtype
  = 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
  r.objid = ROUTE_OBJID and ROUTESEGMENTPERSISTENT_OBJID =
rs.objid
  and rownum  5 and ra.startdate is not null


  call count cpu elapsed disk query
current rows
  --- --  -- -- --
-- --
  Parse 1 0.02 0.01 0 0
0 0
  Execute 2 0.05 0.06 0 0
5 0
  Fetch 2 40.91 471.49 197287 803265
3128 4
  --- --  -- -- --
-- --
  total 5 40.98 471.56 197287 803265
3133 4


  Misses in library cache during parse: 1
  Optimizer goal: ALL_ROWS
  Parsing user id: 29 (NTOPBIG)


  Rows Row Source Operation
  --- ---
   4 COUNT STOPKEY
   4

Re: Oracle for Sun/64 Bit Question

2001-12-03 Thread Thater, William


Rao, Maheswara wrote:

Tom,

Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
best way, I found is, copy both the cd's onto two different locations on the
disk.  Then start the installation.  Once, the first file is over, it asks
you for the second CD.  Then, you give the file path where you copied the
second cd.

Rao

as long as you start the runInstaller from a directory other than 
/cdrom, you can change the CD when it asks you to.  i've done it for 
8.1.7 and 9iAS with no problems.

-- 
--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

This message transmitted on 100% recycled electrons.




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

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

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

Re: killing system user



Deepak,

To be quite honest, I can't remember.  I'm like that with details
sometimes.
I tend to forget them, though I remember the reason I learned them in
the first place.  :)

This is on MetaLink somewhere if you care to look for it.  I really
can't do that now.  It's back to the grindstone for me.

The grindstone in this case being iFS 1.1.9.  Ah the joy of
troubleshooting.  :)

Jared




   

Deepak Thapliyal   

deepakthapliyal@   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
YAHOO.COM  cc:

Sent by:Subject: Re: killing system user   

[EMAIL PROTECTED]   

   

   

12/03/01 09:55 AM  

Please respond to  

ORACLE-L   

   

   





Hi Jared

why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...

Thx
Deepak
--- Jared Still [EMAIL PROTECTED] wrote:

 The session is rolling back, you can't kill it.

 This is why the serial# is changing.

 The following query can be used to track its
 progress.

 select s.osuser
   ,s.username
   ,s.sid
   ,r.segment_name
   ,t.space
   ,t.recursive
   ,t.noundo
   ,t.used_ublk
   ,t.used_urec
   ,t.log_io
   ,t.phy_io
   ,substr(sa.sql_text,1,200) txt
 from v$session s,
  v$transaction t,
  dba_rollback_segs r,
  v$sqlarea sa
 where s.taddr=t.addr
 and   t.xidusn=r.segment_id(+)
 and   s.sql_address=sa.address(+);

 Jared


 On Sunday 02 December 2001 22:55, Tatireddy,
 Shrinivas (MED, Keane) wrote:
  Hi lists,
 
  Solaris 2.7
  oracle 8i
 
  I have a session SYSTEM doing import into a
 table. (logged into server
  thru telnet from win 98 PC)
 
  Suddenly the power outage occurred to my PC.
 
  When I logged into the server thru telnet, I found
 that the session is
  active.
  By mistake, I killed the process at o/s level.
 
  For somereasons,I tried to drop the table. But I
 failed to do it, as it
  is locked by import process.
 
  I tried to kill the user SYSTEM. But the oracle
 is giving  error that
  there is not user with such sid and serial number.
 
  The serial# number is often getting changed when I
 query from v$session.
 
  Is there a way to kill this user, without shutting
 down the database.
 
  And why different serial# number each time, I
 query v$SESSION.?
 
  Any clues?
 
  Thnx and Regards,
 
  Srinivas
 --
 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





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

2001-12-03 Thread Ruth Gramolini


When you have finished the restore and open the database with resetlogs, all
of the old archivelogs are toast anyway.  Just delete them!

You can manually delete any orphaned backupsets.  If a backup fails then you
need to redo it until in completes so that it will be recorded in the
catalog and be usable for restore/recovery.

It really is that easy.  Just a little getting used to, like being pregnant,
not bad but different.( I hope your pregnancy is going well.)  Any
discomfort will be forgotten when you see the results.

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


 Hi Ruth, thanks so much for responding.

 Yes, I wrote the scripts to do an arclog backup delete.  I'm concerned
about
 the arclogs hanging around after a restore and taking up disk space, along
 with unnecessarily inflating the size of my backup files.  (I'm testing
 backup to disk right now)

 It's more of a nice to know, not necessary.  I'm seeing some weird stuff
 that I didn't expect and the monkey in me wants to know why...  No, not
the
 baby :)  Here's some other odd behavior I've seen:

 1.  Instance failure during a backup leaves the rman files intact but the
 backup itself is not reflected in the catalog.  The database recovers
nicely
 from this since no tablespaces are in hotbackup mode (yes)  The
end
 result is orphan rman files that the catalog knows nothing about.

 2.  Initially these files are created the size of all datafiles combined.
 As the backup progresses, the size of the files shrink down considerably.
 For example, I allocate 3 channels to disk and setsize to 2GB, but the
files
 start out at 1.5GB and shrink down to ~500 MB.   I wonder if that behavior
 happens on tape?  Anyone?  I'll be able to test this later this week.

 3.  Can restore and recovery really be this easy?  Sheesh

 Thanks again for your response.  And list, please correct me if I am wrong
 on any of this.

 yours in Monkeying Around,
 Lisa

  -Original Message-
  From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
  Sent: Monday, December 03, 2001 1:17 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: rman restore  arclogs
 
  Lisa,
 
  We backup all archivlogs with the backup set and delete them. Delete is
an
  rman option when you backup archivelogs.  We don't have room to keep
them.
  It is a bit of a pain to restore them but you learn to live with it.
 
  Have a look at rman's tables and views. You should be able to query them
  and
  get what you want.
 
  Yours in rman,
  Ruth
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Monday, December 03, 2001 10:30 AM
 
 
   Good morning all -
  
   I've been practicing rman restores.  It's a lot easier than I
originally
   thought.  I've noticed that when you restore and the arclogs are
needed,
  it
   restores them.  Which is expected.  However, when I take another
backup,
   these arclogs are included in the backup set.  This is unnecessary in
my
   opinion and makes my backup files larger than they need to be.
  
   Is it standard practice to just delete the arclogs that were already
in
  a
   backup set prior to taking the immediate backup after a recovery?  I
can
   verify what arclogs are where in the backup sets with a report.
  
   Any comments are appreciated.  Thanks
  
   Lisa Koivu
   Oracle Database Monkey
   Fairfield Resorts, Inc.
   954-935-4117
  
  
 
  --
  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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle for Sun/64 Bit Question


Tom,

Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
best way, I found is, copy both the cd's onto two different locations on the
disk.  Then start the installation.  Once, the first file is over, it asks
you for the second CD.  Then, you give the file path where you copied the
second cd.

Rao

-Original Message-
Sent: Monday, December 03, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


All,

I have the install disks for 8.1.7 for Sun SPARC Solaris.  

Are these disks (2 of them) the same for Sun 64bit?

I looked on TechNet, and I do not see any other 817 release for Sun.

I do see, however, 64 bit for Oracle for 9i.

Thanks!

Tom Mercadante
Oracle Certified Professional

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

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

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

RE: Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Kevin Bass


I have attempted a full export and received the following message:

[/u03] $ exp system/password full=y rows=y file=full.dmp

Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001

(c) Copyright 1998 Oracle Corporation.  All rights reserved.


Connected to: Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
EXP-8: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'  


Since the corruption resides in the SYSTEM tablespace, it seems that the
course of action that should be taken is to re-create the database.


Kevin L. Bass
Database Administrator
Americal Corporation
(252) 762-2199 x2144


-Original Message-
Sent: Monday, December 03, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L


 Kevin Bass wrote:
 
 I have just started a project and have encountered a database problem.
 The previous DBA did not create any backup scripts or backup and
 recovery plans. Is there a way to get around this problem without
 re-creating the database?
 
 
 When executing my script to get corrupted data block information , I
 get the following:
 ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
 ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
 

Kevin,

   Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,

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

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

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

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

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

RE: Quick Question on hotbackup


Seema,

You do not need to switch current log file at the beginning of your job.
You switch the log file before taking the copy of archive log files.

Generally, listener and tnsnames files copy is not required. 

Overall the steps you outlined are ok.  But remember at every step to check
for the success or failure of your step  before proceeding with the next
step.

If you are trying to write the script in Unix, I suggest the following
additional things.

1. Before starting the hot backup job, check whether the db is up or not. If
the db is not up, then abort the job and send a mail to the Daring Boys All
(DBAs).

2. Before putting a tablespace in the hot backup mode, check whether the
tablespace is already in hot backup mode.  This could happen if another DBA
is doing hot backup on the same tablespace.

3. After copying the datafile, do unix compare. If it fails, then abort the
job and send a mail to DBA.

4. Also after copying the archive log files, you need to delete the archive
logs. Else, your archive log space would keep increasing.

5. Once all the tablespaces and archive logs are copied, it is a good
practice to compress these files.

Rao 

-Original Message-
Sent: Monday, December 03, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L


Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to 
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and passwd file
-All archive log files
Is any things missing in this list?
Thanks
-Seema

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

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

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

Reminder: Listers meeting at OOW

2001-12-03 Thread John Kanagaraj


Hi all,

Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):

Location: Chevy's at Howard and 3rd. 
Time: 7pm onwards at the bar, sit down at 8pm
Contact: Gerardo Molina/John Kanagaraj (table booked in Gerardo's name)

1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo Molina
4. Jeremiah Wilton
5. John Kanagaraj
6. Greg Loughmiller (?)
7. Gaja Vaidyanatha (?)
8. Ari Kaplan
9. Steve Orr (Welcome back to the Bay Area, Steve!)
10. K Gopalakrishnan (?)
11. Vivek Sharma (?)

Please call me at 408-315-0842 - the on-call cell that is always with the me
this entire week :( in case you want to get in touch with the group at the
last minute.

Thanks,
John Kanagaraj
DBSoft at Hitachi Data Systems
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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

RE: Message to Session Users - How's it done in your org ?

2001-12-03 Thread Guidry, Chris


On NT LAN use the NET SEND command.
You can send to individual user names or domain wide
or to those that have connections to the server.
HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


 -Original Message-
 From: Robert Chin [SMTP:[EMAIL PROTECTED]]
 Sent: Sunday, December 02, 2001 07:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Message to Session Users - How's it done in your org ?
 
 In our current environment, we have the need to be able to
 send LAN pop-up message to users of ACTIVE Oracle sessions.
 (Pls log out NOW !..., Pls don't do any x transactions... etc you get
 the idea)
 
 If your organization have similar need.
 Do you know how it's done in your organization ?
 Pls specify the infrastructure (whether it's via Internet or LAN and the
 OS)
 
 Thanks
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Robert Chin
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be 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: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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

RE: Message at the start of svrmgrl

2001-12-03 Thread Anand Prakash




Mike

I found a note on metalink (124568.1) which explains the 
reason. Oracle 8.1.7.x products are not supported on chip prior to 
EV56.

Thanks.
Anand Prakash

 [EMAIL PROTECTED] 12/03/01 12:40PM 

Anand,

I installed the same(? 
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this 
result. However, I do remember this kind of result with a earlier upgrade 
to 8.0.x in the distant past. I believe it is a verbose linking option 
with no negative impact. Is svrmgrl the only executable responding like 
this. If so, try relinking.

Mike Hand
Polaroid 
Corp.

  -Original Message-
  
  I have just done installation of 8.1.7.0 
  on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no 
  installation errors. When I start svrmgrl I see a line "inst emulated 
  pid=175364...".
  
  --$ svrmgrlinst emulated pid=175364 
  svrmgrl va=0x11fffa358 pc=0x1205c0148 
  inst=0x327e0028
  
  Oracle Server Manager Release 3.1.7.0.0 - 
  Production
  
  Copyright (c) 1997, 1999, Oracle Corporation. All 
  Rights Reserved.

RE: rman restore arclogs

Title: RE: rman restore  arclogs





Interesting. Does rman ever get confused during a restore or does it just grab the most convenient backup set with the required archive logs on it? I don't suppose you can parallel restore your arclogs from different files/tapes? (There goes that monkey again)

Thanks for your response Jim.
Lisa 


-Original Message-
From: HAWKINS, JAMES W [IT/1000] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman restore  arclogs


I just wanted to throw something else out there - it may have already come up though.  We backup the archivelogs first without deleting them, and then immediately backup another set with the delete specified.  Obviously, this is because anything can happen to that first set (corruptions, etc.), and if that's your only set, then you're screwed.  The chances of the same archivelog being corrupt in both sets is very low (unless the source archivelog is corrupted), but at least you are protected against all the copy errors.  Also, it's very probable (for us, anyway) that each copy of the archivelog will be on different physical tapes, which in itself is important to us since operations is outsourced ; )

 
Jim
 


__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise 


Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797 


[EMAIL PROTECTED] 


-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman restore  arclogs


Lisa,
 
I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand).

 
The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery.  If you did remove them by hand, Rman may complain that it was expecting them and did not find them.  Did you try this - remove one that was restored by the recovery process and then tried a backup?

 
Depending on the kind of restore you do  - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an open db reset logs, while a full restore could still use these again).

 
Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently!

 
Good Luck!


Tom Mercadante
Oracle Certified Professional 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject: rman restore  arclogs




Good morning all - 


I've been practicing rman restores.  It's a lot easier than I originally thought.  I've noticed that when you restore and the arclogs are needed, it restores them.  Which is expected.  However, when I take another backup, these arclogs are included in the backup set.  This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery?  I can verify what arclogs are where in the backup sets with a report.  

Any comments are appreciated.  Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

RE: Reminder: Listers meeting at OOW

2001-12-03 Thread Mohan, Ross


WOW ( or should I say OOW) it's like a
List of Oracle HeavyHitters and Cognoscenti. 



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


Hi all,

Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):

Location: Chevy's at Howard and 3rd. 
Time: 7pm onwards at the bar, sit down at 8pm
Contact: Gerardo Molina/John Kanagaraj (table booked in Gerardo's name)

1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo Molina
4. Jeremiah Wilton
5. John Kanagaraj
6. Greg Loughmiller (?)
7. Gaja Vaidyanatha (?)
8. Ari Kaplan
9. Steve Orr (Welcome back to the Bay Area, Steve!)
10. K Gopalakrishnan (?)
11. Vivek Sharma (?)

Please call me at 408-315-0842 - the on-call cell that is always with the me
this entire week :( in case you want to get in touch with the group at the
last minute.

Thanks,
John Kanagaraj
DBSoft at Hitachi Data Systems
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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


William,

Thanks for the update.

Rao

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


Rao, Maheswara wrote:

Tom,

Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
best way, I found is, copy both the cd's onto two different locations on
the
disk.  Then start the installation.  Once, the first file is over, it asks
you for the second CD.  Then, you give the file path where you copied the
second cd.

Rao

as long as you start the runInstaller from a directory other than 
/cdrom, you can change the CD when it asks you to.  i've done it for 
8.1.7 and 9iAS with no problems.

-- 
--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

This message transmitted on 100% recycled electrons.




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

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

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

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

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

RE: Corrupted data blocks in tablespace SYSTEM

Title: RE: Corrupted data blocks in tablespace SYSTEM





Kevin, 


Try exporting your schema owners (code, tables, etc.) as a CYA. When you recreate the db, you can import each schema separately. A pain, but it will save you.

Lisa


-Original Message-
From: Kevin Bass [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Corrupted data blocks in tablespace SYSTEM


I have attempted a full export and received the following message:


[/u03] $ exp system/password full=y rows=y file=full.dmp


Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001


(c) Copyright 1998 Oracle Corporation. All rights reserved.



Connected to: Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set


About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
EXP-8: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf' 



Since the corruption resides in the SYSTEM tablespace, it seems that the
course of action that should be taken is to re-create the database.



Kevin L. Bass
Database Administrator
Americal Corporation
(252) 762-2199 x2144



-Original Message-
Sent: Monday, December 03, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L



 Kevin Bass wrote:
 
 I have just started a project and have encountered a database problem.
 The previous DBA did not create any backup scripts or backup and
 recovery plans. Is there a way to get around this problem without
 re-creating the database?
 
 
 When executing my script to get corrupted data block information , I
 get the following:
 ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
 ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
 


Kevin,


 Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,


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


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

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


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

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

RE: Message at the start of svrmgrl

2001-12-03 Thread Sunil_Nookala




Hello all,

could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a 
minuteona table with 50,000 rows 
and about 21 mins on a table with 235,000 rows??
Ihave created a 
bigger rollback segment to take care of this, but no improvement.where 
should i be looking for bottlenecks??

CREATE PROCUDURE DUPES_DELASBEGIN

LOOPDELETE from fms_testwhere row_id 
in(select min(rowid)from 
fms_testgroup by sku_numhaving count 
(*) 1);EXIT WHEN SQL%NOTFOUNDEND 
LOOP;COMMIT;END;

appreciate it.Sunil NookalaDellCorp.Austin, 
TX

Recall: Message at the start of svrmgrl

2001-12-03 Thread Sunil_Nookala


Nookala, Sunil would like to recall the message, Message at the start of
svrmgrl.
-- 
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).

deleting duplicate records

2001-12-03 Thread Sunil_Nookala




Hello all,

could someone please tell me why the procedure 
below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21 
mins on a table with 235,000 rows??

i have created a bigger rollback segment to take care of this, 
but no improvement.where should i be looking for bottlenecks??

CREATE PROCUDURE DUPES_DEL ASBEGIN

LOOPDELETE from fms_testwhere row_id 
in(select min(rowid)from 
fms_testgroup by sku_numhaving count 
(*) 1);EXIT WHEN SQL%NOTFOUNDEND 
LOOP;COMMIT;END;

appreciate it.Sunil NookalaDellCorp.Austin, 
TX

RE: doubts reg : Tablespace


Sangeetha,

1. During creation of tablespace, if you make it online, then, tablespace is
available for use immediately after its creation.  Otherwise (offline), you
need to issue a separate statement making the tablespace online after
tablespace is created.

2. Yes. You could store two different users objects in the same tablespace
and datafile.  Basically, a tablespace contains some datafiles.  Users are
assigned to the tablespace ( I mean users are granted space quota privileges
on the tablespace).

3. No.  Two tablespaces cannot contain the same datafile.

a bit of advice:  Please read Oracle concepts Vol.1.  It would clarify most
of your doubts on these tablespaces and datafiles.

Rao



-Original Message-
Sent: Wednesday, November 28, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L


hi,

 what is the exact use of making the 'status' online
or offline at the time of creation of tablespace.

can objects of two diff users be stored in the same
tablespace and datafile.

can two tablespaces contain the same  datafile .

thanx in advance
sangeetha

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

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

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

RE: FIRST_ROWS vs. ALL_ROWS

2001-12-03 Thread Carle, William T (Bill), NLCIO


Hello again,

I want to thank everyone for responding to my query. I have a much
better understanding of how this works now. I changed my query to remove the
rownum  5 and the query returned 344066 rows. The output of the tkprof is
below:

FIRST_ROWS

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.01   0.01  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch22939 29.99 145.98  424882708970  0
344066


ALL_ROWS

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.01   0.01  0  0  0
0
Execute  2  0.01   0.00  0  0  2
0
Fetch22939 49.33 474.71 221733 803265   3086
344066

It still seems like it takes much longer in the ALL_ROWS case, but the
value in the query column is much less; however, the values in the disk and
current columns are much bigger. When I actually ran it and put the output
into a file, the FIRST_ROWS case took 1:17 minutes and the ALL_ROWS case
took 8:53 minutes. 


Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

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

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

RE: Message at the start of svrmgrl

Title: RE: Message at the start of svrmgrl





Did you trace the statement? Send a trace to the list. 


-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Message at the start of svrmgrl


Hello all,
 
could someone please tell me why the procedure below (Author:Nick Butcher) takes less than a minute on
a table with 50,000 rows and about 21 mins on a table with 235,000 rows??
 
I have created a bigger rollback segment to take care of this, but no improvement.
where should i be looking for bottlenecks??
 


CREATE PROCUDURE DUPES_DEL  AS
BEGIN
 
 LOOP
 DELETE from fms_test
 where row_id in(select min(rowid)
   from fms_test
   group by sku_num
   having count (*) 1);
  EXIT WHEN SQL%NOTFOUND
 END LOOP;
  
  COMMIT;
END;
 


appreciate it.
Sunil Nookala
DellCorp.
Austin, TX

SQL Loader Commit Point?

2001-12-03 Thread Ken Janusz


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
 
-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

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

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

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

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

Re: Corrupted data blocks in tablespace SYSTEM

2001-12-03 Thread Stephane Faroult


Kevin Bass wrote:
 
 I have attempted a full export and received the following message:
 
 [/u03] $ exp system/password full=y rows=y file=full.dmp
 
 Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001
 
 (c) Copyright 1998 Oracle Corporation.  All rights reserved.
 
 Connected to: Oracle8 Release 8.0.5.0.0 - Production
 PL/SQL Release 8.0.5.0.0 - Production
 Export done in US7ASCII character set and US7ASCII NCHAR character set
 
 About to export the entire database ...
 . exporting tablespace definitions
 . exporting profiles
 . exporting user definitions
 . exporting roles
 . exporting resource costs
 . exporting rollback segment definitions
 . exporting database links
 . exporting sequence numbers
 . exporting directory aliases
 . exporting foreign function library names
 EXP-8: ORACLE error 1578 encountered
 ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
 ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
 
 Since the corruption resides in the SYSTEM tablespace, it seems that the
 course of action that should be taken is to re-create the database.
 
 Kevin L. Bass
 Database Administrator
 Americal Corporation
 (252) 762-2199 x2144

Unfortunately, it looks like it. But perhaps you can recover your data
by exporting on a per something basis, 'something' being either owner or
tables or whatever, just trying to circle around the problem. Which is
why you should check dba_extents (somebody posted the query). It will
tell you which table is screwed up, and you may be able to use an export
function which does NOT export what is held in this table. You have good
blocks around the bad one, the problem is to tread carefully around.
Kind of minefield with a single mine in it. Of course no need to do this
kind of thing if you have a reasonably recent backup and do not care too
much about the transactions you might lose.
-- 
Regards,

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

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

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

RE: SQL Loader Commit Point?

2001-12-03 Thread Jack C. Applewhite


Ken,

Check the Loader log file.  The records are being rejected for some reason
and Loader only tells you in the log.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Sent: Monday, December 03, 2001 3:33 PM
To: Multiple recipients of list ORACLE-L


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.

-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

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

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

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

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

RE: deleting duplicate records

2001-12-03 Thread Jack C. Applewhite




Sunil,

If there are multiple 
duplicates foreven a few SKU_Num values, you're doing multiple scans (full 
table or full index) to get all the dups out. You might reconstruct the 
SQL to not use a looping construct if there are lots of duplicate rows for each 
SKU_Num

Delete From 
FMS_Test
Where ( SKU_Num, RowID ) 
In
(
Select SKU_Num, 
RowID
From 
FMS_Test
Minus
Select SKU_Num, Max ( 
RowID )
From 
FMS_Test
Group By 
SKU_Num
) ;

Or keep the loop and add a 
Commit right after the Delete statement - that will cut down on Rollback segment 
usage.

Is there an index on the column 
sku_num? It would probably help as well.

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 
  [EMAIL PROTECTED]Sent: Monday, December 03, 2001 3:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  deleting duplicate records
  Hello all,
  
  could someone please tell me why the procedure 
  below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 
  21 mins on a table with 235,000 rows??
  
  i have created a bigger rollback segment to take care of 
  this, but no improvement.where should i be looking for 
  bottlenecks??
  
  CREATE PROCUDURE DUPES_DEL ASBEGIN
  
  LOOPDELETE from fms_testwhere 
  row_id in(select min(rowid)from 
  fms_testgroup by sku_numhaving 
  count (*) 1);EXIT WHEN SQL%NOTFOUNDEND 
  LOOP;COMMIT;END;
  
  appreciate it.Sunil NookalaDellCorp.Austin, 
  TX

Anybody heard Oracle will remove the JVM from Oracle in future re

2001-12-03 Thread Khedr, Waleed


Thanks,

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

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

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

Re: killing system user


yeah Jared, i will look at it. C i am wondering that
if the SID is sufficient to gaurentee uniqueness ..
why does oracle need the serial# as well?? 

or maybe there is a scheduled maintainance window at
this time inside of my head ;)

Thx anyhu ;)

Deepak


--- [EMAIL PROTECTED] wrote:
 
 Deepak,
 
 To be quite honest, I can't remember.  I'm like that
 with details
 sometimes.
 I tend to forget them, though I remember the reason
 I learned them in
 the first place.  :)
 
 This is on MetaLink somewhere if you care to look
 for it.  I really
 can't do that now.  It's back to the grindstone for
 me.
 
 The grindstone in this case being iFS 1.1.9.  Ah the
 joy of
 troubleshooting.  :)
 
 Jared
 
 
 
 
 
 
  
 Deepak Thapliyal
 
  
 deepakthapliyal@   To:
 Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 YAHOO.COM  cc: 
 
  
 Sent by:Subject:
 Re: killing system user 
  
 [EMAIL PROTECTED]
 
  
 
 
  
 
 
  
 12/03/01 09:55 AM   
 
  
 Please respond to   
 
  
 ORACLE-L
 
  
 
 
  
 
 
  
 
 
 
 
 Hi Jared
 
 why does the serial# have to change due to rollback?
 lots of us would be curious for a brief expln ...
 
 Thx
 Deepak
 --- Jared Still [EMAIL PROTECTED] wrote:
 
  The session is rolling back, you can't kill it.
 
  This is why the serial# is changing.
 
  The following query can be used to track its
  progress.
 
  select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
,t.used_urec
,t.log_io
,t.phy_io
,substr(sa.sql_text,1,200) txt
  from v$session s,
   v$transaction t,
   dba_rollback_segs r,
   v$sqlarea sa
  where s.taddr=t.addr
  and   t.xidusn=r.segment_id(+)
  and   s.sql_address=sa.address(+);
 
  Jared
 
 
  On Sunday 02 December 2001 22:55, Tatireddy,
  Shrinivas (MED, Keane) wrote:
   Hi lists,
  
   Solaris 2.7
   oracle 8i
  
   I have a session SYSTEM doing import into a
  table. (logged into server
   thru telnet from win 98 PC)
  
   Suddenly the power outage occurred to my PC.
  
   When I logged into the server thru telnet, I
 found
  that the session is
   active.
   By mistake, I killed the process at o/s level.
  
   For somereasons,I tried to drop the table. But I
  failed to do it, as it
   is locked by import process.
  
   I tried to kill the user SYSTEM. But the
 oracle
  is giving  error that
   there is not user with such sid and serial
 number.
  
   The serial# number is often getting changed when
 I
  query from v$session.
  
   Is there a way to kill this user, without
 shutting
  down the database.
  
   And why different serial# number each time, I
  query v$SESSION.?
  
   Any clues?
  
   Thnx and Regards,
  
   Srinivas
  --
  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
 
 
 
 
 
 -- 
 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

Re: HP-UX 11/8.1.7/Recovery


Michael

i remember (long time back) they had released a new
command called as alter database .. end backup or
somethin in 7.3.. maybe this is the default behaviour
in later releases including 817

Deepak
--- Vergara, Michael (TEM) [EMAIL PROTECTED]
wrote:
 Hi All!
 
 We had an interesting sequence of events last night,
 and I was 
 hoping somebody could tell me if what we saw was
 what should've 
 happened.  Clear?  As mud?  Ok...
 
 System is up and running.
 The backup process starts, and puts the datafiles in
 backup mode.
 The system crashes.  Hard.  Memory fault.
 When the database comes back up, it successfully
 performs media
 recovery and pronounces itself OK.
 We check, and the datafiles are NOT in backup mode.
 
 So we're wondering...does media recovery take the
 datafiles out
 of backup mode automatically?  Can you point me to a
 doco on this?
 
 Thanks,
 Mike
 
 ---

===
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 (909) 914-2304
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
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: Anybody heard Oracle will remove the JVM from Oracle in future re

2001-12-03 Thread Scott Shafer


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


Khedr, Waleed wrote:
 
 Thanks,
 
 Waleed

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

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

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

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

RE: function help ???

2001-12-03 Thread Scott Crabtree


Andrea,
Here is a version of the function you asked for, IT IS NOT WELL
TESTED, should give you something to go on.

Scott Crabtree

FUNCTION calc_avg (student_id IN NUMBER)
   RETURN NUMBER
AS
   CURSOR student_c
   IS
  SELECT  snum
   || call# class, credit, RTRIM (grade) grade,
 credit
   * DECODE (RTRIM (grade), 'A', 4, 'B', 3, 'C', 2, 'D', 1, 'F',
0) weight
  FROM enrollment
 WHERE student# = student_id
  ORDER BY grade DESC;

   last_classNUMBER  := 0;
   last_weight   NUMBER  := 0;
   last_credit   NUMBER  := 0;
   last_gradeVARCHAR2 (1):= 'Z';
   cum_weightNUMBER  := 0;
   cum_credits   NUMBER  := 0;
   gpa   NUMBER (5, 2)   := 0.00;
   student_rec   student_c%ROWTYPE;
BEGIN
   OPEN student_c;
   FETCH student_c INTO student_rec;

   WHILE student_c%FOUND
   LOOP
  --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) || ' ' ||
nvl(to_char(student_rec.credit),'NULL'));
  IF  last_class = student_rec.class  --Repeat_delete 
  AND last_grade IN ('F', 'D')
  AND student_rec.grade IN ('A', 'B', 'C')
  THEN
 cum_weight :=   cum_weight
   - last_weight
   + student_rec.weight;
 cum_credits :=   cum_credits
- last_credit
+ student_rec.credit;
  --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) ||
to_char(student_rec.credit));
  ELSE
 cum_weight :=   cum_weight
   + student_rec.weight;
 cum_credits :=   cum_credits
+ student_rec.credit;
  END IF;

  last_class := student_rec.class;
  last_weight := student_rec.weight;
  last_credit := student_rec.credit;
  last_grade := student_rec.grade;
  FETCH student_c INTO student_rec;
   END LOOP;

   CLOSE student_c;
   gpa := cum_weight / cum_credits;
   -- DBMS_OUTPUT.PUT_LINE('Cum Weight:' || to_char(cum_weight) || ' Cum
Credits:' || to_char(cum_credits));
   RETURN gpa;
END; -- Function CALC_AVG

Call it for every distinct student# using:

select calc_avg(student),a.student from 
(select distinct STUDENT# student from enrollment) a


-Original Message-
Sent: Monday, December 03, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L


Hi, Could any one show me how to write the following
function?  Thank you very, very much!  

The GPA Function

1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.

2.Repeat_delete Policy: A student may repeat a course
as many times as he
wants. However, if the first grade he receives on this
course is a D or F,
then the second grade will automatically replaces the
first grade, and the
first enrollment will not go into his GPA calculation.
Under any other
circumstances, his grades will be considered as a
regular grade and be
taken into consideration for GPA.

create table Enrollment(
Student# NUMBER (7),
SNUM NUMBER (5),
Call# NUMBER (7),
Semester char (8),
GRADE char (3),
Credit number,
Withdraw_Date Date);

SNUM + Call# represents one class.

 Insert into Enrollment
values('58001','111','70070','Sp2000','F',3, null);
Insert into Enrollment
values('58001','111','70070','Fa2000','B',3, null);
Insert into Enrollment
values('58003','222','70070','Sp2000','A',2, null);
Insert into Enrollment
values('58004','333','80025','Fa2000','A',2, null);
Insert into Enrollment
values('58005','222','80025','Fa2000','C',3, null);




__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

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

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

Question on dba_ts_quotas

2001-12-03 Thread Prasada . Gunda1



Hi All,

I have a question on dba_ts_quotas.

User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
tablespaces. And, I expect that the relation/quota
would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
for this schema. I checked for other
schemas and they showed up.
Just for testing, I created a dummy table to test it and it got created
without any problems.

Why is it not showing up in dba_ts_quotas. Am I missing something here?
BTW, I am using SYSTEM to query these views.

Thanks in advance for your help.

SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';

TABLESPACE_NAME
--
TS_QUOTE_DATA
TS_QUOTE_INDEX

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';

no rows selected

CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;

Table created.


Best regards,
Prasad


-- 
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: rman restore arclogs


We have a slightly differnt apprach for this ..

1. 
cp arch files to arch history location (stage 2 days
worth achives on disk. there is a cron that fires
everday and deletes all files from hostory arch
location which are two or more days older)

2.there is a script that invokes rman to backup arch
using delete input clause

steps 1 and 2 are done every 4 hours for archives so
that archives are backed up to tape and to ensure as
per sla that we store atleast 2 days worth of archives
on disk. 

at the end of the day take a db backup(full or inc as
per sla. vaires from db to db)

Deepak


--- HAWKINS, JAMES W [IT/1000]
[EMAIL PROTECTED] wrote:
 I just wanted to throw something else out there - it
 may have already come
 up though.  We backup the archivelogs first without
 deleting them, and then
 immediately backup another set with the delete
 specified.  Obviously, this
 is because anything can happen to that first set
 (corruptions, etc.), and if
 that's your only set, then you're screwed.  The
 chances of the same
 archivelog being corrupt in both sets is very low
 (unless the source
 archivelog is corrupted), but at least you are
 protected against all the
 copy errors.  Also, it's very probable (for us,
 anyway) that each copy of
 the archivelog will be on different physical tapes,
 which in itself is
 important to us since operations is outsourced ; )
  
 Jim
  
 
 __ 
 Jim Hawkins 
 Oracle Database Administrator 
 Data Management Center of Expertise 
 
 Pharmacia Corporation 
 800 North Lindbergh Blvd. 
 St. Louis, Missouri  63167 
 Work  (314) 694-4417 
 Cellular (314) 724-9664 
 Pager (314) 294-9797 
 
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Monday, December 03, 2001 12:56 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Lisa,
  
 I guess I'm lazy (or cautious) in that I would allow
 the first backup to
 take this archive log files back to tape where they
 belong, rather than
 determine (by running reports) which log files I may
 delete (by hand).
  
 The cautious part of me says that if Rman decided to
 back these monkeys up
 within the first save set after the recovery, it may
 have decided that it
 needs them for a future recovery.  If you did remove
 them by hand, Rman may
 complain that it was expecting them and did not find
 them.  Did you try this
 - remove one that was restored by the recovery
 process and then tried a
 backup?
  
 Depending on the kind of restore you do  - a full,
 or a point in time - the
 archivelog may be of no use anyway (a point in time
 makes them invalid
 because you had to perform an open db reset logs,
 while a full restore
 could still use these again).
  
 Glad you are at least experimenting with the tool
 before you put it in
 production - it actually is fun to do a restore as
 it happens so
 infrequently!
  
 Good Luck!
 
 Tom Mercadante 
 Oracle Certified Professional 
 
 -Original Message-
 Sent: Monday, December 03, 2001 10:30 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Good morning all - 
 
 I've been practicing rman restores.  It's a lot
 easier than I originally
 thought.  I've noticed that when you restore and the
 arclogs are needed, it
 restores them.  Which is expected.  However, when I
 take another backup,
 these arclogs are included in the backup set.  This
 is unnecessary in my
 opinion and makes my backup files larger than they
 need to be. 
 
 Is it standard practice to just delete the arclogs
 that were already in a
 backup set prior to taking the immediate backup
 after a recovery?  I can
 verify what arclogs are where in the backup sets
 with a report.  
 
 Any comments are appreciated.  Thanks 
 
 Lisa Koivu 
 Oracle Database Monkey 
 Fairfield Resorts, Inc. 
 954-935-4117 
 
 


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
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).

UTL_SMTP to send email

2001-12-03 Thread Suhen Pather









List,



I am sending email from the database.

I have UTL_SMTP setup which works fine.



However in the message field I would like to query a table (using
a select)

rather than a hardcoded
message.



Not sure how to do this though. 

Anyone got any pointers will be greatly appreciated.



PROCEDURE send_mail (

sender IN VARCHAR2,

recipient IN VARCHAR2,

subject IN VARCHAR2,

message IN VARCHAR2

)

IS

mailhost VARCHAR2 (30) := 'www';

mail_conn utl_smtp.connection;

crlf VARCHAR2 (2) := CHR (13)

|| CHR (10);

mesg VARCHAR2 (1000);

BEGIN

mail_conn := utl_smtp.open_connection
(mailhost, 25);

mesg := 'Date: '

|| TO_CHAR (SYSDATE, 'dd Mon yy hh24:mi:ss')

|| crlf

|| 'From: '

|| sender

|| ''

|| crlf

|| 'Subject: '

|| subject

|| crlf

|| 'To: '

|| recipient

|| crlf

|| ''

|| crlf

|| message;

utl_smtp.helo (mail_conn,
mailhost);

utl_smtp.mail (mail_conn,
sender);

utl_smtp.rcpt (mail_conn,
recipient);

utl_smtp.data (mail_conn,
mesg);

utl_smtp.quit (mail_conn);

END;





Thanks  Regards 

Suhen

RE: Anybody heard Oracle will remove the JVM from Oracle in futur

2001-12-03 Thread Khedr, Waleed


Why???

-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


Khedr, Waleed wrote:
 
 Thanks,
 
 Waleed

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

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

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

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

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

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

Re: killing system user



Found it:

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

Jared



   

Deepak Thapliyal   

deepakthapliyal@   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
YAHOO.COM  cc:

Sent by:Subject: Re: killing system user   

[EMAIL PROTECTED]   

   

   

12/03/01 02:09 PM  

Please respond to  

ORACLE-L   

   

   





yeah Jared, i will look at it. C i am wondering that
if the SID is sufficient to gaurentee uniqueness ..
why does oracle need the serial# as well??

or maybe there is a scheduled maintainance window at
this time inside of my head ;)

Thx anyhu ;)

Deepak


--- [EMAIL PROTECTED] wrote:

 Deepak,

 To be quite honest, I can't remember.  I'm like that
 with details
 sometimes.
 I tend to forget them, though I remember the reason
 I learned them in
 the first place.  :)

 This is on MetaLink somewhere if you care to look
 for it.  I really
 can't do that now.  It's back to the grindstone for
 me.

 The grindstone in this case being iFS 1.1.9.  Ah the
 joy of
 troubleshooting.  :)

 Jared












-- 
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: Anybody heard Oracle will remove the JVM from Oracle in futur

2001-12-03 Thread Gogala, Mladen


Rumor is that there will be a perl engine in the database instead of Java
one.


-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


Khedr, Waleed wrote:
 
 Thanks,
 
 Waleed

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

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

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

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



If you check DBA_SYS_PRIVS you will likely
find that the user has 'UNLIMITED TABLESPACE'.

Probably due to granting RESOURCE to the user.

Jared



   

Prasada.Gunda1@hartfo  

rdlife.com  To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
Sent by:cc:

[EMAIL PROTECTED]Subject: Question on dba_ts_quotas 

   

   

12/03/01 02:56 PM  

Please respond to  

ORACLE-L   

   

   






Hi All,

I have a question on dba_ts_quotas.

User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
tablespaces. And, I expect that the relation/quota
would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
for this schema. I checked for other
schemas and they showed up.
Just for testing, I created a dummy table to test it and it got created
without any problems.

Why is it not showing up in dba_ts_quotas. Am I missing something here?
BTW, I am using SYSTEM to query these views.

Thanks in advance for your help.

SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';

TABLESPACE_NAME
--
TS_QUOTE_DATA
TS_QUOTE_INDEX

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';

no rows selected

CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;

Table created.


Best regards,
Prasad


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

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

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




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

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

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

RE: rman restore arclogs