>
>
> hi ari ,
> i am a recent graduate into DBa we run oracle 7.3 on windows nt4.0
> platform i am enclosing my pfile with this mail please help me in
> changing it or to correct it as i have problems in shutting down the
> database. i can shut down in immediate and abort options but if i do
> shut down in normal its taking lot of time i.e hours so i had to do a
> immediate shut down.so please help me and an advance thanks
>
The reason that your SHUTDOWN in normal mode is taking so long does not have
to do with your pfile. The reason is that when you do a SHUTDOWN normal,
the database waits until ALL users logout of the database. If even one user
remains on, the database will not shut down. I always use SHUTDOWN IMMEDIATE.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 100+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
> pfile
>
> db_name = oracle
> db_files = 20
> control_files = (H:\ORANT\DATABASE\ctl1orcl.ora,
> H:\ORANT\DATABASE\ctl2orcl.ora)
>
> compatible = 7.3.0.0.0
>
> #db_file_multiblock_read_count =
> # db_file_multiblock_read_count = 8
> # SMALL
> db_file_multiblock_read_count = 16
> # MEDIUM
> # db_file_multiblock_read_count = 32
> # LARGE
>
> #db_block_buffers = # INITIAL
> # db_block_buffers = 200
> # SMALL
> db_block_buffers = 550
> # MEDIUM
> # db_block_buffers = 3200
> # LARGE
>
> #shared_pool_size = # INITIAL
> # shared_pool_size = 3500000
> # SMALL
> shared_pool_size = 6000000
> # MEDIUM
> # shared_pool_size =10500000
> # LARGE
>
> log_checkpoint_interval = 10000
>
> #processes = # INITIAL
> processes = 50
> # SMALL
> # processes = 100
> # MEDIUM
> # processes = 200
> # LARGE
>
> #dml_locks = # INITIAL
> # dml_locks = 100
> # SMALL
> dml_locks = 200
> # MEDIUM
> # dml_locks = 500
> # LARGE
>
> transactions = 40
>
> global_names = true
>
> open_links = 4
>
> job_queue_processes = 2
>
> job_queue_interval = 10
>
> job_queue_keep_connections = false
>
> #log_buffer = # INITIAL
> # log_buffer = 8192
> # SMALL
> log_buffer = 32768
> # MEDIUM
> # log_buffer = 163840
> # LARGE
>
> #sequence_cache_entries = # INITIAL
> # sequence_cache_entries = 10
> # SMALL
> sequence_cache_entries = 30
> # MEDIUM
> # sequence_cache_entries = 100
> # LARGE
>
> #sequence_cache_hash_buckets = # INITIAL
> # sequence_cache_hash_buckets = 10
> # SMALL
> sequence_cache_hash_buckets = 23
> # MEDIUM
> # sequence_cache_hash_buckets = 89
> # LARGE
>
> audit_trail = true # if you want auditing
> timed_statistics = true # if you want timed statistics
> max_dump_file_size = 10240 # limit trace file size to 5 Meg each
>
> log_archive_start = true # if you want automatic archiving
> log_archive_dest = h:\orant\test #log archive destination
> log_archive_format = 't%ts%s.arc'
>
> # define directories to store trace and alert files
> background_dump_dest=H:\RDBMS73\trace
> user_dump_dest=H:\RDBMS73\trace
>
> db_block_size = 2048
>
> snapshot_refresh_processes = 2
>
> snapshot_refresh_interval = 60
>
> snapshot_refresh_keep_connections = false
>
> remote_login_passwordfile = shared
>
> text_enable = true
>
> bye
> ===
> Nagesh Pillarisetti
Back to Ari Kaplan's Home Page