Privet!
I'll send my remarks in mail afternoon.
Regards!

Solutions::

A. Ora.ini
In additions, change PGA_AGGREGATE_TARGET to 600 MByte.
CURSOR_SPACE_FOR_TIME = TRUE ( after cleaning a "buffer busy
waits" situation.
session_cached_cursors= 15 ( latch free waits! )
comment on [sga_max_size=943718400 ]
CURSOR_SHARING = SIMILAR
B. Application side:

I. Find statements with very high logical I/O or physical I/O, using unselective
indexes.
II. After I, find inefficient SQL that accesses incorrect indexes iteratively
(large index range scans) or many full table scans ( or HASH FULL SCAN )
III. Detected High RELOADS / INVALIDATIONS -> Hot blocks (!!)

C.Queries for checking::
SELECT operation, options, object_name name,
trunc(bytes/1024/1024) "input(MB)",
trunc(last_memory_used/1024) last_mem,
trunc(estimated_optimal_size/1024) optimal_mem,
trunc(estimated_onepass_size/1024) onepass_mem,
decode(optimal_executions, null, null,
optimal_executions||'/'||onepass_executions||'/'||
multipasses_executions) "O/1/M"
FROM V$SQL_PLAN p, V$SQL_WORKAREA w
WHERE p.address=w.address(+)
AND p.hash_value=w.hash_value(+)
AND p.id=w.operation_id(+)

SELECT parameter
, sum(gets)
, sum(getmisses)
, 100*sum(gets - getmisses) / sum(gets) pct_succ_gets
, sum(modifications) updates
FROM V$ROWCACHE
WHERE gets > 0
GROUP BY parameter

SELECT NAME,SUM(VALUE) || ' BYTES' "TOTAL MEMORY FOR ALL SESSIONS"
FROM V$SESSTAT, V$STATNAME
WHERE
V$SESSTAT.STATISTIC# = V$STATNAME.STATISTIC#
group by NAME

Hey, man!
How are You?
What's Your instance?

Hi!
Full ini received. Check Your mail tomorrow.