Edgar Rocha Carvalho

less info
101 reputation
3
bio website escala
location Brasilia, Brazil
age 35
visits member for 2 years, 11 months
seen Apr 4 at 21:43

Free Flowing Tech Thinking


Feb
24
awarded  Autobiographer
Aug
21
awarded  Scholar
Aug
21
accepted Oracle performance after rebuild TEMP
Aug
19
answered Oracle performance after rebuild TEMP
Aug
19
comment Oracle performance after rebuild TEMP
Well, we had this problem with TEMP files and the application became unstable. So my attention was on the database. I spent many hours recreating both the database and another application server, doing a lot of tests, including network traffic, and we realized that our application server was actually receiving some kind of attack, we just changed the IP of the application server and now everything is fine! What a bad luck having this network problem at the same time of temp file, I got my attention to the wrong place.
Aug
18
comment Oracle performance after rebuild TEMP
Last night I recreated the tempfile with initial size very big 10GB (bigger than the maxsize of the previous I created), with next autoexend at 500mb and maximum size without limit. The file is no longer growing, it means that its size is enough. The previous temp had it´s maxsize 5GB, but the size of the file never passed 2,5GB. I got ORA-01652 when the server was out of space, but after I recreated the temp, it does not happen anymore. Thank you. No alert on the servers. I tried to reboot both the application server and the database server. Thank you!
Aug
18
awarded  Editor
Aug
18
revised Oracle performance after rebuild TEMP
deleted 5 characters in body
Aug
18
asked Oracle performance after rebuild TEMP