sql - Oracle snapshot too old and DBLINK -
i getting
ora-01555: snapshot old: rollback segment number 234 name "_syssmu234_1378897836$"
too smal while selecting data using dblink in oracle database.
select a,b localtab union select a,b rmottab@remotedb;
is there way override error?
have situation take data in periodical manner.
you need close cursor when finished retrieving data. problem holding cursor open long. there tons of reasons that: - row-by-row processing on client side. take forever finish. (the database waiting deliver data client) hint. arraysize (fetchsize) set low. arraysize of 100-200 can speed things up. - there nice view hidden behind "rmotab" takes > 30 minutes return burning cpu (logical reads)
basically, have these options:
- speed process. (end cursor (query) faster). bulk load.
- schedule process happen when no dml going on.
- materialized view (pre-load data (read-only))
- increase undo.
Comments
Post a Comment