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
Explain what are the functional modules used in sequence in bdc?
If client copy is stopped in middle, what happens if you want to start it again?
What are the different modules of SAP?
How you will give new authorizations?
what post steps and pre steps db refresh
Explain transport domain?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
Explain what is “data sets” in sap?
What is the information derived from OSS notes?
Explain kernel upgrade?
describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?
What are steps for DB Refresh?
What is the difference between consolidation and development route ?