Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance.
What would be your next step to improve performance()
来源:考试资料网2018-08-02
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old
What could be the reason for this error()
来源:考试资料网2018-08-02
Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements aretrue regarding the above command()
来源:考试资料网2018-08-02
Identify the situations in which you use the alert log file in your database to check the detail.()
来源:考试资料网2018-08-02
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted()
来源:考试资料网2018-08-02