ORACLE数据库服务热线：13764045638 诗檀软件

摘要： Reports index fragmentation statistics:==========Script #1:==========SET ECHO offREM NAME: TFSIFRAG.SQLREM USAGE:"@path/tfsifrag schema_name index_name"REM ------------------------------------------... 阅读全文

摘要： We can examine X$BH table to obtain buffer header information,The BH stands for buffer header.Structures that maintain a list of data buffer headers are called:Hash buckets.Hash buckets are grouped by... 阅读全文

摘要： Text: Stop SMON from cleaning up obj$-------------------------------------------------------------------------------NOTE:Events should NEVER be set by customers unless advised to do so byOracle Supp... 阅读全文

摘要： Event:10235 ~~~~~~~~~~~ Version/Use: 7.0 - 10.1.X Check memory manager internal structures. 7.0 - 10.1.X "Check memory manager internal structures" ~~~~~~~~~~~~~~~~~~~~~~~~~~... 阅读全文

摘要： Error: ORA 10051Text: trace OPI calls-------------------------------------------------------------------------------Explanation:This is NOT an error but is a special EVENT code.It should *NOT* be u... 阅读全文

摘要： View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ... 阅读全文

摘要： From Vinod Haval's These Views helps in understanding the following metrics Physical Mapping Provides Undocumented Information 18 X$ Tables (May be more) TABLE NAMEDESCRIPTIONX$KFALSThis table gi... 阅读全文

摘要： What is skip scanning? In prior releases, a composite index would be used to retrieve the records, if the index prefix (leading) column was included in the predicate of the statement. With Oracle9i, t... 阅读全文

摘要： create table SPACE_TEMP ( TABLESPACE_NAME CHAR(30), CONTIGUOUS_BYTES NUMBER)/declare cursor query is select * from dba_free_space order by tablespace_name, bloc... 阅读全文

摘要： Solaris平台上的Oracle数据库，Alert日志偶尔会出现"Network Interface No Longer Operational"的相关记录：ospid 11223: network interface with IP address 192.4.1.22 no longer operationalrequested interface 192.4.1.22 ioctl get ... 阅读全文