Re: ** v$log.status

[Hemant K Chitale]

 there is a column status. This changes from
current
  (if the redo log is in use) to atcive then to inactive.
 Documentation
  says :
 
 
  ACTIVE: The log is active but is not the current log. It is
needed
  for
  crash recovery. It may be in use for block recovery. It
might or
  might
  not be archived.
 
  INACTIVE: The log is no longer needed for instance
recovery. It may
  be
  in use for media recovery. It might or might not be
archived.
 
  So if it is in 'ACTIVE' status : it means it is needed 
for
  crash/instance recover! y? So what does it mean? That
changes in this
  log are still not written to data files? What else? Is this
related
  to
  delayed block cleanout etc or no connection?
 
  What factor affects how long it will be in ACTIVE state
before 
 going
  to INACTIVE? What can be changed to control how long it
takes. Any
  trade off?
 
  Any detailed explanation on this will be greatly
appreciated. You
 can
  mail me direct or to the list. Thank you.
 
 Status of active means that log has been switched, but not all
of the
 changes are written to the disk. It is, essentially, saying that
DBWR
 has some more work to do to catch up. The only log that is open
by 
 the
 instance is the one marked CURRENT. Here is an
example:
 SQL select group#,status from v$log;
 
 GROUP# STATUS
 -- 
 1 CURRENT
 2 INACTIVE
 3 INACTIVE
 
 SQL alter system switch logfile;
 
 System altered.
 
 SQL select group#,status from v$log;
 
 GROUP# STATUS
 -- 
 1 ACTIVE
 2 CURRENT
 3 INACTIVE
 
 So, after the checkpoint, the CKPT has updated log file
headers,
 corresponding markers and termination records are written to the 
 file,
 data file headers have been updated and so has been the control
file.
 DBWR still has some work to do because there are still
unwritten
 blocks modified by transactions whose log records are in the
ACTIVE
 file. DBWR will take its time to write them down.
 The only log file open by the instance is redo02:
 
 [EMAIL PROTECTED] root]# fuser
/data/db/OraHome1/oradata/compldb/*.log
 /data/db/OraHome1/oradata/compldb/redo02.lo! g: 6019
 [EMAIL PROTECTED] root]#
 
 After another checkpoint, everyhing is back to normal:
 
 SQL alter system checkpoint
 2 /
 
 System altered.
 
 SQL select group#,status from v$log;
 
 GROUP# STATUS
 -- 
 1 INACTIVE
 2 CURRENT
 3 INACTIVE
 
 --
 Please see the official ORACLE-L FAQ:
http://www.orafaq.net
 --
 Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- 858-538-5051
http://www.fatcity.com
 San Diego, California -- Mailing list and web hosting services

-
 To REMOVE yourself from this mailing list, send an E-Mail
message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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!?
 Yahoo! SiteBuilder - Free web site building tool. Try it!
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Mladen Gogala
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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!?
Yahoo! SiteBuilder - Free web site building tool.
Try
it! 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 24-Jan-04}


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

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

RE: What to look for in STATSPACK report

[Hemant K Chitale]

! SiteBuilder - Free web site building tool. Try it!
 http://webhosting.yahoo.com/ps/sb/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
 and in the
 message BODY, include a line containing: UNSUB ORACLE-L (or
 the name of
 mailing list you 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.net
 --
 Author: Anjo Kolk
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 This email and its attachments are confidential under
 applicable law and are intended for use of the sender's
 addressee only, unless the sender expressly agrees otherwise,
 or unless a separate written agreement exists between Iron
 Mountain and a recipient company governing communications
 between the parties and any data that may be so transmitted.
 Transmission of email over the Internet is not a secure
 communications medium.  If you are requesting or have
 requested the transmittal of personal data, as defined in
 applicable privacy laws, by means of email or in an
 attachment to email, you may wish to select a more secure
 alternate means of transmittal that better supports your
 obligations to protect such personal data.

 If the recipient of this message is not the recipient named
 above, and/or you have received this email in error, you must
 take no action based on the information in this email.  You
 are hereby notified that any dissemination, misuse or copying
 or disclosure of this communication by a recipient who has
 received this message in error is strictly prohibited. If
 this message is received in error, please return this email
 to the sender and immediately highlight any error in
 transmittal.  Thank you.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
 This e-mail and its attachments are intended for the
 author's addressee only and may be confidential.
 If they have come to you in error you must take no
 action based on them, nor must you copy or show
 them to anyone; please reply to this e-mail and
 highlight the error.
 Please note that this e-mail has been created in the
 knowledge that Internet e-mail is not a 100% secure
 communications medium. We advise that you
 understand and observe this lack of security when
 e-mailing us. Steps have been taken to ensure this
 e-mail and attachments are free from any virus, but
 advise the recipient to ensure they are actually virus
 free.
 The views, opinions and judgments expressed in this
 message are solely those of the author. The message
 contents have not been reviewed or approved by Iron
 Mountain.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lord David
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 24-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name

Re: ROWID PROBLEM

[Hemant K Chitale]

Read the Oracle Documentation or http://otn.oracle.com or 
http://metalink.oracle.com
on what a RowID is.  It is actually a composite of
File_Number_in_Database + Block_Number_in_File + Row_Number_within_Block.
Since a Table is like a heap rows may be inserted by Oracle in any of the
available blocks -- your next insert may or may not be in the same 
Block.  There are
very many reasons why the same Block would not be reused for the next insert.

You should be using some other column for your ORDERed fetch.

Hemant

At 07:19 AM 25-01-04 -0800, you wrote:
HI ALL..

I HAVE PROBLEM

THE ROWID FIELD  IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA..
I INSERT THE TIME WITH EVERY RECORD
AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM  TIMES IN 
TIME FIELD  !!!

THAT HAPPEND WITH ME IN ONE TABLE ONLY 



WALEED HAGGAGY
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 24-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: !!Please Read - Oracle-L is moving!!

[Hemant K Chitale]

 have not been reviewed or approved by Iron 
Mountain.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***



Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 22-Jan-04}


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

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

Re: [Q] create tablespace with different block size error???

[Hemant K Chitale]

And ... what is the error number that you get ?

Note :  If you are creating a tablespace with the non-standard blocksize,
you must have db_cache_Xk_size  configured and running for your instance
before you create the tablespace.
Hemant
At 08:29 AM 23-01-04 -0800, you wrote:
I tried to create tablespace with 16K (default on my
init.ora blocksize =8k). I have error happen.  The
database version is 9.2.0.4.
 SQL create tablespace index1 logging datafile
'/u0/oradata/leg92/index1.dbf' size 20m
  2  blocksize 16384
  3  autoextend on
  4  next 1280k
  5  maxsize unlimited
  6  extent management local
  7  segment space management auto
  8  uniform size 128k;
autoextend on
*
ERROR at line 3:
if I take out blocksize 16384, then it work fine.

SQL create tablespace index1 logging datafile
'/u0/oradata/leg92/index1.dbf' size 20m
  2  reuse autoextend on
  3  next 1280k
  4  maxsize unlimited
  5  extent management local
  6  segment space management auto
  7  uniform size 128k;
Tablespace created.

Does anyone know why??

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dba1 mcc
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 22-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ADMIN: Status of list server systems (and update about

[Hemant K Chitale]

Bruce,
You are doing a GREAT job keeping the lists running.
And you seem to have put in some effort in developing/implementing the 
load balancers
and then again in retrieving the squirreled-away emails.

Thanks.  We appreciate your work.

Regards
Hemant
At 05:39 PM 19-01-04 -0800, you wrote:
Folks --

I have good news and bad news. ;-)  First the good news:

Several people had mentioned that they've sent messages to some lists but 
have not seen the posts arrive back to them.  These messages DID appear in 
the archives though.  This started roughly 12-Jan-2004.  I had previously 
researched this issue but could find no reason for it happening, nor a 
solution.  Up until today, that is.

The cuplrit was one of my load balancers for mailing list traffic.  It was 
handling traffic correctly on some of the machines, but squirreling away 
messages sent to one specific server.  I'd estimate about 1/8th of the 
messages sent to mailing lists since 12-Jan-2004 were not redistributed 
properly.  I have since found and fixed the problem, so this shouldn't 
happen in the future.  I suspect I was only able to re-send a portion of 
the missing messages, so my apologies for anyone who posted a message that 
didn't make it to a list.  Also, my apologies to everyone who has to deal 
with the increased traffic of the old messages, plus current messages, 
plus the inevitable onslaught of re-posts that will occur in the next few 
days.  Please be patient with each other.

So the good news was: problem found, problem fixed, some catch up done, 
shouldn't happen again.

The bad news is that this morning (roughly 7am PST), a construction crew 
near Fat City cut through a section of telecom cable that was critical for 
our connection to the net.  They've been working feverishly on it all day, 
but Fat City was off the net most of the day.  Until about 3pm PST.  I 
believe things are about back to normal right now, but there's always a 
ramp-up time to truly get back to normal.  My apologies to anyone who was 
affected by our downtime.

If you have any questions or concerns about anything, please let me know.

Thanks,
Bruce Bergman
ListMaster, Fat City Hosting
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bruce A. Bergman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Any comments on Open Source Projects for Oracle ?

[Hemant K Chitale]

OTN has published a list of Oracle Open Source Projects at
http://otn.oracle.com/tech/opensource/projects.html


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Host concurrent program whom call ar60runb

[Hemant K Chitale]

Does your TEST.prog include the environment for ar60runb ?
If it runs as a shell script, does it have $ORACLE_HOME, and $PATH
setup correctly ?
Hemant
At 07:09 AM 21-01-04 -0800, you wrote:
Hi Listers,

I'have registered host concurrent program on Oracle
11.5.9 as TEST.prog which include one line to execute
the ar60runb on command line. Unfortunately this is
does not work for me. The problem is the TEST.prog can
execute any other command or script (shell, Perl,...)
but not ar60runb which I can execute independently.
Could you please help to resolve this problem?

Thanks,

Ben

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kader Ben
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Re: pga_aggregate_target -- actual values from my database

[Hemant K Chitale]

end the HELP command for other information (like
subscribing).

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 05-Jan-04}


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

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

RE: full recovery

[Hemant K Chitale]

: http://www.orafaq.net
 --
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you 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.net
--
Author: Rich Holland
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Anyone using IBM's Flashcopy for hotbacks?

[Hemant K Chitale]

We have been using Hitachi and EMC SANs.
The procedure is
1.  Issue BEGIN BACKUP commands for *ALL* the Tablespaces
2.  Use the SAN's commands to split the ShadowImage or FlashCopy for 
the DataFiles FileSystems
3.  Issue END BACKUP commands
4.  Issue an ARCHIVELOG CURRENT command [and we also BACKUP CONTROLFILE to 
the ArchiveLog FileSystem]
5.  split the ArchiveLog FileSystem
6.  Backup the split images of the DataFiles and ArchiveLogs
-- Here I believe that it depends on whether use a SnapShot or SnapClone.
If you use a SnapClone [ie an exact duplicate of the data is made available,
also called ShadowImage  or BCV], you'd have to wait till you backup this
complete SnapClone before you proceed to the next step.
If you use a SnapShot [ie the storage retains metadata information and maps
all changed blocks], you can drop the SnapShot after completing the backup.
6.  ReSync/Resilver the image.

The active database is continuously available.  The ALTER SYSTEM SUSPEND
command in Oracle will actually freeze all I/O.
Check with IBM about how I/O to disk is completed when you split the images.
The Storage must guarantee that all I/O has been completed against the 
SnapClone
image before the command returns to your script which then issues END 
BACKUP commands.
The Storage provider should be providing templates of the command scripts
where you can plug-in your Oracle ALTER ... commands.

Hemant

For information on SnapShot and SnapClone see

http://searchstorage.techtarget.com/infoCenter/askTheExpertsAnswer/0,294272,sid5_gci938037_tax294583,00.html

Hemant
At 02:39 PM 15-01-04 -0800, you wrote:
We're considering an IBM FAStT SAN for a 30GB Oracle9i DB on HP/UX 11i.  One
option with the FAStT is called FlashCopy.  It's been six months since
I've last looked at this, but our original idea was to smack all TSs into
backup mode, FlashCopy, then smack all TSs out of backup mode.  We'd also
need to dump the copy to tape, then startup this copy as another instance,
so the Tivoli plugin to have RMAN manage this probably wouldn't be worth the
money for us.
So, has anyone done this?  Which FlashCopy options did you use?  Any major
gotchas to not do this?  Does the Flash cause I/O problems during the backup
due to the block reads from the original DB?
TIA,
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ** OCP for 9i requirements -- Instructor Led Class is a

[Hemant K Chitale]

Sure.
Read 
Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience
- with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant
investment in its Certification Program. Three distinct changes are being
rolled out with the goal of increasing the level of quality of our
certification skill and ability benchmarks: 
·Scenario-based
testing in all Oracle9i DBA Certified Professional exams . 
·Instructor-led
class requirement for candidates starting on the Oracle9i DBA Certified
Professional credential exam path. 
·A
new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential. 

at
http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
Instructure-led class is a requirement.
You CAN take the Online Training to _prepare_ for the Exams. But
you MUST attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:
why dont
you just read what is on the oracle website?

www.oracle.com

do a search for certification. 

- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, January 13, 2004 9:34 AM
Subject: Re: ** OCP for 9i requirements


Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ? I thought that
the pre-requisite is at least one Instructor Led
Training.

Hemant
At 12:04 AM 13-01-04 -0800, you
wrote:
At 06:14 PM 1/12/2004, Ryan
wrote:
www.oracle.com

do a search for certification. Its all explained there. You can take
an online course for $300. If your company is an oracle partner the
course is free. 
My understanding is that you need to take a class that corresponds to
one of the four OCP exams, which are all 5-day classes. The
in-classroom versions run $2500 and the on-line versions run $1250.
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).

http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html

Justin Cave 
- Original Message - 
From: A Joshi 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM 
Subject: ** OCP for 9i requirements

Hi, 
 For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum? Is any
small course good enough? Can someone who has gone through this provide
details? Thank you



Do you Yahoo!? 
Yahoo! Hotjobs:
Enter
the Signing Bonus Sweepstakes 
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
 {last updated 05-Jan-04}
-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 05-Jan-04}


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

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

Re: Import foibles

[Hemant K Chitale]

 that one used a long column for text and
the other used a varchar2(4000).
The long table took 90 seconds to load with imp and committed every 4.5
blocks.
The varchar2 table took 9 seconds to load and committed every 1000 blocks.

This is know doubt old hat to many of you, but it's the first time I can
recall encountering this.  Don't
really use imp too much.
The fact that writes on this system are *so* slow is what made it worth
investigating.
This 1 gig file took 10 hours to load.  On our speedy linux dev box with
fast IO it took quite
awhile, though I'm not going to run it again to get the exact timing. And
that without indexes
or constraints.
It's sqlloader from now on.

Jared



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ** OCP for 9i requirements

[Hemant K Chitale]

Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ? I thought that
the pre-requisite is at least one Instructor Led
Training.
Hemant
At 12:04 AM 13-01-04 -0800, you wrote:
At 06:14 PM 1/12/2004, Ryan
wrote:
www.oracle.com

do a search for certification. Its all
explained there. You can take an online course for $300. If your company
is an oracle partner the course is free. 
My understanding is that you need to take a class that corresponds to one
of the four OCP exams, which are all 5-day classes. The
in-classroom versions run $2500 and the on-line versions run $1250.
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html
Justin
Cave

- Original Message - 
From: A Joshi 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM
Subject: ** OCP for 9i requirements

Hi,
 For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum? Is any
small course good enough? Can someone who has gone through this provide
details? Thank you


Do you Yahoo!?
Yahoo! Hotjobs:
Enter
the Signing Bonus Sweepstakes


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 05-Jan-04}


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

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

Curious ORA-942 on DataDict Views in 8.1.7 with

[Hemant K Chitale]

Two custom views [DDFS_TOTAL on DBA_DATA_FILES, 
and FSH_TOTAL on DBA_FREE_SPACE] 
which I  create in the DBSNMP schema are now failing with 
ORA-00942 after having set O7_DICTIONARY_ACCESSIBILITY=FALSE. 
The database is 8.1.7.4 32-bit on Solaris8. 
These views used to work with O7_DICTIONARY_ACCESSIBILITY=TRUE
For example, the query on DBA_DATA_FILES works. I only get the ORA-942
when I use the 
query inside a CREATE VIEW. [see below]
Also, a Trace file for 
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [],

[], [] 
Current SQL statement for this session: 
SELECT * FROM DBSNMP.DDFS_TOTAL
is generated in the user_dump_dest for each of such databases the first

time the automated scripts which create the view and then generate
reports are run after 
setting O7_DICTIONARY_ACCESSIBILITY=FALSE
{The reason why I use the views DDFS_TOTAL and FSH_TOTAL is that I have a
generic set of 
scripts working from 7.3.4 to 9.2.0 so I am not using some of the
advanced In-Line views}.
Other 8.0 to 8.1.7 instances with
O7_DICTIONARY_ACCESSIBILITY=TRUE.
9.2 instances work with O7_DICTIONARY_ACCESSIBILITY=FALSE.
However, the difference in 9.2 instances is that DBSNMP has the SELECT
ANY DICTIONARY
Privilege while in the 8.1.7 and below instances, DBSNMP has the
SELECT_CATALOG_ROLE Role.
{The SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY grants to DBSNMP
are my own extensions run manually after
catsnmp.sql}
These are my View Definitions :
REM These views are created in the
remote (monitored) database
create or replace view fsh_total (tablespace_name, free_size, date_stamp)

as 
select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)

from dba_free_space 
group by tablespace_name, trunc(sysdate);
create or replace view ddfs_total (tablespace_name, total_size) 
as 
select tablespace_name, sum(bytes/1024/1024) 
from dba_data_files 
where status = 'AVAILABLE' 
group by tablespace_name;
rem spool off
rem Do NOT put an EXIT as this script is called by FREE_SPACE_WARN !!

rem 

See below [8.1.7.4 32-bit on Solaris 8] for the Errors I get 
:
SQL show user 
USER is DBSNMP 
SQL select granted_role from dba_role_privs where grantee =
'DBSNMP';
GRANTED_ROLE 
-- 
CONNECT 
RESOURCE 
SELECT_CATALOG_ROLE 
SNMPAGENT
SQL select privilege from dba_sys_privs where grantee =
'DBSNMP';
PRIVILEGE 
 
CREATE ANY DIRECTORY 
CREATE DATABASE LINK 
CREATE PUBLIC SYNONYM 
CREATE SESSION 
DROP ANY DIRECTORY 
SELECT ANY TABLE 
UNLIMITED TABLESPACE
7 rows selected.
SQL show user 
USER is DBSNMP
SQL l 
1 select tablespace_name, sum(bytes)/1024/1024 free_size, 
trunc(sysdate) 
2 from dba_free_space 
3* group by tablespace_name, trunc(sysdate) 
SQL /
TABLESPACE_NAME FREE_SIZE TRUNC(SYSDATE) 
-- -- --

PLUMINDEX 717.554688 January 12 2004 00:00:00 
PLUMTABLE 421.128906 January 12 2004 00:00:00 
RBS 219.527344 January 12 2004 00:00:00 
SYSDEFLT 149.019531 January 12 2004 00:00:00 
SYSTEM 116.25 January 12 2004 00:00:00 
TEMP 199.996094 January 12 2004 00:00:00
6 rows selected.
SQL l 
1 create or replace view fsh_total (tablespace_name, free_size,
date_stamp) 
2 as 
3 select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)

4 from dba_free_space 
5* group by tablespace_name, trunc(sysdate) 
SQL / 
from dba_free_space 
* 
ERROR at line 4: 
ORA-00942: table or view does not exist
SQL l4 
4* from dba_free_space 
SQL c/dba/sys.dba 
4* from sys.dba_free_space 
SQL / 
from sys.dba_free_space 
* 
ERROR at line 4: 
ORA-00942: table or view does not exist
SQL l 
1 create or replace view fsh_total (tablespace_name, free_size,
date_stamp) 
2 as 
3 select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)

4 from sys.dba_free_space 
5* group by tablespace_name, trunc(sysdate) 
SQL del 1 
SQL l 
1 as 
2 select tablespace_name, sum(bytes)/1024/1024 free_size, 
trunc(sysdate) 
3 from sys.dba_free_space 
4* group by tablespace_name, trunc(sysdate) 
SQL del 1 
SQL l 
1 select tablespace_name, sum(bytes)/1024/1024 free_size, 
trunc(sysdate) 
2 from sys.dba_free_space 
3* group by tablespace_name, trunc(sysdate) 
SQL /
TABLESPACE_NAME FREE_SIZE TRUNC(SYSDATE) 
-- -- --

PLUMINDEX 717.554688 January 12 2004 00:00:00 
PLUMTABLE 421.128906 January 12 2004 00:00:00 
RBS 219.527344 January 12 2004 00:00:00 
SYSDEFLT 149.019531 January 12 2004 00:00:00 
SYSTEM 116.25 January 12 2004 00:00:00 
TEMP 199.996094 January 12 2004 00:00:00
6 rows selected.
SQL 

Of course, I resolved the issue with GRANT SELECT ON
DBA_FREE_SPACE to DBSNMP.


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 05-Jan-04}


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

Fat City Network Services-- 858-538-5051 http

Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

[Hemant K Chitale]

Yes, I hadn't read the line
so the tablespaces had to be put into backup mode or (8i and after) the 
database had to be suspended
you _do_ have an OR between the backup mode and the database .. suspended.

We hadn't heard of anyone using the SUSPEND and didn't want to take the chance
of a database seeming to be frozen for a few seconds or upto a minute 
{weren't sure
how long the split would actually take to run before we implemented it}.
We'll stick to putting the tablespaces in BACKUP mode.

Hemant

At 09:34 PM 09-01-04 -0800, you wrote:
I should have expressed myself more clearly. Suspend is not necessary, 
it's only fast. Basically,
with suspend, you don't put tablespaces into backup mode. You suspend, 
resync, split
and start aonther instance as if  it crashed.  As no I/O is going to disk, 
datafiles aren't
fuzzy, so no recovery is needed. Problem with this approach is that the 
original instance
is not usable during this time. All sessions are hanging. Benefit is that 
no recovery is
needed and if everything goes OK, you're done very, very quickly. It's 
either-or approach,
not a combination.

On 2004.01.10 00:09, Hemant K Chitale wrote:

 Mladen,
 Is the ALTER SYSTEM SUSPEND  really necessary.

 We've just implemented SnapClone mechanims for three Oracle DBs on
 Hitachi and EMC SANs,  We've been told that only ALTER TABLESPACE ... 
BEGIN
 BACKUP
 is necessary.
 What we do is
 1.  Issue an ALTER TABLESPACE ... BEGIN BACKUP for all the tablespaces
 2.  split the image for the /oradata? filesystems
 3.  Issue an ALTER SYSTEM ARCHIVELOG CURRENT {and also ALTER DATABASE
 BACKUP CONTROLFILE TO ..}
 4.  split the image for the /archlogs filesystem {for the archivelogs 
and
 the controlfile backup}
 5.  Backup the split /oradata? and /archlogs filesystems
 6.  ReSynch


 At 07:24 PM 09-01-04 -0800, you wrote:
 Let me explain, because I have a little bit of experience with it.
 a) BCV's are replicated disks which are synchronized using TimeFinder.
  and then separated from the source.  The phrase splitting BCV's 
means
  producing an exact disk copy of the original disks, similarly to 
what
  dd can
  do. It's an ideal way to make a copy of an instance.  Last time I
  checked,
  BCV's weren't supported by RMAN (it may have changed now), so the
  tablespaces had to be put into backup mode or (8i and after) the 
database
  had to be suspended (very litle known trick is ALTER SYSTEM 
SUSPEND,
  which abruptly ceases all the I/O in the database, without shutting
  it down).
 b) RMAN is an oracle tool which works in conjunction with Legato (EMC),
 NetBackup(Veritas),
  Tivoli, Alexandria or SyncSort backups. RMAN doesn't know how to
  write to tape and needs
   a 3rd party backup to do so. The part  that Veritas, Legato or IBM
  will charge you for is
   called libobk.so and is an interface which enables RMAN to work 
with
  their particular tool.
   RMAN is a very good tool which can do many things in a very easy 
way
  and without
  generating a TB of redo archives for the duration of hot backup 
mode.
  Robert Freeman's
  book is definitely the best source for anything RMAN around.
 

 Hemant K Chitale
 Oracle 9i Database Administrator Certified Professional
 http://hkchital.tripod.com  {last updated 05-Jan-04}


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

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


--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego

re BCV / SnapShot / SnapClone and the ALTER SYSTEM SUSPEND --

[Hemant K Chitale]

Mladen,
Is the ALTER SYSTEM SUSPEND  really necessary.
We've just implemented SnapClone mechanims for three Oracle DBs on
Hitachi and EMC SANs,  We've been told that only ALTER TABLESPACE ... BEGIN 
BACKUP
is necessary.
What we do is
1.  Issue an ALTER TABLESPACE ... BEGIN BACKUP for all the tablespaces
2.  split the image for the /oradata? filesystems
3.  Issue an ALTER SYSTEM ARCHIVELOG CURRENT {and also ALTER DATABASE 
BACKUP CONTROLFILE TO ..}
4.  split the image for the /archlogs filesystem {for the archivelogs and 
the controlfile backup}
5.  Backup the split /oradata? and /archlogs filesystems
6.  ReSynch

At 07:24 PM 09-01-04 -0800, you wrote:
Let me explain, because I have a little bit of experience with it.
a) BCV's are replicated disks which are synchronized using TimeFinder.
and then separated from the source.  The phrase splitting BCV's means
producing an exact disk copy of the original disks, similarly to what 
dd can
do. It's an ideal way to make a copy of an instance.  Last time I 
checked,
BCV's weren't supported by RMAN (it may have changed now), so the
tablespaces had to be put into backup mode or (8i and after) the database
had to be suspended (very litle known trick is ALTER SYSTEM SUSPEND,
which abruptly ceases all the I/O in the database, without shutting 
it down).
b) RMAN is an oracle tool which works in conjunction with Legato (EMC), 
NetBackup(Veritas),
Tivoli, Alexandria or SyncSort backups. RMAN doesn't know how to 
write to tape and needs
 a 3rd party backup to do so. The part  that Veritas, Legato or IBM 
will charge you for is
 called libobk.so and is an interface which enables RMAN to work with 
their particular tool.
 RMAN is a very good tool which can do many things in a very easy way 
and without
generating a TB of redo archives for the duration of hot backup mode. 
Robert Freeman's
book is definitely the best source for anything RMAN around.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Apps 11.5.9 D.R. Site -- MetaLink Note 216212.1 ??

[Hemant K Chitale]

There seems to be Note 216212.1 titled Disaster Recovery and the 
E-business Suite
Has anyone used this note ?

{Although I am familiar with 11.5.3, the last time I worked on 11i was more 
than two years ago,
so I am not in touch with 11i , although I do manage an 11.0.3 instance now}

Hemant

At 03:34 PM 30-12-03 -0800, you wrote:
I've been charged with bringing up a disaster recovery site, so time to 
hit the books again as a lot
has changed since the last time I did this. Looking for resource 
recommendations (FM to read, white
papers, etc).

Sticky part of this is it is an Applications 11.5.9 installation.  The 
database end of it should not
be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications file 
system is modified by the
adpatch utility which adpatch requires a database connection to 
function.  I can think of 2 ways to
get around this requirement.
1. set the two_task to point to a live test system, and run adpatch force 
using the c and g drivers.
The d driver would not need to be run since the changes will come over via 
the archive logs.
2. ignore adpatch utility completely and use rsync.

Suggestion, comments?

Thanks,.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Thomas
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

[Hemant K Chitale]

Hmm. Yes, I think I need to look at _row_cache_cursors. 

I do have a number of objects being pinned but rather than using the
$AD_TOP scripts I use queries
on V$DB_OBJECT_CACHE to identify frequenty executed
procedures.
Hemant
At 12:54 AM 02-12-03 -0800, you wrote:
Hi!

Low _row_cache_cursors might be causing some of
soft parses you have, especially with Apps where we have lots of complex
PL/SQL and really lots of different objects.
Maybe you should increase your
_row_cache_cursors parameter, but check
http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm
first.

Also, have you thought about pinning frequently used-objects. This script: $AD_TOP/sql/ADXCKPIN.sql should give you a list of objects you should pin (You can use $AD_TOP/sql/ADXGNPIN.sql and ADXSPPNS.sql for generating the pinning scripts afterwards).

Tanel.


- Original Message - 
From: Hemant K Chitale 
To: Multiple recipients of list ORACLE-L 
Sent: Monday, December 01, 2003 5:14 PM
Subject: Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute 


CURSOR_SPACE_FOR_TIME is FALSE.

This is an Oracle Apps R11 install.

Hemant
At 05:29 AM 30-11-03 -0800, you wrote:
What's the value for your cursor_space_for_time parameter?

Tanel.
 
- Original Message - 
From: Hemant K Chitale 
To: Multiple recipients of list ORACLE-L 
Sent: Sunday, November 30, 2003 8:54 AM 
Subject: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute 



I have taken SESSION_CACHED_CURSORS from 0 to 100 to 400. On occassion I still see 
very high LIBRARY CACHE LATCH contention and am considering upping the value again. 
Currently, I set it at the Instance level. Since I am running Oracle Apps, I have suggested 
to the application team to put a custom ALTER SESSION trigger into the specific first 
responsibility form for users who do navigate between forms a lot and where we see 
high contention. 
Running Steve Adams's query, I get 
SQL @Session_Cursor_Cache.sql 

PARAMETER VALUE USAGE 
- - - 
session_cached_cursors 400 50% 
open_cursors 1024 36%



CURSOR_CACHE_HITS SOFT_PARSES HARD_PARSES 
- --- --- 
 35.10% 63.09% 1.81%



MAX_CACHEABLE_CURSORS 
- 
 5227

Running StatsPack during a PEAK period and then analyzing the output at oraperf.com, I get : 
33409 parses (673 hard parses), 498516 executions of SQL statements happened. Normally the number of parses should be low and executions should be high. Each cursor was parsed an average of 1.31 times. A value greater than 1, means that the same cursor is parsed more than once. A value lower than 1 means that not all opened cursors have been parsed yet. Parsing the same cursor again and again will consume CPU and other resources. There is no need to parse the same cursor again for each execute. The re-parsing normally happens becomes some applications have an build in cursor cache which is configured too small. Making the cursor cache in the application larger will reduce the reparsing. During this interval 508 sessions logged on and at the end of the timing interval 0 more sessions where active. 

The init.ora parameter SESSION_CACHED_CURSORS has been set. This resulted in reducing the parse count from 32736 to 22550 
During parsing 276280 msec of CPU were used and 1134430 msec was spent waiting on resources. This will most likely will be latch contention on 'library cache' latch 
96% of the latch wait time is on the Library Cache Latch [85% of the Response Time was Wait Time, 71% of the Wait Time 
was Latch Wait time and 96% of the Latch Wait Time was Library Cache Latch, . this Wait Time analysis really 
does make sense !]
Hemant 
At 10:14 PM 29-11-03 -0800, you wrote: 
I thought the session_cached_cursors is dynamic and scope is 
session? This is on 8.1.7. I have used:

alter session set session_cached_cursors=500;

-Original Message- 
Sent: Sunday, November 30, 2003 12:24 AM 
To: Multiple recipients of list ORACLE-L





Sami,

'cached_cursors' is not a valid hint, at least not in 9i.

Or at least, I can find no reference to it.

And 'cached cursors' as it appears in the SQL is not a 
valid hint syntax. 
You need to set the session_cached_cursors value in the 
init.ora, and bounce the database. This parameter cannot 
be set dynamically, at least as of 9i.

Jared

On Sat, 2003-11-29 at 14:44, Sami wrote: 
 Dear Jonathan Lewis, 
 
 Many thanks for your response. 
 
 Using session_cached_cursor parameter I am not getting better response time. 
 I did run this testcases multiple times but always session_cached_cursor=0 
 gives better response time. 
 But the same time w.r.t latch, session_cached_cursor=100 is giving positive 
 impact. 
 
 1) session_cached_cursor=0 - more latches but good response time(2.60) 
 2) session_cached_cursor=100 - less # of latches but higher response 
 time(2.87) 
 
 Version :8.1.7.3 
 OS: Sun Solaris 
 
 tkprof output 
 = 
 SELECT /*+ cached cursors 0 
 */FIRST_NAME,LAST_NAME

Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

[Hemant K Chitale]

CURSOR_SPACE_FOR_TIME is FALSE.
This is an Oracle Apps R11 install.
Hemant
At 05:29 AM 30-11-03 -0800, you wrote:
What's
the value for your cursor_space_for_time parameter?

Tanel.


- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Sunday, November 30, 2003 8:54 AM
Subject: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute 



I have taken SESSION_CACHED_CURSORS from 0 to 100 to 400. On
occassion I still see
very high LIBRARY CACHE LATCH contention and am considering upping
the value again.
Currently, I set it at the Instance level. Since I am running
Oracle Apps, I have suggested
to the application team to put a custom ALTER SESSION trigger into
the specific first
responsibility form for users who do navigate between forms a lot and
where we see
high contention.
Running Steve Adams's query, I 
get
SQL @Session_Cursor_Cache.sql 

PARAMETER
VALUE USAGE
- - -
session_cached_cursors
400 50%
open_cursors
1024 36%


CURSOR_CACHE_HITS SOFT_PARSES HARD_PARSES
- --- ---

35.10%
63.09% 1.81%


MAX_CACHEABLE_CURSORS
-

5227

Running StatsPack during a PEAK period and then analyzing the output
at oraperf.com, I get :
33409 parses (673 hard parses), 498516 executions of SQL statements
happened. Normally the number of parses should be low and executions
should be high. Each cursor was parsed an average of 1.31 times. A value
greater than 1, means that the same cursor is parsed more than once. A
value lower than 1 means that not all opened cursors have been parsed
yet. Parsing the same cursor again and again will consume CPU and other
resources. There is no need to parse the same cursor again for each
execute. The re-parsing normally happens becomes some applications have
an build in cursor cache which is configured too small. Making the cursor
cache in the application larger will reduce the reparsing. During this
interval 508 sessions logged on and at the end of the timing interval 0
more sessions where active. 

The init.ora parameter SESSION_CACHED_CURSORS has been set. This
resulted in reducing the parse count from 32736 to 22550

During parsing 276280 msec of CPU were used and 1134430 msec was
spent waiting on resources. This will most likely will be latch
contention on 'library cache' latch

96% of the latch wait time is on the Library Cache Latch [85% of the
Response Time was Wait Time, 71% of the Wait Time
was Latch Wait time and 96% of the Latch Wait Time was Library Cache
Latch, . this Wait Time analysis really
does make sense !]

Hemant

At 10:14 PM 29-11-03 -0800, you
wrote:
I thought the session_cached_cursors is dynamic and scope is
session? This is on 8.1.7. I have used:

alter session set session_cached_cursors=500;

-Original Message-
Sent: Sunday, November 30, 2003 12:24 AM
To: Multiple recipients of list ORACLE-L



Sami,

'cached_cursors' is not a valid hint, at least not in 9i.

Or at least, I can find no reference to it.

And 'cached cursors' as it appears in the SQL is not a
valid hint syntax.
You need to set the session_cached_cursors value in the
init.ora, and bounce the database. This parameter cannot
be set dynamically, at least as of 9i.

Jared

On Sat, 2003-11-29 at 14:44, Sami wrote:
 Dear Jonathan Lewis,
 
 Many thanks for your response.
 
 Using session_cached_cursor parameter I am not getting better
response time.
 I did run this testcases multiple times but always
session_cached_cursor=0
 gives better response time.
 But the same time w.r.t latch, session_cached_cursor=100 is
giving positive
 impact.
 
 1) session_cached_cursor=0 - more latches but good response
time(2.60)
 2) session_cached_cursor=100 - less # of latches but higher
response
 time(2.87)
 
 Version :8.1.7.3
 OS: Sun Solaris
 
 tkprof output
 =
 SELECT /*+ cached cursors 0
 */FIRST_NAME,LAST_NAME,CUSTOMERID,COUNTRYABBREV
 FROM T1 P,T2 E,T3 C WHERE P.T1ID =
E.T1ID AND P.BUSINESS_COUNTRY_ID =
 C.COUNTRYABBREV
 
 
 call
count cpu
elapsed
disk query current
 rows
 --- --  -- --
-- --
 --
 Parse
2000
1.76
1.77
0
0 0
 0
 Execute 2000
0.84
0.74
0
0 0
 0
 Fetch
0 0.00
0.00
0
0 0
 0
 --- --  -- --
-- --
 --
 total
4000
2.60
2.51
0
0 0
 0
 
 Misses in library cache during parse: 0
 Optimizer goal: CHOOSE
 Parsing user id: 165 (recursive
depth: 1)
 
 Rows Row Source Operation
 ---
---
 0 HASH JOIN
 0 INDEX
FAST FULL SCAN (object id 76648)
 0 HASH
JOIN
 0
TABLE ACCESS FULL T2
 0
TABLE ACCESS FULL T1
 
 
 
 
 SELECT /*+ cached cursors 100
*/FIRST_NAME,LAST_NAME,CUSTOMERID,
 COUNTRYABBREV
 FROM T1 P,T2 E,T3 C WHERE P.T1ID =
E.T1ID AND P.BUSINESS_COUNTRY_ID =
 C.COUNTRYABBREV
 
 
 call
count cpu
elapsed
disk query current
 rows
 --- --  -- --
-- --
 --
 Parse

SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

[Hemant K Chitale]

 ---
---
 0 HASH JOIN
 0 INDEX FAST
FULL SCAN (object id 76648)
 0 HASH
JOIN
 0 TABLE
ACCESS FULL T2
 0 TABLE
ACCESS FULL T1
 
 


 
 
 Program used to generate the above trace file.
 ==
 
 alter session set SQL_TRACE=true;
 alter session set session_cached_cursors=0;
 declare
 type rc is ref cursor;
 C rc;
 n number :=0;
 begin
 n := dbms_utility.get_time;
 for i in 1 .. 2000 loop
 open C for select
/*+ cached cursors 0 */
 first_name,last_name,customerid,countryabbrev from t1 p,t2 e,t3 c
where
 p.t1id=e.t1id and p.business_country_id=c.countryabbrev;
 close C;
 end loop;
 dbms_output.put_line( dbms_utility.get_time - n );
 end;
 /
 alter session set session_cached_cursors=100;
 declare
 type rc is ref cursor;
 C rc;
 n number :=0;
 begin
 n := dbms_utility.get_time;
 for i in 1 .. 2000 loop
 --open C for select
/*+ cached_cursors 100 */ * from dual;
 open C for select
/*+ cached cursors 100 */
 first_name,last_name,customerid,countryabbrev from t1 p,t2 e,t3 c
where
 p.t1id=e.t1id and p.business_country_id=c.countryabbrev;
 close C;
 end loop;
 dbms_output.put_line( dbms_utility.get_time - n );
 end;
 /
 
 
 SQL @x
 
 Session altered.
 Session altered.
 
 394
 
 PL/SQL procedure successfully completed.
 Session altered.
 
 413
 
 PL/SQL procedure successfully completed.
 SQL
 
 

Name
Run1 Run2
Diff
 LATCH.KCL lock element
parent
1
2 1
 LATCH.KCL name table
latch
1
2 1
 LATCH.cache buffers lru
chain
1
2 1
 STAT...calls to
kcmgas
2
1 -1
 STAT...redo ordering
marks
2
1 -1
 STAT...free buffer
requested
2
1 -1
 LATCH.checkpoint queue
latch
113
114 1
 LATCH.list of block
allocation
0
1 1
 LATCH.dlm domain lock table
la
0
2 2
 LATCH.name-service namespace
b
17
19 2
 LATCH.name-service request
que
17
19 2
 LATCH.redo
writing
4
6 2
 STAT...redo
entries
26
28 2
 LATCH.dlm group lock table
lat
0
2 2
 STAT...calls to
kcmgcs
17
20 3
 LATCH.dlm lock table freelist
12,000
12,004 4
 LATCH.session
allocation
15
19 4
 LATCH.enqueue hash
chains
0
4 4

LATCH.enqueues
0
4 4
 LATCH.dlm resource hash list
24,000
24,005 5
 LATCH.process parent latch
30,000
30,005 5
 STAT...consistent
gets
34
39 5
 LATCH.redo
allocation
30
25 -5
 STAT...db block
gets
64
70 6
 STAT...consistent
changes
60
68 8
 LATCH.undo global
data
23
14 -9
 STAT...db block
changes
88
97 9
 LATCH.dlm resource table freel
6,026
6,037 11
 STAT...session logical
reads
98
109 11
 STAT...parse time
cpu
57
83 26
 STAT...parse time
elapsed
58
85 27

LATCH.messages
200
236 36
 STAT...recursive cpu
usage
220
256 36
 LATCH.cache buffers
chains
404
327 -77
 STAT...redo
size
4,304 4,500
196
 STAT...session cursor cache co
-99
100 199
 LATCH.shared
pool
14,002 8,002 -6,000
 LATCH.library
cache
94,232 79,824 -14,408
 
 Run1 latches total versus runs -- difference and pct
 Run1
Run2 Diff Pct
 181,088 160,677 -20,411 112.70%
 
 
 -- 
 Please see the official ORACLE-L FAQ:
http://www.orafaq.net
 -- 
 Author: Sami
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- 858-538-5051
http://www.fatcity.com
 San Diego, California --
Mailing list and web hosting services

-
 To REMOVE yourself from this mailing list, send an E-Mail
message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you 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.net
-- 
Author: Jared Still
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
-- 
Author: Richard Ji
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


-- 
Please see

When / why we resize/clean the temporary tablespace -- was RE:

[Hemant K Chitale]

Not exactly correct.  It is 1 single segment, with multiple extents.  The 
extents
are reused.  The segment is never dropped-and-recreated unless you
  (a) Stop and start the database instance [it is then created on the 
first request
for a temporary segment]
  (b) If it is NOT a TEMPORARY Tablespace but a Tablespace .. TEMPORARY,
you issue an ALTER TABLESPACE ... DEFAULT STORAGE ... command

Now why should we worry about the Temporary Segment ?
Of the 60 odd databases I have there are 2 databases [on in 8.1.7 where I am
not using a TEMPORARY TABLESPACE but a TABLESPACE .. TEMPORARY,
and therefore, I can use the ALTER TABLESPACE .. DEFAULT STORAGE ... command
and the other in 9.2 where I am using a TEMPORARY TABLESPACE with TEMPFILEs]
where at least once a month the Tablespace which is usually 2GB [and 400MB 
used] goes to 8GB
[or, as I found in a third 9.2 database this week 24GB], the file system is 
full
and users may start getting errors.  Now, the Unix Administrator does have 
a CRON job
checking all the file systems of his 200+ servers, once-an-hour, I have a 
CRON job checking all
the tablespaces of the 60 databases every hour but it takes much less than an
hour for some user writing a wonderful SQL query to take Temporary 
Tablespace
out from 2GB to 8GB [or 24GB !].
It is in those cases, that I need to know how to bring my Temporary 
Tablespace usage
down.
{Of course, I do know that if that wonderful SQL query user has exited, then
he has released all the 8GB or 24GB of extents but my Unix administrator
asks me why I am using so much space and what he should do about the alerts
that the filesystem is 90+% full.  If I keep the MAXSIZE of the files too low,
it is quite likely that more than one user gets errors trying to allocate 
extents while the
wonderful SQL query user is still around in the database}.

I also issue the ALTER TABLESPACE ... DEFAULT STORAGE .. command in the
daily backup job to drop the Temporary segment when it is not in use.
Yes, there is a cost associated with reallocating extents but this is only 
once a day.
If the NEXT is appropriate sized, few user sessions would be allocating 
more than
one or two new extents the first time round.

Hemant

At 10:09 AM 14-11-03 -0800, you wrote:
[EMAIL PROTECTED]  scribbled on the wall in glitter crayon:

 I got the impression that the poster was thinking segments allocated
 in temp tablespace must be released, cleaned out, blown away, etc.
 before something else can come along and use the space.
i was always under the impression that you didn't need to do anything to the
temp tablespace.  that the segments were just reused as needed.  am i behind
the times here?
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Shift to the left!  Shift to the right!  Pop up, push down, byte, byte,
byte!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thater, William
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Clean temporary tablespace

[Hemant K Chitale]

I have been using this method in all my 8.0 and 8.1 databases.
Unfortunately, if it is a TEMPORARY Tablespace with a TEMPFILE,
[as I have begun using in 9.2] this command fails.
Then, the only option to either resize the TEMPFILE or resize the  TEMPORARY
Segment is to drop and recreate the TEMPORARY Tablespace as
I have outlined in another email.
Hemant

At 03:54 PM 13-11-03 -0800, you wrote:
8.1.6.3
SQL select status,contents,extent_management,allocation_type from
dba_tablespaces where tablespace_name='TEMP';
Extent
STATUSCONTENTS  Management ALLOCATIO
- - -- -
ONLINETEMPORARY DICTIONARY USER
SQL alter tablespace TEMP default storage(pctincrease 0);

Tablespace altered.

SQL

This will force the SMON to wake up and coalesce those segments which
have been
used but not freed. This will work if you are using DICT.Managed temp
tablespaces.
I have been using it regularly with results.
HTH
GovindanK
On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED]
said:
 Hello!

 How can I clean temporary tablespace? It grows up faster and faster.

 --
 ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit)
 Oracle 9i DBA beginner
--
http://www.fastmail.fm - Sent 0.02 seconds ago
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GovindanK
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Clean temporary tablespace

[Hemant K Chitale]

Or you can
1. Create another Temporary Tablespace with CREATE TEMPORARY TABLESPACE 
new_temporary_tablespace
TEMPFILE . SIZE ... AUTOEXTEND ON NEXT .. MAXSIZE ...
2.  Issue ALTER USER TEMPORARY TABLESPACE new_temporary_tablespace commands
3.  If running 9.2 with a Default Temporary Tablespace, ALTER DATABASE 
DEFAULT TEMPORARY TABLESPACE new_temporary_tablespace
4.  Check that there are no active sessions still using the existing 
Temporary Tablespace, querying V$SORT_SEGMENT
and also use the Unix fuser command against the Temporary Tablespace 
Tempfiles
5.  DROP TABLESPACE current_temporary_tablespace INCLUDING CONTENTS [add 
AND DATAFILES if using 9.2]
Note : Ensure that you really have no segments in the tablespace other than 
the temporary segment [ie, it is really
a temporary tablespace ! because the DROP TABLESPACE command syntax 
doesn't specify if it is a TEMPORARY
or PERMANENT tablespace]
6.  Recreate your original Temporary Tablespace
7. Run through Steps 2 and 3 again to revert to the original Temporary 
Tablespace
8. Run Steps 4 and 5 to drop the new_temporary_tablespace

Because, bouncing or restarting the Database Instance isn't always an 
available option!

Hemant
At 12:05 AM 12-11-03 -0800, you wrote:
Hi,

Restartup your database if possible.

If you set the datafile autoextent on then you have to recreate that 
tablespace,
if you set it to not autoextent on for some query may fail due to not 
enough sorting space.

Sinardy

-Original Message-
Sent: 12 November 2003 14:24
To: Multiple recipients of list ORACLE-L
Hello!

How can I clean temporary tablespace? It grows up faster and faster.

--
ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit)
Oracle 9i DBA beginner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VirVit
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: Sinardy Xing
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sequences CYCLEing -- was RE: How do you genrate primary

[Hemant K Chitale]

So, let's start another thread.

How many of you have actually seen Sequences implemented in the manner I 
described
and Mladen demonstrated below ?

Hemant

At 08:24 AM 08-11-03 -0800, you wrote:
Being sort of DBA Doubting Tom, I have a bad habit of trying and testing
stuff.  Here is what happens with sequences:
SQL create sequence test1 start with 1 maxvalue 4 cycle nocache;

Sequence created.

SQL select test1.nextval from dual
 2  /
  NEXTVAL
--
1
SQL /

  NEXTVAL
--
2
SQL /

  NEXTVAL
--
3
SQL /

  NEXTVAL
--
4
SQL /

  NEXTVAL
--
1
SQL /

  NEXTVAL
--
2
SQL

On 2003.11.08 10:54, Hemant K Chitale wrote:
Ah yes.  The exception case when sequence numbers are not unique.
Believe me, I've seen Sequences with low MAXVALUE [the guy decided that the
the number would never exceed 4 digits and didn't want to waste resources
and space].
And I do vaguely remember that I HAVE seen a Sequence CYCLE over and
restart.  Can't remember the details, though  this was many years ago.
It takes all kinds of developers and database designers to make Oracle
interesting.
Hemant
At 03:29 PM 05-11-03 -0800, you wrote:
In theory I suppose it's possible to have overlaps, but this has nothing to
do with OPS/RAC.  If you create the sequence to CYCLE (not the default) AND
set MAXVALUE to something less than reasonable (the default is NOMAXVALUE
which IIRC means 10 to the power 27) AND don't create a unique index on the
column storing the sequence, then maybe you can end up with multiple rows
having the same value?  Never heard of anyone doing that, of course, but in
theory ...
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Millsap
Sent: Thursday, November 06, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L
I've never heard of an Oracle sequence not generating unique id's, OPS/RAC
or not. Gaps, yes. Overlaps, never.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Todd Boss
Sent: Wednesday, November 05, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
There's six very good reasons listed below to NOT use SSN as your unique
PK,
and honestly I can't believe this is STILL an issue for any dba
who deals w/ SSNs.  These arguments are YEARS old.  Isn't this Data
Modelling 101?  I know for sure this exact case is in every text i've read.
How to deal with Natural keys:
- Create a surrogate PK that the user never sees but guarantees uniqueness.
- Create a separate (unique if you can) index on your natural key.
- Go on with life.
I'm a bit more concerned about what i'm hearing about Sequences. Is it true
that sequences are NOT guaranteed to be unique??  After all
this time listening to Oracle people scoff at the Sybase/Ms Sql identity
feature and its inadequacies as compared to Sequences for generating
sequential surrogate keys  they're NOT guaranteed to be unique if
you're
working in a parallel processing environment??
Is this really true?  Do Oracle developers have to depend on
circa 1990 techniques to generate something as BASIC as a surrogate key by
designing their own little lookup table systems?  Or am I just reading this
thread incorrectly?
Todd

 I'm fully convinced. SSN should not be used as a PK.

 Can we also conclude that natural keys in general are only good if you
sit in
 an ivory tower and do unrealistic lab test?

 Yong Huang

 --- Bellow, Bambi [EMAIL PROTECTED] wrote:
  Having worked for the government in a situation where we were
actually
  tracking information BY Social Security Number, let me tell you the
problems
  with it.
 
  1)  Social Security Numbers ARE NOT GUARANTEED TO BE UNIQUE
  2)  Individuals ARE NOT GUARANTEED TO HAVE ONE AND ONLY ONE Social
Security
  Number
  3)  Not all Social Security Numbers are numeric
  4)  Not all Social Security Numbers which ARE numeric are 9
characters in
  length
  5)  Social Security Numbers can be changed by the holder
  6)  It is illegal to use the Social Security Number for any purpose
other
  than that which the government specifically uses Social Security
Numbers for
  (ie., the distribution of benefits).  I'll bet *that* one is
strictly
  enforced.
 
  HTH,
  Bambi.
 
  -Original Message-
  Sent: Wednesday, November 05, 2003 8:00 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Tom,
 
  I think using a natural key such as Soc. Sec. # as the primary key
is a good
  idea. You don't need to maintain the sequence so there's no
performance
  issue
  associated with sequences. There's no issue of gaps. No index root
block
  contention. It doesn't seem to be industry common practice though

Sequences CYCLEing -- was RE: How do you genrate primary keys?

[Hemant K Chitale]

 for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Todd Boss
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
--
Author: Cary Millsap
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
--
Author: Pete Sharman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re[2]: How do you genrate primary keys?

[Hemant K Chitale]

Yes, now I understand your concurrency issue.
There would have been better ways but it was wiser not to spend time trying to
improve going down the wrong path.  Good that you convinced the managers
there to go for Sequences early.
Regards
Hemant
At 05:59 AM 06-11-03 -0800, you wrote:
Wednesday, November 5, 2003, 9:24:41 AM, Hemant K Chitale 
([EMAIL PROTECTED]) wrote:
HKC 1.  Hit a table that keeps a counter.
HKC Used to be a mechanism in the Oracle5 days [If I remember correctly,
HKC Sequences came in Oracle6].  Issues were with locking the single
HKC record used as the generator or scanning for the max(value) of the
HKC key.
HKC Not quite sure I understand how you encountered concurrency issues, 
though.

My concurrency issues probably boil down to the locking
business. The app I'm thinking of originally did something
like:
SELECT counter INTO :1
FROM counter_table
WHERE counter_name = 'table name';
...some app code goes here...

UPDATE counter_table
SET counter := counter+1
WHERE counter_name = 'table name';
Well, it all worked fine in single-user modegrin. But it
was easy enough for me to sit down in front of two
computers, create two new records, press SAVE at the same
time, and cause two sessions to grab the same key value,
because they would both issue the SELECT before either one
got around to the UPDATE. I couldn't screw things up
consistently, but just by hitting the SAVE button at the
same time I could screw things up often enough to make the
problem obvious.
Maybe there's a way to lock the table, to make the above
approach work. In my case, I didn't bother trying to find
that solution. Once I did my little demo, it was easy enough
to convince the project manager that we should switch to
using Oracle sequences.
Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit 
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word subscribe in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORDER -- was Re[2]: Sequences in OPS/RAC

[Hemant K Chitale]

ORDER isn't strictly necessary when all you want are unique numbers.

There are times when you cannot afford to lose CACHed values, as John 
Kanagaraj has pointed out
in Oracle Applications when generating Cheque numbers.  Such sequences 
required a patch in
Oracle Apps 10.7 and 11 and/or creation with NOCACHE.

An application where you need ORDER is when you are inserting new rows and 
the sequence number
must match the insertion temporaly -- ie, function like a timestamp so that 
you can fetch the same
rows in the same sequence.

Hemant

At 09:44 AM 03-11-03 -0800, you wrote:
Hi,

I have RAC and I always use ORDER when I create SEQUENCE.  The following 
information is from Oracle Manual:

ORDER is necessary only to guarantee ordered generation if you are using 
Oracle with Real Application Clusters. If you are using exclusive mode, 
sequence numbers are always generated in order.

Muqthar Ahmed

-Original Message-
Sent: Monday, November 03, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Hello Hemant,

Monday, November 3, 2003, 11:29:26 AM, you wrote:
HKC However, the Builder.Com article quite explicity asserts
HKC Sequence generator numbers are guaranteed to be unique only for a 
single
HKC instance, which is unsuitable for use as a primary key in parallel or
HKC remote environments, where a sequence in each environment might generate
HKC the same number and result in conflicts

Can you point us to the article? My guess is that the author
is not familiar with Oracle, and is basing the above
statement on his experience with some other database (DB2
perhaps?). There is no problem with using sequence numbers
in a RAC. No conflicts will occur. I've never heard of a
problem in that regard.
Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit 
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word subscribe in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: Muqthar Ahmed
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How do you genrate primary keys?

[Hemant K Chitale]

My comments [probably off-the-cuff without spending much time
thinking the issues through .?]
1.  Hit a table that keeps a counter.
Used to be a mechanism in the Oracle5 days [If I remember correctly,
Sequences came in Oracle6].  Issues were with locking the single
record used as the generator or scanning for the max(value) of the
key.
Not quite sure I understand how you encountered concurrency issues, though.
2. Stored sequences.
Although I prefer not to use a Sequence as a PK in itself  [preferring
natural column/s which are Unique keys, with the NOT NULL, of course],
I have used a Sequence in an Advanced Replication implementation that
had no Primary Key and I needed a PK for Conflict Resolution [this was years
ago and, if you ask me, I can't remember all the details]
3. SYS_GUID
SYS_GUID I've never used.  It doesn't generate a NUMBER value
so it is not really similar to a Sequence.
Can user's key in a SYS_GUID-generated value ?  Is it really
human readable or recallable as a plain NUMBER, Security Security Number,
ZIP Code ??
4. Similar to SYS_GUID ..
You hit on a fortuitous combination of columns.
Hemant

At 05:19 AM 05-11-03 -0800, you wrote:
The recent article that mentioned sequences got me to
thinking. I might pitch a more detailed article on sequences
to Builder.com. But a more interesting article might be one
that explored various ways to automatically generate primary
keys. So, in the name of research, let me throw out the
following questions:
What mechanisms have you used to generate primary keys?
Which ones worked well, and why? Which mechanisms worked
poorly?
I've run up against the following approaches:

* Hit a table that keeps a counter. This is the roll your
own sequence method. The one time I recall encountering
this approach, I helped convert it over to using stored
sequences. This was because of concurrency problems: with
careful timing, two users could end up with the same ID
number for different records. Is there ever a case when this
roll-your-own approach makes sense, and is workable?
* Stored sequences. I worked on one app that used a separate
sequence for each automatically generated primary key. I
worked on another app, a smaller one, that used the same
sequence for more than one table. The only issue that I
recall is that sometimes numbers would be skipped. But end
users really didn't care, or even notice.
* The SYS_GUID approach. I've never used SYS_GUID as a
primary key generator. I wonder, was that Oracle's
motivation for creating the function? Has anyone used it for
primary keys in a production app? What's the real reason
Oracle created this function?
* Similar to SYS_GUID, I once worked on an obituary-tracking
application that built up a primary key from, as best I can
recall now: date of death, part of surname, part of first
name, and a sequence number used only to resolve collisions,
of which there were few. The approached worked well,
actually, because whatever fields we munged together to
generate a primary key gave us a unique key the vast
majority of the time.
The SYS_GUID approach is interesting, but if you need an ID
number that users will see, and that users might type in
themselves (e.g. social security number), is SYS_GUID really
all that viable?
Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit 
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word subscribe in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want

Re[2]: Sequences in OPS/RAC

[Hemant K Chitale]

statement on his experience with some other database (DB2
perhaps?). There is no problem with using sequence numbers
in a RAC. No conflicts will occur. I've never heard of a
problem in that regard.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com *
906.387.1698 *
mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,

or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or
body.
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Jonathan Gennick
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Sequences in OPS/RAC

[Hemant K Chitale]

I have always been comfortable with the idea that Sequences continue to 
guarantee
uniqueness even in OPS / RAC environments.

However, a recent Builder.Com article by Scott Stephens on the SYS_GUID 
function has these lines :
Sequence generator numbers are guaranteed to be unique only for a single 
instance, which is unsuitable for use as a primary key in parallel or 
remote environments, where a sequence in each environment might generate 
the same number and result in conflicts. An identifier created by SYS_GUID 
is guaranteed to be unique for each database.

Huh ?!  Do the lines mean that a single sequence can have duplicate values 
in the two instances of an RAC cluster ?

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sequences in OPS/RAC

[Hemant K Chitale]

Yes, I've been aware of the difference between ORDERED and CACHED.

However, the Builder.Com article quite explicity asserts
Sequence generator numbers are guaranteed to be unique only for a single 
instance, which is unsuitable for use as a primary key in parallel or 
remote environments, where a sequence in each environment might generate 
the same number and result in conflicts
Sequence generator numbers are guaranteed to be unique only for a single 
instance, which is unsuitable for use as a primary key in parallel or 
remote environments, where a sequence in each environment might generate 
the same number and result in conflicts

As Tim has pointed out earlier, the author of the article might have confused
uniqueness with ordering.
{I've sent copies of the builder.com article by seperate emails to Raj and Tim}
Hemant

At 07:59 AM 03-11-03 -0800, you wrote:
In the Oracle9i Real Application Clusters Administration manual, there 
is a chapter
about sequence numbers generator. Before believing to the snake oil 
sellers, read
the fine manual. Sequence numbers are guaranteed to be unique PER 
DATABASE. What they're
not guaranteed is to come in ordered fashion. When sequence number are 
cached (that is the
default), they're cached separately, for each instance. Each instance 
returns the contents
of its cache, so it is possible for the smaller number being returned 
after a larger one.
There is ORDERED flag to deal with that, but that can be extremely 
expensive and impose
significant overhead on your cluster.

On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote:


 I have always been comfortable with the idea that Sequences continue to
 guarantee
 uniqueness even in OPS / RAC environments.

 However, a recent Builder.Com article by Scott Stephens on the SYS_GUID
 function has these lines :
 Sequence generator numbers are guaranteed to be unique only for a single
 instance, which is unsuitable for use as a primary key in parallel or
 remote environments, where a sequence in each environment might generate
 the same number and result in conflicts. An identifier created by SYS_GUID
 is guaranteed to be unique for each database.

 Huh ?!  Do the lines mean that a single sequence can have duplicate values
 in the two instances of an RAC cluster ?


 Hemant K Chitale
 Oracle 9i Database Administrator Certified Professional
 My personal web site is :  http://hkchital.tripod.com


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

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

Mladen Gogala
Oracle DBA


Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify 
the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. Wang Trading LLC and any of its subsidiaries each 
reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, 
except where the message states otherwise and the sender is authorized to 
state them to be the views of any such entity.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: re Rebuilding Indexes in Oracle Apps -- an update

[Hemant K Chitale]

Richard et al,

{for those who've been following the thread on Rebuilding Indexes ...}

I've just been reading the AskTom  thread on rebuilding indexes
at 
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730

and picked on the important line
Coalesce... reclaim the free space from mostly empty index leaf blocks 
that will not be reused otherwise due to your increasing sequence. 

Richard has also pointed COALESCE as a better option.
COALESCE would be a better option than REBUILD for Indexes on
monotonically increasing sequences where older values are purged periodically.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Overhead Associated with Signon Audit in Financials 11.0

[Hemant K Chitale]

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


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

RE: Overhead Associated with Signon Audit in Financials 11.0

[Hemant K Chitale]

Another advantage of SignOn audit  [see my other email on details of my 
implementation],
particularly down to the FORM level, is that, given a process taking 
signficant CPU time,
I can actually identify *who* the user is, which *form* he is in currently.
I have job periodically running an improved version of utllockt.sql and 
providing User,Responsibility,Form
information by using FND_SIGNON_AUDIT_VIEW as well !

Hemant
At 01:44 PM 30-10-03 -0800, you wrote:
Vicki,

As long as your *Purge* Audit signon data, I really do not see any
significant overhead. We have a 200 Gb DB and see no issues. What level is
your Profile set to? The advantages of Signon Audit far outweighs the load
it places - for e.g. you have no other way of seeing which user is logged on
(and depending on your audit level) what forms and what responsibility they
are using at this time... On the other hand, ask your auditors *what* they
would like to see. Oracle Apps already records Last-changed user and
date/timestamp for rows, while Signon Audit tracks sessions only when it is
switched on.
Let us know if you need more info.
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
-Original Message-
Sent: Thursday, October 30, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L


Does anyone have any statistics about overhead associated with using the
Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3 environment.  We are using full
installs of AP, GL, FA and CE.  Size of the production database is 100G.
Can't tell you exactly what we'd be auditing;  we are under siege by
Internal Audit at the moment - they've raised the database audit flag, but
have not started dictating what they want audited.  I am trying to get some
real-world statistics to arm myself with when the day comes .
I have heard that the overhead is significant - is this true, in your
experience?
Vicki Pierce
Database Administration
x2401
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DR Planning

[Hemant K Chitale]

A Standby Database need not be on a cluster [it just has to be the same
OS and Platform].
The Standby database could be user-managed [you write your own scripts to
copy and apply archivelogs]
or automated [using the Standby Database feature of 8.0 or 8i or
DataGuard feature of 8i or 9i].
Hemant
At 12:54 PM 24-10-03 -0800, you wrote:
Gurus,
We have a Clustered enviornment with a commomn storage array 
(which holds the database). Recently our storage array 
is having problems and for some odd reason takes the entire system down
including
the database. Not sure what is going on.

The vendor has brought the system up temporarily until they figure it out
but on our end
We are trying to come up with a solution so that we can fail-over to
another machine if the 
system goes down next time. 
We do have another srever (which is not clustered and is not as
powerful), which we
think we can use it as a hot standby. Is it possible to mix Hot
Standby with clustered? 
I am having problem seperating Cluster switchover from Primary to
Secondary node switchover.
What are your experiences or suggestions if any?
TIA
Shelly


This is going to be a great day!!!

Do you Yahoo!?
The
New Yahoo! Shopping - with improved product search 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Re: When would we see optimizer_mode=NONE in V$SQLAREA ?

[Hemant K Chitale]

Yes, I have seen the MULTIPLE CHILDS PRESENT as
well.
Yet still, how do you explain the high ratio of NONEs.
Surely you/someone isn't running so any DDLs / ANALYZEs etc
when you query V$SQL and find that 1261 of 2733 are NONEs
?
I ran a test where I began a DBMS_STATS.GATHER_SCHEMA_STATS and
immediately noticed a spike in the NONEs
which gradually came down [I even did an ALTER SYSTEM FLUSH
SHARED_POOL in-between].
Hemant
Hemant
At 12:59 PM 29-10-03 -0800, you wrote:
Hi!

Yep, when SQL is invalidated, it's optimizer
mode goes to none, as far as I've seen. It's the same with
PL/SQL stored procs, when their dependencies change, or when the
procedure is loaded but not executed due to incorrect parameter number or
types, etc, the optimizer_mode remains none.

Alter, analyze and validate commands have
optimizer_mode setting of the session during the operation runs, but as
soon they finish, their corresponding SQL areas are invalidated, thus
optimizer_mode goes back to none (with an exception of validate index
command). Create and drop statements seem not to be cached at all, but
that's perfectly reasonable, because a DROP will clear the corresponding
object out anyway and one can't really *reuse* a CREATE statement,
because corresponding object has to be dropped before, causing dependent
library cache structures invalidated.

Btw, in v$sqlarea, there is also one more
option for optimizer_mode - MULTIPLE CHILDS
PRESENT which states that you should go to v$sql to check
individual optimizer modes (I prefer v$sql over v$sqlarea anyway due
performance reasons and better granularity...)

For conclusion, this is an example of 8.1.7.1
Portal database with a lot of NONE-s:

SQL select optimizer_mode,
count(*) from v$sql group by optimizer_mode;

OPTIMIZER_
COUNT(*)
-- --
CHOOSE
1467
NONE
1261
RULE
5

Tanel.

- Original Message - 
From: Hemant K Chitale
[EMAIL PROTECTED]
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 5:04
PM
Subject: When would we see optimizer_mode=NONE
in V$SQLAREA ?

 
 
 I noticed in an 9.2 instance that a number of entries in
V$SQL, V$SQLAREA
 showed up with OPTIMIZER_MODE=NONE [there were others
with CHOOSE]
 
 I can understand that it might be NONE if someone has done an
ANALYZE or 
 DBMS_STATS
 or executed DDL and the SQLs are invalidated.
 But do you normally see a number of entries in V$SQL like that
?
 
 [I had approx 20% of the entries].
 
 
 Hemant K Chitale
 Oracle 9i Database Administrator Certified Professional
 My personal web site is :
http://hkchital.tripod.com
 
 
 -- 
 Please see the official ORACLE-L FAQ:
http://www.orafaq.net
 -- 
 Author: Hemant K Chitale
 INET:
[EMAIL PROTECTED]
 
 Fat City Network Services -- 858-538-5051
http://www.fatcity.com
 San Diego,
California -- Mailing list and
web hosting services

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

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Re: Removing NUMGROUP from lexer in ConTerMedText index

[Hemant K Chitale]

I can't provide a solution.
But I do agree with your nomenclature 
:  Context/Intermedia/Text/whateverTheHell
and ConTerMedText.

I have [or rather HAD]  Intermedia/Text setup in an 9iFS 1.1.9 and 9iFS 9.0.1
environment.  The IFS_TEXT index was successful for not very many files.
We've given up doing searches on IFS_TEXT !
We still do have Intermedia/Text in Oracle Portal 3.0.9 but I doubt if 
users user
that either.

Hemant

At 02:44 PM 29-10-03 -0800, you wrote:
Hey all,

I've setup a Context/Intermedia/Text/whateverTheHell index on 8.1.7.4 on
HP/UX to index about 25 description fields in order for our users to
search on them.  This was two years ago, and now someone has discovered at
least one issue.
One description contains something like:

BLEAH,120,1/4W

Using the default lexer, this stupidly parses into tokens of BLEAH,
120,1 and 4W instead of BLEAH, 120, and 1/4W (or even 1 and
4W).  I think this is because of the default NUMGROUP for US languages,
which is a comma (,).  So when a user looks for 120 AND 1/4W, this
description is missed because 120 isn't a valid token with the default
lexer.
There can be numerous other issues with NUMGROUP when lexing a
free-formatted description, so I really don't want a NUMGROUP.  I tried
setting it to null using:
ctx_ddl.set_attribute('MYLEXER','NUMGROUP','');

..but this bombs with:

ORA-2: interMedia Text error:
DRG-10705: invalid value NULL for attribute NUMGROUP
Other than trying to find some char that will work with 250K rows, is there
a way to turn this off?  The thing that gets me is that 120,1 isn't even a
proper number, but ConTerMedText thinks it is and tokenizes it.
TIA,
Rich
Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9I RAC corporate standard.

[Hemant K Chitale]

9iRAC on Tru64 is a breeze.  And Tru64 is True Cluster File System.
One of the diminishing breed of people still upgrading databases on Tru64 !
Hemant

At 03:39 PM 28-10-03 -0800, you wrote:
Well, we evaluated 9iRAC on some cheap-o Linux boxes as a proof-of-concept,
with the hardware idea based on
http://www.bradmark.com/site2/products/pdfs/9irac_config.pdf  As far as I'm
concerned, RAC's a major pain, unstable and not yet worth the risk -- for
us.  The idea for us being that we could move a DB or three to this RAC
system with a no-cost OS on commodity hardware giving us HA and some
load-balancing.
I tried installing RHAS 2.1 ($60 duhveloper edition), but it's so old (based
on RH7.2) that it couldn't identify our newish hardware (Intel D845 MB).
Without a clear path to add kernel mods to allow HW identification, I
installed SuSE SLES8.  Yipe!  Never did get far on that one.  Way too many
library/kernel issues to consider it.  I finally ended up testing on RH9
because it could identify our hardware, I have some familiarity with it, and
there are docs on the web (e.g. http://www.puschitz.com) to help get
Oracle9i installed on it.  I didn't have time to try United Linux, although
it does come with a 2.4-19 kernel.
Once that was resolved, I wanted to use a filesystem for Oracle, given the
limitations of RAW on SCSI under Linux (max 15 partitions), so I downloaded
OCFS 1.09.  Well, it wouldn't install because of RH9's newer kernel (it was
only made to work on RHAS2.1).  And when I tried to compile the source, I
got errors.  So I patched the OCFS source with a modified version of a JFS
patch for RH9 and it worked.  Unfortunately though, it didn't perform,
peaking out at about 1.2MB/s peak throughput and I switched to RAW (40-50
times faster).  There's also the ocfstool that you need for monitoring
because OCFS only allows contiguous file extents.  Veritas is supposed to
have a VxFS for Linux as a beta soon...
There's not enough room here for me to go over the software install hell to
get RAC actually on the systems.  And anything Java-based (Installer, DBCA,
OEM, etc.) most of the time flat out refused to run without any errors.  I
thought this was odd considering I didn't have any problem with other
non-Oracle Java programs.  Finally, when I called in a problem to Oracle
Support regarding DBCA, I thought I had a decent tech until I was warned by
him that my SHMMAX kernel setting was too high because it was over physical
RAM.  Also, I've had a helluva time trying to understand the 9iRAC client
setup.  I haven't found any Oracle docs yet that explain it well.
Granted, some/much/all of this is probably because I'm running on an
unsupported version of Linux.  My problem with that is that it shouldn't
freakin matter.  With my luck at getting 9.2.0.4 to run on Gentoo, I just
might try 9iRAC on there...  :)  I would *love* to try 9iRAC on OpenVMS.  It
should be by far the easiest to install and maintain, given the clustering
is builtin to the OS.
Gotta go redo some lvols now...

GL!  You'll need it!

Rich

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


 -Original Message-
 From: Spears, Brian [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 28, 2003 4:24 PM
 To: Multiple recipients of list ORACLE-L
 Subject: 9I RAC corporate standard.



  Hi,  Has anyone started to implement 9I Rac as a corporate
 standard... IE. many or all the apps being deployed on 9I RAC
 clusters?

  We are looking at doing it and wanted to know what other
 people had as experience in doing it or on the  way to attempting it.

  If so, what hardware platform are you using? HP Itanium or
 Linux boxes etc?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line

When would we see optimizer_mode=NONE in V$SQLAREA ?

[Hemant K Chitale]

I noticed in an 9.2 instance that a number of entries in V$SQL,  V$SQLAREA
showed up with OPTIMIZER_MODE=NONE   [there were others with CHOOSE]
I can understand that it might be NONE if someone has done an ANALYZE or 
DBMS_STATS
or executed DDL and the SQLs are invalidated.
But do you normally see a number of entries in V$SQL like that ?

[I had approx 20% of the entries].

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

[Hemant K Chitale]

Yes.  However, every time he has replied to me, he has been confident that he
IS right.
Mind you, Richard, you are immortalised now !
Hemant
At 05:04 PM 22-10-03 -0800, you wrote:
So now the blame rests solely on Richard for any material in the note that's
wrong.  :)
Check the latest update:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=182699.1
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Millsap
Sent: Wednesday, October 22, 2003 2:35 AM
To: Multiple recipients of list ORACLE-L
Oops, I didn't see that part. Thanks for the catch, Hemant.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Hemant K Chitale
Sent: Tuesday, October 21, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Unfortunately, the lines
Unoccupied space on indexes occurs when a key value changes, and
the
index
 row is deleted from one place (Leaf Block) and inserted into another.
 Deleted Leaf Rows are not reused.  Therefore, indexes whose columns are
 subject to intensive value change should be rebuilt periodically, since
 they become naturally fragmentated. 
are still visible in Note 182699.1
Hemant

At 08:29 AM 20-10-03 -0800, you wrote:
Fyi, Oracle updated note 182699.1 last Friday. The inaccurate
statements
about index fragmentation have been removed.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Richard Foote
Sent: Friday, October 17, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L
Separate

Hi Hemant,

One word perfectly describes the Metalink article you highlighted:

Crap ;)

A nice example of  how Oracle Corp is the greatest myth generator of
them all !! It's all rather sad and embarressing isn't.

Thanks for the headsup. Anyone in a position to get the note removed ?

Cheers

Richard

 Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds
Fragmentated Indexes (8.0-9.0)
 
 Index fragmentation occurs when a key value changes, and the index
row
is
 deleted from one place (Leaf Block) and inserted into another.
 
  Deleted Leaf Rows are not reused. Therefore indexes whose columns
are
  subject to value change must be rebuilt periodically since they
become
naturally fragmentated.
 
  An index is considered to be 'fragmentated' when more than 20% of
its
Leaf
Rows space is
 empty because of the implicit deletes caused by indexed columns value
changes.
 
  Fragmentated indexes degrade the performance of index range scan
operations.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
--
Author: Cary Millsap
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line

Re: Performance problem with Shareplex and Oracle

[Hemant K Chitale]

With 2 CPUs, a Run-Queue of 1.27 isn't high.   As SharePlex seems to be
the only process taking CPU, it is taking 100% of 1 CPU.  If it is one 
process only,
then the CPU speed __could__   [and I'm not saying IS] the constraint.
Adding CPUs wouldn't help.  However, upgrading to a faster CPU would
help.
My comments are just a generalisation.

Hemant
At 07:29 AM 23-10-03 -0800, you wrote:
Hi gurus,

Oracle 8.1.7.3 on Sun Solaris
One of our databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT  TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
-- ------ -- --- 
17 latch free   83 69   1   ,012048193
17 log file sync15  0   9   ,6
17 db file sequential read  52  0   6   ,115384615
17 file open 1  0   00
17 SQL*Net message to client   74791  0  27   ,000361006
17 SQL*Net message from client 74791  05235   ,069995053
I really don't see any Oracle performance problems.

My problem is the backlog (queue) of Shareplex is getting bigger and bigger.
Where is the bottleneck?
The only thing I can see is the server.  The server is a Ultra-80, 2 CPU
450Mhz, 2048Megs of RAM
According to top, this process is taking 50% of the CPU.
and my load average is 1.26, 1.27, 1.24
My average load exceed 1, can I conclude that the CPU is the bottleneck?

What are my possibilities?

TIA
Luc
-
Luc Demanche
AstraZeneca RD Montreal
Oracle Database Administrator
514.832.3200 x2356
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: CBO, RBO and will v5 ever really go away?

[Hemant K Chitale]

 Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you 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.net
--
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

[Hemant K Chitale]

 connection 
can be
bequeathed (passed) directly to a dedicated server process without going 
through
the listener. The application initiating the session spawns a dedicated server
process for the connection request using the bequeath protocol.  This happens
automatically if an application is used to start the database on the same 
machine
as the database. 

Also at http://otn.oracle.com/deploy/security/pdf/2003alert59.pdf

The 8.1.7 Support Status and Alerts note [Note 120607.1]  has also been
updated with a reference to this [Vulnerability#59] Note 251910.1
However, 251910.1 specifically says that  8.1.x and earlier has been
proved as not vulnerable.
Hemant

At 08:19 AM 23-10-03 -0800, you wrote:
Ian - I haven't been able to locate this on Metalink, but can you give a
quick idea about how I can ensure I don't have a vulnerability here? Our
databases are behind firewalls and all access is through app servers.
Thanks.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 23, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L
The exploit  involves passing a large argv[1] argument to  the oracle or
oracle0 binary.   Credit for discovering the vulnerability goes to
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] .  The error was first
discovered on a LINUX box but I have seen notes that AIX is vulnerable as
well.  What is not published in North America yet, is the Oracle alert you
mention.  The first security note I saw on this was published  on 19
October.   Yes  there are people who know how to exploit the  vulnerability.
The vulnerability was shown to Oracle  over a month ago, according to the
comments in a proof of concept exploit.
One workaround is to take off the setuid bit from the Oracle binaryIs it
really necessary to set this.  How many places  still have  users log into
the database server?Oracle has recommended putting its databases behind
firewalls for some time.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 23, 2003 6:25 AM
To: Multiple recipients of list ORACLE-L
Important:  Please read the following Oracle Alert.

We strongly recommend that you do not connect the Oracle Database
directly to the Internet.
Got your attention?  That is what is in the Alert.  These alerts are
beginning
to come all too often.  Sounds just like Microsoft's software, yeah?
Buffer Overflow in Oracle Database Server Binaries
This is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' file
in $ORACLE_HOME/bin.
Description
A potential buffer overflow has been discovered in the oracle and
oracleO (the letter O) binaries
of the Oracle Database. A knowledgeable and malicious local user can exploit
this buffer overflow
to execute code on the operating system hosting the Oracle Database server.
Products Affected
* Oracle 9i Database Release 2, Version 9.2.x
* Oracle 9i Database Release 1, Version 9.0.x
Platforms Affected
All supported UNIX and Linux operating system variants.
Patch only available for Linux right now.

So who found out this vulnerability? David Litchfield? Aaron Newman?
I know it is a bit silly to ask but does anyone know how
to exploit this vulnerability?  Send it to me directly if you dont want to
reply publicly
ta
tony
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to trace 3rd party app

[Hemant K Chitale]

How about writing a SYSTEM Trigger to capture the error to an error_table ?
Based on the SID and SQL_ADDR, the trigger could also get the last SQL.
Hemant
At 07:29 AM 23-10-03 -0800, you wrote:




Hi DBAs,

How can I trace a 3rd party app that produces a ora-3113 error?
I am looking into dbms_support package but I am not sure what trace event
and level it does.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Transportable tablespaces -- yes in 10g ?

[Hemant K Chitale]

 --
 Author:
 INET: [EMAIL PROTECTED]

 Fat City Network Services -- 858-538-5051
http://www.fatcity.com
 San Diego, California --
Mailing list and web hosting services

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

 the message BODY, include a line containing: UNSUB ORACLE-L (or the

 name of mailing list you 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.net
 --
 Author: Goulet, Dick
 INET: [EMAIL PROTECTED]

 Fat City Network Services -- 858-538-5051
http://www.fatcity.com
 San Diego, California --
Mailing list and web hosting services

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

 the message BODY, include a line containing: UNSUB ORACLE-L (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!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ORACLE-L (or the name
of
mailing list you 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.net
-- 
Author: Henry Poras
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ORACLE-L (or the name
of
mailing list you 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.net
-- 
Author: Pete Sharman
 INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

[Hemant K Chitale]

Unfortunately, the lines
Unoccupied space on indexes occurs when a key value changes, and the 
index
row is deleted from one place (Leaf Block) and inserted into another.
Deleted Leaf Rows are not reused.  Therefore, indexes whose columns are
subject to intensive value change should be rebuilt periodically, since
they become naturally fragmentated. 
are still visible in Note 182699.1

Hemant

At 08:29 AM 20-10-03 -0800, you wrote:
Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements
about index fragmentation have been removed.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Richard Foote
Sent: Friday, October 17, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L
Separate
Hi Hemant,

One word perfectly describes the Metalink article you highlighted:

Crap ;)

A nice example of  how Oracle Corp is the greatest myth generator of
them
all !! It's all rather sad and embarressing isn't.
Thanks for the headsup. Anyone in a position to get the note removed ?

Cheers

Richard

Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds
Fragmentated Indexes (8.0-9.0)

Index fragmentation occurs when a key value changes, and the index row
is
deleted from one place (Leaf Block) and inserted into another.

 Deleted Leaf Rows are not reused. Therefore indexes whose columns are
 subject to value change must be rebuilt periodically since they become
naturally fragmentated.

 An index is considered to be 'fragmentated' when more than 20% of its
Leaf
Rows space is
empty because of the implicit deletes caused by indexed columns value
changes.

 Fragmentated indexes degrade the performance of index range scan
operations.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: Cary Millsap
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Financials and APPS password

[Hemant K Chitale]

Stephen,
The revealing of the APPS password on the command line in SQL
was fixed by
patch 1196850 for 11.5 and back-ported to 11.0 and 10.7
See Note 201567.1 on MetaLink
Hemant
At 10:43 AM 17-10-03 -0800, you wrote:
April:



 Wanted to chime
in on this one but didn t have time. The APPS password is generally
secure within the DBA group, HOWEVER, it can be seen by almost everyone
that has access to UNIX or Concurrent Manager. Unfortunately,
this portion of apps was not well protected.



 Oracle was
working on a solution to this but it appears it will not be fixed until
12i or later.



Thank You



Stephen P. Karniotis

Technical Alliance Manager

Compuware Corporation

Direct:
(313) 227-4350

Mobile:
(248) 408-2918

Email:
[EMAIL PROTECTED] 

Web:
www.compuware.com




-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 15, 2003 8:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Financials and APPS password



Okay, anyone using Financials... E-Business suite... Oracle 11i... whatever you want to call it... 



I am trying to apply SOME kind of security to my databases. It appears that it is critical for everyone to be able to access production using the APPS id Finance and accounting people, developers, everyone. What does everyone else do in their setups? The newest reason is the need to run the new Mass Additions Trace which apparently requires that you use the apps id. We have found a way to set up any user with a read only version of what APPS has (since they have to be able to compile reports in production and access production data live rather than a month old clone), but Oracle says that you need to run Mass Additions Trace as apps.



Does anyone let the entire company have the production apps user's password?



April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 
 /\ 
/ \ 
/ \ 
\ / 
 \/ 
 \ 
 \ 
 \ 
 \ 
Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 


The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.


Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

[Hemant K Chitale]

I wonder if it is not necessary to rebuild indexes is also a myth.

It IS in some cases necessary
1.  Indexes on monotonically increasing values [eg Conrurrent_Request_ID 
based on a Sequence
or even on date columns which signify when the record is created] if the 
table is also
purged by the same columns frequently
2.  Because the disk space used by an Index can be inordinately larged 
after a couple of years
and index fast_full_scans are impacted

Have you administered an Oracle Applications database ?
hemant
At 03:29 AM 17-10-03 -0800, you wrote:
Hi Hemant,

One word perfectly describes the Metalink article you highlighted:

Crap ;)

A nice example of  how Oracle Corp is the greatest myth generator of them
all !! It's all rather sad and embarressing isn't.
Thanks for the headsup. Anyone in a position to get the note removed ?

Cheers

Richard

Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds
Fragmentated Indexes (8.0-9.0)

Index fragmentation occurs when a key value changes, and the index row is
deleted from one place (Leaf Block) and inserted into another.

 Deleted Leaf Rows are not reused. Therefore indexes whose columns are
 subject to value change must be rebuilt periodically since they become
naturally fragmentated.

 An index is considered to be 'fragmentated' when more than 20% of its Leaf
Rows space is
empty because of the implicit deletes caused by indexed columns value
changes.

 Fragmentated indexes degrade the performance of index range scan
operations.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

[Hemant K Chitale]

At 01:34 PM 14-10-03 -0800, you wrote:
Hemant,
John,

My apologies for the delay.  I hadn't logged on to my email last night.

Here's the output from my site
11.0.3
Purge Obsolete Workflow Runtime Data set to AGE=90 days [ITEM_TYPE and
ITEM_KEY null in parameters]
SQL set time on
14:57:42 SQL
14:57:42 SQL select activity_status, count(*)
14:57:46 2 from applsys.wf_item_activity_statuses
14:57:46 3 group by activity_status;
select item_type,activity_status,count(*)
from
applsys.wf_item_activity_statuses where activity_status='COMPLETE'
group by item_type,activity_status;
ACTIVITY COUNT(*)
 --
ACTIVE 18761
COMPLETE 1039949
DEFERRED 1082
ERROR 5541
NOTIFIED 10489
14:58:03 SQL 14:58:03 SQL 14:58:03 2 14:58:03 3 14:58:03 4
ITEM_TYP ACTIVITY COUNT(*)
  --
APVRMDER COMPLETE 29739
CREATEPO COMPLETE 154074
POAPPRV COMPLETE 309445
REQAPPRV COMPLETE 546767
14:59:01 SQL
Currently I do not have too many rows in the tables but I still plan to 
rebuild the tables
and indexes.

Hemant

This applies on 11i only. I would rebuild all indexes supporting the
WF_ITEM_ACTIVITY_STATUSES and WF_ATTRIBUTE_VALUES tables. I have been
working on some AOL table(space) problems in the background and noticed that
in 11i by default, we are not be purging _all_ the WF data that we should be
purging. I believe the current Purge routine purges activity rows whose
persistence has expired and are marked 'TEMPORARY' and ignores those that
are COMPLETE (see below). My contention is that it should be deleting old
rows that are COMPLETEd... (Fyi, this is 12+ million rows...) Notes
141853.1, 144806.1, 132254.1, 148705.1, 148678.1 may help.
You could check this using the following SQLs

select activity_status, count(*)
from applsys.wf_item_activity_statuses
group by activity_status;
select item_type,activity_status,count(*)
from
applsys.wf_item_activity_statuses where activity_status='COMPLETE'
group by item_type,activity_status;
Once the 'correct' purge is complete, the 'holey' indexes will need to be
rebuilt and the WF_ tables copied/truncated/recopied to shrink the HWM to
reasonable levels.
Let me know what your install shows up.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original Message-
Sent: Tuesday, October 14, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


John,

I rebuild the FND_CONCURRENT_REQUESTS indexes every four months [and the
table itself, occassionally].
This Saturday I will also be rebuilding some ALR indexes.
Which WorkFlow Indexes do you rebuild ?
Hemant

At 11:44 AM 13-10-03 -0800, you wrote:

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: re Rebuilding Indexes in Oracle Apps -- Quoting an Apps

[Hemant K Chitale]

Richard,
Quoting Metalink Note 182699.1 on
 bde_rebuild.sql -
Validates and
 Rebuilds Fragmentated Indexes
(8.0-9.0)
Index fragmentation occurs when a key value changes, and the index row is

 deleted from one place (Leaf Block) and inserted into
another. 
 Deleted Leaf Rows are not reused. Therefore,
indexes whose columns are 
 subject to value change must be rebuilt periodically,
since they become 
 naturally fragmentated. 

 An index is considered to be 'fragmentated' when more
than 20% of its 
 Leaf Rows space is empty because of the implicit
deletes caused by indexed 
 columns value changes. 

 Fragmentated indexes degrade the performance of index
range scan 
 operations. 
At 06:29 AM 16-10-03 -0800, you wrote:
 On
Wed, 2003-10-15 at 18:04, M Rafiq wrote:
  Jared,
  
  Those tables are transit type of tables and depending on your
volume of 
  data, there are lot of deletes and inserts all the time
resuling index 
  fragmentation(holes due to deletes) and space usage.
  
  The rebuilding not only release the space but also reduces the
index 
  fragmentation. If you don't have table truncation option for
such tables 
  then it is much better to rebuid indexes on such tables at
regular interval 
  to release space and for better performance.
  

Hi Rafiq,

I haven't been receiving all the mail from this
list so I don't know the full thread and it doesn't appear a mail I sent
a few days ago regarding all this ever made it so I could be wasting my
time again. But everytime I see comments as in the above, a voice in my
head says do something, do something. So I'll try
again.

Having lots of deletes and inserts of course
doesn't necessarily mean fragmentation. These so-called holes are fully
re-usable and in the vast majority of cases results in no substantial
issues. Having lots of deletes, inserts and updates rarely requires the
index to be rebuilt.

Simple little demo for any newbies or those
force-fed Oracle myths since child birth ...

First of all, create a simple table and
index. I've intentionally left a value out in the middle of a
range for extra effect. 
SQL create table bowie_test (ziggy number);

Table created.

SQL insert into bowie_test values
(1);

1 row created.

SQL insert into bowie_test values
(2);

1 row created.

SQL insert into bowie_test values
(3);

1 row created.

SQL insert into bowie_test values
(4);

1 row created.

SQL insert into bowie_test values
(6);

1 row created.

SQL insert into bowie_test values
(7);

1 row created.

SQL insert into bowie_test values
(8);

1 row created.

SQL insert into bowie_test values
(9);

1 row created.

SQL insert into bowie_test values
(10);

1 row created.

SQL insert into bowie_test values
(100);

1 row created.

SQL commit;

Commit complete.

SQL create index bowie_test_idx on
bowie_test(ziggy);

Index created.

Now analyze the index ...

SQL analyze index bowie_test_idx validate
structure;

Index analyzed.

and we see that everything is sweet with no
wasted deleted space ...

SQL select lf_rows, del_lf_rows,
del_lf_rows_len from index_stats;

 LF_ROWS DEL_LF_ROWS
DEL_LF_ROWS_LEN
-- --- ---

10
0
0

We now delete a number of rows
..

SQL delete bowie_test where ziggy in
(2,3,4,6,7,8,9,10);

8 rows deleted.

SQL commit;

Commit complete.

And we see that of the 10 leaf rows, 8 are
deleted. As Gollum would say nasty wasted spaces it is, gollum
..

SQL select lf_rows, del_lf_rows,
del_lf_rows_len from index_stats;

 LF_ROWS DEL_LF_ROWS
DEL_LF_ROWS_LEN
-- --- ---

10
8
112

However, we now insert a new value (notice
it's different from any previous value but obviously belongs in the same
leaf node as the others) ...

SQL insert into bowie_test values (5);

1 row created.

SQL commit;

Commit complete.

SQL analyze index bowie_test_idx validate
structure;

Index analyzed.

SQL select lf_rows, del_lf_rows,
del_lf_rows_len from index_stats;

 LF_ROWS DEL_LF_ROWS
DEL_LF_ROWS_LEN
-- --- ---

3
0
0
and we see that *all* the wasted deleted space within the
leaf node has been freed and is available for reuse ...

With few exceptions (the key is picking those
rare cases), index rebuilds are redundant, wasteful and can actually be
detrimental to performance. 

Cheers

Richard


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from

re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

[Hemant K Chitale]

 tim
  
   @sagelogix.com To: Multiple
   recipients of list ORACLE-L [EMAIL PROTECTED]
 
   Sent by: cc:
  
   ml-errors Subject: Re: BAARF
  
  
  
  
  
   09/28/2003 09:44
  
   PM
  
   Please respond
  
   to ORACLE-L
  
  
  
  
  
  
  
  
  
   Thomas,
  
   Please pardon me, but you are off-target in your criticisms of 
   OFA.
  
   It has never advocated separating tables from indexes for
  performance purposes. Ironically, your email starts to touch on the 
  real reason for separating them (i.e. different types of I/O, 
  different recovery requirements, etc). Tables and indexes do belong 
  in different tablespaces, but not for reasons of performance.
  
   Cary first designed and implemented OFA in the early 90s and
  formalized it into a paper in 1995. Quite frankly, it is a 
  brilliant set of rules of how Oracle-based systems should be 
  structured, and a breath of fresh air from the simplistic way that 
  Oracle installers laid things out at the time. It took several years 
  for Oracle Development to see the light and become OFA-compliant, 
  and not a moment too soon either. Just imagine if everything were 
  still installed into a single directory tree under ORACLE_HOME? All 
  of things you mention here have nothing to do with OFA.
  
   Please read the paper.
  
   Hope this helps...
  
   -Tim
  
   P.S. By the way, multiple block sizes are not intended for
   performance
   optimization; they merely enable transportable 
   tablespaces
  between
   databases with different block sizes.
  
  
   on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote:
  
   
I would love to have a definitive site that I could send all
  RAID-F
advocates to where it would be laid out clearly, unambiguously,
  and
definitively what storage types should be used for what purpose.
   
Redo logs on RAID 0 with Oracle duplexing (y/n)?
 
 === message truncated ===


 __
 Do you Yahoo!?
 The New Yahoo! Shopping - with improved product search 
 http://shopping.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]

 Fat City Network Services -- 858-538-5051 http://www.fatcity.com
 San Diego, California -- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you 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.net
-- 
Author: Richard Foote
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
-- 
Author: 
INET: [EMAIL PROTECTED]

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


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Re: FW: Concurrent Manager

[Hemant K Chitale]

Well, I guess there's something more for me to learn.

The last time I did an 11i install was more than 2.5 years ago, as a 
consultant,
installing 11.5.3
Since then, I've been administering an 11.0.3 environment [alongwith 50 
other databases].

Hemant
At 10:39 AM 12-10-03 -0800, you wrote:
It is incredibly annoying when the listserver truncates a response.  Here it
is in its entirety...
-- Forwarded Message
Date: Sun, 12 Oct 2003 11:06:38 -0700
To: [EMAIL PROTECTED]
Hemant,

That configuration was usual for Apps 11.0.x and prior, but with 11i it is
strongly recommended to take the default configuration and leave the ConcMgr
on the apps-tier instread of the db-tier.
Two major reasons:

* The gains in manageability (especially upgrades) far outweigh the
incremental (possible) loss in performance.  For tuning, tune the SQL, don¹t
assume its network.  For example, upgrading the db-tier is now a snap, as
compared to performing such an upgrade for 10.7 or 11.0.x...
* There is not as much network back-and-forth in 11i batch programs and
reports as there used to be.  Enormous numbers of stored procedures and
packages are now being used, making the ConcMgr programs much less ³chatty².
By way of example, I recently performed a ³utlirp.sql² run as part of an
RDBMS upgrade for Oracle Financials 11.0.3 (from 8.0.5 to 8.1.7) and about
30,000 compiled objects were invalidated and then recompiled.  In contrast,
I recently also performed the same ³utlirp.sql² for an 11.5.8 Financials
upgrade (from 8.1.7 to 9.2.0) and just under 200,000 compiled objects where
invalidated then recompiled.
Again, everything is a trade-off.  You might incur some loss due to network
latency, but is network latency the biggest problem to pay attention to?
Just another example of how the only constant is change...

-Tim

on 10/12/03 8:59 AM, Hemant K Chitale at [EMAIL PROTECTED] wrote:


 I keep Concurrent Managers on the DB server because the managers fire off
 child processes
 to run all requests and I do not want report jobs submitted by users 
that are
 actually large batch-jobs
 running over SQLNet.  It would be the old Client-Server issue where 
Reports on
 a Client ran
 slower because of the overhead of the SQLNet round-trips.

 Hemant

 At 04:10 AM 09-10-03 -0800, you wrote:
 Hi ,
 In Oracle Apps why concurrent manager and report server
 should be in database tier when other application servers
 are in application tier.?

 Thx

 Hemant K Chitale
 Oracle 9i Database Administrator Certified Professional
 My personal web site is : http://hkchital.tripod.com
 http://hkchital.tripod.com/

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

-- End of Forwarded Message

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Concurrent Manager

[Hemant K Chitale]

I keep Concurrent Managers on the DB server because the managers fire off
child processes
to run all requests and I do not want report jobs submitted by users that
are actually large batch-jobs
running over SQLNet. It would be the old Client-Server issue where
Reports on a Client ran
slower because of the overhead of the SQLNet round-trips.
Hemant
At 04:10 AM 09-10-03 -0800, you wrote:
Hi
,
In Oracle Apps why concurrent manager and
report server 
should be in database tier when other
application servers 
are in application tier.?

Thx


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Re: Temp Tablespace

[Hemant K Chitale]

 
-- 
Author: Hans de Git 
 INET: [EMAIL PROTECTED] 
 
Fat City Network Services -- 858-538-5051 
http://www.fatcity.com 
San Diego, California -- Mailing list and web 
hosting services 
 
 
 - 
 
To REMOVE yourself from this mailing list, send an 
E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in 
the message BODY, include a line containing: UNSUB 
ORACLE-L 
(or the name of mailing list you want to be removed 
from). You may 
also send the HELP command for other information 
(like subscribing). 
 
 
 
 = 
 Gaja Krishna Vaidyanatha 
 Principal Technical Product Manager, 
 Application Performance Management, Veritas Corporation 
 E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 
 Website: http://www.veritas.com 
 
 __ 
 Do you Yahoo!? 
 The New Yahoo! Shopping - with improved product search 
 http://shopping.yahoo.com 

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

Fat City Network Services -- 858-538-5051 http://www.fatcity.com 
San Diego, California -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you 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.net 
-- 
Author: vikas kawatra 
 INET: [EMAIL PROTECTED] 

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


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Re: 11i Licencing Hel(l)p

[Hemant K Chitale]

Check the Oracle Software Investment Guide at
http://www.oracle.com/corporate/pricing/index.html?sig.html
Hemant
At 06:44 AM 07-10-03 -0800, you wrote:
Help! We
are in the middle of an Oracle licencing audit fight and there is
confusion about what (if any) additional licences we need to
buy.

Currently we have 85 concurrent licences for
11i and the database. The problem is that two of the 11i options require
and use partitioning. We (and the company we hire to manage our
production database) are under the assumption that when we bought the 11i
option we would be licenced for the database options they
require.

Any insight into the Oracle Licencing nightmare
would be appreciated.

Kevin
P.S., I know we should be using CPU licences,
but that isn't my call.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

RE: Top (=10) Issues faced by Oracle DBAs Deploying in a

[Hemant K Chitale]

Unfortunately, we are always adding a new database.
The new SAN commission in June-July was supposed to hold 6 databases.
Then it became 7 databases in August.  Now it is 8 this month and the
count will go up to 9 databases by December.
As the SAN Storage Admin and Unix SA roles are handled by two people
[apart from me, the DBA], I haven't been able to get additional file systems
available on the SunCluster accessing the SAN.  I have been cramming
in 8 databases into file systems sized for 6.
Hemant

At 09:09 AM 29-09-03 -0800, you wrote:
Hemant --

I just came off a gig where I was the storage/Unix/DBA geek, and, in my
opinion, while the level of expertise *does* need to be higher, *and
different*, for in that environment, it's all front-end.  Once you have the
database configured and the backup and recovery scripts written and tested,
you can go back to having just straight DBAs.  At least that's what they did
at my last site, and I haven't heard any complaints from them.
Bambi.

-Original Message-
Sent: Saturday, September 27, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L


As an Oracle DBA , I have no problems putting my Databases on SANs [yes,
we have seperate SANs, from different vendors].
However, I find that Storage and Unix Admin skill requirements for a SAN
seem to be higher.  When Clustered servers access the SAN, it seems to
be even more difficult to get an additional mount point made available to
the DBA.
Hemant
At 10:59 AM 25-09-03 -0800, you wrote:
Fellow Listers,

If you don't deal with Oracle databases on SAN/NAS
environments, this posting may not interest you. If
so, my apologies, please delete this. Otherwise,
please read on.

In an effort to better understand what issues you face
when deploying an Oracle database in a SAN/NAS
environment, I am writing to you to get some real
life feedback. Although I have a fair idea, where
some of the pain lies, it would be much more valuable
if you could tell me. Kind of like From the horse's
mouth..;-) And I truly meant that as a
compliment...:-)

My goal is to fully understand where the real pain
lies, so that appropriate solutions can be built to
alleviate or even eliminate the pain. You can be as
broad or narrow in your responses using the following
topics as guidelines:

* Initial SAN/NAS Configuration for Database Creation
   and Application Deployment
* Ongoing Storage Volume Management in a SAN/NAS
* Ongoing Storage Administration (Growth, Resizing)
* Performance Optimization  Troubleshooting
* Things that require automation
* Anything else you think is important that I have
   missed

I do really appreciate you taking the time to put your
feedback in black and white. Those of you who take
the time and effort to provide feedback, will be
entered in a raffle to for some T-shirts and other
freebies. Oh, BTW, when you do send your response,
please provide your full contact information, so that
I know where to mail the goodies.

In the interest of not flooding the list, please
send me your feedback directly to [EMAIL PROTECTED] As
a courtesy to my fellow listers, I will collate all
responses and post a summary in the near future. You
can count on me to do that.


Best regards,


Gaja

=
Gaja Krishna Vaidyanatha|  E-Mail: [EMAIL PROTECTED]
Principal Technical Product Manager  |  Phone: (650)-527-3180
Application Performance Management   |  Web: http://www.veritas.com
Veritas Corporation |

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Hemant K Chitale]

I've had no problems with the syntax on 9.2.0.2 on Solaris, HPUX and
Tru64.
Haven't tried 9.2.0.4
Is the segment space management auto really the problem ? Or
is it
the file size.
Just run the create tablespace with a 100M or 50M initial file
size.
Hemant
At 06:44 AM 29-09-03 -0800, you wrote:
I have
RDBMS 9.2.0.4 on RH 7.3 and I executed the following 
command:

create tablespace wizard
datafile '/oradata/WIZ/wizard01.dbf' size 3072M
reuse
autoextend on next 1024M maxsize
16385m
extent management local
autoallocate
segment space management auto;

The whole system just hung, doing I/O like
crazy. I was unable to killl one of the server
processes
which survived even shutdown abort, so I had to
bounce thw whole box. No errors, no traces, no
anything. Does anybody else have experience
with this? Is there a known bug (not currently known
to me) with a patch that I can install?
I'd really like to use SEGMENT SPACE MANAGEMENT
AUTO
and forget about pctfree/pctused stuff.


--
Mladen Gogala
Oracle DBA 


Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any
mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this
message if you are not the intended recipient.
Wang Trading LLC and any of its
subsidiaries each reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those
of the individual sender, except where the message states otherwise and
the sender is authorized to state them to be the views of any such
entity.



Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com

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

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

Re: Top (=10) Issues faced by Oracle DBAs Deploying in a

[Hemant K Chitale]

As an Oracle DBA , I have no problems putting my Databases on SANs [yes,
we have seperate SANs, from different vendors].
However, I find that Storage and Unix Admin skill requirements for a SAN
seem to be higher.  When Clustered servers access the SAN, it seems to
be even more difficult to get an additional mount point made available to
the DBA.
Hemant
At 10:59 AM 25-09-03 -0800, you wrote:
Fellow Listers,

If you don't deal with Oracle databases on SAN/NAS
environments, this posting may not interest you. If
so, my apologies, please delete this. Otherwise,
please read on.
In an effort to better understand what issues you face
when deploying an Oracle database in a SAN/NAS
environment, I am writing to you to get some real
life feedback. Although I have a fair idea, where
some of the pain lies, it would be much more valuable
if you could tell me. Kind of like From the horse's
mouth..;-) And I truly meant that as a
compliment...:-)
My goal is to fully understand where the real pain
lies, so that appropriate solutions can be built to
alleviate or even eliminate the pain. You can be as
broad or narrow in your responses using the following
topics as guidelines:
* Initial SAN/NAS Configuration for Database Creation
  and Application Deployment
* Ongoing Storage Volume Management in a SAN/NAS
* Ongoing Storage Administration (Growth, Resizing)
* Performance Optimization  Troubleshooting
* Things that require automation
* Anything else you think is important that I have
  missed
I do really appreciate you taking the time to put your
feedback in black and white. Those of you who take
the time and effort to provide feedback, will be
entered in a raffle to for some T-shirts and other
freebies. Oh, BTW, when you do send your response,
please provide your full contact information, so that
I know where to mail the goodies.
In the interest of not flooding the list, please
send me your feedback directly to [EMAIL PROTECTED] As
a courtesy to my fellow listers, I will collate all
responses and post a summary in the near future. You
can count on me to do that.
Best regards,

Gaja

=
Gaja Krishna Vaidyanatha|  E-Mail: [EMAIL PROTECTED]
Principal Technical Product Manager  |  Phone: (650)-527-3180
Application Performance Management   |  Web: http://www.veritas.com
Veritas Corporation |
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Google's architecture -- was Re: paging and google.com

[Hemant K Chitale]

Google certainly doesn't use an Oracle database. They just wouldn't get the 
performance
that they achieve currently.
See this link on Google's architecture 
:  http://www.computer.org/micro/mi2003/m2022.pdf

Hemant

At 05:44 AM 26-09-03 -0800, you wrote:
Im in the middle of Kytes new tuning book. He states that google uses a 
query similiar to this to return web pages in their search function:

select /*+ FIRST_ROWS */ b.*
from ( select a.*, a.rownum
  from (your query here) a
  where rownum  pick max number of rows you want in a batch )
where rownum  will start with 1 and be max + 1 for each 'page' 
If they are using oracle to do this, how do they get the estimated number 
of total results? Is it from 'cardinality'? Do you know which data 
dictionary that comes from? explain plan is costly so they cant be using that.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Experiences setting OPEN_CURSORS for Java applications

[Hemant K Chitale]

I would just like to know what are your experiences setting OPEN_CURSORS
for Java applications / middle-tier application servers ?
We're rolling out a bunch of applications on WebMethods, Tivoli Identity 
Manager,
Plumtree, Documentum etc --- all non-Oracle clients accessing the database
through JDBC connections.

The WebMethods consultant wanted me to set OPEN_CURSORS to 500.
Plumtree also requries OPEN_CURSORS to 250 or so.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Google's architecture -- was Re: paging and google.com

[Hemant K Chitale]

I'm confused. Does Tom Kyte actually say that Google uses
Oracle
or is he talking of google-like behaviour in Oracle queries
?
Hemant
At 07:24 AM 26-09-03 -0800, you wrote:
http://tinyurl.com/ordz

HTH 
Raj 
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 
-Original Message- 
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 26, 2003 11:00 AM 
To: Multiple recipients of list ORACLE-L 
Subject: Re: Google's architecture -- was Re: paging and google.com 
hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

[Hemant K Chitale]

oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of the EE price.
Thus, EE is US$40K per CPU.  RAC is US$60K per CPU [40K + 20K].
Partitioning is US$50K per CPU [40K + 10K]  and RAC with Partitioning would 
be US$70K per CPU !
Data Mining, OLAP, Advanced Security, Spatial and Label Security
are also seperately priced options.

Hemant

Date: Thu, 25 Sep 2003 22:46:40 +0800
To: [EMAIL PROTECTED]
From: Hemant K Chitale [EMAIL PROTECTED]
Subject: RE: RAC for download -- re RAC Pricing
Check oraclestore.com.   The default page just shows you the pricing
for the DB  EE, true.
However, when you click on Database under Products in the left panel,
you can see Oracle Enterprise Edition Options listed seperately from
Oracle Database.
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.
Thus, an RAC price is 150% of an EE price.
Hemant
At 11:44 AM 24-09-03 -0800, you wrote:
My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Mogens Nørgaard
 Sent: Wednesday, September 24, 2003 2:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: RAC for download


 I've seen the same kind of confusion with respect to the partitioning
 option, where people have been informed by their sales rep that
 partitioning option is part of EE. Well, yes, if you pay extra for it.

 Mogens

 Hemant K Chitale wrote:

 
  If the question is about price [referring to oraclestore], remember
  that RAC
  is an option and is generally at a 50% premium on the EE cost.
 
  However, Mladen is right in that RAC is on the same CDs as the
  Enterprise Edition.
  If your servers are cluster-ready, the OUI automatically
 includes RAC as
  an installation option,  else, RAC does not apear in the Oracle
  product list
  when you run the Installer.
 
  Hemant
 
  At 06:54 AM 24-09-03 -0800, you wrote:
 
  RAC is a part of the EE version, for whichever OS you
 have. You will
  still need
  to purchase the hardware.
 
 
  --
  Mladen Gogala
  Oracle DBA
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
  Behalf Of quriyat
  Sent: Wednesday, September 24, 2003 10:05 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RAC for download
 
  Hello all
 
  Where can i get RAC for download? I don't see one in
 OTN. Oracle
  store puts a high tag?
 
  Thanks
 
 
 --
 --
  No banners. No pop-ups. No kidding.
  Introducing My Way - http://www.myway.com
 
 
  Note:
  This message is for the named person's use only.  It may contain
  confidential, proprietary or legally privileged information.  No
  confidentiality or privilege is waived or lost by any
  mistransmission.  If you receive this message in error, please
  immediately delete it and all copies of it from your
 system, destroy
  any hard copies of it and notify the sender.  You must
 not, directly
  or indirectly, use, disclose, distribute, print, or copy
 any part of
  this message if you are not the intended recipient. Wang
 Trading LLC
  and any of its subsidiaries each reserve the right to monitor all
  e-mail communications through its networks.  Any views
 expressed in
  this message are those of the individual sender, except where the
  message states otherwise and the sender is authorized to
 state them
  to be the views of any such entity.
 
 
 
  Hemant K Chitale
  Oracle 9i Database Administrator Certified Professional
  My personal web site is :  http://hkchital.tripod.com
  http://hkchital.tripod.com/
 
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
  Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City
  Network Services -- 858-538-5051 http://www.fatcity.com San Diego,
  California -- Mailing list and web hosting services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail
 message to:
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
  message BODY, include a line containing: UNSUB ORACLE-L (or
 the name
  of mailing list you 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.net
 --
 Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services

RE: RAC for download -- re RAC Pricing

[Hemant K Chitale]

Check oraclestore.com.   The default page just shows you the pricing
for the DB  EE, true.
However, when you click on Database under Products in the left panel,
you can see Oracle Enterprise Edition Options listed seperately from
Oracle Database.
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.
Thus, an RAC price is 150% of an EE price.
Hemant
At 11:44 AM 24-09-03 -0800, you wrote:
My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Mogens Nørgaard
 Sent: Wednesday, September 24, 2003 2:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: RAC for download


 I've seen the same kind of confusion with respect to the partitioning
 option, where people have been informed by their sales rep that
 partitioning option is part of EE. Well, yes, if you pay extra for it.

 Mogens

 Hemant K Chitale wrote:

 
  If the question is about price [referring to oraclestore], remember
  that RAC
  is an option and is generally at a 50% premium on the EE cost.
 
  However, Mladen is right in that RAC is on the same CDs as the
  Enterprise Edition.
  If your servers are cluster-ready, the OUI automatically
 includes RAC as
  an installation option,  else, RAC does not apear in the Oracle
  product list
  when you run the Installer.
 
  Hemant
 
  At 06:54 AM 24-09-03 -0800, you wrote:
 
  RAC is a part of the EE version, for whichever OS you
 have. You will
  still need
  to purchase the hardware.
 
 
  --
  Mladen Gogala
  Oracle DBA
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
  Behalf Of quriyat
  Sent: Wednesday, September 24, 2003 10:05 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RAC for download
 
  Hello all
 
  Where can i get RAC for download? I don't see one in
 OTN. Oracle
  store puts a high tag?
 
  Thanks
 
 
 --
 --
  No banners. No pop-ups. No kidding.
  Introducing My Way - http://www.myway.com
 
 
  Note:
  This message is for the named person's use only.  It may contain
  confidential, proprietary or legally privileged information.  No
  confidentiality or privilege is waived or lost by any
  mistransmission.  If you receive this message in error, please
  immediately delete it and all copies of it from your
 system, destroy
  any hard copies of it and notify the sender.  You must
 not, directly
  or indirectly, use, disclose, distribute, print, or copy
 any part of
  this message if you are not the intended recipient. Wang
 Trading LLC
  and any of its subsidiaries each reserve the right to monitor all
  e-mail communications through its networks.  Any views
 expressed in
  this message are those of the individual sender, except where the
  message states otherwise and the sender is authorized to
 state them
  to be the views of any such entity.
 
 
 
  Hemant K Chitale
  Oracle 9i Database Administrator Certified Professional
  My personal web site is :  http://hkchital.tripod.com
  http://hkchital.tripod.com/
 
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
  Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City
  Network Services -- 858-538-5051 http://www.fatcity.com San Diego,
  California -- Mailing list and web hosting services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail
 message to:
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
  message BODY, include a line containing: UNSUB ORACLE-L (or
 the name
  of mailing list you 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.net
 --
 Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
   INET: [EMAIL PROTECTED]

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



Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission

Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

[Hemant K Chitale]

Tanel,

Thanks ! Yes, your suggestion was the right fix. {I can't upgrade ALL the 
clients
and remote databases to 9.2.0.3} I set event 10499.

I referred to Note 241355.1 and Bugs 2235818 and 2960493
and set 10499 at level 4 [although any non-zero value should suffice]
The Support Analyst had asked me to rerun catalog.sql and catproc.sql but
I referred back to the Note and Bugs when I closed the TAR.
Thanks again !
Hemant


At 01:39 PM 22-09-03 -0800, you wrote:
Hi!

Try to set event 10499 at level 1 in your remote server. Or upgrade the
client to at least 9.2.0.3.
You get more information from metalink when searching for this event in
metalink, it's about float scale representation change in 10i (which was
backported to 9.2.0.3).
Tanel.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:34 PM


 I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64
database
 to a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.0.2 to 9.2.0.4]
database
 through a Database Link.
 {I use the 9.2.0.1/Tru64 Database to monitor a number of other
 8.0--9.2.0.2/NT-Solaris-Tru64
 databases using the DBSNMP account, with some additonal custom views}
 Here @HRDM is a DB-Link to the 9.2.0.4/Solaris Database :

 When querying across a DB-Link I get no errors if the query is an SQL
query.
However, I get ORA-4052 and other errors when I put the query in a
PLSQL
 block.
SQL :
SQL l
1 select count(*)
2 from [EMAIL PROTECTED] dtbs,
3 [EMAIL PROTECTED] ddfs
4 where dtbs.tablespace_name = ddfs.tablespace_name
5* and ddfs.status = 'AVAILABLE'
SQL /
COUNT(*)
--
7
SQL
PLSQL :
SQL get X1.sql
1 declare
2 cnt number;
3 begin
4 select count(*) into cnt
5 from [EMAIL PROTECTED] dtbs,
6 [EMAIL PROTECTED] ddfs
7 where dtbs.tablespace_name = ddfs.tablespace_name
8 and ddfs.status = 'AVAILABLE';
9 dbms_output.put_line('Cnt is '||cnt);
10* end;
SQL /
select count(*) into cnt
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PL/SQL: ORA-04052: error occurred when looking up remote object
[EMAIL PROTECTED]
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be bet
ORA-06550: line 4, column 1:
PL/SQL: SQL Statement ignored
SQL

 I've logged a Priority-2 TAR with Support currently but wonder if someone
 else can reproduce this {I can reproduce it on the only 2 9.2.0.4
instances
 I have,
 both Solaris, connecting from the 9.2.0.1 instance}



 Hemant K Chitale
 Oracle 9i Database Administrator Certified Professional
 My personal web site is :  http://hkchital.tripod.com


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

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you 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.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY

RE: RAC for download

[Hemant K Chitale]

If the question is about price [referring to oraclestore], remember that
RAC
is an option and is generally at a 50% premium on the EE cost.
However, Mladen is right in that RAC is on the same CDs as the Enterprise
Edition.
If your servers are cluster-ready, the OUI automatically includes RAC
as
an installation option, else, RAC does not apear in the Oracle
product list
when you run the Installer.
Hemant
At 06:54 AM 24-09-03 -0800, you wrote:
RAC is
a part of the EE version, for whichever OS you have. You will still
need
to purchase the hardware.


--
Mladen Gogala
Oracle DBA 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of quriyat 
Sent: Wednesday, September 24, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RAC for download

Hello all

Where can i get RAC for download? I don't see one in OTN. Oracle
store puts a high tag?

Thanks


No banners. No pop-ups. No kidding.
Introducing My Way -
http://www.myway.com 


Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any
mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this
message if you are not the intended recipient. Wang
Trading LLC and any of its subsidiaries each reserve the right
to monitor all e-mail communications through its networks. Any
views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.



Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

[Hemant K Chitale]

I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 database
to a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.0.2 to 9.2.0.4] database
through a Database Link.
{I use the 9.2.0.1/Tru64 Database to monitor a number of other 
8.0--9.2.0.2/NT-Solaris-Tru64
databases using the DBSNMP account, with some additonal custom views}
Here @HRDM is a DB-Link to the 9.2.0.4/Solaris Database :

When querying across a DB-Link I get no errors if the query is an SQL query.
  However, I get ORA-4052 and other errors when I put the query in a PLSQL 
block.
  SQL :
  SQL l
  1 select count(*)
  2 from [EMAIL PROTECTED] dtbs,
  3 [EMAIL PROTECTED] ddfs
  4 where dtbs.tablespace_name = ddfs.tablespace_name
  5* and ddfs.status = 'AVAILABLE'
  SQL /
  COUNT(*)
  --
  7
  SQL
  PLSQL :
  SQL get X1.sql
  1 declare
  2 cnt number;
  3 begin
  4 select count(*) into cnt
  5 from [EMAIL PROTECTED] dtbs,
  6 [EMAIL PROTECTED] ddfs
  7 where dtbs.tablespace_name = ddfs.tablespace_name
  8 and ddfs.status = 'AVAILABLE';
  9 dbms_output.put_line('Cnt is '||cnt);
  10* end;
  SQL /
  select count(*) into cnt
  *
  ERROR at line 4:
  ORA-06550: line 4, column 1:
  PL/SQL: ORA-04052: error occurred when looking up remote object
  [EMAIL PROTECTED]
  ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
  ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
  ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
  ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
  ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
  ORA-06553: PLS-623: FLOAT precision constraint must be bet
  ORA-06550: line 4, column 1:
  PL/SQL: SQL Statement ignored
  SQL

I've logged a Priority-2 TAR with Support currently but wonder if someone
else can reproduce this {I can reproduce it on the only 2 9.2.0.4 instances 
I have,
both Solaris, connecting from the 9.2.0.1 instance}



Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Fwd: Re: Tempfile weirdness

[Hemant K Chitale]

funny how my previous email seems to have been truncated where I put
three dots [ie , .] to
signifiy 3 lines.
Resend :
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE 
UNION
SELECT * FROM DBA_SOURCE
UNION
a dot here.
another dot here.
and a third dot here, signifiying 3 lines.
immediately after I startup the Instance [fortunately, the instance
startup is supposed to be
only once in 1 or 2 years but has practically been once in 3
months].
Hemant
At 01:54 PM 17-09-03 -0800, you wrote:
Any comments on the following??
When creating index, got
ORA-00603: ORACLE server session terminated by fatal error
apparently caused by
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 121 (block # 149)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 16384
Additional information: 49152
which I determined was caused by attempted write to temp tablespace using
a
tempfile. The tablespace was dropped and recreated, and all was well
again.
What I think MIGHT have happened is the tablespace created weeks ago,
but
not used. So it didn't grab any actual storage. In the mean time, some
of
the storage might have been used by something else, but storage was
released. Now tempfile goes to grab some space, but filesystem is
all
screwed up about what storage the tempfile should be grabbing.
Does this sound plausible?
Is there something else going on here?
Is this another one of those spiffy cool things in Oracle that are
just
something else to go wrong and make life a bitch?
Note that the index create blew up immediately, so the original
tempfile
never grabbed any space.
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Date: Thu, 18 Sep 2003 08:34:46
-0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Hemant K Chitale [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California

For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 in NOCATALOG mode?

[Hemant K Chitale]

It's so much easier to include an sql alter database backup controlfile 
to  filename;
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.

Hemant

At 06:54 AM 18-09-03 -0800, you wrote:
Denham
   Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have reported they were able
to extract the controlfile from the RMAN backup. I believe that on Oracle9i
this is much improved. The important thing is that you validate your backup
regularly because an untested backup can't be trusted.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 18, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Hello

Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the controlfile? Before backup /
after backup /before and after backup.
Does this aid your recovery from a crash? What advantage would it have?
Many Thanks
Regards
Denham Eva
Oracle DBA
Linux like TeePee... No Windows, No Gates and Apache inside!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denham Eva
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backup controlfile does not include ALTER TABLESPACE ...

[Hemant K Chitale]

A backup controlfile allows me to do Point-in-Time or Incomplete Recovery.
This I have to do when
  a) I am cloning a database from a Hot Backup and cannot afford to shutdown
the source database to copy the active controlfile and online redologs
  b) If I have lost ALL my files in the source database.
The backup controlfile does give me the full structure in terms of datafiles.
Therefore, it allows me to apply as many archivelogs as I have available.
Unfortunately, it does not include the ALTER commands to add tempfiles back.
*That* is my issue.
Hemant

At 07:54 AM 17-09-03 -0800, you wrote:
How is backup controlfile different? It doesn't contain the last SCN.

--
Mladen Gogala
Oracle DBA


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Hemant K Chitale
 Sent: Wednesday, September 17, 2003 11:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Backup controlfile does not include ALTER TABLESPACE ...



 Dennis,
 Yes. Sometimes,  Oracle doesn't want to do some additional
 work. Although I can't understand how the backup controlfile
 is different from
 the active controlfile
 in that manner.

 The last Support Analyst's response was
 ...  the backup binary control file does not store
 information about the
 temporary files and this is a expected
behavior.

 My retort before I closed the TAR  [maybe I should be filing
 an Enhancement
 Request]
 was
 I would expect the backup controlfile to have the same information
as the original control file. If a trace from the active
 controlfile
does provide the ALTER TABLESPACE .. ADD TEMPFILE .. I don't see
why the backup controlfile cannot provide the same.

 Hemant

 At 12:04 PM 16-09-03 -0800, you wrote:
 Hemant
 I think that the Oracle philosophy is that there is no
 reason waste
 time/tape to back up a temp tablespace. To help matters,
 Oracle added
 the ALTER TABLESPACE command to the BACKUP CONTROLFILE TO TRACE. I
 personally disagree, because after a database recovery this
 is one more
 annoying thing to remember, and if you forget it, users
 often get more
 upset over a strange tempfile error message than they do
 with a database crash.
 But in Oracle's business you can't please everyone, and I don't
 expect them to rearrange their internals to fix this obscure issue
 soon.
 
 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 
 -Original Message-
 Sent: Tuesday, September 16, 2003 10:25 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 RDBMS 8.1.7.4
 Sun Solaris [although I would think that this does not matter]
 
 What is the common method of handling the missing TEMPFILE
 clause when
 cloning a database using a Hot Backup and recreating
 controlfiles based
 on the trace from the backup controlfile ?
 
 My description to the Oracle Support Analyst :
 1. TEMPFILE exists in the database.
 2. If I do an ALTER DATABASE BACKUP CONTROLFILE TO TRACE
 I can see the ALTER TABLESPACE .. ADD TEMPFILE in the Trace file
 3. However, I do an ALTER DATABASE BACKUP CONTROLFILE TO
 controlfilebackup.dbf
 4. I then copy controlfilebackup.dbf [with the Hot Backup of all
 Database Files] to the cloning server
 In the Cloning Server/Database :
 1. I copy in controlfilebackup.dbf to the expected
 control01.ctl location
 2. I issue an STARTUP MOUNT to read the controlfile
 3. I then issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE
 Here, the ALTER TABLESPACE .. ADD TEMPFILE is missing ! It just
 does not appear.
 Therefore, if I recreate the controlfile and/or OPEN
 RESETLOGS the
 database, the TEMPFILE is missing as it does not exist on the
 cloned-server.
 However, I do not have the ALTER TABLESPACE .. ADD
 TEMPFILE command
 to add it back.
 I have to go back to the source database, get a TRACE
 backup of the
 controlfile
 to regenerate the ALTER TABLESPACE .. ADD TEMPFILE statement.
 
 
 The Analyst's response :
 When you create a backup of the controlfile the backup will not have
 information about tempfiles.
 To incude temporary tablespace in backup strategy follow
 the note:-
 167135.1( How to Incorporate Locally Managed
 Temporary Tablespaces into the Backup Strategy)
 
 Is there a TechNote or Documentation reference which specifies
 why/how tempfiles are excluded from backup controlfiles ?
 
 My current backup strategy uses DBA_DATA_FILES to identify files
 to copy out / backup to tape / other storage. It ignores
 DBA_TEMP_FILES.
 However, even if I were to include DBA_TEMP_FILES or V$TEMPFILE
 and copy the file out, my backup controlfile would not be aware
 of it. Recovery would be ok if I do not have to recreate the
 controlfile. I normally recreate the controlfile to easily
 relocate the datafiles before beginning recovery.
 Hmm. I guess my backup script should also list the TEMPFILES
 in a .list file in my backup destination

Re: 'Test' Note on Metalink...

[Hemant K Chitale]

The modified date is unreliable.  I have seen notes relating to 7.3 and 8.0
and Apps 10.7 which, from the text, I know have *not* been modified for two 
or more years
and yet the modified date appears as being only a month ago --
particulary Desupport Advisories.
e.g. see Note 39013.1 -- The Desupport Advisory for 7.1/7.2 which
was supposedly last modified 04-Sep-03.

Hemant

At 09:49 AM 17-09-03 -0800, you wrote:
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have
been around since 11-Jun-2003 (if the Modified date can be believed)
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Tempfile weirdness

[Hemant K Chitale]

For a critical database where I want to be SURE that the file system has 
enough space for the
TempFile,  I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION

RE: Backup controlfile does not include ALTER TABLESPACE ...

[Hemant K Chitale]

Dennis,
Yes. Sometimes,  Oracle doesn't want to do some additional work.
Although I can't understand how the backup controlfile is different from 
the active controlfile
in that manner.

The last Support Analyst's response was
...  the backup binary control file does not store information about the 
temporary files and this is a expected
  behavior.

My retort before I closed the TAR  [maybe I should be filing an Enhancement 
Request]
was
I would expect the backup controlfile to have the same information
  as the original control file. If a trace from the active controlfile
  does provide the ALTER TABLESPACE .. ADD TEMPFILE .. I don't see
  why the backup controlfile cannot provide the same.

Hemant

At 12:04 PM 16-09-03 -0800, you wrote:
Hemant
   I think that the Oracle philosophy is that there is no reason waste
time/tape to back up a temp tablespace. To help matters, Oracle added the
ALTER TABLESPACE command to the BACKUP CONTROLFILE TO TRACE. I personally
disagree, because after a database recovery this is one more annoying thing
to remember, and if you forget it, users often get more upset over a strange
tempfile error message than they do with a database crash.
   But in Oracle's business you can't please everyone, and I don't expect
them to rearrange their internals to fix this obscure issue soon.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 16, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L


RDBMS 8.1.7.4
Sun Solaris [although I would think that this does not matter]
What is the common method of handling the missing TEMPFILE clause when
cloning a database using a Hot Backup and recreating controlfiles based on
the trace from the backup controlfile ?
My description to the Oracle Support Analyst :
   1. TEMPFILE exists in the database.
   2. If I do an ALTER DATABASE BACKUP CONTROLFILE TO TRACE
   I can see the ALTER TABLESPACE .. ADD TEMPFILE in the Trace file
   3. However, I do an ALTER DATABASE BACKUP CONTROLFILE TO
controlfilebackup.dbf
   4. I then copy controlfilebackup.dbf [with the Hot Backup of all
Database Files] to the cloning server
   In the Cloning Server/Database :
   1. I copy in controlfilebackup.dbf to the expected control01.ctl location
   2. I issue an STARTUP MOUNT to read the controlfile
   3. I then issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE
   Here, the ALTER TABLESPACE .. ADD TEMPFILE is missing ! It just
   does not appear.
   Therefore, if I recreate the controlfile and/or OPEN RESETLOGS the
   database, the TEMPFILE is missing as it does not exist on the
cloned-server.
   However, I do not have the ALTER TABLESPACE .. ADD TEMPFILE command
   to add it back.
   I have to go back to the source database, get a TRACE backup of the
controlfile
   to regenerate the ALTER TABLESPACE .. ADD TEMPFILE statement.
The Analyst's response :
When you create a backup of the controlfile the backup will not have
information about tempfiles.
   To incude temporary tablespace in backup strategy follow the note:-
167135.1( How to Incorporate Locally Managed
   Temporary Tablespaces into the Backup Strategy)
Is there a TechNote or Documentation reference which specifies
   why/how tempfiles are excluded from backup controlfiles ?
   My current backup strategy uses DBA_DATA_FILES to identify files
   to copy out / backup to tape / other storage. It ignores
   DBA_TEMP_FILES.
   However, even if I were to include DBA_TEMP_FILES or V$TEMPFILE
   and copy the file out, my backup controlfile would not be aware
   of it. Recovery would be ok if I do not have to recreate the
   controlfile. I normally recreate the controlfile to easily
   relocate the datafiles before beginning recovery.
   Hmm. I guess my backup script should also list the TEMPFILES
   in a .list file in my backup destination and I use the .list
   file to identify tempfiles. Not neat.


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

Re: invalid ROWID

[Hemant K Chitale]

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


DISCLAIMER: The information contained in this message is intended only and
solely for the addressed individual or entity indicated in this message and
for the exclusive use of the said addressed individual or entity indicated
in this message (or responsible for delivery of the message to such person)
and may contain legally privileged and confidential information belonging
to Tata Consultancy Services. It must not be printed, read, copied,
disclosed, forwarded, distributed or used (in whatsoever manner) by any
person other than the addressee. Unauthorized use, disclosure or copying is
strictly prohibited and may constitute unlawful act and can possibly
attract legal action, civil and/or criminal. The contents of this message
need not necessarily reflect or endorse the views of Tata Consultancy
Services on any subject matter. Any action taken or omitted to be taken
based on this message is entirely at your risk and neither the originator
of this message nor Tata Consultancy Services takes any responsibility or
liability towards the same. Opinions, conclusions and any other information
contained in this message that do not relate to the official business of
Tata Consultancy Services shall be understood as neither given nor endorsed
by Tata Consultancy Services or any affiliate of Tata Consultancy Services.
If you have received this message in error, you should destroy this message
and may please notify the sender by e-mail. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: ManojKr Jha
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-600

[Hemant K Chitale]

Doc ID: 
 Note:34782.1
Subject: 
 ORA-600 [17114]
KGH Bad magic
 number in
header
Type: 
 REFERENCE
Status: 
 PUBLISHED

Content Type: 

TEXT/PLAIN

Creation Date: 

29-FEB-1996

Last Revision Date: 

29-OCT-2002

Note: For additional ORA-600 related information please read
[NOTE:146580.1] 
 
PURPOSE:

 This article discusses the internal error ORA-600
[17114], what 
 it means and possible actions. The information here is only
applicable 
 to the versions listed and is provided only for guidance.

 
ERROR:

 ORA-600 [17114][a][b][c][d][e] 
 
VERSIONS:

 versions 7.X to 8.X 
 
DESCRIPTION: 
 
 Oracle has detected that the magic number in a memory chunk
header has been 
 overwritten. 
 
 This is a heap (in memory) corruption and there is no
underlying data 
 corruption. 
 
 The error may occur in the one of the process specific
heaps 
 (the Call heap, PGA heap, or session heap) or in the shared
heap (SGA). 
 
 
FUNCTIONALITY: 
 HEAP MANAGEMENT 
 
IMPACT:

 PROCESS FAILURE 
 MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE 
 NON DATA CORRUPTIVE - No underlying data corruption. 
 
SUGGESTIONS: 
 
 If you think you are not hitting any of the known issues
shown below, 
 then you need to set event 10235 in your init.ora file :-

 
 event=10235 trace name context
forever, level 1 
 
 While the event is set, the next time you get the error a
trace 
 file will be generated in your USER_DUMP_DEST directory.

 Contact Oracle Support Services and supply the trace file.

 
 Known Issues: 
 Bug 898074: PRIVATE MEM CORR ON PARTITION TABLE 
NON-PARTITION-KEY PREDICATE 
 fixed in 8.0.6.1 and 8.1.6.0 releases 
 Bug 573746: -- 
 DBMS_SQL DEFINE_ARRAY / ARRAY FETCH TO LARGE
ARRAY MAY CAUSE ORA-600[17114] 
 fixed in 8.0.4.4, 8.0.5.0 and 8.1.5.0 releases 
 Bug 1280983: ORA-600 [17114]/ORA-600 [17112] USING
STAR_TRANSFORMATION 
 fixed in 8.1.7.0 
Hemant
At 08:14 AM 16-09-03 -0800, you wrote:
This
is on an old 7.3.4 database. I can't find the same error on
Metalink. Anybody have any ideas what might be the
cause?

ORA-00600: internal error code,
arguments: [17114], [1074346728], [], [], [], [], [], [] 

Ron
Smith


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Backup controlfile does not include ALTER TABLESPACE ... ADD

[Hemant K Chitale]

RDBMS 8.1.7.4
Sun Solaris [although I would think that this does not matter]
What is the common method of handling the missing TEMPFILE clause when
cloning a database using a Hot Backup and recreating controlfiles based on
the trace from the backup controlfile ?
My description to the Oracle Support Analyst :
  1. TEMPFILE exists in the database.
  2. If I do an ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  I can see the ALTER TABLESPACE .. ADD TEMPFILE in the Trace file
  3. However, I do an ALTER DATABASE BACKUP CONTROLFILE TO 
controlfilebackup.dbf
  4. I then copy controlfilebackup.dbf [with the Hot Backup of all 
Database Files] to the cloning server
  In the Cloning Server/Database :
  1. I copy in controlfilebackup.dbf to the expected control01.ctl location
  2. I issue an STARTUP MOUNT to read the controlfile
  3. I then issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  Here, the ALTER TABLESPACE .. ADD TEMPFILE is missing ! It just
  does not appear.
  Therefore, if I recreate the controlfile and/or OPEN RESETLOGS the
  database, the TEMPFILE is missing as it does not exist on the cloned-server.
  However, I do not have the ALTER TABLESPACE .. ADD TEMPFILE command
  to add it back.
  I have to go back to the source database, get a TRACE backup of the 
controlfile
  to regenerate the ALTER TABLESPACE .. ADD TEMPFILE statement.

The Analyst's response :
When you create a backup of the controlfile the backup will not have 
information about tempfiles.
  To incude temporary tablespace in backup strategy follow the note:- 
167135.1( How to Incorporate Locally Managed
  Temporary Tablespaces into the Backup Strategy)

Is there a TechNote or Documentation reference which specifies
  why/how tempfiles are excluded from backup controlfiles ?
  My current backup strategy uses DBA_DATA_FILES to identify files
  to copy out / backup to tape / other storage. It ignores
  DBA_TEMP_FILES.
  However, even if I were to include DBA_TEMP_FILES or V$TEMPFILE
  and copy the file out, my backup controlfile would not be aware
  of it. Recovery would be ok if I do not have to recreate the
  controlfile. I normally recreate the controlfile to easily
  relocate the datafiles before beginning recovery.
  Hmm. I guess my backup script should also list the TEMPFILES
  in a .list file in my backup destination and I use the .list
  file to identify tempfiles. Not neat.


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: more questions -- multiplexing of datafiles

[Hemant K Chitale]

See the ASM feature of Oracle 
10g.  http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html
Oracle handles virtualisation and redistribution of datafiles and also 
provides mirroring of datafiles.

Hemant

At 07:59 AM 04-09-03 -0800, you wrote:
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of
datafiles, since at least Oracle v6, I believe.  It's just something that
never made the jump to other ports, I guess...


on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote:

 how to startup oracle after machine
 is bootup?
 you must configure your /etc/oratab
 Ans:
 add this line
 your_sid:your_oracle_home:AUTO(auto is keyword)


 how to shutdown oracle before Unix is shutdown?
 Ans:
 I don't think that Oracle provide such feature, but you can write OS script
 add to your in your init.d

 or simpler way replace your init binary file with your own
 for example

 # init 6

 your new init

 /where is my shutdown script/shutdown oracle.sh
 /or perhaps you want to shutdown listener too or other application do it
 here/bla.sh
 sync
 sync
 original_init $1

 It seems to me that I cannot multiplex data files. Is that true?

 Ans:

 Yes Oracle only allow you to multiplex your control files and redolog files
 but not your data files, however
 Oracle do recommend you to do RAID 0 + 1 if you have the $$$.


 Sinardy





 -Original Message-
 Sent: 02 September 2003 11:29
 To: Multiple recipients of list ORACLE-L


 Hi Greetings,

 We are using solaris. I wonder how to startup oracle after machine
 is bootup and how to shutdown oracle before unix is shutdown?
 I know how to multiplex control files and redo files. It seems to
 me that I cannot multiplex data files. Is that true?

 Thanks!
 Jin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 Enhancement Request System

[Hemant K Chitale]

Then it moved to being under MetaLink. Now I can't find it or the
note referring to it either !
Has ers been quietly dropped or forgotten or is it lying low ?
Hemant
At 11:14 AM 02-09-03 -0800, you wrote:
Hi!

It used to be ers.oracle.com, but it has
disappeared for some reason... 

Tanel.


- Original Message - 
From: Jamadagni,
Rajendra 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, September 02, 2003 8:34 PM
Subject: Oracle Enhancement Request System

Does anyone have the URL handy ?? I have managed to misplace
mine. 

TIA 
Raj 


Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

RE: Error Log

[Hemant K Chitale]

Yes, I could ignore ORA-001.  But there are cases where I might want
to know of ORA-001's occurring.
Hemant
At 11:59 PM 31-08-03 -0800, you wrote:
Can't you tell your trigger to ignore this error as well.

-Original Message-
Sent: Saturday, August 30, 2003 7:19 AM
To: Multiple recipients of list ORACLE-L


Use a Database Trigger AFTER SERVERRROR.

[careful, the table might fill up pretty quickly -- e.g at my site a load
job ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!]
Try this :

drop table system.oracle_errors;
create table system.oracle_errors
(db_username  varchar2(30),
 db_session_id  number,
 db_process_id  number,
 unix_process_id varchar2(9),
 client_process_id  varchar2(9),
 client_program  varchar2(48),
 client_machine  varchar2(64),
 client_terminal varchar2(30),
 client_os_user  varchar2(30),
 appl_user_name  varchar2(100),  -- exclude if not
using Oracle Apps
 appl_responsibility_name  varchar2(100), -- exclude if not
using Oracle Apps
 appl_form_name  varchar2(80),-- exclude if not
using Oracle Apps
 err_timestamp date,
 error_msg varchar2(2000))
tablespace customd   -- or any other TBS
storage (initial 4M next 1M maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx1
on system.oracle_errors(appl_login_name,err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx2
on system.oracle_errors(err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx3
on system.oracle_errors(error_msg)
tablespace customx  -- or any other TBS
storage (initial 1M next 1M maxextents 500 pctincrease 0)
/
drop trigger system.oracle_errors_trg;

create or replace trigger system.oracle_errors_trg
after servererror on database
begin
insert into system.oracle_errors
select s.username, s.sid, p.pid, p.spid, s.process,
s.program, s.machine, s.terminal, s.osuser,
f.user_name, f.responsibility_name, f.user_form_name,   -- exclude
all three if not using Oracle Apps
sysdate, dbms_utility.format_error_stack
from apps.fnd_signon_audit_view f, v$session s, v$process p  -- exclude
apps.fnd_signon_audit_view
where s.audsid = userenv( 'sessionid' )
and s.paddr=p.addr
and p.pid=f.pid(+);  -- exclude this join if not
using Oracle Apps
end;
/
At 06:19 PM 29-08-03 -0800, you wrote:

Is there anyway to setup oracle on the server side to log all fail and
error transaction in a file or something? I mean, error/fail
transaction due to,
eg: Integrity Contraint violation, Check constraint, Not Null constraint,
any
other error.

It would simply debugging since then we don't have to output / catch
and send error and SQL statement on the application level.

System: ORACLE 9i on Redhat Linux 7.3

Thanks.
RDB
--
Reuben D. Budiardja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru

RE: 7.3.4 on hp-ux11 upgrade problem

[Hemant K Chitale]

Hmm.
Note 29732.1   on MetaLink does list seperate part numbers for Oracle7.3.4 
on HPUX 10.20 and 11.x.
But does not make it clear that the two OS versions are not object-file 
compatible.
See Note 99206.1  for the different possible scenarios in upgrades on HP.

However, Jesse's advice is best.  As your target machine is a seperate server,
you really do not need to install 7.3.4 and copy the database across.
Install 9.2.0.2 or higher [NOT 9.0.1] on the new server, create a 7.3.4 Export
from the old server and import the database into the new server.
I suggest that you read the Oracle 9i Migration document in the Documentation
CD of your 9i CD pack  or at  http://tahiti.oracle.com  or 
http://otn.oracle.com

Hemant
At 07:34 AM 27-08-03 -0800, you wrote:
I have read the manuals and conflicting posts on metalink
and have asked first oracle what to do and they're advice
was to take 10.20 cd's and install them on 11.11. This was done
before this post.
If you want to know where to find this in manuals let me know.

Jeroen

-Oorspronkelijk bericht-
Van: Jesse, Rich [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 27 augustus 2003 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: 7.3.4 on hp-ux11 upgrade problem
Among changes like nearly the whole data dictionary, the format of the
ROWIDs for every row in the DB is different.  You need to migrate the DB.
Kindly RTFM.
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Wednesday, August 27, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Hi,

We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to
oracle 9.0.1.0 on a different hp-ux 11.11 box.
In order to be able to migrate we installed 7.3.4 on this machine,
copied datafiles and config.ora, init.ora and listener.ora
We only run the old listener (this starts correctly) and we try to bring up
our copy on this
machine. We encounter the following problem
pablo:oracle/opt/oracle/product/7.3.4/dbs $svrmgrl

Oracle Server Manager Release 2.3.4.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

ORA-12547: TNS:lost contact
SVRMGR connect internal;
Password:
ORA-12547: TNS:lost contact
SVRMGR startup
LCC-00161: ORACLE error (possible syntax error) parameter [NULL]
ORA-12547: TNS:lost contact
Environment has been set to the right oracle_home, also tns_admin
Any idea what causes this? Installation or configuration problem?
Thnx in advance,

Jeroen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: Jeroen van Sluisdam
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Error Log

[Hemant K Chitale]

Use a Database Trigger AFTER SERVERRROR.

[careful, the table might fill up pretty quickly -- e.g at my site a load job
ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!]
Try this :

drop table system.oracle_errors;
create table system.oracle_errors
   (db_username  varchar2(30),
db_session_id  number,
db_process_id  number,
unix_process_id varchar2(9),
client_process_id  varchar2(9),
client_program  varchar2(48),
client_machine  varchar2(64),
client_terminal varchar2(30),
client_os_user  varchar2(30),
appl_user_name  varchar2(100),  -- exclude if not 
using Oracle Apps
appl_responsibility_name  varchar2(100), -- exclude if not 
using Oracle Apps
appl_form_name  varchar2(80),-- exclude if not 
using Oracle Apps
err_timestamp date,
error_msg varchar2(2000))
tablespace customd   -- or any other TBS
storage (initial 4M next 1M maxextents 500 pctincrease 0)
/

create index system.oracle_errors_ndx1
on system.oracle_errors(appl_login_name,err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx2
on system.oracle_errors(err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx3
on system.oracle_errors(error_msg)
tablespace customx  -- or any other TBS
storage (initial 1M next 1M maxextents 500 pctincrease 0)
/
drop trigger system.oracle_errors_trg;

create or replace trigger system.oracle_errors_trg
after servererror on database
begin
insert into system.oracle_errors
select s.username, s.sid, p.pid, p.spid, s.process,
   s.program, s.machine, s.terminal, s.osuser,
   f.user_name, f.responsibility_name, f.user_form_name,   -- exclude 
all three if not using Oracle Apps
   sysdate, dbms_utility.format_error_stack
from apps.fnd_signon_audit_view f, v$session s, v$process p  -- exclude 
apps.fnd_signon_audit_view
where s.audsid = userenv( 'sessionid' )
and s.paddr=p.addr
and p.pid=f.pid(+);  -- exclude this join if not 
using Oracle Apps
end;
/

At 06:19 PM 29-08-03 -0800, you wrote:

Is there anyway to setup oracle on the server side to log all fail and error
transaction in a file or something? I mean, error/fail transaction due to,
eg: Integrity Contraint violation, Check constraint, Not Null constraint, any
other error.
It would simply debugging since then we don't have to output / catch and send
error and SQL statement on the application level.
System: ORACLE 9i on Redhat Linux 7.3

Thanks.
RDB
--
Reuben D. Budiardja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: 7.3.4 on hp-ux11 upgrade problem

[Hemant K Chitale]

There is a seperate 7.3.4 release for HPUX 11.0as 10.20 and 11.0 are 
not binary compatible.
You must install the HPUX 11.0  release of 7.3.4  [if you don't have the CDs,
call Oracle Support and explain how you need them to run the upgrade
as your upgrade is covered by your Support contract].

Fortunately, the Oracle DataFiles [including ControlFiles and RedoLog 
files] are
compatible from HPUX 10.20 to HPUX 11.0  so you should be able to just
copy the database across.

Hemant
At 06:14 AM 27-08-03 -0800, you wrote:



I don't believe that HP-UX 10.2 and 11.0 are binary compatable, try
export/import.




  Jeroen van 
Sluisdam 

  jeroen.van.sluisdam@To:   Multiple 
recipients of list ORACLE-L [EMAIL PROTECTED]
  vrijuit.nl  cc: 

  Sent by: Subject:  7.3.4 on 
hp-ux11 upgrade problem
  [EMAIL PROTECTED] 





  08/27/2003 09:49 
AM 

  Please respond 
to 

  ORACLE-L 









Hi,





We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to

oracle 9.0.1.0 on a different hp-ux 11.11 box.

In order to be able to migrate we installed 7.3.4 on this machine,

copied datafiles and config.ora, init.ora and listener.ora

We only run the old listener (this starts correctly) and we try to bring 
up our
copy on this

machine. We encounter the following problem





pablo:oracle/opt/oracle/product/7.3.4/dbs $svrmgrl





Oracle Server Manager Release 2.3.4.0.0 - Production





Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.





ORA-12547: TNS:lost contact

SVRMGR connect internal;

Password:

ORA-12547: TNS:lost contact

SVRMGR startup

LCC-00161: ORACLE error (possible syntax error) parameter [NULL]

ORA-12547: TNS:lost contact





Environment has been set to the right oracle_home, also tns_admin

Any idea what causes this? Installation or configuration problem?





Thnx in advance,





Jeroen





--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Boligan
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Forms - as sysdba

[Hemant K Chitale]

Rather, why do you want to connect as SYS ?
If you've created some custom tables in the SYS schema in an earlier
version, 
create another user, connect as SYS in sqlplus, GRANT privileges to that
user
and connect as that new user in Forms. -- and think about migrating the
tables
out of the SYS schema.
If you are querying standard tables, OEM provides good views for most of
what
you need and the group here can provide better SQL scripts
anyway.
Hemant
At 07:29 AM 21-08-03 -0800, you wrote:
Try if it
works if you put sys/sys as sysdba to forms username prompt? (without
quotes)
But why do you want to connect as sysdba
anyway?

Tanel.


- Original Message - 
From: Robo 
To: Multiple recipients of
list ORACLE-L 
Sent: Thursday, August 21, 2003 11:54 AM
Subject: Forms - as sysdba

Hi all, 
I have a 9.2.0.3 DB and I need to connect
to Forms 6i as user sys. There are 3 boxes for username, password and
database.
I tried a lot of combinations, eg: 
Username: sys as sysdba

Password: sys 

Database: db 
sys/[EMAIL PROTECTED] as sysdba 
sys/[EMAIL PROTECTED] /as sysdba 
sys/[EMAIL PROTECTED] 'as sysdba' 
sys/[EMAIL PROTECTED] '/as sysdba' 
But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). 
I have also tried it from command line but didn't succeed. 

Does anyone know if/how is it possible?

Thanks a lot 
Robert Pipich 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Re: Forms 3 and 9i

[Hemant K Chitale]

I was about to say wouldn't work
But considering that Oracle Applications 10.7 Character-mode Forms
2.4 works with 8.1.7,
yes, why not ? [although 2.4 might actually be a higher version
than 3.0 as 2.4
was specifically built for Apps 10.7 and the Y2K upgrades while 3.0
predates Y2K].
Of course, you won't be supported.
Hemant
At 02:59 AM 21-08-03 -0800, you wrote:
Hi All,

Will forms 3 works with 9i. Any known issues in
this.

TIA,
Senthil.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

Re: URGENT!!! My 9i databases are not shutting down

[Hemant K Chitale]

Habit. The sync command is picked up by the scheduler
sched and may not be executed immediately.
With three sync calls, at least one goes through by the time
you are ready to type in shutdown or init
0
Hemant
At 08:04 AM 21-08-03 -0800, you wrote:
Hi!

I've always wondered why 3 syncs. Is it
quaranteed, that after *exactly 3* syncs everything has been written to
disk? Or it more like that after that number of syncs, most of the
changes should be on disk? (sounds stupid)

Tanel.

- Original Message - 
From: Tim Gorman 
To: Multiple recipients of
list ORACLE-L 
Sent: Thursday, August 21, 2003 12:04 AM
Subject: Re: URGENT!!! My 9i databases are not shutting down
cleanly/cons

I’d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just
prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and
just to make me feel better)...

Does anyone remember the UNIX mantra of entering “sync; sync; sync”
before “halt”? :-)



on 8/20/03 11:09 AM, April Wells at
[EMAIL PROTECTED] wrote:

We have started waiting 90 min then do shutdown abort, startup,
shutdown
immediate
April Wells

Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. 
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash
April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 20, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

There seems to be a problem with consistent shutdowns in 9i 

Oracle 9i 64bit 
9.0.1.3.0 - infrastructure database that comes with the application server 
9.2.0.1.0 - that is the version of RDBMS we are running. 

Does anyone have problems shutting down their databases consistently with 9i? 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


Hemant K Chitale
Oracle 9i

Re: OEM

[Hemant K Chitale]

I am able to use OEM 9.2.0.1 against 8.0.4-8.0.6 and 8.1.6-8.1.7
databases.  
Hemant

At 08:59 AM 20-08-03 -0800, you wrote:
Does OEM
9.2.0.1 works well with 8.1.7.4 database ? or in general with all
versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db
version and sends commands appropriately . Any Idea ?

thanks,
-ak


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com


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

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

RE: dbca and finish button

[Hemant K Chitale]

If you've specified directory names and file names for the database / redo 
log / control files,
check that the values are correct.   -- e.g. you can use a FILE VARIABLE to 
specify directory
names but the variable name itself may be mistyped -- if any of the values 
are incorrect,
the installer just returns to the same ending screen. Go BACK to the 
screens where you
specify file names and check the FILE VARIABLEs, directory names and file 
names again.
Hemant

At 04:29 AM 19-08-03 -0800, you wrote:
No it doesn't.

When prompted to save as html I do so. I then click Finish again and it
prompts me to save as html againround and round in circles.


-Original Message-
Sent: 19 August 2003 10:50
To: Multiple recipients of list ORACLE-L
Click to save and it'll continue

Jack



-Original Message-
Sent: Tuesday, August 19, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
Have just installed Oracle 9.2 and am trying to use dbca to create a
database. Even though I select to create a database it just displays the
template with the option to save as HTML, but does not create the database!
Am I missing something here?

John

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you 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.net
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you 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.net
--
Author: John Dunn
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Using noatime mount-flag to improve performance ?

[Hemant K Chitale]

I've recently come across references to setting
the noatime attribute to improve performance 
of a Database server because Unix does not then
need to update the last-access time for each file.

e.g. the Oracle for Linux tuning paper at
http://otn.oracle.com/oramag/webcolumns/2002/techarticles/scalzo_linux01.html
also mentions this.

Has anyone used this on Unix [Solaris/AIX/HPUX/Tru64]
servers ?

Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

RE: 32 or 64? -- on Solaris 8 ?

[Hemant K Chitale]

Has anyone tests / benchmarks showing a multiuser
OLTP Oracle database performs better with 
64-bit 8.1.7 on 64-bit Solaris8 then 
32-bit 8.1.7 on 64-bit Solaris8 ?

ie, the default Solaris8 install is 64-bit.
If the DB is less than 100GB with db_block_buffers
of less than 1GB and db_block_size of 4K [sorry !]
and there are 10 to 20 concurrent users, 
would 32-bit 8.1.7 or 64-bit 8.1.7 be better ?

What about databases with 1.5GB db_block_buffers,
8K db_block_size and 50 to 100 concurrent users ?

Hemant

--- Niall Litchfield [EMAIL PROTECTED] wrote:

 To sell more sun kit? To add to a resume? 
 
 As for bugs, I'll bet my hat there are more bugs on any newer,
 limited
 circulation release than there are on wide circulation popular
 releases.
 
 
 Niall
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
  Behalf Of Daniel Fink
  Sent: 18 August 2003 17:14
  To: Multiple recipients of list ORACLE-L
  Subject: 32 or 64?
  
  
  From a technical and business perspective, what are the 
  reasons to migrate from 32-bit to 64-bit Oracle? Are there 
  known bugs/problems with one version that are not present in 
  the other?
  
  Daniel Fink
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Niall Litchfield
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting
 services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like
 subscribing).
 



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 online redo logs and archivelogs -- was RE: PTC

[Hemant K Chitale]

Oh yes, do please inform people of the need to keep multiple backup sets !
I did see that the online redo log file and the last two archive logs
plus two datafiles in the last online backup set were bad -- this happened
as the I/O controller had errors while the Hot Backup to disk was running.
These files hadn't yet gone to the tape as all I/O to the disk was suspended.
I had to recover the database till the last good archive log.

Hemant

At 06:59 AM 14-08-03 -0800, you wrote:
Hemant
   Corrupted archivelogs. Interesting. Just yesterday I was trying to point
out to someone on this list that having only weekly backups can leave you
vulnerable to this sort of thing. Not that it is the end of the world, I've
had production systems in that configuration, but the business users need to
understand the vulnerability. I'm not sure if I was completely convincing.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 14, 2003 12:44 AM
To: Multiple recipients of list ORACLE-L


I do have PTC Windchill running at my site.
The first thing I did when the database was handed over
to IT Operations was to switch to ARCHIVELOG.
[A year later, we had some problem with the I/O controller
which corrupted the online archivelog file and also
some of the files in the HotBackup-to-Disk. I had
to restore the database from the previous night's
backup and reapply the archivelogs till the last good
archivelog. Potentially, we lost some data !]
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Storage Cache - WriteThrough or WriteBack

[Hemant K Chitale]

I've begun a debate in my organisation about 
caches on storage systems.
If an Oracle Database, including Redo Log files,
is on RAID1 or RAID1+0 or RAID5 on the storage/SAN
and the storage/SAN system provides a cache, should
the cache be WriteThrough or WriteBack ?

I prefer WriteThrough -- particularly when the
Redo Log files are also on such external storage.

The vendor talks of Mirrored-Caches and Battery-Backed Cache.

In the past year, we've had one instance of the
Cache itself failing and the Controller stopping all
I/O to the storage and a couple of instances of 
Cache batteries being low/dead.  {Should I/O be
allowed to proceed if the Cache Batteries are dead
or should the storage automatically switch to WriteThrough ?}


Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

RE: PTC Windchill

[Hemant K Chitale]

I do have PTC Windchill running at my site.
The first thing I did when the database was handed over
to IT Operations was to switch to ARCHIVELOG.
[A year later, we had some problem with the I/O controller
which corrupted the online archivelog file and also
some of the files in the HotBackup-to-Disk. I had
to restore the database from the previous night's
backup and reapply the archivelogs till the last good
archivelog. Potentially, we lost some data !]

As per the Site Info document that was provided by the
Parametric consultants who did the implementation, we
are running WindChill 5.0 which is NOT certified with 8.1.7.
Yes, we are still running 8.1.6

The Windchill installation create's its own ORACLE_HOME
and datafiles in a database directory under the ORACLE_HOME.

{A side note :  Plumtree, BlueMartini and TivoliIdentityManager also create datafiles 
under
$ORACLE_HOME/database or $ORACLE_HOME/dbs !  At least
for these implementation, I am involved before they go live
and either the consultant modifies the script to create
the datafiles in the location I specify or I shutdown
the database after the application installation and
relocate the datafiles !}

Hemant K Chitale
--- M.Godlewski [EMAIL PROTECTED] wrote:

 Thanks Rich! 
  
 I'm hope the product does support archive log mode.  Could make for
 some creative backup plans otherwise.
 
 Jesse, Rich [EMAIL PROTECTED] wrote:
 I can't comment on the product itself since I've never used it.
 Strictly
 speaking from the DB end of Windchill, ignore most of what PTC says
 about
 setting up Oracle. It's a bare bones install with no tuning
 whatsoever.
 The Oracle software comes as a fixed, non-patchable, non-OFA
 version. The
 default DB setup puts all files on the same mountpoint as the
 software. I'm
 trying to remember if archivelog mode is suported or not (yes, you
 heard
 that correctly). It may depend on if there's external vaulting or
 not.
 There's no RI in the schema. This has been my experience with most
 vendor
 product implementations on Oracle. Hopefully, I'm remebering this
 correctly!
 
 This being said, I've not touched the production DB for tuning or
 downtime
 since I created it back in October. After the software was installed
 (which
 also installs their version of Oracle and the DB) and re-installed
 several
 times prior to production, we moved the DB to a proper 6-way RAID 10
 (or is
 it 0+1? I forget) and some smaller mirrored stripes, splitting up
 data from
 control from redo from archive, and all's been well WITH THE DB ever
 since.
 I used what I consider standard items in the init.ora (CBO,
 archivelog,
 etc) and haven't needed to tune it. I haven't even (yet) needed to
 apply
 Tim Gorman's optimizer index parameter fixes. The only thing I've
 needed to
 watch for is the growth of the LOBs. YMMV!
 
 Also, our account rep has been VERY receptive in our feedback, and
 they are
 using some of our suggestions in versions since (and for other
 customers).
 I'll give them credit for that.
 
 One final note: Not every place is going to have a dedicated DBA.
 Most
 vendors that I've dealt with want to set things up in a simple
 generic
 fashion, probably in an effort to reduce initial problems. I think
 that may
 be a little short-sighted in some cases, as I think performance is a
 major
 cause of support calls (The system's slow) and can be very
 difficult to
 correctly troubleshoot and remedy remotely a year or two after
 implementation. Just my $.02 on that...
 
 HTH! GL! :)
 
 Rich
 
 Rich Jesse System/Database Administrator
 [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
 
 
 -Original Message-
 Sent: Wednesday, August 13, 2003 9:14 AM
 To: Multiple recipients of list ORACLE-L
 
 
 We are planning to install and test a product called PTC Windchill.
 Has
 anyone used this software? Is there any gotchas with it?
 
 TIA
 M.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jesse, Rich
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- 858-538-5051 http://www.fatcity.com
 San Diego, California -- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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!?
 The New Yahoo! Search - Faster. Easier. Bingo.



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

Re: what happens if a remove a job that is running?

[Hemant K Chitale]

I think that you will see it disappear from the dba_jobs view, though.
Hemant
At 06:59 AM 14-08-03 -0800, you wrote:
If I run dbms_job.remove on a job that is in dba_jobs_running it remains 
in that table.

it runs to completion correct?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 10G is real

[Hemant K Chitale]

Here's a note I compiled for my colleagues :
{in fact there are a large number of 10G presentations, I've just listed a 
few here
See 
http://www.oracleworld2003.com/catalog/search.jsp?force=trueprofileItem_id=58searchGroup=9searchGroupID=535}

Oracle will be formally launching 10G at the OracleWorld conference 07-11
September 2003.
[The G stands for Grid Computing, not next Geneartion or Global].
Some of the interesting Oracle 10G sessions at OracleWorld, SFO, September
03
Oracle Database 10G: A Revolution in Database Technology

Oracle Database 10G is a revolutionary database technology that lets you
deliver mission-critical, reliable, secure, and scalable service at the
lowest cost. This presentation explains how Oracle Database 10G lets you
leverage low-cost, modular storage and server hardware to build the data
center of the future: the enterprise grid. It describes new advances in
Oracle Database 10G to make the database more highly available than ever.
It then describes how Oracle Database 10G drastically cuts the cost of
management via new self-managing capabilities and the ability of a single
DBA to manage across numerous databases in an enterprise grid.
Oracle RAC 10G : The Fourth Generation
First-generation companies succeeded by using technology and intelligence
for tracking customer loyalty. Second-generation companies succeeded by
increasing sales through e-commerce. Third-generation companies succeeded
by consolidating, reducing costs, and improving processes.
Fourth-generation companies will use computer grids and succeed by being
adaptive, proactive, and agile. In this session, learn how new Oracle
Database 10G RAC features can help you skip a few generations.
Oracle Database 10G - RMAN and ATA Storage in Action
With the feature enhancements in the new version of RMAN, backup to and
recovery from disk using low cost, high capacity ATA storage provides
significant benefits to Oracle customers.This presentation describes the
many advantages of being able to complement tape backup with technology
that provides the ability to have more Oracle data on-line.The session will
talk to the feature enhancements in the new RMAN offering as well as the
service level benefits and best practices for ATA storage use in Oracle
Database 10G RMAN environments.
Oracle Database 10G Performance Overview: Scaling to the Grid

This session describes the performance and scalability enhancements in
Oracle Database 10G. Features covered include new data structures, faster
versions of the PL/SQL code generator and optimizer, InfiniBand support,
and improvements to partitioning and materialized views. For Windows users,
the session addresses support for Fibers and 64-bit Windows 2003 (first
announced with Oracle9i Database Release 2 in April 2003). The session also
covers performance features enabling migration to Enterprise Grid Computing
and concludes with an introduction to the new self-tuning features of
Oracle Database 10G.


Oracle Database 10G: The Self-Managing Database

Enterprise databases continue to grow in size and number, resulting in
increased systems management complexity. Oracle Database 10G introduces a
sophisticated self-managing database that automatically monitors, adapts,
and fixes itself. This presentation provides a technical overview of these
self-managing solutions that allow DBAs to become more productive, help
their organizations reduce management costs, and scale to manage the
Enterprise Computing Grid.


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: sar

[Hemant K Chitale]

I don't see how sar is a root access issue. On the Sun Solaris servers
at my site, I can always execute sar as oracle, I don't have to ask the
SysAdmin for permission.   {setting up the sa1 and sa2 jobs as cron jobs
is done by root, though}.
Hemant
At 07:44 AM 31-07-03 -0800, you wrote:
Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.
I cannot give you direct access to the sar command.  Because of the
parameters
the command allows, it would be equivalent to giving full root access.
If you could give me some details on the kind of information you would like
to
be able to collect, maybe we could set up some kind of command to obtain
it.
Henry

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: clustering

[Hemant K Chitale]

Ah. I never went to 9.0.1 I went from 8.1.5 OPS to 9.2.0.2
RAC, using Export-Import
and migrating to LMT, AutoAllocate, ASSM etc.
Hemant
At 05:24 AM 31-07-03 -0800, you wrote:
Hi!

I found out that these hanging problems were
version 9.0.1's problems. I wasn't directly involved with this setup. But
in 9.2 they say these problems are fixed. (One instance hits ORA-600 with
parameter 4519 and all instances would hang until restarted all
instances).
This was on 3-node tru64.

Tanel.

- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, July 29, 2003 6:19 PM
Subject: Re: clustering


Tanel,

I think that you've had some unfortunate experiences with RAC.
Mind elucdating them ?
I don't see nodes hanging when one node dies [I'm running a 2-node
Tru64 RAC Cluster]

Hemant

At 03:04 PM 28-07-03 -0800, you
wrote:
However, failed transactions must be handled from client side.
Queries may migrate to surviving nodes
transparently.
Also, currently RAC has many problems, such all nodes hanging when
one node dies. Completely separate systems are still (an will always be)
the most available solution.

Tanel.

- Original Message - 
From: Indy Johal 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, July 28, 2003 7:49 PM 
Subject: Re: clustering



Another Important different is that RAC is best High Availability
solution in case of System/Instance Failure where in case of HP or
Veritas Cluster, all of the resource get stopped on live system/node of
the cluster and then get started on second node and hence user will be
affected. But in case of system or Instance failure, there is seamless
transition of the User session in RAC 



Indy Johal



Ron Rogers [EMAIL PROTECTED]

Sent by: [EMAIL PROTECTED] 

07/28/03 12:29 PM 
Please respond to ORACLE-L 
 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
 cc: 
 Subject: Re: clustering





ak, 
As I understand it, an HP cluster is 2 boxes that have the capability 
to access the same disks and data but only one can have the oracle 
instance running and accessing the datafiles(active). Sort of like a 
high availability option. 
With RAC both boxes can access the instance and datafiles at the same 
time. 
List, Correct me if I need it. 
Ron

 [EMAIL PROTECTED] 07/28/03 12:14PM  
Hi Guys , 
I am new to this clustering concept. Just trying to understand few 
basics . Need ur help .

what is differece between oracle running on sun /hp cluster with 2 
nodes and oracle with RAC running on 2 nodes ? 

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

Fat City Network Services -- 858-538-5051 http://www.fatcity.com 
San Diego, California -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from). You may 
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


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

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

Re: optimizer parameters in Oracle 9.2

[Hemant K Chitale]

See  http://www.evdbt.com/SearchIntelligenceCBO.doc

Hemant
At 06:04 AM 30-07-03 -0800, you wrote:
Hi all:

I have been reading on the optimizer_ parameters for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching and optimizer_index_cost_adj.
I have also been playing whith them and I can see that
they affect the explain plans for some queries quite
dramatically. Is there any guidelines for what they
should be set to for optimum performance (some kind of
range and may be relationship between the values) or
is this mostly a trial and error kind of thing? I have
seen a few discussion on the Oracle Metalink, but
mostly they are very specific  - try this value or try
that value. Does anyone have a link to a document with
something more systematic than that?
thank you

Gene

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gurelei
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: 8.1.7.4 interim patch management strategy

[Hemant K Chitale]

I do not apply any one-off patch [except for Security patches] unless I have
actually encountered a situation where I need it or the application requires it
[e.g Apps R11 on 8.1.7.2 and 8.1.7.4 requires additional one-off patches].
The one-off patches are not regression-tested.

Security Patches must be applied [there's a seperate IT Security group
and these guys keep a watch on bugtraq , SANS etc and other alerts.
They don't see http://otn.oracle.com/security but do ask me about patches
notified by SANS]
Hemant
At 02:54 PM 29-07-03 -0800, you wrote:
Hello All,

There are 188 interim patches after 8.1.7.4 patchset. I know that
8.1.7.4 is the last patchset.
1. What methods/strategy do you'll have for installing patches on a
8.1.7.4 64 bit hp-ux 11.11 database?
2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i.
3. Should one install all the applicable patches (around 180 individual
patches)?
pessimistic (wait for the bug to hit and db to crash)
optimistic (install applicable patches)
4. How to manage the interdependencies between these 180 individual
patches?
5. Can we create a hp unix patch depot like thing for all these oracle
patches?
pls dont advise putting an enhancement request and upgrading to 9i/10i
:-)
Thanks,
Mandar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mandar A. Ghosalkar
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Resend : Question about EXTPROC and vulnerability

[Hemant K Chitale]

Thanks Arup.  It is a bit clearer now.

I do not grant CREATE LIBRARY privileges explicitly but these would be part of
the DBA role and I've seen the DBA role being granted all to easily.
My guess is that some of the seeded demo schemas in 9i also have such
privileges.  Here, again, I never install the demo schemas.
Regards
Hemant
At 07:29 AM 29-07-03 -0800, you wrote:
I sent a reply on that day. Here it is, once again.

 Date: Fri, 25 Jul 2003 12:25:59 -0400
 Subject: Re: Question about EXTPROC and vulnerability
Hemant,

You are right in wondering why there are three steps.

1. The lsitener must not be listening for the EXTPROC connections - that is
the first line of defense.
2. There is no absolute need to remove from tnsnames.ora, but good to do so
as you will see later.
3. The executabe has to be removed as it could be exploited in a different
manner. Note, all security alerts are based on what is known _today_; not
what is possible. Just because the listener is not listening for the extproc
executable does not _necessarily_ indicate that it can't be used in an
attack; an enterprising hacker may find a way. If your intention is to
remove extproc, you did so by removing from listener.ora; so it is just
prudent to remove the last potential hole by removing extproc executable,
too. After all, it not useful.
Now for the other question why the alter 57 does not talk about the
listener.ora security. The alerts 29 and 57 are similar, yet different. The
alert 29 talks about a buffer overflow using the external process. The
alert 57 is about system privileges. The system privilege, create library
will alow a hacker to create a library on any filesystem that the user
oracle has privileges on, INCLUDING THE ORACLE_HOME/BIN and $OH/lib!
Therefore, imagine a hacker breaks in, creates a library that uses the
Oracle excutables and java libraries and executes them. This is a huge hole
and should be plugged by simply disallowing any user to create a library.
Take for instance, a user has to create a library to create a function for
some complex mathemetical calculation, e.g. finding the prime numbers, which
can't be done in PL/SQL. This can be done via a C++ program and the shared
object can be made availabel to ORacle using a lbrary as:
create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so';

When a user uses this library, the EXTPROC process will run the .so file on
the user's behalf. Fair enough; what's wrong with that?
What is the user (the hacker) creates a library to point to some .so file in
$OH/lib directory? You get the picture what might happen.
Another variation of the create library is

create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so' AGENT
'dblink1'
Here the Oracle server process uses the dblink to connect to another
server's EXTPROC process to executes its task. Instead of using a dblink to
another server, it may actually connect to the extproc of the same server
using the connect string defined in the tnsnames.ora. It may not exist; but
what if the hacker actually copied the exeutable to a different name,
seemingly harmless. Removing extproc from tnsnames.ora wil lplug that hole
too. BEsides, it is a good practice to remove it since the presence
indicates the usage (albeit in the past) and may give a potential hacker a
clue.
Remember, securing is not just plugging the most obvious holes; but all
potential ones. The alerts point that out.
Another thing of note here is to plug a seprate potential problem - removing
the CREATE ANY DIRECTORY privilege. This provilege creates a directory on
any filesystem accessible by oracle user. Do not grant any one this
privilege; and be very cautious while granting CREATE DIRECTORY privilege,
too.
HTH.

Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 10:59 AM

 Resending this email, hoping for a reply this time.

 Date: Fri, 25 Jul 2003 07:49:24 -0800
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 X-Comment: Oracle RDBMS Community Forum
 X-Sender: Hemant K Chitale [EMAIL PROTECTED]
 Sender: [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 From: Hemant K Chitale [EMAIL PROTECTED]
 Subject: Question about EXTPROC and vulnerability
 Organization: Fat City Network Services, San Diego, California
 
 
 Oracle's Security Alert #29  [Note 175429.1] on the EXTPROC recommends
the
 workaround to disable
 EXTPROC as
 1.  Removing the entry for extproc/PLSExtproc/icache_extproc from the
  listener.ora
 2.  Removing the entry from the tnsnames.ora
 3.  Renaming or removing the extproc executable
 
 Why should all three actions be necessary ?  Why not just removing the
 entry from the
 listener.ora ?  Can extproc be called without the listener configured ?
 
 Security Alert #57 just talks of the CREATE LIBRARY privilege and makes
no
 mention of
 updating the listener.ora or tnsnames.ora or removing/renaming the
extproc
 executable

Resend : Question about EXTPROC and vulnerability

[Hemant K Chitale]

Resending this email, hoping for a reply this time.

Date: Fri, 25 Jul 2003 07:49:24 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Hemant K Chitale [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Hemant K Chitale [EMAIL PROTECTED]
Subject: Question about EXTPROC and vulnerability
Organization: Fat City Network Services, San Diego, California
Oracle's Security Alert #29  [Note 175429.1] on the EXTPROC recommends the 
workaround to disable
EXTPROC as
   1.  Removing the entry for extproc/PLSExtproc/icache_extproc from the 
listener.ora
   2.  Removing the entry from the tnsnames.ora
   3.  Renaming or removing the extproc executable

Why should all three actions be necessary ?  Why not just removing the 
entry from the
listener.ora ?  Can extproc be called without the listener configured ?

Security Alert #57 just talks of the CREATE LIBRARY privilege and makes no 
mention of
updating the listener.ora or tnsnames.ora or removing/renaming the extproc 
executable.  Why ?
Is it that Oracle wants people to use EXTPROC [or makes use of EXTPROC 
itself] so it
does not specify how EXTPROC can be disabled ?



Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).