Home » Tables » Dc_Tablespace_Quotas Oracle

Dc_Tablespace_Quotas Oracle

01/11/2012 d/b ORACLE 11g R1 We have a query which is having row cache lock event and is waiting for more that 3 hours.

dc_tablespace_quotas 1 607 1 0 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?

, 01/06/2006 Cc: oracle -l_at_freelists.

org Subject: Re: Row cache lock wait issue in RAC 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.

, 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.

, 31/05/2006 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, Oracle Database uses the shared pool to cache many different types of data.

Cached data includes the textual and executable forms of PL/SQL blocks and SQL statements, dictionary cache data, result cache data, and other data.

16 99.

9 26,811 dc_synonyms 6617 168 97.

5 0 dc_tablespace_quotas 120 7 94.

2 51 dc_tablespaces 581248 10 100.

0 0 dc.

, 26/08/2012 Query 1 : dc_users 4066966381 dc_tablespaces 4018016215 dc_objects 2383364368 dc_rollback_segments 1295784977 dc_users 1022278979 dc_histogram_defs 820056347 dc_segments 215441370 dc_global_oids 65478943 dc_files 27367793 dc_object_grants 25343234 dc_histogram_data 10286544 dc_sequences 8285853 dc_tablespace_quotas 8274908 dc_users 7980860 dc.

, 05/01/2012 Oracle.

Browse.

8,790 129 dc_table_scns 8 100.

00 0 0 0 dc_tablespace_quotas 532 0.

00 0 0 58 dc_tablespaces 936,895 0.

00 0 0 109 dc_users 2,168,907 0.

00 0 0 466 global database name 147,539 0.

00 0 0 2 outstanding_alerts 533 0.

19 0 3 107 rule_info 8 100.

00 0 0 0 sch_lj_oids 16 12.

50 0 0 17.

, Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.

Feel free to ask questions on our Oracle forum.

, Oracle stores NLS settings in 3 levels: database/instance/session:.

3 4 dc_used_extents 4 2 dc_segments 5 0 dc_tablespaces 6 5 dc_tablespace_quotas 7 6 dc_files 8 7 dc_users 8 10 dc_users 9 8 dc_object_grants 9 8 dc_objects 10 17 dc_global_oids 11 12 dc_constraints 12 13 dc_sequences 13 16 dc_histogram_data 13 16 dc_histogram_defs 14 54 dc.

, 17/03/2011 Oracle has confirmed that due to an existing bug in 11.

2.

0.

1, described in doc 1162566.

1.

It looks like the issue occurs when there is a logon atempt that fails (not necessarily for this process), which required a row cache lock in order to modify the user data.

dc_tablespace_quotas oracle