sa_java_loaded_classes system procedure

Lists the classes currently loaded by the database Java virtual machine.

Syntax

sa_java_loaded_classes( )

Result set

Column name	Data type	Description
class_name	VARCHAR(512)	The name of a class currently loaded by the database Java virtual machine.

Remarks

Returns a result set containing all the names of the Java classes currently loaded by the database Java virtual machine.

When the virtual machine is first called, it loads a number of classes. If you call sa_java_loaded_classes without using any Java in the database features beforehand, it returns this set of classes.

The procedure can be useful to diagnose missing classes. It can also be used to identify which classes from a particular jar are used by a given application.

Permissions

DBA authority required

Side effects

None