What are the new features in Oracle 10G DBA?
Asked by Nitya C Last Modified
Follow 0 
Answer 
Skyitsolutions
Hi Nityashree.... There are lots of new features in Oracle 10g... atleast 400+ new features in total related to DBA and Developer (Oracle 10g was released some 8-9 years back). Things which strike my mind now are : > Automatic Workload Repository > Automatic Database Diagnostic Monitor > Automatic...
read more Hi Nityashree.... There are lots of new features in Oracle 10g... atleast 400+ new features in total related to DBA and Developer (Oracle 10g was released some 8-9 years back). Things which strike my mind now are : > Automatic Workload Repository > Automatic Database Diagnostic Monitor > Automatic SQL Tuning Advisor > SQL Access Advisor > Automatic Segment/Memory/UNDO advisor > Automatic Storage management > In 9i we had 1 flashback... in 10g we have 6 types of flashback features > DataPump is a new utility similar to Export/Import in earlier versions with additional features... read less
0
Comments
Ankit Bhardwaj
Oracle DBA expert
Undo management is automatically managed. ASSM , optimizer mode , AMM
0
Comments
Skyitsolutions
Ankit, As far as I know... ASSM - Automatic Segment Space Management is available from 9i UNDO Management was introduced in 9i Optimizer Mode is there in earlier versions too... one thing is that RULE hint has been deprecated parameter from 10g onwards.... only COST based is supported... (FIRST_ROWS......
read more Ankit, As far as I know... ASSM - Automatic Segment Space Management is available from 9i UNDO Management was introduced in 9i Optimizer Mode is there in earlier versions too... one thing is that RULE hint has been deprecated parameter from 10g onwards.... only COST based is supported... (FIRST_ROWS... ALL_ROWS...) Regards Dinesh Chandar MK read less
0
Comments
Oracle 10G for administrators has many new advanced features such as cluster ready services, cloning,automatic storage management,DBCA,Collection process,automatic launching , automatic pre install checksatc and many more..
0
Comments
Ajiesh Mon
Technical Training
Simplified Oracle10g installation Enhanced Enterprise Manager Introducing DataPump - The load/unload utility Automatic Database Diagnostic Monitor Automatic Shared Memory Management Automatic Optimizer Statistics Gathering Automatic Undo Tuning Automatic Workload Repository Automatic...
read more Simplified Oracle10g installation Enhanced Enterprise Manager Introducing DataPump - The load/unload utility Automatic Database Diagnostic Monitor Automatic Shared Memory Management Automatic Optimizer Statistics Gathering Automatic Undo Tuning Automatic Workload Repository Automatic Storage Management Automatic Maintenance Tasks read less
0
Comments
View 3 more Answers
Related Questions
5 My name is Rajesh , working as a Recruiter from past 6 years and thought to change my career into software (development / admin/ testing ) am seeking for some suggestion which technology I need to learn ? Any job after training ? Or where I can get job within 3 months after finishing my training programme- your advices are highly appreciated 
Mr rajesh if you want to enter in to software Choose SAP BW AND SAP HANA because BW and HANA rules the all other erp tools next 50 years.it provides rubust reporting tools for quicker decesion of business It very easy to learn
What is the eligibility criteria for learning Oracle 10g DBA?
First of all oracle 10G is deprecated version. 12c is current version. Any beginner can go for 11G. No remarkable criteria required. RDBMS concept may get extra mileage.
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionLooking for Oracle 10g DBA Training?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you
