Oracle教程 2023-04-06

Oracle 视图 DBA_JOINGROUPS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_JOINGROUPS是一个系统视图，用于显示归档方式启用的连接组，以及连接组的属性。有些连接组是由Oracle Net Services管理的，这种连接组使用Oracle Net Services技术。Oracle视图DBA_JOINGROUPS可以用来显示这些连接组的信息，这包括名称、类型、属性、数据库实例名和其他信息。若要查看连接组的信息，可以使用Oracle视图DBA_JOINGROUPS并提供系统管理员或者数据库用户的账户进行查询，这种查询可以不受连接组成员范围的限制。另外，如果用途需要，也可以通过使用Oracle视图DBA_JOINGROUPS来查看特定连接组的信息，以供进一步处理。

官方英文解释

DBA_JOINGROUPS describes join groups in the database. A join group is a user-created object that consists of two or more columns that can be meaningfully joined. The maximum number of columns that can be included in a join group is 255.

In certain queries, join groups enable the database to eliminate the performance overhead of decompressing and hashing column values. Join groups require an In-Memory column store (IM column store).

Related View

USER_JOINGROUPS describes join groups belonging to the user. This view does not display the JOINGROUP_OWNER column.

Column	Datatype	NULL	Description
`JOINGROUP_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Join group owner. This is the user that created the join group.
`JOINGROUP_NAME`	`VARCHAR2(128)`	`NOT NULL`	This is the user specified name of the join group. The join group name is specified when the join group is created as part of the `CREATE INMEMORY JOIN GROUP` statement.
`TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Table owner
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Table name
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Column name
`FLAGS`	`VARCHAR2(6)`		Possible values: `MASTER`: Indicates which column in the join group is mastering the global dictionary. A join group is a group of columns sharing a global dictionary; the global dictionary is associated with one column and the other columns share the same dictionary. The column with which the global dictionary is associated is called the mastering column. NULL: Indicates that the column is not mastering the global dictionary.
`GD_ADDRESS`	`RAW(8)`		The memory address of the global dictionary. Ideally, all the columns in one join group should have the same global dictionary address (that is, they share the same global structure). This might not always be the case (for example, a column might be added to a join group after it was populated into memory – in which case its `GD_ADDRESS` field will be NULL). In such cases, you should force re-populate the tables that are part of the join group and check the views after the repopulates complete.

本站中文解释

官方英文解释

相关推荐