Home » Tables » Oracle Dc_Tablespace_Quotas

Oracle Dc_Tablespace_Quotas

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?

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

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

, The ‘ oracle 8i internal services’ book does this to some degree, but also leaves a number of events out.

Thanks.

and we said.

Of: a) average wait time or b) total wait time or c) total waits.

dc_tablespace_quotas 0 0 0 6 46 dc_tablespaces 12,505 0.

0 0 0 11 73.

, Oracle recommends using automatic memory management to manage the memory on your system.

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_used_extents 51418 20249 60.

6 42,811 dc_user_grants 76082 18 100.

0 0 dc_usernames 216860 12 100.

0 0 dc_users 376895 22 100.

0 0 Examining.

oracle dc_tablespace_quotas