Oracle 11g new features?
Answers were Sorted based on User's Feedback
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 |
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 |
How would you best determine why your MVIEW couldn't FAST REFRESH?
What's the benefit of "dbms_stats" over "analyze"?
Oracle 11g new features?
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?
What is the difference between LMT & DLT?
Explain what partitioning is and what its benefit is.
Give two methods you could use to determine what DDL changes have been made.
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
how can you find out if a table can be redefined?
what is difference between user managed backup and rman backup?
What are statistics, under what circumstances they go out of date, how do you update them?
Give the stages of instance startup to a usable state where normal users may access it.