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
Below a little script that will allow to create a user like another one in an easy way
When starting linux OS and that fsck fails with fsck.ext4: No such file or directory while trying to open /dev/mapper/myvg_mylv, usually the disks are mounted in read only mode. To solve this issue, you’ll have cancel fsck and login to the console. Remount / filestem as read only with mount -n -o remount,rw / After … Read more