Cannot tell for sure. Maybe - but there are lots of
other queries with FTS executed thoughout the week.
There appears to be no change to x$bh for these table
blocks (including buf#) .
-Ravi.
--- AK [EMAIL PROTECTED] wrote:
Did u do a full scan of table again after nocache
setting ?
-ak
Guys,
Help me figure this one out. Was helping a colleague
diagnose slow response time (8.1.7/Solaris running
Peoplesoft ). x$bh showed 102,248 out of 170,000
buffers belonged to a single table, which he said he
cached explicitly. He did NOCACHE (on my suggestion)
on the large table.
I still
Did u do a full scan of table again after nocache setting ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 12:20 PM
Guys,
Help me figure this one out. Was helping a colleague
diagnose slow response time
Hi Oli
My question is how to compute memeory require by table.
Regards
-Mala
From: Oliver Artelt [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: TABLE CACHE
Date: Wed, 07 Feb 2001 13:34:44 -0800
Hi
select blocks from
recipients of list ORACLE-L
Subject: Re: TABLE CACHE
Hi Oli
My question is how to compute memeory require by table.
Regards
-Mala
From: Oliver Artelt [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: TABLE CACHE
Date
Hi DBAs
I have one large table.I want to keep it into memory thru
alter table tname cache;
Is there any computation formula how much ram this table takes.
Please help me.Thanks in advance.
Regards
-Mala
_
Get Your Private,
PROTECTED]]
Sent: Wednesday, February 07, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: TABLE CACHE
Hi DBAs
I have one large table.I want to keep it into memory thru
alter table tname cache;
Is there any computation formula how much ram this table takes.
Please help
Hi
select blocks from dba_segments where segment_name ='table' shows the size
of your table.
oli
On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote:
Hi DBAs
I have one large table.I want to keep it into memory thru
alter table tname cache;
Is there any computation formula how