set linesize 200 set pagesize 0 select * from table (dbms_xplan.display_awr( '44snxh96pfuxb',1084138060,null, 'TYPICAL'));Where
- the first argument is the SQL id
- the second argument is plan hash value (optional)
- the third argument the DB_ID. If not specified, the value from V$DATABASE is used
- the fourth argument is the format string. TYPICAL is the default value.
Source: Oracle Documentation
No comments:
Post a Comment