Re: Does Optimizer use P.A.T to calculate cost..?

From: <mccmx_at_hotmail.com>
Date: 30 Oct 2006 01:17:52 -0800
Message-ID: <1162199872.480186.233910@b28g2000cwb.googlegroups.com>

> What is your
> total physical memory

2Gb

> memory allocated to SGA

SGA_TARGET = 400Mb

> number of expected sessions

Maximum 15 session (exclusing background processes)
> setting for db_file_multiblock_read_count

DB_F_M_B_R_C = 16

> Do you have any hidden parameters set,

_push_join_union_view=false (advised by Oracle Support)

> and what values do you have for any
> optimizer-related parameters that are not
> at their default ?

select name, value from v$parameter where isdefault='FALSE';

processes                           150
nls_language                        ENGLISH
nls_territory                       UNITED KINGDOM
sga_target                          419430400

control_files
D:\ORACLE\ORADATA\PEFFPROD\CONTROL01.CTL, D:\....

db_block_size                       8192
db_keep_cache_size                  0
compatible                          10.2.0.2.0

log_archive_dest_1
location=d:\oracle\oradata\peffprod\archive MANDATORY

db_file_multiblock_read_count       16
db_recovery_file_dest               D:\oracle\flash_recovery_area
db_recovery_file_dest_size          53687091200
undo_management                     AUTO
undo_tablespace                     UNDOTBS1
remote_login_passwordfile           EXCLUSIVE
db_domain
job_queue_processes                 10
audit_file_dest                     D:\ORACLE\ADMIN\PEFFPROD\ADUMP
background_dump_dest                D:\ORACLE\ADMIN\PEFFPROD\BDUMP
user_dump_dest                      D:\ORACLE\ADMIN\PEFFPROD\UDUMP
core_dump_dest                      D:\ORACLE\ADMIN\PEFFPROD\CDUMP
db_name                             peffprod
open_cursors                        300
_push_join_union_view               FALSE
pga_aggregate_target                96468992

Received on Mon Oct 30 2006 - 03:17:52 CST