Re: Obj$ table

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 30 Mar 2020 22:17:33 -0400

What do you mean by "defragment"? ASSM tablespaces have few possible extent sizes which means that there is no fragmentation as in largely forgotten dictionary managed tablespaces. Also, don't ever freak with dictionary tables.

On 3/30/20 8:16 PM, Ali Alizadeh wrote:

Hello expert
I am trying to defragment obj$ table.
Has anyone done this before?

I appreciate any suggestions !
Regards,
Ali

--
//www.freelists.org/webpage/oracle-l


--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
//www.freelists.org/webpage/oracle-l


Other related posts: