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 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 the table has or had a trigger. ...
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. ...
For related information, see System Tablespace Data File Configuration, and Resizing the System Tablespace. The innodb_autoextend_increment setting does not affect file-per-table tablespace files or general tablespace files. These files are auto-extending regardless of the innodb_autoextend_increment ...
ViewtheExhibitandexaminethepropertiesoftheTTtablespace.UsingDatabaseControl,youhaveschedul edajobtoshrinktheTRANStableresidingontheTTtablespace.Thejobwouldrunat5:00p.m.everyFriday.Whenyouexaminethespaceusageofthetableafterthecompletionofthejob,youfindthatthetablehasnotbeenshrunk.Whatcouldhavebeenthereasonforthis...
ship_mode_t1 USING psort (sm_ship_mode_sk) TABLESPACE pg_default (1 row) SELECT * FROM pg_get_indexdef(136035,1,false); pg_get_indexdef --- sm_ship_mode_sk (1 row) pg_get_keywords() Description: Gets list of SQL keywords and their categories. Return type: SETOF record Note: ...
PG_THREAD_WAIT_STATUS allows you to test the block waiting status about the backend thread and auxiliary thread of the current instance.The waiting statuses in the wait_s
A tablespace is a unit of storage within the database that you can administer as a logical subset of the total storage. Individual objects and subobjects may be allocated to individual tablespaces. Each database includes multiple tablespaces. In Sybase IQ 15.3, a dbspace is a tablespace that ...
When you query theV$BLOCK_INFOview, TimesTen returns data for the database to which your application is connected. Ignore theelementIdcolumn. Command> SELECT * FROM V$BLOCK_INFO; TOTALBLOCKS, FREEBLOCKS, FREEBYTES, LARGESTFREE, ELEMENTID ...
Information about the first three undo zones with the maximum usage. The output format is as follows: zoneId1: used size of zone 1. zoneId2: used size of zone 2. zoneId3: used size of zone 3. Output parameter curr_used_undo_size int Total size of the undo tablespace that is ...