爹地攞厘做什么

忙了一整天，跟老婆说，如果有一种机器或法术，让我一按，就可以把饭做好，把碗筷洗好，把衣服叠好，把地拖好，那就好了。
这时，旁边的儿子就插嘴了，“如果甘，爹地攞厘做什么。”
把我们都笑翻了。天啊，原来老豆我在儿子眼里就跟菲佣没什么区别。

Data Warehouse Best Practices(2) -- Optimizing Star Queries

--From Oracle DW Best Practices White Paper

Two most important criteria are:

1. Create a BITMAP index on each of the foreign key columns in the fact table or tables

2. Set the init parameter STAR_TRANSFORMATION_ENABLE to TRUE. This will enable the optimizer feature for star queries.

Data Warehouse Best Practice (1) -- Partition exchange load

--From Oracle DW Best Practices White Paper

Steps:
1. Create external table for the flat file data coming from the online system
2. Using CTAS statement, create a non-partitioned table that has the same column structure as Sales table
3. Build any indexes that are on the Sales table on the temp_sales table
4. Gather optimizer statistics on the temp_sales
5. Issue the exchange partition command:
ALTER table Sales EXCHANGE partition May_24_2009 with table temp_sales including indexes without validation;

The last step does not physically move data, it simply updates the data dictionary to reset a pointer from the partition to the table and vice versa. So it is a sub-second operation and far less likely to impact performance than any traditional data-movement approaches such as INSERT.

在雨中起舞

Life is not about waiting for the storms to pass...it's about learning how to dance in the rain.

以前对这句话没有太深的感触，直到有了四条化骨龙。总跟自己说，等他们会走路了，就好了，就有时间了。等他们上学了，就会有时间了。等他们可以自己穿衣服了，就会有时间了。如果总是等，等，等。等到我的头发都全白了的时候，可能我才发现，我已经没有精力或激情了。

开始学习在雨中起舞。挤时间看想看的书，做想做的事，看想看的风景，见思念的人。享受和家人在一起的安排的密密麻麻的时间表。享受帮他们穿裤子，收拾玩具的时间。享受他们的纠缠和没完没了的问题。享受他们跟我说，爸爸，我长大结婚了还要和你一起住。

呵呵，很快，他们就会长大，不和我一起住了。所以要珍惜现在的繁忙。

SAP R/3 Database Admin Lab Mind Map

This is another one I would like to share.

Again, please feel free to copy or link it, but DO NOT remove the company name.

Thanks,

Ken Chen

BR*Tools Mind Map

I always find it an easier way to memorize notes by making tree mind maps.

Feel free to copy this image if you like it. But please DO NOT remove my company name from it.

Thanks,

Ken Chen

SAP BASIS Study Notes 1 --Adjusting Tablespace

Issue:
We got warning emails saying that a tablespace may be out of free space soon.

Background:
A shell script runs nightly to verify the free tablespace of the database. If free space is less than 75% of recommended threshold number, it will send out an email to DBAs. The recommended threshold number is determined by 4 times monthly data growth.

Solutions:
Use BR*Tools to resize the data file or extend the tablespace.

Steps:

1. su to production account;
2. Start brtools and choose 2 - Space management;
3. Then choose 5 - alter data file;
4. Then BRSPACE asks you to enter input values; I picked 4 ~ Tablespace names and paste the tablespace name;
5. typed "c" to continue several times till we see menu 314;
6. Choose 5-Resize data file;
7. picked the data file;
8. entered the new size for the option with "?";
9. verified the sql statement is correct, and "c"ontinued;
10. got the successful message;
11. exit the program.