-
编辑 删除
有人用OIM吗？
如题，一直在用希望有学习的人一起讨论。或ｍａｉｌ联系ｍａｉｌ：ｋｒｉｓ３１０６＠ｇｍａｉｌ．ｃｏｍ
-
编辑 删除
B-tree and Bitmap Index
Oracle has 2 kinds of Index: B-tree index and Bitmap Index. B-tree index is commonly used index, which is created using CREATE INDEX command. B-tree index structure:Root: Pointer to branch node...
-
编辑 删除
V$BH
V$BHV$BH displays the status and number of pings for every buffer in the SGA. This is a Real Application Clusters view.ColumnDatatypeDescriptionFILE#NUMBERDatafile identifier number (to f...
-
编辑 删除
CONTROLFILE
V$CONTROLFILEThis view lists the names of the control files.ColumnDatatypeDescriptionSTATUSVARCHAR2(7)INVALID if the name cannot be determined, which should not occur. Null if the name ...
-
编辑 删除
Oracle 9i Data Dictionary
摘自：http://sqlbible.tar.hu/sqlbible0099.htmlOracle 9i Data DictionaryOracle uses the term "Data Dictionary" for its system catalogs. Each Oracle database has its own set of system tables and views...
-
编辑 删除
DB_UNIQUE_NAME and DB_NAME
DB_UNIQUE_NAMEPropertyDescriptionParameter typeStringSyntaxDB_UNIQUE_NAME = database_unique_nameDefault valueDatabase instances: the value of DB_NAME Automatic Storage Management inst...
-
编辑 删除
SWITCH LOGFILE and CHECKPOINT
# 这下该清楚了吧`~~ALTER SYSTEM SWITCH LOGFILE ;SWITCH LOGFILE ClauseThe SWITCH LOGFILE clause lets you explicitly force Oracle to begin writing to a new redo log file group, regardless of whethe...
-
编辑 删除
dddddd
alter system switch logfile 和 alter system archive log current 的区别2008-04-18 12:51要区别： ALTER SYSTEM SWITCH LOGFILE 对单实例数据库或RAC中的当前实例执行日志切换。(也可以是非归档情况下日志...
-
编辑 删除
DBID DB_UNIQUE_NAME
DBID是DataBase IDentifier的缩写，意思就是数据库的唯一标识符。DBID在数据文件头和控制文件中都是存在的，可以用于标示数据文件的归属。对于不同数据库来说，DBID应当不同，而db_name则可能是相同的。...
