Цитата: kadr а как насчёт конфигурации Oracle? интересно было бы посмотреть, как используется железо
в планах изменения кол-ва фрилистов, секционирование может и outline
еще в стадии отладки:
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\oradata\OSCOLCO\bdump'
*.buffer_pool_keep='15350'
*.compatible='9.2.0.7.0'
*.control_files='D:\oracle\oradata\OSCOLCO\control01.ctl','H:\oracle\oradata\OSCOLCO\control02.ctl','I:\oracle\oradata\OSCOLCO\control03.ctl'
*.core_dump_dest='D:\oracle\oradata\OSCOLCO\cdump'
*.cpu_count=4
*.db_block_buffers=376831
*.db_block_size=16384
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='OSCOLCO'
*.db_writer_processes=4
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='OSCOLCO'
*.java_pool_size=0
*.job_queue_processes=2
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='1024'
*.O7_DICTIONARY_ACCESSIBILITY=TRUE
*.open_cursors=300
*.optimizer_features_enable='9.2.0'
*.optimizer_index_caching=60
*.optimizer_index_cost_adj=30
*.parallel_automatic_tuning=TRUE
*.pga_aggregate_target=187695104
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan='INTERNAL_PLAN'
*.service_names='OSCOLCO'
*.session_cached_cursors=20
*.shared_pool_size=150994944
*.star_transformation_enabled='TRUE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS'
*.use_indirect_data_buffers=TRUE
*.user_dump_dest='D:\oracle\oradata\OSCOLCO\udump'
*.workarea_size_policy='AUTO'