[Q][031]Discuss Together

roscoe

最初由 shyu1 发布
[B]QUESTION NO: 21
Which statement about an Oracle instance is true?
A. The redo log buffer is NOT part of the shared memory area of an Oracle instance.
B. Multiple instances can execute on the same computer, each accessing its own physical database.
C. An Oracle instance is a combination of memory structures, background processes, and user processes.
D. In a shared server environment, the memory structure component of an instance consists of a single SGA and a single PGA.
TK Answer: B

two oracle servers running on the same computer?????.
[/B]

B may not be wrong, since Oracle allows multiple instances running on the same host, while each instance can only handle its own database.

shyu1

roscoe:

Thank you for joining!

"since Oracle allows multiple instances running on the same host"
Can you prove this sentence ?
e.g. which book and which page?

From your said  that means two oracle servers running on the same host, because one instance = one server.

D32645-9i-DBAFundamentalsI-PPT.pdf
p. 9 [Oracle Server] Consists of an Oracle instance and an Oracle database

roscoe

最初由 shyu1 发布
[B]roscoe:

Thank you for joining!

"since Oracle allows multiple instances running on the same host"
Can you prove this sentence ?
e.g. which book and which page?

From your said  that means two oracle servers running on the same host, because one instance = one server.
[/B]

Well I am not sure if my answer is right, so please correct me if I am wrong There are supposed to be 2 possibilities, OPS (parallel server) and multiple servers. Instances of OPS manage the same database, while the latter manages different database.

Sybex
OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery
Study Guide
Chap. 1, p. 14

Software Code Area
.... Multiple instances of Oracle can use the same Oracle code area with different databases if running on the same computer.

shyu1

Nobody can say which one is 100% right except Lawrence J. Ellison.
Please do not hesitate to post any idea here!

xmzw

B
我们公司的测试用机就是2 instances execute on the same computer

samuel

謝謝您的分享，受益不少。

无边落木

不过今天刚开始看031, 水平尚不够跟大家讨论, 我一定努力赶上.
我打算花2个月时间过这一门, 不知道够不够(业余时间学习)?

不知其他各位兄弟打算花多长时间?

shyu1

Before five years  I had worked for database(not Oracle) about two years , SQL for me is easy. But I'm also a novice for Oracle.

xmzw

我计划9月20日去考，不知各位如何安排？

无边落木

I found the part 1 and part 2 are the same.
Also I found some page are lost in the file such as 1-4 or 1-8 or 1-13.....

Can you check this? Thank you!

BTW, when you prepare to take the exam of 031?