DBA_在执行1亿条资料插入长脚本如何判断需耗时多久（案例）

1

create table bxj_xla_journals
(
  ledger_name varchar2(30),
  account varchar2(240),
  account_description varchar2(240),
  accounting_date date,
  accounted_dr number,
  accounted_cr number,
  gl_transfer_status varchar2(30),
  period_name varchar2(15),
  je_category_name varchar2(30)
)

insert into bxj_xla_journals
  select gl.name,
         fnd_flex_ext.get_segs(‘SQLGL‘,
                               ‘GL#‘,
                               gl.chart_of_accounts_id,
                               l.code_combination_id) ACCOUNT,
         xla_oa_functions_pkg.get_ccid_description(gl.chart_of_accounts_id,
                                                   l.code_combination_id) account_description,
         h.accounting_date,
         l.accounted_dr,
         l.accounted_cr,
         h.gl_transfer_status_code,
         h.period_name,
         h.je_category_name
    from xla_ae_headers h, xla_ae_lines l, xla_gl_ledgers_v gl
   where gl.ledger_id = h.ledger_id
     and h.ae_header_id = l.ae_header_id

check_users.sql在用户操作的情况

session_sql.sql在session中执行的sql

session_wait.sql在等待session的event

session_wait_sid在等待的session情况

session_xplan的解析计划确认

通过确认undo空间的大小变化

V$sessionlong

DBA_在执行1亿条资料插入长脚本如何判断需耗时多久（案例）,布布扣,bubuko.com