How to tune Oracle Standard Edition without Option Packs
When you monitor a Oracle Standard Edition, you did not have a Tuning or Diagnostic Pack. This Feature must be disabled because they are not allowed Read More…
When you monitor a Oracle Standard Edition, you did not have a Tuning or Diagnostic Pack. This Feature must be disabled because they are not allowed Read More…
I was assigned to collect performance data on an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under SRead More…
In MySQL it is a very beautiful way to find the server’s over all current status or even we can generates a HTML code to get a report like Oracle ARead More…
The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values from timeRead More…
Patching is one of the most common task performed by DBA’s in day-to-day life . Here , we will discuss about the various types of patches which are pRead More…
STEP 1:Check the operating system bit version (32 bit or 64 bit). [[email protected] ~]$ uname -a Linux host11.intra.searshc.com 2.6.18-308.1.1.el5xRead More…
The way to use Oracle 12c STATSPACK is to bracket the performance problem by getting a snapshot before the issue begins and after the issue ends. ThiRead More…
SQL Developer may not be the perfect IDE, but it doesn’t mean that it has not got any tricks at all. One of those features I’d like mention about canRead More…
Asking why to use this parameter? Why this is set in your environment? Or even how it can hep you? Here we go: As per Oracle documentation, this pRead More…
If you need to create a database in Oracle 10g but doesn¥t want to use the DBCA feature or are unable to use it, you could simply follow the followiRead More…