Re: Re:RE: Deadlock

this session (the one that dumped the graph) the same as the SQL that has been dumped for the other session ? Most critically - do you have any triggers on the child table that may be doing parent table activity that you've overlooked ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk

Re: direct distributed insert causes massive sorting on target, why?

rather than a special case that a serial process could see. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html

Re: X$dual and Dual: performance and others?

time to time. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co

Re: Row cache locks on INSERTs with a sequence

; end; I couldn't get a single row cache lock wait. This was using 8.1.7.4 on HPUX 11. So I wonder if the waits you were seeing were a side-effect of another issue, or highly version dependent. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost

Re: db block Size for Indexes Tablespaces in 9.2 ?

expect to notice, then figure out if any of those points are relevant to your system, then devise a realistic test to find out if any hypothetical benefit turns into a real benefit. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation

Re: Indentifying Redundant Indexes

store only one plan, but the same (or apparently identical) piece of SQL could have conflicting plans because of a hidden rls predicate. 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/tutorial.html

Re: Row cache locks on INSERTs with a sequence

Correct - I was sure that I had a set of test results to prove my point, but I didn't - so I've just run a series of tests on enqueue and buffer busy waits on an 8.1.7.4 system and you are absolutely right - the seconds_in_wait does not reset as the wait completes. Thanks, Jonathan Lewis

Re: tracing error stack - finding the cause of a ORA-00917 error

You might want to look at dbms_system.set_ev Parameters: sid serial event number level event name -- leave null in your case . Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http

Re: Row cache locks on INSERTs with a sequence

. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ

Re: Re:RE: Deadlock

whether this was an ORA-04020 deadlock (dictionary internal) or ORA-00060 (data related). I think the text is the one that comes with ORA-00060, but the two texts are pretty similar. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based

Re: performance comparision between LMT and DMT

. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ

Re: Re:RE: Deadlock

MAXTRANS can be set to 1, so you need only use two sessions and two rows per block. 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/tutorial.html ) Next Seminar dates: (see http

Re: Row cache locks on INSERTs with a sequence

If the wait times on the latch were significant, I think I'd check that the inserts were high volume inserts into tables with a very small extent sizes and lots of indexes, also with very small extents. I wouldn't have thought it was anything to do with sequences. Regards Jonathan Lewis http

Re: Row cache locks on INSERTs with a sequence

(at least on my 9.2 system - the values may vary across version). I based my comments on dc_segments - not on the cache id number - still, I got lucky ! Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http

Re: Cardinality of indexed columns... how to discover? What is the ma

further down your current path, you might like to read a couple of articles I've written about bitmap indexes at www.dbazine.com 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/tutorial.html

Histograms

completely baffled. Any insights would be appreciated. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html

Re: Re:RE: Deadlock

is a deadlock - which will show a deadlock graph with holders in mode 6 and waiters in mode 4. (X and S if I've got the letters right - personally I prefer numbers). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http

Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

because most of your buffer space is flooded with hot BMBs and the data has to keep thrashing on and off disk. 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/tutorial.html ) Next Seminar dates

Re: Faking an ORA-600

and b2 between 40 and 80 ; I think this one breaks an 8.1.6 database. 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk

Re: Online Redifinition in 8i ?

Not all that hard - but I don't like the bit that starts update obj$ set 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/tutorial.html ) Next Seminar dates: (see http

Re: Direct Path Inserts and Partition Splits

for shunting data above the current high_value into a holding table. (Requiring end-user code to handle rogue data would otherwise introduce a significant overhead on processing times). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation

Re: db block Size for Indexes Tablespaces in 9.2 ?

they needed a large block size ? 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/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23

Re: Transportable Tablespaces as backup?

in that tablespace couldn't possibly need any local work done for read consistency). 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/tutorial.html ) Next Seminar dates: (see http

Re: Direct Path Inserts and Partition Splits

flushing the shared pool before doing the trace - if the dictionary cache holds all the defining information, a trace file may not show the cause of such an error; but if the defining data has to be reloaded into the dictionary cache, then you may spot the FETCH that fails. Regards Jonathan Lewis

OT - change in Oracle's marketing strategy

The article below has produced more feedback than any of the others I have written, so I thought I'd share it with Oracle-L http://www.jlcomp.demon.co.uk/tar.html Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http

Re: Autoextend WAIT statistic?

granularity - except in a set of 8.1.6 NT databases I was looking at today) whilst the state is WAITING. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) Denver___December 2/4 England__January 21/23

Re: Mass updates to production tables (NULL to non-NULL)

off and on when I have time, but not dealing with 9iR2 (or R1) on a daily basis I had no idea about the DBMS_XPLAN package in 9iR2. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL

Re: Mass updates to production tables (NULL to non-NULL)

for costing when the new cpu_costing method is switched on, an adjusted dbf_mbrc is used when the traditional io_costing method is the only thing in place). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html

Re: Mass updates to production tables (NULL to non-NULL)

at read-consistency, and cyclic block flushing. Note - ORA-01555 need not matter, if you have a mechanism that can respond to it gracefully. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) Denver___December 2/4

Re: Mass updates to production tables (NULL to non-NULL)

is null and rownum = 1; repeat until rows updated 10,000 Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) Denver___December 2/4 England__January 21/23 The Co-operative Oracle Users' FAQ http

Re: DIRECT PATH READ wait events

as a side-effect of increasing the SQL*Plus arraysize. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Re: ITL Deadlock Example?

and three concurrent sessions, but for consistency you need to have three blocks of data and rotate through the sessions updating one row in each block from each session in turn. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar

Re: Performance issue , OCI related ? - urgent , please

to be applied as the fetch progresses to preserve read-consistency, but I wouldn't expect the effect to be as extreme as your figures indicate. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Re: ITL Deadlock Example?

) that I've found so far - but I don't think I've seen one quite like this. Are you using any of: distributed transaction partitioned tables parallel DML Autonomous transactions Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar

Re: ID This Wait stat

I think if you look at the v$session_event view, you will find that these are idle waits by the various dbw slave processes. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Re: Wait Event PX Deq: Execution Msg

the rows from all the slaves and passed them to the front end. This means that it is a usually an idle event - but it may be a symptom of excessively large queries choosing an inappropriate execution path. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building

Re: too low optimizer_index_cost_adj causing bizarre index choice

the issue further by expounding a hypothesis that may be totally misleading. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle

Re: too low optimizer_index_cost_adj causing bizarre index choice

are the reason why Oracle decided that a full indexed path was cheaper than a scan. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative

Re: Reverse Key Index Performance

- with the reverse key, you COULD get 0% buffering on the leaf blocks. It tallies with the timing - does it tally with the execution path ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Re: SMJ, NL or HJ

Notes inline. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: Reverse Key Index Performance

in 9.0 yet. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: shared pool memory issue on OPS (non-MTS)

not for user access ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: SMJ, NL or HJ

table B table A Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq

Re: Oracle-L gathering etc.

the offer has disappeared. Thank for the tip about ISBN Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Re: Changing SQL statements inside the database

. This is partly to do with an invalidation issue that Tom Kyte describes in his book. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co

Re: Partitoned Table Insert Performance

to maximise the probability of adjacent inserts being to different partitions Overhead ca. 50% Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host

Re: shared pool memory issue on OPS (non-MTS)

Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message

Re: shared pool memory issue on OPS (non-MTS)

and KEEP'ed in this instance before the other instance starts up, making this instance the resource master for a very large dictionary cache ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Oracle-L gathering etc.

trio of James Morle, Steve Adams, and Jonathan Lewis. http://www.amazon.com/exec/obidos/ASIN/0201715848/qid%3D974459938/sr%3 D1-12/103-3940479-8339835 (which URL will probably get broken and wrapped) Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient

Re: bad execution plan

on ? My guess would be that Oracle has switched to indexed access and merge joins because it has estimated a zero row return from STAGING.BECONS STAGING.BECATD Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia

Re: single clustered tables

for partitioned table. Bear in mind that you cannot do direct path loads to clustered tables - (another common practice with d/w systems - but if you can't partition, this may be irrelevant anyway). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient

Re: DBMS_STATS.gather_database_stats

: But this report against user_ind_columns user_indexes user_constraints user_constraint_cols user_tables runs perfectly under rule-based and dies under cost-based. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next

Re: CPU Pegged at 100%

Is it necessary to copy the entire report.txt every time you make a short response to this question. So far I think I have received 10 copies of a 155K report. (And it wasn't all that exciting the first time around ;) Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle

Re: Curious question about flushing the Pool

be a good thing. Maybe yet another undocumented hint /*+ bypass_cache_flush */ would be sufficient. One (trivial ?) thing I'd like to see is SQL normalised before it goes into the shared pool. Oracle 9i does it with stored_outlines - why not with all SQL ? Jonathan Lewis http://www.jlcomp.demon.co.uk

Re: Curious question about flushing the Pool

So have you tried dropping your SGA to 275MB so that the stuff that is useful can be found quicker and latches are held for a shorter time ? Also consider looking at cursor_sharing - it's a band-aid but it can work well in extremis. Jonathan Lewis http://www.jlcomp.demon.co.uk Author

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

may find that some of the 8.0 indexes were deemed redundant by the 8.1 import, so you may have invisibly dropped an index supporting a foreign key. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August

Re: DBMS_STATS.gather_database_stats

. Consequently the 'special' code for analyzing the database simply included a predicate which said: obj$.name not in ('FET$','UET$','SEG$') Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Re: Re: Oracle invents time machine - optimizer now faster than l

So that's how they implement flashback queries in 10i. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Re: Clob indexes

if there is a 'bitand(flag,)' line in the query that identifies indexes that excludes LOB indexes. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host

Re: Currval and buffer gets

; You will really kill the system, because every time you hard-parse a statement containing a view, Oracle re-executes a recursive query like: select text from view$ where rowid = ... (Believe it - it has been done). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i

Re: good value for optimizer_index_cost_adj

times and average multiblock read size. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Re: good value for optimizer_index_cost_adj

or the other. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: good value for optimizer_index_cost_adj

accessed as a consequence of index block reads, but can be one-off blocks in table scans and index fast full scans due to the existence of previously buffered blocks or tail-end blocks on extents. And then there are cached LOB reads and Jonathan Lewis http

Re: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

never gets mentioned. I would also like to point out that not all 'hit ratios' are bad. The FAN hit ratio is a very useful indicator. (see http://miracleas.dk/undskyld/fhr.pdf in the short term for further details). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i

Re: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

of the time X is 'the amount of time it ought to take' and Y is 'the amount of time it does take'. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co

Oracle invents time machine - optimizer now faster than light.

it started. Now that's how to pass a benchmark ! Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Re: Oracle invents time machine - optimizer now faster than light.

You mean a soft parse is allowed to finish before it starts ? Or maybe it has to be a soft parse, by SYS, on a recursive statement that uses the rule-based optimiser ;) Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar

Re: Oracle invents time machine - optimizer now faster than light.

=0,mis=1,r=0,dep=0,og=4,tim=1019495629321662 Note the complete absence of PARSE #1, and the 'massive' 32,000 microsecond back-step. In general, however, the PARSE seems to be a fairly persistent 110 micro seconds out of step. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical

Re: Currval and buffer gets

It's a change that also made it into 8.1.7.3 (or possibly 8.1.7.2) - check in $ORACLE_HOME/rdbms/admin/standard.sql Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk

Re: Execution plan optimizer Question

of those fine urban legends? |For the time being I am starting out with a small test database. |-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: ioug-a question

, either your database is working too hard, or it's not being allowed to work. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative

Re: Currval and buffer gets

directly, and the RETURNING clause to find out what the inserted value was can reduce calls to SQL from PL/SQL quite dramatically. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http

Re: ORA-01722

to force the optimizer to eliminate any rows that would return an ORA-0 1722. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle

Re: Enqueue and DB File Sequential Read Waits Problem

this was on a Sun that was under extreme pressure, and I made the same assumption that you did - now I'm beginning to wonder if there is more to it than that). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August

Re: Help with Locking Issue

- two foreign keys, but only one of them index by virtue of the composite primary key. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co

Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)

and seeing what the difference in CPU is ? Until you can reduce the CPU time to something like 0.01 seconds, your application will not scale. (Your simple table isn't partitioned is it ?) Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases

Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)

of the IN list). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: Security Hole

Tur64 UNIX Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: forced code path?

it to take. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Re: Help with Locking Issue

Any bitmap indexes on the table ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http

Security Hole

didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia

Re: PX Deq: Table Q qref

' command. You are dumping a lot of data to a spool file - you haven't exceeded the file size that SQL*Plus can managed have you ? Perhaps something is going wrong there. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar

Re: cache buffer chains contention

. Bottom line, though, is that if the session does not appear to be in an Oracle-recorded wait state, it is either using (or scheduled to use) CPU, or you've hit a wait state that isn't instrumented properly. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http

Re: Exchanging partition takes a lot of times

. The solution/workaround is to set the constraints to a RELY ENABLE NOVALIDATE. But the last time I checked you still got problems with partitioned tables in involved in parent/child relationships. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http

Re: Explain: In List Iterator

AND, bitmap MERGE etc.) Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL

Re: Does index need rebuilding when table is truncated

describe the behaviour of table data blocks, and ignore the fact that indexes consist of data blocks which are sometimes handled differently - (although as in this case they are sometimes handled identically to the table). Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle

Re: cache buffer chains contention

, though, and if you session REALLY is doing nothing for 30 seconds, then you've hit one; however normally I would say that your session is busy doing something (from Oracle's perspective) in that 30 seconds. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users

Re: Buf Hit Ratio

to match. You are running a 64-bit version of Oracle, and the code the exposes v$sysstat (or rather the x$ underlying it) is not quite in-line with the actual memory content. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk

Re: Decyphering LMT space bitmap

a question of working out the byte and word swapping in the dump. Temporary tablespaces are different, though, as the 'bitmap' is actually 2 bytes per extent because temporary extents 'belong' to instances and each 'bit' needs to have the current owning instance associated with it. Jonathan Lewis

Re: Decyphering LMT space bitmap

header, 2 blocks for the bitmap. Could anyone confirm that, thanks ? Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message

Re: Decyphering LMT space bitmap

of the file. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: FUNCTION.

: Miscellaneous - In Lists Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases

Re: Odd Sql result

Are you sure you aren't running 9i with: alter session set sessiontimezone = 'UTC+72:00': Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk

Re: odd explain plan

other than tiny and the db_file_multiblock_read_count isn't kept very small. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author

Re: How much memory is consumed by cache tables?

to find just one row, and 10 datablocks in the buffer (plus one segment header, plus one first level bitmap plus one second level bitmap). Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle

Re: alter table tabname drop column colname checkpoint #;

checkpoint every NNN rows. If you specify: alter table tabX drop column colX checkpoint; without a rowcount, then you checkpoint every 512 rows. You post doesn't include the checkpoint keyword, so I guess you hit the top option. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK

Re: Customize my SQLPlus login

However, login.sql will run if it is defined in the SQL_PATH (or possibly SQLPATH) environment variable, which is set up using the same syntax at the normal PATH option, viz. directory names separated by colons. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th

Re: Customize my SQLPlus login

It's possible that you have a line in the file (perhaps the last line) that consists of a string of blanks; or the last command line of the file does not have a carriage return. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk

OT: Funniest line in the manual.

propose this one for urban legend status for 2004 ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i

Re: Dynamic SQL

, and execute the array. (I think there's a sample of this on my web site). Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

<    1   2   3   4   5   6   >