Hi Andes,
coba cari tau dulu sebenarnya process apa yg nulis ke
trace file.
Biasanya info ini ada di header file bersangkutan.
Coba :
head -300 <nama_trace_file>
Ada bbrp kemungkinan trace file bisa membengkak.
- Walaupun sql_trace = false, tapi bisa saja user
mengaktifkan session tracing dari Oracle ebiz.
- Ada set parameter EVENT di init.ora utk trap error2
tertentu?
- Apakah ada error yg sering muncul di alert.log ?
Coba korelasikan dengan trace file yg ada.
regards,
tomi
--- Andes Febrian <[EMAIL PROTECTED]> wrote:
> Pak abi, saya coba tkprof input_file.trc output.txt,
> tp yg keluar hanya
> berupa :
>
> TKPROF: Release 10.1.0.3.0 - Production on Thu Feb
> 21 16:00:48 2008
> Copyright (c) 1982, 2004, Oracle. All rights
> reserved.
> Trace file: ittdb_ora_22158.trc
> Sort options: default
>
********************************************************************************
> count = number of times OCI procedure was
> executed
> cpu = cpu time in seconds executing
> elapsed = elapsed time in seconds executing
> disk = number of physical reads of buffers from
> disk
> query = number of buffers gotten for consistent
> read
> current = number of buffers gotten in current mode
> (usually for update)
> rows = number of rows processed by the fetch or
> execute call
>
********************************************************************************
> Trace file: ittdb_ora_22158.trc
> Trace file compatibility: 10.01.00
> Sort options: default
> 1 session in tracefile.
> 0 user SQL statements in trace file.
> 0 internal SQL statements in trace file.
> 0 SQL statements in trace file.
> 0 unique SQL statements in trace file.
> 30063199 lines in trace file.
> 0 elapsed seconds in trace file.
> gmn cara nya membaca session yg membuat trace file
> ini ? trace file ini
> sizenya 956MB. mohon pencerahannya. terima kasih.
>
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
