Re: table function help

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 27 Dec 2012 14:20:49 -0600
Message-ID: <CAJvnOJatfydT8BqvfBsrqT9mj0tNwDFRD7u0oe9Y0bXwPGhZ-Q_at_mail.gmail.com>

Hi, I already have the solution to this, thanks. Thanks to Raj Jamadagni<https://plus.google.com/u/0/107377698524988211109?prsrc=4>for providing the answerI had to change the query to read like this: l_query varchar2(32000):='select redo_gen_format(b.inst_id,

b.sid,
b.serial#,
b.username,
b.machine,
b.osuser,
b.status,

round(a.value/1024/1024)) as my_row
from sys.gv_$sesstat a,
sys.gv_$session b
where a.statistic#=175
and a.inst_id=b.inst_id
and a.sid=b.sid ';

It just not something I have had occasion to do much with.

On Thu, Dec 27, 2012 at 2:16 PM, Sayan Malakshinov <xt.and.r_at_gmail.com>wrote:

> Hi, Andrew!
>
> Here is example of this:
> (formatted - https://gist.github.com/4391444 )
> Some additions:
> 1. I created this without nds, but if needed you can use "execute
> immediate" instead of declared cursor
> 2. You can change cursor to parameterized one
> 3. I'm not sure that there is needed "bulk collect", as a function is
> pipelined, maybe would be better to fetch with limits
>
> create or replace package pkg_redo_gen as
> cursor c is
> select
> b.inst_id,
> b.sid,
> b.serial#,
> b.username,
> b.machine,
> b.osuser,
> b.status,
> round(a.value/1024/1024) redo_mb
> from
> gv$sesstat a,
> gv$session b
> where
> a.statistic#=175
> and a.inst_id=b.inst_id
> and a.sid=b.sid;
>
> <SNIP> <%2B7%20903%20207-1576>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 27 2012 - 21:20:49 CET