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 do you lock users if CUA is configured?
What is supplementation language?
How many types of Work Process.and types of roles. how will assign the role to the user.
If job is slow?
How do you create a password exception list?
How TRANS (:\usr\sap\trans) directory is configured, what is the maximum size of TRANS directory, how to see? briefly....
while applying patches with jspm java engine restarts while the jspm is still running.how?
when i did run cccleaner, i had lost my sapmmc console tree.i can see sapr/3 system option under console root.so i am not able to start my server.how can get resolve of this problem. please any one suggest get rid outoff this.
in oracle script @? "?" question mark means what it indicate?
Mention what is the difference between central instance & application server?
patchs can apply CI OR dialog server?
HI, I'm practicig CRM fuctioal in 6.0 (2007)(Ides) versio the problem is i'm not able to process any transaction type due to IPC is not configured.Please any one can help me to how to config IPC in ides sysetem.Anybody know please provide me the steps.