Oracle Log Miner - size of operation -

-

some background information @ first: i'm analysing load on oracle database .net application make use of nservicebus. we've observed high redo logs activity when running application , hence - high amount of archivelog (we've got database in archivelog mode). we've used toad logminer find out causes it, unfortunately many of operations of type unsupported. i've assume it's because of using securefile type of lob. i've digged database logminer view: v$logmnr_contents see there lot more columns in toad's logminer.

what need size of each operation in redo. here's query far:

select timestamp,        rbabyte,        seg_owner,        seg_name,        table_name,        seg_type,        seg_type_name,        table_space,        row_id,        operation,        sql_redo   v$logmnr_contents  1 = 1 , operation = 'unsupported'

i'm not sure if rbabyte correct value use or maybe calculation more complicated, me looks record size including lob. oracle's documentations says it's "rba byte offset within block", it's not enough. please advice.

try query:

with t1         (select rs_id,                 ssn,                 rbablk,                 rbabyte,                 rbablk * 512 + rbabyte curpos,                 lead (rbablk * 512 + rbabyte, 1, rbablk * 512 + rbabyte)                    on (partition substr (rs_id, 1, 9)order                             rbasqn,                             rbablk,                             rbabyte,                             scn,                             redo_value)                    nextpos,                   lead (rbablk * 512 + rbabyte, 1, rbablk * 512 + rbabyte)                      on (partition substr (rs_id, 1, 9)order                               rbasqn,                               rbablk,                               rbabyte,                               scn,                               redo_value)                 - (rbablk * 512 + rbabyte)                    redo_size,                 operation,                 case                    when operation = 'internal' , data_obj# != 0                       (select t0.owner                          dba_objects t0                         t0.object_id = t1.data_obj#)                    else                       seg_owner                 end                    seg_owner,                 case                    when operation = 'internal' , data_obj# != 0                       (select t0.object_name nome                          dba_objects t0                         t0.object_id = t1.data_obj#)                    else                       seg_name                 end                    seg_name,                 sql_redo,                 redo_value,                 client_id,                 timestamp            v$logmnr_contents t1)   select rs_id,          ssn,          rbablk,          rbabyte,          curpos,          nextpos,          redo_size,          seg_owner,          seg_name,          operation,          sql_redo     t1 order substr (rs_id, 1, 9),          ssn,          rbablk,          rbabyte,          redo_value

Comments

Post a Comment

Popular posts from this blog

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require...
Read more

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u...
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork...
Read more