Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:Database_Management_System
|
| gptkbp:aimsTo |
user experience
overall database performance |
| gptkbp:analyzes |
execution plans
|
| gptkbp:basedOn |
cost-based optimization
|
| gptkbp:benefits |
large databases
|
| gptkbp:can_be |
service level agreements (SLAs)
|
| gptkbp:createdBy |
SQL_tuning_sets
|
| gptkbp:designedFor |
improving_SQL_query_performance
|
| gptkbp:evaluates |
SQL_statements
|
| gptkbp:features |
gptkb:Oracle_Autonomous_Database
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQL tuning advisor
|
| gptkbp:includes |
capacity planning
resource allocation query optimization troubleshooting_SQL_issues |
| gptkbp:is_a_tool_for |
performance analysis
|
| gptkbp:is_available_in |
Oracle_10g_and_later
|
| gptkbp:is_integrated_with |
gptkb:SQL_Access_Advisor
|
| gptkbp:is_part_of |
gptkb:Oracle_Database_Cloud_Services
gptkb:Oracle_Enterprise_Manager gptkb:Oracle_SQL_Developer |
| gptkbp:is_used_in |
Oracle Database
reduce resource consumption enhance application performance performance tuning processes database_administrators |
| gptkbp:mayHave |
historical performance data
SQL_workload |
| gptkbp:offers |
SQL_profile_recommendations
|
| gptkbp:provides |
advice on join methods
explain plans recommendations for index creation recommendations for query rewriting detailed_reports_on_SQL_performance real-time_SQL_monitoring |
| gptkbp:recommendation |
materialized views
partitioning strategies statistics gathering parameter adjustments database configuration changes hints_for_SQL_execution |
| gptkbp:reduces |
query execution time
|
| gptkbp:requires |
access to database statistics
|
| gptkbp:suitableFor |
data warehousing systems
OLTP_systems |
| gptkbp:supports |
automatic_SQL_tuning
|
| gptkbp:visitedBy |
suboptimal queries
SQL_performance_issues bottlenecks_in_SQL_execution |