> > - I want to know the tables of tempate1> > There are none, unless you choose to add some.I got it there are no tables. What about the system tables of template1 database ? Are they updated or not?
> > - If i want to monitor the transactions done in the template1 database (
> > insertion/updation ) , is there any way to track the same.
I want to monitor externally, without changing the database. If there are some system queries which can tell me what are the number of database insertion/updation in the template1 ( including system table it will be helpful for me).