2020. 10. 28. 00:19 오라클
19c default spfile 내용
[TEST]oracle@ora19c:/oracle/app/oracle/product/19.3.0/dbs# strings spfileTEST.ora
TEST.__data_transfer_cache_size=0
TEST.__db_cache_size=1124073472
TEST.__inmemory_ext_roarea=0
TEST.__inmemory_ext_rwarea=0
TEST.__java_pool_size=0
TEST.__large_pool_size=16777216
TEST.__oracle_base='/oracle/app'#ORACLE_BASE set from environment
TEST.__pga_aggregate_target=536870912
TEST.__sga_target=1610612736
TEST.__shared_io_pool_size=83886080
TEST.__shared_pool_size=369098752
TEST.__streams_pool_size=0
TEST.__unified_pga_pool_size=0
*.audit_file_dest='/oracle/app/admin/TEST/adump
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/oracle/oradata/TEST/control01.ctl','/oracle/oradata/TEST/control02.ctl'
*.db_block_size=8192
*.db_name='TEST'
*.diagnostic_dest='/oracle/app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=512m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1536m
*.undo_tablespace='UNDOTBS1'
