RE: Slow database, too MANY buffers???

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???

; > > 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???

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???

s.seg$, sys.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 ORACLE-L <[EMAIL PROTECTED]>

Re: Slow database, too MANY buffers???

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???

cc: Subject: Re: Slow database, too MANY buffers??? 01

Re: Slow database, too MANY buffers???

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???

ent by: rootcc: Subject: Re: Slow d

Re: Slow database, too MANY buffers???

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???

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???

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???

mon.co.uk> cc: Sent by: Subject: Re: Slow database, too MANY buffers???

RE: Slow database, too MANY buffers???

>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???

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???

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???

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???

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

RE: OT -- # tables in your db (was: Slow database)

:-)) > > : ) > > Regards, > > Patrice Boivin > Systems Analyst (Oracle DBA) > Bedford Institute of Oceanography > Fisheries and Oceans Canada > > > -----Original Message- > > From:   [EMAIL PROTECTED] > > Sent:   Thursday, March 29, 2001 9:

RE: OT -- # tables in your db (was: Slow database)

Title: RE: OT -- # tables in your db (was: Slow database) Nope, Cherie wins.  Before I left, I realized I had a database that had 19,000+ tables in it.  There were a ridiculous number of schemas.  Cherie, did you guys ever bust that database up into two?  -Original Message- From

Re: OT -- # tables in your db (was: Slow database)

raphy > Fisheries and Oceans Canada > > > -Original Message- > > From: [EMAIL PROTECTED] > > Sent: Thursday, March 29, 2001 9:51 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Slow database > > > > > > We are r

Re: OT -- # tables in your db (was: Slow database)

Happy Birthday Patrice! Here you go: SQL> select object_type, count(*) 2 from dba_objects 3 where owner != 'SYS' 4 andowner != 'SYSTEM' 5 andowner != 'CTXSYS' 6 andowner != 'DBSNMP' 7 group by object_type; OBJECT_TYPE COUNT(*) --- -- DATA

OT -- # tables in your db (was: Slow database)

iple recipients of list ORACLE-L > Subject: Slow database > > > We are running an oracle database 8i, we have several Ms Access > applications connected by ODBC to this database. The database is very > complex ,in total about 300 tables and of course PL/SQL procedures We &

Slow database

We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we

Re: Slow database

Hi, it's difficult to help you because we don't know anything about your nightmare skript. Either you do a business/application tuning about these procedures or you can create a ressource plan and drive this with low processor resources. oli -- Oliver Artelt Oracle Certified DBA cubeoffice

RE: Slow database

Maybe the "big" process is not doing intermittent commits, and is straining the rollback segments? Have you checked the growth and skew of your indices? Have you checked whether you can disable the indices while the process is running, then enable them? Is it doing inserts or updates or both? Does

Slow database

Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day, ma