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
What is the procedure to applying patches?
If possible send me screenshot doc for installation of ecc6
How to perform the transport?
What are the different types of sap profiles?
What do you understand by executing background jobs in sap system?
What is the use of account id in logon tab?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
How to transfer request which is created directly on quality server & has to be moved to in production server?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
Where will u find transport error logs?
How do you check the installed software components and product versions on sap system?
Where can you find a list of object keys included in a transport?
can we give one check for all vendors in automatic payment run? how?
How to do transport at OS level?
Where XML file is generated in solution manager?