Block change Tracking -Enable -disable
[oracle@srv7 ~]$ sqlplus sys/system123@oradb11g as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon May 9 22:00:37 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc v$block_change_tracking;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(10)
FILENAME VARCHAR2(513)
BYTES NUMBER
SQL> select * from v$block_change_tracking;
STATUS
----------
FILENAME
--------------------------------------------------------------------------------
BYTES
----------
DISABLED
SQL> alter database enable block change tracking using file '/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/block_change_tracking.dbf';
Database altered.
SQL> select * from v$block_change_tracking;
STATUS
----------
FILENAME
--------------------------------------------------------------------------------
BYTES
----------
ENABLED
/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/block_change_tracking.dbf
11599872
SQL> SELECT *
FROM v$sgastat
WHERE name like 'CTWR%'; 2 3
POOL NAME BYTES
------------ -------------------------- ----------
large pool CTWR dba buffer 2146304
SQL> @tablespace
NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
ORADB11G READ WRITE PRIMARY oradb11g
Tablespace Allocated Current Used Available %Used (vs)
Name Size(GB) Size(GB) Size(GB) Size(GB) (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
EXAMPLE 32.00 .34 .30 31.70 .94
SYSAUX 32.00 .51 .48 31.52 1.49
SYSTEM 32.00 .73 .72 31.28 2.26
UNDOTBS1 32.00 .11 .10 31.90 .33
USERS 32.00 .00 .00 32.00 .01
SQL>
No comments:
Post a Comment