As an administrator on the Unix system, we may encounter situations where we must remove the blank lines from many files. Similar is the case comments also, we may need to remove from a lot of files. Doing this using vi or nano editor is going to be lengthy and very tedious. This is also […]
How to recover database using RMAN
Recover database is an important part of Oracle database administration. Here in this post,I will try to cover scenario’s on How to recover database using RMAN Case 1: Loss of a datafile We often get the scenario where we lost the data file because of a hard disk crash and we get to restore the […]
How to check Stale statistics
Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: Parameter setting required to Track the table changes […]
Java web start(JWS) in R12
In this post, we will be discussing Java web start implementation in R12/R12.1 and R12.2 versions of EBS. we will see why it is important to implement it What is Java Web start? Java Web Start provides a browser-independent architecture for deploying Java technology-based applications to the client desktop. With Java Web Start, users can […]
How to delete the archive logs in Oracle
Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands to […]
How to generate sql monitor report in Oracle
We often come across a situation where a sql statement is giving issues. SQL monitor report is a very useful tool to analyze the various operation done by the sql, wait events, bind variables, and memory details. The below statement can be used to monitor any active sql or done sql in the database SET […]