Database Tuning In Oracle 10g/11g Db Administration
I"m going to explain about oracle advisor frame work as it pertain the oracle 11g environment we"ll look at new advisors they come stranded with the oracle 11g database we"ll look at the automatic database advisers we"ll look at the maintenance window which has been are redesigned in the oracle 11g environment.
The advisor framework is to make sure cartooning ducks or Perrot. The advisor framework is going to located under oracle enterprise manager. Pretty much any tap have will have the advisor central tap. Under advisor central we have the ability to ADDM and as well as memory advisors. You can remember ADDM is automatic database diagnostic monitor. It is written on top of eight on the line. If you have ADDM are enabled we will collect database performance statistics every hour. And leaving recorded information consist SYS.orc table after successful AW are run ADDM will run. ADDM will look at the rocket that is provided by edit AW. The advantage of ADDM is that gives us the action, recommendation as well as the rational. That will then comeback and I will tell us I suggest ADDM is best. We suggest that you can fill out these changes now that right then and there you can implement the recommended changes or you can review it at a later point day and come back and recommend that you implement the recommendations or not a lot. Are there by the central we have the memory adviser with a little bit.
The memory advisors will provide advice on SJM as well as the overall PGA. If we had more space to the FDA how much more throughput coming to speck to get. If we had more space to the PGA how many more sort operations configure place with the memory. Now we have the SQL advisors under the SQL advisors we have the sequel access advisers, which would provide us advised on the indexes materialized views as well as partitions. We have the sequel tuning advisor. Sequel tuning advisor if I rewrite the e-bill statement how many better performance privacy and in a brand new in oracle 11g with the sequel repair advisor. The sequel repair advisor says if I implement oracle patch it will repair the simple statement. Also we have one more advisor called automatic undo management. This advisor tells us if I increase the value of under retention by increasing the value untrue retention how large related to take my undo table space to grow.
And the DBA is what it is all the time for some reasons we need to retain longer time in the table space in the details but we don"t have any idea of the how a lot undo table space will grow. So I had increased the value and the advisor will say if you increasing value from one day to two days figure and details first will grow.
We are going to Provided that you require more data on Database Tuning in Oracle 10g/11g DB Administration.
The advisor framework is to make sure cartooning ducks or Perrot. The advisor framework is going to located under oracle enterprise manager. Pretty much any tap have will have the advisor central tap. Under advisor central we have the ability to ADDM and as well as memory advisors. You can remember ADDM is automatic database diagnostic monitor. It is written on top of eight on the line. If you have ADDM are enabled we will collect database performance statistics every hour. And leaving recorded information consist SYS.orc table after successful AW are run ADDM will run. ADDM will look at the rocket that is provided by edit AW. The advantage of ADDM is that gives us the action, recommendation as well as the rational. That will then comeback and I will tell us I suggest ADDM is best. We suggest that you can fill out these changes now that right then and there you can implement the recommended changes or you can review it at a later point day and come back and recommend that you implement the recommendations or not a lot. Are there by the central we have the memory adviser with a little bit.
The memory advisors will provide advice on SJM as well as the overall PGA. If we had more space to the FDA how much more throughput coming to speck to get. If we had more space to the PGA how many more sort operations configure place with the memory. Now we have the SQL advisors under the SQL advisors we have the sequel access advisers, which would provide us advised on the indexes materialized views as well as partitions. We have the sequel tuning advisor. Sequel tuning advisor if I rewrite the e-bill statement how many better performance privacy and in a brand new in oracle 11g with the sequel repair advisor. The sequel repair advisor says if I implement oracle patch it will repair the simple statement. Also we have one more advisor called automatic undo management. This advisor tells us if I increase the value of under retention by increasing the value untrue retention how large related to take my undo table space to grow.
And the DBA is what it is all the time for some reasons we need to retain longer time in the table space in the details but we don"t have any idea of the how a lot undo table space will grow. So I had increased the value and the advisor will say if you increasing value from one day to two days figure and details first will grow.
We are going to Provided that you require more data on Database Tuning in Oracle 10g/11g DB Administration.
Source...