{"id":15511,"date":"2021-01-08T16:57:31","date_gmt":"2021-01-08T15:57:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/"},"modified":"2021-01-08T16:57:31","modified_gmt":"2021-01-08T15:57:31","slug":"handling-unified-auditing-spillover-files-on-the-standby-site","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/","title":{"rendered":"Handling unified auditing spillover files on the standby-site"},"content":{"rendered":"

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:<\/p>\n

\nSQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS ACTIONS ALL ONLY TOPLEVEL;\nSQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS;\n<\/pre>\n
REMARK1: You may check the Blog on traditional SYS-auditing here<\/a>
\nREMARK2: Tests done in this Blog were done with Oracle 19.9. Auditing toplevel operations were not possible before 19c.<\/p>\n
With unified auditing all data is written in the database – except when there’s no possibility to write to the database. If the database is e.g. not open then spillover files are written to the OS. By default files with extension bin are written to $ORACLE_BASE\/audit\/$ORACLE_SID. <\/p>\n
REMARK: Container databases have a sub-directory per pluggable DB there, but all examples in this Blog are for a non-container-DB. <\/p>\n
E.g.<\/p>\n
\noracle@boda1:\/u01\/app\/oracle\/audit\/TISMED\/ [TISMED] ls -ltr | tail -10\n-rw-------. 1 oracle oinstall    6656 Jan  8 15:30 ora_audit_031.bin\n-rw-------. 1 oracle oinstall   98304 Jan  8 15:35 ora_audit_0251.bin\n-rw-------. 1 oracle oinstall    1536 Jan  8 15:57 ora_audit_0253.bin\n-rw-------. 1 oracle oinstall 3140096 Jan  8 15:57 ora_audit_019.bin\n-rw-------. 1 oracle oinstall    2048 Jan  8 15:57 ora_audit_0256.bin\n-rw-------. 1 oracle oinstall    3584 Jan  8 15:58 ora_audit_0252.bin\n-rw-------. 1 oracle oinstall    4096 Jan  8 15:58 ora_audit_0238.bin\n-rw-------. 1 oracle oinstall    2048 Jan  8 15:58 ora_audit_024.bin\n-rw-------. 1 oracle oinstall  314368 Jan  8 15:58 ora_audit_030.bin\n-rw-------. 1 oracle oinstall    2048 Jan  8 15:58 ora_audit_029.bin\noracle@boda1:\/u01\/app\/oracle\/audit\/TISMED\/ [TISMED] \n<\/pre>\n
You get an idea what’s in the files when doing a strings on them:<\/p>\n
\noracle@boda1:\/u01\/app\/oracle\/audit\/TISMED\/ [TISMED] strings ora_audit_030.bin | head -20\nANG Spillover Audit File\nORAAUDNG\noracle\nboda2.localdomain\npts\/0\n(TYPE=(DATABASE));(CLIENT ADDRESS=((ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.6)(PORT=18890))));\t\nPUBLIC\noracle@boda2.localdomain (TNS V1-V3)\n`)',\n26801\nSYSOPR\nPUBLIC:\nORAAUDNG\noracle\nboda2.localdomain\npts\/0\n(TYPE=(DATABASE));(CLIENT ADDRESS=((ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.6)(PORT=18892))));\t\nPUBLIC\noracle@boda2.localdomain (TNS V1-V3)\n26813\noracle@boda1:\/u01\/app\/oracle\/audit\/TISMED\/ [TISMED] \n<\/code><\/pre>\n
The data in the spillover-files are visible in the database when querying e.g. unified_audit_trail as the following simple example shows:<\/p>\n
\nSQL> select count(*) from unified_audit_trail;\n\n  COUNT(*)\n----------\n    237306\n\nSQL> !mv \/u01\/app\/oracle\/audit\/TISMED \/u01\/app\/oracle\/audit\/TISMED_tmp\n\nSQL> select count(*) from unified_audit_trail;\n\n  COUNT(*)\n----------\n    233816\n\nSQL> !mv \/u01\/app\/oracle\/audit\/TISMED_tmp \/u01\/app\/oracle\/audit\/TISMED\n\nSQL> select count(*) from unified_audit_trail;\n\n  COUNT(*)\n----------\n    237328\n\nSQL> \n<\/pre>\n
I.e. moving the spillover directory to a new name results in showing less data in UNIFIED_AUDIT_TRAIL. The view UNIFIED_AUDIT_TRAIL is a UNION ALL of the view v$unified_audit_trail and the table audsys.aud$unified (you may check $ORACLE_HOME\/rdbms\/admin\/catuat.sql on what the metadata of UNIFIED_AUDIT_TRAIL is). The data of the spillover-files comes from the view v$unified_audit_trail:<\/p>\n
\nSQL> select count(*) from v$unified_audit_trail;\n\n  COUNT(*)\n----------\n      3501\n\nSQL> select count(*) from audsys.aud$unified;\n\n  COUNT(*)\n----------\n    233845\n\nSQL> !mv \/u01\/app\/oracle\/audit\/TISMED \/u01\/app\/oracle\/audit\/TISMED_tmp\n\nSQL> select count(*) from v$unified_audit_trail;\n\n  COUNT(*)\n----------\n\t 0\n\nSQL> select count(*) from audsys.aud$unified;\n\n  COUNT(*)\n----------\n    233849\n\nSQL> !mv \/u01\/app\/oracle\/audit\/TISMED_tmp \/u01\/app\/oracle\/audit\/TISMED\n\nSQL> select count(*) from v$unified_audit_trail;\n\n  COUNT(*)\n----------\n      3501\n\nSQL> \n<\/pre>\n
Oracle provided the following possibility to load the data of the spillover-files into the database:<\/p>\n
\nSQL> exec DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES;\n<\/pre>\n
The issue I want to talk about in this blog are spillover files on standby databases. Standby databases are usually running in MOUNT-mode and hence are not writable. I.e. all audit-data produced on the standby-DBs go to spillover-files. If you haven’t switched over to the standby database for a while and loaded the spillover-files to the database then there could be quite a lot of data in the spillover-directory. I saw systems with e.g. 10GB of data in the spillover-directory, especially when doing rman-backups on the standby-site.<\/p>\n
That causes 3 issues:<\/p>\n
1.) If you move your audit data on your primary database to history tables then those history-tables may not contain the full truth, because audit-records of spillover-files on the standby-DBs are not visible in the history tables.
\n2.) After a switchover a query on unified_audit_trail may be very slow, because reading spillover-files is slower than reading from the database.
\n3.) Loading the spillover files after a switchover to the new primary database may take a long time and causes the SYSAUX-tablespace to grow significantly.<\/p>\n
So the question is: How to handle the spillover-files on the standby-DB?<\/p>\n
One possibility is to just remove them regularly on the OS if your security rules can afford to lose auditing data of standby-DBs. If that’s not possible then you may move the spillover-files regularly to a backup-location, so that you can restore those if necessary. The third alternative I’ve tested was to copy the spillover-files from the standy DB to the primary DB and load them there. That worked for me, but 2 things have to be considered:<\/p>\n
1. spillover-files are not unique over all DBs in data guard. I.e. don’t just copy files over to the primary. You have to move away the primnary spillover directory first and restore it when the data has been loaded.
\n2. The procedure is not documented and has to be confirmed by Oracle Support<\/p>\n
E.g. here the process to copy and load spillover-files from standby to primary and load them:<\/p>\n
1. Move away the primary spillover-folder <\/p>\n
\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n       239\n\nSQL> !mv \/u01\/app\/oracle\/audit\/${ORACLE_SID} \/u01\/app\/oracle\/audit\/${ORACLE_SID}_tmp\n\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n\t 0\n<\/pre>\n
2. Copy spillover-files from standby to primary<\/p>\n
\nSQL> !scp -p -r standby:\/u01\/app\/oracle\/audit\/${ORACLE_SID} \/u01\/app\/oracle\/audit\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n       101\n\nSQL> exec DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES;\n\nPL\/SQL procedure successfully completed.\n\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n\t24\n<\/pre>\n
–> Not all files were loaded. That’s normal.<\/p>\n
3. Backup the current spillover-directory and restore the original spillover-directory<\/p>\n
\nSQL> !mv \/u01\/app\/oracle\/audit\/${ORACLE_SID} \/u01\/app\/oracle\/audit\/${ORACLE_SID}_standby\n\nSQL> !mv \/u01\/app\/oracle\/audit\/${ORACLE_SID}_tmp \/u01\/app\/oracle\/audit\/${ORACLE_SID}\n\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n       239\n<\/pre>\n
4. Backup the spillover-folder on the standby-site. I.e. do the following command on the standby-host<\/p>\n
\nSQL> !mv \/u01\/app\/oracle\/audit\/${ORACLE_SID} \/u01\/app\/oracle\/audit\/${ORACLE_SID}_backup\n<\/pre>\n
5. Copy the remaining standby-files not loaded back to the standby host. I.e. do the following command on the standby-host<\/p>\n
\nSQL> !scp -p -r primary:\/u01\/app\/oracle\/audit\/${ORACLE_SID}_standby \/u01\/app\/oracle\/audit\/${ORACLE_SID}\nSQL> select count(*) from v$unified_audit_trail uview;\n\n  COUNT(*)\n----------\n\t24\n<\/pre>\n
REMARK: Above procedure is not 100% correct, because it doesn’t consider spillover-files produced while doing above steps. <\/p>\n
Summary: Many people with standby-DBs and Unified Auditing active may not have realized that there are potential issues with spillover-files at the standby-site. Those spillover files on standby have to be considered. The easiest method is to just remove them regularly on the OS if that has been approved by the security team.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 ACTIONS ALL ONLY TOPLEVEL; SQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS; REMARK1: You may check the […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[221,2231,2232,238,2233],"type_dbi":[],"class_list":["post-15511","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-data-guard","tag-primary","tag-spillover-files","tag-standby","tag-unified-auditing"],"acf":[],"yoast_head":"\nHandling unified auditing spillover files on the standby-site - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Handling unified auditing spillover files on the standby-site\" \/>\n<meta property=\"og:description\" content=\"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 ACTIONS ALL ONLY TOPLEVEL; SQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS; REMARK1: You may check the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-08T15:57:31+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Handling unified auditing spillover files on the standby-site\",\"datePublished\":\"2021-01-08T15:57:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\"},\"wordCount\":747,\"commentCount\":0,\"keywords\":[\"Data Guard\",\"primary\",\"spillover files\",\"Standby\",\"Unified Auditing\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\",\"name\":\"Handling unified auditing spillover files on the standby-site - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-01-08T15:57:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Handling unified auditing spillover files on the standby-site\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Handling unified auditing spillover files on the standby-site - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/","og_locale":"en_US","og_type":"article","og_title":"Handling unified auditing spillover files on the standby-site","og_description":"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 ACTIONS ALL ONLY TOPLEVEL; SQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS; REMARK1: You may check the […]","og_url":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/","og_site_name":"dbi Blog","article_published_time":"2021-01-08T15:57:31+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Handling unified auditing spillover files on the standby-site","datePublished":"2021-01-08T15:57:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/"},"wordCount":747,"commentCount":0,"keywords":["Data Guard","primary","spillover files","Standby","Unified Auditing"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/","url":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/","name":"Handling unified auditing spillover files on the standby-site - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-01-08T15:57:31+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/handling-unified-auditing-spillover-files-on-the-standby-site\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Handling unified auditing spillover files on the standby-site"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=15511"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15511\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15511"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}