神刀安全网

2 Reports You Might Enjoy in Oracle SQL Developer

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer.

Today I’m going to share 2 reports that I frequently forget about, that you may enjoy.

Finding Unindexed Foreign Keys

We all know this should not happen. We all know it eventually happens. Here’s a report to help you quickly find these in your database.

2 Reports You Might Enjoy in Oracle SQL Developer

Found under the Quality Assurance section of your database reports.

You could easily make this a custom report and have a child page that showed a computed DDL statement to build your index, or include an object hyperlink to the ‘offending’ table…

Top SQL – Tune It!

This report requires both the Diagnostic and Tuning Packs be licensed in the databases you want to run it. You can then ask for expensive queries by wait events over the past X seconds. And when you click one, you can see the SQL Tuning Advisor task output for your offending query.

2 Reports You Might Enjoy in Oracle SQL Developer

It will prompt you for time in seconds to go back in Active Session History (ASH) .

And you can find this report here:

2 Reports You Might Enjoy in Oracle SQL Developer

Remember: this touches ASH and the SQL Tuning Advisor.

转载本站任何文章请注明:转载至神刀安全网,谢谢神刀安全网 » 2 Reports You Might Enjoy in Oracle SQL Developer

分享到:更多 ()

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
分享按钮