Re: Multiple extents in system tablespace
Date: Tue, 4 Oct 94 21:23:00 -0300
Message-ID: <2aa.555.846%mpcbbs_at_ibase.org.br>
On 4 Oct 94 07:58pm, wrote to ALL:
> Newsgroup: comp.databases.oracle
> Organization: Eli Lilly and Company
> In article <1994Oct1.131545.1321_at_gtewd.mtv.gtegsc.com>,
> davidsonj_at_gtewd.mtv.gtegsc.com writes: > I have noticed that my system
> tablespace has a lot of segments with multiple > extents (some as many as
> 20 extents). Will this impact performance of stored > procedures? Or
> anything else?
I think that you WHANT to improve the performance of your database, right?! Don't care about it! My tip: use TKPROF and improve your applications. You also can look for some row chaining or blocks with few rows (wrong PCTUSED/PCTFREE). Spend your time on HOT AREAS!
bye,
----->>>>>>>>>>>> Don't reply. Reply will not work! <<<<<<<<<<<<<<----
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 | | Software Design Informatica | Fax : +55.192.54.6518 | | Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br | | Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) | |---------------------------------------------------------------------------| | Softex 2000 member | Brazil, Sao Paulo state, Campinas city | =============================================================================
- Evaluation copy of Silver Xpress. Day # 102
--- via Silver Xpress V4.01P [NR]
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Wed Oct 05 1994 - 01:23:00 CET