Data Dictionary on Netezza

The data dictionary view on netezza are name as _V_*

For example:

_V_GROUP
_V_TABLE
_V_RELATION_COLUMN
_V_GROUPUSERS
_V_VIEW

To describe a table or view, use \d

SYSTEM(ADMIN)-> \d _V_GROUP
                             View "_V_GROUP"
      Attribute      |          Type          | Modifier | Default Value
---------------------+------------------------+----------+---------------
 OBJID               | OID                    |          |
 GROUPNAME           | NAME                   |          |
 OWNER               | NAME                   |          |
 CREATEDATE          | ABSTIME                |          |
 ROWLIMIT            | INTEGER                |          |
 SESSIONTIMEOUT      | INTEGER                |          |
 QUERYTIMEOUT        | INTEGER                |          |
 DEF_PRIORITY        | NAME                   |          |
 MAX_PRIORITY        | NAME                   |          |
 OBJDELIM            | BOOLEAN                |          |
 GRORSGPERCENT       | INTEGER                |          |
 RSGMAXPERCENT       | INTEGER                |          |
 CROSS_JOINS_ALLOWED | CHARACTER VARYING(255) |          |
 COLLECTHISTORY      | INTEGER                |          |
 ACCESSTIME          | INTEGER                |          |
 CONCURRENTSESS      | INTEGER                |          |
 JOBMAX              | INTEGER                |          |


Sources
http://wirewoods.wikidot.com/netezza-metadata-queries

AWR scripts

Questi script sono gli awr di un database 10.2:

/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrddinp.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrddrpi.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrddrpt.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrextr.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrinfo.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrinpnm.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrinput.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrload.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrrpt.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrrpti.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrsqrpi.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/awrsqrpt.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/catawrtb.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/catawrvw.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/catnoawr.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/dbmsawr.sql
/sbrdbms/app/oracle/product/10.2.0/db_rac/rdbms/admin/prvtawr.plb