crc.js

const oracledb = require('oracledb');
const dbConfig = require('./dbconfig.js');

if (process.platform === 'darwin') {
  oracledb.initOracleClient({libDir: process.env.HOME + '/Downloads/instantclient_19_8'});
}

let result;

async function run() {

  try {
    const connection = await oracledb.getConnection(dbConfig);
    const systemconn = await oracledb.getConnection({user: 'system', password: 'oracle', connectString: dbConfig.connectString});


    // Setup schema

    const stmts = [
      `drop table crc_tab`,
      `create table crc_tab (id number)`,
      `insert into crc_tab values (1)`,
    ];

    for (const s of stmts) {
      try {
        await connection.execute(s, [], { autoCommit: true });
      } catch(e) {
        if (e.errorNum != 942)
          console.error(s, e);
      }
    }

    // Run some load

    const q = `select id from crc_tab`;
    const qc = `select /*+ result_cache */ id from crc_tab`;

    for (let i = 0; i < 100; i++) {
      result = await connection.execute(q);
      result = await connection.execute(qc);
    }

    // Compare behaviors

    const m = `select executions from v$sqlarea where sql_text = :q1`;

    result = await systemconn.execute(m, [q]);
    console.log('No CRC', result.rows[0][0], 'executions');

    result = await systemconn.execute(m, [qc]);
    console.log('CRC', result.rows[0][0], 'executions');

  } catch (err) {
    console.error(err);
  }
}

run();