Recent content by saintSlen

What differences can you ascertain from your stats pack reports when performance was good compared to now?

set pagesize 0 set heading off set feedback off spool Script.sql select 'Myname 00001111 Notinwork' from dual; spool off set heading on set feedback on @Script

Can you create a large rollback, alter sessions set transaction or use the create temp table table technique and just query a sub-set of the data; then insert /*+ append */ the rest. rules for insert append and redo: Table Mode Insert Mode ArchiveLog mode result -----------...

I think support note <Note:40689.1> covers this topic very well: ORA-01555 &quot;Snapshot too old&quot; - Detailed Explanation =================================================== Overview ~~~~~~~~ This article will discuss the circumstances under which a query can return the Oracle error...

Not quite enough info to definitively determine which is &quot;more efficient&quot;; it really depends on exactly what you are doing and wish to capture. Do you want to include network times from an app server to the db server or are you really looking for pure db transaction times? That said...

Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value. Action: Increase the value of NEXT for the user's temp tablespace. ~L