Pardon !

I had problem with my mail box;

Thank you four your precise response!

Regards

-----Message d'origine-----
De : Edwards Ed [mailto:oracledba-ezmlmshield-x19491313.[Email address protected]
Envoyé : mardi 6 mars 2007 13:43
À : LazyDBA Discussion
Objet : RE: size limited on IAS 10g

Well,well, well,
It's Zoheir Belmahdi! Hehe. How have you been? I must said "You
never give up"! hehe. I don't think you can limit the size of the
"log" files created on the Oracle Application Server (OAS) with a
number. What I do on a daily basis is eyeball those files and see if
they are any rows that are worth keeping. Usually, everything runs with
no problems. So I run the following two files:

--Save the code below in a file named "count_lines.vbs"
--This code counts all lines in a files

i = 0
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("D:\Oracle\alert_orcl.log", 1)
DO Until objFile.AtEndOfStream
objFile.ReadLine
i = i + 1
Loop
objFile.Close
Wscript.Echo(i)


--Save the code below in a file named "delete_lines.vbs"
--This code deletes all lines in a files except the first four lines

Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fso, fi, fo, nLines, sInFile, sOutFile, j

j = 0

sInFile = "D:\Oracle\alert_orcl.log"
sOutFile = "D:\Oracle\alert_orcl.txt"
Set fso = CreateObject("Scripting.FileSystemObject")

Set fi = fso.OpenTextFile(sInFile, ForAppending)
nLines = fi.Line
fi.close

Set fi = fso.OpenTextFile(sInFile, ForReading)
Set fo = fso.OpenTextFile(sOutFile, ForWriting, true)

for i = 1 to nLines - 1
if i >= 1 and i <= 4 then
fo.Writeline fi.readline
j = j + 1
else
fi.readline
end if
next

fi.close
fo.close
wsh.echo "Done:", nLines - 2, "lines read."
wsh.echo "Done:", j, "lines written."

I know in the httpd.conf file, you can define log locations, loggings,
and formats. You can limit the size of the httpd.conf file by using
"LogLevel error". There maybe something like that for the other files.

Have a great Day!






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Zoheir Belmahdi
[mailto:oracledba-ezmlmshield-x25408686.[Email address protected]
Sent: Tuesday, March 06, 2007 4:28 AM
To: LazyDBA Discussion
Subject: RE: size limited on IAS 10g

Hi all

I want to limlit size of

1/

F:\OraHome1\j2ee\OC4J_BI_Forms\log\OC4J_BI_Forms_default_island_1

default-web-access.log 7 Go


2/

F:\OraHome1\forms90\trace

ifweb90_dump_2136 50 Go

regards



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page