Prev: OEM, Or10
Next: constraint disable (no)validate
From: Paul Izzo on 7 Feb 2005 05:00
Is there a way with Oracle Enterprise Manager to view a given
tablespace's level of fragmentation?

From: Sybrand Bakker on 7 Feb 2005 06:12
On 7 Feb 2005 02:00:42 -0800, "Paul Izzo" <paul.izzo(a)mosca-ag.com>
wrote:

>Is there a way with Oracle Enterprise Manager to view a given
>tablespace's level of fragmentation?

Well you can look at the map of a tablespace.
However, with the demise of dictionary managed tablespaces and the
advent of locally managed tablespaces this would be a futile exercise.
A LMT doesn't fragment, and if it does the consequences for the
performance are nil.


--
Sybrand Bakker, Senior Oracle DBA
From: Paul Izzo on 7 Feb 2005 08:38
This question is in reference to a Oracle 8i database. How can I tell
as to which configuration I have for a current tablespace. I took a
look into the scripts that created a tablespace and I can't determine
if it's configured to use a dictionary or if it's locally managed.
Here's the script:

CREATE TABLE "W100"."PMLB" ("PMLBPHYS_AEND_IND" NUMBER(9) DEFAULT
0, "ARTIKEL_NR" VARCHAR2...
USING INDEX
TABLESPACE "W100_DATA"
STORAGE ( INITIAL 104K NEXT 104K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "W100_DATA" PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255
STORAGE ( INITIAL 8768K NEXT 104K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING

From: Sybrand Bakker on 7 Feb 2005 08:59
On 7 Feb 2005 05:38:27 -0800, "Paul Izzo" <paul.izzo(a)mosca-ag.com>
wrote:

>This question is in reference to a Oracle 8i database. How can I tell
>as to which configuration I have for a current tablespace. I took a
>look into the scripts that created a tablespace and I can't determine
>if it's configured to use a dictionary or if it's locally managed.
>Here's the script:
>
>CREATE TABLE "W100"."PMLB" ("PMLBPHYS_AEND_IND" NUMBER(9) DEFAULT
> 0, "ARTIKEL_NR" VARCHAR2...
> USING INDEX
> TABLESPACE "W100_DATA"
> STORAGE ( INITIAL 104K NEXT 104K MINEXTENTS 1 MAXEXTENTS
> 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
> PCTFREE 10 INITRANS 2 MAXTRANS 255)
> TABLESPACE "W100_DATA" PCTFREE 10 PCTUSED 40 INITRANS 1
> MAXTRANS 255
> STORAGE ( INITIAL 8768K NEXT 104K MINEXTENTS 1 MAXEXTENTS
> 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
> LOGGING

select extent_management from dba_tablespaces where tablespace_name =
'W100_DATA'

Should list local or dictionary, the default is dictionary.


--
Sybrand Bakker, Senior Oracle DBA
From: Paul Izzo on 7 Feb 2005 09:36
Thanks Sybrand,

It turns out that all of my tablespaces are using dictionary extent
management. Soon we'll be upgrading to 9i when we do so I'll suggest
creating the new tablespaces using locally managed tablespaces.

 |  Next  |  Last
Pages: 1 2
Prev: OEM, Or10
Next: constraint disable (no)validate