Oracle Handling unified auditing spillover files on the standby-site 08.01.2021 by Clemens Bleile Switching to Oracle Unified Auditing may produce lots of data when e.g. auditing activities of the SYS-user. I.e. according the documentation you can do the following to audit similarly as in traditional auditing with audit_sys_operations=TRUE: SQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS(…)
Oracle Automatic column formatting in Oracle sqlplus 05.10.2020 by Clemens Bleile Column formatting was always a pain in sqlplus when writing queries on the prompt. Most people use tools like SQL Developer or Quest TOAD which can scroll horizontally when running queries against a database, but as a consultant you are(…)
Oracle Oracle DML (DELETE) and the Index Clustering Factor 24.09.2020 by Clemens Bleile As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but(…)
Oracle Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics? 07.08.2020 by Clemens Bleile In a recent project we migrated an Oracle database previously running on 12.1.0.2 on an Oracle Database Appliance to an Exadata X8 with DB version 19.7. Shortly after the migration a merge-statement (upsert) failed with an ORA-07445: exception encountered:(…)
Oracle Oracle ASH SQL_PLAN_LINE_ID in adaptive plans 20.07.2020 by Clemens Bleile There are several methods to find out where time is spent in an execution plan of a query running in an Oracle database. Classical methods like SQL Trace and running a formatter tool like tkprof on the raw trace, or(…)
Oracle DB-Upgrade hangs in SE2 waiting on Streams AQ while gathering statistics on LOGMNR-Tables 05.06.2020 by Clemens Bleile A couple of weeks ago I upgraded an Oracle Standard Edition 2 test database from 12.1.0.2 to 12.2.0.1 (with the April 2020 Patch Bundle) on Windows. Recently I upgraded the production database. Both upgrades were done with the Database Upgrade(…)
Oracle Functions in SQL with the Multitenant Containers Clause 03.06.2020 by Clemens Bleile By Clemens Bleile To prepare a presentation about Multitenant Tuning I wanted to see the METHOD_OPT dbms_stats global preference of all my pluggable DBs. In this specific case I had 3 PBDs called pdb1, pdb2 and pdb3 in my CDB.
Oracle Handle DB-Links after Cloning an Oracle Database 09.05.2020 by Clemens Bleile By Clemens Bleile After cloning e.g. a production database into a database for development or testing purposes, the DBA has to make sure that no activities in the cloned database have an impact on data in other production databases. Because(…)
Oracle Starting an Oracle Database when a first connection comes in 09.04.2020 by Clemens Bleile To save resources I thought about the idea to start an Oracle database automatically when a first connection comes in. I.e. if there are many smaller databases on a server, which are not required during specific times, then we may(…)
Oracle Cleanup a failed Oracle XE installation on Linux Mint 08.04.2020 by Clemens Bleile On this Blog I described on how to install Oracle XE on a current Linux Mint version (19.3. Tricia when writing the Blog). After the conversion of the Oracle provided rpm to a deb installation file with the tool(…)