I need to disable generation of trc files. They are chewing up most of my disk space and I'm really not even sure what they are for. There are lots of posting on this, but none really solve my problem.
However, I don't have "sql_trace" in my init.ora file. Also, I have two init.ora files in: /oracle/dbs/init.ora and /oracle/srvm/admin/init.ora. Both have the similar dates and I don't know which is the 'live' one.
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.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
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…