请教两个TK里的问题

显示全部楼层 · 2005-7-7 01:01:24

QUESTION1:
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown
below:
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 15 GB.
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for
STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to
autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to
shared pool from 3 GB to 2 GB.
QUESTION2:
You work as a database administrator at TestKing.com. In your test database, you find that a user?s
session is executing a lot of SQL statements, resulting in the generation of a large number of trace files.
While investigating the reason, you find that SQL trace has been enabled at the instance level.
You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data
being generated.
How do you achieve this objective?
A. by setting the SQL_TRACE parameter to FALSE in the parameter file
B. by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C. by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user
session
D. by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user
session

千问 · 2005-7-7 01:01:24

其中qustion1中TK给的答案是B,E。我只能选出E,其他的感觉都不对，自动管理的SGA_TARGET怎么能超过SGA_MAX_SIZE呢？不明白
question2中TK的答案是B,可是我查阅了SG，在6-18页找到
for example,setting the initialization parameter SQL_TRACE=TRUE causes the SQL trace facility to generate performence statistics for processing of all SQL statementsfor an instance and write them to USER_DUMP_DEST directory.
Trace files can be generate for server processes at user request. Regardless of the current value of the SQL_TRACE parameter, each session can enable or disable trace logging on behalf of associated server process by using the SQL statement ALTER SESSION SET SQL_TRACE.
所以我认为D才对啊，大家有什么看法？
多谢

千问 · 2005-7-7 01:01:24

最初由 zildjianzhang 发布
[B]其中qustion1中TK给的答案是B,E。我只能选出B,其他的感觉都不对，自动管理的SGA_TARGET怎么能超过SGA_MAX_SIZE呢？不明白
question2中TK的答案是B,可是我查阅了SG，在6-18页找到
for example,setting the initialization parameter SQL_TRACE=TRUE causes the SQL trace facility to generate performence statistics for processing of all SQL statementsfor an instance and write them to USER_DUMP_DEST directory.
Trace files can be generate for server processes at user request. Regardless of the current value of the SQL_TRACE parameter, each session can enable or disable trace logging on behalf of associated server process by using the SQL statement ALTER SESSION SET SQL_TRACE.
所以我认为D才对啊，大家有什么看法？
多谢 [/B]
肯定是b啊! alter session 只能改变current session 的属性!而如果要改变其他session 的属性,9i 中可以利用dbms_session.set_sql_trace !

千问 · 2005-7-7 01:01:24

谢谢楼上的解答：）

千问 · 2005-7-7 01:01:24

学习中

千问 · 2005-7-7 01:01:24

第一个问题哪位好心人能帮我解惑呢？

千问 · 2005-7-7 01:01:24

第一题是：c e