tag:blogger.com,1999:blog-2571414265392841828.post2019713417066195308..comments2023-07-11T01:54:39.701-07:00Comments on OracleNext - Solution to your Oracle problems: Tablespace Growth History and Forecast for 12c and AboveSalman Ahmed Qureshihttp://www.blogger.com/profile/06946726509853037798noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2571414265392841828.post-16758895441234834932023-06-16T00:46:26.484-07:002023-06-16T00:46:26.484-07:00Thanks alot Salman. awsome script Thanks alot Salman. awsome script Alihttps://www.blogger.com/profile/09965451602346410891noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-46494748876802349292021-01-28T01:29:46.649-08:002021-01-28T01:29:46.649-08:00Hello Syed
The answer to your first question is al...Hello Syed<br />The answer to your first question is already explained before the code of the script about how it works. Yes, it is for 12c and above that have pluggable databases.<br /><br />For 10g and 11g, use below article.<br />https://www.oraclenext.com/2014/02/tablespace-growth-history-and-expected.html<br />Salman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-36802743742072539202021-01-27T22:24:17.019-08:002021-01-27T22:24:17.019-08:00Is this script only for CDB and PDB concept? what ...Is this script only for CDB and PDB concept? what about for 11g, if you have please share. ThanksSyedhttps://www.blogger.com/profile/04815259595637962215noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-21100597164090831582020-10-12T18:52:23.252-07:002020-10-12T18:52:23.252-07:00Hello KP. TEMP tablespace is dealt very differentl...Hello KP. TEMP tablespace is dealt very differently by Oracle. It automatically shrinks when usage is low. After an instance restart, it becomes clan. Because of no continuous growth, there is no way or no reason to find out growth history of TEMP tablespaceSalman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-52863673556427201242020-10-12T02:45:54.955-07:002020-10-12T02:45:54.955-07:00How to get growth history of TEMP tablespace.as i ...How to get growth history of TEMP tablespace.as i am facing issue with temp tablespace need to find how its growing.KPhttps://www.blogger.com/profile/10246244475576836036noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-31525274816634980762019-08-07T21:12:30.865-07:002019-08-07T21:12:30.865-07:00Thank alotThank alotSuutamthuthuathttps://www.blogger.com/profile/12875486169525497416noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-36078126257011033932018-02-15T00:23:08.488-08:002018-02-15T00:23:08.488-08:00Hello Ashraf,
It is not wise to use this script to...Hello Ashraf,<br />It is not wise to use this script to get growth of UNDO tablespace, in fact we don't really bother about UNDO tablespace growth. Undo tablespace is empty when you restart a database, and it starts growing as the transactions (undo) data starts coming in, and space is again de-allocated on next startup.Salman Ahmed Qureshihttps://www.blogger.com/profile/06946726509853037798noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-63414115411596296902018-02-14T21:26:48.217-08:002018-02-14T21:26:48.217-08:00how to get UNDO tablespace growth,as this script g...how to get UNDO tablespace growth,as this script giving wrong growth for UNDOashraf nalakathhttps://www.blogger.com/profile/18170791115416606004noreply@blogger.comtag:blogger.com,1999:blog-2571414265392841828.post-25140092993735206282017-01-16T20:37:24.693-08:002017-01-16T20:37:24.693-08:00Awesome script .. I am searching and working this ...Awesome script .. I am searching and working this .. quite some time. But you have given me as a hot cake. <br />Thanks alot. <br /><br />prabhuVasistahttps://www.blogger.com/profile/00912962440215064970noreply@blogger.com