what r tyhe major differences between oracle 9i & 10g?
Answers were Sorted based on User's Feedback
Answer / sonali
oracle 10g has introduced data pump,awr addm etc
| Is This Answer Correct ? | 25 Yes | 3 No |
Answer / krishna
oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump..
generating snap shot is much more flxible in 10 g compare to 9i
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / ramesh
ASM,procative performance monitoring,initialization
parameter add and absolute(sga_target).
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / paaru ninar
The main differences b/w oracle 9i and 10g both are one and
the same but 10g has some additional features like RECYCLE
BIN (like purge and flashback) and IIMESTAMPS
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ranjith
first you read properly then give your ideas plz
| Is This Answer Correct ? | 5 Yes | 2 No |
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to define a variable to match a table column data type?
What are advantages of dateset in datastage?
When do we use group by clause in a sql query?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to check database size in Oracle?
What is analyze command used for?
What is SQL Tuning Advisor in Oracle?
How can you merge two tables in oracle?
what is a view?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What is instant client oracle?