Tag Archives: oracle scripts

Hi, Database name is very important parameter in Oracle especially for backup operations.

Hi, The character set is most critical parameter for the database setup because it is one of the unchanging properties after installation.

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 ?