Re: serverouput buffer overflow

From: Rajagopal Venkataramany <rajagopalvr_at_excite.com>
Date: Fri, 11 Aug 2000 07:22:49 -0700 (PDT)
Message-Id: <10586.114358@fatcity.com>

Hi,

 Using UTL_FILE command would be the ideal solution to this. However,  if you are working from a windows client and find it difficult=20  to log into the db server machine, to see the file, then u can  insert all the details u want into a temp table and use sqlplus  to generate a report from the table.

Regards
Rajagopal Venkataramany

On Thu, 10 Aug 2000 08:31:53 -0800, ORACLE-L_at_fatcity.com wrote:

> Does anyone know how I can work around the 1000000 limit for server
output?
> =20
> I have a cursor that makes a list of all the indexes in a database, then
I
> use that to generate sql to file to analyze them in turn plus store thei=
r
> sizing info into a separate table.

> =20
> Unfortunately there is so much information generated in the cursor that
when
> I use dbms_output to produce the SQL, I reach the limit.

> =20

> Sqlplus only seems to spool once the command has finished, in this case
> until the whole PL/SQL loop has finished.

> =20

> I would prefer not having to break up the job into smaller cursors.

> =20

> TIA
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)

> =20


>  Systems Admin & Operations | Admin. et Exploit. des syst=E8mes

>  Technology Services        | Services technologiques

>  Informatics Branch         | Direction de l'informatique=20

>  Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

> =20

> --
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca

> =20


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

Regards
Rajagopal Venkataramany

---

Say Bye to Slow Internet! Received on Fri Aug 11 2000 - 09:22:49 CDT