GENERATING THE CURRENT INITIALIZATION PARAMETER FILE
Spfile
0
REQUEST
To generate an initialization parameter file by querying a database.
RELATED
DETAILS
V$PARAMETER displays information about the initialization parameters that are currently in effect for the session.
V$SPPARAMETER displays information about the contents of the server parameter file.
V$SYSTEM_PARAMETER displays information about the initialization parameters that are currently in effect for the instance.
V$SPPARAMETER displays information about the contents of the server parameter file.
V$SYSTEM_PARAMETER displays information about the initialization parameters that are currently in effect for the instance.
SOLUTION
SET LINES 300
SET PAGES 999
COL "INITIALIZTION PARAMETERS" FOR A100
SELECT '*.' || NAME || '=' || DISPLAY_VALUE "INITIALIZTION PARAMETERS" FROM V$SYSTEM_PARAMETER WHERE ISDEFAULT='FALSE' ORDER BY 1;
INITIALIZTION PARAMETERS
----------------------------------------------------------------------------------------------------
*.audit_file_dest=/oracle/admin/DBPILOT/adump
*.audit_trail=DB
*.compatible=12.2.0
*.control_files=/oracle/oradata/DBPILOT/control01.ctl, /oracle/oradata/DBPILOT/control02.ctl
*.db_block_size=8192
*.db_name=DBPILOT
*.diagnostic_dest=/oracle
*.dispatchers=(PROTOCOL=TCP) (SERVICE=DBPILOTXDB)
*.local_listener=LISTENER_DBPILOT
*.nls_language=AMERICAN
*.nls_territory=AMERICA
*.open_cursors=300
*.pga_aggregate_target=9664M
*.processes=640
*.remote_login_passwordfile=EXCLUSIVE
*.sga_target=28992M
*.undo_tablespace=UNDOTBS1
The initialization file contains the same values
oracle@dbpilot.net: cat $ORACLE_HOME/dbs/initDBPILOT.ora
DBPILOT.__data_transfer_cache_size=0
DBPILOT.__db_cache_size=26172456960
DBPILOT.__inmemory_ext_roarea=0
DBPILOT.__inmemory_ext_rwarea=0
DBPILOT.__java_pool_size=134217728
DBPILOT.__large_pool_size=201326592
DBPILOT.__oracle_base='/oracle'#ORACLE_BASE set from environment
DBPILOT.__pga_aggregate_target=10133438464
DBPILOT.__sga_target=30400315392
DBPILOT.__shared_io_pool_size=536870912
DBPILOT.__shared_pool_size=3288334336
DBPILOT.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/DBPILOT/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='/oracle/oradata/DBPILOT/control01.ctl','/oracle/oradata/DBPILOT/control02.ctl'
*.db_block_size=8192
*.db_name='DBPILOT'
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBPILOTXDB)'
*.local_listener='LISTENER_DBPILOT'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=9664m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=28992m
*.undo_tablespace='UNDOTBS1'
Version : 11:27 19.01.2018
Database : Standalone Oracle database 10g – 12cR2
Database : Standalone Oracle database 10g – 12cR2
Tags In
Related Posts
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (63)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (3)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Temporary Tablespace (2)
Tags
/etc/sudoers
Account
Agent
Agent 12c Deinstall
Agent 13c Deployment
Automated Maintenance Tasks
AWR
BLOCKING SESSION
Database Auditing
Database Directory
Database Performance
Datapump
DBMS_SYSTEM
Enterprise Manager
Enterprise Manager Metrics
Failed Logins (Historical) Metric
Failed Logins Metric
Gather Statistics Job
GET_ENV
High IO Load
Idle Sessions
Initialization Parameters
LOCKED(TIMED)
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
Processes
Repository
Retrieve Object DDL
ROW LOCK
Scheduler
Schema Statistics
Scripts
Sessions
spfile
SQL_ID
Standard Query
TRANSACTION
User Grants
UTL_FILE
WAITING SESSION
Window Group
Window Name
Yum