I'd like to look at it from the object level and see how much I/O is being
done on specific table or index and then check which sessions are
responsible for that.
also, what's the catalog table you would recommend me to use if I want to
see I/O activity on an object regardless of the session?
On
I'd like to look at it from the object level and see how much I/O is being
done on specific table or index and then check which sessions are
responsible for that.
also, what's the catalog table you would recommend me to use if I want to
see I/O activity on an object regardless of the
On 2010/09/12 23:02, adi hirschtein wrote:
I'm coming from the Oracle side of the house and In oracle for instance, you
use shared buffer as well, but you are still able to see which session is
waiting for which blocks
and if one session is doing the real I/O then the other one wait on 'wait
Thanks!
I'll look into those system tools and probably come back with some more
questions...
Best,
Adi
On Mon, Sep 13, 2010 at 4:58 AM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 09/12/2010 10:02 PM, adi hirschtein wrote:
Hi Craig,
Thanks a lot for the quick response!
I'm coming
adi hirschtein wrote:
Using the catalog tables, is there any way to correlate session
id/user id to which object (i.e. tables, indexes etc) it access and
much how disk reads or I/O wait has been done against the objects.
in general, I'd like to see which objects are being accessed by which
On 09/12/2010 06:52 PM, adi hirschtein wrote:
Hi,
Using the catalog tables, is there any way to correlate session id/user
id to which object (i.e. tables, indexes etc) it access and much how
disk reads or I/O wait has been done against the objects.
in general, I'd like to see which objects are
Hi Craig,
Thanks a lot for the quick response!
I'm coming from the Oracle side of the house and In oracle for instance, you
use shared buffer as well, but you are still able to see which session is
waiting for which blocks
and if one session is doing the real I/O then the other one wait on 'wait
On 09/12/2010 10:02 PM, adi hirschtein wrote:
Hi Craig,
Thanks a lot for the quick response!
I'm coming from the Oracle side of the house and In oracle for instance,
you use shared buffer as well, but you are still able to see which
session is waiting for which blocks and if one session is