We added one more processor in the server during the weekend. Since then the performance is affected, i increased the SGA to 1.8 GB from 1.2 GB. The buffer cache hit ratio is still showing below 70%. Especially when we do the search from the application and navigating from one page to another page, it takes more than 6 sec whereas it was not the case earlier.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …