How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
Answer Posted / yasaswini
the major differences between Oracle9i and Oracle10g:
Major changes to SQL optimizer internals
Oracle Grid computing
AWR and ASH tables incorporated into Oracle Performance
Pack and Diagnostic Pack options
Automated Session History (ASH) materializes the Oracle
Wait Interface over time
Data Pump replaces imp utility with impdp
Automatic Database Diagnostic Monitor (ADDM)
SQLTuning Advisor
SQLAccess Advisor
Rolling database upgrades (using Oracle10g RAC)
dbms_scheduler package replaces dbms_job for scheduling
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does the acronym acid stand for in database management?
Is pl sql a scripting language?
Which software is used for pl sql programming?
what are date and time data types? : Sql dba
Does normalization improve performance?
What is the max nvarchar size?
What is sql engine in oracle?
What are the different types of database management systems?
What is the reports view in oracle sql developer?
what is the difference between blob and text? : Sql dba
How do you run a query?
Does sql*plus have a pl/sql engine?
What is the location of pre_defined_functions.
What are the query optimization techniques?
Is delete faster than truncate?