Re: hot tables
From: Brent <bpathakis_at_yahoo.com>
Date: 28 Oct 2002 07:36:56 -0800
Message-ID: <1736c3ae.0210280736.5ca2c309_at_posting.google.com>
Date: 28 Oct 2002 07:36:56 -0800
Message-ID: <1736c3ae.0210280736.5ca2c309_at_posting.google.com>
sergeev_at_ubrr.ru (Pavel Sergeev) wrote in message news:<12dd4573.0210272251.7e06100c_at_posting.google.com>...
> Hi.
> I want to know about hot tables.
> Hot tables are tables with high io.
> Best wishes, Pavel Sergeev.
Okay... not a lot of info to go on...but I'm guessing you want to know which tables have the most IO.
I like to separate my tables into different tablespace using
LMT's with uniform extent sizes ... based on small, medium, large
tables.
That makes it easy to track IO using a tool like statspack.
If I have one or two tables I know are active, I might put them into another tablespace. Received on Mon Oct 28 2002 - 16:36:56 CET