I downloaded it from metalink a while back. It was pretty straight forward to install. The report name was something different like statsrep.sql or statsrep80.sql. Also, there was a view that had to be created. All the information/instructions were in the tar file that I downloaded.
If you can't find it on metalink, let me know, and I will round up my old notes and the tar file and send it to you. Rob Pegram Oracle Certified DBA --- Jack van Zanen <[EMAIL PROTECTED]> wrote: > Hi > > I have in the past seen a download for a backported > statspack on I believe > OTN. This would work on Oracle 8.0.5 > Maybe still there > > Jack > > > > > > "Baker, Barbara" > > > <bbaker@denvernewspaper > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > agency.com> > cc: (bcc: Jack van > Zanen/nlzanen1/External/MEY/NL) > > Sent by: > Subject: order by in subquery workaround > > [EMAIL PROTECTED] > > > > > > > > > 11-07-2002 19:38 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > Solaris 2.6 > > Oracle RDBMS v8.0.5.2.1 > > > List: > I'm trying to run a retrofit of statspack on an > 8.0.5 database. (ya, I > know. upgrading would actually be easier....) > The statspack stuff came from an 8.1.7 install I > have on the same box. > > The spreport.sql report encounters errors in the > "order by" clause. The > problem is that you can't do an "order by" on a > subquery before version > 8.1.something-or-other > > I know there's some kind of work around for this. I > had something to do > with a hint. Even after 3 cups of coffee, I can't > remember what it is. > > Can anyone help? > Thanks! > Barb > > here are the errors: > > Shared Pool Statistics Begin End > ------ ------ > Memory Usage %: 75.99 70.05 > % SQL with executions>1: 21.95 48.60 > % Memory for SQL w/exec>1: 11.28 21.84 > order by time desc, waits desc > * > ERROR at line 24: > ORA-00907: missing right parenthesis > > > > > pmon timer 1,184 1,177 > 355,304 3001 > 0.2 > > ------------------------------------------------------------- > order by (e.buffer_gets - > nvl(b.buffer_gets,0)) desc, e.hash_value, > st.piece > * > ERROR at line 41: > ORA-00907: missing right parenthesis > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > =================================================================== > De informatie verzonden in dit e-mailbericht is > vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. > Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking > van deze informatie aan > derden is, behoudens voorafgaande schriftelijke > toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in > voor de juiste en > volledige overbrenging van de inhoud van een > verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan > niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch > dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst > van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is > gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te > retourneren aan de verzender > en het origineel en eventuele kopie�n te verwijderen > en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar > werkzaamheden algemene > voorwaarden, waarin een beperking van > aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos > toegezonden. > ===================================================================== > The information contained in this communication is > confidential and is > intended solely for the use of the individual or > entity to whom it is > addressed. You should not copy, disclose or > distribute this communication > without the authority of Ernst & Young. Ernst & > Young is neither liable for > the proper and complete transmission of the > information contained in this > communication nor for any delay in its receipt. > Ernst & Young does not > guarantee that the integrity of this communication > has been maintained nor > that the communication is free of viruses, > interceptions or interference. > > If you are not the intended recipient of this > communication please return > the communication to the sender and delete and > destroy all copies. > > In carrying out its engagements, Ernst & Young > applies general terms and > conditions, which contain a clause that limits its > liability. A copy of > these terms and conditions is available on request > free of charge. > =================================================================== > > > > > > > -- > === message truncated === __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
