Oracle Database Tuning ADDM
ADDM (Automatic Database Diagnostic Monitor) implements the Oracle performance method and analyzes statistics to provide automatic diagnosis of major performance problems. Because ADDM can significantly shorten the time required to improve the performance of a system, it is one of the most used performance tuning tools of Oracle database.
1. Run some operations on your database instance.
First, start your database instance and do the database operations (select, update, delete...) which will be optimized. e.g. run a script to make some queries in database:
sh run.sh -r rdf1mm-performance -t p -f p3.txt
2. Login to EM
Login to Database EM home page (https://:5500/em), click Performance tab.
3. Run ADDM
Click Button "Run ADDM Now", and click "Yes" on the confirmation page. After a while, we will see the ADDM analysis page.
Database Activity chart shows the database activity during the ADDM analysis period.
In the ADDM Performance Analysis table, ADDM findings are listed in descending order, from highest to least impact. The Informational Findings section lists areas that have no performance impact and are for information only.
4. Implement ADDM recommendations
Click the ADDM findings that has the impact on performance. e.g. Top SQL Statements.
The Category column displays the category of recommendation. The Benefit column displays the estimated benefit of implementing the recommendation.
If we click "Run Advisor Now", SQL tuning advisor will give us some recommendations on how to tune the SQLs.
Ïà¹ØÎĵµ£º
oracle×ö²éѯÓï¾äµÄʱºò£¬ÀàËÆselect id in (xxxx,xxxx.....)ÕâÑùµÄÓï¾ä×î´óÖ»Ö§³Ö2000¸öÖµ£¬Èç¹û¶ÔÓ¦µÃÖµÉÏÍòÐУ¬Èç¸ÃÈçºÎ´¦ÀíÁË¡£
ÕâʱºòÓ¦¸Ã²ÉÓÃÁÙʱ±í¡£½¨Ò»¸öÁÙʱ±í£¬°ÑÊý¾Ýµ¼Èë½øÈ¥¡£²éѯʱºòÁª±í²éѯ¼È¿É¡££¨ÒÔÉÏÊÇÎÒ¹¤×÷ÖÐÓöµ½µÄÒ»¸öÐèÇó) ......
ÏÂÔØµØÖ·£º
http://www.itsoba.com/Article.asp?id=847
ÊÓÆµ½éÉÜ£º
±¾Ì×ORACLEÊÓÆµ½Ì³ÌΪ´«ÖDz¥¿ÍÄÚ²¿¾µä½ÌѧÊÓÆµµÄÒ»¼¯£¬ºóÐøÊÓÆµÕýÔÚÂ¼ÖÆºÍÕûÀíÖУ¬¾´Çë¹Ø×¢¡£
½²Ê¦½éÉÜ£º
ÍõÖιú£¬ÓжàÄêÈí¼þ¿ª·¢¾ÑéºÍ½Ìѧ¾Ñ飬ÏȺóÔÚ¶à¼ÒÈí¼þ¹«Ë¾µ£ÈÎÈí¼þ¹¤³Ìʦ¡¢ÏîÄ¿¾Àí£¬¾«Í¨J2SE¡¢J2ME¡¢J2EE¡¢Linux¡¢Oracle¡¢SqlS ......
17:00:59 SQL> desc dbms_random;
Element Type
---------- ---------
SEED PROCEDURE
VALUE FUNCTION
NORMAL FUNCTION
STRING FUNCT ......
µ¥Öµº¯ÊýÔÚ²éѯÖзµ»Øµ¥¸öÖµ£¬¿É±»Ó¦Óõ½select£¬where×Ӿ䣬start withÒÔ¼°connect by ×Ó¾äºÍhaving×Ӿ䡣
(Ò»).ÊýÖµÐͺ¯Êý(Number Functions)
ÊýÖµÐͺ¯ÊýÊäÈëÊý×ÖÐͲÎÊý²¢·µ»ØÊýÖµÐ͵ÄÖµ¡£¶àÊý¸ÃÀຯÊýµÄ·µ»ØÖµÖ§³Ö38λСÊýµã£¬ÖîÈ磺COS, COSH, EXP, LN, LOG,
SIN, SINH, SQRT, TAN, and TANH Ö ......
ºÜ²»ÐÒ£¬½¨Á¢µÄ±í±»Ä³ÈËÎóɾÁË£¬£¬£¬
»¹ºÃ¿ÉÒÔͨ¹ýÕâÑù»Ö¸´¡£
select * from user_recyclebin where original_name like 'FINANCE_%' order by droptime desc;
FLASHBACK TABLE FINANCE_CASE_FEE_ITEM TO BEFORE DROP
¼´ËùÓÐdropµÄ±í¶¼ÔÚ user_recyclebin Õâ¸öoracle»ØÊÕÕ¾ÀïÃæµÄ£¬ÔÙͨ¹ýflashbackÃü ......