skip to main
|
skip to sidebar
Oracle Miscelleneous
Wednesday, December 22, 2010
Display Plan for SQL from STS(Manual)
select sql_id from dba_sqlset_statements
where sqlset_name = '&STS_Name'
order by sql_id;
SELECT * FROM table ( DBMS_XPLAN.DISPLAY_SQLSET( '&STS_NAME','&SQL_ID'));
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
▼
2010
(11)
▼
December
(9)
Manual AWR Baselinje
Display Plan for SQL from STS(Manual)
schema Stat Refresh and print objects
Manual STS
Generate Stat script for a schema
Find Index
SGA info
Schema Stat
Stale Stat
►
October
(1)
►
September
(1)
About Me
Prashant Vaze
Certified Oracle 8/8i/9i/10g/11g DBA professional. Extensive experience in HA multi TB OLTP and DSS databases in RAC and single instance mode
View my complete profile
No comments:
Post a Comment