Re: Insert Speed on 8.0.5 on Linux/Solaris

Hi Alan,

In the session that does the inserts just before it disconnects do ...

select e.event, e.time_waited
from v$session_event e, v$session s
where s.audsid = userenv('SessionID')
and e.sid = s.sid;

select s.name, m.value
from v$mystat m, v$statname s
where m.statistic# = s.statistic#
and s.name = 'CPU used by this session';

Thanks,
Steve Adams

In article <924607142.14571.0.nnrp-04.c2d97406_at_news.demon.co.uk>,   "Alan Barclay" <escribe_at_my-dejanews.com> wrote:
>
> Steve Adams wrote in message <7fg36c$urm$1_at_nnrp1.dejanews.com>...
> >Hi Alan,
> >
> >Could we please have just the event name and time waited and only for the
> >session that did the inserts?
> >
> >Regards,
> >Steve Adams
>
> How do I do that then?
>
> The session outputs which I listed were done after shutting down and
> restarting the DBs so that the counts would be reset.
>
> Alan.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 08:09:49 CDT