{"id":511,"date":"2013-09-09T17:04:03","date_gmt":"2013-09-09T17:04:03","guid":{"rendered":"http:\/\/www.alemdopeoplebooks.com.br\/site\/?p=511"},"modified":"2013-09-15T01:11:38","modified_gmt":"2013-09-15T01:11:38","slug":"trace-magic","status":"publish","type":"post","link":"https:\/\/www.alemdopeoplebooks.com.br\/site\/trace-magic\/","title":{"rendered":"PeopleSoft Trace Magic"},"content":{"rendered":"<p>Para facilitar o rastreamente de problemas de performance podemos utilizar o TraceMagic.<\/p>\n<p>A ferramenta TraceMagic PeopleSoft oferece a possibilidade de separar as informa\u00e7\u00f5es de rastreamento PeopleSoft com base nos seguintes tipos de trace: SELECT, DELETE, INSERT, UPDATE. Al\u00e9m disso, as instru\u00e7\u00f5es SQL podem ser analisados \u200b\u200bem amostras a granel ou categorizadas por comandos com a \u00fanica cl\u00e1usula WHERE ou \u00fanica cl\u00e1usula FROM.<\/p>\n<p>A Home do TraceMagic nos mostra estat\u00edsticas dos comandos executados<\/p>\n<p><a href=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic0.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"traceMagic0\" src=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic0.png\" width=\"1152\" height=\"338\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Tamb\u00e9m \u00e9 posssivel a visualiza\u00e7\u00e3o por tipo: (SELECT, DELETE, &#8230;)<\/p>\n<p><a href=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic1.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"traceMagic1\" src=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic1.png\" width=\"1344\" height=\"587\" \/><\/a><\/p>\n<p>Para que o TraceMagic funcione corretamente a Oracle recomenda o uso de 8 op\u00e7\u00f5es de trace marcadas conforme abaixo.<\/p>\n<p><a href=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-516\" alt=\"traceMagic\" src=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic.png\" width=\"411\" height=\"280\" srcset=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic.png 411w, https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/09\/traceMagic-300x204.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Segue o link para download do TraceMagic (\u00c9 necess\u00e1rio login no Oracle Support)<\/p>\n<p><a href=\"https:\/\/support.oracle.com\/epmos\/main\/downloadattachmentprocessor?attachid=1470578.1%3ACURRENTVERSION&amp;docType=DIAGNOSTIC%20TOOLS&amp;action=download\" target=\"_blank\">Download Trace Magic<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para facilitar o rastreamente de problemas de performance podemos utilizar o TraceMagic. A ferramenta TraceMagic PeopleSoft oferece a possibilidade de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[69,3],"tags":[13,113,48,16,15,14,110,9,77],"class_list":["post-511","post","type-post","status-publish","format-standard","hentry","category-peoplesoft","category-peopletools","tag-oracle-peoplesoft","tag-peoplesoft","tag-peoplesoft-fdm","tag-peoplesoft-fscm","tag-peoplesoft-hcm","tag-peoplesoft-hrms","tag-peopletools","tag-trace","tag-tracemagic"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/comments?post=511"}],"version-history":[{"count":10,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/511\/revisions"}],"predecessor-version":[{"id":524,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/511\/revisions\/524"}],"wp:attachment":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/categories?post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/tags?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}