Tag Archives: useful oracle scripts

Hi, Using bind variable in the queries is very crucial for performance tuning.

Hi, Using bind variable in the queries is very crucial for performance tuning.

Hi, Sometimes you may want to delete all trace, log files, audit files completely.

Hi, Sometimes customer ask you that why spesific sql is running long time or consuming lots of resource.

Hi, Time setting is very important on Linux server for database and application. Because application and database are mostly getting time from server.

Hi, Oracle Database Admin should know what is the database load profile and Active Session load to compare it when the complaint comes from Customer.

Hi, Disk speed is very important for database administrator and application. Because disk speed is very slow then you will see slowness automatically.

Hi, As a Database Administrator , The most encountered  in the database server is disk space problem. And we ask frequently which directory and files is top directory and files ?

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.

Hi, If you get slowness complaint from customer,  you need to monitor database which sql is consuming a lots of resource.