what is the difference with oracle 9i and 10g?
Answers were Sorted based on User's Feedback
Answer / 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 |
A role is assigned to 100 users and for one day only 10 users need to be able to access that role and the other 99 users should not have access. How do you do that?
What are the functional modules used in sequence in BDC?
Database related issues?
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
How can we creat a Z authorization object, can anyone help me with the procedure and the T-code for the same?
what is the difference with oracle 9i and 10g?
Describe the various types of transport request.
House keeping jobs?
Can i lock a particular table.If yes then how
How to kill a background job which is not showing any pid in sm50
What kind of ABAP dumps errors you faced and how to resolve?
can anyone tellme java instance startup sequence?