Of course practice, practice, practice. But I have found this site to be very helpful;
http://www.ucertify.com/
They have some practice tests on it, but if you are willing to pay for the software, OCP or a bundle package for OCA and the next step OCP its pretty reasonable.

It tracks your progress and you are able to design the tests to your weaknesses. Also with the test if you fail they will pay for the test, I'm sure there is some type of clause, but using this software I can say it works very well.

Also using it you are able to see 'I didn't know I didn't know that' just work on these types of things in your current system you work with, relating it to your data will really help remember it during test time

Good luck

0  out of 1 found this valuable. Do you find this valuable? Do you?    

Use the TopLink discussion forum at forums.oracle.com.

0  out of 1 found this valuable. Do you find this valuable? Do you?    

Post this question in the official RMAN Discussion Forum: http://forums.oracle.com/forums/forum.jspa?forumID=74

1  out of 3 found this valuable. Do you find this valuable? Do you?    

Dear,

I think you have to reconsider what exactly your problem is.
Because, even if you discover how to flush the memory, I think unacceptable you have to restart your database and tomcat every day.
Instead of that, you have to discover why your 16 Gb fill up in 24 hours.
I had a similar issue with Oracle Database 10gR1 and Oracle IAS. The problem was the connection pool.
They open a lot of connection and never close, even if they don't use it anymore.
Did you see the number of sessions in database when the memory is full?
The number of sessions does match with the load in tomcat?
In my case we changed the THIN connection to OCI and use Oracle data source class.
Now I have my Oracle database running 24X7 very stable.

Note: If you have Linux 32 Bits, don't even try increase the value of kernel.shmmax.

Regards,
Fábio Ferreira

0  out of 1 found this valuable. Do you find this valuable? Do you?    

I have checked there was no process which was taking that much memory fill up such a huge spcae. my SGA is 1536 Mb as per my requirement.

 out of  found this valuable. Do you find this valuable?    

Part 2(due to 2000 char limit)

rtn := utl_smtp.data(mailconn, 'Subject: '||SUBJECT||utl_tcp.crlf||TEXT);
dbms_output.put_line ('DATA: '||to_char(rtn.code)||' '||rtn.text);
end if;
-------------------------------------------------
-- there is more than one so break up the list
-------------------------------------------------
WHILE end_loc > 0 LOOP

end_loc := instr(v_send_to, seperator, start_loc);
dbms_output.put_line ('start_loc : '||to_char(start_loc));
dbms_output.put_line ('end_loc : '||to_char(end_loc));

if end_loc != 0 THEN
send_also := substr(v_send_to, start_loc, end_loc-start_loc);
else
-- we are at the end of the string
send_also := substr(v_send_to, start_loc);
END IF;

dbms_output.put_line ('To (1): '||send_also);

rtn := utl_smtp.mail(mailconn, send_from);

rtn := utl_smtp.rcpt(mailconn, send_also);
dbms_output.put_line ('To (2): '||to_char(rtn.code)||' '||rtn.text);

rtn := utl_smtp.data(mailconn, 'Subject: '||SUBJECT||utl_tcp.crlf||TEXT);
dbms_output.put_line ('DATA: '||to_char(rtn.code)||' '||rtn.text);

start_loc := end_loc + 1;

end loop;


rtn := utl_smtp.quit(mailconn);
dbms_output.put_line ('QUIT: '||to_char(rtn.code)||' '||rtn.text);
EXCEPTION
WHEN others THEN
dbms_output.put_line('oohh.. big error');

END;
/

show errors

3  out of 5 found this valuable. Do you find this valuable? Do you?    

The Berkeley data base is not at all like Oracle, and asking this on an Oracle wiki site is not likely to get much response. I've never used BDB, but I do happen to know the answer to this. The space is empty after you delete all the records and can be used for future inserts, but it is not released back to the OS for performance reasons. To get details on this, try a Google search.

0  out of 3 found this valuable. Do you find this valuable? Do you?    

actually it's called pivot queries, more information and examples could be found here:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:766825833740

1  out of 9 found this valuable. Do you find this valuable? Do you?