Sydney Oracle Meetup

RE: [Sydney-Oracle] 90% of the blocks under HWM are over 75% free, but new records are still pushing up the HWM

From:	Nuno Pinto do Souto
Sent on:	Wednesday, December 16, 2009 6:10 PM

Funny, just spent the afternoon reorganizing some of our tables with similar problem! J

An example:

SQL> @gdstst

Enter DWDEVTEAM tname=>f_gl_monthly_balance_sl

PL/SQL procedure successfully completed.

UNFB

--------------

FS4B

--------------

160440320

FS3B

--------------

38010880

FS2B

--------------

42876928

FS1B

--------------

359866368

FULLB

--------------

[masked]

I’ve got all tablespaces in LOCAL but with UNIFORM: different sizes depending how big the tables are in that tablespace. That way I can move a table around without any concern that it’ll fit in available free space as all “free” slots are same size.

In our case, this is caused by extensive DELETEs, followed by INSERT with APPEND hint, for block inserts.

All new rows go beyond current HWM and it never gets reset because DELETE doesn’t reset it.

Slowly getting developers to change code to not use APPEND, or use it only in conjunction with TRUNCATE.

Cheers

Nuno Pinto do Souto

DBA Team

From: [address removed] [mailto:[address removed]] On Behalf Of Geoffrey Zhang
Sent: Wednesday, 16 December 2009 5:48 PM
To: [address removed]
Subject: [Sydney-Oracle] 90% of the blocks under HWM are over 75% free, but new records are still pushing up the HWM

http://www.sydneyoracle.com.au/messages/boards/thread/8240163

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Geoffrey Zhang ([address removed]) from Sydney Oracle Meetup.
To learn more about Geoffrey Zhang, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup Inc. PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]

______________________________________________________
CONFIDENTIALITY NOTICE
This electronic mail message, including any and/or all attachments, is for the sole use of the intended recipient(s), and may contain confidential and/or privileged information, pertaining to business conducted under the direction and supervision of the sending organization. All electronic mail messages, which may have been established as expressed views and/or opinions (stated either within the electronic mail message or any of its attachments), are left to the sole responsibility of that of the sender, and are not necessarily attributed to the sending organization. Unauthorized interception, review, use, disclosure or distribution of any such information contained within this electronic mail message and/or its attachment(s), is (are) strictly prohibited. If you are not the intended recipient, please contact the sender by replying to this electronic mail message, along with the destruction all copies of the original electronic mail message (along with any attachments).
______________________________________________________

« previous

back to mailing list archive