The most recent content from our members.
Hi Guys, Doing a capacity plan, and I'm a tad confused by the results of the above it. I cant figure out how it has defined its raw capacity for this field or where its getting its observed usage from since no other report seems to correlate (i would imagine it would match to the cluster vm max iop usage report but its…
Description This custom report will list the Top N SQL statements in your instance by number of disk reads. To use this report, run it from SQL*Plus while connected to the Ignite repository database. SQL*Plus Script select id, name from cond order by name; prompt Which Database ID accept DBID prompt Enter Start Date…
Description This procedure, when executed, will return all SQL statements for the given date range ordered by the Logical I/O per execution. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored Procedure IF…
It looks like you're new here. Sign in or register to get started.