tag:blogger.com,1999:blog-2511956539743992936.post8658122363584367064..comments2024-03-16T12:46:41.382+05:30Comments on Satya's DBA Blog: Temporary Tablespace in OracleSatya Thirumanihttp://www.blogger.com/profile/14440084623088726822noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2511956539743992936.post-81148586017159832352019-11-22T20:05:16.081+05:302019-11-22T20:05:16.081+05:30select df.tablespace_name "Tablespace",
...select df.tablespace_name "Tablespace",<br />totalusedspace "Used MB",<br />(df.totalspace - tu.totalusedspace) "Free MB",<br />df.totalspace "Total MB",<br />round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))<br />"Pct. Free"<br />from<br />(select tablespace_name,<br />round(sum(bytes) / 1048576) TotalSpace<br />from dba_data_files<br />group by tablespace_name) df,<br />(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name<br />from dba_segments<br />group by tablespace_name) tu<br />where df.tablespace_name = tu.tablespace_name ;<br />brajendrahttps://www.blogger.com/profile/09540765006060328218noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-77902686641444000842019-04-25T16:20:17.816+05:302019-04-25T16:20:17.816+05:30This comment has been removed by the author.Balajee Nandurihttps://www.blogger.com/profile/08406450507882767100noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-90853757808994205902018-12-24T16:31:44.913+05:302018-12-24T16:31:44.913+05:30Great article. It covers almost all the queries re...Great article. It covers almost all the queries related to <a href="https://orahow.com/checking-temporary-tablespace-usage/" rel="nofollow">temporary</a> tablespaceSantosh Tiwaryhttps://www.blogger.com/profile/12413511847358736422noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-76650122987083604562018-12-21T13:04:06.790+05:302018-12-21T13:04:06.790+05:30Great article. Very good queries for TEMPORARY Tab...Great article. Very good queries for <a href="https://orahow.com/shrink-temp-tablespace-in-oracle/" rel="nofollow">TEMPORARY</a> Tablespace.Santoshhttps://www.blogger.com/profile/00046033033360527381noreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-80010395490381741302012-11-01T00:10:47.091+05:302012-11-01T00:10:47.091+05:30Wonderful blog! I found it while surfing around on...Wonderful blog! I found it while surfing around on Yahoo News.<br />Do you have any suggestions on how to get listed in Yahoo News?<br />I've been trying for a while but I never seem to get there! Cheers<br /><i>Feel free to surf my blog post</i> - <b><a href="http://www.charlottencappliancerepair.com" rel="nofollow">geographic</a></b>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-84653676835469147232012-09-16T22:42:51.934+05:302012-09-16T22:42:51.934+05:30I have been browsing online more than 4 hours toda...I have been browsing online more than 4 hours today, yet I never <br />found any interesting article like yours. It's pretty worth enough for me. In my opinion, if all website owners and bloggers made good content as you did, the web will be a lot more useful than ever before.<br /><i>My weblog</i> ; <b><a href="http://atlanta-seo-company.blogspot.com" rel="nofollow">website</a></b>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2511956539743992936.post-13881178669401967582012-08-13T22:00:37.285+05:302012-08-13T22:00:37.285+05:30Hi Satya,
If a TEMP tablespace (11g) hits 100% us...Hi Satya,<br /><br />If a TEMP tablespace (11g) hits 100% usage is that a problem? Does it mean my process is going to crash?<br /><br />Regards<br />DanPeter Agenhttp://www.socialxpo.comnoreply@blogger.com