Quote:
Originally Posted by
Haasini
Hi,
I want to know shell script and pl/sql script for database monitoring to get alerts when users executing sql on production.
Please help me out ----------------
Thanks
Haasini
Sorry all for the marginal post!
1/ Tell me what's about your kind of Oracle Server? Shared Server or Dedicated Server? Trace_sql and generate the log_file whenever the server uses Dedicated because of many reason, but the main is one Dedicated Server's process reserve one session.
2/ If you simply want to get the alertSID.ora, put it in your environment, and open it by vi editor, you need:
- Identify $ORACLE_HOME$
- Get the exactly path, example /u02/app/oracle/product/10.2.0/admin/ORCL/udump/xxx.trc
- Write a sh script, open it in your environment.