User Environment Parameters

Use the following examples and documentation to find database environmental information.

-- find current database.

select sys_context('USERENV', 'DB_NAME') from dual;

Use the following documentation to find a full list of parameters.

SYS_CONTEXT ORACLE DOCUMENTATION

PLSQL and MAIL

Use the following plsql package to use internal plsql packages to send emails.

NOTE:
You need to ensure the domain and mail servers are updated.

demo_mail.sql

Oracle Support Notices

oracle unsupported notice for database 9.2

Resumable Space Allocation

Privileges Required

To allow a user to enable resumable at the session level --> grant resumable to
To allow all sessions to have resumable setup -->

Setting Up Resumable Statements at Session level

alter session enable resumable;
alter session enable resumable timeout
alter session enable resumable timeout name 'some descriptive name'

… run the sql …

alter session disable resumable;

Resumable Space Allocation Documentation

DBA_RESUMABLE VIEW DEFINITION
DBMS_RESUMABLE PACKAGE DEFINITION
MANAGING RESUMABLE SPACE ALLOCATION
PSOUG Resumable Space Management