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语句在运行时动态修改。