{"id":10131,"date":"2017-05-25T06:10:19","date_gmt":"2017-05-25T04:10:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/"},"modified":"2017-05-25T06:10:19","modified_gmt":"2017-05-25T04:10:19","slug":"you-do-use-the-oracle-trace-file-analyzer-dont-you","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/","title":{"rendered":"You do use the Oracle Trace File Analyzer, don’t you?"},"content":{"rendered":"

When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places (yes, this got much better with the Automatic Diagnostics Repository(ADR)). Now imagine you have a cluster and something goes wrong, where do you start? We created a very nice picture for our Grid Infrastructure workshop<\/a> which gives an idea of all the components and where it can go wrong. Lets start with the components.<\/p>\n

<\/p>\n

This is approximately what you get when you install a three node Oracle RAC infrastructure (I know there are even more when you go for a flex cluster but this is not important for the scope of this post):<\/p>\n

\"cluster_overview\"<\/a><\/p>\n

These are quite a few components and all need to work together properly for the cluster being healthy and doing what is expected. And when you have so many components many things can go wrong:<\/p>\n

\"cluster_overview_issues\"<\/a><\/p>\n

Depending on how good your monitoring is you might know where to start looking for the issue quite fast or you can rely on your experience for starting to troubleshoot. Always a good staring point are the alert logs of the cluster, asm and the database. They all are usually located under $ORACLE_BASE and there are many, many other trace files and directories. For a 12.2 database it looks like this:<\/p>\n

\noracle@oelrac1:\/u01\/app\/oracle\/diag\/rdbms\/db1\/DB1_1\/ [DB1_1] ls \u2013la\ndrwxr-x---.  2 oracle asmadmin    20 Mar 21 14:55 alert\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 cdump\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 hm\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 incident\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 incpkg\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 ir\ndrwxr-x---.  2 oracle asmadmin  4096 Mar 21 15:00 lck\ndrwxr-x---.  7 oracle asmadmin    60 Mar 21 14:55 log\ndrwxr-x---.  2 oracle asmadmin  4096 Mar 21 15:00 metadata\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 metadata_dgif\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 metadata_pv\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 stage\ndrwxr-x---.  2 oracle asmadmin     6 Mar 21 14:55 sweep\ndrwxr-x---.  2 oracle asmadmin 36864 May 23 08:26 trace\n<\/pre>\n
For a 12.2 Grid Infrastrucure it looks like this:<\/p>\n
\noracle@oelrac1:\/u01\/app\/oracle\/diag\/crs\/oelrac1\/crs\/ [DB1_1] ls -la\ndrwxrwxr-x.  2 oracle oinstall    20 Mar 21 12:59 alert\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 cdump\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 incident\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 incpkg\ndrwxrwxr-x.  2 oracle oinstall  4096 Mar 21 12:59 lck\ndrwxrwxr-x.  4 oracle oinstall    29 Mar 21 12:59 log\ndrwxrwxr-x.  2 oracle oinstall  4096 Mar 21 12:59 metadata\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 metadata_dgif\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 metadata_pv\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 stage\ndrwxrwxr-x.  2 oracle oinstall     6 Mar 21 12:59 sweep\ndrwxrwxr-x.  2 oracle oinstall 20480 May 23 08:28 trace\n<\/pre>\n
But there are even more when you go one level up:<\/p>\n
\noracle@oelrac1:\/u01\/app\/oracle\/diag\/ [DB1_1] ls -la\ndrwxrwxr-x.  3 oracle oinstall   22 Mar 21 13:02 afdboot\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 apx\ndrwxrwxr-x.  5 oracle oinstall   51 Mar 21 13:04 asm\ndrwxrwxr-x.  4 oracle oinstall   40 Mar 21 13:04 asmtool\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 bdsql\ndrwxrwxr-x.  4 oracle oinstall   40 Mar 21 13:05 clients\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 diagtool\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 dps\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 em\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 gsm\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 ios\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 lsnrctl\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 netcman\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 ofm\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 plsql\ndrwxrwxr-x.  2 oracle oinstall    6 Mar 21 12:57 plsqlapp\ndrwxrwxr-x.  3 oracle oinstall   20 Mar 21 13:08 tnslsnr\n<\/pre>\n
It can quite take some time to locate the trace file which contains the information you need for troubleshooting or for uploading to Oracle support. And this is where the Oracle Trace File Analyzer is a great help. There is a great support note to get started and to download the latest bundle: TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1).
\n\"mos_tfa\"<\/a><\/p>\n
As the note explains TFA is a bundle of tools. What you get when you download the bundle is this:<\/p>\n
\"tfa_overview\"<\/a><\/p>\n
So in words TFA consists of: A collecter, an Analyzer, the tfactl command line utility and a bunch of tools. Probably you already know one or more of these tools and maybe you already installed and used some of them. Stop doing that immediately: Use TFA which brings them all. To come back to the components picture from above: Once you installed TFA the picture looks like this:<\/p>\n
\"tfa_overview_2\"<\/a><\/p>\n
You use tfactl (the initiator) to talk to a local TFA daemon that can talk to the TFA daemons on all other nodes in the cluster. When you install an Oracle 12.2 Grid Infrastructure tfactl is already there:<\/p>\n
\noracle@oelrac1:\/var\/tmp\/ [+ASM1] which tfactl\n\/u01\/app\/12.2.0.1\/grid\/bin\/tfactl\n<\/pre>\n
The issue with that is that you do not have all of the support tools available, e.g. you won’t have SQLT, DA\/RDA, Procwatcher and OSWatcher. For getting those you’ll need to download the complete bundle from the support note referenced above and then remove the current TFA installation and re-install it:<\/p>\n
\n[root@oelrac1 tmp]$ \/u01\/app\/12.2.0.1\/grid\/bin\/tfactl uninstall\n[root@oelrac1 tmp]$ .\/installTFALite \nEnter a location for installing TFA (\/tfa will be appended if not supplied) [\/var\/tmp\/tfa]:\n\/u01\/app\/12.2.0.1\/grid\/tfa\nEnter a Java Home that contains Java 1.5 or later : \/u01\/app\/12.2.0.1\/grid\/jdk\/\n<\/pre>\n
Once this is through you should see all the tools:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] tfactl toolstatus\n.--------------------------------------.\n|        External Support Tools        |\n+---------+--------------+-------------+\n| Host    | Tool         | Status      |\n+---------+--------------+-------------+\n| oelrac1 | oswbb        | RUNNING     |\n| oelrac1 | darda        | DEPLOYED    |\n| oelrac1 | prw          | NOT RUNNING |\n| oelrac1 | orachk       | DEPLOYED    |\n| oelrac1 | vi           | DEPLOYED    |\n| oelrac1 | changes      | DEPLOYED    |\n| oelrac1 | ps           | DEPLOYED    |\n| oelrac1 | param        | DEPLOYED    |\n| oelrac1 | events       | DEPLOYED    |\n| oelrac1 | alertsummary | DEPLOYED    |\n| oelrac1 | ls           | DEPLOYED    |\n| oelrac1 | dbperf       | DEPLOYED    |\n| oelrac1 | sqlt         | DEPLOYED    |\n| oelrac1 | summary      | DEPLOYED    |\n| oelrac1 | pstack       | DEPLOYED    |\n| oelrac1 | tail         | DEPLOYED    |\n| oelrac1 | oratop       | DEPLOYED    |\n| oelrac1 | dbglevel     | DEPLOYED    |\n| oelrac1 | exachk       | DEPLOYED    |\n| oelrac1 | grep         | DEPLOYED    |\n| oelrac1 | srdc         | DEPLOYED    |\n| oelrac1 | history      | DEPLOYED    |\n'---------+--------------+-------------'\n<\/pre>\n
I will not go into all the tools but highlight some of them. Lets start with oratop. When you want to know which statements are currently executing in your instance:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] tfactl \n\ntfactl> oratop -database DB1\n<\/pre>\n
This bring up something very similar to the “top” command which comes with the operating system but displays information of what is going on in the database:
\n\"oratop\"<\/a><\/p>\n
Can be quite handy when you only have access via ssh. Another great tool is OSWatcher which gathers operating statistics in the background and is able to create graphs:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] tfactl run oswbb\n\nStarting OSW Analyzer V7.3.3\nOSWatcher Analyzer Written by Oracle Center of Expertise\nCopyright (c)  2014 by Oracle Corporation\n\nParsing Data. Please Wait...\n\nScanning file headers for version and platform info...\n\n\nParsing file oelrac1_iostat_17.05.23.1500.dat ...\nParsing file oelrac1_iostat_17.05.23.1600.dat ...\nParsing file oelrac1_iostat_17.05.24.0800.dat ...\nParsing file oelrac1_iostat_17.05.24.0900.dat ...\nParsing file oelrac1_iostat_17.05.24.1000.dat ...\nParsing file oelrac1_iostat_17.05.24.1100.dat ...\n\n\nParsing file oelrac1_vmstat_17.05.23.1500.dat ...\nParsing file oelrac1_vmstat_17.05.23.1600.dat ...\nParsing file oelrac1_vmstat_17.05.24.0800.dat ...\nParsing file oelrac1_vmstat_17.05.24.0900.dat ...\nParsing file oelrac1_vmstat_17.05.24.1000.dat ...\nParsing file oelrac1_vmstat_17.05.24.1100.dat ...\n\n\nParsing file oelrac1_netstat_17.05.23.1500.dat ...\nParsing file oelrac1_netstat_17.05.23.1600.dat ...\nParsing file oelrac1_netstat_17.05.24.0800.dat ...\nParsing file oelrac1_netstat_17.05.24.0900.dat ...\nParsing file oelrac1_netstat_17.05.24.1000.dat ...\nParsing file oelrac1_netstat_17.05.24.1100.dat ...\n\n\nParsing file oelrac1_top_17.05.23.1500.dat ...\nParsing file oelrac1_top_17.05.23.1600.dat ...\nParsing file oelrac1_top_17.05.24.0800.dat ...\nParsing file oelrac1_top_17.05.24.0900.dat ...\nParsing file oelrac1_top_17.05.24.1000.dat ...\nParsing file oelrac1_top_17.05.24.1100.dat ...\n\n\nParsing file oelrac1_ps_17.05.23.1500.dat ...\nParsing file oelrac1_ps_17.05.23.1600.dat ...\nParsing file oelrac1_ps_17.05.24.0800.dat ...\nParsing file oelrac1_ps_17.05.24.0900.dat ...\nParsing file oelrac1_ps_17.05.24.1000.dat ...\nParsing file oelrac1_ps_17.05.24.1100.dat ...\n\n\nParsing Completed.\n\n\nEnter 1 to Display CPU Process Queue Graphs\nEnter 2 to Display CPU Utilization Graphs\nEnter 3 to Display CPU Other Graphs\nEnter 4 to Display Memory Graphs\nEnter 5 to Display Disk IO Graphs\n\nEnter 6 to Generate All CPU Gif Files\nEnter 7 to Generate All Memory Gif Files\nEnter 8 to Generate All Disk Gif Files\n\nEnter L to Specify Alternate Location of Gif Directory\nEnter T to Alter Graph Time Scale Only (Does not change analysis dataset)\nEnter D to Return to Default Graph Time Scale\nEnter R to Remove Currently Displayed Graphs\n\nEnter A to Analyze Data\nEnter S to Analyze Subset of Data(Changes analysis dataset including graph time scale)\n\nEnter P to Generate A Profile\nEnter X to Export Parsed Data to File\nEnter Q to Quit Program\n\nPlease Select an Option:4\n\n<\/pre>\n
When you for example chose “4 Display Memory Graphs” this will bring up nice graphs about the memory consumption:
\n\"oswatcher_memory\"<\/a><\/p>\n
Very handy as well. But what do you do when you have a seriou issues and need to collect all the trace\/log files? Quite easy as well, lets do a short demo and force an ORA-07445:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] kill -l | grep SIGSEGV\n11) SIGSEGV\t12) SIGUSR2\t13) SIGPIPE\t14) SIGALRM\t15) SIGTERM\noracle@oelrac1:\/home\/oracle\/ [+ASM1] ps -ef | grep dbw  | grep DB1\noracle   14821     1  0 08:20 ?        00:00:00 ora_dbw0_DB1_1\noracle@oelrac1:\/home\/oracle\/ [+ASM1] kill -11 14821\n<\/pre>\n
This will cause the database to restart, so please don’t do this on other systems than your lab systems. What we can do now is to ask TFA to collect all the files from all nodes which are required for troubleshooting the issue:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] tfactl diagcollect -srdc ora7445\nEnter the time of the ORA-07445 [YYYY-MM-DD HH24:MI:SS,=ALL] :            \nEnter the Database Name [=ALL] : DB1\n\n1. May\/24\/2017 09:39:52 : [db1] ORA-07445: exception encountered: core dump [semtimedop()+10] [SIGSEGV] [ADDR:0xD43100006015] [PC:0x7F746C15DFCA] [unknown code] []\n\nPlease choose the event : 1-1 [1] 1\n\u2026\nLogs are being collected to: \/u01\/app\/oracle\/tfa\/repository\/srdc_ora7445_collection_Wed_May_24_09_43_07_CEST_2017_node_local\n\/u01\/app\/oracle\/tfa\/repository\/srdc_ora7445_collection_Wed_May_24_09_43_07_CEST_2017_node_local\/oelrac1.tfa_srdc_ora7445_Wed_May_24_09_43_07_CEST_2017.zip\n<\/pre>\n
Get the zip file and either start to analyze yourself or upload to Oracle Support. Usually they should not ask you for additional log or trace files anymore \ud83d\ude42 Saves a lot of time.<\/p>\n
If you prefer a menu driven interface to all the tools you can have that as well:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] tfactl run darda\n<\/pre>\n
This will bring up a menu similar to a Linux text based installation program:
\n\"darda1\"<\/a><\/p>\n
Chose what you want to do, e.g. “1” for “Oracle Database: Collectors”:
\n\"darda2\"<\/a><\/p>\n
Go to “2 Optimize Performance”:
\n\"darda3\"<\/a><\/p>\n
You have a “1 Slow Running Database”, so:
\n\"darda4\"<\/a><\/p>\n
… and you have the possibility to run an AWR report from here. Of course you should monitor that TFA is running so that you get notified when things like this happen:<\/p>\n
\noracle@oelrac1:\/home\/oracle\/ [+ASM1] sudo $ORACLE_HOME\/bin\/tfactl status\n\n.----------------------------------------------------------------------------------------------.\n| Host    | Status of TFA | PID  | Port | Version    | Build ID             | Inventory Status |\n+---------+---------------+------+------+------------+----------------------+------------------+\n| oelrac1 | RUNNING       | 2532 | 5000 | 12.1.2.8.4 | 12128420170206111019 | COMPLETE         |\n| oelrac2 | NOT RUNNING   | -    |      |            |                      |                  |\n'---------+---------------+------+------+------------+----------------------+------------------'\n<\/pre>\n
There is much more you can do with tfa (check the documentation) and tfa is useful for single instances as well. Hope this helps ….<\/p>\n","protected":false},"excerpt":{"rendered":"
When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places […]<\/p>\n","protected":false},"author":29,"featured_media":10132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[96,97],"type_dbi":[],"class_list":["post-10131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-oracle","tag-tfa"],"acf":[],"yoast_head":"\nYou do use the Oracle Trace File Analyzer, don't you? - 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\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"You do use the Oracle Trace File Analyzer, don't you?\" \/>\n<meta property=\"og:description\" content=\"When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-25T04:10:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1399\" \/>\n\t<meta property=\"og:image:height\" content=\"894\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"You do use the Oracle Trace File Analyzer, don’t you?\",\"datePublished\":\"2017-05-25T04:10:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/\"},\"wordCount\":867,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/cluster_overview.png\",\"keywords\":[\"Oracle\",\"tfa\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/\",\"name\":\"You do use the Oracle Trace File Analyzer, don't you? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/cluster_overview.png\",\"datePublished\":\"2017-05-25T04:10:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/cluster_overview.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/cluster_overview.png\",\"width\":1399,\"height\":894},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/you-do-use-the-oracle-trace-file-analyzer-dont-you\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"You do use the Oracle Trace File Analyzer, don’t you?\"}]},{\"@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\\\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\\\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/westermanndanie\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/daniel-westermann\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"You do use the Oracle Trace File Analyzer, don't you? - 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\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/","og_locale":"en_US","og_type":"article","og_title":"You do use the Oracle Trace File Analyzer, don't you?","og_description":"When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places […]","og_url":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/","og_site_name":"dbi Blog","article_published_time":"2017-05-25T04:10:19+00:00","og_image":[{"width":1399,"height":894,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"You do use the Oracle Trace File Analyzer, don’t you?","datePublished":"2017-05-25T04:10:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/"},"wordCount":867,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png","keywords":["Oracle","tfa"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/","url":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/","name":"You do use the Oracle Trace File Analyzer, don't you? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png","datePublished":"2017-05-25T04:10:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/cluster_overview.png","width":1399,"height":894},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/you-do-use-the-oracle-trace-file-analyzer-dont-you\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"You do use the Oracle Trace File Analyzer, don’t you?"}]},{"@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\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10131","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10131"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10131\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10132"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10131"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}