I've been trying to use the IMA objects to immediately identify who's
holding locks other need.

It's seems the example in the 2.6 manual entitled "Who Is Holding a Lock
Others Need?" has the wrong syntax or joins.

Anyone successfully used ima to track locks? If so can I "borrow" some sql
from you please.

Thanks again

Gareth
Cymraeg:- Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohonina chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn
bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ohebiaeth a dderbynnir, yn
unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio at wefan
Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:- This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further informationon Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.

Hi Gareth,

This is what I use. Make sure you put the grants.

IMA registrations

/* REGISTRATIONS */
execute immediate register table dba_domain ( domplace varchar(64)
not null not default is 'exp.gwf.gwm.session.dom.index' ) as import
from 'tables' with dbms = ima, structure=unique sortkeyed,
key=(domplace)
\p\g
register table dbms_server_parameters ( server varchar(64) not null
not default is 'SERVER', server_name varchar(64) not null not default
is 'exp.scf.scd.server_name', name_server_registration integer4 not
null not default is 'exp.scf.scd.names_reg', capabilities varchar(64)
not null not default is 'exp.scf.scd.capabilities_str',
capability_values integer4 not null not default is 'exp.scf.scd.capab
ilities_num', cursors_per_session integer4 not null not default is 'e
xp.scf.scd.acc', cursor_flags integer4 not null not default is 'exp.s
cf.scd.csrflags', fast_commit integer4 not null not default is 'exp.s
cf.scd.fastcommit', query_flattening integer4 not null not default is
'exp.scf.scd.flatflags', expected_row_count integer4 not null not
default is 'exp.scf.scd.irowcount', max_thread__priority integer4 not
null not default is 'exp.scf.scd.max_priority', min_thread__priority
integer4 not null not default is 'exp.scf.scd.min_priority',
norm_thread__priority integer4 not null not default is 'exp.scf.scd.n
orm_priority', avoid_cluster_optimizations integer4 not null not
default is 'exp.scf.scd.no_star_cluster', avoid_2pc_recovery integer4
not null not default is 'exp.scf.scd.nostar_recovr', max_threads
integer4 not null not default is 'exp.scf.scd.nousers', psf_memory
integer4 not null not default is 'exp.scf.scd.psf_mem',
risk_udt_inconsistency integer4 not null not default is 'exp.scf.scd.
risk_inconsistency', rule_depth integer4 not null not default is 'exp
..scf.scd.rule_depth', max_connections integer4 not null not default
is 'exp.scf.scd.server.max_connections', reserved_connections
integer4 not null not default is 'exp.scf.scd.server.reserved_connect
ions', write_behind_threads integer4 not null not default is 'exp.scf
..scd.writebehind', sole_server integer4 not null not default is 'exp.
scf.scd.soleserver', startup_time varchar(64) not null not default is
'exp.scf.scd.startup_time', server_pid integer4 not null not default
is 'exp.scf.scd.server.pid' ) as import from 'tables' with dbms =
IMA, structure = sortkeyed, key = (server)
\p\g
execute immediate register table dbms_server_stats ( server
varchar(64) not null not default is 'SERVER', cpu_time integer4 not
null not default is 'exp.clf.unix.cs.srv_block.cpu', error_code
integer4 not null not default is 'exp.clf.unix.cs.srv_block.error_cod
e', event_mask integer4 not null not default is 'exp.clf.unix.cs.srv_
block.event_mask', idle_time integer4 not null not default is 'exp.cl
f.unix.cs.srv_block.idle_time', state_mask integer4 not null not
default is 'exp.clf.unix.cs.srv_block.mask', active_count integer4
not null not default is 'exp.clf.unix.cs.srv_block.num_active',
session_count integer4 not null not default is 'exp.clf.unix.cs.srv_b
lock.num_sessions', quantums integer4 not null not default is 'exp.cl
f.unix.cs.srv_block.quantums', ready_mask integer4 not null not
default is 'exp.clf.unix.cs.srv_block.ready_mask', cs_smms_count
integer4 not null not default is 'exp.clf.unix.cs.srv_block.sem_stats
..cs_smms_count', smmsx_count integer4 not null not default is 'exp.cl
f.unix.cs.srv_block.sem_stats.smmsx_count', smmx_count integer4 not
null not default is 'exp.clf.unix.cs.srv_block.sem_stats.smmx_count',
smmxx_count integer4 not null not default is 'exp.clf.unix.cs.srv_blo
ck.sem_stats.smmxx_count', smss_count integer4 not null not default
is 'exp.clf.unix.cs.srv_block.sem_stats.smss_count', smssx_count
integer4 not null not default is 'exp.clf.unix.cs.srv_block.sem_stats
..smssx_count', smsx_count integer4 not null not default is 'exp.clf.u
nix.cs.srv_block.sem_stats.smsx_count', smsxx_count integer4 not null
not default is 'exp.clf.unix.cs.srv_block.sem_stats.smsxx_count',
state integer4 not null not default is 'exp.clf.unix.cs.srv_block.sta
te', stk_count integer4 not null not default is 'exp.clf.unix.cs.srv_
block.stk_count', stk_list integer4 not null not default is 'exp.clf.
unix.cs.srv_block.stk_list', stksize integer4 not null not default is
'exp.clf.unix.cs.srv_block.stksize', toq_cnt integer4 not null not
default is 'exp.clf.unix.cs.srv_block.toq_cnt', user_sessions
integer4 not null not default is 'exp.clf.unix.cs.srv_block.user_sess
ions', bio_done integer4 not null not default is 'exp.clf.unix.cs.srv
_block.wait_stats.bio_done', bio_idle integer4 not null not default
is 'exp.clf.unix.cs.srv_block.wait_stats.bio_idle', bio_time integer4
not null not default is 'exp.clf.unix.cs.srv_block.wait_stats.bio_tim
e', bio_waits integer4 not null not default is 'exp.clf.unix.cs.srv_b
lock.wait_stats.bio_waits', dio_done integer4 not null not default is
'exp.clf.unix.cs.srv_block.wait_stats.dio_done', dio_idle integer4
not null not default is 'exp.clf.unix.cs.srv_block.wait_stats.dio_idl
e', dio_time integer4 not null not default is 'exp.clf.unix.cs.srv_bl
ock.wait_stats.dio_time', dio_waits integer4 not null not default is
'exp.clf.unix.cs.srv_block.wait_stats.dio_waits', lg_done integer4
not null not default is 'exp.clf.unix.cs.srv_block.wait_stats.lg_done
', lg_idle integer4 not null not default is 'exp.clf.unix.cs.srv_bloc
k.wait_stats.lg_idle', lg_time integer4 not null not default is 'exp.
clf.unix.cs.srv_block.wait_stats.lg_time', lg_waits integer4 not null
not default is 'exp.clf.unix.cs.srv_block.wait_stats.lg_waits',
lk_done integer4 not null not default is 'exp.clf.unix.cs.srv_block.w
ait_stats.lk_done', lk_idle integer4 not null not default is 'exp.clf
..unix.cs.srv_block.wait_stats.lk_idle', lk_time integer4 not null not
default is 'exp.clf.unix.cs.srv_block.wait_stats.lk_time' , lk_waits
integer4 not null not default is 'exp.clf.unix.cs.srv_block.wait_stat
s.lk_waits', tm_done integer4 not null not default is 'exp.clf.unix.c
s.srv_block.wait_stats.tm_done', tm_idle integer4 not null not
default is 'exp.clf.unix.cs.srv_block.wait_stats.tm_idle', tm_time
integer4 not null not default is 'exp.clf.unix.cs.srv_block.wait_stat
s.tm_time', tm_waits integer4 not null not default is 'exp.clf.unix.c
s.srv_block.wait_stats.tm_waits' ) as import from 'tables' with dbms
= ima, structure=sortkeyed, key=(server)
\p\g
execute immediate register table dbms_servers ( server varchar(64)
not null not default is 'SERVER', server_pid integer4 not null not
default is 'exp.clf.unix.cs.srv_block.pid', server_name varchar(64)
not null not default is 'exp.clf.unix.cs.srv_block.gca_name',
session_max integer4 not null not default is 'exp.clf.unix.cs.srv_blo
ck.max_sessions', tx_max integer4 not null not default is 'exp.clf.un
ix.cs.srv_block.max_active', max_cursors integer4 not null not
default is 'exp.clf.unix.cs.srv_block.cursors', q_per_sec integer4
not null not default is 'exp.clf.unix.cs.srv_block.q_per_sec' ) as
import from 'tables' with dbms = ima, structure=sortkeyed,
key=(server)
\p\g
execute immediate register table dmf_bm_stats ( server varchar(64)
not null not default is 'SERVER', bmcwait integer4 not null not
default is 'exp.dmf.dm0p.bmc_bmcwait', cpcheck integer4 not null not
default is 'exp.dmf.dm0p.bmc_cpcheck', cp_count integer4 not null not
default is 'exp.dmf.dm0p.bmc_cpcount', cp_index integer4 not null not
default is 'exp.dmf.dm0p.bmc_cpindex', fc_flushes integer4 not null
not default is 'exp.dmf.dm0p.bmc_fcflush', wb_flushes integer4 not
null not default is 'exp.dmf.dm0p.bmc_wbflush', lockreclaim integer4
not null not default is 'exp.dmf.dm0p.bmc_lockreclaim', server_count
integer4 not null not default is 'exp.dmf.dm0p.bmc_srv_count', status
integer4 not null not default is 'exp.dmf.dm0p.bmc_status', db_cache
integer4 not null not default is 'exp.dmf.dm0p.bmc_dbcsize',
table_cache integer4 not null not default is 'exp.dmf.dm0p.bmc_tblcsi
ze' ) as import from 'tables' with dbms = ima, structure=sortkeyed,
key=(server)
\p\g
execute immediate register table dmf_cache ( server varchar(64) not
null not default is 'SERVER', page_size integer4 not null not default
is 'exp.dmf.dm0p.bm_pgsize', buffer_count integer4 not null not
default is 'exp.dmf.dm0p.bm_bufcnt', free_limit integer4 not null not
default is 'exp.dmf.dm0p.bm_flimit', group_buffers integer4 not null
not default is 'exp.dmf.dm0p.bm_gcnt', group_size integer4 not null
not default is 'exp.dmf.dm0p.bm_gpages', bucket_count integer4 not
null not default is 'exp.dmf.dm0p.bm_hshcnt', modify_limit integer4
not null not default is 'exp.dmf.dm0p.bm_mlimit', wb_end integer4 not
null not default is 'exp.dmf.dm0p.bm_wbend', wb_start integer4 not
null not default is 'exp.dmf.dm0p.bm_wbstart' ) as import from 'table
s' with dbms = ima, structure=unique sortkeyed, key=(server,
page_size)
\p\g
execute immediate register table dmf_cache_stats ( server varchar(64)
not null not default is 'SERVER', page_size integer4 not null not
default is 'exp.dmf.dm0p.bm_pgsize', checks integer4 not null not
default is 'exp.dmf.dm0p.bm_check', clock integer4 not null not
default is 'exp.dmf.dm0p.bm_clock', dirty integer4 not null not
default is 'exp.dmf.dm0p.bm_dirty', single_free integer4 not null not
default is 'exp.dmf.dm0p.bm_fcount', single_fixed integer4 not null
not default is 'exp.dmf.dm0p.bm_lcount', single_modified integer4 not
null not default is 'exp.dmf.dm0p.bm_mcount', fcwait integer4 not
null not default is 'exp.dmf.dm0p.bm_fcwait', fix_calls integer4 not
null not default is 'exp.dmf.dm0p.bm_fix', force integer4 not null
not default is 'exp.dmf.dm0p.bm_force', fwait integer4 not null not
default is 'exp.dmf.dm0p.bm_fwait', group_free integer4 not null not
default is 'exp.dmf.dm0p.bm_gfcount', group_fixed integer4 not null
not default is 'exp.dmf.dm0p.bm_glcount', group_modified integer4 not
null not default is 'exp.dmf.dm0p.bm_gmcount', group_reads integer4
not null not default is 'exp.dmf.dm0p.bm_greads', gsyncwr integer4
not null not default is 'exp.dmf.dm0p.bm_gsyncwr', gwait integer4 not
null not default is 'exp.dmf.dm0p.bm_gwait', group_writes integer4
not null not default is 'exp.dmf.dm0p.bm_gwrites', hits integer4 not
null not default is 'exp.dmf.dm0p.bm_hit', iowait integer4 not null
not default is 'exp.dmf.dm0p.bm_iowait', single_reads integer4 not
null not default is 'exp.dmf.dm0p.bm_reads', refresh integer4 not
null not default is 'exp.dmf.dm0p.bm_refresh', sbufcnt integer4 not
null not default is 'exp.dmf.dm0p.bm_sbufcnt', status integer4 not
null not default is 'exp.dmf.dm0p.bm_status', syncwr integer4 not
null not default is 'exp.dmf.dm0p.bm_syncwr', unfix_calls integer4
not null not default is 'exp.dmf.dm0p.bm_unfix', single_writes
integer4 not null not default is 'exp.dmf.dm0p.bm_writes' ) as import
from 'tables' with dbms = ima, structure=sortkeyed, key=(server)
\p\g
execute immediate register table dmf_server_stats ( server
varchar(64) not null not default is 'SERVER', page_size integer4 not
null not default is 'exp.dmf.dm0p.lbm_pgsize', checks integer4 not
null not default is 'exp.dmf.dm0p.lbm_check', dirty integer4 not null
not default is 'exp.dmf.dm0p.lbm_dirty', fcwait integer4 not null not
default is 'exp.dmf.dm0p.lbm_fcwait', fix_calls integer4 not null not
default is 'exp.dmf.dm0p.lbm_fix', force integer4 not null not
default is 'exp.dmf.dm0p.lbm_force', fwait integer4 not null not
default is 'exp.dmf.dm0p.lbm_fwait', group_reads integer4 not null
not default is 'exp.dmf.dm0p.lbm_greads', gsyncwr integer4 not null
not default is 'exp.dmf.dm0p.lbm_gsyncwr', gwait integer4 not null
not default is 'exp.dmf.dm0p.lbm_gwait', group_writes integer4 not
null not default is 'exp.dmf.dm0p.lbm_gwrites', hits integer4 not
null not default is 'exp.dmf.dm0p.lbm_hit', iowait integer4 not null
not default is 'exp.dmf.dm0p.lbm_iowait', single_reads integer4 not
null not default is 'exp.dmf.dm0p.lbm_reads', refresh integer4 not
null not default is 'exp.dmf.dm0p.lbm_refresh', syncwr integer4 not
null not default is 'exp.dmf.dm0p.lbm_syncwr', unfix_calls integer4
not null not default is 'exp.dmf.dm0p.lbm_unfix', single_writes
integer4 not null not default is 'exp.dmf.dm0p.lbm_writes' ) as
import from 'tables' with dbms = ima, structure=sortkeyed,
key=(server)
\p\g
register table ima_mib_objects(server varchar(64)not null not default
is 'SERVER', classid varchar(64)not null not default is 'CLASSID',
instance varchar(64)not null not default is 'INSTANCE', value
varchar(64)not null not default is 'VALUE', perm integer2 not null
not default is 'PERMISSIONS')as import from 'objects' with update,
DBMS=IMA, STRUCTURE=unique sortkeyed, key=(server, classid, instance)
\p\g
register table ima_mo_meta (server varchar(64)not null not default is
'SERVER', classid varchar(64)not null not default is 'exp.glf.mo.meta
..classid', perms integer2 not null not default is 'exp.glf.mo.meta.pe
rms', size integer2 not null not default is 'exp.glf.mo.meta.size',
xindex varchar(64) not null not default is 'exp.glf.mo.meta.index')
as import from 'tables' with DBMS=IMA, STRUCTURE=unique sortkeyed,
key=(server, classid)
\p\g
execute immediate register table locking_config ( vnode varchar(64)
not null not default is 'VNODE', cluster_id integer4 not null not
default is 'exp.dmf.lk.lkd_csid', csp_pid integer4 not null not
default is 'exp.dmf.lk.lkd_csp_id', total_locklists integer4 not null
not default is 'exp.dmf.lk.lkd_lbk_size', lock_hash_size integer4 not
null not default is 'exp.dmf.lk.lkd_lkh_size', locks_per_tx integer4
not null not default is 'exp.dmf.lk.lkd_max_lkb', total_resources
integer4 not null not default is 'exp.dmf.lk.lkd_rbk_size',
res_hash_size integer4 not null not default is 'exp.dmf.lk.lkd_rsh_si
ze', total_locks integer4 not null not default is 'exp.dmf.lk.lkd_sbk
_size' ) as import from 'tables' with dbms = ima,
structure=sortkeyed, key=(vnode)
\p\g
execute immediate register table locking_stats ( vnode varchar(64)
not null not default is 'VNODE', locklists_used integer4 not null not
default is 'exp.dmf.lk.lkd_llb_inuse', resources_used integer4 not
null not default is 'exp.dmf.lk.lkd_rsb_inuse', locks_used integer4
not null not default is 'exp.dmf.lk.lkd_lkb_inuse' , list_creates
integer4 not null not default is 'exp.dmf.lk.lkd_stat.create_list',
list_releases integer4 not null not default is 'exp.dmf.lk.lkd_stat.r
elease_all', lock_requests integer4 not null not default is 'exp.dmf.
lk.lkd_stat.request_new', lock_re_reqs integer4 not null not default
is 'exp.dmf.lk.lkd_stat.request_convert', lock_converts integer4 not
null not default is 'exp.dmf.lk.lkd_stat.convert', lock_releases
integer4 not null not default is 'exp.dmf.lk.lkd_stat.release',
lock_cancel integer4 not null not default is 'exp.dmf.lk.lkd_stat.can
cel', lock_escalates integer4 not null not default is 'exp.dmf.lk.lkd
_stat.release_partial', lock_waits integer4 not null not default is '
exp.dmf.lk.lkd_stat.wait', lock_searches integer4 not null not
default is 'exp.dmf.lk.lkd_stat.deadlock_search', lock_deadlocks
integer4 not null not default is 'exp.dmf.lk.lkd_stat.deadlock',
conv_waits integer4 not null not default is 'exp.dmf.lk.lkd_stat.conv
ert_wait', conv_searches integer4 not null not default is 'exp.dmf.lk
..lkd_stat.convert_search', conv_deadlocks integer4 not null not
default is 'exp.dmf.lk.lkd_stat.convert_deadlock', res_long_chain_len
integer4 not null not default is 'exp.dmf.lk.lkd_stat.max_rsrc_chain_
len', lock_long_chain_len integer4 not null not default is 'exp.dmf.l
k.lkd_stat.max_lock_chain_len', block_allocs integer4 not null not
default is 'exp.dmf.lk.lkd_stat.allocate_cb', block_deallocs integer4
not null not default is 'exp.dmf.lk.lkd_stat.deallocate_cb',
lbk_highwater integer4 not null not default is 'exp.dmf.lk.lkd_stat.l
bk_highwater', lkb_highwater integer4 not null not default is 'exp.dm
f.lk.lkd_stat.lkb_highwater', llb_highwater integer4 not null not
default is 'exp.dmf.lk.lkd_stat.llb_highwater', max_lcl_dlk_srch
integer4 not null not default is 'exp.dmf.lk.lkd_stat.max_lcl_dlk_src
h', rbk_highwater integer4 not null not default is 'exp.dmf.lk.lkd_st
at.rbk_highwater', rsb_highwater integer4 not null not default is 'ex
p.dmf.lk.lkd_stat.rsb_highwater', sbk_highwater integer4 not null not
default is 'exp.dmf.lk.lkd_stat.sbk_highwater' ) as import from 'tabl
es' with dbms = ima, structure=sortkeyed, key=(vnode)
\p\g
execute immediate register table locklists ( vnode varchar(64) not
null not default is 'VNODE', locklist_id integer4 not null not
default is 'exp.dmf.lk.llb_id.id_id', related_list_id integer4 not
null not default is 'exp.dmf.lk.llb_related_llb_id_id',
waiting_lock_id_id integer4 not null not default is 'exp.dmf.lk.llb_w
ait_id_id', max_locks integer4 not null not default is 'exp.dmf.lk.ll
b_max_lkb', lock_count integer4 not null not default is 'exp.dmf.lk.l
lb_lkb_count', logical_count integer4 not null not default is 'exp.dm
f.lk.llb_llkb_count', server_pid integer4 not null not default is 'ex
p.dmf.lk.llb_pid', session_id varchar(32) not null not default is 'ex
p.dmf.lk.llb_sid', connected_locklists integer4 not null not default
is 'exp.dmf.lk.llb_connect_count', evflags integer4 not null not
default is 'exp.dmf.lk.llb_evflags', ev_stamp integer4 not null not
default is 'exp.dmf.lk.llb_ew_stamp', name0 integer4 not null not
default is 'exp.dmf.lk.llb_name0', name1 integer4 not null not
default is 'exp.dmf.lk.llb_name1', related_count integer4 not null
not default is 'exp.dmf.lk.llb_related_count', related_llb integer4
not null not default is 'exp.dmf.lk.llb_related_llb', search_count
integer4 not null not default is 'exp.dmf.lk.llb_search_count', stamp
integer4 not null not default is 'exp.dmf.lk.llb_stamp', status_s
varchar(64) not null not default is 'exp.dmf.lk.llb_status', status
integer4 not null not default is 'exp.dmf.lk.llb_status_num', tick
integer4 not null not default is 'exp.dmf.lk.llb_tick' ) as import
from 'tables' with dbms = ima, structure=unique sortkeyed,
key=(vnode,locklist_id)
\p\g
execute immediate register table locks ( vnode varchar(64) not null
not default is 'VNODE', lock_id integer4 not null not default is 'exp
..dmf.lk.lkb_id.id_id', attribute_s varchar(32) not null not default
is 'exp.dmf.lk.lkb_attribute', attribute integer4 not null not
default is 'exp.dmf.lk.lkb_attribute_num', lkb_count integer4 not
null not default is 'exp.dmf.lk.lkb_count', grant_mode_s varchar(12)
not null not default is 'exp.dmf.lk.lkb_grant_mode', grant_mode
integer4 not null not default is 'exp.dmf.lk.lkb_grant_mode_num',
status_block integer4 not null not default is 'exp.dmf.lk.lkb_lksb.lo
ck_id', value0 integer4 not null not default is 'exp.dmf.lk.lkb_lksb.
value0', value1 integer4 not null not default is 'exp.dmf.lk.lkb_lksb
..value1', locklist_id integer4 not null not default is 'exp.dmf.lk.lk
b_llb_id_id', req_mode_s varchar(12) not null not default is 'exp.dmf
..lk.lkb_request_mode', req_mode integer4 not null not default is 'exp
..dmf.lk.lkb_request_mode_num', resource_id integer4 not null not
default is 'exp.dmf.lk.lkb_rsb_id_id', lock_state_s varchar(12) not
null not default is 'exp.dmf.lk.lkb_state', lock_state integer4 not
null not default is 'exp.dmf.lk.lkb_state_num' ) as import from 'tabl
es' with dbms = ima, structure=unique sortkeyed, key=(vnode,lock_id)
\p\g
execute immediate register table log_dbs ( vnode varchar(64) not null
not default is 'VNODE', first_log_offset integer4 not null not
default is 'exp.dmf.lg.ldb_d_first_la.la_offset', first_log_trip
integer4 not null not default is 'exp.dmf.lg.ldb_d_first_la.la_sequen
ce', last_log_rec varchar(32) not null not default is 'exp.dmf.lg.ldb
_d_last_la', last_log_offset integer4 not null not default is 'exp.dm
f.lg.ldb_d_last_la.la_offset', last_log_trip integer4 not null not
default is 'exp.dmf.lg.ldb_d_last_la.la_sequence', db_id integer4 not
null not default is 'exp.dmf.lg.ldb_database_id', db_name varchar(32)
not null not default is 'exp.dmf.lg.ldb_db_name', db_owner
varchar(32) not null not default is 'exp.dmf.lg.ldb_db_owner',
instance integer4 not null not default is 'exp.dmf.lg.ldb_id.id_insta
nce', first_jnl_rec varchar(32) not null not default is 'exp.dmf.lg.l
db_j_first_la', first_jnl_offset integer4 not null not default is 'ex
p.dmf.lg.ldb_j_first_la.la_offset', first_jnl_trip integer4 not null
not default is 'exp.dmf.lg.ldb_j_first_la.la_sequence', last_jnl_rec
varchar(32) not null not default is 'exp.dmf.lg.ldb_j_last_la',
last_jnl_offset integer4 not null not default is 'exp.dmf.lg.ldb_j_la
st_la.la_offset', last_jnl_trip integer4 not null not default is 'exp
..dmf.lg.ldb_j_last_la.la_sequence', l_buffer integer4 not null not
default is 'exp.dmf.lg.ldb_l_buffer', lpd_count integer4 not null not
default is 'exp.dmf.lg.ldb_lpd_count', lxb_count integer4 not null
not default is 'exp.dmf.lg.ldb_lxb_count', lxbo_count integer4 not
null not default is 'exp.dmf.lg.ldb_lxbo_count', back_rec varchar(32)
not null not default is 'exp.dmf.lg.ldb_sback_lsn', back_trip
integer4 not null not default is 'exp.dmf.lg.ldb_sback_lsn_high',
back_offset integer4 not null not default is 'exp.dmf.lg.ldb_sback_ls
n_low', backup_rec varchar(32) not null not default is 'exp.dmf.lg.ld
b_sbackup', backup_offset integer4 not null not default is 'exp.dmf.l
g.ldb_sbackup.la_offset', backup_trip integer4 not null not default
is 'exp.dmf.lg.ldb_sbackup.la_sequence', txn_begins integer4 not null
not default is 'exp.dmf.lg.ldb_stat.begin', txn_end integer4 not null
not default is 'exp.dmf.lg.ldb_stat.end', log_forces integer4 not
null not default is 'exp.dmf.lg.ldb_stat.force', log_reads integer4
not null not default is 'exp.dmf.lg.ldb_stat.read', log_waits
integer4 not null not default is 'exp.dmf.lg.ldb_stat.wait',
log_writes integer4 not null not default is 'exp.dmf.lg.ldb_stat.writ
e', status_s varchar(64) not null not default is 'exp.dmf.lg.ldb_stat
us', status integer4 not null not default is 'exp.dmf.lg.ldb_status_n
um', ldb_index integer4 not null not default is 'exp.dmf.lg.ldb_id.id
_id', buffer varchar(32) not null not default is 'exp.dmf.lg.ldb_buff
er', first_log_rec varchar(32) not null not default is 'exp.dmf.lg.ld
b_d_first_la' ) as import from 'tables' with dbms = ima,
structure=unique sortkeyed, key=(vnode,ldb_index)
\p\g
execute immediate register table log_header_stats ( vnode varchar(64)
not null not default is 'VNODE', active_log_s varchar(64) not null
not default is 'exp.dmf.lg.lfb_active_log', active_log integer4 not
null not default is 'exp.dmf.lg.lfb_active_log_num', arc_end_s
varchar(32) not null not default is 'exp.dmf.lg.lfb_archive_end',
arc_end_offset integer4 not null not default is 'exp.dmf.lg.lfb_archi
ve_end.la_offset', arc_end_trip integer4 not null not default is 'exp
..dmf.lg.lfb_archive_end.la_sequence', arc_pcp_s varchar(32) not null
not default is 'exp.dmf.lg.lfb_archive_prevcp', arc_pcp_offset
integer4 not null not default is 'exp.dmf.lg.lfb_archive_prevcp.la_of
fset', arc_pcp_trip integer4 not null not default is 'exp.dmf.lg.lfb_
archive_prevcp.la_sequence', arc_start_s varchar(32) not null not
default is 'exp.dmf.lg.lfb_archive_start', arc_start_offset integer4
not null not default is 'exp.dmf.lg.lfb_archive_start.la_offset',
arc_start_trip integer4 not null not default is 'exp.dmf.lg.lfb_archi
ve_start.la_sequence', forced_s varchar(32) not null not default is '
exp.dmf.lg.lfb_forced_lga', forced_offset integer4 not null not
default is 'exp.dmf.lg.lfb_forced_lga.la_offset', forced_trip
integer4 not null not default is 'exp.dmf.lg.lfb_forced_lga.la_sequen
ce', forced_lsn_s varchar(32) not null not default is 'exp.dmf.lg.lfb
_forced_lsn', forced_lsn_offset integer4 not null not default is 'exp
..dmf.lg.lfb_forced_lsn_high', forced_lsn_trip integer4 not null not
default is 'exp.dmf.lg.lfb_forced_lsn_low', active_logs integer4 not
null not default is 'exp.dmf.lg.lfb_hdr_lgh_active_logs', begin_s
varchar(32) not null not default is 'exp.dmf.lg.lfb_hdr_lgh_begin',
begin_offset integer4 not null not default is 'exp.dmf.lg.lfb_hdr_lgh
_begin_off', begin_trip integer4 not null not default is 'exp.dmf.lg.
lfb_hdr_lgh_begin_seq', header_checksum integer4 not null not default
is 'exp.dmf.lg.lfb_hdr_lgh_checksum', cp_s varchar(32) not null not
default is 'exp.dmf.lg.lfb_hdr_lgh_cp', cp_offset integer4 not null
not default is 'exp.dmf.lg.lfb_hdr_lgh_cp_off', cp_trip integer4 not
null not default is 'exp.dmf.lg.lfb_hdr_lgh_cp_seq',
archiver_interval integer4 not null not default is 'exp.dmf.lg.lfb_hd
r_lgh_cpcnt', end_s varchar(32) not null not default is 'exp.dmf.lg.l
fb_hdr_lgh_end', end_offset integer4 not null not default is 'exp.dmf
..lg.lfb_hdr_lgh_end_off', end_trip integer4 not null not default is '
exp.dmf.lg.lfb_hdr_lgh_end_seq', percent_full integer4 not null not
default is 'exp.dmf.lg.lfb_hdr_lgh_percentage_logfull', log_status_s
varchar(64) not null not default is 'exp.dmf.lg.lfb_hdr_lgh_status',
log_status integer4 not null not default is 'exp.dmf.lg.lfb_hdr_lgh_s
tatus_num', last_txid_s varchar(32) not null not default is 'exp.dmf.
lg.lfb_hdr_lgh_tran_id', last_tx_id_high integer4 not null not
default is 'exp.dmf.lg.lfb_hdr_lgh_tran_high', last_tx_id_low
integer4 not null not default is 'exp.dmf.lg.lfb_hdr_lgh_tran_low',
reserved_bytes integer4 not null not default is 'exp.dmf.lg.lfb_reser
ved_space', status_s varchar(64) not null not default is 'exp.dmf.lg.
lgd_status', status integer4 not null not default is 'exp.dmf.lg.lgd_
status_num' ) as import from 'tables' with dbms = ima,
structure=sortkeyed, key=(vnode)
\p\g
execute immediate register table log_procs ( vnode varchar(64) not
null not default is 'VNODE', lpb_index integer4 not null not default
is 'exp.dmf.lg.lpb_id.id_id', buffer_mgr_id integer4 not null not
default is 'exp.dmf.lg.lpb_bufmgr_id', cond integer4 not null not
default is 'exp.dmf.lg.lpb_cond', force_abort_sid integer4 not null
not default is 'exp.dmf.lg.lpb_force_abort_sid', gcmt_asleep integer4
not null not default is 'exp.dmf.lg.lpb_gcmt_asleep', gcmt_sid
integer4 not null not default is 'exp.dmf.lg.lpb_gcmt_sid', instance
integer4 not null not default is 'exp.dmf.lg.lpb_id.id_instance',
lpd_count integer4 not null not default is
'exp.dmf.lg.lpb_lpd_count', pid integer4 not null not default is 'exp
..dmf.lg.lpb_pid', txn_begins integer4 not null not default is 'exp.dm
f.lg.lpb_stat.begin', txn_ends integer4 not null not default is 'exp.
dmf.lg.lpb_stat.end', log_forces integer4 not null not default is 'ex
p.dmf.lg.lpb_stat.force', log_readios integer4 not null not default
is 'exp.dmf.lg.lpb_stat.readio', log_waits integer4 not null not
default is 'exp.dmf.lg.lpb_stat.wait', log_writes integer4 not null
not default is 'exp.dmf.lg.lpb_stat.write', lpb_status_s varchar(64)
not null not default is 'exp.dmf.lg.lpb_status', lpb_status integer4
not null not default is 'exp.dmf.lg.lpb_status_num' ) as import from
'tables' with dbms = ima, structure=unique sortkeyed, key=(vnode,
lpb_index)
\p\g
execute immediate register table logging_config ( vnode varchar(64)
not null not default is 'VNODE', log_buffers integer4 not null not
default is 'exp.dmf.lg.lfb_buf_cnt', abort_blocks integer4 not null
not default is 'exp.dmf.lg.lfb_hdr_lgh_l_abort', cp_blocks integer4
not null not default is 'exp.dmf.lg.lfb_hdr_lgh_l_cp', full_blocks
integer4 not null not default is 'exp.dmf.lg.lfb_hdr_lgh_l_logfull',
block_size integer4 not null not default is 'exp.dmf.lg.lfb_hdr_lgh_s
ize', block_count integer4 not null not default is 'exp.dmf.lg.lfb_hd
r_lgh_count', db_limit integer4 not null not default is 'exp.dmf.lg.l
gd_ldbb_size', server_limit integer4 not null not default is 'exp.dmf
..lg.lgd_lpbb_size', proc_db_limit integer4 not null not default is 'e
xp.dmf.lg.lgd_lpdb_size', tx_limit integer4 not null not default is '
exp.dmf.lg.lgd_lxbb_size', logwriter_threads integer4 not null not
default is 'exp.dmf.lg.lgd_n_logwriters', file_version integer4 not
null not default is 'exp.dmf.lg.lfb_hdr_lgh_version', check_stall
integer4 not null not default is 'exp.dmf.lg.lgd_check_stall',
node_id integer4 not null not default is 'exp.dmf.lg.lgd_cnodeid',
cpstall integer4 not null not default is 'exp.dmf.lg.lgd_cpstall',
csp_pid integer4 not null not default is 'exp.dmf.lg.lgd_csp_pid',
gcmt_numticks integer4 not null not default is 'exp.dmf.lg.lgd_gcmt_n
umticks', gcmt_threshold integer4 not null not default is 'exp.dmf.lg
..lgd_gcmt_threshold' ) as import from 'tables' with dbms = ima,
structure=sortkeyed, key=(vnode)
\p\g
execute immediate register table logging_stats ( vnode varchar(64)
not null not default is 'VNODE', dual_read_ios integer4 not null not
default is 'exp.dmf.lg.lfb_stat_dual_readio', dual_write_ios integer4
not null not default is 'exp.dmf.lg.lfb_stat_dual_writeio', txn_ends
integer4 not null not default is 'exp.dmf.lg.lfb_stat_end',
log_forces integer4 not null not default is 'exp.dmf.lg.lfb_stat_forc
e', kbytes integer4 not null not default is 'exp.dmf.lg.lfb_stat_kbyt
es', log_read_ios integer4 not null not default is 'exp.dmf.lg.lfb_st
at_log_readio', log_write_ios integer4 not null not default is 'exp.d
mf.lg.lfb_stat_log_writeio', split_waits integer4 not null not
default is 'exp.dmf.lg.lfb_stat_split', log_waits integer4 not null
not default is 'exp.dmf.lg.lfb_stat_wait', log_writes integer4 not
null not default is 'exp.dmf.lg.lfb_stat_write', writeio integer4 not
null not default is 'exp.dmf.lg.lfb_stat_writeio', prim_last_block
integer4 not null not default is 'exp.dmf.lg.lfb_dual_channel_blk',
dual_last_block integer4 not null not default is 'exp.dmf.lg.lfb_chan
nel_blk', lfbb_size integer4 not null not default is 'exp.dmf.lg.lgd_
lfbb_size', ldb_inuse integer4 not null not default is 'exp.dmf.lg.lg
d_ldb_inuse', ldbb_count integer4 not null not default is 'exp.dmf.lg
..lgd_ldbb_count', lfbb_count integer4 not null not default is 'exp.dm
f.lg.lgd_lfbb_count', lpb_inuse integer4 not null not default is 'exp
..dmf.lg.lgd_lpb_inuse', lpb_allocated integer4 not null not default
is 'exp.dmf.lg.lgd_lpbb_count', lpd_inuse integer4 not null not
default is 'exp.dmf.lg.lgd_lpd_inuse', lpd_allocated integer4 not
null not default is 'exp.dmf.lg.lgd_lpdb_count', lxb_inuse integer4
not null not default is 'exp.dmf.lg.lgd_lxb_inuse', lxbb_allocated
integer4 not null not default is 'exp.dmf.lg.lgd_lxbb_count', no_bcp
integer4 not null not default is 'exp.dmf.lg.lgd_no_bcp',
protect_count integer4 not null not default is 'exp.dmf.lg.lgd_protec
t_count', db_add integer4 not null not default is 'exp.dmf.lg.lgd_sta
t.add', bcp_stall_waits integer4 not null not default is 'exp.dmf.lg.
lgd_stat.bcp_stall_wait', txn_begins integer4 not null not default is
'exp.dmf.lg.lgd_stat.begin', dual_readio integer4 not null not
default is 'exp.dmf.lg.lgd_stat.dual_readio', dual_writeio integer4
not null not default is 'exp.dmf.lg.lgd_stat.dual_writeio',
lgd_txn_ends integer4 not null not default is 'exp.dmf.lg.lgd_stat.en
d', force integer4 not null not default is 'exp.dmf.lg.lgd_stat.force
', free_waits integer4 not null not default is 'exp.dmf.lg.lgd_stat.f
ree_wait', group_count integer4 not null not default is 'exp.dmf.lg.l
gd_stat.group_count', group_force integer4 not null not default is 'e
xp.dmf.lg.lgd_stat.group_force', inconsistent_db integer4 not null
not default is 'exp.dmf.lg.lgd_stat.inconsist_db', kbytes_written
integer4 not null not default is 'exp.dmf.lg.lgd_stat.kbytes',
log_readio integer4 not null not default is 'exp.dmf.lg.lgd_stat.log_
readio', log_writeio integer4 not null not default is 'exp.dmf.lg.lgd
_stat.log_writeio', pgyback_check integer4 not null not default is 'e
xp.dmf.lg.lgd_stat.pgyback_check', pgyback_write integer4 not null
not default is 'exp.dmf.lg.lgd_stat.pgyback_write', readio integer4
not null not default is 'exp.dmf.lg.lgd_stat.readio', db_remove
integer4 not null not default is 'exp.dmf.lg.lgd_stat.remove', split
integer4 not null not default is 'exp.dmf.lg.lgd_stat.split',
stall_wait integer4 not null not default is 'exp.dmf.lg.lgd_stat.stal
l_wait', wait integer4 not null not default is 'exp.dmf.lg.lgd_stat.w
ait', log_write integer4 not null not default is 'exp.dmf.lg.lgd_stat
..write', lgd_writeio integer4 not null not default is 'exp.dmf.lg.lgd
_stat.writeio' ) as import from 'tables' with dbms = ima,
structure=sortkeyed, key=(vnode)
\p\g
execute immediate register table qsf_dbp ( server varchar(64) not
null not default is 'SERVER', dbp_index integer4 not null not default
is 'exp.qsf.qso.dbp.index', proc_name varchar(64) not null not
default is 'exp.qsf.qso.dbp.name', proc_owner varchar(32) not null
not default is 'exp.qsf.qso.dbp.owner', proc_size integer4 not null
not default is 'exp.qsf.qso.dbp.size', proc_dbid integer4 not null
not default is 'exp.qsf.qso.dbp.udbid', usage_count integer4 not null
not default is 'exp.qsf.qso.dbp.usage' ) as import from 'tables' with
dbms = ima, structure=unique sortkeyed, key=(server,dbp_index)
\p\g
execute immediate register table qsf_pool ( server varchar(64) not
null not default is 'SERVER', buckets_used integer4 not null not
default is 'exp.qsf.qsr.qsr_bkts_used', bucket_max_objs integer4 not
null not default is 'exp.qsf.qsr.qsr_bmaxobjs', decay_factor integer4
not null not default is 'exp.qsf.qsr.qsr_decay_factor', memory_left
integer4 not null not default is 'exp.qsf.qsr.qsr_memleft',
memory_total integer4 not null not default is 'exp.qsf.qsr.qsr_memtot
' , max_master_objs integer4 not null not default is 'exp.qsf.qsr.qsr
_mx_index', max_named_objs integer4 not null not default is 'exp.qsf.
qsr.qsr_mx_named', max_req_size integer4 not null not default is 'exp
..qsf.qsr.qsr_mx_rsize', max_stored_size integer4 not null not default
is 'exp.qsf.qsr.qsr_mx_size', max_unnamed_objs integer4 not null not
default is 'exp.qsf.qsr.qsr_mx_unnamed', max_buckets integer4 not
null not default is 'exp.qsf.qsr.qsr_mxbkts_used', max_objects
integer4 not null not default is 'exp.qsf.qsr.qsr_mxobjs',
max_sessions integer4 not null not default is 'exp.qsf.qsr.qsr_mxsess
', named_requests integer4 not null not default is 'exp.qsf.qsr.qsr_n
amed_requests', bucket_count integer4 not null not default is 'exp.qs
f.qsr.qsr_nbuckets', no_destroyed integer4 not null not default is 'e
xp.qsf.qsr.qsr_no_destroyed', no_index integer4 not null not default
is 'exp.qsf.qsr.qsr_no_index', named_objs integer4 not null not
default is 'exp.qsf.qsr.qsr_no_named', unnamed_objs integer4 not null
not default is 'exp.qsf.qsr.qsr_no_unnamed', total_objs integer4 not
null not default is 'exp.qsf.qsr.qsr_nobjs', session_count integer4
not null not default is 'exp.qsf.qsr.qsr_nsess' ) as import from 'tab
les' with dbms = ima, structure=sortkeyed, key=(server)
\p\g
execute immediate register table qsf_rqp ( server varchar(64) not
null not default is 'SERVER', query_index integer4 not null not
default is 'exp.qsf.qso.rqp.index', query_name varchar(64) not null
not default is 'exp.qsf.qso.rqp.name', query_size integer4 not null
not default is 'exp.qsf.qso.rqp.size', query_dbix integer4 not null
not default is 'exp.qsf.qso.rqp.udbid', usage_count integer4 not null
not default is 'exp.qsf.qso.rqp.usage' ) as import from 'tables' with
dbms = ima, structure=sortkeyed, key=(server)
\p\g
execute immediate register table registered_servers ( name_server
varchar(64) not null not default is 'SERVER', listen_address
varchar(64) not null not default is 'exp.gcf.gcn.server.address',
server_class varchar(32) not null not default is 'exp.gcf.gcn.server.
class', server_dblist varchar(32) not null not default is 'exp.gcf.gc
n.server.object' ) as import from 'tables' with dbms = ima,
structure=unique sortkeyed, key=(name_server,listen_address)
\p\g
execute immediate register table resources ( vnode varchar(64) not
null not default is 'VNODE', resource_id integer4 not null not
default is 'exp.dmf.lk.rsb_id.id_id', convert_mode_s varchar(12) not
null not default is 'exp.dmf.lk.rsb_convert_mode', convert_mode
integer4 not null not default is 'exp.dmf.lk.rsb_convert_mode_num',
grant_mode_s varchar(12) not null not default is 'exp.dmf.lk.rsb_gran
t_mode', grant_mode integer4 not null not default is 'exp.dmf.lk.rsb_
grant_mode_num', invalid integer4 not null not default is 'exp.dmf.lk
..rsb_invalid', resource_name varchar(64) not null not default is 'exp
..dmf.lk.rsb_name', name0 integer4 not null not default is 'exp.dmf.lk
..rsb_name0', name1 integer4 not null not default is 'exp.dmf.lk.rsb_n
ame1', name2 integer4 not null not default is 'exp.dmf.lk.rsb_name2',
name3 integer4 not null not default is 'exp.dmf.lk.rsb_name3', name4
integer4 not null not default is 'exp.dmf.lk.rsb_name4', name5
integer4 not null not default is 'exp.dmf.lk.rsb_name5', name6
integer4 not null not default is 'exp.dmf.lk.rsb_name6', value0
integer4 not null not default is 'exp.dmf.lk.rsb_value0', value1
integer4 not null not default is 'exp.dmf.lk.rsb_value1' ) as import
from 'tables' with dbms = ima, structure=unique sortkeyed,
key=(vnode, resource_id)
\p\g
execute immediate register table sess_gg ( server varchar(64) not
null not default is 'SERVER', session_id varchar(32) not null not
default is 'exp.scf.scs.scb_self', client_pid integer4 not null not
default is 'exp.scf.scs.scb_client_pid', client_user varchar(32) not
null not default is 'exp.scf.scs.scb_client_user', effective_user
varchar(32) not null not default is 'exp.scf.scs.scb_euser',
effective_group varchar(32) not null not default is 'exp.scf.scs.scb_
group' ) as import from 'tables' with dbms = ima, structure=unique
sortkeyed, key=(server, session_id)
\p\g
execute immediate register table session_lastquery ( server
varchar(64) not null not default is 'SERVER', session_index integer4
not null not default is 'exp.scf.scs.scb_index', session_id
varchar(32) not null not default is 'exp.scf.scs.scb_self',
query_text varchar(1024) not null not default is 'exp.scf.scs.scb_las
tquery' ) as import from 'tables' with dbms = ima, structure=unique
sortkeyed, key=(server,session_index)
\p\g
execute immediate register table session_os_stats ( server
varchar(64) not null not default is 'SERVER', session_index
varchar(16) not null not default is 'exp.clf.unix.cs.scb_index',
session_id varchar(32) not null not default is 'exp.clf.unix.cs.scb_s
elf', scb_owner integer4 not null not default is 'exp.clf.unix.cs.scb
_owner', pid integer4 not null not default is 'exp.clf.unix.cs.scb_pi
d', ppid integer4 not null not default is 'exp.clf.unix.cs.scb_ppid',
session_type_s varchar(32) not null not default is 'exp.clf.unix.cs.s
cb_thread_type', session_type integer4 not null not default is 'exp.c
lf.unix.cs.scb_thread_type_num', comm_ios integer4 not null not
default is 'exp.clf.unix.cs.scb_bio', client_type integer4 not null
not default is 'exp.clf.unix.cs.scb_client_type', condition integer4
not null not default is 'exp.clf.unix.cs.scb_cnd', connect_time
integer4 not null not default is 'exp.clf.unix.cs.scb_connect',
cpu_used integer4 not null not default is 'exp.clf.unix.cs.scb_cputim
e', disk_ios integer4 not null not default is 'exp.clf.unix.cs.scb_di
o', kernel_cpu_used integer4 not null not default is 'exp.clf.unix.cs
..scb_inkernel', lock_count integer4 not null not default is 'exp.clf.
unix.cs.scb_locks', session_mask_s varchar(64) not null not default
is 'exp.clf.unix.cs.scb_mask', stack_size integer4 not null not
default is 'exp.clf.unix.cs.scb_stk_size', current_mode integer4 not
null not default is 'exp.clf.unix.cs.scb_mode', next_mode integer4
not null not default is 'exp.clf.unix.cs.scb_nmode', session_state_s
varchar(64) not null not default is 'exp.clf.unix.cs.scb_state',
session_state integer4 not null not default is 'exp.clf.unix.cs.scb_s
tate_num', username varchar(64) not null not default is 'exp.clf.unix
..cs.scb_username', session_mask integer4 not null not default is 'exp
..clf.unix.cs.scb_mask_num', wait_reason varchar(16) not null not
default is 'exp.clf.unix.cs.scb_memory' ) as import from 'tables'
with dbms = ima, structure=unique sortkeyed, key=(server,session_id)
\p\g
execute immediate register table session_stats ( server varchar(64)
not null not default is 'SERVER', session_index integer4 not null not
default is 'exp.scf.scs.scb_index', session_id varchar(32) not null
not default is 'exp.scf.scs.scb_self', activity_detail varchar(128)
not null not default is 'exp.scf.scs.scb_act_detail', activity
varchar(64) not null not default is 'exp.scf.scs.scb_activity',
appl_code integer4 not null not default is 'exp.scf.scs.scb_appl_code
', connect_limit integer4 not null not default is 'exp.scf.scs.scb_co
nnect_limit', facility_index integer4 not null not default is 'exp.sc
f.scs.scb_facility_index', facility_name varchar(12) not null not
default is 'exp.scf.scs.scb_facility_name', assoc_id integer4 not
null not default is 'exp.scf.scs.scb_gca_assoc_id', idle_limit
integer4 not null not default is 'exp.scf.scs.scb_idle_limit',
curr_connect_limit integer4 not null not default is 'exp.scf.scs.scb_
initial_connect_limit', curr_idle_limit integer4 not null not default
is 'exp.scf.scs.scb_initial_idle_limit', sec_label varchar(64) not
null not default is 'exp.scf.scs.scb_initial_security_label',
priority integer4 not null not default is 'exp.scf.scs.scb_priority',
priority_limit integer4 not null not default is 'exp.scf.scs.scb_prio
rity_limit', query_text varchar(1024) not null not default is 'exp.sc
f.scs.scb_query', role varchar(32) not null not default is 'exp.scf.s
cs.scb_role', curr_sec_label varchar(64) not null not default is 'exp
..scf.scs.scb_security_label' ) as import from 'tables' with dbms =
ima, structure=unique sortkeyed, key=(server,session_index)
\p\g
execute immediate register table session_stats_new ( server
varchar(64) not null not default is 'SERVER', session_index integer4
not null not default is 'exp.scf.scs.scb_index', session_id
varchar(32) not null not default is 'exp.scf.scs.scb_self',
activity_detail varchar(128) not null not default is 'exp.scf.scs.scb
_act_detail', activity varchar(64) not null not default is 'exp.scf.s
cs.scb_activity', appl_code integer4 not null not default is 'exp.scf
..scs.scb_appl_code', connect_limit integer4 not null not default is '
exp.scf.scs.scb_connect_limit', facility_index integer4 not null not
default is 'exp.scf.scs.scb_facility_index', facility_name
varchar(12) not null not default is 'exp.scf.scs.scb_facility_name',
assoc_id integer4 not null not default is 'exp.scf.scs.scb_gca_assoc_
id', idle_limit integer4 not null not default is 'exp.scf.scs.scb_idl
e_limit', curr_connect_limit integer4 not null not default is 'exp.sc
f.scs.scb_initial_connect_limit', curr_idle_limit integer4 not null
not default is 'exp.scf.scs.scb_initial_idle_limit', sec_label
varchar(64) not null not default is 'exp.scf.scs.scb_initial_security
_label', priority integer4 not null not default is 'exp.scf.scs.scb_p
riority', priority_limit integer4 not null not default is 'exp.scf.sc
s.scb_priority_limit', query_text varchar(1024) not null not default
is 'exp.scf.scs.scb_query', role varchar(32) not null not default is
'exp.scf.scs.scb_role', curr_sec_label varchar(64) not null not
default is 'exp.scf.scs.scb_security_label' ) as import from 'tables'
with dbms = ima, structure=unique sortkeyed, key=(server,session_id)
\p\g
execute immediate register table sessions ( server varchar(64) not
null not default is 'SERVER', session_index integer4 not null not
default is 'exp.scf.scs.scb_index', session_id varchar(32) not null
not default is 'exp.scf.scs.scb_self', client_connect varchar(32) not
null not default is 'exp.scf.scs.scb_client_connect', client_host
varchar(32) not null not default is 'exp.scf.scs.scb_client_host',
client_info varchar(128) not null not default is 'exp.scf.scs.scb_cli
ent_info', client_pid integer4 not null not default is 'exp.scf.scs.s
cb_client_pid', client_tty varchar(32) not null not default is 'exp.s
cf.scs.scb_client_tty', client_user varchar(32) not null not default
is 'exp.scf.scs.scb_client_user', db_name varchar(32) not null not
default is 'exp.scf.scs.scb_database', db_lockmode varchar(32) not
null not default is 'exp.scf.scs.scb_dblockmode', db_owner
varchar(32) not null not default is 'exp.scf.scs.scb_dbowner',
description varchar(64) not null not default is 'exp.scf.scs.scb_desc
ription', effective_user varchar(32) not null not default is 'exp.scf
..scs.scb_euser', effective_group varchar(32) not null not default is
'exp.scf.scs.scb_group', server_pid integer4 not null not default is
'exp.scf.scs.scb_pid', real_user varchar(32) not null not default is
'exp.scf.scs.scb_ruser', session_name varchar(32) not null not
default is 'exp.scf.scs.scb_s_name', terminal varchar(32) not null
not default is 'exp.scf.scs.scb_terminal' ) as import from 'tables'
with dbms = ima, structure=unique sortkeyed, key=(server,
session_index)
\p\g
execute immediate register table sessions_new ( server varchar(64)
not null not default is 'SERVER', session_index integer4 not null not
default is 'exp.scf.scs.scb_index', session_id varchar(32) not null
not default is 'exp.scf.scs.scb_self', client_connect varchar(32) not
null not default is 'exp.scf.scs.scb_client_connect', client_host
varchar(32) not null not default is 'exp.scf.scs.scb_client_host',
client_info varchar(128) not null not default is 'exp.scf.scs.scb_cli
ent_info', client_pid integer4 not null not default is 'exp.scf.scs.s
cb_client_pid', client_tty varchar(32) not null not default is 'exp.s
cf.scs.scb_client_tty', client_user varchar(32) not null not default
is 'exp.scf.scs.scb_client_user', db_name varchar(32) not null not
default is 'exp.scf.scs.scb_database', db_lockmode varchar(32) not
null not default is 'exp.scf.scs.scb_dblockmode', db_owner
varchar(32) not null not default is 'exp.scf.scs.scb_dbowner',
description varchar(64) not null not default is 'exp.scf.scs.scb_desc
ription', effective_user varchar(32) not null not default is 'exp.scf
..scs.scb_euser', effective_group varchar(32) not null not default is
'exp.scf.scs.scb_group', server_pid integer4 not null not default is
'exp.scf.scs.scb_pid', real_user varchar(32) not null not default is
'exp.scf.scs.scb_ruser', session_name varchar(32) not null not
default is 'exp.scf.scs.scb_s_name', terminal varchar(32) not null
not default is 'exp.scf.scs.scb_terminal' ) as import from 'tables'
with dbms = ima, structure=unique sortkeyed, key=(server, session_id)
\p\g
execute immediate register table transactions ( vnode varchar(64) not
null not default is 'VNODE', txn_index integer4 not null not default
is 'exp.dmf.lg.lxb_id.id_id', cp_address varchar(32) not null not
default is 'exp.dmf.lg.lxb_cp_lga', cp_offset integer4 not null not
default is 'exp.dmf.lg.lxb_cp_lga.la_offset', cp_trip integer4 not
null not default is 'exp.dmf.lg.lxb_cp_lga.la_sequence', db_id
integer4 not null not default is 'exp.dmf.lg.lxb_db_id_id', db_name
varchar(32) not null not default is 'exp.dmf.lg.lxb_db_name',
db_owner varchar(32) not null not default is 'exp.dmf.lg.lxb_db_owner
' , dst_txn varchar(32) not null not default is 'exp.dmf.lg.lxb_dis_t
ran_id_hexdump', first_log_rec varchar(32) not null not default is 'e
xp.dmf.lg.lxb_first_lga', first_log_offset integer4 not null not
default is 'exp.dmf.lg.lxb_first_lga.la_offset', first_log_trip
integer4 not null not default is 'exp.dmf.lg.lxb_first_lga.la_sequenc
e', instance integer4 not null not default is 'exp.dmf.lg.lxb_id.id_i
nstance', prepared varchar(32) not null not default is 'exp.dmf.lg.lx
b_is_prepared', dist_txid varchar(16) not null not default is 'exp.dm
f.lg.lxb_is_xa_dis_tran_id', last_log_rec varchar(32) not null not
default is 'exp.dmf.lg.lxb_last_lga', last_log_offset integer4 not
null not default is 'exp.dmf.lg.lxb_last_lga.la_offset',
last_log_trip integer4 not null not default is 'exp.dmf.lg.lxb_last_l
ga.la_sequence', last_lsn varchar(32) not null not default is 'exp.dm
f.lg.lxb_last_lsn', last_lsn_trip integer4 not null not default is 'e
xp.dmf.lg.lxb_last_lsn_high', last_lsn_offset integer4 not null not
default is 'exp.dmf.lg.lxb_last_lsn_low', pid integer4 not null not
default is 'exp.dmf.lg.lxb_pid', pr_id integer4 not null not default
is 'exp.dmf.lg.lxb_pr_id_id', reserved_bytes integer4 not null not
default is 'exp.dmf.lg.lxb_reserved_space', sequence integer4 not
null not default is 'exp.dmf.lg.lxb_sequence', session_id varchar(32)
not null not default is 'exp.dmf.lg.lxb_sid', log_forces integer4 not
null not default is 'exp.dmf.lg.lxb_stat.force', log_split_waits
integer4 not null not default is 'exp.dmf.lg.lxb_stat.split',
log_waits integer4 not null not default is
'exp.dmf.lg.lxb_stat.wait', log_writes integer4 not null not default
is 'exp.dmf.lg.lxb_stat.write', status_s varchar(64) not null not
default is 'exp.dmf.lg.lxb_status', status integer4 not null not
default is 'exp.dmf.lg.lxb_status_num', txn_id_s varchar(16) not null
not default is 'exp.dmf.lg.lxb_tran_id', txn_id_high integer4 not
null not default is 'exp.dmf.lg.lxb_tran_id.db_high_tran', txn_id_low
integer4 not null not default is
'exp.dmf.lg.lxb_tran_id.db_low_tran', user_name varchar(32) not null
not default is 'exp.dmf.lg.lxb_user_name', wait_reason_s varchar(64)
not null not default is 'exp.dmf.lg.lxb_wait_reason', wait_reason
integer4 not null not default is 'exp.dmf.lg.lxb_wait_reason_num' )
as import from 'tables' with dbms = ima, structure=unique sortkeyed,
key=(vnode,txn_id_s)
\p\g



SQL script


select

hex(int4(a.session_id)),

a.client_pid,

a.real_user, 'LOCKED'

from sessions a, locks l, locklists ll

where a.session_id =ll.session_id and

l.lock_id=ll.waiting_lock_id_id and

l.locklist_id=ll.locklist_id

and ll.status_s='WAITING' and

l.lock_state_s <>'GRANTED' union

select hex(int4(s.session_id)),

s.client_pid, s.real_user, 'LOCKING'

from locklists a, locks b, sessions s

where s.session_id=a.session_id and

a.locklist_id=b.locklist_id and

b.lock_state_s='GRANTED' and

b.resource_id=

(

select

l.resource_id

from locks l, locklists ll

where

l.lock_id=ll.waiting_lock_id_id and

l.locklist_id=ll.locklist_id

and ll.status_s='WAITING' and

l.lock_state_s <>'GRANTED'

)


Sample of how it works

I made two queries which are locking.

#9474;59a976e0#9474;ingres #9474;pts/23#9474;mk #9474;BIO #9474; #9474; #9474;
#9474;59bac040#9474;renfrowa #9474;batch #9474;mk #9474;COM #9474;QEF#9474;DELETE #9474;
#9474;59bc0de0#9474;ingres #9474;pts/25#9474;mk #9474;LOCK #9474;QEF#9474;insert into armand value#9474;
#9474;59c94040#9474;ingres #9474;pts/26#9474; #9474;COM #9474; #9474; #9474;
#9492;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9524;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9524;#9472; #9472;#9472;#9472;#9472;#9472;#9524;#9472;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9524;#9472;#9472;#9472;#9472;#9472;#9472; #9524;#9472;#9472;#9472;#9524;#9472;#9472;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472; #9472;#9472;#9472;#9472;

The result of the sql scripts

#9484;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9516;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9516;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9516;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9488;
#9474;col1 #9474;client_pid #9474;real_user #9474;col4 #9474;
#9500;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9532;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9532;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9532;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9508;
#9474;59A976E0#9474; 115100#9474;ingres #9474;LOCKING#9474;
#9474;59BC0DE0#9474; 118766#9474;ingres #9474;LOCKED #9474;
#9492;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9524;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9524;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#947 2;#9472;#9472;#9472;#9472;#9472;#9472;#9472;#9472; #9472;#9472;#9472;#9472;#9472;#9472;#9524;#9472;#9 472;#9472;#9472;#9472;#9472;#9472;#9496;


Hope this helps.

Armand





Gareth Williams <Gareth.Williams (AT) bromor-tr (DOT) wales.nhs.uk> wrote:

I've been trying to use the IMA objects to immediately identify who's holding locks other need.

It's seems the example in the 2.6 manual entitled "Who Is Holding a Lock Others Need?" has the wrong syntax or joins.

Anyone successfully used ima to track locks? If so can I "borrow" some sql from you please.

Thanks again

Gareth



Cymraeg:- Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn
bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ohebiaeth a dderbynnir, yn
unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio at wefan
Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:- This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information&nbsp;Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further information on Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.





================================================== =====
Armand

"If I had only known, I would have been a locksmith."
Albert Einstein
================================================== =====