SQL Text

The SQL text of the target query

:SQL_TEXT_CLOB
SELECT p., TO_CHAR(p.Signature) Char_Signature, sod.comp_data, s.Min_Inst_ID, NVL(s.Instance_Count, 0) Instance_Count, s.Min_SQL_ID, NVL(s.SQL_ID_Count, 0) SQL_ID_Count FROM DBA_SQL_Patches p LEFT OUTER JOIN (SELECT /+ NO_MERGE / SQL_Patch, MIN(Inst_ID) Min_Inst_ID, COUNT(DISTINCT Inst_ID) Instance_Count, MIN(SQL_ID) Min_SQL_ID, COUNT(DISTINCT SQL_ID) SQL_ID_Count FROM gv$SQL WHERE SQL_Patch IS NOT NULL GROUP BY SQL_Patch ) s ON s.SQL_Patch = p.Name JOIN sys.sqlobj$ so ON so.Name = p.Name AND so.Signature = p.Signature AND so.Category = p.Category AND so.Obj_Type = 3 / SQL patch */ JOIN sys.sqlobj$data sod ON sod.signature = so.signature and sod.category = so.category and sod.obj_type = so.obj_type and sod.plan_id = so.plan_id WHERE (p.Force_Matching = 'YES' AND p.Signature = :A1) OR (p.Force_Matching = 'NO' AND p.Signature = :A2)

:SQL_TEXT_CLOB

SELECT p.*, TO_CHAR(p.Signature) Char_Signature, sod.comp_data, s.Min_Inst_ID, NVL(s.Instance_Count, 0) Instance_Count, s.Min_SQL_ID, NVL(s.SQL_ID_Count, 0) SQL_ID_Count FROM DBA_SQL_Patches p LEFT OUTER JOIN (SELECT /*+ NO_MERGE */ SQL_Patch, MIN(Inst_ID) Min_Inst_ID, COUNT(DISTINCT Inst_ID) Instance_Count, MIN(SQL_ID) Min_SQL_ID, COUNT(DISTINCT SQL_ID) SQL_ID_Count FROM gv$SQL WHERE SQL_Patch IS NOT NULL GROUP BY SQL_Patch ) s ON s.SQL_Patch = p.Name JOIN sys.sqlobj$ so ON so.Name = p.Name AND so.Signature = p.Signature AND so.Category = p.Category AND so.Obj_Type = 3 /* SQL patch */ JOIN sys.sqlobj$data sod ON sod.signature = so.signature and sod.category = so.category and sod.obj_type = so.obj_type and sod.plan_id = so.plan_id WHERE (p.Force_Matching = 'YES' AND p.Signature = :A1) OR (p.Force_Matching = 'NO' AND p.Signature = :A2)

Observations

The system observations

Table Summary

Tables summary information

Table Name	Owner	Partitioned	Degree	Temp	Last Analyzed	Blocks	Global Stats	User Stats	Stale	Columns	Indexes	Index Columns	Allocated Size
SQL$	SYS	NO	1	N	2025-07-29 16:47:46	0	YES	NO	NO	5	2	1	0
SQL$TEXT	SYS	NO	1	N	2025-07-29 16:47:46	0	YES	NO	NO	5	4	2	0
SQLOBJ$	SYS	NO	1	N	2025-07-29 16:47:46		YES	NO	NO	9	3	6
SQLOBJ$AUXDATA	SYS	NO	1	N	2025-07-29 16:47:46	0	YES	NO	NO	39	4	9	0
SQLOBJ$DATA	SYS	NO	1	N	2025-07-29 16:47:47		YES	NO	NO	7	3	4

Table Columns

A list of physical Table attributes

TABLE_NAME: SYS.SQL$

Indexes	Column ID	Column Name	Data Type	Nullable	Last Analyzed	Density	Histogram	Hidden Column	Virtual Column	Global Stats	User Stats
1	1	SIGNATURE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	2	INUSE_FEATURES	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	3	FLAGS	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	4	SPARE1	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	5	SPARE2	CLOB	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO

TABLE_NAME: SYS.SQL$TEXT

Indexes	Column ID	Column Name	Data Type	Nullable	Last Analyzed	Density	Histogram	Hidden Column	Virtual Column	Global Stats	User Stats
1	1	SIGNATURE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	2	SQL_HANDLE	VARCHAR2	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	3	SQL_TEXT	CLOB	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	4	SPARE1	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	5	SPARE2	CLOB	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO

TABLE_NAME: SYS.SQLOBJ$

Indexes	Column ID	Column Name	Data Type	Nullable	Last Analyzed	Density	Histogram	Hidden Column	Virtual Column	Global Stats	User Stats
2	3	OBJ_TYPE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	1	SIGNATURE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	2	CATEGORY	VARCHAR2	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	4	PLAN_ID	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	5	NAME	VARCHAR2	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	6	FLAGS	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	7	LAST_EXECUTED	TIMESTAMP(6)	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	8	SPARE1	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	9	SPARE2	CLOB	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO

TABLE_NAME: SYS.SQLOBJ$AUXDATA

Indexes	Column ID	Column Name	Data Type	Nullable	Last Analyzed	Density	Histogram	Hidden Column	Virtual Column	Global Stats	User Stats
1	1	SIGNATURE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	2	CATEGORY	VARCHAR2	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	3	OBJ_TYPE	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	4	PLAN_ID	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	29	TASK_ID	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	30	TASK_EXEC_NAME	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	31	TASK_OBJ_ID	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	32	TASK_FND_ID	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
1	33	TASK_REC_ID	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	5	DESCRIPTION	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	6	CREATOR	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	7	ORIGIN	NUMBER	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	8	VERSION	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	9	CREATED	TIMESTAMP(6)	N	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	10	LAST_MODIFIED	TIMESTAMP(6)	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	11	LAST_VERIFIED	TIMESTAMP(6)	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	12	PARSE_CPU_TIME	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	13	OPTIMIZER_COST	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	14	MODULE	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	15	ACTION	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	16	PRIORITY	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	17	OPTIMIZER_ENV	RAW	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	18	BIND_DATA	RAW	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	19	PARSING_SCHEMA_NAME	VARCHAR2	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	20	EXECUTIONS	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	21	ELAPSED_TIME	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	22	CPU_TIME	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	23	BUFFER_GETS	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	24	DISK_READS	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	25	DIRECT_WRITES	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	26	ROWS_PROCESSED	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	27	FETCHES	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	28	END_OF_FETCH_COUNT	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	34	FLAGS	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	35	SPARE1	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	36	SPARE2	CLOB	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	37	TASK_CON_DBID	NUMBER	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	38	FOREGROUND_LAST_VERIFIED	TIMESTAMP(6)	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO
0	39	NOTES	CLOB	Y	2025-07-29 16:47:46	0,000000e+00	NONE	NO	NO	YES	NO

TABLE_NAME: SYS.SQLOBJ$DATA

Indexes	Column ID	Column Name	Data Type	Nullable	Last Analyzed	Density	Histogram	Hidden Column	Virtual Column	Global Stats	User Stats
1	1	SIGNATURE	NUMBER	N	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
1	2	CATEGORY	VARCHAR2	N	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
1	3	OBJ_TYPE	NUMBER	N	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
1	4	PLAN_ID	NUMBER	N	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
0	5	COMP_DATA	CLOB	N	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
0	6	SPARE1	NUMBER	Y	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO
0	7	SPARE2	CLOB	Y	2025-07-29 16:47:47	0,000000e+00	NONE	NO	NO	YES	NO

Table Constraints

Table constraints and if they are enabled or not

TABLE_NAME: SYS.SQL$

Constraint Name	Constraint Type	Status	Deferrable	Deferred	Validated	Generated	Last Change
SYS_C00614	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:31
SYS_C00615	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:31
SYS_C00616	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:31

TABLE_NAME: SYS.SQL$TEXT

Constraint Name	Constraint Type	Status	Deferrable	Deferred	Validated	Generated	Last Change
SYS_C00617	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:32
SYS_C00618	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:32
SYS_C00619	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:32

TABLE_NAME: SYS.SQLOBJ$

Constraint Name	Constraint Type	Status	Deferrable	Deferred	Validated	Generated	Last Change	Index Owner	Index Name
SQLOBJ$_PKEY	P	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	USER NAME	2025-07-29 15:57:32	SYS	SQLOBJ$_PKEY
SYS_C00620	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:32
SYS_C00621	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:32

TABLE_NAME: SYS.SQLOBJ$AUXDATA

Constraint Name	Constraint Type	Status	Deferrable	Deferred	Validated	Generated	Last Change
SYS_C00626	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33
SYS_C00627	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33
SYS_C00628	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33
SYS_C00629	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33
SYS_C00630	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33
SYS_C00631	C	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	2025-07-29 15:57:33

TABLE_NAME: SYS.SQLOBJ$DATA

Constraint Name	Constraint Type	Ref Owner	Ref Constraint Name	Delete Rule	Status	Deferrable	Deferred	Validated	Generated	Rely	Last Change	Index Owner	Index Name	Invalid?	View Related
SQLOBJ$DATA_PKEY	P				ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	USER NAME		2025-07-29 15:57:32	SYS	SQLOBJ$DATA_PKEY
SYS_C00623	C				ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME		2025-07-29 15:57:32

Table Partitions

A list of partitions and their physical attributes

Table Modifications

Table insert, updates, deletes and other physical changes

Tables Statistics Versions

CBO Statistics and relevant attributes

Object Name	Owner	Version Type	Save Time	Row Count	Row Change	Percentage Row Change	Sample Size	Block Count	Average Row Length
SQL$	SYS	CURRENT		0	-	-	0	0	0
SQL$	SYS	HISTORY	2025-07-29 16:47:46		-	-
SQL$TEXT	SYS	CURRENT		0	-	-	0	0	0
SQL$TEXT	SYS	HISTORY	2025-07-29 16:47:46		-	-
SQLOBJ$	SYS	CURRENT		0	-	-	0	0	0
SQLOBJ$	SYS	HISTORY	2025-07-29 16:47:46		-	-
SQLOBJ$AUXDATA	SYS	CURRENT		0	-	-	0	0	0
SQLOBJ$AUXDATA	SYS	HISTORY	2025-07-29 16:47:46		-	-
SQLOBJ$DATA	SYS	CURRENT		0	-	-	0	0	0
SQLOBJ$DATA	SYS	HISTORY	2025-07-29 16:47:47		-	-

Gather Table Stats Details

Table Statistics gathering info (DBA_OPTSTAT_OPERATIONS)

Table Extensions

Table Extensions on objects used in SQL statement

VPD Policies

VPD Policies applied on objects used in SQL

DBMS_STATS Table Preferences

The DBMS_STATS Table preferences

Owner	Object Name	Preference Name	Preference Value
SYS	I_SQL$TEXT_PKEY
SYS	I_SQL$_PKEY
SYS	I_SQLOBJ$AUXDATA_PKEY
SYS	I_SQLOBJ$NAME_TYPE
SYS	SQL$
SYS	SQL$TEXT
SYS	SQLOBJ$
SYS	SQLOBJ$AUXDATA
SYS	SQLOBJ$DATA
SYS	SQLOBJ$DATA_PKEY
SYS	SQLOBJ$_PKEY

Index Summary

Indexes summary information

TABLE_NAME: SYS.SQL$

Index Name	Owner	Index Type	Partitioned	Degree	Temporary	Uniqueness	Columns	Num Rows	Sample Size	Sample Size Percentage	Last Analyzed	Distinct Keys	Blevel	Leaf Blocks	Leaf Blocks Per Key	Data Blocks Per Key	Clustering Factor	Global Stats	User Stats	Locked	Stale	Status
I_SQL$_PKEY	SYS	NORMAL	NO	1	N	UNIQUE	1	0	0		2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO		NO	VALID
SYS_IL0000000430C00005$$	SYS	LOB	NO	0	N	UNIQUE	0											NO	NO			VALID

TABLE_NAME: SYS.SQL$TEXT

Index Name	Owner	Index Type	Partitioned	Degree	Temporary	Uniqueness	Columns	Num Rows	Sample Size	Last Analyzed	Distinct Keys	Blevel	Leaf Blocks	Leaf Blocks Per Key	Data Blocks Per Key	Clustering Factor	Global Stats	User Stats	Stale	Status
I_SQL$TEXT_HANDLE	SYS	NORMAL	NO	1	N	UNIQUE	1	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
I_SQL$TEXT_PKEY	SYS	NORMAL	NO	1	N	UNIQUE	1	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
SYS_IL0000000434C00003$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID
SYS_IL0000000434C00005$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID

TABLE_NAME: SYS.SQLOBJ$

Index Name	Owner	Index Type	Partitioned	Degree	Temporary	Uniqueness	Columns	Num Rows	Sample Size	Last Analyzed	Distinct Keys	Blevel	Leaf Blocks	Leaf Blocks Per Key	Data Blocks Per Key	Clustering Factor	Global Stats	User Stats	Stale	Status
I_SQLOBJ$NAME_TYPE	SYS	NORMAL	NO	1	N	UNIQUE	2	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
SQLOBJ$_PKEY	SYS	IOT - TOP	NO	1	N	UNIQUE	4	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
SYS_IL0000000441C00009$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID

TABLE_NAME: SYS.SQLOBJ$AUXDATA

Index Name	Owner	Index Type	Partitioned	Degree	Temporary	Uniqueness	Columns	Num Rows	Sample Size	Last Analyzed	Distinct Keys	Blevel	Leaf Blocks	Leaf Blocks Per Key	Data Blocks Per Key	Clustering Factor	Global Stats	User Stats	Stale	Status
I_SQLOBJ$AUXDATA_PKEY	SYS	NORMAL	NO	1	N	UNIQUE	4	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
I_SQLOBJ$AUXDATA_TASK	SYS	NORMAL	NO	1	N	NONUNIQUE	5	0	0	2025-07-29 16:47:46	0	0	0	0	0	0	YES	NO	NO	VALID
SYS_IL0000000456C00036$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID
SYS_IL0000000456C00039$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID

TABLE_NAME: SYS.SQLOBJ$DATA

Index Name	Owner	Index Type	Partitioned	Degree	Temporary	Uniqueness	Columns	Num Rows	Sample Size	Last Analyzed	Distinct Keys	Blevel	Leaf Blocks	Leaf Blocks Per Key	Data Blocks Per Key	Clustering Factor	Global Stats	User Stats	Stale	Status
SQLOBJ$DATA_PKEY	SYS	IOT - TOP	NO	1	N	UNIQUE	4	0	0	2025-07-29 16:47:47	0	0	0	0	0	0	YES	NO	NO	VALID
SYS_IL0000000446C00005$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID
SYS_IL0000000446C00007$$	SYS	LOB	NO	0	N	UNIQUE	0										NO	NO		VALID

Index Columns

Physical attributes of indexed columns and if they are used in the plan or not

TABLE_NAME: SYS.SQL$

Used?	Index Name	Index Owner	Column Position	Column ID	Column Name	Desc/ Asc	Num Nulls	Sample Size	Num Distinct	Low Value	High Value	Last Analyzed	Average Column Length	Density	Num Buckets	Histogram	Global Stats?	User Stats?
N	I_SQL$_PKEY	SYS	1	1	SIGNATURE	ASC	0		0			2025-07-29 16:47:46	0	0,000000e+00	0	NONE	YES	NO

TABLE_NAME: SYS.SQL$TEXT

Used?	Index Name	Index Owner	Column Position	Column ID	Column Name	Desc/ Asc	Num Nulls	Sample Size	Num Distinct	Low Value	High Value	Last Analyzed	Average Column Length	Density	Num Buckets	Histogram	Global Stats?	User Stats?
N	I_SQL$TEXT_HANDLE	SYS	1	2	SQL_HANDLE	ASC	0		0			2025-07-29 16:47:46	0	0,000000e+00	0	NONE	YES	NO
N	I_SQL$TEXT_PKEY	SYS	1	1	SIGNATURE	ASC	0		0			2025-07-29 16:47:46	0	0,000000e+00	0	NONE	YES	NO

TABLE_NAME: SYS.SQLOBJ$

Used?	Index Name	Index Owner	Column Position	Column ID	Column Name	Desc/ Asc	Last Analyzed	Density	Histogram	Global Stats?	User Stats?
N	I_SQLOBJ$NAME_TYPE	SYS	1	5	NAME	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$NAME_TYPE	SYS	2	3	OBJ_TYPE	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	SQLOBJ$_PKEY	SYS	1	1	SIGNATURE	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	SQLOBJ$_PKEY	SYS	2	2	CATEGORY	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	SQLOBJ$_PKEY	SYS	3	3	OBJ_TYPE	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	SQLOBJ$_PKEY	SYS	4	4	PLAN_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO

TABLE_NAME: SYS.SQLOBJ$AUXDATA

Used?	Index Name	Index Owner	Column Position	Column ID	Column Name	Desc/ Asc	Last Analyzed	Density	Histogram	Global Stats?	User Stats?
N	I_SQLOBJ$AUXDATA_PKEY	SYS	1	1	SIGNATURE	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_PKEY	SYS	2	2	CATEGORY	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_PKEY	SYS	3	3	OBJ_TYPE	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_PKEY	SYS	4	4	PLAN_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_TASK	SYS	1	29	TASK_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_TASK	SYS	2	30	TASK_EXEC_NAME	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_TASK	SYS	3	31	TASK_OBJ_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_TASK	SYS	4	32	TASK_FND_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO
N	I_SQLOBJ$AUXDATA_TASK	SYS	5	33	TASK_REC_ID	ASC	2025-07-29 16:47:46	0,000000e+00	NONE	YES	NO

TABLE_NAME: SYS.SQLOBJ$DATA

Used?	Index Name	Index Owner	Column Position	Column ID	Column Name	Desc/ Asc	Last Analyzed	Density	Histogram	Global Stats?	User Stats?
N	SQLOBJ$DATA_PKEY	SYS	1	1	SIGNATURE	ASC	2025-07-29 16:47:47	0,000000e+00	NONE	YES	NO
N	SQLOBJ$DATA_PKEY	SYS	2	2	CATEGORY	ASC	2025-07-29 16:47:47	0,000000e+00	NONE	YES	NO
N	SQLOBJ$DATA_PKEY	SYS	3	3	OBJ_TYPE	ASC	2025-07-29 16:47:47	0,000000e+00	NONE	YES	NO
N	SQLOBJ$DATA_PKEY	SYS	4	4	PLAN_ID	ASC	2025-07-29 16:47:47	0,000000e+00	NONE	YES	NO

Index Partitions

Partition information for partitioned indexes

Indexes Statistics Versions

CBO Statistics and relevant attributes

Table Name	Table Owner	Index Name	Index Owner	Version Type	Save Time	Last Analyzed	Row Count	Sample Size	Distinct Keys	BLevel	Leaf Blocks	Avg Leaf BLKS per key	Avg Data BLKS per key	Clustering Factor
SQL$TEXT	SYS	I_SQL$TEXT_HANDLE	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQL$TEXT	SYS	I_SQL$TEXT_HANDLE	SYS	HISTORY	29.07.25 16:47:46,741610 -07:00
SQL$TEXT	SYS	I_SQL$TEXT_PKEY	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQL$TEXT	SYS	I_SQL$TEXT_PKEY	SYS	HISTORY	29.07.25 16:47:46,748516 -07:00
SQL$	SYS	I_SQL$_PKEY	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQL$	SYS	I_SQL$_PKEY	SYS	HISTORY	29.07.25 16:47:46,712385 -07:00
SQLOBJ$AUXDATA	SYS	I_SQLOBJ$AUXDATA_PKEY	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQLOBJ$AUXDATA	SYS	I_SQLOBJ$AUXDATA_PKEY	SYS	HISTORY	29.07.25 16:47:46,934495 -07:00
SQLOBJ$AUXDATA	SYS	I_SQLOBJ$AUXDATA_TASK	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQLOBJ$AUXDATA	SYS	I_SQLOBJ$AUXDATA_TASK	SYS	HISTORY	29.07.25 16:47:46,926797 -07:00
SQLOBJ$	SYS	I_SQLOBJ$NAME_TYPE	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQLOBJ$	SYS	I_SQLOBJ$NAME_TYPE	SYS	HISTORY	29.07.25 16:47:46,864979 -07:00
SQLOBJ$DATA	SYS	SQLOBJ$DATA_PKEY	SYS	CURRENT		2025-07-29 16:47:47	0	0	0	0	0	0	0	0
SQLOBJ$DATA	SYS	SQLOBJ$DATA_PKEY	SYS	HISTORY	29.07.25 16:47:47,051379 -07:00
SQLOBJ$	SYS	SQLOBJ$_PKEY	SYS	CURRENT		2025-07-29 16:47:46	0	0	0	0	0	0	0	0
SQLOBJ$	SYS	SQLOBJ$_PKEY	SYS	HISTORY	29.07.25 16:47:46,871947 -07:00
SQL$	SYS	SYS_IL0000000430C00005$$	SYS	CURRENT
SQL$TEXT	SYS	SYS_IL0000000434C00003$$	SYS	CURRENT
SQL$TEXT	SYS	SYS_IL0000000434C00005$$	SYS	CURRENT
SQLOBJ$	SYS	SYS_IL0000000441C00009$$	SYS	CURRENT
SQLOBJ$DATA	SYS	SYS_IL0000000446C00005$$	SYS	CURRENT
SQLOBJ$DATA	SYS	SYS_IL0000000446C00007$$	SYS	CURRENT
SQLOBJ$AUXDATA	SYS	SYS_IL0000000456C00036$$	SYS	CURRENT
SQLOBJ$AUXDATA	SYS	SYS_IL0000000456C00039$$	SYS	CURRENT

SQL Object Dependency

Dependency description between objects

OWNER	Object Name	Object Type	Last DDL Time
SYS	DBA_SQL_PATCHES	VIEW	2025-07-29 16:30:18
SYS	GV_$SQL	VIEW	2025-07-29 16:28:41
SYS	SQL$	TABLE	2025-07-29 15:57:31
SYS	SQL$TEXT	TABLE	2025-07-29 15:57:32
SYS	SQLOBJ$	TABLE	2025-07-29 16:41:33
SYS	SQLOBJ$AUXDATA	TABLE	2025-07-29 15:57:33
SYS	SQLOBJ$DATA	TABLE	2025-07-29 15:57:32
PUBLIC	DBA_SQL_PATCHES	SYNONYM	2025-07-29 16:30:18
PUBLIC	GV$SQL	SYNONYM	2025-07-29 16:28:41

View/Synonym Dependency Hierarchy

View/Synonym Dependency Hierarchy (GV$OBJECT_DEPENDENCY/DBA_DEPENDENCIES) Fusion Apps

Index Metadata

Indexes Metadata

  CREATE UNIQUE INDEX "SYS"."I_SQL$_PKEY" ON "SYS"."SQL$" ("SIGNATURE")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."I_SQL$TEXT_HANDLE" ON "SYS"."SQL$TEXT" ("SQL_HANDLE")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."I_SQL$TEXT_PKEY" ON "SYS"."SQL$TEXT" ("SIGNATURE")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."I_SQLOBJ$NAME_TYPE" ON "SYS"."SQLOBJ$" ("NAME", "OBJ_TYPE")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."SQLOBJ$_PKEY" ON "SYS"."SQLOBJ$" ("SIGNATURE", "CATEGORY", "OBJ_TYPE", "PLAN_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."I_SQLOBJ$AUXDATA_PKEY" ON "SYS"."SQLOBJ$AUXDATA" ("SIGNATURE", "CATEGORY", "OBJ_TYPE", "PLAN_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  TABLESPACE "SYSAUX" ;

  CREATE INDEX "SYS"."I_SQLOBJ$AUXDATA_TASK" ON "SYS"."SQLOBJ$AUXDATA" ("TASK_ID", "TASK_EXEC_NAME", "TASK_OBJ_ID", "TASK_FND_ID", "TASK_REC_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  TABLESPACE "SYSAUX" ;

  CREATE UNIQUE INDEX "SYS"."SQLOBJ$DATA_PKEY" ON "SYS"."SQLOBJ$DATA" ("SIGNATURE", "CATEGORY", "OBJ_TYPE", "PLAN_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSAUX" ;

View Metadata

Views Metadata

SQL History

Historical execution information in chronological order

SQL Undo Usage

I/O Type Usage in SQL. (includes Undo)

Current Plans Summary

Execution Plans performance metrics for while still in memory.Plans ordered by average elapsed time.

ROWNUM	PHV	Average Elapsed	Average CPU	Average IO	Average Concurrency	Average Application	Average Cluster	Average PLSQL	Average JAVA	Average Buffer Gets	Average Disk Reads	Average Direct Writes	Average Rows Processed	Total Executions	Min Optimizer Cost	Max Optimizer Cost	Min Optimizer Env HV	Max Optimizer Env HV	First Load Time	Last Load Time	Last Active Time
1	3462993574	0,006	0,005	0,000	0,000	0,000	0,000	0,000	0,000	72	0	0	0	18	1		3734797985		2025-08-07/06:26:46	2025-08-07/06:36:00	2025-08-07 07:50:23

Historical Plans Summary

Execution Plans performance metrics for SQL from memory and AWR. Plans ordered by average elapsed time.

Historical SQL Stats - DELTA

Execution Plans performance metrics for SQL from memory and AWR. Plans ordered by average elapsed time.

Historical SQL Stats - TOTAL

Execution Plans performance metrics for SQL from memory and AWR. Plans ordered by average elapsed time.

Last Execution Plan

The execution plan found in memory


Inst: 1   Child: 0   Plan hash value: 3462993574

----------------------------------------------------------------------------------------------------------------------------------------------
| Id  | exeOrd| Operation                        | Name                  | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------------------------
|   0 |  N/A  | SELECT STATEMENT                 |                       |        |       |     1 (100)|          |       |       |          |
|*  1 |  N/A  |  HASH JOIN OUTER                 |                       |      1 |  3440 |     1 (100)| 00:00:01 |   681K|   681K|  195K (0)|
|   2 |  N/A  |   NESTED LOOPS                   |                       |      1 |  3327 |     0   (0)|          |       |       |          |
|   3 |  N/A  |    NESTED LOOPS                  |                       |      1 |  3327 |     0   (0)|          |       |       |          |
|   4 |  N/A  |     NESTED LOOPS                 |                       |      1 |  2826 |     0   (0)|          |       |       |          |
|   5 |  N/A  |      NESTED LOOPS                |                       |      1 |   811 |     0   (0)|          |       |       |          |
|   6 |  N/A  |       NESTED LOOPS               |                       |      1 |   785 |     0   (0)|          |       |       |          |
|   7 |  N/A  |        NESTED LOOPS              |                       |      1 |   342 |     0   (0)|          |       |       |          |
|*  8 |  N/A  |         INDEX FULL SCAN          | I_SQLOBJ$NAME_TYPE    |      1 |   171 |     0   (0)|          |       |       |          |
|*  9 |  N/A  |         INDEX RANGE SCAN         | SQLOBJ$_PKEY          |      1 |   171 |     0   (0)|          |       |       |          |
|* 10 |  N/A  |        INDEX UNIQUE SCAN         | SQLOBJ$DATA_PKEY      |      1 |   443 |     0   (0)|          |       |       |          |
|* 11 |  N/A  |       TABLE ACCESS BY INDEX ROWID| SQL$                  |      1 |    26 |     0   (0)|          |       |       |          |
|* 12 |  N/A  |        INDEX UNIQUE SCAN         | I_SQL$_PKEY           |      1 |       |     0   (0)|          |       |       |          |
|  13 |  N/A  |      TABLE ACCESS BY INDEX ROWID | SQL$TEXT              |      1 |  2015 |     0   (0)|          |       |       |          |
|* 14 |  N/A  |       INDEX UNIQUE SCAN          | I_SQL$TEXT_PKEY       |      1 |       |     0   (0)|          |       |       |          |
|* 15 |  N/A  |     INDEX RANGE SCAN             | I_SQLOBJ$AUXDATA_PKEY |      1 |       |     0   (0)|          |       |       |          |
|  16 |  N/A  |    TABLE ACCESS BY INDEX ROWID   | SQLOBJ$AUXDATA        |      1 |   501 |     0   (0)|          |       |       |          |
|  17 |  N/A  |   VIEW                           |                       |      1 |   113 |     1 (100)| 00:00:01 |       |       |          |
|  18 |  N/A  |    HASH GROUP BY                 |                       |      1 |   100 |     1 (100)| 00:00:01 |   839K|   839K|          |
|* 19 |  N/A  |     FIXED TABLE FULL             | X$KGLCURSOR_CHILD     |      1 |   100 |     0   (0)|          |       |       |          |
----------------------------------------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):


   1 - SEL$BB855F6A
   8 - SEL$BB855F6A / "SO"@"SEL$7"
   9 - SEL$BB855F6A / "SO"@"SEL$2"
  10 - SEL$BB855F6A / "SOD"@"SEL$8"
  11 - SEL$BB855F6A / "SQ"@"SEL$2"
  12 - SEL$BB855F6A / "SQ"@"SEL$2"
  13 - SEL$BB855F6A / "ST"@"SEL$2"
  14 - SEL$BB855F6A / "ST"@"SEL$2"
  15 - SEL$BB855F6A / "AD"@"SEL$2"
  16 - SEL$BB855F6A / "AD"@"SEL$2"
  17 - SEL$0098CF9D / "S"@"SEL$1"
  18 - SEL$0098CF9D
  19 - SEL$0098CF9D / "X$KGLCURSOR_CHILD"@"SEL$6"

Outline Data


  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('23.1.0')
      DB_VERSION('23.1.0')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$0098CF9D")
      MERGE(@"SEL$F5B21678" >"SEL$3")
      OUTLINE_LEAF(@"SEL$BB855F6A")
      MERGE(@"SEL$22F20E7B" >"SEL$9")
      OUTLINE(@"SEL$3")
      OUTLINE(@"SEL$F5B21678")
      MERGE(@"SEL$ABDE6DFF" >"SEL$4")
      OUTLINE(@"SEL$9")
      OUTLINE(@"SEL$22F20E7B")
      MERGE(@"SEL$1D5803B5" >"SEL$8")
      OUTLINE(@"SEL$4")
      OUTLINE(@"SEL$ABDE6DFF")
      MERGE(@"SEL$6" >"SEL$5")
      OUTLINE(@"SEL$8")
      OUTLINE(@"SEL$1D5803B5")
      MERGE(@"SEL$8CFDDA53" >"SEL$FDEC9754")
      OUTLINE(@"SEL$5")
      OUTLINE(@"SEL$6")
      OUTLINE(@"SEL$FDEC9754")
      ANSI_REARCH(@"SEL$7")
      OUTLINE(@"SEL$8CFDDA53")
      MERGE(@"SEL$2" >"SEL$8812AA4E")
      OUTLINE(@"SEL$7")
      OUTLINE(@"SEL$8812AA4E")
      ANSI_REARCH(@"SEL$1")
      OUTLINE(@"SEL$2")
      OUTLINE(@"SEL$1")
      INDEX(@"SEL$BB855F6A" "SO"@"SEL$7" ("SQLOBJ$"."NAME" "SQLOBJ$"."OBJ_TYPE"))
      INDEX(@"SEL$BB855F6A" "SO"@"SEL$2" ("SQLOBJ$"."SIGNATURE" "SQLOBJ$"."CATEGORY" "SQLOBJ$"."OBJ_TYPE" "SQLOBJ$"."PLAN_ID"))
      INDEX(@"SEL$BB855F6A" "SOD"@"SEL$8" ("SQLOBJ$DATA"."SIGNATURE" "SQLOBJ$DATA"."CATEGORY" "SQLOBJ$DATA"."OBJ_TYPE"
              "SQLOBJ$DATA"."PLAN_ID"))
      INDEX_RS_ASC(@"SEL$BB855F6A" "SQ"@"SEL$2" ("SQL$"."SIGNATURE"))
      INDEX_RS_ASC(@"SEL$BB855F6A" "ST"@"SEL$2" ("SQL$TEXT"."SIGNATURE"))
      INDEX(@"SEL$BB855F6A" "AD"@"SEL$2" ("SQLOBJ$AUXDATA"."SIGNATURE" "SQLOBJ$AUXDATA"."CATEGORY" "SQLOBJ$AUXDATA"."OBJ_TYPE"
              "SQLOBJ$AUXDATA"."PLAN_ID"))
      NO_ACCESS(@"SEL$BB855F6A" "S"@"SEL$1")
      LEADING(@"SEL$BB855F6A" "SO"@"SEL$7" "SO"@"SEL$2" "SOD"@"SEL$8" "SQ"@"SEL$2" "ST"@"SEL$2" "AD"@"SEL$2" "S"@"SEL$1")
      USE_NL(@"SEL$BB855F6A" "SO"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "SOD"@"SEL$8")
      USE_NL(@"SEL$BB855F6A" "SQ"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "ST"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "AD"@"SEL$2")
      NLJ_BATCHING(@"SEL$BB855F6A" "AD"@"SEL$2")
      USE_HASH(@"SEL$BB855F6A" "S"@"SEL$1")
      FULL(@"SEL$0098CF9D" "X$KGLCURSOR_CHILD"@"SEL$6")
      USE_HASH_AGGREGATION(@"SEL$0098CF9D" GROUP_BY)
      END_OUTLINE_DATA
  */

Peeked Binds (identified by position):


   1 - (VARCHAR2(30), CSID=873): '1319706931548838258'
   2 - (VARCHAR2(30), CSID=873): '12970587569150853377'

Predicate Information (identified by operation id):


   1 - access("S"."SQL_PATCH"="SO"."NAME")
   8 - access("SO"."OBJ_TYPE"=3)
       filter("SO"."OBJ_TYPE"=3)
   9 - access("SO"."SIGNATURE"="SO"."SIGNATURE" AND "SO"."CATEGORY"="SO"."CATEGORY" AND "SO"."OBJ_TYPE"=3)
       filter((INTERNAL_FUNCTION("SO"."SIGNATURE") AND "SO"."NAME"="SO"."NAME"))
  10 - access("SOD"."SIGNATURE"="SO"."SIGNATURE" AND "SOD"."CATEGORY"="SO"."CATEGORY" AND "SOD"."OBJ_TYPE"=3 AND
              "SOD"."PLAN_ID"="SO"."PLAN_ID")
  11 - filter(((DECODE(BITAND("SQ"."FLAGS",1),1,'YES','NO')='YES' AND "SO"."SIGNATURE"=TO_NUMBER(:A1)) OR
              (DECODE(BITAND("SQ"."FLAGS",1),1,'YES','NO')='NO' AND "SO"."SIGNATURE"=TO_NUMBER(:A2))))
  12 - access("SO"."SIGNATURE"="SQ"."SIGNATURE")
  14 - access("SO"."SIGNATURE"="ST"."SIGNATURE")
  15 - access("SO"."SIGNATURE"="AD"."SIGNATURE" AND "SO"."CATEGORY"="AD"."CATEGORY" AND "AD"."OBJ_TYPE"=3)
  19 - filter(("KGLOBTS7" IS NOT NULL AND INTERNAL_FUNCTION("CON_ID")))

Column Projection Information (identified by operation id):


   1 - (#keys=1; rowset=54) "SO"."NAME"[VARCHAR2,128], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128],
       "AD"."TASK_REC_ID"[NUMBER,22], "SO"."FLAGS"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672], "SQ"."FLAGS"[NUMBER,22],
       "ST"."SQL_TEXT"[LOB,4000], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22], "AD"."CREATED"[TIMESTAMP,11],
       "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22], "AD"."TASK_EXEC_NAME"[VARCHAR2,128],
       "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22], "S"."SQL_ID_COUNT"[NUMBER,22], "S"."MIN_INST_ID"[NUMBER,22],
       "S"."INSTANCE_COUNT"[NUMBER,22], "S"."MIN_SQL_ID"[VARCHAR2,13]
   2 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000], "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22],
       "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22],
       "AD"."CREATED"[TIMESTAMP,11], "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22],
       "AD"."TASK_EXEC_NAME"[VARCHAR2,128], "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22],
       "AD"."TASK_REC_ID"[NUMBER,22]
   3 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000], "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22],
       "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22]
   4 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000]
   5 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22]
   6 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672]
   7 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22]
   8 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208]
   9 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22]
  10 - "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22], "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22],
       "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672]
  11 - "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22]
  12 - "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22]
  13 - "ST".ROWID[ROWID,10], "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000]
  14 - "ST".ROWID[ROWID,10], "ST"."SIGNATURE"[NUMBER,22]
  15 - "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22], "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22]
  16 - "AD".ROWID[ROWID,10], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22], "AD"."CREATED"[TIMESTAMP,11],
       "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22], "AD"."TASK_EXEC_NAME"[VARCHAR2,128],
       "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22], "AD"."TASK_REC_ID"[NUMBER,22]
  17 - (rowset=54) "S"."SQL_PATCH"[VARCHAR2,128], "S"."MIN_INST_ID"[NUMBER,22], "S"."INSTANCE_COUNT"[NUMBER,22],
       "S"."MIN_SQL_ID"[VARCHAR2,13], "S"."SQL_ID_COUNT"[NUMBER,22]
  18 - (#keys=1; rowset=54) "KGLOBTS7"[VARCHAR2,128], COUNT(DISTINCT "KGLOBT03")[22], COUNT(DISTINCT "INST_ID")[22],
       MIN("KGLOBT03")[13], MIN("INST_ID")[22]
  19 - "INST_ID"[NUMBER,22], "CON_ID"[NUMBER,22], "KGLOBT03"[VARCHAR2,13], "KGLOBTS7"[VARCHAR2,128]

Hint Report (identified by operation id / Query Block Name / Object Alias):

Total hints for statement: 1
---------------------------------------------------------------------------

  18 -  SEL$0098CF9D
           -  NO_MERGE

Note

   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level

Query Block Registry:


  SEL$1 (PARSER)
    SEL$8812AA4E (VIEW ANSI REARCHITECTURE SEL$1)
      SEL$8CFDDA53 (VIEW MERGE SEL$8812AA4E ; SEL$2)
  SEL$2 (PARSER)
  SEL$3 (PARSER)
    SEL$0098CF9D (VIEW MERGE SEL$3 ; SEL$F5B21678) [FINAL]
  SEL$4 (PARSER)
    SEL$F5B21678 (VIEW MERGE SEL$4 ; SEL$ABDE6DFF)
  SEL$5 (PARSER)
    SEL$ABDE6DFF (VIEW MERGE SEL$5 ; SEL$6)
  SEL$6 (PARSER)
  SEL$7 (PARSER)
    SEL$FDEC9754 (QUERY ANSI REARCHITECTURE SEL$7 ; SEL$8812AA4E)
      SEL$1D5803B5 (VIEW MERGE SEL$FDEC9754 ; SEL$8CFDDA53)
  SEL$8 (PARSER)
    SEL$22F20E7B (VIEW MERGE SEL$8 ; SEL$1D5803B5)
  SEL$9 (PARSER)
    SEL$BB855F6A (VIEW MERGE SEL$9 ; SEL$22F20E7B) [FINAL]

All Execution Plans

All execution plans from non-memory sources


Inst: 1   Child: 0   Plan hash value: 3462993574

----------------------------------------------------------------------------------------------------------------------------------------------
| Id  | exeOrd| Operation                        | Name                  | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |  OMem |  1Mem |  O/1/M   |
----------------------------------------------------------------------------------------------------------------------------------------------
|   0 |  N/A  | SELECT STATEMENT                 |                       |        |       |     1 (100)|          |       |       |          |
|*  1 |  N/A  |  HASH JOIN OUTER                 |                       |      1 |  3440 |     1 (100)| 00:00:01 |   681K|   681K|    15/0/0|
|   2 |  N/A  |   NESTED LOOPS                   |                       |      1 |  3327 |     0   (0)|          |       |       |          |
|   3 |  N/A  |    NESTED LOOPS                  |                       |      1 |  3327 |     0   (0)|          |       |       |          |
|   4 |  N/A  |     NESTED LOOPS                 |                       |      1 |  2826 |     0   (0)|          |       |       |          |
|   5 |  N/A  |      NESTED LOOPS                |                       |      1 |   811 |     0   (0)|          |       |       |          |
|   6 |  N/A  |       NESTED LOOPS               |                       |      1 |   785 |     0   (0)|          |       |       |          |
|   7 |  N/A  |        NESTED LOOPS              |                       |      1 |   342 |     0   (0)|          |       |       |          |
|*  8 |  N/A  |         INDEX FULL SCAN          | I_SQLOBJ$NAME_TYPE    |      1 |   171 |     0   (0)|          |       |       |          |
|*  9 |  N/A  |         INDEX RANGE SCAN         | SQLOBJ$_PKEY          |      1 |   171 |     0   (0)|          |       |       |          |
|* 10 |  N/A  |        INDEX UNIQUE SCAN         | SQLOBJ$DATA_PKEY      |      1 |   443 |     0   (0)|          |       |       |          |
|* 11 |  N/A  |       TABLE ACCESS BY INDEX ROWID| SQL$                  |      1 |    26 |     0   (0)|          |       |       |          |
|* 12 |  N/A  |        INDEX UNIQUE SCAN         | I_SQL$_PKEY           |      1 |       |     0   (0)|          |       |       |          |
|  13 |  N/A  |      TABLE ACCESS BY INDEX ROWID | SQL$TEXT              |      1 |  2015 |     0   (0)|          |       |       |          |
|* 14 |  N/A  |       INDEX UNIQUE SCAN          | I_SQL$TEXT_PKEY       |      1 |       |     0   (0)|          |       |       |          |
|* 15 |  N/A  |     INDEX RANGE SCAN             | I_SQLOBJ$AUXDATA_PKEY |      1 |       |     0   (0)|          |       |       |          |
|  16 |  N/A  |    TABLE ACCESS BY INDEX ROWID   | SQLOBJ$AUXDATA        |      1 |   501 |     0   (0)|          |       |       |          |
|  17 |  N/A  |   VIEW                           |                       |      1 |   113 |     1 (100)| 00:00:01 |       |       |          |
|  18 |  N/A  |    HASH GROUP BY                 |                       |      1 |   100 |     1 (100)| 00:00:01 |   839K|   839K|          |
|* 19 |  N/A  |     FIXED TABLE FULL             | X$KGLCURSOR_CHILD     |      1 |   100 |     0   (0)|          |       |       |          |
----------------------------------------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):


   1 - SEL$BB855F6A
   8 - SEL$BB855F6A / "SO"@"SEL$7"
   9 - SEL$BB855F6A / "SO"@"SEL$2"
  10 - SEL$BB855F6A / "SOD"@"SEL$8"
  11 - SEL$BB855F6A / "SQ"@"SEL$2"
  12 - SEL$BB855F6A / "SQ"@"SEL$2"
  13 - SEL$BB855F6A / "ST"@"SEL$2"
  14 - SEL$BB855F6A / "ST"@"SEL$2"
  15 - SEL$BB855F6A / "AD"@"SEL$2"
  16 - SEL$BB855F6A / "AD"@"SEL$2"
  17 - SEL$0098CF9D / "S"@"SEL$1"
  18 - SEL$0098CF9D
  19 - SEL$0098CF9D / "X$KGLCURSOR_CHILD"@"SEL$6"

Outline Data


  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('23.1.0')
      DB_VERSION('23.1.0')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$0098CF9D")
      MERGE(@"SEL$F5B21678" >"SEL$3")
      OUTLINE_LEAF(@"SEL$BB855F6A")
      MERGE(@"SEL$22F20E7B" >"SEL$9")
      OUTLINE(@"SEL$3")
      OUTLINE(@"SEL$F5B21678")
      MERGE(@"SEL$ABDE6DFF" >"SEL$4")
      OUTLINE(@"SEL$9")
      OUTLINE(@"SEL$22F20E7B")
      MERGE(@"SEL$1D5803B5" >"SEL$8")
      OUTLINE(@"SEL$4")
      OUTLINE(@"SEL$ABDE6DFF")
      MERGE(@"SEL$6" >"SEL$5")
      OUTLINE(@"SEL$8")
      OUTLINE(@"SEL$1D5803B5")
      MERGE(@"SEL$8CFDDA53" >"SEL$FDEC9754")
      OUTLINE(@"SEL$5")
      OUTLINE(@"SEL$6")
      OUTLINE(@"SEL$FDEC9754")
      ANSI_REARCH(@"SEL$7")
      OUTLINE(@"SEL$8CFDDA53")
      MERGE(@"SEL$2" >"SEL$8812AA4E")
      OUTLINE(@"SEL$7")
      OUTLINE(@"SEL$8812AA4E")
      ANSI_REARCH(@"SEL$1")
      OUTLINE(@"SEL$2")
      OUTLINE(@"SEL$1")
      INDEX(@"SEL$BB855F6A" "SO"@"SEL$7" ("SQLOBJ$"."NAME" "SQLOBJ$"."OBJ_TYPE"))
      INDEX(@"SEL$BB855F6A" "SO"@"SEL$2" ("SQLOBJ$"."SIGNATURE" "SQLOBJ$"."CATEGORY" "SQLOBJ$"."OBJ_TYPE" "SQLOBJ$"."PLAN_ID"))
      INDEX(@"SEL$BB855F6A" "SOD"@"SEL$8" ("SQLOBJ$DATA"."SIGNATURE" "SQLOBJ$DATA"."CATEGORY" "SQLOBJ$DATA"."OBJ_TYPE"
              "SQLOBJ$DATA"."PLAN_ID"))
      INDEX_RS_ASC(@"SEL$BB855F6A" "SQ"@"SEL$2" ("SQL$"."SIGNATURE"))
      INDEX_RS_ASC(@"SEL$BB855F6A" "ST"@"SEL$2" ("SQL$TEXT"."SIGNATURE"))
      INDEX(@"SEL$BB855F6A" "AD"@"SEL$2" ("SQLOBJ$AUXDATA"."SIGNATURE" "SQLOBJ$AUXDATA"."CATEGORY" "SQLOBJ$AUXDATA"."OBJ_TYPE"
              "SQLOBJ$AUXDATA"."PLAN_ID"))
      NO_ACCESS(@"SEL$BB855F6A" "S"@"SEL$1")
      LEADING(@"SEL$BB855F6A" "SO"@"SEL$7" "SO"@"SEL$2" "SOD"@"SEL$8" "SQ"@"SEL$2" "ST"@"SEL$2" "AD"@"SEL$2" "S"@"SEL$1")
      USE_NL(@"SEL$BB855F6A" "SO"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "SOD"@"SEL$8")
      USE_NL(@"SEL$BB855F6A" "SQ"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "ST"@"SEL$2")
      USE_NL(@"SEL$BB855F6A" "AD"@"SEL$2")
      NLJ_BATCHING(@"SEL$BB855F6A" "AD"@"SEL$2")
      USE_HASH(@"SEL$BB855F6A" "S"@"SEL$1")
      FULL(@"SEL$0098CF9D" "X$KGLCURSOR_CHILD"@"SEL$6")
      USE_HASH_AGGREGATION(@"SEL$0098CF9D" GROUP_BY)
      END_OUTLINE_DATA
  */

Peeked Binds (identified by position):


   1 - (VARCHAR2(30), CSID=873): '1319706931548838258'
   2 - (VARCHAR2(30), CSID=873): '12970587569150853377'

Predicate Information (identified by operation id):


   1 - access("S"."SQL_PATCH"="SO"."NAME")
   8 - access("SO"."OBJ_TYPE"=3)
       filter("SO"."OBJ_TYPE"=3)
   9 - access("SO"."SIGNATURE"="SO"."SIGNATURE" AND "SO"."CATEGORY"="SO"."CATEGORY" AND "SO"."OBJ_TYPE"=3)
       filter((INTERNAL_FUNCTION("SO"."SIGNATURE") AND "SO"."NAME"="SO"."NAME"))
  10 - access("SOD"."SIGNATURE"="SO"."SIGNATURE" AND "SOD"."CATEGORY"="SO"."CATEGORY" AND "SOD"."OBJ_TYPE"=3 AND
              "SOD"."PLAN_ID"="SO"."PLAN_ID")
  11 - filter(((DECODE(BITAND("SQ"."FLAGS",1),1,'YES','NO')='YES' AND "SO"."SIGNATURE"=TO_NUMBER(:A1)) OR
              (DECODE(BITAND("SQ"."FLAGS",1),1,'YES','NO')='NO' AND "SO"."SIGNATURE"=TO_NUMBER(:A2))))
  12 - access("SO"."SIGNATURE"="SQ"."SIGNATURE")
  14 - access("SO"."SIGNATURE"="ST"."SIGNATURE")
  15 - access("SO"."SIGNATURE"="AD"."SIGNATURE" AND "SO"."CATEGORY"="AD"."CATEGORY" AND "AD"."OBJ_TYPE"=3)
  19 - filter(("KGLOBTS7" IS NOT NULL AND INTERNAL_FUNCTION("CON_ID")))

Column Projection Information (identified by operation id):


   1 - (#keys=1; rowset=54) "SO"."NAME"[VARCHAR2,128], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128],
       "AD"."TASK_REC_ID"[NUMBER,22], "SO"."FLAGS"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672], "SQ"."FLAGS"[NUMBER,22],
       "ST"."SQL_TEXT"[LOB,4000], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22], "AD"."CREATED"[TIMESTAMP,11],
       "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22], "AD"."TASK_EXEC_NAME"[VARCHAR2,128],
       "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22], "S"."SQL_ID_COUNT"[NUMBER,22], "S"."MIN_INST_ID"[NUMBER,22],
       "S"."INSTANCE_COUNT"[NUMBER,22], "S"."MIN_SQL_ID"[VARCHAR2,13]
   2 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000], "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22],
       "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22],
       "AD"."CREATED"[TIMESTAMP,11], "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22],
       "AD"."TASK_EXEC_NAME"[VARCHAR2,128], "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22],
       "AD"."TASK_REC_ID"[NUMBER,22]
   3 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000], "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22],
       "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22]
   4 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22], "ST".ROWID[ROWID,10],
       "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000]
   5 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672],
       "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22]
   6 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22], "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22],
       "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22], "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672]
   7 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208], "SO".ROWID[ROWID,208],
       "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22], "PLAN_ID"[NUMBER,22],
       "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22]
   8 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "SO"."PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO".ROWID[ROWID,208]
   9 - "SO".ROWID[ROWID,208], "SO"."SIGNATURE"[NUMBER,22], "SO"."CATEGORY"[VARCHAR2,128], "SO"."OBJ_TYPE"[NUMBER,22],
       "PLAN_ID"[NUMBER,22], "SO"."NAME"[VARCHAR2,128], "SO"."FLAGS"[NUMBER,22]
  10 - "SOD".ROWID[ROWID,208], "SOD"."SIGNATURE"[NUMBER,22], "SOD"."CATEGORY"[VARCHAR2,128], "SOD"."OBJ_TYPE"[NUMBER,22],
       "SOD"."PLAN_ID"[NUMBER,22], "SOD"."COMP_DATA"[LOB,672]
  11 - "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22], "SQ"."FLAGS"[NUMBER,22]
  12 - "SQ".ROWID[ROWID,10], "SQ"."SIGNATURE"[NUMBER,22]
  13 - "ST".ROWID[ROWID,10], "ST"."SIGNATURE"[NUMBER,22], "ST"."SQL_TEXT"[LOB,4000]
  14 - "ST".ROWID[ROWID,10], "ST"."SIGNATURE"[NUMBER,22]
  15 - "AD".ROWID[ROWID,10], "AD"."SIGNATURE"[NUMBER,22], "AD"."CATEGORY"[VARCHAR2,128], "AD"."OBJ_TYPE"[NUMBER,22]
  16 - "AD".ROWID[ROWID,10], "AD"."DESCRIPTION"[VARCHAR2,500], "AD"."ORIGIN"[NUMBER,22], "AD"."CREATED"[TIMESTAMP,11],
       "AD"."LAST_MODIFIED"[TIMESTAMP,11], "AD"."TASK_ID"[NUMBER,22], "AD"."TASK_EXEC_NAME"[VARCHAR2,128],
       "AD"."TASK_OBJ_ID"[NUMBER,22], "AD"."TASK_FND_ID"[NUMBER,22], "AD"."TASK_REC_ID"[NUMBER,22]
  17 - (rowset=54) "S"."SQL_PATCH"[VARCHAR2,128], "S"."MIN_INST_ID"[NUMBER,22], "S"."INSTANCE_COUNT"[NUMBER,22],
       "S"."MIN_SQL_ID"[VARCHAR2,13], "S"."SQL_ID_COUNT"[NUMBER,22]
  18 - (#keys=1; rowset=54) "KGLOBTS7"[VARCHAR2,128], COUNT(DISTINCT "KGLOBT03")[22], COUNT(DISTINCT "INST_ID")[22],
       MIN("KGLOBT03")[13], MIN("INST_ID")[22]
  19 - "INST_ID"[NUMBER,22], "CON_ID"[NUMBER,22], "KGLOBT03"[VARCHAR2,13], "KGLOBTS7"[VARCHAR2,128]

Hint Report (identified by operation id / Query Block Name / Object Alias):

Total hints for statement: 1
---------------------------------------------------------------------------

  18 -  SEL$0098CF9D
           -  NO_MERGE

Note

   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level

Query Block Registry:


  SEL$1 (PARSER)
    SEL$8812AA4E (VIEW ANSI REARCHITECTURE SEL$1)
      SEL$8CFDDA53 (VIEW MERGE SEL$8812AA4E ; SEL$2)
  SEL$2 (PARSER)
  SEL$3 (PARSER)
    SEL$0098CF9D (VIEW MERGE SEL$3 ; SEL$F5B21678) [FINAL]
  SEL$4 (PARSER)
    SEL$F5B21678 (VIEW MERGE SEL$4 ; SEL$ABDE6DFF)
  SEL$5 (PARSER)
    SEL$ABDE6DFF (VIEW MERGE SEL$5 ; SEL$6)
  SEL$6 (PARSER)
  SEL$7 (PARSER)
    SEL$FDEC9754 (QUERY ANSI REARCHITECTURE SEL$7 ; SEL$8812AA4E)
      SEL$1D5803B5 (VIEW MERGE SEL$FDEC9754 ; SEL$8CFDDA53)
  SEL$8 (PARSER)
    SEL$22F20E7B (VIEW MERGE SEL$8 ; SEL$1D5803B5)
  SEL$9 (PARSER)
    SEL$BB855F6A (VIEW MERGE SEL$9 ; SEL$22F20E7B) [FINAL]

Historical Execution Plans

Historical execution plans including Outline data

Plan Control Objects (Parameters)

Plan control related parameters - If ALTERNATE_PLAN_BASELINE is AUTO, AUTO SPM is enabled

Parameter Name	Value
ACCEPT_PLANS	TRUE
ALTERNATE_PLAN_BASELINE	EXISTING
ALTERNATE_PLAN_LIMIT	UNLIMITED
ALTERNATE_PLAN_SOURCE	AUTO
DAYS_TO_EXPIRE	UNLIMITED
DEFAULT_EXECUTION_TYPE	SPM EVOLVE
EXECUTION_DAYS_TO_EXPIRE	30
JOURNALING	INFORMATION
MODE	COMPREHENSIVE
TARGET_OBJECTS	1
TIME_LIMIT	3600

Auto Tasks

Task ID	Task Name	Enabled	Last Scheduled Time
0	AWR Warehouse Auto-Import	FALSE
1	AWR Warehouse Auto-Export	FALSE
2	KET Autonomous Task Test	FALSE
3	Auto Index Task	FALSE
4	Auto Statistics Management Task	FALSE
5	Auto STS Capture Task	TRUE	07.08.25 07:46:35,748 +00:00
6	Auto SPM Task	FALSE
7	SQLQ: Auto-purge unused SQL quarantine configurations	FALSE
8	Auto Zonemap Task	FALSE
9	Auto-STS Flush	TRUE	07.08.25 07:46:38,720 +00:00
10	Auto-STS Purge	TRUE	06.08.25 08:13:32,846 +00:00
11	Managed Stream Flush	FALSE
12	AUTO MV ARM TASK	FALSE
13	AUTO MV VER TASK	FALSE
14	AUTO MV MM TASK	FALSE
15	Autotask Lite	FALSE
16	DBReplay Finish Capture	FALSE
17	SQL Monitor Purge	TRUE	06.08.25 08:18:30,372 +00:00
18	Event Logger Purge	TRUE	06.08.25 08:13:30,004 +00:00
19	Advisor Framework Purge	TRUE	06.08.25 08:13:30,074 +00:00
20	Autotask Async Operation	FALSE
22	AWRHub Maintenance	TRUE	06.08.25 08:13:30,270 +00:00
23	SQL Monitor Reports Flush	FALSE
24	Auto SF Shrink	FALSE
25	Auto Clustering Task	FALSE
26	Auto In-Memory Task	FALSE
27	Auto Compress	FALSE
28	Replay Monitor	FALSE
29	DB Feature Usage Sampling	TRUE	05.08.25 09:01:19,689 +00:00
30	Automatic SQL Tuning Advisor Task	FALSE
31	Query Vector Processing Task	FALSE
32	Auto Compress Observation	FALSE

Auto Task Interval

Auto Tasks

Task Name	Interval
Auto STS Capture Task	900

Plan Control Objects (Baselines/Profiles)

Information related to Profiles and Baselines

Plan Control Objects (DBA_SQLSET_STATEMENTS)

Entries in DBA_SQLSET_STATEMENTS

Monitored Executions

Recent 10 executions by Status

Non Standard Optimizer Parameters

List of non standard optimizer parameters

Reoptimization Hints

Reoptimization hints for SQL statement

Cursor Sharing Info

Info as to why a cursor may have multiple versions (if applicable)

Parameters(Non-Default Values)

A list of system parameters with non-default values

Rownum	Parameter Name	Instance ID	Ordinal	Is Default	Is Modified	Value	Display Value	Description
1	_dmm_blas_library	1	1	FALSE	FALSE	libora_netlib.so		Control which BLAS/LAPACK dynamic library to load
2	_enable_memory_protection_keys	1	1	FALSE	FALSE	FALSE		Enable memory protection keys usage
3	_instance_recovery_bloom_filter_size	1	1	FALSE	FALSE	1048576		Bloom filter size (in bytes) used during claim phase
4	common_user_prefix	1	1	FALSE	FALSE			Enforce restriction on a prefix of a Common User/Role/Profile name
5	compatible	1	1	FALSE	FALSE	23.6.0		Database will be completely compatible with this software version
6	control_files	1	1	FALSE	FALSE	/opt/oracle/oradata/FREE/control01.ctl		control file names list
7	control_files	1	2	FALSE	FALSE	/opt/oracle/oradata/FREE/control02.ctl		control file names list
8	control_management_pack_access	1	1	FALSE	FALSE	DIAGNOSTIC+TUNING		declares which manageability packs are enabled
9	cpu_count	1	1	FALSE	FALSE	2		maximum number of CPUs
10	db_block_size	1	1	FALSE	FALSE	8192		Size of database block in bytes
11	db_name	1	1	FALSE	FALSE	FREE		database name specified in CREATE DATABASE
12	diagnostic_dest	1	1	FALSE	FALSE	/opt/oracle		diagnostic base directory
13	dispatchers	1	1	FALSE	FALSE	(PROTOCOL=TCP) (SERVICE=FREEXDB)		specifications of dispatchers
14	enable_pluggable_database	1	1	FALSE	FALSE	TRUE		Enable Pluggable Database
15	fast_start_parallel_rollback	1	1	FALSE	FALSE	FALSE		max number of parallel recovery slaves that may be used
16	job_queue_processes	1	1	FALSE	FALSE	1		maximum number of job queue slave processes
17	local_listener	1	1	FALSE	FALSE			local listener
18	nls_language	1	1	FALSE	FALSE	AMERICAN		NLS language name
19	nls_territory	1	1	FALSE	FALSE	AMERICA		NLS territory name
20	open_cursors	1	1	FALSE	FALSE	300		max # cursors per session
21	pga_aggregate_target	1	1	FALSE	FALSE	536870912	512M	Target size for the aggregate PGA memory consumed by the instance
22	processes	1	1	FALSE	FALSE	200		user processes
23	remote_login_passwordfile	1	1	FALSE	FALSE	EXCLUSIVE		password file usage parameter
24	sga_max_size	1	1	FALSE	FALSE	1577058304	1504M	max total SGA size
25	sga_target	1	1	FALSE	FALSE	0		Target size of SGA
26	shared_servers	1	1	FALSE	FALSE	0		number of shared servers to start up
27	spatial_vector_acceleration	1	1	FALSE	FALSE	TRUE		enable spatial vector acceleration
28	undo_tablespace	1	1	FALSE	FALSE	UNDOTBS1		use/switch undo tablespace

Instance Parameters

All parameter settings, including hidden parameters

Rownum	Parameter Name	Ordinal	Is Default	Is Modified	Value	Display Value	Description
1	DBFIPS_140	1	TRUE	FALSE	FALSE		Enable use of crypographic libraries in FIPS mode, public
2	_dmm_blas_library	1	FALSE	FALSE	libora_netlib.so		Control which BLAS/LAPACK dynamic library to load
3	_enable_memory_protection_keys	1	FALSE	FALSE	FALSE		Enable memory protection keys usage
4	_instance_recovery_bloom_filter_size	1	FALSE	FALSE	1048576		Bloom filter size (in bytes) used during claim phase
5	adg_account_info_tracking	1	TRUE	FALSE	LOCAL		ADG user account info tracked in standby(LOCAL) or in Primary(GLOBAL)
6	adg_redirect_dml	1	TRUE	FALSE	FALSE		Enable DML Redirection from ADG
7	alert_log_max_size	1	TRUE	FALSE	1048576000	1000M	Alert-log maximum total size
8	allow_global_dblinks	1	TRUE	FALSE	FALSE		LDAP lookup for DBLINKS
9	allow_group_access_to_sga	1	TRUE	FALSE	FALSE		Allow read access for SGA to users of Oracle owner group
10	allow_legacy_reco_protocol	1	TRUE	FALSE	TRUE		Should the database allow the legacy RECO protocol
11	allow_rowid_column_type	1	TRUE	FALSE	FALSE		Allow creation of rowid column
12	allow_weak_crypto	1	TRUE	FALSE	TRUE		Allow weak crypto usage in DBMS_CRYPTO
13	approx_for_aggregation	1	TRUE	FALSE	FALSE		Replace exact aggregation with approximate aggregation
14	approx_for_count_distinct	1	TRUE	FALSE	FALSE		Replace count distinct with approx_count_distinct
15	approx_for_percentile	1	TRUE	FALSE	NONE		Replace percentile_* with approx_percentile
16	aq_tm_processes	1	TRUE	FALSE	1		number of AQ Time Managers to start
17	archive_lag_target	1	TRUE	FALSE	0		Maximum number of seconds of redos the standby could lose
18	asm_diskgroups	0	TRUE	FALSE			disk groups to mount automatically
19	asm_diskstring	0	TRUE	FALSE			disk set locations for discovery
20	asm_io_processes	1	TRUE	FALSE	20		number of I/O processes per domain in the ASM IOSERVER instance
21	asm_power_limit	1	TRUE	FALSE	1		number of parallel relocations for disk rebalancing
22	asm_preferred_read_failure_groups	0	TRUE	FALSE			preferred read failure groups
23	asm_unified_audit_destination	1	TRUE	FALSE	SYSTEMLOG		Configuring ASM Unified Audit Destination
24	asm_unified_audit_level	1	TRUE	FALSE	BASIC		Configuring ASM Unified Audit Level
25	audit_file_dest	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/rdbms/audit		Directory in which auditing files are to reside
26	audit_sys_operations	1	TRUE	FALSE	FALSE		enable sys auditing
27	audit_syslog_level	0	TRUE	FALSE			Syslog facility and level
28	audit_trail	1	TRUE	FALSE	NONE		enable system auditing
29	auto_start_pdb_services	1	TRUE	FALSE	FALSE		Automatically start all PDB services on PDB Open
30	autotask_max_active_pdbs	1	TRUE	FALSE	2		Setting for Autotask Maximum Maintenance PDBs
31	awr_pdb_autoflush_enabled	1	TRUE	FALSE	TRUE		Enable/Disable AWR automatic PDB flushing
32	awr_pdb_max_parallel_slaves	1	TRUE	FALSE	10		maximum concurrent AWR PDB MMON slaves per instance
33	awr_snapshot_time_offset	1	TRUE	FALSE	0		Setting for AWR Snapshot Time Offset
34	background_core_dump	1	TRUE	FALSE	partial		Core Size for Background Processes
35	background_dump_dest	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/rdbms/log		Detached process dump directory
36	backup_tape_io_slaves	1	TRUE	FALSE	FALSE		BACKUP Tape I/O slaves
37	bitmap_merge_area_size	1	TRUE	FALSE	1048576		maximum memory allow for BITMAP MERGE
38	blank_trimming	1	TRUE	FALSE	FALSE		blank trimming semantics parameter
39	blockchain_table_max_no_drop	0	TRUE	FALSE			maximum idle retention minutes for blockchain tables
40	blockchain_table_retention_threshold	1	TRUE	FALSE	16		maximum retention without TABLE RETENTION privilege
41	buffer_pool_keep	1	TRUE	FALSE			Number of database blocks/latches in keep buffer pool
42	buffer_pool_recycle	1	TRUE	FALSE			Number of database blocks/latches in recycle buffer pool
43	cdb_cluster	1	TRUE	FALSE	FALSE		if TRUE startup in CDB Cluster mode
44	cdb_cluster_name	1	TRUE	FALSE			CDB Cluster name
45	cell_offload_compaction	1	TRUE	FALSE	ADAPTIVE		Cell packet compaction strategy
46	cell_offload_decryption	1	TRUE	FALSE	TRUE		enable SQL processing offload of encrypted data to cells
47	cell_offload_parameters	1	TRUE	FALSE			Additional cell offload parameters
48	cell_offload_plan_display	1	TRUE	FALSE	AUTO		Cell offload explain plan display
49	cell_offload_processing	1	TRUE	FALSE	TRUE		enable SQL processing offload to cells
50	cell_offloadgroup_name	0	TRUE	FALSE			Set the offload group name
51	circuits	0	TRUE	FALSE			max number of circuits
52	client_prefetch_rows	1	TRUE	FALSE	0		Client prefetch rows value
53	client_result_cache_lag	1	TRUE	FALSE	3000		client result cache maximum lag in milliseconds
54	client_result_cache_size	1	TRUE	FALSE	0		client result cache max size in bytes
55	client_statistics_level	1	TRUE	FALSE	TYPICAL		Client Statistics Level
56	clonedb	1	TRUE	FALSE	FALSE		clone database
57	clonedb_dir	0	TRUE	FALSE			CloneDB Directory
58	cloud_table_commit_threshold	1	TRUE	FALSE	0		export threshold (row count) for buffered cloud table
59	cluster_database	1	TRUE	FALSE	FALSE		if TRUE startup in cluster database mode
60	cluster_interconnects	1	TRUE	FALSE			interconnects for RAC use
61	commit_logging	0	TRUE	FALSE			transaction commit log write behaviour
62	commit_point_strength	1	TRUE	FALSE	1		Bias this node has toward not preparing in a two-phase commit
63	commit_wait	0	TRUE	FALSE			transaction commit log wait behaviour
64	commit_write	0	TRUE	FALSE			transaction commit log write behaviour
65	common_user_prefix	1	FALSE	FALSE			Enforce restriction on a prefix of a Common User/Role/Profile name
66	compatible	1	FALSE	FALSE	23.6.0		Database will be completely compatible with this software version
67	connection_brokers	1	TRUE	FALSE	((TYPE=DEDICATED)(BROKERS=2)(CONNECTIONS=2000))		connection brokers specification
68	connection_brokers	2	TRUE	FALSE	((TYPE=EMON)(BROKERS=1))		connection brokers specification
69	container_data	1	TRUE	FALSE	ALL		which containers should data be returned from?
70	containers_parallel_degree	1	TRUE	FALSE	65535		Parallel degree for a CONTAINERS() query
71	control_file_record_keep_time	1	TRUE	FALSE	7		control file record keep time in days
72	control_files	1	FALSE	FALSE	/opt/oracle/oradata/FREE/control01.ctl		control file names list
73	control_files	2	FALSE	FALSE	/opt/oracle/oradata/FREE/control02.ctl		control file names list
74	control_management_pack_access	1	FALSE	FALSE	DIAGNOSTIC+TUNING		declares which manageability packs are enabled
75	core_dump_dest	1	TRUE	FALSE	/opt/oracle/diag/rdbms/free/FREE/cdump		Core dump directory
76	cpu_count	1	FALSE	FALSE	2		maximum number of CPUs
77	cpu_min_count	1	TRUE	FALSE	2		minimum number of CPUs required
78	create_bitmap_area_size	1	TRUE	FALSE	8388608		size of create bitmap buffer for bitmap index
79	create_stored_outlines	0	TRUE	FALSE			create stored outlines for DML statements
80	cursor_bind_capture_destination	1	TRUE	FALSE	memory+disk		Allowed destination for captured bind variables
81	cursor_invalidation	1	TRUE	FALSE	IMMEDIATE		default for DDL cursor invalidation semantics
82	cursor_sharing	1	TRUE	FALSE	EXACT		cursor sharing mode
83	cursor_space_for_time	1	TRUE	FALSE	FALSE		use more memory in order to get faster execution
84	data_guard_max_io_time	1	TRUE	FALSE	240		maximum I/O time before process considered hung
85	data_guard_max_longio_time	1	TRUE	FALSE	240		maximum long I/O time before process considered hung
86	data_guard_sync_latency	1	TRUE	FALSE	0		Data Guard SYNC latency
87	data_transfer_cache_size	1	TRUE	FALSE	0		Size of data transfer cache
88	db_16k_cache_size	1	TRUE	FALSE	0		Size of cache for 16K buffers
89	db_2k_cache_size	1	TRUE	FALSE	0		Size of cache for 2K buffers
90	db_32k_cache_size	1	TRUE	FALSE	0		Size of cache for 32K buffers
91	db_4k_cache_size	1	TRUE	FALSE	0		Size of cache for 4K buffers
92	db_8k_cache_size	1	TRUE	FALSE	0		Size of cache for 8K buffers
93	db_big_table_cache_percent_target	1	TRUE	FALSE	0		Big table cache target size in percentage
94	db_block_buffers	1	TRUE	FALSE	0		Number of database blocks cached in memory
95	db_block_checking	1	TRUE	FALSE	FALSE		header checking and data and index block checking
96	db_block_checksum	1	TRUE	FALSE	TYPICAL		store checksum in db blocks and check during reads
97	db_block_size	1	FALSE	FALSE	8192		Size of database block in bytes
98	db_cache_advice	1	TRUE	FALSE	ON		Buffer cache sizing advisory
99	db_cache_size	1	TRUE	FALSE	0		Size of DEFAULT buffer pool for standard block size buffers
100	db_create_file_dest	1	TRUE	FALSE			default database location
101	db_create_online_log_dest_1	1	TRUE	FALSE			online log/controlfile destination #1
102	db_create_online_log_dest_2	1	TRUE	FALSE			online log/controlfile destination #2
103	db_create_online_log_dest_3	1	TRUE	FALSE			online log/controlfile destination #3
104	db_create_online_log_dest_4	1	TRUE	FALSE			online log/controlfile destination #4
105	db_create_online_log_dest_5	1	TRUE	FALSE			online log/controlfile destination #5
106	db_domain	0	TRUE	FALSE			directory part of global database name stored with CREATE DATABASE
107	db_file_multiblock_read_count	1	TRUE	FALSE	128		db block to be read each IO
108	db_file_name_convert	0	TRUE	FALSE			datafile name convert patterns and strings for standby/clone db
109	db_files	1	TRUE	FALSE	200		max allowable # db files
110	db_flash_cache_file	1	TRUE	FALSE			flash cache file for default block size
111	db_flash_cache_size	1	TRUE	FALSE	0		flash cache size for db_flash_cache_file
112	db_flashback_log_dest	1	TRUE	FALSE			Separate creation directory for flashback database logs
113	db_flashback_log_dest_size	1	TRUE	FALSE	0		Size limit of separate creation directory for flashback database logs
114	db_flashback_retention_target	1	TRUE	FALSE	1440		Maximum Flashback Database log retention time in minutes.
115	db_index_compression_inheritance	1	TRUE	FALSE	NONE		options for table or tablespace level compression inheritance
116	db_keep_cache_size	1	TRUE	FALSE	0		Size of KEEP buffer pool for standard block size buffers
117	db_lost_write_protect	1	TRUE	FALSE	AUTO		enable lost write detection
118	db_name	1	FALSE	FALSE	FREE		database name specified in CREATE DATABASE
119	db_performance_profile	1	TRUE	FALSE			Database performance category
120	db_recovery_auto_rekey	1	TRUE	FALSE	ON		enable automatic tablespace rekey recovery
121	db_recovery_file_dest	1	TRUE	FALSE			default database recovery file location
122	db_recovery_file_dest_size	1	TRUE	FALSE	0		database recovery files size limit
123	db_recycle_cache_size	1	TRUE	FALSE	0		Size of RECYCLE buffer pool for standard block size buffers
124	db_securefile	1	TRUE	FALSE	PREFERRED		permit securefile storage during lob creation
125	db_ultra_safe	1	TRUE	FALSE	OFF		Sets defaults for other parameters that control protection levels
126	db_unique_name	1	TRUE	FALSE	FREE		Database Unique Name
127	db_unrecoverable_scn_tracking	1	TRUE	FALSE	TRUE		Track nologging SCN in controlfile
128	db_writer_processes	1	TRUE	FALSE	1		number of background database writer processes to start
129	dbnest_enable	1	TRUE	FALSE	NONE		database Nest enable
130	dbnest_pdb_fs_conf	0	TRUE	FALSE			PDB Filesystem configuration
131	dbwr_io_slaves	1	TRUE	FALSE	0		DBWR I/O slaves
132	ddl_lock_timeout	1	TRUE	FALSE	0		timeout to restrict the time that ddls wait for dml lock
133	debug_log_max_size	1	TRUE	FALSE	1048576000	1000M	Debug-log maximum total size
134	default_credential	1	TRUE	FALSE			default credential session parameter
135	default_sharing	1	TRUE	FALSE	metadata		Default sharing clause
136	deferred_segment_creation	1	TRUE	FALSE	TRUE		defer segment creation to first insert
137	dg_broker_config_file1	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/dbs/dr1FREE.dat		data guard broker configuration file #1
138	dg_broker_config_file2	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/dbs/dr2FREE.dat		data guard broker configuration file #2
139	dg_broker_start	1	TRUE	FALSE	FALSE		start Data Guard broker (DMON process)
140	diagnostic_dest	1	FALSE	FALSE	/opt/oracle		diagnostic base directory
141	diagnostics_control	1	TRUE	FALSE	IGNORE		controls response when 'enabling diagnostics' privilege is absent
142	directory_prefixes_allowed	0	TRUE	FALSE			Allowed prefixes for directory paths created inside the PDB
143	disable_pdb_feature	1	TRUE	FALSE	0		Disable features
144	disk_asynch_io	1	TRUE	FALSE	TRUE		Use asynch I/O for random access devices
145	dispatchers	1	FALSE	FALSE	(PROTOCOL=TCP) (SERVICE=FREEXDB)		specifications of dispatchers
146	distributed_lock_timeout	1	TRUE	FALSE	60		number of seconds a distributed transaction waits for a lock
147	dml_locks	1	TRUE	FALSE	1416		dml locks - one for each table modified in a transaction
148	dnfs_batch_size	1	TRUE	FALSE	4096		Max number of dNFS asynch I/O requests queued per session
149	drcp_connection_limit	1	TRUE	FALSE	0		DRCP connection limit
150	drcp_dedicated_opt	1	TRUE	FALSE	NO		Turn on/off dedicated optimization for DRCP
151	dst_upgrade_insert_conv	1	TRUE	FALSE	TRUE		Enables/Disables internal conversions during DST upgrade
152	enable_automatic_maintenance_pdb	1	TRUE	FALSE	TRUE		Enable/Disable Automated Maintenance for Non-Root PDB
153	enable_ddl_logging	1	TRUE	FALSE	FALSE		enable ddl logging
154	enable_dnfs_dispatcher	1	TRUE	FALSE	FALSE		Enable DNFS Dispatcher
155	enable_goldengate_replication	1	TRUE	FALSE	FALSE		goldengate replication enabled
156	enable_imc_with_mira	1	TRUE	FALSE	FALSE		enable IMC with multi instance redo apply
157	enable_per_pdb_drcp	1	TRUE	FALSE	FALSE		Turn on/off per PDB DRCP
158	enable_pluggable_database	1	FALSE	FALSE	TRUE		Enable Pluggable Database
159	enabled_PDBs_on_standby	1	TRUE	FALSE	*		List of Enabled PDB patterns
160	encrypt_new_tablespaces	1	TRUE	FALSE	CLOUD_ONLY		whether to encrypt newly created tablespaces
161	error_message_details	1	TRUE	FALSE	ON		print additional explanatory error details
162	event	1	TRUE	FALSE			debug event control - default null string
163	external_keystore_credential_location	1	TRUE	FALSE			external keystore credential location
164	fal_client	1	TRUE	FALSE			FAL client
165	fal_server	1	TRUE	FALSE			FAL server list
166	fast_start_io_target	1	TRUE	FALSE	0		Upper bound on recovery reads
167	fast_start_mttr_target	1	TRUE	FALSE	0		MTTR target in seconds
168	fast_start_parallel_rollback	1	FALSE	FALSE	FALSE		max number of parallel recovery slaves that may be used
169	file_mapping	1	TRUE	FALSE	FALSE		enable file mapping
170	fileio_network_adapters	0	TRUE	FALSE			Network Adapters for File I/O
171	filesystemio_options	1	TRUE	FALSE	none		IO operations on filesystem files
172	fixed_date	1	TRUE	FALSE			fixed SYSDATE value
173	forward_listener	0	TRUE	FALSE			forward listener
174	gcs_server_processes	1	TRUE	FALSE	0		number of background gcs server processes to start
175	global_names	1	TRUE	FALSE	FALSE		enforce that database links have same name as remote database
176	global_txn_processes	1	TRUE	FALSE	1		number of background global transaction processes to start
177	group_by_position_enabled	1	TRUE	FALSE	FALSE		enable/disable group by position
178	hash_area_size	1	TRUE	FALSE	131072		size of in-memory hash work area
179	heartbeat_batch_size	1	TRUE	FALSE	5		Number of heartbeats to be sent in a batch
180	heat_map	1	TRUE	FALSE	OFF		ILM Heatmap Tracking
181	hi_shared_memory_address	1	TRUE	FALSE	0		SGA starting address (high order 32-bits on 64-bit platforms)
182	hs_autoregister	1	TRUE	FALSE	TRUE		enable automatic server DD updates in HS agent self-registration
183	http_proxy	0	TRUE	FALSE			http_proxy
184	hybrid_read_only	1	TRUE	FALSE	FALSE		Hybrid read only mode allows CDB common user to patch the PDB
185	identity_provider_config	1	TRUE	FALSE			Identity Provider Configuration
186	identity_provider_type	1	TRUE	FALSE	NONE		Identity Provider Type
187	ifile	0	TRUE	FALSE			include file in init.ora
188	ignore_session_set_param_errors	0	TRUE	FALSE			Ignore errors during alter session param set
189	inmemory_adg_enabled	1	TRUE	FALSE	TRUE		Enable IMC support on ADG
190	inmemory_automatic_level	1	TRUE	FALSE	OFF		Enable Automatic In-Memory management
191	inmemory_clause_default	1	TRUE	FALSE			Default in-memory clause for new tables
192	inmemory_deep_vectorization	1	TRUE	FALSE	TRUE		In-Memory Deep Vectorization Enabled
193	inmemory_expressions_usage	1	TRUE	FALSE	ENABLE		Controls which In-Memory Expressions are populated in-memory
194	inmemory_force	1	TRUE	FALSE	DEFAULT		Force tables to be in-memory or not
195	inmemory_graph_algorithm_execution	1	TRUE	FALSE	DEFAULT		Controls the fall-back action of graph algorithm execution if in-memory execution is not possible
196	inmemory_max_populate_servers	1	TRUE	FALSE	0		maximum inmemory populate servers
197	inmemory_optimized_arithmetic	1	TRUE	FALSE	DISABLE		Controls whether or not DSBs are stored in-memory
198	inmemory_optimized_date	1	TRUE	FALSE	DISABLE		Enables feature to accelerate date queries
199	inmemory_prefer_xmem_memcompress	1	TRUE	FALSE			Prefer to store tables with given memcompress levels in xmem
200	inmemory_prefer_xmem_priority	1	TRUE	FALSE			Prefer to store tables with given priority levels in xmem
201	inmemory_query	1	TRUE	FALSE	ENABLE		Specifies whether in-memory queries are allowed
202	inmemory_size	1	TRUE	FALSE	0		size in bytes of in-memory area
203	inmemory_trickle_repopulate_servers_percent	1	TRUE	FALSE	1		inmemory trickle repopulate servers percent
204	inmemory_virtual_columns	1	TRUE	FALSE	MANUAL		Controls which user-defined virtual columns are stored in-memory
205	inmemory_xmem_size	1	TRUE	FALSE	0		size in bytes of in-memory xmem area
206	instance_abort_delay_time	1	TRUE	FALSE	0		time to delay an internal initiated abort (in seconds)
207	instance_groups	0	TRUE	FALSE			list of instance group names
208	instance_mode	1	TRUE	FALSE	READ-WRITE		indicates whether the instance read-only or read-write or read-mostly
209	instance_name	1	TRUE	FALSE	FREE		instance name supported by the instance
210	instance_number	1	TRUE	FALSE	0		instance number
211	instance_type	1	TRUE	FALSE	RDBMS		type of instance to be executed
212	instant_restore	1	TRUE	FALSE	FALSE		instant repopulation of datafiles
213	iorm_limit_policy	1	TRUE	FALSE	RM_PLAN		Policy used to compute Exadata IORM limit
214	ipddb_enable	1	TRUE	FALSE	FALSE		Enable IPD/DB data collection
215	java_jit_enabled	1	TRUE	FALSE	FALSE		Java VM JIT enabled
216	java_max_sessionspace_size	1	TRUE	FALSE	0		max allowed size in bytes of a Java sessionspace
217	java_pool_size	1	TRUE	FALSE	0		size in bytes of java pool
218	java_restrict	1	TRUE	FALSE	none		Restrict Java VM Access
219	java_soft_sessionspace_limit	1	TRUE	FALSE	0		warning limit on size in bytes of a Java sessionspace
220	job_queue_processes	1	FALSE	FALSE	1		maximum number of job queue slave processes
221	json_behavior	1	TRUE	FALSE			control json behaviors
222	json_expression_check	1	TRUE	FALSE	off		enable/disable JSON query statement check
223	kafka_config_file	1	TRUE	FALSE			KSR pub/sub external message bus(KGMPS) CONFIGuration file
224	large_pool_size	1	TRUE	FALSE	0		size in bytes of large pool
225	ldap_directory_access	1	TRUE	FALSE	NONE		RDBMS's LDAP access option
226	ldap_directory_sysauth	1	TRUE	FALSE	no		OID usage parameter
227	license_max_sessions	1	TRUE	FALSE	0		maximum number of non-system user sessions allowed
228	license_max_users	1	TRUE	FALSE	0		maximum number of named users that can be created in the database
229	license_sessions_warning	1	TRUE	FALSE	0		warning level for number of non-system user sessions
230	listener_networks	0	TRUE	FALSE			listener registration networks
231	load_without_compile	1	TRUE	FALSE	none		Load PL/SQL or Database objects without compilation
232	lob_signature_enable	1	TRUE	FALSE	FALSE		enable lob signature
233	local_listener	1	FALSE	FALSE			local listener
234	lock_name_space	0	TRUE	FALSE			lock name space used for generating lock names for standby/clone database
235	lock_sga	1	TRUE	FALSE	FALSE		Lock entire SGA in physical memory
236	lockdown_errors	1	TRUE	FALSE	RAISE		Mode to ignore or raise PDB lockdown error
237	lockfree_reservation	1	TRUE	FALSE	ON		enable/disable lockfree reservation
238	log_archive_config	1	TRUE	FALSE			log archive config
239	log_archive_dest	1	TRUE	FALSE			archival destination text string
240	log_archive_dest_1	1	TRUE	FALSE			archival destination #1 text string
241	log_archive_dest_10	1	TRUE	FALSE			archival destination #10 text string
242	log_archive_dest_11	1	TRUE	FALSE			archival destination #11 text string
243	log_archive_dest_12	1	TRUE	FALSE			archival destination #12 text string
244	log_archive_dest_13	1	TRUE	FALSE			archival destination #13 text string
245	log_archive_dest_14	1	TRUE	FALSE			archival destination #14 text string
246	log_archive_dest_15	1	TRUE	FALSE			archival destination #15 text string
247	log_archive_dest_16	1	TRUE	FALSE			archival destination #16 text string
248	log_archive_dest_17	1	TRUE	FALSE			archival destination #17 text string
249	log_archive_dest_18	1	TRUE	FALSE			archival destination #18 text string
250	log_archive_dest_19	1	TRUE	FALSE			archival destination #19 text string
251	log_archive_dest_2	1	TRUE	FALSE			archival destination #2 text string
252	log_archive_dest_20	1	TRUE	FALSE			archival destination #20 text string
253	log_archive_dest_21	1	TRUE	FALSE			archival destination #21 text string
254	log_archive_dest_22	1	TRUE	FALSE			archival destination #22 text string
255	log_archive_dest_23	1	TRUE	FALSE			archival destination #23 text string
256	log_archive_dest_24	1	TRUE	FALSE			archival destination #24 text string
257	log_archive_dest_25	1	TRUE	FALSE			archival destination #25 text string
258	log_archive_dest_26	1	TRUE	FALSE			archival destination #26 text string
259	log_archive_dest_27	1	TRUE	FALSE			archival destination #27 text string
260	log_archive_dest_28	1	TRUE	FALSE			archival destination #28 text string
261	log_archive_dest_29	1	TRUE	FALSE			archival destination #29 text string
262	log_archive_dest_3	1	TRUE	FALSE			archival destination #3 text string
263	log_archive_dest_30	1	TRUE	FALSE			archival destination #30 text string
264	log_archive_dest_31	1	TRUE	FALSE			archival destination #31 text string
265	log_archive_dest_4	1	TRUE	FALSE			archival destination #4 text string
266	log_archive_dest_5	1	TRUE	FALSE			archival destination #5 text string
267	log_archive_dest_6	1	TRUE	FALSE			archival destination #6 text string
268	log_archive_dest_7	1	TRUE	FALSE			archival destination #7 text string
269	log_archive_dest_8	1	TRUE	FALSE			archival destination #8 text string
270	log_archive_dest_9	1	TRUE	FALSE			archival destination #9 text string
271	log_archive_dest_state_1	1	TRUE	FALSE	enable		archival destination #1 state text string
272	log_archive_dest_state_10	1	TRUE	FALSE	enable		archival destination #10 state text string
273	log_archive_dest_state_11	1	TRUE	FALSE	enable		archival destination #11 state text string
274	log_archive_dest_state_12	1	TRUE	FALSE	enable		archival destination #12 state text string
275	log_archive_dest_state_13	1	TRUE	FALSE	enable		archival destination #13 state text string
276	log_archive_dest_state_14	1	TRUE	FALSE	enable		archival destination #14 state text string
277	log_archive_dest_state_15	1	TRUE	FALSE	enable		archival destination #15 state text string
278	log_archive_dest_state_16	1	TRUE	FALSE	enable		archival destination #16 state text string
279	log_archive_dest_state_17	1	TRUE	FALSE	enable		archival destination #17 state text string
280	log_archive_dest_state_18	1	TRUE	FALSE	enable		archival destination #18 state text string
281	log_archive_dest_state_19	1	TRUE	FALSE	enable		archival destination #19 state text string
282	log_archive_dest_state_2	1	TRUE	FALSE	enable		archival destination #2 state text string
283	log_archive_dest_state_20	1	TRUE	FALSE	enable		archival destination #20 state text string
284	log_archive_dest_state_21	1	TRUE	FALSE	enable		archival destination #21 state text string
285	log_archive_dest_state_22	1	TRUE	FALSE	enable		archival destination #22 state text string
286	log_archive_dest_state_23	1	TRUE	FALSE	enable		archival destination #23 state text string
287	log_archive_dest_state_24	1	TRUE	FALSE	enable		archival destination #24 state text string
288	log_archive_dest_state_25	1	TRUE	FALSE	enable		archival destination #25 state text string
289	log_archive_dest_state_26	1	TRUE	FALSE	enable		archival destination #26 state text string
290	log_archive_dest_state_27	1	TRUE	FALSE	enable		archival destination #27 state text string
291	log_archive_dest_state_28	1	TRUE	FALSE	enable		archival destination #28 state text string
292	log_archive_dest_state_29	1	TRUE	FALSE	enable		archival destination #29 state text string
293	log_archive_dest_state_3	1	TRUE	FALSE	enable		archival destination #3 state text string
294	log_archive_dest_state_30	1	TRUE	FALSE	enable		archival destination #30 state text string
295	log_archive_dest_state_31	1	TRUE	FALSE	enable		archival destination #31 state text string
296	log_archive_dest_state_4	1	TRUE	FALSE	enable		archival destination #4 state text string
297	log_archive_dest_state_5	1	TRUE	FALSE	enable		archival destination #5 state text string
298	log_archive_dest_state_6	1	TRUE	FALSE	enable		archival destination #6 state text string
299	log_archive_dest_state_7	1	TRUE	FALSE	enable		archival destination #7 state text string
300	log_archive_dest_state_8	1	TRUE	FALSE	enable		archival destination #8 state text string
301	log_archive_dest_state_9	1	TRUE	FALSE	enable		archival destination #9 state text string
302	log_archive_duplex_dest	1	TRUE	FALSE			duplex archival destination text string
303	log_archive_format	1	TRUE	FALSE	%t_%s_%r.dbf		archival destination format
304	log_archive_max_processes	1	TRUE	FALSE	4		maximum number of active ARCH processes
305	log_archive_min_succeed_dest	1	TRUE	FALSE	1		minimum number of archive destinations that must succeed
306	log_archive_trace	1	TRUE	FALSE	0		Establish archive operation tracing level
307	log_buffer	1	TRUE	FALSE	4292608	4192K	redo circular buffer size
308	log_checkpoint_interval	1	TRUE	FALSE	0		# redo blocks checkpoint threshold
309	log_checkpoint_timeout	1	TRUE	FALSE	1800		Maximum time interval between checkpoints in seconds
310	log_checkpoints_to_alert	1	TRUE	FALSE	FALSE		log checkpoint begin/end to alert file
311	log_file_name_convert	0	TRUE	FALSE			logfile name convert patterns and strings for standby/clone db
312	long_module_action	1	TRUE	FALSE	TRUE		Use longer module and action
313	main_workload_type	1	TRUE	FALSE	OLTP		Main workload type
314	mandatory_user_profile	1	TRUE	FALSE			Enforce Mandatory Password Profile for multitenant database
315	max_auth_servers	1	TRUE	FALSE	25		Maximum size of auth pool
316	max_columns	1	TRUE	FALSE	STANDARD		maximum number of columns allowed in table or view
317	max_datapump_jobs_per_pdb	1	TRUE	FALSE	AUTO		maximum number of concurrent Data Pump Jobs per PDB
318	max_datapump_parallel_per_job	1	TRUE	FALSE	AUTO		maximum number of parallel processes per Data Pump Job
319	max_dispatchers	0	TRUE	FALSE			max number of dispatchers
320	max_dump_file_size	1	TRUE	FALSE	32M		Maximum size (in bytes) of dump file
321	max_idle_blocker_time	1	TRUE	FALSE	0		maximum idle time for a blocking session in minutes
322	max_idle_time	1	TRUE	FALSE	0		maximum session idle time in minutes
323	max_iops	1	TRUE	FALSE	0		MAX IO per second
324	max_mbps	1	TRUE	FALSE	0		MAX MB per second
325	max_pdbs	1	TRUE	FALSE	18		max number of pdbs allowed in CDB or Application ROOT
326	max_saga_duration	1	TRUE	FALSE	86400		default value for max saga duration
327	max_shared_servers	0	TRUE	FALSE			max number of shared servers
328	max_string_size	1	TRUE	FALSE	STANDARD		controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
329	memoptimize_pool_size	1	TRUE	FALSE	0		Size of cache for imoltp buffers
330	memoptimize_write_area_size	1	TRUE	FALSE	0		changes memoptimize write area size
331	memoptimize_writes	1	TRUE	FALSE	HINT		write data to IGA without memoptimize_write hint
332	memory_max_size	1	TRUE	FALSE	0		Maximum memory size
333	memory_max_target	1	TRUE	FALSE	0		Max size for Memory Target
334	memory_size	1	TRUE	FALSE	0		Target memory size
335	memory_target	1	TRUE	FALSE	0		Target size of Oracle SGA and PGA memory
336	mfa_duo_api_host	1	TRUE	FALSE			MFA Duo API Host
337	mfa_oma_iam_domain_url	1	TRUE	FALSE			MFA Oracle Mobile Authenticator IAM Domain Url
338	mfa_sender_email_displayname	1	TRUE	FALSE			MFA Sender Email Displayname
339	mfa_sender_email_id	1	TRUE	FALSE			MFA Sender Email Id
340	mfa_smtp_host	1	TRUE	FALSE			MFA SMTP Host
341	mfa_smtp_port	1	TRUE	FALSE	587		MFA SMTP Port
342	min_auth_servers	1	TRUE	FALSE	1		Minimum size of auth pool
343	mle_prog_languages	1	TRUE	FALSE	all		Enable Multilingual Engine
344	multishard_query_data_consistency	1	TRUE	FALSE	strong		consistency setting for multishard queries
345	multishard_query_partial_results	1	TRUE	FALSE	not allowed		enable partial results for multishard queries
346	native_blockchain_features	1	TRUE	FALSE			Native block chain enable/disable
347	nls_calendar	1	TRUE	FALSE			NLS calendar system name
348	nls_comp	1	TRUE	FALSE	BINARY		NLS comparison
349	nls_currency	1	TRUE	FALSE			NLS local currency symbol
350	nls_date_format	1	TRUE	FALSE			NLS Oracle date format
351	nls_date_language	1	TRUE	FALSE			NLS date language name
352	nls_dual_currency	1	TRUE	FALSE			Dual currency symbol
353	nls_iso_currency	1	TRUE	FALSE			NLS ISO currency territory name
354	nls_language	1	FALSE	FALSE	AMERICAN		NLS language name
355	nls_length_semantics	1	TRUE	FALSE	BYTE		create columns using byte or char semantics by default
356	nls_nchar_conv_excp	1	TRUE	FALSE	FALSE		NLS raise an exception instead of allowing implicit conversion
357	nls_numeric_characters	1	TRUE	FALSE			NLS numeric characters
358	nls_sort	1	TRUE	FALSE			NLS linguistic definition name
359	nls_territory	1	FALSE	FALSE	AMERICA		NLS territory name
360	nls_time_format	1	TRUE	FALSE			time format
361	nls_time_tz_format	1	TRUE	FALSE			time with timezone format
362	nls_timestamp_format	1	TRUE	FALSE			time stamp format
363	nls_timestamp_tz_format	1	TRUE	FALSE			timestamp with timezone format
364	noncdb_compatible	1	TRUE	FALSE	FALSE		Non-CDB Compatible
365	object_cache_max_size_percent	1	TRUE	FALSE	10		percentage of maximum size over optimal of the user session's object cache
366	object_cache_optimal_size	1	TRUE	FALSE	51200000		optimal size of the user session's object cache in bytes
367	ofs_threads	1	TRUE	FALSE	4		Number of OFS threads
368	olap_page_pool_size	1	TRUE	FALSE	0		size of the olap page pool in bytes
369	one_step_plugin_for_pdb_with_tde	1	TRUE	FALSE	FALSE		Facilitate one-step plugin for PDB with TDE encrypted data
370	open_cursors	1	FALSE	FALSE	300		max # cursors per session
371	open_links	1	TRUE	FALSE	4		max # open links per session
372	open_links_per_instance	1	TRUE	FALSE	4		max # open links per instance
373	optimizer_adaptive_plans	1	TRUE	FALSE	TRUE		controls all types of adaptive plans
374	optimizer_adaptive_reporting_only	1	TRUE	FALSE	FALSE		use reporting-only mode for adaptive optimizations
375	optimizer_adaptive_statistics	1	TRUE	FALSE	FALSE		controls all types of adaptive statistics
376	optimizer_capture_sql_plan_baselines	1	TRUE	FALSE	FALSE		automatic capture of SQL plan baselines for repeatable statements
377	optimizer_capture_sql_quarantine	1	TRUE	FALSE	FALSE		enable automatic creation/update of sql quarantine configuration
378	optimizer_cross_shard_resiliency	1	TRUE	FALSE	FALSE		enables resilient execution of cross shard queries
379	optimizer_dynamic_sampling	1	TRUE	FALSE	2		optimizer dynamic sampling
380	optimizer_features_enable	1	TRUE	FALSE	23.1.0		optimizer plan compatibility parameter
381	optimizer_ignore_hints	1	TRUE	FALSE	FALSE		enables the embedded hints to be ignored
382	optimizer_ignore_parallel_hints	1	TRUE	FALSE	FALSE		enables embedded parallel hints to be ignored
383	optimizer_index_caching	1	TRUE	FALSE	0		optimizer percent index caching
384	optimizer_index_cost_adj	1	TRUE	FALSE	100		optimizer index cost adjustment
385	optimizer_inmemory_aware	1	TRUE	FALSE	TRUE		optimizer in-memory columnar awareness
386	optimizer_mode	1	TRUE	FALSE	ALL_ROWS		optimizer mode
387	optimizer_real_time_statistics	1	TRUE	FALSE	FALSE		optimizer real time statistics on conventional DML
388	optimizer_secure_view_merging	0	TRUE	FALSE			optimizer secure view merging and predicate pushdown/movearound
389	optimizer_session_type	1	TRUE	FALSE	NORMAL		Controls Auto Index
390	optimizer_use_invisible_indexes	1	TRUE	FALSE	FALSE		Usage of invisible indexes (TRUE/FALSE)
391	optimizer_use_pending_statistics	1	TRUE	FALSE	FALSE		Control whether to use optimizer pending statistics
392	optimizer_use_sql_plan_baselines	1	TRUE	FALSE	TRUE		use of SQL plan baselines for captured sql statements
393	optimizer_use_sql_quarantine	1	TRUE	FALSE	TRUE		enable use of sql quarantine
394	os_authent_prefix	1	TRUE	FALSE	ops$		prefix for auto-logon accounts
395	os_roles	1	TRUE	FALSE	FALSE		retrieve roles from the operating system
396	outbound_dblink_protocols	1	TRUE	FALSE	ALL		Outbound DBLINK Protocols allowed
397	parallel_adaptive_multi_user	1	TRUE	FALSE	FALSE		enable adaptive setting of degree for multiple user streams
398	parallel_degree_limit	1	TRUE	FALSE	CPU		limit placed on degree of parallelism
399	parallel_degree_policy	1	TRUE	FALSE	MANUAL		policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO/ADAPTIVE)
400	parallel_execution_message_size	1	TRUE	FALSE	16384		message buffer size for parallel execution
401	parallel_force_local	1	TRUE	FALSE	FALSE		force single instance execution
402	parallel_instance_group	1	TRUE	FALSE			instance group to use for all parallel operations
403	parallel_max_servers	1	TRUE	FALSE	1		maximum parallel query servers per instance
404	parallel_min_degree	1	TRUE	FALSE	1		controls the minimum DOP computed by Auto DOP
405	parallel_min_percent	1	TRUE	FALSE	0		minimum percent of threads required for parallel query
406	parallel_min_servers	1	TRUE	FALSE	1		minimum parallel query servers per instance
407	parallel_min_time_threshold	1	TRUE	FALSE	AUTO		threshold above which a plan is a candidate for parallelization (in seconds)
408	parallel_servers_target	1	TRUE	FALSE	1		instance target in terms of number of parallel servers
409	parallel_threads_per_cpu	1	TRUE	FALSE	1		number of parallel execution threads per CPU
410	paranoid_concurrency_mode	1	TRUE	FALSE	FALSE		Enable strictly durable query data gets
411	pdb_file_name_convert	0	TRUE	FALSE			PDB file name convert patterns and strings for create cdb/pdb
412	pdb_lockdown	0	TRUE	FALSE			pluggable database lockdown profile
413	pdb_os_credential	0	TRUE	FALSE			pluggable database OS credential to bind
414	pdb_template	0	TRUE	FALSE			PDB template
415	pdc_file_size	1	TRUE	FALSE	2101248	2052K	size (in bytes) of the pmem direct commit file
416	permit_92_wrap_format	1	TRUE	FALSE	FALSE		allow 9.2 or older wrap format in PL/SQL
417	pga_aggregate_limit	1	TRUE	FALSE	2147483648	2G	limit of aggregate PGA memory for the instance or PDB
418	pga_aggregate_target	1	FALSE	FALSE	536870912	512M	Target size for the aggregate PGA memory consumed by the instance
419	pkcs11_library_location	1	TRUE	FALSE			PKCS#11 library location for Transparent Data Encryption
420	plscope_settings	1	TRUE	FALSE	IDENTIFIERS:NONE		plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier and SQL statement data
421	plsql_ccflags	1	TRUE	FALSE			PL/SQL ccflags
422	plsql_code_type	1	TRUE	FALSE	INTERPRETED		PL/SQL code-type
423	plsql_debug	1	TRUE	FALSE	FALSE		PL/SQL debug
424	plsql_function_dynamic_stats	1	TRUE	FALSE	PREFERENCE		Perform Dynamic Sampling for PL/SQL functions
425	plsql_implicit_conversion_bool	1	TRUE	FALSE	FALSE		PL/SQL: Implicit conversion for boolean
426	plsql_optimize_level	1	TRUE	FALSE	2		PL/SQL optimize level
427	plsql_v2_compatibility	1	TRUE	FALSE	FALSE		PL/SQL version 2.x compatibility flag
428	plsql_warnings	1	TRUE	FALSE	DISABLE:ALL		PL/SQL compiler warnings settings
429	pmem_filestore	0	TRUE	FALSE			Persistent Memory Filestore list
430	pre_page_sga	1	TRUE	FALSE	TRUE		pre-page sga for process
431	priority_txns_high_wait_target	1	TRUE	FALSE	2147483647		Auto abort wait for high pri txns
432	priority_txns_medium_wait_target	1	TRUE	FALSE	2147483647		Auto abort wait for medium pri txns
433	priority_txns_mode	1	TRUE	FALSE	ROLLBACK		Modes for Priority Transactions feature
434	private_temp_table_prefix	1	TRUE	FALSE	ORA$PTT_		Private temporary table prefix
435	processes	1	FALSE	FALSE	200		user processes
436	processor_group_name	0	TRUE	FALSE			Name of the processor group that this instance should run in.
437	query_rewrite_enabled	1	TRUE	FALSE	TRUE		allow rewrite of queries using materialized views if enabled
438	query_rewrite_integrity	1	TRUE	FALSE	enforced		perform rewrite using materialized views with desired integrity
439	rdbms_server_dn	1	TRUE	FALSE			RDBMS's Distinguished Name
440	read_only	1	TRUE	FALSE	FALSE		Restrict WRITE operations in user session
441	read_only_open_delayed	1	TRUE	FALSE	FALSE		if TRUE delay opening of read only files until first access
442	recovery_parallelism	1	TRUE	FALSE	0		number of server processes to use for parallel recovery
443	recyclebin	1	TRUE	FALSE	on		recyclebin processing
444	redo_transport_user	1	TRUE	FALSE			Data Guard transport user when using password file
445	remote_dependencies_mode	1	TRUE	FALSE	TIMESTAMP		remote-procedure-call dependencies mode parameter
446	remote_listener	0	TRUE	FALSE			remote listener
447	remote_login_passwordfile	1	FALSE	FALSE	EXCLUSIVE		password file usage parameter
448	remote_os_roles	1	TRUE	FALSE	FALSE		allow non-secure remote clients to use os roles
449	remote_recovery_file_dest	1	TRUE	FALSE			default remote database recovery file location for refresh/relocate
450	replication_dependency_tracking	1	TRUE	FALSE	TRUE		tracking dependency for Replication parallel propagation
451	resource_limit	1	TRUE	FALSE	TRUE		master switch for resource limit
452	resource_manage_goldengate	1	TRUE	FALSE	FALSE		goldengate resource manager enabled
453	resource_manager_cpu_allocation	1	TRUE	FALSE	0		Resource Manager CPU allocation
454	resource_manager_cpu_scope	1	TRUE	FALSE	INSTANCE_ONLY		scope of CPU resource management
455	resource_manager_plan	1	TRUE	FALSE			resource mgr top plan
456	result_cache_auto_blocklist	1	TRUE	FALSE	ON		whether to run the auto blocklisting algorithm
457	result_cache_execution_threshold	1	TRUE	FALSE	2		minimum executions before a PL/SQL function is cached
458	result_cache_integrity	1	TRUE	FALSE	TRUSTED		result cache deterministic PLSQL functions
459	result_cache_max_result	1	TRUE	FALSE	5		maximum result size as percent of cache size
460	result_cache_max_size	1	TRUE	FALSE	8126464	7936K	maximum amount of memory to be used by the cache
461	result_cache_max_temp_result	1	TRUE	FALSE	5		maximum temp per result as percent of total temp for result cache
462	result_cache_max_temp_size	1	TRUE	FALSE	81264640	79360K	maximum amount of temp space to be used
463	result_cache_mode	1	TRUE	FALSE	MANUAL		result cache operator usage mode
464	result_cache_remote_expiration	1	TRUE	FALSE	0		maximum life time (min) for any result using a remote object
465	resumable_timeout	1	TRUE	FALSE	0		set resumable_timeout
466	rman_restore_file_storage_metadata	1	TRUE	FALSE	FALSE		restore file's storage metadata
467	rollback_segments	0	TRUE	FALSE			undo segment list
468	run_addm_for_awr_report	1	TRUE	FALSE	NONE		types of AWR snapshots for which ADDM can be run inside AWR report
469	saga_hist_retention	1	TRUE	FALSE	43200		default value for retention of completed sagas
470	scheduler_follow_pdbtz	1	TRUE	FALSE	FALSE		Make scheduler objects follow PDB TZ
471	sec_max_failed_login_attempts	1	TRUE	FALSE	3		maximum number of failed login attempts on a connection
472	sec_protocol_error_further_action	1	TRUE	FALSE	(DROP,3)		TTC protocol error continue action
473	sec_protocol_error_trace_action	1	TRUE	FALSE	TRACE		TTC protocol error action
474	sec_return_server_release_banner	1	TRUE	FALSE	FALSE		whether the server retruns the complete version information
475	serial_reuse	1	TRUE	FALSE	disable		reuse the frame segments
476	service_names	1	TRUE	FALSE	FREE		service names supported by the instance
477	session_cached_cursors	1	TRUE	FALSE	50		Number of cursors to cache in a session.
478	session_exit_on_package_state_error	1	TRUE	FALSE	FALSE		Request client to exit when PL/SQL package state is discarded
479	session_max_open_files	1	TRUE	FALSE	10		maximum number of open files allowed per session
480	sessions	1	TRUE	FALSE	322		user and system sessions
481	sga_max_size	1	FALSE	FALSE	1577058304	1504M	max total SGA size
482	sga_min_size	1	TRUE	FALSE	0		Minimum, guaranteed size of PDB's SGA
483	sga_target	1	FALSE	FALSE	0		Target size of SGA
484	shadow_core_dump	1	TRUE	FALSE	partial		Core Size for Shadow Processes
485	shard_apply_max_memory_size	1	TRUE	FALSE	0		SNR Apply max memory size in bytes
486	shard_enable_raft_follower_read	1	TRUE	FALSE	FALSE		enable read from follower replications units in a shard
487	shard_queries_restricted_by_key	1	TRUE	FALSE	FALSE		add shard key predicates to the query
488	shard_raft_logfile_size	1	TRUE	FALSE	1073741824	1G	size of raft log file in byte
489	shared_memory_address	1	TRUE	FALSE	0		SGA starting address (low order 32-bits on 64-bit platforms)
490	shared_pool_reserved_size	1	TRUE	FALSE	35232153		size in bytes of reserved area of shared pool
491	shared_pool_size	1	TRUE	FALSE	0		size in bytes of shared pool
492	shared_server_sessions	0	TRUE	FALSE			max number of shared server sessions
493	shared_servers	1	FALSE	FALSE	0		number of shared servers to start up
494	shrd_dupl_table_refresh_rate	1	TRUE	FALSE	60		duplicated table refresh rate (in seconds)
495	skip_unusable_indexes	1	TRUE	FALSE	TRUE		skip unusable indexes if set to TRUE
496	smtp_out_server	0	TRUE	FALSE			utl_smtp server and port configuration parameter
497	soda_behavior	1	TRUE	FALSE			control soda behaviors
498	sort_area_retained_size	1	TRUE	FALSE	0		size of in-memory sort work area retained between fetch calls
499	sort_area_size	1	TRUE	FALSE	65536		size of in-memory sort work area
500	spatial_vector_acceleration	1	FALSE	FALSE	TRUE		enable spatial vector acceleration
501	spfile	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/dbs/spfileFREE.ora		server parameter file
502	sql92_security	1	TRUE	FALSE	TRUE		require select privilege for searched update/delete
503	sql_error_mitigation	1	TRUE	FALSE	on		enables automatic error mitigation
504	sql_history_enabled	1	TRUE	FALSE	FALSE		SQL Query History is enabled when TRUE
505	sql_trace	1	TRUE	FALSE	FALSE		enable SQL trace
506	sql_transpiler	1	TRUE	FALSE	OFF		Enable SQL transpiler
507	sqltune_category	1	TRUE	FALSE	DEFAULT		Category qualifier for applying hintsets
508	ssl_wallet	0	TRUE	FALSE			ssl_wallet
509	standby_db_preserve_states	1	TRUE	FALSE	NONE		Preserve state cross standby role transition
510	standby_file_management	1	TRUE	FALSE	MANUAL		if auto then files are created/dropped automatically on standby
511	standby_pdb_source_file_dblink	0	TRUE	FALSE			database link to standby source files
512	standby_pdb_source_file_directory	0	TRUE	FALSE			standby source file directory location
513	star_transformation_enabled	1	TRUE	FALSE	FALSE		enable the use of star transformation
514	statement_redirect_service	1	TRUE	FALSE			statement redirect service
515	statistics_level	1	TRUE	FALSE	TYPICAL		statistics level
516	streams_pool_size	1	TRUE	FALSE	0		size in bytes of the streams pool
517	sysdate_at_dbtimezone	1	TRUE	FALSE	FALSE		use DB timezone while computing sysdate and systimestamp value
518	tablespace_encryption	1	TRUE	FALSE	MANUAL_ENABLE		Tablepsace encryption in hybrid ADG
519	tablespace_encryption_default_algorithm	1	TRUE	FALSE	AES256		default tablespace encryption block cipher mode
520	tablespace_encryption_default_cipher_mode	1	TRUE	FALSE	XTS		default tablespace encryption block cipher mode
521	tape_asynch_io	1	TRUE	FALSE	TRUE		Use asynch I/O requests for tape devices
522	target_pdbs	1	TRUE	FALSE	2		Parameter is a hint to adjust certain attributes of the CDB
523	tde_configuration	1	TRUE	FALSE			Per-PDB configuration for Transparent Data Encryption
524	tde_key_cache	1	TRUE	FALSE	FALSE		Enable caching of TDE intermediate key
525	temp_undo_enabled	1	TRUE	FALSE	FALSE		is temporary undo enabled
526	thread	1	TRUE	FALSE	0		Redo thread to mount
527	threaded_execution	1	TRUE	FALSE	FALSE		Threaded Execution Mode
528	time_at_dbtimezone	1	TRUE	FALSE	off		use DB timezone when computing current time
529	timed_os_statistics	1	TRUE	FALSE	0		internal os statistic gathering interval in seconds
530	timed_statistics	1	TRUE	FALSE	TRUE		maintain internal timing statistics
531	timezone_version_upgrade_integrity	1	TRUE	FALSE	enforced		perform DST upgrade leveraging constraints with desired integrity
532	timezone_version_upgrade_online	1	TRUE	FALSE	FALSE		enable/disable time zone version upgrade online
533	trace_enabled	1	TRUE	FALSE	TRUE		enable in memory tracing
534	tracefile_content_classification	1	TRUE	FALSE	DEFAULT		enable output of trace record security label prefix
535	tracefile_identifier	0	TRUE	FALSE			trace file custom identifier
536	transaction_recovery	1	TRUE	FALSE	ENABLED		Transaction recovery is enabled when set to ENABLED
537	transactions	1	TRUE	FALSE	354		max. number of concurrent active transactions
538	transactions_per_rollback_segment	1	TRUE	FALSE	5		number of active transactions per rollback segment
539	true_cache	1	TRUE	FALSE	FALSE		Enable True Cache
540	true_cache_config	1	TRUE	FALSE			True cache config
541	txn_auto_rollback_high_priority_wait_target	1	TRUE	FALSE	2147483647		Auto abort wait for high pri txns
542	txn_auto_rollback_medium_priority_wait_target	1	TRUE	FALSE	2147483647		Auto abort wait for medium pri txns
543	txn_auto_rollback_mode	1	TRUE	FALSE	ROLLBACK		Modes for Priority Transactions feature
544	txn_priority	1	TRUE	FALSE	HIGH		Priority of a transaction in a session
545	undo_management	1	TRUE	FALSE	AUTO		instance runs in SMU mode if TRUE, else in RBU mode
546	undo_retention	1	TRUE	FALSE	900		undo retention in seconds
547	undo_tablespace	1	FALSE	FALSE	UNDOTBS1		use/switch undo tablespace
548	unified_audit_common_systemlog	0	TRUE	FALSE			Syslog facility and level for only common unified audit records
549	unified_audit_systemlog	1	TRUE	FALSE			Syslog facility and level for Unified Audit
550	unified_audit_trail_exclude_columns	1	TRUE	FALSE	NONE		Exclude columns from unified_audit_trail
551	uniform_log_timestamp_format	1	TRUE	FALSE	TRUE		use uniform timestamp formats vs pre-12.2 formats
552	use_dedicated_broker	1	TRUE	FALSE	NONE		Use dedicated connection broker
553	use_large_pages	1	TRUE	FALSE	TRUE		Use large pages if available (TRUE/FALSE/ONLY)
554	user_dump_dest	1	TRUE	FALSE	/opt/oracle/product/23ai/dbhomeFree/rdbms/log		User process dump directory
555	vector_index_neighbor_graph_reload	1	TRUE	FALSE	RESTART		specifies whether HNSW reload is enabled
556	vector_memory_size	1	TRUE	FALSE	0		size in bytes of vector memory area
557	vector_query_capture	1	TRUE	FALSE	ON		Specifies whether vector query capture is enabled
558	wallet_root	1	TRUE	FALSE			wallet root instance initialization parameter
559	workarea_size_policy	1	TRUE	FALSE	AUTO		policy used to size SQL working areas (MANUAL/AUTO)
560	xml_client_side_decoding	1	TRUE	FALSE	true		enable/disable xml client-side decoding
561	xml_db_events	1	TRUE	FALSE	enable		are XML DB events enabled
562	xml_handling_of_invalid_chars	1	TRUE	FALSE	raise_error		Handle invalid chars during xmlelement
563	xml_params	1	TRUE	FALSE			Parameters to alter xml behavior

Index Contention

Index Contention details from Active Session History

ASH by Plan

Active Session History by execution plan

ASH by Plan Line

Active Session History by plan line

ASH by Plan (in Memory)

Active Session History Information related to the query

ASH by Plan Line (in Memory)

Active Session History by execution plan line

Peeked vs Monitored Bind Values - In Memory

In memory information about the Peeked Binds

Peeked vs Captured Bind Values - In Memory

In memory information about Captured Binds

Peeked vs Captured Bind Values - AWR

AWR information about Peeked and Captured Binds

SQL Report SQLID: 995w9d8jrc6my Report Date: 07-AUG-25 07:50

PLANS GLOBAL CURSOR SHARING AND BINDS

TABLES INDEXES ACTIVE SESSION HISTORY(ASH)

MISCELLANEOUS AUTO TASKS OVERVIEW

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section

No data was found for this section