{"id":6375,"date":"2021-09-09T23:55:56","date_gmt":"2021-09-09T23:55:56","guid":{"rendered":"https:\/\/swiv.com.br\/creating-swingbench-configuration-files\/"},"modified":"2026-05-27T20:02:29","modified_gmt":"2026-05-27T19:02:29","slug":"creating-swingbench-configuration-files","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/09\/09\/creating-swingbench-configuration-files\/","title":{"rendered":"Creating Swingbench Configuration Files"},"content":{"rendered":"\n<p>A ferramenta Swingbench nos ajuda a simular opera\u00e7\u00f5es em nossos bancos (de laborat\u00f3rio), permitindo estudar para diversos cen\u00e1rios que os DBAs enfrentam no dia a dia. O objetivo desse artigo \u00e9 realizar configura\u00e7\u00f5es simples na ferramenta de modo que possamos simular um workload OLTP e outro OLAP, atrav\u00e9s de arquivos de configura\u00e7\u00e3o (de extens\u00e3o xml).<\/p>\n\n\n\n<p>Reconhecendo o banco de dados que estou usando para o laborat\u00f3rio:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel7 BSS]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 9 19:39:32 2021\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL&gt; SELECT NAME,OPEN_MODE,LOG_MODE FROM V$DATABASE;\n\nNAME      OPEN_MODE            LOG_MODE\n--------- -------------------- ------------\nCORTEX    READ WRITE           ARCHIVELOG\n<\/pre><\/div>\n\n\n<p>Abrindo a ferramenta SwingBench:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-11-1.png\" alt=\"\" class=\"wp-image-7394\"\/><\/figure>\n\n\n\n<p>Configurando os par\u00e2metros de conex\u00e3o com o banco de dados, e clicando no bot\u00e3o de teste:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-12-1024x298.png\" alt=\"\" class=\"wp-image-7396\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-13.png\" alt=\"\" class=\"wp-image-7397\"\/><\/figure>\n\n\n\n<p>Para simular uma carga, vamos aumentar o n\u00famero de usu\u00e1rios na ferramenta e executar o bot\u00e3o de play:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-14-1024x154.png\" alt=\"\" class=\"wp-image-7398\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-15.png\" alt=\"\" class=\"wp-image-7399\"\/><\/figure>\n\n\n\n<p>O workload come\u00e7a a ser executado:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-16-1024x409.png\" alt=\"\" class=\"wp-image-7400\"\/><\/figure>\n\n\n\n<p>Para simularmos um ambiente OLTP, podemos configurar os par\u00e2metros da sess\u00e3o Transaction conforme abaixo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-18-1024x251.png\" alt=\"\" class=\"wp-image-7402\"\/><\/figure>\n\n\n\n<p>Clicando no bot\u00e3o salvar, teremos esses par\u00e2metros como os padr\u00f5es (arquivo swingconfig.xml):<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-19.png\" alt=\"\" class=\"wp-image-7403\"\/><\/figure>\n\n\n\n<p>Mas tamb\u00e9m podemos gerar um arquivo xml espec\u00edfico, conforme abaixo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-20.png\" alt=\"\" class=\"wp-image-7404\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-21.png\" alt=\"\" class=\"wp-image-7405\"\/><\/figure>\n\n\n\n<p>Agora podemos configurar os par\u00e2metros que simular\u00e3o um ambiente de warehouse (OLAP):<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-22-1024x267.png\" alt=\"\" class=\"wp-image-7406\"\/><\/figure>\n\n\n\n<p>Salvando:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-23.png\" alt=\"\" class=\"wp-image-7407\"\/><\/figure>\n\n\n\n<p>Para fazermos uso dos nossos arquivos de configura\u00e7\u00e3o, basta ir na op\u00e7\u00e3o abaixo para que os par\u00e2metros sejam carregados:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-24.png\" alt=\"\" class=\"wp-image-7408\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-25.png\" alt=\"\" class=\"wp-image-7409\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-26-1024x243.png\" alt=\"\" class=\"wp-image-7410\"\/><\/figure>\n\n\n\n<p>Assim j\u00e1 podemos colocar o monstro para rodar:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-27-1.png\" alt=\"\" class=\"wp-image-7411\"\/><\/figure>\n\n\n\n<p>Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A ferramenta Swingbench nos ajuda a simular opera\u00e7\u00f5es em nossos bancos (de laborat\u00f3rio), permitindo estudar para diversos cen\u00e1rios que os DBAs enfrentam no dia a dia. O objetivo desse artigo \u00e9 realizar configura\u00e7\u00f5es simples na ferramenta de modo que possamos simular um workload OLTP e outro OLAP, atrav\u00e9s de arquivos de configura\u00e7\u00e3o (de extens\u00e3o xml). [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-6375","post","type-post","status-publish","format-standard","hentry","category-performance"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=6375"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6375\/revisions"}],"predecessor-version":[{"id":9048,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6375\/revisions\/9048"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=6375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=6375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=6375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}