Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Parallel Query Diagnostic Utilities
AUTHID
CURRENT_USER
Data Types
TYPE bbox_type IS RECORD (
INST_ID NUMBER,
SLVPID NUMBER,
QC_INST_ID NUMBER,
QCSID NUMBER,
TRACE VARCHAR2(2048));
TYPE bbox_type_local IS RECORD (
SLVPID NUMBER,
QC_INST_ID NUMBER,
QCSID NUMBER,
TRACE VARCHAR2(2048));
TYPE qerpxCnt_type IS RECORD (
INST_ID NUMBER,
KXFBBSET NUMBER,
KXFBBPNAM VARCHAR2(10),
COUNT NUMBER);
TYPE qcslv_type IS RECORD (
QCINSTNO NUMBER,
QCSID NUMBER,
QCPROC VARCHAR2(24),
SLVSID NUMBER,
SLVPROC VARCHAR2(24),
SLVINSTNO NUMBER,
SLVNO NUMBER,
PNAME VARCHAR2(4),
SQL_ID VARCHAR2(13),
COMMAND NUMBER);
TYPE qcslv_type_local IS RECORD (
QCINSTNO NUMBER,
QCSID NUMBER,
QCPROC VARCHAR2(24),
SLVSID NUMBER,
SLVPROC VARCHAR2(24),
SQL_ID VARCHAR2(13),
COMMAND NUMBER,
DEGREE NUMBER,
REQ_DEGREE NUMBER);
TYPE bbox_col IS TABLE OF bbox_type;
TYPE bbox_col_local IS TABLE OF bbox_type_local;
TYPE qerpxCnt_col IS TABLE OF qerpxCnt_type;
TYPE qcslv_col IS TABLE OF qcslv_type;
TYPE qcslv_col_local IS TABLE OF qcslv_type_local;
Displays the black box trace of a query execution after the Parallel Query slave starts
dbms_pqdiag.display_trace(
topnrows IN NUMBER DEFAULT 0,
pxstate IN NUMBER DEFAULT 0,
last_exe IN NUMBER DEFAULT 1)
RETURN sys.dbms_pqdiag.bbox_col PIPELINED;
PARAMETERS:
-- topNrows - only display the top N rows for each slave, default displays all rows
-- pxState - slave process state
-- - 0 = not specified
-- - 1 = available
-- - 2 = in use
-- last_exe - 1 = only show traces of the last executed query,
-- 0 = show all traces in blackbox
col trace format a95
SELECT slvpid, qcsid, trace
FROM TABLE(dbms_pqdiag.display_trace(last_exe=>0, pxState=>0))
WHERE rownum < 11;
Displays the black box trace of a query execution after the Parallel Query slave starts
dbms_pqdiag.display_trace_local(
topnrows IN NUMBER DEFAULT 0,
pxstate IN NUMBER DEFAULT 0,
last_exe IN NUMBER DEFAULT 1)
RETURN sys.dbms_pqdiag.bbox_col_local PIPELINED;
-- parameters are the same as DISPLAY_TRACE
col trace format a95
SELECT slvpid, qcsid, trace
FROM TABLE(dbms_pqdiag.display_trace(last_exe=>0, pxState=>0))
WHERE rownum < 11;
SELECT * FROM TABLE(dbms_pqdiag.display_trace_local(last_exe=>0, pxState=>2));