System Tables Related to Database Operation

{question}

1. Do you have any dictionary tables/views which I can query from?

2. In Oracle we use v$session table so we can see all the sessions which are connected to the database.

{question}

{answer}

1. In NuoDB we keep that kind of information in the NuoDB SYSTEM schema. Originally they are used internally for NuoDB operations, however in many cases they can provide useful information to the NuoDB user. We keep more the 60 tables with useful information, you can review these tables in our documentation here.

To view them, you can type

SQL> SHOW TABLES;

or 

SQL> SELECT tablename, extends, type, cardinality
FROM SYSTEM.TABLES WHERE schema = 'SYSTEM';

2. In NuoDB we keep the connection information in SYSTEM.CONNECTIONS table;

SQL> SET OUTPUT VERTICAL
SQL> SELECT sqlstring, count, runtime, user, schema, 
numparam, params, connid, open, handle, nodeid, execid
FROM system.connections;
  • You can review the table's fields here.
  • In this case it's better to use SET OUTPUT VERTICAL because there are many columns in this table and it is more readable if displayed this way.

{answer}

Have more questions? Submit a request

Comments