Home » RDBMS Server » Server Administration » Segment space release - ASM (Oracle 10g R2, SUN OS 5.10)
Segment space release - ASM [message #306649] Sat, 15 March 2008 07:43
Messages: 1
Registered: March 2008
Location: Dubai
Junior Member
Dear All,

How to monitor the segment space which is relased by a table segment which created within a big file tablespace on ASM file system.

You can observe that, 'dba_segments.blocks' gets modified as and when any truncate or drop performed on tradional file (in this case UNIX) system.

But somehow I couldn't find any change in the 'dba_segment' view after a truncate or drop carried on oracle database which is live on ASM file system.

The only differnce is file system which is supporting the above mentioned databases.

Request all your valuable inputs on this.

Oracle & ASM version =
OS & Machine = SUN OS 5.10 sun4us sparc FJSV,GPUZC-M

Previous Topic: 'SYS' User login error
Next Topic: Oracle 9i and 10g...difference from DB Administration and Developing View
Goto Forum:

Current Time: Tue Oct 25 12:40:38 CDT 2016

Total time taken to generate the page: 0.22256 seconds