Oracle 11g new features?

Answers were Sorted based on User's Feedback



Oracle 11g new features?..

Answer / kittu

1) ORACLE_BASE has been introduced
2) ADR(Automatic Diagnostic Repository) added ( instead of udump, bdump, cdump in oracle 10g)
3) Case sensitive passwords
4) Data recovery advisor in RMAN
5) For db cloning in RMAN "from active database" command
6) SYSASM system level privilege has been introduced
7) New initialization parameter memory_target (instead of sga_target & pga_target)

Is This Answer Correct ?    9 Yes 0 No

Oracle 11g new features?..

Answer / sam

online patching,Tables can changed to read only,In datapump
parameter compression can have following values 1)
data_only,2)metadata_only,3)all,4)none

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Administration Interview Questions

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


Oracle 11g new features?

2 Answers  


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  


What is the difference between LMT & DLT?

1 Answers   CTS,






Explain what partitioning is and what its benefit is.

2 Answers  


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  


how can you find out if a table can be redefined?

0 Answers   Oracle,


what is difference between user managed backup and rman backup?

1 Answers   CTS,


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


Categories