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 |
How to applay support patches? Pre- requisites?
What is the folder it will ask to install oracle?
Have you participated in Kernel upgrading and OCS Patches?
What is the tablespace? difference between Offline redolog files and online redolog files? Datafiles? Resizing table space how wil do?
To check if oracle processes are running?
How u will assign Logon Groups?where u find logo.ini
i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?
1 Answers HCL, Pyrotech Odyssey,
How R3 systems are communicated?
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 is supplementation language?
how can we transport one or two tables in client copy from one client to another client?
Hai which kernel version, and patch version and now in real time we need to apply? ie means which version is now running on real time?