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: 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: negative value for buffer cache hit ratio

It is possible that after 4 months your stats have wrapped around the ( ? 64 bit ?) limit value for your platform. Check the actual values from v$sysstat to see if some of them have gone negative or appear to be 'counting backwards'. Jonathan Lewis Seminars on getting the best out of Oracle

Re: PARTITION attache to SYNONYM

strange has happened. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 August 2001 19:57 |Hi All

Re: free up datafile space problem ???

alter index rebuild and then resizing data files downwards. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL

Re: How to locate who dropped a view using log miner?

at the OBJ$ code, and set up the column search section of log miner to search for the TYPE# column, specifying the value as per the list in $ORACLE_HOME/rdbms/admin/sql.bsq Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http

Re: Private vs. Public Rollback Segments

. (But that consideration seems to have disappeared with 9i and SMUT). Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date

Re: How to locate who dropped a view using log miner?

sets of PH columns in log_miner , so you can specify, for example that the PH1 set should map to the sys.obj$.type# column, then query v$logmnr_contents for: seg_name = 'OBJ$' andph1_name = 'TYPE#' andph1_redo = 4 Jonathan Lewis Seminars on getting the best out of Oracle

Re: Timed statistics and SQL_TRACE for already running session

Which version of Oracle. From 8.1.6 onwards, dbms_system contains a call similar to set_sql_trace_in_session which is name something like: set_boll_param_in_session. Describe dbms_system to check the proper nmame and parms. Jonathan Lewis Seminars on getting the best out of Oracle Last few

Re: PARTITION attache to SYNONYM

#' and block#. Clip out this bit of the sql, and select out the file# and block# for the funny partition. Then use those values to query the file and block against dba_segments to find out what data segment is actually being referenced. Jonathan Lewis Seminars on getting the best out of Oracle Last

Re: PARTITION attache to SYNONYM

partiitoned table, or a partitioned IOT ? If standard, there MUST be a segment, because dba_tab_partitions CANNOT report a partition without joining to the matching seg$ row. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http

Re: Timed statistics and SQL_TRACE for already running session

It's pure 8.1.6+ something like: dbms_system.set_bool_param(sid, serial,'parameter',true/false); I don't think there is ANYTHING sneaky you can do prior to 8.1.6; alter system is the only option for avoiding the bounce. Jonathan Lewis Seminars on getting the best out of Oracle Last few

Re: How to locate who dropped a view using log miner?

Apparently intentional - the file was newly generated, and when I called it in to Oracle they told me it was deliberate. Off-hand I think it was tab$, col$, ind$, icol$ that were excluded from the normal display. Jonathan Lewis Seminars on getting the best out of Oracle Last few places

Re: RAID or NOT to RAID? What's the diff???

And if it does confuse you, my book has a couple of pretty pictures in it that might help. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple

Re: Indexes Used per Query

for it to be used unhinted. The INDEX_JOIN path has just been introduced (disabled, though) to allow a hash-join between indexes that bypasses the table completely. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk

Re: external proc listener

= Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 14 August 2001 18:49 Ok i know i'm doing something

Re: Performance analysis (enqueue and buffer busy waits)

Enqueue waits cannot cause buffer busy waits, but the absence of indexes (and you point out missing FK indexes) can result in excessive tablescanning, and tablescanning can result in buffer busy waits. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept

Re: Performance analysis (enqueue and buffer busy waits)

I/O, I/O slaves, or multiple db_writers works best for you. You may also want to review the size of your log files (upwards), and your rollback segments (downwards). Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http

Re: Locally Managed Tablespaces and autoextend

at the end; for a very small file with its special one-block bitmap, you could still at about 63,500 extents without a new chunk of bitmap appearing. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk

Re: Performance analysis (enqueue and buffer busy waits)

sync' as a problem without getting (in your case) 'log buffer space' and 'log file ... write'. What is your average log file write size ? (redo blocks written / redo writes). and what do you other 'redo%' stats look like over the period ? How many CPUs ? Jonathan Lewis Seminars on getting

Re: An SQL question , not easy ;-)

ts.timestamp between pc.start_date and pc.end_date and pc.start_date between to_date('1-jan-2001','dd-mon-') and to_date('2-jan-2001','dd-mon-') group by ts.timestamp ; Adjust constants to suit precision and resources. Jonathan Lewis Seminars on getting the best

Re: Speed up Truncate tables

(a little). The only other case I can think of is that truncating a table which is actually stored in a cluster does NOT do a truncate, it does a delete. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html

Re: Performance analysis (enqueue and buffer busy waits)

- on the other hand it might just make all the log file syncs last longer. Do you have figures for total elapsed run time total wait time on log file sync total wait time on tx enqueues total CPU used for the duration of the run ? Jonathan Lewis Seminars on getting the best out

Re: Speed up Truncate tables

And you can also shrink the initial extent with 'deallocate unused' if the HWM if inside the first extent. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message

Re: Performance analysis (enqueue and buffer busy waits)

table set all rows to an unchanged value') lock the child table in mode 4 (or possibly 5 if the session has already done some DML on the child), then do a tablescan to make sure that no child rows for that parent exist. Deletes do the same. Yes, it can take some time. Jonathan Lewis Seminars

Re: Can a SYSTEM tablespace be locally managed.

something like: A future release will allow SYSTEM to be locally managed ... At present I wouldn't do it, even if it were supposed to be possible. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html

Re: Comment on 'Practical Oracle 8i'

, and I'd supervise the tests). Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 August 2001 06:04

Re: Re:RE: Index space not freed when rows deleted?

Comments in line Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 August 2001 18:38 |Jay

Re: Ways to improve speediness of truncate, drop, coalesce

extent to that unit size, and pctincrease = 0. This gets rid of future fragmentation issues. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple

Re: Delete followed by Select Count(1) - SLOW

See my website: Index of topics - Miscellaneous - Block Cleanout Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L

Re: table create vs alter

placed at the end of the row. However, if you added a column, it HAD to be added past the long column. So: create table t1(txt long); alter table t1 add id number; would actually be stored differently from create table t1 (id number, txt long); Jonathan Lewis Seminars on getting

Re: Delete followed by Select Count(1) - SLOW

and delayed_logging_block_cleanout, but reports were (like Mark Twain's death) exaggerated. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL

Re: Using triggers for data validation

; but there are inevitably cases where it doesn't really matter, and special cases where it is not true. Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk

Re: Performance analysis (enqueue and buffer busy waits)

Small rollback segments can be recycled without being written to disc. This can reduce the total write-load on the system and enhance your general use of the db_block_buffer. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author

Re: Performance analysis (enqueue and buffer busy waits)

Does that mean you think it is impossible to have rollback segments that are too big ? Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk

Re: Freelist Contention

header waits as the flushed and scanned blocks are rolled back by the PX slaves for read consistency. Excessive serial tablescans, on the other hand can easily cause significant buffer busy waits. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq

Re: Users Schema's

= XXX; which you can embed into a database logon trigger using 'execute immediate' Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk/book_rev.html

Re: OT - File System to Disk Mapping

3535 --- Logical extents --- LEPV1PE1 Status 1 0 /dev/dsk/c0t5d000277 current 1 /dev/dsk/c0t5d000278 current 2 /dev/dsk/c0t5d000279 current Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http

Re: Nested loop very slow

couldn't get your result in just a few seconds. Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public appearances

Re: Freelist Contention

above the HWM of an existing data segment; so I don't think PX slaves would have that issue. (which can, of course, be an issue with 'ordinary' highly concurrent processes). Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author

Re: Would you use 9i?

I'd go for it. Give yourself a head start by making sure you learn about what 9i can do. Don't just wade in to using 8i to build a 7.3-style application with a few bolt-ons. Make the newness work for you. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk

Re: OT - Best book to learn 8i

Thomas Kyte Expert one on one: Oracle. Wrox Press. Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public

Re: hash join order

blocks being scanned at the same time (assuming you haven't managed to get the whole lot buffered). It gets interesting when the data set from the first table (the b_tab in your case as Barbara pointed out) is too large to fit into memory in a hash table. Jonathan Lewis Host to The Co-Operative

Re: A quick pl/sql datatypes question

: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

Re: PK/Fk question

on it - them make table1 and table2 reference it. Your question does, of course, suggest that there may be a flaw in your physical database structure. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building

Re: PK/Fk question

There is also the drawback that the trigger has to do a 'select for update', with all associated contention problems, otherwise the effect of read-consistency would allow a trigger to determine that a parent existed when in fact it had been deleted by an uncommitted transaction. Jonathan Lewis

Re:

below) to split the parallel query SQL from the rest of the plan as this tends to make things a little cleaner. Jonathan Lewis 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 See http

Re: Efficient way to monitor table growth...

growth on a frequent, but low-cost basis. (there are some samples on my website). Jonathan Lewis 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 See http://www.jlcomp.demon.co.uk/book_rev.html

Re: HP-UX

(the PHCO_17058.depot file in a local directory, then choose the install action). After the analyze stage you get messages about errors and warnings and files skipped - this may be more helpful (or perhaps comforting) than the summary message you are getting at the end. Jonathan Lewis http

Re: Export/Import question

using locally managed tablespaces of uniform extent sizes. 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 Screen saver or Life saver: http

Re: Column Name

In the short term: Rename XXX to YYY create view XXX as select {all the columns} from YYY; In the longer term - migrate to Oracle 9 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

Re: USE_HASH hint

to end up with my desired ordering, but rejected path. 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 Screen saver or Life saver: http

Re: query rewrite question

table of about 3,300 rows on my system, on a 4K block size for a total of about 30 blocks. Oracle 8.1.7.0 on NT 4.0 The sample queries all use the materialized view instead of the base table. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http

Re: reason behind Oracle and HP love affair

Latch, used to emulate this function in software on the HP port. 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 Screen saver or Life saver: http

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

Re: Dynamic SQL

problem, but only have 8.1.7.3. If the sql_str variable is declared large enough to hold the incoming string it works as expected, if the variable is larger than the declared length of the variable the error is the usual PL/SQL 6502 numeric or value error. Jonathan Lewis http

Re: 8.1.7 LMTs Autoallocate vs Uniform Extents

to be pretty arbitrary about how many of each of the 'legal' extent sizes it uses if (a) you specify a table with a large initial extent (notes about that on the same addendum page) and/or if there are available holes near the start of the tablespace which are waiting to be used up. Jonathan Lewis http

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

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

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

  1   2   3   4   5   6   >