SAP ABAP Class CL_ORA_DATABASE (ORA: Current Database)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DBA_DISTRIBUTED_DATABASE	DBA Cockpit: Distributed Database Object	20050622

Properties

Class	CL_ORA_DATABASE
Short Description	ORA: Current Database
Super Class	CL_DBA_DISTRIBUTED_DATABASE	DBA Cockpit: Distributed Database Object
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	S_ORA_COCKPIT	DBACockpit: Oracle Monitors
Created	20050622	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_ORA_DATABASE has no interface implemented.

Friends

Class CL_ORA_DATABASE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	DBMS_ADVISOR_PRIVS	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL		Execute privilege dbms_advisor	20110105
2	DBMS_WL_REPOSITORY_PRIV	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL		Execute privilege dbms_workload_repository	20110105
3	DB_ID	Instance attribute	Public	☐	Type reference (TYPE)	ORA_DBID		Oracle monitoring: database id	20080122
4	DB_START_DATE	Instance attribute	Public	☐	Type reference (TYPE)	CHAR08		Date of Database startup	20080124
5	DB_START_TIME	Instance attribute	Public	☐	Type reference (TYPE)	CHAR08		Time of Database startup	20080124
6	FORCE_SHOW_EXPLAIN	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	Force Show Explain in DBA Cockpit	20130418
7	NODES_LIST_INSTNM	Instance attribute	Public	☑	Type reference (TYPE)	RAC_NODE_ORA_T		List of RAC nodes with instancename	20070320
8	NO_DIAG_PACKAGE	Instance attribute	Public	☑	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	DIAG Package not used	20080403
9	NO_SCHEMA_USER	Instance attribute	Public	☑	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	User not equal SAP schema	20080903
10	SELECT_ANY_TABLE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL		SELECT ANY TABLE Privilege	20101216

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_DBMS_ADVISOR_PRIV	Instance method	Private	Method	Check execute privilege for dbms_advisor	20110105
2	CHECK_DBMS_WL_REPOSITORY_PRIV	Instance method	Private	Method	Check execute privilege for dbms_workload_repository	20110105
3	CHECK_DIAG_PACKAGE	Instance method	Private	Method	Check diagnostic package	20080403
4	CHECK_FORCE_SHOW_EXPLAIN	Instance method	Private	Method	Set Explain Flag	20130418
5	CHECK_PARALLEL_MIN_SERVERS	Instance method	Private	Method	Check preconditions (parallel_min_servers >= 10 on RAC)	20060321
6	CHECK_SELECT_ANY_TABLE	Instance method	Private	Method	Check if current user has SELECT ANY TABLE Privilege	20101216
7	CHECK_USER	Instance method	Private	Method	Check if dbcon user not equal schema	20080903
8	GET_DB_ID	Instance method	Private	Method	Get database IDx	20080122
9	GET_ROLES	Instance method	Private	Method	Get roles assigned to a user	20110105
10	GET_UTC_TIMEZONE_DIFF	Instance method	Private	Method	Get difference in sec between utc time and time	20120821

Events

Class CL_ORA_DATABASE has no event.

Types

Class CL_ORA_DATABASE has no local type.

Method Signatures

Method CHECK_DBMS_ADVISOR_PRIV Signature

Method CHECK_DBMS_ADVISOR_PRIV on class CL_ORA_DATABASE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110105

Method CHECK_DBMS_WL_REPOSITORY_PRIV Signature

Method CHECK_DBMS_WL_REPOSITORY_PRIV on class CL_ORA_DATABASE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110105

Method CHECK_DIAG_PACKAGE Signature

Method CHECK_DIAG_PACKAGE on class CL_ORA_DATABASE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20080403

Method CHECK_FORCE_SHOW_EXPLAIN Signature

Method CHECK_FORCE_SHOW_EXPLAIN on class CL_ORA_DATABASE has no parameter.
Method CHECK_FORCE_SHOW_EXPLAIN on class CL_ORA_DATABASE has no exception.

Method CHECK_PARALLEL_MIN_SERVERS Signature

Method CHECK_PARALLEL_MIN_SERVERS on class CL_ORA_DATABASE has no parameter.
Method CHECK_PARALLEL_MIN_SERVERS on class CL_ORA_DATABASE has no exception.

Method CHECK_SELECT_ANY_TABLE Signature

Method CHECK_SELECT_ANY_TABLE on class CL_ORA_DATABASE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20101220

Method CHECK_USER Signature

Method CHECK_USER on class CL_ORA_DATABASE has no parameter.
Method CHECK_USER on class CL_ORA_DATABASE has no exception.

Method GET_DB_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080122

Method GET_DB_ID on class CL_ORA_DATABASE has no exception.

Method GET_ROLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_ROLES	Call by reference	☐	Type reference (TYPE)	STRING		string containing the assigned roles	20110105

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110105

Method GET_UTC_TIMEZONE_DIFF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	DIFF	Value transfer	☐	Type reference (TYPE)	I			20120821

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20120821

History

Last changed by/on	SAP	20130531
SAP Release Created in	710