Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference with oracle 9i and 10g?
- 2 Answers
- 9595 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / agustuss
Hi
oralce 10g is higher version of oracle 9i, oracle 10g has
added a follwoing features
Transparent Data Encryption
Async commits
CONNECT ROLE can not only connect
Passwords for DB Links are encrypted
New asmcmd utility for managing ASM storage
Grid computing - an extension of the clustering feature
(Real Application Clusters)
Manageability improvements (self-tuning features)
Performance and scalability improvements
Automated Storage Management (ASM)
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Flashback operations available on row, transaction, table
or database level
Ability to UNDROP a table from a recycle bin
Ability to rename tablespaces
Ability to transport tablespaces across machine types (E.g
Windows to Unix)
New 'drop database' statement
New database scheduler - DBMS_SCHEDULER
DBMS_FILE_TRANSFER Package
Support for bigfile tablespaces that is up to 8 Exabytes in
size
Data Pump - faster data movement with expdp and impdp.
Regards,
Agustuss.G
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to deactivate IPC in standalone CRM.
What is the use of profile paramater ztta/roll_area?
How do you check the users logs in your system and how many sessions each user is generating?
I would like to know the version or name of SAP that is implemented in real time?
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
How can you view locked transactions?
How do you create an instance?
What is an interface in SAP?
What is a support package? What is its purpose?
list some common errors faced with jspm while updating java stcks.and solutions.
What is purpose user group in SU01?
How to define logon groups?
Can you tell me installation procedure of SAP on UNIX
How client refresh is different than client copy?
If brtools is not working how you will add datafile?
