Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the meaning of each parameter in the oracle 10g initialization parameter file pfile

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

Oracle 10g initialization parameters file pfile what the meaning of the parameters, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

Some of the initialization parameters of the database are stored in pfile. Here we summarize the meaning of each parameter according to the pfile I obtained (oracle10g Enterprise Edition under windows). It is important to note that the parameters of pfile are only part of them. To view other parameters, you can use the following command after the instance is started:

SQL > show parameter;-displays all parameters, or:

SQL > show parameter xxx;-- displays the specified parameters.

Brief notes on the parameters of pfile

Orcl.__db_cache_size=301989888

-- data cache size

Orcl.__java_pool_size=4194304

-- java pool siz

Orcl.__large_pool_size=4194304

-- large pool size

Orcl.__shared_pool_size=134217728

-- shared pool siz

Orcl.__streams_pool_size=0

-- flow pool size

* .audit_file_dest='H:\ oracle\ product\ 10.2.0\ admin\ orcl\ adump'

-- Audit log directory

* .background_dump_dest='H:\ oracle\ product\ 10.2.0\ admin\ orcl\ bdump'

The background process tracks the file directory, including warning files.

* .compatible='10.2.0.3.0'

-- version number

* .control_files='H:\ oracle\ product\ 10.2.0\ oradata\ orcl\ control01.ctl','H:\ oracle\ product\ 10.2.0\ oradata\ orcl\ control02.ctl','H:\ oracle\ product\ 10.2.0\ oradata\ orcl\ control03.ctl'

-- Control file

* .core_dump_dest='H:\ oracle\ product\ 10.2.0\ admin\ orcl\ cdump'

Invalid parameters on windows, which seem to be used to store information when the database server is running errors.

* .db_block_size=8192

-- Block size, minimum IO unit.

* .db_domain=''

-- Database domain name

* .db_file_multiblock_read_count=16

-- the maximum number of blocks read in one the maximum number of blocks read in one O operation during a sequential scan.

* .db_name='orcl'

-- Database name

* .db_recovery_file_dest='H:\ oracle\ product\ 10.2.0\ flash_recovery_area'

-- data recovery area

* .db_recovery_file_dest_size=2147483648

-- data recovery area size

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=orclXDB)'

Dispatcher in shared server mode

* .job_queue_processes=10

-the maximum number of waiting processes in the job queue

* .log_archive_format='ARC%S_%R.%T'

-- naming rules for archived files

* .nls_language='SIMPLIFIED CHINESE'

-- language

* .nls_territory='CHINA'

-- country

* .open_cursors=300

-- maximum number of open cursors

* .pga_aggregate_target=149946368

-- specifies the target aggregate PGA memory available to all server processes attached to the instance

* .processes=50

-- maximum value of connection process

* .remote_login_passwordfile='EXCLUSIVE'

-- whether Oracle checks for a password file.

EXCLUSIVE:The password file can be used by only one database.

* .sessions=60

-- maximum number of sessions

* .sga_target=449839104

-- used for automatic memory management and cannot be greater than sga_max_size.

* .undo_management='AUTO'

-- rollback management

* .undo_tablespace='UNDOTBS1'

-- roll back the tablespace

* .user_dump_dest='H:\ oracle\ product\ 10.2.0\ admin\ orcl\ udump'

-- user process tracking file storage directory

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report