Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Determining Busy Tables/Tablespaces

Re: Determining Busy Tables/Tablespaces

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 06 Feb 2003 22:09:06 +0800
Message-ID: <3E426C82.4E39@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US