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: Sat Jul 22 04:20:39 CDT 2017

Total time taken to generate the page: 0.09921 seconds