Oracle Parameters File

Environment:Oracle Standalone 11.2.0.4

Parameter file location: >show parameter SPFile

Edit parameter file: >create pfile= ' D:\init.ora ' from SPFile

*.optimizer_index_caching=            
#这个初始化参数代表一个百分比, the values range from 0 to 99. The default value is 0, which means that when the CBO accesses data using an index, the rate at which data is found in memory is 0%, meaning that accessing the data through the index will require a physical read, which is costly. If you use the default settings, when Oracle evaluates costs, many times it is wrong to select Full table scan *.optimizer_index_cost_adj=            #这个初始化参数代表一个百分比, Values range from 1 to 10000. This parameter represents the comparison of the index scan and the full table scan cost. The default value of 100 means that the index scan cost equals the full table scan *.remote_login_passwordfile='EXCLUSIVE'        # Specifies whether Oracle checks the password file, and how many databases can use a password file. The default value is that the exclusive password file can only be used by one database, and the password file may contain other names, Sys. Noneoracle ignores any password files. Therefore, privileged users must be certified by the operating system. Shared multiple databases can use a password file. However, the only user that the password file recognizes is sys. *. O7_dictionary_accessibility=True        #控制对数据字典的访问. Set to True if the user is granted any table permission such as select any table, Users can access the data dictionary even if they are not DBAs or SYSDBA users.

Oracle parameter file