December 2002
Intermediate to advanced
928 pages
85h 29m
English
FUNCTION DBMS_PROFILER.START_PROFILER
(run_comment IN VARCHAR2 := SYSDATE
[,run_comment1 IN VARCHAR := '']#
[,run_number OUT BINARY_INTEGER]#)
RETURN BINARY_INTEGER;
Starts the profiler with comments. run_number is an optional OUT parameter that stores the run number to access the information later. The last two parameters are new with Oracle9i.
FUNCTION DBMS_PROFILER.STOP_PROFILER
RETURN BINARY_INTEGER;
Stops the profiler run.
FUNCTION DBMS_PROFILER.FLUSH_DATA
RETURN BINARY_INTEGER;
Flushes the data to pre-existing database tables.
FUNCTION DBMS_PROFILER.PAUSE_PROFILER
RETURN BINARY_INTEGER;
Pauses profiler data collection. New with Oracle9i.
FUNCTION DBMS_PROFILER.RESUME_PROFILER
RETURN BINARY_INTEGER;
Resumes profiler data collection. New with Oracle9i.
PROCEDURE DBMS_PROFILER.GET_VERSION
(major OUT BINARY_INTEGER,
minor OUT BINARY_INTEGER);
Returns the version of the package.
FUNCTION DBMS_PROFILER.INTERNAL_VERSION_CHECK
RETURN BINARY_INTEGER;
Checks to make sure this version of the package can work with the version of the database.