For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
prvt_awr_viewer.awr_rmmetrics_xml(
p_plan_name IN VARCHAR2,
p_awr_period IN OUT PRVT_AWRV_METADATA,
p_bucket_map IN OUT PRVT_AWRV_MAPTAB,
p_bucket_interval IN NUMBER,
p_show_sql IN NUMBER,
p_idname_map IN OUT PRVT_AWRV_INSTTAB,
output_xml IN OUT XMLTYPE);
prvt_awr_viewer.awr_sysmetrics_xml(
awr_period IN OUT PRVT_AWRV_METADATA,
bucket_map IN OUT PRVT_AWRV_MAPTAB,
p_bucket_max_count IN NUMBER,
p_bucket_interval IN NUMBER,
p_metric_type IN VARCHAR2,
p_show_sql IN NUMBER,
output_xml OUT XMLTYPE);
prvt_awr_viewer.awr_sysstat_totalstat_xml(
awr_period IN OUT PRVT_AWRV_METADATA,
bucket_map IN OUT PRVT_AWRV_MAPTAB,
p_bucket_max_count IN NUMBER,
p_bucket_interval IN NUMBER,
p_show_sql IN NUMBER,
p_stat_desc IN VARCHAR2,
output_xml OUT XMLTYPE);
prvt_awr_viewer.create_bucket_snap_map(
p_awr_period IN OUT PRVT_AWRV_METADATA,
p_bucket_map IN OUT PRVT_AWRV_MAPTAB,
p_bucket_max_count IN OUT NUMBER,
p_bucket_calc_interval OUT NUMBER);
prvt_awr_viewer.generate_buckets_tag2(p_buckets IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT prvt_awr_viewer.generate_buckets_tag2('Testing')
2 FROM dual;
PRVT_AWR_VIEWER.GENERATE_BUCKETS_TAG2('TESTING')
---------------------------------------------------------------------------------
nvl2(Testing, xmlelement("buckets", xmlattributes( :p_bucket_interval as "bucket_interval", :p_bucket_count as "bucket_count", :b_min_time as "start_time", :b_max_time as "end_time", :b_duration as "duration"),Testing), null)
prvt_awr_viewer.get_bucket_map(
p_start_time IN DATE,
p_end_time IN DATE,
p_inst_id IN NUMBER,
p_dbid IN NUMBER,
p_bucket_max_count IN OUT NUMBER,
p_bucket_interval OUT NUMBER,
p_awr_period OUT prvt_awrv_metadata;
p_bucket_map IN OUT prvt_awrv_maptab);
SELECT dbid
FROM v$database;
DECLARE
a DATE := SYSDATE-1;
b DATE := SYSDATE;
c NUMBER := 1;
d NUMBER := 428676178;
e NUMBER := 5;
f NUMBER;
g prvt_awrv_metadata;
h prvt_awrv_maptab;
BEGIN
prvt_awr_viewer.get_bucket_map(a,b,c,d,e,f,g,h);
prvt_awr_viewer.report_addm_xml(
start_time IN DATE,
end_time IN DATE,
num_days IN NUMBER,
owner IN VARCHAR2,
task_name IN VARCHAR2,
section IN VARCHAR2,
spotrep IN VARCHAR2,
spotlist IN VARCHAR2,
inst_id IN NUMBER,
db_id IN NUMBER,
show_sql IN NUMBER,
top_n_detail IN NUMBER,
compress_xml IN NUMBER)
RETURN XMLTYPE;
prvt_awr_viewer.report_awrrep_xml(
selected_start_time IN DATE,
selected_end_time IN DATE,
inst_id IN NUMBER,
dbid IN NUMBER,
compress_xml IN BINARY_INTEGER,
report_reference IN VARCHAR2)
RETURN XMLTYPE;
prvt_awr_viewer.report_awr_xml(
start_time IN DATE,
end_time IN DATE,
instance_list IN VARCHAR2,
dbid IN NUMBER,
member_id IN NUMBER,
bucket_max_count IN NUMBER,
time_model IN VARCHAR2,
wait_class IN VARCHAR2,
wiat_event IN VARCHAR2,
event_class IN VARCHAR2,
sysstat IN VARCHAR2,
sqlstat IN VARCHAR2,
osstat IN VARCHAR2,
iostat IN VARCHAR2,
memory IN VARCHAR2,
space IN VARCHAR2,
key_statistics IN VARCHAR2,
summary IN VARCHAR2,
inst_detail IN VARCHAR2,
members IN VARCHAR2,
timepicker_start IN DATE,
timepicker_end IN DATE,
report_level IN VARCHAR2,
show_sql IN NUMBER)
RETURN XMLTYPE;
prvt_awr_viewer.report_containers_xml(
p_start_time IN DATE,
p_end_time IN DATE,
p_last_refresh_time IN DATE,
p_inst_id IN NUMBER,
p_dbid IN NUMBER,
p_IS_realtime IN NUMBER,
p_top_n_count IN NUMBER,
p_top_n_rankby IN VARCHAR2,
p_show_sql IN NUMBER)
RETURN XMLTYPE;
prvt_awr_viewer.report_metrics_xml(
start_time IN DATE,
end_time IN DATE,
inst_id IN NUMBER,
dbid IN NUMBER,
bucket_max_count IN NUMBER,
bucket_interval IN NUMBER,
inst_detail IN VARCHAR2,
report_level IN VARCHAR2,
show_sql IN NUMBER)
RETURN XMLTYPE;
CREATE TABLE t (testcol XMLTYPE);
SELECT sql_id, sid, serial#
FROM v$sqlarea
WHERE executions = (
SELECT MAX(executions) FROM v$sqlarea);
SELECT dbid
FROM v$database;
DECLARE
a DATE := SYSDATE-1;
b DATE := SYSDATE;
c NUMBER := 1;
d NUMBER := 428676178;
e NUMBER := 5;
f NUMBER := 1;
g VARCHAR2(30); -- inst_detail
h VARCHAR2(10) := 'TYPICAL';
i NUMBER := 1; -- show_sql
x XMLTYPE;
BEGIN
x := prvt_awr_viewer.report_metrics_xml(a,b,c,d,e,f,g,h,i);
prvt_awr_viewer.report_rac_xml(
start_time IN DATE,
end_time IN DATE,
last_refresh_time IN DATE,
inst_id IN NUMBER,
dbid IN NUMBER,
is_realtime IN NUMBER,
show_sql IN NUMBER)
RETURN XMLTYPE;
CREATE TABLE t (testcol XMLTYPE);
SELECT sql_id, sid, serial#
FROM v$sqlarea
WHERE executions = (
SELECT MAX(executions) FROM v$sqlarea);
SELECT dbid
FROM v$database;
DECLARE
a DATE := SYSDATE-1;
b DATE := SYSDATE;
c DATE := SYSDATE;
d NUMBER := 1;
e NUMBER := 428676178;
f NUMBER := 1;
g NUMBER := 1;
x XMLTYPE;
BEGIN
x := prvt_awr_viewer.report_rac_xml(a,b,c,d,e,f,g);
prvt_awr_viewer.report_timepicker_xml(
start_time IN DATE,
end_time IN DATE,
duration IN NUMBER,
inst_id IN NUMBER,
dbid IN NUMBER,
is_realtime IN NUMBER,
sql_id IN VARCHAR2,
sid IN NUMBER,
serial IN NUMBER,
show_sql IN NUMBER)
RETURN XMLTYPE;
CREATE TABLE t (testcol XMLTYPE);
SELECT sql_id, sid, serial#
FROM v$sqlarea
WHERE executions = (
SELECT MAX(executions) FROM v$sqlarea);
SELECT dbid
FROM v$database;
DECLARE
a DATE := SYSDATE-1;
b DATE := SYSDATE;
c NUMBER := 1;
d NUMBER := 1;
e NUMBER := 428676178;
f NUMBER := 1;
g VARCHAR2(13) := '96g93hntrzjtr';
h NUMBER := NULL;
i NUMBER := NULL;
j NUMBER := 1;
x XMLTYPE;
BEGIN
x := prvt_awr_viewer.report_timepicker_xml(a,b,c,d,e,f,g,h,i,j);
prvt_awr_viewer.report_topsql_xml(
start_time IN DATE,
end_time IN DATE,
last_refresh_time IN DATE,
inst_id IN NUMBER,
dbid IN NUMBER,
is_realtime IN NUMBER,
top_n_detail IN NUMBER,
outer_start_time IN DATE,
outer_end_time IN DATE,
compress_xml IN BINARY_INTEGER,
show_sql IN NUMBER)
RETURN XMLTYPE
conn / as sysdba
CREATE TABLE t (testcol XMLTYPE);
SELECT dbid
FROM v$database;
DECLARE
a DATE := SYSDATE-1;
b DATE := SYSDATE;
c DATE := SYSDATE-1;
d NUMBER := 1;
e NUMBER := 428676178;
f NUMBER := 1; -- is_realtime
g NUMBER := 10; -- top_n
h DATE;
i DATE;
j NUMBER := 1; -- compress
k NUMBER := 1; -- show SQL
x XMLTYPE;
BEGIN
x := prvt_awr_viewer.report_topsql_xml(a,b,c,d,e,f,g,h,i,j,k);
prvt_awr_viewer.rmmetrics_data_xml(
p_start_time IN DATE,
p_end_time IN DATE,
p_inst_id_low IN NUMBER,
p_inst_id_high IN NUMBER,
p_dbid IN NUMBER,
p_bucket_count IN NUMBER,
p_bucket_interval IN NUMBER,
p_inst_detail IN NUMBER,
p_is_rac IN NUMBER,
p_show_sql IN NUMBER,
p_plan_name IN VARCHAR2)
RETURN XMLTYPE;