Alter system set spfile location
- show parameter spfile
- show parameter spfile is empty
- show parameter spfile no value
- show parameter spfile value is null
How to check spfile location in oracle
Initialization parameter file in oracle.
PFILE and SPFILE in Oracle Database and How can you create PFILE and SPFILE?
This article describes PFILE and SPFILE in Oracle Database in details from where you will know
- What is PFILE and SPFILE?
- File Location
- What is difference between PFILE and SPFILE?
- Advantages of SPFILEs
- How to create PFILE and SPFILE?
- How can we modify PFILE and SPFILE?
- How to SHOW Parameter in SPFILE?
What is PFILE and What is SPFILE?
Simply, PFILE and SPFILE are the initialization parameter file which contains some parameters like data_transfer_cache_size, Java_pool_size, sga_target, large_pool_size etc.
When we start the machine, the initialization parameter file is read and the characteristics of the Instance are established by parameters specified within the initialization parameter file.
There are two types of initialization parameters files:
- Server Parameter File (SPFILE)
- Text Initialization Parameter File(PFILE)
SPFILEs are available in Oracle 9i and above.
All prior releases of Oracle are using PFILEs. By default, Oracle database initializes
- oracle check parameter value in spfile
- show parameters