Home -> Usenet -> comp.databases.oracle -> Java program that automatically monitor and tune the Oracle database

Java program that automatically monitor and tune the Oracle database

From: rabbit <liqiuxia_at_comp.nus.edu.sg>
Date: 29 Sep 2002 02:31:27 -0700
Message-ID: <184dc8fd.0209290131.29410f90_at_posting.google.com> 






Hi,



I need to write a java program that can automatically monitor and tune
the database, i.e., tuning the shared pool(increase or decrease the
shared_pool_size parameter in init.ora), buffer cache and redo log
buffer.


Does anyone know how to do so in a jdbc program (without write or read
this init.ora file directly, but use SQL statement to change it)?



As many of these parameters involve the updating of the file init.ora,
shutting down and restarting the database instance is required for the
change to take effect. Does anyone know how to restart and shutdown
the database in the


java program?



Thanks!
Received on Sun Sep 29 2002 - 11:31:27 CEST












Original text of this message