Two questions from bright guys:

1. In a situation that I got the error max extent reached for Rollback R01-XX which solution is the best:

Enlarge the sise of each extent
Change max to unlimited ( what about V 7.3 )
Add another RBS


2. The end user comes to me and said its application hang when he issue a search ( behind the scene an Oracle select and Oracle and listners are ok and you can connect from sql plus client.

Can you tell me couple of your first professional steps to resolve this problem. For example for first try do you have a look at v$session or V$lock? where do you start? How can you exatly specify which command cause the grief?


Thanks a bunch