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.
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 …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…