e opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
>-Original Message-
>From: Tim Gorman [mailto:[EMAIL PROTECTED]
>Sent: Saturday, October 11, 2003 11:14 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re:
Here is the short answer:
=
* Set OPTIMIZER_INDEX_CACHING to 90
* Make sure that DB_FILE_MULTIBLOCK_READ_COUNT is not overly high
* Also, consider gathering column-level statistics on some of the
indexed columns involved, especially if the query in question
Hi List,
DB version - 8174. (Oracle Apps 11.5.4).
One of the customized report started running very slowly. One query was taking more
than 3 GB of TEMP tablespace for 'HASH' type segment and erroring out after 2 hours
for a lack of space in TEMP.
Tkprof showed that it is doing Cartesian Sort