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()