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

Home -> Community -> Usenet -> c.d.o.server -> Re: MAXQUERYLEN clarification

Re: MAXQUERYLEN clarification

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 19 Apr 2007 18:18:35 +0200
Message-ID: <4627965a$0$24675$426a34cc@news.free.fr>

"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

Original text of this message

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