what is the difference with oracle 9i and 10g?
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
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
Is sap a database ?
How do you solve oracle archive struck?
How to apply job on OS Level?
What is difference between oracle 9i and oracle 10g?
what post steps and pre steps db refresh
Can you change the profile parameter in the os level? Which one is advisable why?
Error in the phase import_proper while applying support packages?
On a particular system how you can get a list of the users with development access on a particular system?
steps to congigure CMS in XI ?
please share sap basis admin interview questions .. thanks sadik
What are the different user types in sap system that an admin can use while creating a new user?
Where will you change the parameters in three profiles?
How you can disable the ‘import all’ button on stms for the queues?
What are the key responsibilities of sap basis administrator?