2012年9月27日
Discrete Manufacturing – The Made To Order Cycle and Make TO Stock Cycle
摘要： In sap there is specific transaction flow for a particular Manufacturing Process. It all depends upon the requirement of client and process.Here is the basic flow of transactions which is req. for creating master data, planning and order processing…The Made TO Order Cycle:The sale department passes 阅读全文
posted @ 2012-09-27 15:14 jefflu99 阅读(308) 评论(0) 推荐(0)
2012年9月19日
Classification Data Material
摘要： The classification data is used when searching for materials. The characteristic values into the classes for each material can be used to search for material with that set of characteristics.Class TypeThe classification entry screen after the basic data entry allows information to be entered into us 阅读全文
posted @ 2012-09-19 11:35 jefflu99 阅读(725) 评论(0) 推荐(0)
2012年9月12日
[Oracle] Enable Row Movement
摘要： 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 阅读(1421) 评论(0) 推荐(0)
2012年9月10日
How to adjust the high watermark in ORACLE 10g -- ALTER TABLE SHRINK
摘要： Hanging around in my hotel in Chicago because it is raining, I have been cruising around in the OTN forums which inspired me to write something about the High Watermark and the Oracle 10gR1 New Feature SEGMENT SHRINKING.The High Watermark is the maximum fill-grade a table has ever reached.Above the 阅读全文
posted @ 2012-09-10 17:50 jefflu99 阅读(434) 评论(0) 推荐(0)
2012年9月9日
Putty的X-window的妙用在Windows系统下
摘要： 最近用了Putty来远程连接Linux，其中的X11 forwarding的使用很有意思，其中的配置转载国外的；X Forwarding with Putty on WindowsIntro to X ForwardingUnix machines have been able to run software on a remote machine and display the GUI locally for almost two decades. Linux and Mac OS X support X Forwarding with no extra software. Any term 阅读全文
posted @ 2012-09-09 23:41 jefflu99 阅读(615) 评论(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 阅读(133) 评论(0) 推荐(0)
[转]Two new hidden parameters starting from 11.2.0.x
摘要： Starting Oracle 11.2.0.x, Oracle has introduced two new hidden parameters which indeed brings a change in the instance abort and memory setting behaviour.1. _datafile_write_errors_crash_instanceThe above parameter is “TRUE” by default and cause the instance to be aborted if any write to a datafile w 阅读全文
posted @ 2012-09-09 20:56 jefflu99 阅读(308) 评论(0) 推荐(0)
2012年9月7日
[Oracle 10g] 大文件表空间 [转载]
摘要： 最近在做DW的设计的时候，考虑到使用oracle的Bigfile的tablespace --大文件 (Bigfile) 表空间 , 因为它对性能方面确实有不一样的impact；先看看高人写的吧 ！好好学习一下 ； [Oracle 10g] 大文件表空间 作者：Fenng 简单介绍Oracle 10g 的存储能力有了显著的增强。这表现在很多方面，下面介绍 10g 新增的表空间类型：大文件 (Bigfile) 表空间。 大文件表空间从某种角度来说提高了 Oracle 在 VLDB 上的管理能力。 只有自动段空间管理的 LMT (Locally Managed Tablespaces ) 支持 BI 阅读全文
posted @ 2012-09-07 18:11 jefflu99 阅读(388) 评论(0) 推荐(0)
Oracle + RAID ==> Performance impact
摘要： RAIDRAID is an acronym for Redundant Arrays of Inexpensive Disks. These provide a mechanism for load balancing and securing your data across multiple disks. In this article I'll give a brief explanation of the most commonly used RAID levels and how they should be used with Oracle.RAID LevelsOrac 阅读全文
posted @ 2012-09-07 00:28 jefflu99 阅读(235) 评论(0) 推荐(0)
Oracle服务器如何科学组织RAID阵列
摘要： 最近在搞Data Guard为了项目的需求，这个正好是为了OLAP服务的，其中的运算量都很大，数据量也是相当的大.在网上google了一篇文章；觉得挺有帮助的，转来学习一下，我们在部署服务器时通常都免不了RAID阵列级别的选择，RAID技术发展到今天已经有数十种之多了，但我们在生产系统上常用的也就只有几种，如 0，1，5，0+1。读者朋友可能对各个级别的RAID原理已经非常熟悉了，甚至能背诵出来，但面临真正在生产系统中选择最适合应用系统的RAID级别 时，可能没多少心理有底，本文就oracle数据库服务器在选择RAID阵列级别时做一个介绍，希望对还心存疑虑的人们吃一粒定心丸。首先，还是来看看常 阅读全文
posted @ 2012-09-07 00:26 jefflu99 阅读(295) 评论(0) 推荐(0)