Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: serverouput buffer overflow

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US