tablespace This column is not applicable in Hologres. hasindexes The value is true if the table has or had an index. hasrules The value is true if the table has or had a rule. hastriggers The value is true if th
Required privileges to access system tables and views By defaultPUBLIChasSELECTprivileges on various system tables and views andEXECUTEprivileges on various PL/SQL objects. You can see the list of objects by using this query: SELECT * FROM sys.dba_tab_privs WHERE grantee='PUBLIC'; TheADMINorSEL...
tablespace_files: Information about files used by tablespaces. tablespaces: Information about active tablespaces. triggers: Information about triggers. view_routine_usage: Information about dependencies between views and stored functions used by them. ...
Description: Gets SQL name of a data type.Return type: textNote:format_type returns the SQL name of a data type that is identified by its type OID and possibly a type mod
The increment size (in megabytes) for extending the size of an auto-extending InnoDB system tablespace file when it becomes full. The default value is 64. For related information, see System Tablespace Data File Configuration, and Resizing the System Tablespace. The innodb_autoextend_increment set...
The latter stages of the full-text search are handled in memory, and limiting this prevents excess memory usage. If the limit is exceeded, the query returns an error. Commandline: --innodb-ft-result-cache-limit=# Scope: Global Dynamic: Yes Data Type: numeric Default Value: ...
See Table and Tablespace Encryption. Commandline: --encryption-algorithm=value Scope: Global Dynamic: No Data Type: enum Default Value: none Valid Values: none, aes_ecb, aes_cbc, aes_ctr Introduced: MariaDB 10.1.3 Removed: MariaDB 10.1.4 ...
• tablespace_files: Information about files used by tablespaces. • tablespaces: Information about active tablespaces. • triggers: Information about triggers. • view_routine_usage: Information about dependencies between views and stored functions used by them. ...
UNDO_TABLESPACE specifies the undo tablespace to be used when an instance starts up. If this parameter is specified when the instance is in manual undo management mode, an error will occur and startup will fail. USE_STORED_OUTLINES Syntax: USE_STORED_OUTLINES = { TRUE | FALSE | category...
Tablespace size The group server name depends on the group name to which the server is added. Core Usage report The Core Usage report provides detailed information about the number of cores specific to: Server type Database version Platform and group name ...