db ideas for event triggers and pipes.
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.