如何看spfilesid.ora檔案裡面內容

我們知道spfile是二進位制檔案，用ue開啟時看到的都是二進位制內容

有時候要用到pfile檔案,而要用到pfile檔案,就可以透過以下這種方式複製出來了

那透過什麼方法可以正確顯示spfile檔案裡面內容呢

在linux下可以用 string spfilesid.ora 這個命令

[oracle@test-oracle-01 dbs]$ strings spfileora9i.ora
*._log_io_size=3072000
*.background_dump_dest='/orasys/oracle/admin/ora9i/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/orasys/oracle/oradata/ora9i/control01.ctl','/oraexp/ora9i/cont                                             rol02.ctl'
*.core_dump_dest='/orasys/oracle/admin/ora9i/cdump'
*.db_16k_cache_size=50000000
*.db_block_size=8192
*.db_cache_size=512000000
*.db_domain=''
*.db_file_multiblock_read_count=64
*.db_name='ora9i'
*.dbwr_io_slaves=4
*.fast_start_mttr_target=300
*.hash_area_size=10240000
*.hash_join_enabled=TRUE
*.instance_name='ora9i'
*.java_pool_size=0
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_buffer=10240000
*.open_cursors=300
*.optimizer_index_caching=90
*.optimizer_index_cost_adj=50
*.pga_aggregate_target=1024000000
*.processes=300
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.sga_max_size=819200000
*.shared_pool_size=102400000
*.sort_area_retained_size=2046000
*.sort_area_size=4048000
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/orasys/oracle/admin/ora9i/udump'