随笔- 285 文章- 47 评论- 3 阅读- 37万

随笔分类 - Oracle Basic Know-How

Basic knowledge and Oracle new feature and new Technology

摘要：Enable RowMovement.I’m trying to share one of my past experience with “row movement” in my early career days…An Application deleted about 80 million rows (approx) in a table where the table had just above 87 million rows. This was a routine activity for them at their business EOD.And they saw perfor 阅读全文

posted @ 2012-09-12 00:22 jefflu99 阅读(1393) 评论(0) 推荐(0) 编辑

Oracle® Database Performance Tuning Guide 11g Release 2 (11.2)----Configuring and Using Memory

摘要：It's Oracle official document about oracle memory :http://docs.oracle.com/cd/E11882_01/server.112/e16638/memory.htm 阅读全文

posted @ 2012-09-09 22:21 jefflu99 阅读(128) 评论(0) 推荐(0) 编辑

Oracle 11g - Creating and Maintaining a Password File

摘要：Oracle® Database Administrator's Guide11g Release 2 (11.2)Part Number E10595-04Creating a Password File with ORAPWDThe syntax of the ORAPWD command is as follows:ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}]Command arguments are summarized in the following table. 阅读全文

posted @ 2012-09-03 23:29 jefflu99 阅读(593) 评论(0) 推荐(0) 编辑