Re: How to get the maximum space used in TEMP during process execution

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Fri, 7 Nov 2014 11:51:42 -0200
Message-ID: <CAJdDhaPvJvyE9JY94WsGr0aEah8VAE7jE3DjKnb=dMO7dt_5ww_at_mail.gmail.com>



Thanks all for answering about Temporary tables. Eriovaldo

2014-11-02 7:19 GMT-02:00 Eriovaldo Andrietta <ecandrietta_at_gmail.com>:

> Hello,
>
> I would like to know if this way is correct. If no, what is the correct
> way to get the maximum space used during a process execution.
>
> I am doing it:
>
> begin
> dbms_application_info.set_module(module_name => 'MY_PROCESS_001'
> ,action_name => '');
> end;
> /
>
> then I execute the process:
> select * from ...
> update table set ...
> delete table ...
> exec procedure ....
>
> at final I do:
>
> select max(temp_space_allocated/1024/1024) TEMP_MB
> from v$active_session_history
> where module = 'MY_PROCESS_001';
>
> The result of this query is the maximum space quantity used in TEMP during
> all the time. Is it correct ?
>
> Is there another way to do it ?
>
> Regards
> Eriovaldo
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 07 2014 - 14:51:42 CET

Original text of this message