Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Determining Busy Tables/Tablespaces
Rhugga wrote:
>
> Is there a view in Oracle that I can examine to determine which tables
> get the most activity (ie: Most reads, full scans, updates, etc..)
> Basically I am looking for usage statistics so that I segregate the
> busier objects onto idle disk groups. I am running 8.1.7.4.
>
> Thx,
> CC
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
www.dbazine.com/connor.html
has a brief summary of some ideas you could explore
hth
connor
Received on Thu Feb 06 2003 - 08:09:06 CST