def get_sql_stats(target):
"""docs.oracle.com: V$SQLSTATS displays basic performance statistics for SQL cursors and contains one row per """ \
"""SQL statement (that is, one row per unique value of SQL_ID). The column definitions for columns in """ \
"""V$SQLSTATS are identical to those in the V$SQL and V$SQLAREA views. However, the V$SQLSTATS view """ \
"""differs from V$SQL and V$SQLAREA in that it is faster, more scalable, and has a greater data retention (""" \
"""the statistics may still appear in this view, even after the cursor has been aged out of the shared pool)."""
return render_page()
def get_sql_area(target):
"""docs.oracle.com: V$SQLAREA displays statistics on shared SQL areas and contains one row per SQL string. """ \
"""It provides statistics on SQL statements that are in memory, parsed, and ready for execution. """ \
"""V$SQL lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each """ \
"""child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end """ \
"""of query execution. However, for long running queries, they are updated every 5 seconds. This makes """ \
"""it easy to see the impact of long running SQL statements while they are still in progress. """ \
"""asktom.oracle.com: ...v$sqlarea is a aggregate of v$sql."""
return render_page()
def get_query_report(target, query):
result = render_page(True)
if not result:
abort(404)
root = ElementTree.fromstring(result)
sql_text = root.find('.body/p')
if sql_text is not None:
if len(sql_text.text) > 1000:
sql_text.text = sql_text.text[:1000] + '...'
excess_items = [
'./head/title', './body/h1', './body/hr', './body/font/hr'
]
for item in excess_items:
for found_item in root.findall(item):
found_item.clear()
return render_template(get_query_report.template + '.html',
data=ElementTree.tostring(
root, method='html').decode('utf-8'))
def get_target_objects(target):
return render_page()
def get_dml_locks(target):
return render_page()
def get_target_waits(target):
return render_page()
def get_advisor_task_report(target, owner, task):
return render_page()
def get_synonyms(target):
return render_page()
def get_outstanding_alerts(target):
return render_page()
def get_plans_cache(target):
return render_page()
def get_ts_fragmentation(target):
return render_page()
def get_tablespace_usage(target):
return render_page()
def get_temp_usage(target):
return render_page()
def get_target(target):
return render_page()
def get_table_stats(target):
"""Pct wasted is a very approximate parameter, based on average row length."""
return render_page()
def get_target_snapshot(target):
return render_page()
def get_ind_partitions_count(target):
return render_page()
def get_advisor_findings(target):
return render_page()
def get_modifications(target):
return render_page()
def get_index_usage(target):
return render_page()
def get_undo_usage(target):
return render_page()
def get_session_monitor(target):
"""Px means the session is parallel run coordinator."""
return render_page()
def get_segment_usage(target):
return render_page()
def get_alert_history(target):
return render_page()
def get_sql_monitor(target):
return render_page()
def get_index_stats(target):
return render_page()
def get_target_long_ops(target):
return render_page()
def get_privileges(target):
return render_page()
def get_users(target):
return render_page()
def get_rman_status(target):
return render_page()
