Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4334 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How many file formats are supported to export data?
What is a materialised view?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
master table and child table performances and comparisons in Oracle ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
When a form is invoked with call_form, Does oracle forms issues a save point ?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How can we find out the current date and time in oracle?
How to check the server version in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Explain the use of compress option in exp command.
Oracle General 
