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 |
I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise
After client copy is table space and database sizes will be increased or not?
what are the pre-requisites for java stack upgradation in bulk?and which EP components you have to upgrade first?
What are various profiles available for client copy?
What is a background processing batch scheduler?
if there are 3 clients in quality(100,200,300) and only two clients in production(100,200) , how many clients will be there after system Refresh ?
What are the categories to execute sap background jobs?
HOW TO TRANSPORT SAME REQUST TO MANY CLIENTS
How to do transports from OS level?
What is the procedure to apply Patches?
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
Hi Al I have a small querry in SAP there are different type of Users one of them is System User I want to know why the system user is created and if created what is use of them and how they are associated with the Dialogue User ,As we all know Dialogue user can perform all work in Sap by logging in the sap server , so why the system user is created and how they are associated with Dialogue user With Rgds