Oracle 10g RAC on Linux -- copy from Oracle-Base

removed this post as it is available on Oracle-Base and only affects search results here. too long.

I will try to keep my posts easy to understand and easy to use for readers. So I will keep them short.

Enjoy reading.

Ken Chen

12/23/2019

收到期待已久的《构建Oracle高可用环境》一书了

今天收到了妈妈寄来的包裹，拿到了这本期待已久的书。
Piner写的很认真，这书有很多我想看想学的东西！

Basic Unix Command Mind map

This is a copy from David G Ward, a teacher of Seneca College in Toronto. When I was studying at York University, I went to listen to some lectures that interested me. There are quite a few famous instructors in Seneca, such as Murray Saul, Cathy Leung...they are really good.

Oracle RAC Installation Tree

Please feel free to distribute this mindmap, but do not remove the Company Name.

Thanks,

Ken Chen

天才学校

今天收到Vintage的电话，说有位置给女儿上三年级。好了，那他们两个都顺利转学到Vintage了。

我老板说Vintage比不上Andasol，我认为要试过才知道。至少，从网评，考试分数，和学校的荣誉看，Vintage都比Andasol高至少两个档次。看看他们下个学年学的怎么样。

铁血战士玩完了

阿诺领导的加州负债累累，一边要加税，一边还要削减教育经费。看他是搞不定了。大公司都搬走了。我们公司也把部分业务搬到德州去了。还在削减加州的人员。
最近还决定把机器硬件都搬到别的州去，看来，我们部门危险了。

爹地攞厘做什么

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

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.