Re: View
From: Vince Germscheid <Vince_Germscheid_at_cscmail.csc.com>
Date: 1996/09/26
Message-ID: <01bbabf5$45b13840$211e0814_at_vgermscheid.min.csc.com>#1/1
Date: 1996/09/26
Message-ID: <01bbabf5$45b13840$211e0814_at_vgermscheid.min.csc.com>#1/1
The view v$sesstats has a number of statistics about all sessions executing on the database, including number of rows for both full table scans as well as fetches by rowid. You will need to join it to v$statname and v$session to get username and statistic name.
Vince.
Dussan Pirc <dussan.pirc_at_mop.sigov.mail.si> wrote in article
<52bh4k$sdf_at_sigov1.sigov.si>...
> I have application which is working with oracle (btw. it is ESRI SDE).
> I wish to know how many data is retriving from database.
>
> Is there a view containg informations about hov many data (rows,
> bytes, etc..) one user is getting in a period of time.
>
> I appreciate your help,
> Dussan
>
>
Received on Thu Sep 26 1996 - 00:00:00 CEST