{"id":2178,"date":"2021-02-26T09:12:47","date_gmt":"2021-02-26T09:12:47","guid":{"rendered":"https:\/\/swiv.com.br\/using-swingbench-to-set-up-an-order-entry-schema\/"},"modified":"2026-05-27T20:02:52","modified_gmt":"2026-05-27T19:02:52","slug":"using-swingbench-to-set-up-an-order-entry-schema","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/02\/26\/using-swingbench-to-set-up-an-order-entry-schema\/","title":{"rendered":"Using Swingbench to set up an Order Entry Schema"},"content":{"rendered":"\n<p>Neste artigo vou criar um schema de testes em meu ambiente de laborat\u00f3rio utilizando a ferramenta Swingbench. Na tela inicial, clicar em &#8220;Next&#8221;:<\/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-330.png\" alt=\"\" class=\"wp-image-8130\"\/><\/figure>\n\n\n\n<p>Manter a vers\u00e3o 2.0 e clicar em Next:<\/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-331.png\" alt=\"\" class=\"wp-image-8131\"\/><\/figure>\n\n\n\n<p>Selecionar a primeira op\u00e7\u00e3o e clicar em Next:<\/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-332.png\" alt=\"\" class=\"wp-image-8132\"\/><\/figure>\n\n\n\n<p>Preencher os dados de conex\u00e3o e informar a senha do banco:<\/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-333.png\" alt=\"\" class=\"wp-image-8133\"\/><\/figure>\n\n\n\n<p>Preenchendo o DG que abrigar\u00e1 o novo datafile e clicando em Next:<\/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-334.png\" alt=\"\" class=\"wp-image-8134\"\/><\/figure>\n\n\n\n<p>Mudando o tipo de tablespace para normal:<\/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-335.png\" alt=\"\" class=\"wp-image-8135\"\/><\/figure>\n\n\n\n<p>Definindo o tamanho:<\/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-336.png\" alt=\"\" class=\"wp-image-8136\"\/><\/figure>\n\n\n\n<p>Definindo n\u00edvel de paralelismo:<\/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-337.png\" alt=\"\" class=\"wp-image-8137\"\/><\/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-338.png\" alt=\"\" class=\"wp-image-8138\"\/><\/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-339.png\" alt=\"\" class=\"wp-image-8140\"\/><\/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-340.png\" alt=\"\" class=\"wp-image-8141\"\/><\/figure>\n\n\n\n<p>Processo finalizado:<\/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-341.png\" alt=\"\" class=\"wp-image-8142\"\/><\/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-342.png\" alt=\"\" class=\"wp-image-8143\"\/><\/figure>\n\n\n\n<p>Validando o ambiente:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT INSTANCE_NAME,STATUS FROM GV$INSTANCE;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\ncortex           OPEN\n \nSQL&gt; SELECT SUM(BYTES\/1024\/1024\/1024) FROM DBA_SEGMENTS WHERE OWNER=&#039;SOE&#039;;\n \nSUM(BYTES\/1024\/1024\/1024)\n-------------------------\n               .794921875\n \nSQL&gt; EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname =&gt; &#039;SOE&#039;);\n \nPL\/SQL procedure successfully completed.\n \nSQL&gt; exit\nDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n&#x5B;oracle@oel7 ~]$ rman target \/\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 26 06:08:35 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\n \nRMAN&gt; report schema;\n \nusing target database control file instead of recovery catalog\nReport of database schema for database with db_unique_name CORTEX\n \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    910      SYSTEM               YES     +DG_DATA\/CORTEX\/DATAFILE\/system.256.1039033445\n3    600      SYSAUX               NO      +DG_DATA\/CORTEX\/DATAFILE\/sysaux.257.1039033519\n4    340      UNDOTBS1             YES     +DG_DATA\/CORTEX\/DATAFILE\/undotbs1.258.1039033555\n5    824      SOE                  NO      +DG_DATA\/CORTEX\/DATAFILE\/soe.266.1065506205\n7    5        USERS                NO      +DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\n \nList of Temporary Files\n=======================\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1    32       TEMP                 32767       +DG_DATA\/CORTEX\/TEMPFILE\/temp.264.1039033669\n \nRMAN&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Neste artigo vou criar um schema de testes em meu ambiente de laborat\u00f3rio utilizando a ferramenta Swingbench. Na tela inicial, clicar em &#8220;Next&#8221;: Manter a vers\u00e3o 2.0 e clicar em Next: Selecionar a primeira op\u00e7\u00e3o e clicar em Next: Preencher os dados de conex\u00e3o e informar a senha do banco: Preenchendo o DG que abrigar\u00e1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2178","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2178","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=2178"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2178\/revisions"}],"predecessor-version":[{"id":9256,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2178\/revisions\/9256"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}