SQL & PL/SQL :: Understanding Dba_tab_modifications

Feb 21, 2012

This is the 10.2.0.4.0 database. To collect the object statistics, we are using the default GATHER_STATS_JOB. Totally I have 930 objects in my schema. but when I check the user_tab_modifications,it is only showing 344 objects. To understand the real concept, I have taken the below table for my analysis.

The below mentioned table got 3.7% changes since the last analyze.

1.) Why this table is not showing in dba_tab_modifications table?
2.) If 6.4% of changes happened in this table now, will oracle analyze this table today night?
3.) If your answer is 'YES' for the 2nd question, where it is keeping the information about 3.7% changes, since there is no information in dba_tab_modifications about this table?
4.) If your answer is 'NO' for the 2nd question,why it won't get analyzed?
5.) will oracle purge the older data from dba_tab_modifications table? if yes what is the frequency of this purging activity?

SQL> select count(*) from orca1;
COUNT(*)
----------
4493437

SQL> select TABLE_NAME,LAST_ANALYZED,NUM_ROWS,monitoring from user_tables where table_name='ORCA1';

TABLE_NAME LAST_ANAL NUM_ROWS MON
------------------------------ --------- ---------- ---
ORCA1 30-AUG-10 4332300 YES

SQL> select * from all_tab_modifications where table_name = 'ORCA1';

no rows selected.

View 10 Replies


ADVERTISEMENT

Backup & Recovery :: Understanding FRA Files

May 4, 2011

I have been experimenting with RMAN over the past few days and have a fairly strong grasp on it. I setup a test scenario using a three tier incremental approach as follows:

Every four weeks take level 0
Every 7 days take level 1
Every day take level 2

Obviously I'm only taking one per day, so on days I take a level 0, I'm not taking a level 1 or 2. My scripts look similar to the following, with change to incremental level number.

rman target / <<EOF
run {
configure device type disk parallelism 4 backup type to compressed backupset;
configure default device type to disk;
configure backup optimization off;
configure controlfile autobackup on;
configure retention policy to recovery window of 4 days;
[code]......

What I'm trying to understand is what files Oracle is creating in the flash recovery area. I have several sets of files:

In the root level of the FRA, I see several files per incremental backup with names such as aambg4sa_1_1, aqmbg5mj_1_1, b6mbg614_1_1, etc. I was under the impression that these were the incremental backup pieces, multiple files because I'm using parallelism of 4.

Under a /FRA/<SID> I see 3 directories: archivelog, autobackup, and backupset. I assume arhivelog is where Oracle is archiving the redo logs, autobackup is storing the SPFILE and CONTROLFILE as I have enabled controlfile autobackup. However, what is being stored in backupset?

When I do a crosscheck, it lists the files within backupset, but does not list the several files under the root of FRA (b6mbg614_1_1 and so on).

What's the difference between /FRA/<SID>/backupset and the files under root FRA? Do I need both for recovery - and if not, why is Oracle keeping both?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved