"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk)

The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks
and to develop/implement appropriate solutions.

"With great power comes great responsibility" (Uncle Ben)

Features

  • 1_QuickCheck_generic.sql
  • 2_QEP_MissingIndexes_generic.sql
  • 3_ReScript_Indexes_generic.sql
  • 4_IndexUsage_generic.sql
  • 5_Current_Blocks_generic.sql
  • 6_Locks_Blocks_generic.sql
  • 7_TraceCheck_generic.sql

Project Samples

M7_0 Preparation M7_1 QuickCheck M7_2 MissingIndexes M7_3 ReScript M7_4 IndexUsage M7_5 Blocks

Project Activity

See All Activity >

Categories

Database Engines/Servers, Profiling, Performance Testing

License

GNU General Public License version 3.0 (GPLv3)

Follow Magic 7

Magic 7 Web Site

Other Useful Business Software
Go from Code to Production URL in Seconds Icon
Go from Code to Production URL in Seconds

Cloud Run deploys apps in any language instantly. Scales to zero. Pay only when code runs.

Skip the Kubernetes configs. Cloud Run handles HTTPS, scaling, and infrastructure automatically. Two million requests free per month.
Try it free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Magic 7!

Additional Project Details

Intended Audience

Developers, Other Audience, System Administrators

Programming Language

PL/SQL

Database Environment

Microsoft SQL Server

Related Categories

PL/SQL Database Engines Servers, PL/SQL Profiling Software, PL/SQL Performance Testing Software

Registered

2019-08-01
Report inappropriate content