-
编辑 删除
Oracle11g Patch level list
除了用opatch lsinventory 查看外， 还可以通过select * from sys.registry$history;来查看
-
编辑 删除
What cause the big diffrence on the same sql ?
1.DELETE FROM PUB_QUEUEWHERE ROWID = :B1call count cpu elapsed disk &n...
-
编辑 删除
dbua report datafile not exists
Because when DBA add datafiles, the datafile name with the end "space" For example: 'a ' !='a',the dbua check the datafiles trim the space, but when alter database datafile ' &...
-
编辑 删除
ORA-02019: connection description for remote database not found
昨日做数据库升级， 升级完毕后， 在alert log 里报如下错误：Node name: suzdrsas-updradeRelease: 5.10Version: ...
-
编辑 删除
ORA-00235: controlfile fixed table inconsistent due to concurrent update
偶遇00235 error , 找了半天，还是这个解释比较接近答案http://forums.oracle.com/forums/thread.jspa?messageID=2524868&tstart=0
-
编辑 删除
What database parameters are relevant to ORA-04031 problems?
CURSOR_SHARING Literal replacement is a feature where Oracle replaces literal values in SQL statements to reduce the application Shared Pool footprint and decrease "hard" parsing. ...
-
编辑 删除
What is an ORA-04031 Error?
The memory pool in the SGA are comprised of memory chunks in various sizes. When the database starts is started, you have a large chunk of memory allocated in the various pools and tracked in free ...
-
编辑 删除
What are Subpools?
In Oracle 9i and later versions, the Shared Pool can be divided into subpools. Each subpool is a "mini" shared pool, having its own set of Free Lists, memory structure entries, and L...
-
编辑 删除
How is memory allocated and deallocated in the SGA pools?
The SGA is comprised of fixed areas like the Log Buffers and the Buffer Cache(s) as well as memory pools (Shared Pool, Large Pool, Java Pool, and in 10g, the Streams Pool). Memory&nb...
