Oracle Connection Pooling in Django

I'd like to provide some information about Oracle database integration with Django based on the documentation.

Current Oracle Support in Django

Django currently supports Oracle Database Server versions 19c and higher, requiring version 1.3.2 or higher of the oracledb Python driver. It's worth noting that support for cx_Oracle is deprecated since Django 5.0.

Required Oracle Privileges

For Django users working with Oracle databases, the following privileges are required for basic operations:

• For running migrations (python manage.py migrate):

  • CREATE TABLE
  • CREATE SEQUENCE
  • CREATE PROCEDURE
  • CREATE TRIGGER

• Additional privileges needed for running test suites:

  • CREATE USER
  • ALTER USER
  • DROP USER
  • CREATE TABLESPACE
  • DROP TABLESPACE
  • CREATE SESSION WITH ADMIN OPTION
  • CREATE TABLE WITH ADMIN OPTION
  • CREATE SEQUENCE WITH ADMIN OPTION
  • CREATE PROCEDURE WITH ADMIN OPTION
  • CREATE TRIGGER WITH ADMIN OPTION

Some test suites may also require:

• CREATE VIEW WITH ADMIN OPTION
• CREATE MATERIALIZED VIEW WITH ADMIN OPTION

The Oracle database backend also requires execute permissions on:

SQLCopied
GRANT EXECUTE ON SYS.DBMS_LOB TO user;
GRANT EXECUTE ON SYS.DBMS_RANDOM TO user;

Testing the Connection Pooling Feature

Regarding the connection pooling feature you're inviting users to test, this would be a valuable addition to Django's Oracle support. Users who want to test this feature should ensure they have the proper privileges set up as outlined above.

For those interested in Oracle-specific testing configurations, Django 2.0 introduced settings that allow customizing test tablespace parameters:

• DATAFILE_SIZE
• DATAFILE_TMP_SIZE
• DATAFILE_EXTSIZE
• DATAFILE_TMP_EXTSIZE

These settings might be relevant when testing the new connection pooling functionality.