What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Answer Posted / guest
This value causes the optimizer to use the cost-based
approach for all SQL statements in the session regardless of
the presence of statistics and to optimize with a goal of
best response time.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What to do if dba lost the system password?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Will you be able to store pictures in the database?
When system tablespace is created?
What is the difference between count (*), count (expression), count (distinct expression)?
Why does for update in oracle 8 cause an ora-01002 error?
What is columnar storage what is the advantage?
What is meant by joins? List out the types of joins.
11. Display the client number and name and the client number and name of the person who referred that client.
What is the relation of a user account and a schema in oracle?
Explain the difference between sap and oracle?
Differentiate between pre-select and pre-query?
Can we store images in oracle database?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.