Discover parameter file in informatica, include the articles, news, trends, analysis and practical advice about parameter file in informatica on alibabacloud.com
After the Oracle database is started, you can use the select * fromv $ parameter statement to view all the parameters used by the Oracle database. For Oracle parameter files
After the Oracle database is started, you can use the select * from v $ parameter statement to view all the parameters used by the Oracle database. For Oracle
First, the control documentRole:
binary files
The structure and behavior of the current instance of the database, the information of the data file log file, and the maintenance of database consistency are recorded.
The location and size of the control file are defined in the parameter
Basic rules
A. In the SPFile file, all parameters are optional, that is, you only need to list those parameters that need to be modified in the initialization parameter file, others to keep the default values.
The B.spfile file can contain only parameter assignment stateme
ObjectiveThe main points of this article are as follows:
Parameter binding
Data echo
File Upload
Parameter bindingWe use the method parameter in the controller to receive the value, that is, the Web side of the value to receive the controller processing, this process is called
Oracle Parameters
I. Differences between Oracle pfile and spfilePfileThe default name is "init + routine name. ora "file path: e: \ oracle \ product \ 10.2.0 \ db_1 \ DBs. This is a text file and can be opened using any text editing tool.SpfileThe default name is "spfile + routine name. ora "file path: e: \ oracle \ product \ 10.2.0 \ db_1 \ DBS exists in the for
;? ? ? ? When this parameter is set to receive, the receiving Remote archive log is activated;? ? ? ? When this parameter is set to Noreceive, it is forbidden to receive remote archive logs;? ? ? ? When you set this parameter to Dg_config, you can specify a maximum of 9 unique database names;? ? ? ? When the parameter
Oracle parameter file Introduction
After the Oracle database is started, you can use the select * from v $ parameter statement to view all the parameters used by the Oracle database.
Oracle parameter files are divided into spfile binary files and pfile text files. Currently, the database generally uses the spfile binar
Pfile
The pfile (ParameterFile) file is a text-based parameter file that contains database configuration parameters. Oracle 9i creates a pfile for each database during installation. The default name is "init + routine name. ora", which is a text file and can be opened using any text editing tool.Spfile
Spfile (Server
Modify the parameter file spfile and disable the database startup.
Since the parameter file spfile is a binary file, you cannot directly use a text editor to modify it. We can start the database and then use the SQL command to modify it: alter system
commandsSql> Show parameter processes; --Maximum number of connections allowed for the databaseNAME TYPE VALUE------------------------------------ ----------- ------------------------------Processes integer 150Sql> alter system set PROCESSES=250 Scope=spfile; --Modify the maximum number of connections allowed for the databaseSystem altered.Scope Explanation:SPFile: Writes the value of this parameter to the
A static parameter file is a text file. The Oralce instance reads the content of this file at startup, So if you modify the content of this file, you must restart the Oracle instance to generate
A static parameter
Oracle has many parameter files, but the most important one is database parameter files. Database parameter files include pfile and spfile. Pfile must be manually modified. It is a text file, and spfile is a binary file, which can be changed dynamically.
Spfile is available
specific ORDER (for example, query using the order by clause) (the default value is 256 K ).Sore_buffer = n indicates the length of the cache area allocated for sorting operations (2 MB by default). If the cache area is too small, a temporary file must be created for sorting.Table_cache = n the number of data tables opened at the same time (the default value is 64 ).Tmp_table_size = n Maximum length of the temporary HEAP data table (32 MB by default)
MySQL parameter optimization for beginners, is more difficult to understand things, in fact, this parameter optimization, is a very complex thing, for different sites, and its online volume, access, number of posts, network conditions, as well as the machine hardware configuration are related, optimization can not be completed one-time, the need for continuous observation and debugging, is likely to get the
The Export Configuration File stores all the Configuration parameters of the chinamoocs router. This function backs up the configuration parameters of the chinamoocs router to a computer. Generally, after you upgrade the vro version or complete all configurations, make sure that the current vro setting parameters are stored in the computer! In the system configuration parameter
In the RAC environment, the initialization parameter file has some similarities and differences with the parameter files under the instance, mainly because the initialization parameter can be shared for multiple instances, or you can set the initial
In the RAC environment, the initialization
)Upload_err_okValue: 0; No error occurred and the file upload was successful.Upload_err_ini_sizeValue: 1; The uploaded file exceeds the value of the Upload_max_filesize option limit in php.ini.Upload_err_form_sizeValue: 2; The size of the uploaded file exceeds the value specified by the Max_file_size option in the HTML form.Upload_err_partialValue: 3; Only part o
How to modify the PAE | awe | 3 GB parameter of the bootini file: we all know the boot. you can add parameters after INI, such as: PAE: enable the system to access more than 4 GB of physical memory 3 GB: Enable the application to use more than 2 GB of memory, up to 3 GB awe: enable the application to use more than 3 GB memoryI do not know whether the above is true or not. My problem is:1. What are the speci
Since the parameter file spfile is a binary file, you cannot directly use the text editor to modify it. You can start the database and then use the SQL command to modify the parameter value of altersystem, scopeboth | spfile | memorysorcl. For details about the authoritative parameters, refer to official document 1. Mo
Parameter extension variable (% 0 to % 9) for parameters in the next Windows batch processing file (BAT ). When the batch parameters are used in the batch file, % 0 will be replaced by the batch file name, while % 1 to % 9 will be replaced by the corresponding parameters typed in the command line. You can use the modif
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.