{"id":745,"date":"2012-04-16T15:40:19","date_gmt":"2012-04-16T13:40:19","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=745"},"modified":"2012-04-16T15:40:19","modified_gmt":"2012-04-16T13:40:19","slug":"jak-zrobic-trace-na-formatkach-oaf","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=745","title":{"rendered":"Jak zrobi\u0107 trace na formatkach OAF"},"content":{"rendered":"<p>Jak zrobi\u0107 trace na formatkach OAF \u00a0czyli tzw.\u00a0Oracle Self Service Web Applications.<\/p>\n<p>1) Wyszukaj profil na poziomie u\u017cytkownika\u00a0<!--more--><\/p>\n<p>FND_INIT_SQL PL <strong>Inicjalizacja instrukcji SQL &#8211; niestandardowa<\/strong><br \/>\nFND_INIT_SQL US <strong>Initialization SQL Statement &#8211; Custom<\/strong><\/p>\n<p>Najlepiej nie zamyka\u0107 formatki z profilami, \u017ceby nie zapomnie\u0107 za chwil\u0119 zdj\u0105\u0107 profilu.<\/p>\n<p>2) nowym oknie zaloguj si\u0119 do formatki OAF i przygotuj do wykonania czynno\u015bci dla kt\u00f3rych chcesz zrobi\u0107 trace.<\/p>\n<p>3) wpisz warto\u015b\u0107 opcji profiku na u\u017cytkowniku (jedna d\u0142uga linia)<\/p>\n<pre>BEGIN\u00a0FND_CTL.FND_SESS_CTL('','',\u00a0'',\u00a0'TRUE','','ALTER\u00a0SESSION\u00a0SET\u00a0TRACEFILE_IDENTIFIER='||''''||'TraceTrade'\u00a0||''''||'\u00a0EVENTS\u00a0='||''''||'\u00a010046\u00a0TRACE\u00a0NAME\u00a0CONTEXT\u00a0FOREVER,\u00a0LEVEL\u00a012\u00a0'||'''');\u00a0END;<\/pre>\n<p>4) Zapisz profil<\/p>\n<p>5) Wykonaj\u00a0czynno\u015bci\u00a0do trace<\/p>\n<p>6) Usu\u0144 warto\u015b\u0107 profilu dla u\u017cytkowika &#8211; WA\u017bNE, \u017ceby trace nie robi\u0142 w si\u0119 w niesko\u0144czono\u015b\u0107 bo admin si\u0119 wkurzy.<\/p>\n<p>7) plik *.trc powinien by\u0107 na serwerze bazodanowym. W nazwie powinna by\u0107 data i godzina i nazwa u\u017cytkownika. Lokalizacj\u0119 mo\u017cna odczyta\u0107 w bazie<\/p>\n<pre>select value from v$parameter where name = 'user_dump_dest';<\/pre>\n<p>8) Plik *.trc trzeba potraktowa\u0107 narz\u0119dziem\u00a0TKPROF<\/p>\n<pre>$tkprof raw_trace_file.trc output_file explain=apps\/apps sort=(exeela,fchela) sys=no\u00a0\r\n\r\n<strong><em>Where:<\/em><\/strong>\u00a0\r\n\r\nraw_trace_file.trc: Name of trace file\u00a0\r\noutput_file:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 tkprof out file\u00a0\r\nexplain:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 This option provides the explain plan for the sql\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0statements\u00a0\r\nsort:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 This provides the sort criteria in which all sql\u00a0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0statements will be sorted. This will bring the bad sql at\u00a0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0the top of the outputfile.\u00a0\r\nsys=no:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Disables sql statements issued by user SYS<\/pre>\n<p>W wygenerowanym pliku output_file\u00a0mo\u017cemy odczyta\u0107 zapytania jakie by\u0142y wykonywane.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jak zrobi\u0107 trace na formatkach OAF \u00a0czyli tzw.\u00a0Oracle Self Service Web Applications. 1) Wyszukaj profil na poziomie u\u017cytkownika\u00a0<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[119,118,117],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/745"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=745"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/745\/revisions"}],"predecessor-version":[{"id":746,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/745\/revisions\/746"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}