Oracle spfile支持的參數包括但不限于:
- log_archive_dest
- db_name
- control_files
- db_block_size
- memory_target
- audit_file_dest
- db_create_file_dest
- compatible
- pga_aggregate_target
- sga_target
- undo_tablespace
- optimizer_features_enable
- job_queue_processes
- remote_login_passwordfile
- dispatcher
- shared_pool_size
這些參數可以通過ALTER SYSTEM語句在運行時動態修改。