This content has been marked as final. Show 4 replies
1)How to monitor alert log file (using any tool or manual)?You can use tool like OEM and have the alert setup on errors OR you can make your own script which will run periodically and checks for errors.
2) What are the implications of a database with multiple data block sizes?No implications if you use those appropriately.
1) If on 11g, I would reccomend ADRCI.
2) The implications are many. Database block size impacts how oracle access and manage your data and it's caches. As a general guideline a larger block tablespace is used for large sequential full table scans. Smaller blocksizes are used for improving sessions that typically do random access and retrieve only one row or two, and those are small rows. But again, this is just the tip of the iceberg, there are many more implications regarding buffer cache, metadata, block contention and so on.
Edited by: Alvaro on 10/05/2013 21:42