RE: Slow database, too MANY buffers???

2003-01-30 Thread Cunningham, Gerald
s.obj$ and sys.user$ rather than dba_extents. > > > "Thomas Day" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 01/24/2003 10:39 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list OR

Re: Slow database, too MANY buffers???

2003-01-25 Thread Jared Still
; > > Sent by: [EMAIL PROTECTED] > > 01/24/2003 10:39 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: > > Subject:Re: Slow database, too MANY

Re: Slow database, too MANY buffers???

2003-01-25 Thread Jonathan Lewis
And don't forget to use a no_merge hint in the in-line view. Oracle is getting far too smart about simplifying complex queries these days. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutori

Re: Slow database, too MANY buffers???

2003-01-25 Thread Stephane Faroult
To: Multiple > recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent by: rootcc: >Subject: Re: Slow database, > too MANY buffers??? > > 01/24/2003 12:34 > PM >

Re: Slow database, too MANY buffers???

2003-01-24 Thread Jared . Still
lt;[EMAIL PROTECTED]> cc: Subject: Re: Slow database, too MANY buffers??? So this is what you're looking for? col segment_name format a30 col segment_type format a10 select segment_name, segment_type, count(*) from dba_extents, x$bh where file_id = file# and dbablk be

Re: Slow database, too MANY buffers???

2003-01-24 Thread Thomas Day
cc: Subject: Re: Slow database, too MANY buffers??? 01

Re: Slow database, too MANY buffers???

2003-01-24 Thread Jared . Still
nts of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Slow database, too MANY buffers??? We'll I don't want to show my ignorance but I'll never learn if I don't ask. How do you get from DBABLK to PK_MATERIAL_ORDER_POOL?

Re: Slow database, too MANY buffers???

2003-01-24 Thread Thomas Day
ent by: rootcc: Subject: Re: Slow d

Re: Slow database, too MANY buffers???

2003-01-24 Thread Jared Still
On Friday 24 January 2003 02:23, Jonathan Lewis wrote: > I wouldn't necessarily be concerned, for example, > by Jared's example of a single block being at > 66 copies and all the rest at 6. I've earned the right to be picky with this particular application. :) Jared -- Please see the official

Re: Slow database, too MANY buffers???

2003-01-24 Thread Jonathan Lewis
Correct. Hot blocks (the most intensively used blocks) are always likely to leave chains of CR copies, or have CR copies built, but the number 6 will often show up as a fairly strict limit. The code "tries" to limit the number of CR block to 6 (according to a parameter with a name something like

RE: Slow database, too MANY buffers???

2003-01-23 Thread Cary Millsap
I got to see over 1,000 on a couple of cache buffers chains at one Oracle7 site a few years ago. This was prior to when Server Technologies set the limit of CR blocks in the buffer cache to 42 (spooky), and then eventually created (I think) the _db_block_max_cr_dba parameter. The cause was an appl

Re: Slow database, too MANY buffers???

2003-01-23 Thread Rajesh . Rao
mon.co.uk> cc: Sent by: Subject: Re: Slow database, too MANY buffers???

RE: Slow database, too MANY buffers???

2003-01-23 Thread Stephen Lee
>From your e-mail, I get the impression that there is a 687 Mb SGA on a box with 256 Mb. If that is the case, then the majority of the instance is sitting out on a swap file ... on a hard drive ... not in memory. For what it's worth, 687 Mb SGA is not **HUGE** (actually, it's rather small these

Re: Slow database, too MANY buffers???

2003-01-23 Thread Jared . Still
003 11:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Slow database, too MANY buffers??? You could try: selectfile#, dbablk, count(*) fromx$bh group by

Re: Slow database, too MANY buffers???

2003-01-23 Thread Jonathan Lewis
You could try: selectfile#, dbablk, count(*) fromx$bh group by file#, dbablk having count(*) > 5 ; (technically you should include the tablespace number, but that won't matter if you have less than 1022 files). This will report the blocks which have an un

RE: Slow database, too MANY buffers???

2003-01-23 Thread DENNIS WILLIAMS
Michael - Can you run a STATSPACK report or otherwise get a query of the wait statistics? Once you have that, you'll know where to go. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 23, 2003 12:47 P

Slow database, too MANY buffers???

2003-01-23 Thread Michael Kline
I've got a cust that is showing some signs that one would think is having a horrible problem on I/O...   I suspect it is the "error" of having a **HUGE** value in db_block_buffers and it's constantly crunching memory trying to figure out which ones to free up. It's only 256 meg, but depend