It is possible to resize a tablespace datafile is there is some free space at the end of the datafile. This is the quick and easy method. If you have data at the end of the datafile, you will need to move the objects so that segment will be recreated. View tablespace size with free … Read more
Q Processes take more and more memory and does not release the memory. pga_aggregate_limit=0 allows pga to grow unlimited hence the Q processes can consume all server memory. Temporary workaround is to reset the AQ slaves so that it is not necessary to shutdown/startup the db instance Queries to Monitor Q Processes. Check also that … Read more
Last, times, we noticed high cpu and memory usage on our database server. Top memory consuming process was some ora_j000_* process which are spawned as part of execution of auto task scheduler job . It was using also lots of swap. After reviewing, we found that the process was running “Optimizer statistics advisor” task name … Read more