How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
- 1 Answers
- 5033 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer / 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 |
How to return an array from java to pl/sql?
how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6
how to convert character strings to numeric values? : Sql dba
write the Sql query for creating database backup?
What are aggregate functions in sql?
Mention what pl/sql package consists of?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Can we create clustered index without primary key?
Which is faster count (*) or count 1?
What is not equal in sql?
What are different types of sql commands?
What are the basic sql commands?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
