Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MAXQUERYLEN clarification
"David.E.M...._at_gmail.com" <David.E.Murphy_at_gmail.com> a écrit dans le message de news:
1176998310.151385.171770_at_n76g2000hsh.googlegroups.com...
|I am trying to understand MAXQUERYLEN. If anyone could help I would
| appreciate it. This is what I know:
|
| MAXQUERYLEN - The length of a query is measured from the cursor open
| time to the last fetch/execute time of the cursor. Also, I have heard
| of it as - time for a process to complete, time for a transaction to
| complete, time for a report to complete, etc.
|
| I ask this because of trouble with my undo space growing and I would
| like to split up a function to reduce this from happening, but I want
| to make sure I am on the right track without going further.
|
| The script I would like to split is compiled into the db as a
| procedure. The script starts by dropping a bunch of tables. Then
| there is the CREATE OR REPLACE PROCEDURE line followed shortly after
| by a BEGIN and the last line is an END. Within the procedure there
| are numerous begin/end blocks. There are also numerous DELETE FROM
| lines. There are COMMIT statements throughout.
|
| Is MAXQUERYLEN the time it takes for the entire procedure to run?
| Is MAXQUERYLEN the time it takes between COMMIT statements?
| Is MAXQUERYLEN the time it takes for the innermost begin/end blocks to
| complete?
| Is MAXQUERYLEN the time it takes for the outermost begin/end blocks to
| complete?
| Is MAXQUERYLEN the time it takes for a single line of sql to complete?
|
| This was probably covered in plsql 101 but I never took that...
|
| Thanks!
|
What about making some tests?
Just a small procedure with several blocks calling dbms_lock.sleep and
commiting. Simple, easy, fast.
Regards
Michel Cadot
Received on Thu Apr 19 2007 - 11:18:35 CDT