The ogg copy process of the temp table space occupies

Source: Internet
Author: User

There is a change in demand, need to extract data to the pressure measurement environment, in the IMPDP import process found. .
. . Imported "RCS". " T_rcs_mer_day ":" PMAX "0 KB 0 rows
Processing Object Type Table_export/table/comment
Processing Object Type Table_export/table/index/index
Always stuck, according to experience should be the table has an index table space, it should be the index table space, or the temporary table space is insufficient to cause hang. Check the alert log;
Mon June 04 15:47:31 2018
Statement in resumable session ' SYS. sys_import_full_01.1 ' is suspended due to
Ora-01652:unable to extend temp segment by tablespace Rcs_idx
Sure enough, there is a warning that the process should be stopped. Let's resize the index table space first.
Mon June 04 16:06:14 2018
ALTER DATABASE datafile '/u01/yace/datafile/yace/rcs_idx_01.dbf ' RESIZE 30G
Mon June 04 16:06:26 2018
Completed:alter DATABASE datafile '/u01/yace/datafile/yace/rcs_idx_01.dbf ' RESIZE 30G
Mon June 04 16:06:26 2018
Statement in resumable session ' SYS. sys_import_full_01.1 ' was resumed
Then there is a prompt for task recovery, and then the import work is completed
Processing Object Type Table_export/table/comment
Processing Object Type Table_export/table/index/index
Processing Object Type Table_export/table/constraint/constraint
Processing Object Type Table_export/table/index/statistics/index_statistics
Processing Object Type Table_export/table/statistics/table_statistics
The Job "SYS". Sys_import_full_01 "successfully completed at Mon June 4 16:09:10 2018 Elapsed 0 00:23:05

Kinda funny lately and temp table space bar on Ha, let's see what's taking advantage of the temp table space.
SELECT se.username, SE. SID, se.serial#, se.sql_address, Se.machine, Se.program, Su. Tablespace,su.segtype, Su. CONTENTS from
V$session se, v$sort_usage su WHERE se.saddr = su.session_addr;

Is OGG user occupancy, is there a delay in the replication process?
[Email protected] ggs12]$./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jul 21 2017 20:31:38
Operating system Character set identified as UTF-8.

Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

Ggsci (yace) 1> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING
EXTRACT RUNNING extzw 00:00:00 00:00:05
EXTRACT RUNNING PMPZW 00:00:00 00:00:05
Replicat RUNNING REPZW 00:00:00 00:00:04

Ggsci (yace) 2> info REPZW

Replicat REPZW last Started 2018-05-10 18:58 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 98477
Log Read Checkpoint file/home/oracle/ogg/ggs12/dirdat/t1000000040
2018-06-04 16:37:32.000442 RBA 84950052

Use the following statement to see what statements occupy the temp table space
Sql> Set lines pages 200
Sql> Set Long 999999999
Sql> Select Se.username,se.sid,su.extents,su.blocks*to_number (RTrim (P.value)) as Space,tablespace,segtype,sql_ Text
From V$sort_usage su,v$parameter p,v$session se,v$sql s
where P.name= ' db_block_size ' and su.session_addr=se.saddr and S.hash_value=su.sqlhash and S.ADDRESS=SU.SQLADDR
Order BY Se.username,se.sid;

UPDATE ogg.checkpointtable SET last_update_ts = sysdate, seqno =: seqno, RBA =: RBA, Audit_ts =: audit_ts, LOG_BSN =: Log_ BSN, LOG_CSN =: LOG_CSN, Log_xid =: Log_xid, LOG_CMPLT_CSN =: LOG_CMPLT_CSN, Log_cmplt_xids =: log_cmplt_xids, Version =: Version WHERE Group_name =: group_name and Group_key =: key

As to how to solve the problem, you can't kill the process, mark.

The ogg copy process of the temp table space occupies

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.