{"id":12755,"date":"2019-08-21T14:00:42","date_gmt":"2019-08-21T12:00:42","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/"},"modified":"2019-08-21T14:00:42","modified_gmt":"2019-08-21T12:00:42","slug":"useful-linux-commands-for-an-oracle-dba","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/","title":{"rendered":"Useful Linux commands for an Oracle DBA"},"content":{"rendered":"

Introduction<\/h2>\n

Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions.<\/p>\n

watch with diff<\/h2>\n

It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more useful with the – -diff parameter. All the differences since last run are highlighted. For example if you want to monitor a running backup, try this:<\/p>\n

watch -n 60 --diff 'sqlplus -s \/nolog @check_backup; echo ; du -hs \/backup'<\/code><\/p>\n

The check_backup.sql being:<\/p>\n


\nconn \/ as sysdba
\nset feedback off
\nset lines 150
\nset pages 100
\ncol status for a30
\nalter session set NLS_DATE_FORMAT=\"DD\/MM-HH24:MI:SS\";
\nselect start_time \"Start\", round (input_bytes\/1024\/1024,1) \"Source MB\", round(output_bytes\/1024\/1024,1) \"Backup MB\", input_type \"Type\", status \"Status\", round(elapsed_seconds\/60,1) \"Min\", round(compression_ratio,1) \"Ratio\" from v$rman_backup_job_details where start_time >= SYSDATE-1 order by 1 desc;
\nexit;
\n<\/code><\/p>\n

Every minute (60 seconds), you will check, in the rman backup views, the amount of data already backed up. And the amount of data in your backup folder.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Very convenient to keep an eye on things without actually repeating the commands.<\/p>\n

Truncate a logfile in one simple command<\/h2>\n

Oracle is generating a lot of logfiles, some of them can reach several GB and fill up your filesystem. How to quickly empty a big logfile without removing it? Simply use the true command:<\/p>\n

true > listener.log<\/code><\/p>\n

Run a SQL script on all the running databases<\/h2>\n

You need to check something on every databases running on your system? Or eventually make the same change to all these databases? A single line will do the job:<\/p>\n

for a in `ps -ef | grep pmon | grep -v grep | awk '{print $8}' | cut -c 10- | sort`; do . oraenv <<< $a; sqlplus -s \/ as sysdba @my_script.sql >> output.log; done<\/code><\/p>\n

Don’t forget to put an exit at the end of your SQL script my_script.sql. Using this script through ansible will even increase the scope and save hours of work.<\/p>\n

Copy a folder to another server<\/h2>\n

scp is fine for copying single file or multiple files inside a folder. But copying a folder recursively to a remote server with scp is more complicated. Actually, you need to do a tarfile for that purpose. A clever solution is to use tar without creating any archive on the source server, but with a pipe to the destination server. Very useful and efficient, with just one line:<\/p>\n

tar cf - source_folder | ssh oracle@192.168.50.167 \"cd destination_folder_for_source_folder; tar xf -\"<\/code><\/p>\n

For sure, you will need +rwx on destination_folder_for_source_folder for oracle user on 192.168.50.167.<\/p>\n

Check the network speed – because you need to check<\/h2>\n

As an Oracle DBA you probably have to deal with performance: not a problem it’s part of your job. But are you sure your database system is running at full network speed? You probably didn’t check that, but low network speed could be the root cause of some performance issues. This concerns copper-based networks.<\/p>\n

Today’s servers handle 10Gb\/s ethernet speed but can also work with 1Gb\/s depending on the network behind the servers. You should be aware that you can still find 100Mb\/s network speeds, for example if the network port of the switch attached to your server has been limitated for some reason (needed for the server connected to this port before yours for example). If 1Gb\/s is probably enough for most of the databases, 100Mb\/s is clearly inadequate, and most of the recent servers will even not handle correctly 100Mb\/s network speed. Your Oracle environment may work, but don’t expect high performance level as your databases will have to wait for the network to send packets. Don’t forget that 1Gb\/s gives you about 100-120MBytes\/s in real condition, and 100Mb\/s only allows 10-12MBytes\/s, “Fast Ethernet” of the 90’s… <\/p>\n

Checking the network speed is easy, with ethtool. <\/p>\n

[root@oda-x6-2 ~]# ethtool btbond1
\nSettings for btbond1:
\n Supported ports: [ ]
\n Supported link modes: Not reported
\n Supported pause frame use: No
\n Supports auto-negotiation: No
\n Advertised link modes: Not reported
\n Advertised pause frame use: No
\n Advertised auto-negotiation: No
\n Speed: 1000Mb\/s <= Network speed is OK<\/strong>
\n Duplex: Full
\n Port: Other
\n PHYAD: 0
\n Transceiver: internal
\n Auto-negotiation: off
\n Link detected: yes
\n<\/code><\/p>\n

In case of a network bonding interface, please also check the real interfaces associated to the bonding, all the network interfaces belonging to the bonding need to have the same network speed :<\/p>\n

[root@oda-x6-2 ~]# ethtool em1
\nSettings for em1:
\n Supported ports: [ TP ]
\n Supported link modes: 100baseT\/Full <= This network interface is physically supporting 100Mb\/s<\/strong>
\n 1000baseT\/Full <= also 1Gb\/s<\/strong>
\n 10000baseT\/Full <= and 10Gb\/s<\/strong>
\n Supported pause frame use: Symmetric
\n Supports auto-negotiation: Yes
\n Advertised link modes: 100baseT\/Full
\n 1000baseT\/Full
\n 10000baseT\/Full
\n Advertised pause frame use: Symmetric
\n Advertised auto-negotiation: Yes
\n Speed: 1000Mb\/s <= Network speed is 1Gb\/s<\/strong>
\n Duplex: Full
\n Port: Twisted Pair
\n PHYAD: 0
\n Transceiver: external
\n Auto-negotiation: on
\n MDI-X: Unknown
\n Supports Wake-on: d
\n Wake-on: d
\n Current message level: 0x00000007 (7)
\n drv probe link
\n Link detected: yes <= This interface is connected to a switch<\/strong>
\n<\/code><\/p>\n

Conclusion<\/h2>\n

Hope this helps!<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with […]<\/p>\n","protected":false},"author":45,"featured_media":12757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,42,59],"tags":[1673,1674,23,1675,73,1676,1677,96,270,1678,985,1679,235,1680],"type_dbi":[],"class_list":["post-12755","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-operating-systems","category-oracle","tag-commands","tag-copy-complete-folder","tag-dba","tag-dba-tool","tag-linux","tag-monitor","tag-network-speed","tag-oracle","tag-rman","tag-script-on-all-databases","tag-sqlplus","tag-truncate-logfile","tag-useful","tag-watch-linux"],"acf":[],"yoast_head":"\nUseful Linux commands for an Oracle DBA - 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\/useful-linux-commands-for-an-oracle-dba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Useful Linux commands for an Oracle DBA\" \/>\n<meta property=\"og:description\" content=\"Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-21T12:00:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1697\" \/>\n\t<meta property=\"og:image:height\" content=\"366\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\\\/useful-linux-commands-for-an-oracle-dba\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"Useful Linux commands for an Oracle DBA\",\"datePublished\":\"2019-08-21T12:00:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/\"},\"wordCount\":602,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/useful_linux_cmd_pic2.png\",\"keywords\":[\"commands\",\"copy complete folder\",\"DBA\",\"dba tool\",\"Linux\",\"monitor\",\"network speed\",\"Oracle\",\"RMAN\",\"script on all databases\",\"sqlplus\",\"truncate logfile\",\"useful\",\"watch linux\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/\",\"name\":\"Useful Linux commands for an Oracle DBA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/useful_linux_cmd_pic2.png\",\"datePublished\":\"2019-08-21T12:00:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/useful_linux_cmd_pic2.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/useful_linux_cmd_pic2.png\",\"width\":1697,\"height\":366},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/useful-linux-commands-for-an-oracle-dba\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Useful Linux commands for an Oracle DBA\"}]},{\"@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\\\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\\\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-dubar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Useful Linux commands for an Oracle DBA - 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\/useful-linux-commands-for-an-oracle-dba\/","og_locale":"en_US","og_type":"article","og_title":"Useful Linux commands for an Oracle DBA","og_description":"Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with […]","og_url":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/","og_site_name":"dbi Blog","article_published_time":"2019-08-21T12:00:42+00:00","og_image":[{"width":1697,"height":366,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png","type":"image\/png"}],"author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"Useful Linux commands for an Oracle DBA","datePublished":"2019-08-21T12:00:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/"},"wordCount":602,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png","keywords":["commands","copy complete folder","DBA","dba tool","Linux","monitor","network speed","Oracle","RMAN","script on all databases","sqlplus","truncate logfile","useful","watch linux"],"articleSection":["Database Administration & Monitoring","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/","url":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/","name":"Useful Linux commands for an Oracle DBA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png","datePublished":"2019-08-21T12:00:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/useful_linux_cmd_pic2.png","width":1697,"height":366},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/useful-linux-commands-for-an-oracle-dba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Useful Linux commands for an Oracle DBA"}]},{"@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\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12755","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\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12755"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12755\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/12757"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12755"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}