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

<    1   2   3   4   5   6