WE HAVE AN APP USING ORACLE 9 WHICH HAS BEEN RUNNING FOR 3/4 YEARS FINE
NOW USERS ARE EXPERIENCING SLOW RESPONSES INTERMITTENTLY
WE THINK EITHER
ORACLE DATABASE NEEDS TO RUN SOME TUNING PROGRAM "COMPUTE STATISTICS??" AS NOW DATA HAS EXPANDED TO A POINT TO MAKE ORACLE INEFFICIENT.CAN SOMEONE TELL US MORE INFO ON THIS
USER VIA A USER REPORTING TOOL IS HITTING TABLE WITH INEFFICIENT QUERY.
WE HAVE FOUND THE V$SQL TABLE WHICH LISTS QUERIES AND TIME TAKEN. HOWEVER CAN WE ALSO FIND THE USER WHO HAS RUN THIS QUERY.
ALSO NOTE WE USE mlogs TO PROVIDE AN AUDIT OF MOST OF OUR TABLES
THANKS IN ANTISCIPATION
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.
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…