Home > Workload Solutions > Oracle > Guides > Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex > Initialization parameter settings for the Oracle database
Use these settings in the database init.ora file or spfile.
bds.__data_transfer_cache_size=0
bds.__db_cache_size=23085449216
bds.__inmemory_ext_roarea=0
bds.__inmemory_ext_rwarea=0
bds.__java_pool_size=134217728
bds.__large_pool_size=134217728
bds.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
bds.__pga_aggregate_target=6777995264
bds.__sga_target=26508001280
bds.__shared_io_pool_size=134217728
bds.__shared_pool_size=2952790016
bds.__streams_pool_size=0
bds.__unified_pga_pool_size=0
*._bigdata_external_table=TRUE
*._bigdata_offload_flag=TRUE
*.audit_file_dest='/u01/app/oracle/admin/bds/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='+DATA/BDS/control01.ctl','+DATA/BDS/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_name='bds'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bdsXDB)'
*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.230.87.183)(PORT=1521))'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=6415m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=25245m
*.star_transformation_enabled='TRUE'
*.undo_tablespace='UNDOTBS1'