Using Fast Recovery Area to let Oracle automatically manage the backup/flashback/recovery related files is very useful, but avoiding problems related with FRA free space shortage requires careful planning. There are several factors that have to be taken into account, apart from the most obvious like
DB_RECOVERY_FILE_DEST_SIZE parameter, there are some additional ones depending on the type of files stored. For example
_MINIMUM_DB_FLASHBACK_RETENTION) affecting flashback logs or archived logs deletion policy which is also taken into account while reclaimable files purging is done.
Continue reading “Fast Recovery Area space usage threshold”
Case-sensitive passwords were introduced in Oracle Database 11g, causing some misunderstanding and introducing quite a lot of annoying problems for DBAs, even though it was really required to bring level of Oracle’s security to 21st century standards ;). Since then, even more changes were introduced, including for example deprecation of
SEC_CASE_SENSITIVE_LOGON database parameter,
IGNORECASE argument of
ORAPWD tool or password file format change in 12c.
Continue reading “Redo Transport from Oracle 11.2 to 12.2 and SYS password case-sensitivity problems”
Recently I was working on migrating Oracle 220.127.116.11 database running on Windows, to new hardware infrastructure on Linux. This Oracle version is with us for quite a long time, plus migration from Windows to Linux is quite common (fortunately in that direction…;)), so when I got an error while trying to use Active Duplicate feature to create a standby database, I was quite sure I’ll be able to quickly find the solution either in MOS or elsewhere. Indeed, I found several blog posts with exactly the same error, but solution mentioned there was not working for me.
Continue reading “Migrating from Windows to Linux with Active Duplicate for standby – problem with 18.104.22.168”
Today I want to share with you another interesting example of solving performance problem which happened in the database used for Business Intelligence purposes. Users were complaining that the performance in kind of staging database (STGDB) was much better than the production one (PRDDB), even though the dataset was exactly the same.
Continue reading “Bloom filters and parallel execution”
How often did you have the situation when performance problem disappeared just after refreshing object statistics? Of course it is nice to solve the problem quickly and simply, but is always better to understand what has exactly happened.
Continue reading “Playing with statistics modification hints”
The last blog post of Jeff Smith (18.1 Features: SQL Injection Detection) about little, but nice feature of SQL Developer detecting if your PL/SQL code might be vulnerable for SQL Injection, reminded me about the presentation I’ve delivered during Oracle Tutorials at CERN in 2013.
Continue reading “Oracle Database Security For Developers”
If you have performance problems after migrating your BI databases from 22.214.171.124 to 126.96.36.199 or any other performance issue, you should not underestimate SQL Plan Notes, which can point you to the right direction or just let you understand what exactly is going on with your queries. Please check below how SQL Plan Notes helped me to investigate problem I recently encountered.
Continue reading “BI jobs performance degradation after Oracle 188.8.131.52 to 184.108.40.206 migration”