In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.