René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"temporary tablespace usage","articleBody":"Hi,\r\n\r\nI have installed latest utplsql v3.1.11 on a 19.3.0.0.0 for a training initially and then hopefully for real development testing.\r\nThe database is not managed by me but I have access to enough system views,\r\n\r\nIn the schema that the tests will be run there are about 2400+ packages\r\nFor a simple test suite, the standard text reporter returns instantly the result.\r\nHowever the html reporter with coverage is stuck for a long time and then ends with\r\n\r\nORA-01652: unable to extend temp segment by ... in tablespace ...\r\n\r\nThe database has a 32 GB temp tablespace which is almost all free and I can verify from dba_temp_free_space that\r\nwhen starting the test all free space is being eaten away until the error message comes out.\r\n\r\nI have found that I can limit the scope of coverage to certain packages and run the test\r\n(though 1 minute runtime for a single package of 150 lines seems excessive)\r\nbut it is desired to test the whole software in the end (and have coverage for all packages).\r\n\r\nThe amount of 32 GB seems too big. Furthermore I have no guidance on how to estimate the total necessary temp size in GB\r\nin order to tell the administrators.\r\n\r\nSo I would like to ask:\r\n\r\n1. guidance on estimating total temp size needed to have full schema coverage\r\n2. if it's possible to alter certain storage parameters (or utplsql options) so that the temp storage used is reduced (and perhaps runtime is reduced too)\r\n","author":{"url":"https://github.com/dsnz","@type":"Person","name":"dsnz"},"datePublished":"2021-11-23T20:03:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":11},"url":"https://github.com/1169/utPLSQL/issues/1169"}