Oracle 未寫入文檔的參數介紹
2024-08-29 13:37:55
供稿：網友
有許多的的未寫入文檔的參數其實在實際應用中也是委重要的，有時當你碰到一個corrupt,你去問Oracle,oracle也許會說這個無能為力了，其實他們是有辦法的，這其中就有這些內部參數的作用。
1、你用sys連入oracle,執行如下的sql語句，你可以看到有哪些未寫入文檔的參數
select
a.ksppinm "Parameter",
a.ksppdesc "Description",
b.ksppstvl "session Value",
c.ksppstvl "Instance Value"
from
x$ksppi a,
x$ksppcv b,
x$ksppsv c
where a.indx = b.indx
and a.indx = c.indx
and a.ksppinm like '/_%' escape '/'
order by 1
2、也并不是所有的都是有用的，有些還是有害的，下面介紹14個有用的。
3、美國聞名oracle專家Rich Niemiec有14個非凡喜歡的undocument parameter,我把原文引入如下：
a、_ALLOW_RESETLOGS_CORRUPTION -- May be only way to start a db backed up
open without setting backup on tablespaces, will result in unsupported system. See the
detailed section for how to use this in a recovery situation.
b、_CORRUPTED_ROLLBACK_SEGMENTS -- Only way to startup with corrupted public
rollback segments. Can be used without fear of desupport.
c、_ALLOW_READ_ONLY_CORRUPTION – Allows you to open a database even if it has
corruption. This should only be used to eXPort as mUCh data from a corrupted database
as is possible before recreating a database. You should not use a database for normal
use that has been opened in this manner as it will not be supported.
d、_SPIN_COUNT -- Sets the number of spins a PRocess will undergo before trying to get a
latch. If CPU is not fully loaded a high value may be best, for a fully loaded CPU a
smaller value may help. Usually defaults to 2000. Can be changed without fear of
desupport. This parameter flips from being undocumented to documented depending on
database version.
e、_LOG_ENTRY_PREBUILD_THRESHOLD – This parameter was documented at one
time, now it is undocumented. It is the minimum size of entry in blocks that will be prebuilt
for redo log entries, usually set to 30.
f、_LATCH_SPIN_COUNT -- Shows how often a latch request will be taken
g、_DB_BLOCK_WRITE_BATCH – This parameter was documented at one time, but is now
undocumented. It is the number of blocks that the db writers will write in each batch,
defaults to 512 or DB_FILES*DB_FILE_SIMULTANEOUS_WRITES/2 up to a limit of ¼
of the value of DB_BLOCK_BUFFERS.
h、_CPU_COUNT – This is another parameter that flips from undocumented to
documented. Should be set automatically but on some platforms it doesn't work, set to
the number of CPUs. This determines several other parameters.
i、_INIT_SQL_FILE -- This is the initialization SQL script run by Oracle when a db is
created. This should be sql.bsq, if you change it, you may not be supported.
j、_TRACE_FILES_PUBLIC -- Changes the privileges on trace files such that everyone can
read them. Should be OK to change at will.
k、_FAST_FULL_SCAN_ENABLED -- Enables fast full index scans (or disables them) if
only indexes are required to resolve the queries. Change this at will.
l、_CORRUPT_BLOCKS_ON_STUCK_RECOVERY -- Can sometimes get a corrupted db
up, you probably won't be supported if done without Oracle supports blessing, if you use
it, immediately export the tables you need and rebuild the db.
m、_ALWAYS_STAR_TRANSFORMATION -- Helps to tune data warehouse queries if you
have a properly designed data warehouse.
n、_SMALL_TABLE_THRESHOLD -- Sets the size of table considered a small table, a small
table is automatically pinned into the buffers when queried. Defaults to 2% in Oracle9i
