全部博文
-
编辑 删除
SQL Profile
试验了用 SQLＰＲＯＦＩＬＥ引导Ｏｒａｌｃｅ采用好的ｅｘｅｃｕｔｉｏｎ ｐｌａｎ： http://oracle-study-notes.blogspot.com/2009/06/explore-sql-profile.html
-
编辑 删除
Invalidate a cursor - don't need to flush shared pool
I read from somewhere that issuing harmless DDL, for examples comment and grant statements could be a good way to invalidate a cursor. I have not got chance to verify it until today. I set up a test a...
-
编辑 删除
DEGREE 的类型
一直以为DBA_INDEXES, DBA_TABLES中的DEGREE的类型是NUMBER，其实不然。 见： http://oracle-study-notes.blogspot.com/2009/04/column-degree-of-dbaindexes-view-is.html
-
编辑 删除
新到ITPUB
偶然机会，发现ITPUB。觉得不错，特来报道。个人技术blog: http://oracle-study-notes.blog.com
