SQL Trace

From: Saimun Julia <saimun_at_ncb.gov.sg>
Date: Wed, 18 Aug 1993 11:58:13 GMT
Message-ID: <1993Aug18.115813.6899_at_iti.gov.sg>

I am in the midst of tuning application for Oracle. I have set the following under init.ora

    sql_trace=true
    timed_statistics=true
    max_dump_file_size=100000

What happens is the SQL trace is turned on. But the problem is the trace file isoverwritten each time there is a new query is submitted. I notice the trace filesize never go beyond 200 KBytes. Is there a way to prevent the trace to be overwritten ? Or is it the size for the dump file is too small. According to manual, the above statement will allocate100000 block of disk space. As the block size is system dependent, I check with our networking team 1 block = 1024 bytes in our machine.

Any help will be greatly appreciated. Please email me directly if possible.

By the way,

    We are running NOS Vines 4.11(5)
    Oracle RDBMS V 6.0.33.?.? (I can't remember the rest ..)

---

| Saimun Julia |
| Analyst Programmer/Oracle DBA Phone : 5309892 |
| National Computer Board Fax : 5309911 |
| Judiciary CISD Email : saimun_at_ncb.gov.sg |
| Singapore |

---

Received on Wed Aug 18 1993 - 13:58:13 CEST