Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference with oracle 9i and 10g?
- 2 Answers
- 9516 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 do you check the users logs in your system and how many sessions each user is generating?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
can u explain step by step procedure of DB REFRESH..Ravi
What are the Pre- requisite for system copy?
How would you troubleshoot the 'system seems slow'?
Explain what is the use of reference and service user in sap?
Can you tell me installation procedure of SAP on UNIX
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
What are the different types of job status? Can you unschedule an active job?
What are common background jobs that will run in your system?
if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days
What is the difference between st06 and st03?
What is the procedure to applying patches?
What is the different architecture between SAP 4.7EE & ECC5.0
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
