Useful Oracle Queries

gistfile1.psql

# discover what programs are still connected to a db
select sid,serial#,program from v$session where username = '<your_schema>';

# and forcibly disconnect them
select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where username = '<your_schema>'

#Shutdown and restart cdb and pdb
shutdown;
#then
startup;
#then
startup pluggable database <service_name>;