Hi DBA's
Temporary tablespace size in production database is 120gb but In test and dev environments we are keeping only 20gb because of my project manager is not allowing us to keep more size.
Temporary tablespace (20gb) is not sufficient in my environment, so every morning I have to recreate temporary tablespace and doing too.
is there any advisory report to suggest required size of data/temp files as per business traffic, SO I can show report to my project manager, so I can demand for more space needed to allocate to asm diskgroups.
Please give your valuable comments.