Re: performance

Ravi,

ARCHIVELOG isn't "obviously slow"; it is the default method of operation for most Oracle installations. Your experience is not the norm (though not uncommon, to be sure!), so I'm sure it can be fixed (unless your system is grossly underconfigured). If you have some form of contention in the redo log generation/archival stream, then it will be slower than NOARCHIVELOG, but most of the range of possible problems are quite easily dealt with. Rather than speculate in the absence of information, it would be best if you gather hard data to pinpoint exactly where the problems are...

I would suggest enabling STATSPACK, but doing so is somewhat involved. To determine if you want to do this, the best documentation is online in a file called "spdoc.txt" located in the "$ORACLE_HOME/rdbms/admin" directory. There are also notes and bulletins on MetaLink as well as other sites on the internet (search www.google.com for STATSPACK).

For more immediate results, please run the "utlbstat/utlestat" scripts during a period of about 20-30 minutes while you are experiencing "slowness". Take the resulting "report.txt" file (generated by "utlestat.sql" from SVRMGRL) and upload it to the http://www.oraperf.com website in order to get a YAPP analysis report, which is returned in HTML format. You have to register for a login to use that site and it's facilities, but it is free and well worth the 30 seconds involved...

If you need help interpreting the output from the YAPP report, then please paste the original "report.txt" report into an email back to this list and I'm sure a couple folks would be delighted to run a YAPP report with it and help interpret it with you. There are no security issues with the data in a "report.txt" or STATSPACK report, unless your datafile names are classified :-). Also, there are several "white papers" on the http://www.oraperf.com site which explain the methodology of "response time analysis" using the YAPP report which might help; click on the link for "white papers" in the left-hand navigation bar...

Hope this helps...

-Tim

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, June 29, 2002 1:13 PM

> Dear All,
>
> Can any one please give me some hints or tips when we
> move to archive mode? when Our DB is non-archive mode
> that was ok,when we moved to Archive, it is dead slow.
>
> Obviosuly archive mode performance is slow, is there
> any other precations to be taken care?
>
> Thanks for your help.
> Cheers,
> Ravi
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Nalla=20Ravi?=
> INET: vvnrk2001_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

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