Configure the oracle adapter

We need to configure the oracle adapter to listen to changes on a large number of tables in one instance and replicate the same into another instance .

Do we need to build notification for each table for each type of change(insert/delete/update) or could we set up operations at the schema level ?

Also, is there any statistics available , showing the impact of the enterprise adapter on the applications running on the database ?

An early reply would be appreciated
thanks
shiv

I can answer part of this:

“Do we need to build notification for each table for each type of change”

Yes.