DataGrip
 
Get DataGrip
You are viewing the documentation for an earlier version of DataGrip.

Oracle introspection levels

Last modified: 14 September 2023

Oracle users might experience a long introspection time if there are lots of objects (tables, schemas, databases, and so on). Introspection is the process of getting the metadata of the database, such as object names, types of columns, and source code. DataGrip uses this information to provide coding assistance, navigation, and search.

Oracle system catalogs are relatively slow, and the introspection is even slower if a user has no permissions for accessing fast catalogs.

Usually, for daily work and coding assistance, there is no need to load sources of all the objects. In many cases, just having database names will be sufficient for proper code completion and navigation. DataGrip has the following introspection levels:

Icons represent the introspection level: the more the pill is filled, the higher the level. Also, color matters: a blue icon means that the introspection level is set directly, grey means that it is inherited.