Home » Tables » Dc_Tablespace_Quotas

Dc_Tablespace_Quotas

01/11/2012 Coud some one please explain me wht does dc_tablespace_quotas enque type means, what exactly it is doing?

Is there any remedy to overcome this kind of thing?

I have the same question Show 0 Likes.

373 Views Tags: 1.

Re: what does dc_tablespace_quotas means?

sb92075 Oct.

, 12/11/2012 PARAMETER COUNT GETS GETMISSES MODIFICATIONS —– —– —– —– —– dc_free_extents 0 0 0 0 dc_used_extents 0 0 0 0 dc_segments 5927 131379921 4142831 693734 dc_tablespaces 22 188609668 2436 0 dc_tablespace_quotas 12 22779303 3843 0 dc_files 0 165961 22493 21 dc_users 19 145681559 2078 21 dc_rollback_segments 67 3906307 66 232 dc_objects.

, 18/07/2012 My database is 10.

2.

0.

4 in solaris 2 node RAC.

Often i am seeing row cache lock on cache id 2 (dc_segments) and 5 ( dc_tablespace_quotas ).

All my tablespaces are locally managed with segment space allocation manual.

, 01/06/2006 > acquire row cache lock on dc_tablespace_quotas in this case and if there > is any way to skip this operation with ‘a clever ‘.

If you search on MetaLink with keyword ” dc_tablespace_quotas ” (with bug database search enabled), there are a few bugs related to data dictionary cache deadlocks.

, 31/05/2006 Anand Rao Luca, In LMT, Oracle acquired a row cache enqueue on dc_tablespace_quotas after a segment is built.

this could even be a partition exchange or add.

In DMT, it used to be worse, where Oracle acquired this enqueue to check quotas and add extents.

The quota checks are still performed but only at the end, even though you may have provided.

, This chapter describes how to tune the shared pool and the large pool.

If you are using automatic memory management to manage the database memory on your system, or automatic shared memory management to configure the Shared Global Area (SGA), there is no need to manually tune the shared pool and the large pool as described in this chapter.

, dc_tablespace_quotas 6.

00.

dc_tablespaces 582,952.

00.

dc_usernames 65,451.

02.

dc_users 3,753,587.

00.

outstanding_alerts 13,822 3.

43.

The Ion tool has a report named Dictionary Cache, represented in Figure 4.

12, which generates charts against the dba_hist_rowcache.

, Note 2918838.

8 Bug 2918838 Undetected deadlock for dc_tablespace_quotas.

Bugs Fixed in Version 9.

2.

0.

6.

Note 3398485.

8 Bug.

3398485 Deadlock during on demand materialized view refresh (ORA-4020) Note 2615271.

8 Bug.

2615271 Deadlock from concurrent GRANT and logon Note 2014833.

8 Bug.

2014833 Deadlock possible from concurrent SELECT and TRUNCATE, 05/06/2010 dc_tablespace_quotas 0 dc_used_extents 0 rule_fast_operators 0 dc_free_extents 0 60 rows selected The next step is to see whether latch miss source can give us some more hints regarding the issue: SQL> select “WHERE”, sleep_count, location, dc_tablespace_quotas 0 0 0 6 46 dc_tablespaces 12,505 0.

0 0 0 11 73 dc_used_extents 0 0 0 154 93 dc_user_grants 10,221 0.

1 0 0 29 74 dc_usernames 1,681 0.

1 0 0 13 59 dc_users 18,069 0.

1 0 0 30 77 ifs_acl_cache_entries 0 0 0 0 0.

dc_tablespace_quotas