Proxy user as the name suggests provides the capability to login as another account without knowing the original password but can inherit its permission. Though this may sound a bit scary there might be some conditions where this...
Unified auditing released with 12c Oracle database provides audit solutions for a variety of sources. It provides a read-only table in AUDSYS schema in SYSAUX tablespace which should be changed to custom tablespace as a best...
Locked Account
Problem Statement Recently we have noticed global temporary tables (GTT) with the option “Preserve rows after commit” not working as expected post-migration to oracle 19c with the distributed transaction...
Internet is full of questions and queries about oracle database or DBA(database administrator) interview questions for fresher, intermediate and experienced administrator. There has been multiple blogs available on this but seems...
Problem Statement Sometimes, one may need to invalidate a statement i.e. flush execution plan for a SQL, for example because the current execution plan is not the right one (as consequence of bind variable peeking) and you...
Problem Statement Lately, there have been some questions post upgrading an oracle database from version 12c to 19c and moving to Multi-tenant architecture. One specific question catches attention, where a third-party...
Problem Statement Event Monitor Process in short called as EMON is generally used by oracle to send notification. Often applications uses Database Change Notification process also known as DBCN to be aware of changes in the...
To perform Session Level Tracing alter session set tracefile_identifier='10046'; alter session set timed_statistics = true; alter session set statistics_level=all; alter session set max_dump_file_size = unlimited; alter...
Securing infrastructure remains critical aspects for everyone and for DBA that also means securing the database. This not just mean to secure your data written on disk (Encryption at rest) but also to secure your data which flows...