Oracle-L: Re: Allocating Extents

From: Dave Hill <hilld_at_COUGAR.BARTON.CC.KS.US>
Date: Fri, 26 Jan 1996 14:19:26 -0600
Message-Id: <9601262227.AA04252@alice.jcc.com>

=_NextPart_000_01BAEBF9.4D5AF2A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit

I have saved the following script in a file called extents and then periodically I run it with different values.

SELECT SUBSTR(TABLESPACE_NAME,1,10) TABLES, SUBSTR(OWNER,1,10) OWNERS,
        SUBSTR(SEGMENT_NAME,1,20) SEGMENTS,
        SUBSTR(SEGMENT_TYPE,1,8) TYPES,
        SUBSTR(EXTENTS,1,5) EXTS, BLOCKS, BYTES

FROM SYS.DBA_SEGMENTS
WHERE EXTENTS > '&1'
ORDER BY OWNER, TABLESPACE_NAME;

Dave

Dave Hill                                   HILLD_at_cougar.barton.cc.ks.us
DBA/Systems Analyst/Programmer
BCCC, Great Bend, KS, USA                       A great place to work!
------------------------------------------------------------------------

Happiness isn't something you experience, its something you remember - Levant.

> FROM: Tom Morris - Kimball International, Inc. (812) 482-8263
> Information Systems USKIMNVM_at_IBMMAIL.COM
>

SUBJECT: Allocating Extents

Hello Oracle Gurus!

I'd like to be more proactive about space allocation, and have had a series of 'failed to allocate extent of size...' messages. Does anyone have a nifty little script/sql they'd like to share that we could run periodically to predict where there won't be room to allocate the next extent so that I can head it off?

Any suggestions will be appreciated... Tom

?? Allocating Extents

=_NextPart_000_01BAEBF9.4D5AF2A0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64

eJ8+IhwUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAENgAQAAgAAAAIAAgABBJAG ADwBAAABAAAADAAAAAMAADADAAAACwAPDgAAAAACAf8PAQAAAFQAAAAAAAAAgSsfpL6jEBmdbgDd AQ9UAgAAAABPUkFDTEUgZGF0YWJhc2UgbWFpbGluZyBsaXN0LgBTTVRQAE9SQUNMRS1MQGNjdm0u c3VueXNiLmVkdQAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAGQAAAE9SQUNMRS1MQGNjdm0u c3VueXNiLmVkdQAAAAADABUMAQAAAAMA/g8GAAAAHgABMAEAAAAgAAAAJ09SQUNMRSBkYXRhYmFz ZSBtYWlsaW5nIGxpc3QuJwACAQswAQAAAB4AAABTTVRQOk9SQUNMRS1MQENDVk0uU1VOWVNCLkVE VQAAAAMAADkAAAAACwBAOgEAAAACAfYPAQAAAAQAAAAAAAADlTsBCIAHABgAAABJUE0uTWljcm9z b2Z0IE1haWwuTm90ZQAxCAEEgAEAFwAAAFJFOiBBbGxvY2F0aW5nIEV4dGVudHMA+gcBBYADAA4A AADMBwEAGgAOABMAGgAFAC4BASCAAwAOAAAAzAcBABoADgARAAgABQAaAQEJgAEAIQAAAEVERUZD OEM3Qjc1N0NGMTFCRDY5NDQ0NTUzNTQwMDAwADAHAQOQBgAUBgAAEgAAAAsAIwAAAAAAAwAmAAAA AAALACkAAAAAAAMANgAAAAAAQAA5AABXJJcr7LoBHgBwAAEAAAAXAAAAUkU6IEFsbG9jYXRpbmcg RXh0ZW50cwAAAgFxAAEAAAAWAAAAAbrsK5ckx8jv7le3Ec+9aURFU1QAAAAAHgAeDAEAAAAFAAAA U01UUAAAAAAeAB8MAQAAAB0AAABoaWxsZEBjb3VnYXIuYmFydG9uLmNjLmtzLnVzAAAAAAMABhDI FhiVAwAHEIIEAAAeAAgQAQAAAGUAAABJSEFWRVNBVkVEVEhFRk9MTE9XSU5HU0NSSVBUSU5BRklM RUNBTExFREVYVEVOVFNBTkRUSEVOUEVSSU9ESUNBTExZSVJVTklUV0lUSERJRkZFUkVOVFZBTFVF Uy0tLS0tLVNFAAAAAAIBCRABAAAAjwQAAIsEAABhCAAATFpGdQ/kWeH/AAoBDwIVAqgF6wKDAFAC 8gkCAGNoCsBzZXQyNwYABsMCgzIDxQIAcHJCcRHic3RlbQKDMzcC5AcTAoM0BEYTMzEguwhVAoB9 CoAIzwnZOxfPeDI1NQKACoENsQtgbvBnMTAzFFALChVhC/IiYwBAIEkgEYB2ZYQgcxzhZCB0aB0A /QIQbBdgA/Aa0B0QBQQLgNwgYR2wAxAdAGMHQB9A+R1gZXgT0AIwBCAAcB1jrQOgcAZxBHBpH3J5 HKF0cnUDoGkFQAPwHYAgzyFADdAEkCARIHYHQApQbHMuCoUKhS0kkwqFUyBFTEVDVAYAVUKAU1RS KFRBQiWAAFNQQUNFX05BEE1FLDEnMDApIAUmRCwlxk9XTkVSfyc1KJMn8AqFKiYl1SVgR/knEE5U JuYB0CeAKyUpr9EqvVRZUCciOCeBLtFjLM8l1UVYVCyTJ0A1jyeAMSEn8SZgT0NLMiIKWTFAUwqF RlJPTQEGAFlTLkRCQV/TLFYKhVdIKMBFMeIskoAgPiAnJjEnCoX4T1JEKMAywSlEKAAmTY47JC8K xwzQMTQ0DfD7G58kFkQc4TkLPa8+vz/P80DNPDkgSAMQAyBC30PvQEhJTExEQAWgdVJnCsAuYgrA dAIgLpBjYy5rI5B1czw2zTQwLxOkBCBBbgdAE7FML1ADYAnAYW0HgHJZCoVCQ0mQKABHF9BhNQVA QgnwZCgAMpJVU35BQ/8tREsACcFKEQtRY88dAEYAIkAFsGshPO9O749P/1EPQS9CgGFwcAuApweQ BCAEAG4nBUBzA3D1EcBoHiJ5CGAf0SDyCfD/TTAoACIgBCBUTBfQB4AG0OcEkCSACoVMZSNAAjAj ph9Rz1n/Ww9cHzmfbGkx5DgwAtFpLTrDOqwLwtwxNgqgA2AT0GMFQFzf+V3mMzY69xRRC/Jghi/G +zYwM5I6J5ADcAXQBbAFEHcEICSALUBLB3BF0EKxSf8CMASRShAhIEgBKABmoEZQICAoODEyJ4A0 OOQyLWhQNjNkOC1EZqD9AhByAMBnEhOVZcFrD0rgAEtJTU5WTUBJkEJNTUFFEC5DM7C3ZDcvxiXR SiWRZRBBHeF3H3BnEB4xRR/0I7xCgGXXHeEpQEiwYx9BRwhwRqCzTdYvyEknHWBeQGtNQ/1XUCAE YBfQIOADYADQZxD/HPEBoAhgVCEKsE0xH4FvM/8CICgAIGIc0i/GEYAdYB8ApxGwCIEEIG9mNkBm C3B/H6JNYXX1HQAf5HhyAJB6NGUuetAndDBToWFn+yOIPJBvB5EAcFTgU5AcxP8fAAMAAYAhoF5A AkAfQQT0WC9zcQMgHYF5c2lzbxGBdycdgEoRdx9RCGBs/x1gIeIg+01hE1AJgCFQIjH/HZB0YR2B dGFNkFQCdBEDYP8DcIAneUkdglOQH/B55lRA/4CUHLAfcAOgHZB3wSIheIDcZj9yT0fwIaBzRYB7 cX9nEgQgA/BCsXQRU1EX0GN7BzAT0GR60S/IZTEjvD/+P0xDbx8jvGIfG+djvRbxAgCTAAADABAQ AAAAAAMAERAAAAAAQAAHMAAB10Qr7LoBQAAIMAAB10Qr7LoBHgA9AAEAAAAFAAAAUkU6IAAAAABo zA==

=_NextPart_000_01BAEBF9.4D5AF2A0--

Received on Fri Jan 26 1996 - 17:27:10 CST