OraFAQ Forum: Server Administration » When is a extent added?

Home » RDBMS Server » Server Administration » When is a extent added?

Tue, 22 March 2005 01:03

webberwu
Messages: 2
Registered: March 2005

Junior Member

Hi,

I can find out each extent of a table from following script:

select extent_id, bytes from dba_extents where segment_name = 'D010S';

I want to know when the extents is added. Because I want to know the growth of a table.

How to do?

Tue, 22 March 2005 03:18

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

This depend on your table's data growth speed.

The following setting may affect the extent allocation:
1, PCTFREE
2, PCTUSED and delete operation

Previous Topic:	Problems with ORA-XXXXX Messages not in alert.log
Next Topic:	What is the max number of extents in Locally Manage TBS?

Goto Forum:

]

Current Time: Fri Jan 10 03:49:18 CST 2025