Database Administration (MOSC)

MOSC Banner

db ideas for event triggers and pipes.

edited Aug 21, 2023 8:32PM in Database Administration (MOSC)

Hi,

I would like to share two ideas about Oracle Database. since there is no separated ideas lab for it, MOSC admin Margi guided me to open the thread in this category.

1- Logon, Startup, Shutdown triggers for PDB on CDB:

it would be nice to have logon, startup and shutdown triggers for PDBS on the CDB.

Let's say I want to take some actions on an after logon trigger on all PDBs in a CDB, I have to create (or add into an existing one) a logon trigger for every PDB and take the action. Since we can reach all sessions in CDB via v$session, it would be much more easier to have logon trigger that run for all pdbs in a cdb. that way we could isolate our codes from pdbs and we don't have to create same trigger on every pdb. it would be easier to maintain the code.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center