Ini permintaan tolong saya yang kesekian.
Saya minta tolong penjelasan...
pada database saya terdapat log-log seperti ini (OEM oracle 10g)
[Critical] Jan 12, 2007 9:58:25 PM Listener response to a TNS ping is
1910 msecs -
[Clear] Jan 12, 2007 9:53:25 PM Listener response to a TNS ping is 30
msecs -
[Critical] Jan 12, 2007 9:33:25 PM Listener response to a TNS ping is
400 msecs -
[Clear] Jan 12, 2007 9:18:25 PM Listener response to a TNS ping is 80
msecs -
[Critical] Jan 12, 2007 9:13:25 PM Listener response to a TNS ping is
630 msecs -
[Clear] Jan 12, 2007 9:08:25 PM Listener response to a TNS ping is 10
msecs -
[Critical] Jan 12, 2007 8:58:25 PM Listener response to a TNS ping is
1240 msecs -
[Clear] Jan 12, 2007 8:53:25 PM Listener response to a TNS ping is 0
msecs -
[Critical] Jan 12, 2007 8:48:25 PM Listener response to a TNS ping is
470 msecs -
[Warning] Jan 12, 2007 8:43:25 PM Listener response to a TNS ping is
100 msecs
Finding Host CPU was a bottleneck and the instance was consuming
12% of the host CPU. All wait times will be inflated by wait for CPU.
Impact (minutes) 135.91
Impact (%) 100
Recommendations
Consider adding more CPUs to the host or increasing the number of instances
serving the database.
Finding Individual database segments responsible for significant
physical I/O were found.
Impact (minutes) 67.43
Impact (%) 49.61
Recommendations
Action Investigate application logic involving I/O on TABLE
"GUNAWAN.CUST_TRX_POINTMNG" with object id 50916.
View Rationale
Message Run "Segment Advisor" on TABLE "GUNAWAN.CUST_TRX_POINTMNG" with
object id 50916.
Action Run "Segment Advisor" on TABLE "GUNAWAN.CUST_TRX_POINTMNG" with
object id 50916.
Finding SQL statements were not shared due to the usage of
literals. This resulted in additional hard parses which were consuming
significant database time.
Impact (minutes) 3.07
Impact (%) 3.04
Recommendations
Action Investigate application logic for possible use of bind variables
instead of literals. Alternatively, you may set the parameter "cursor_sharing"
to "force".
yang jadi pertanyaan saya adalah apakah maksud dari pesan tersebut dan
bagaimana menjalankan rekomendasi tersebut...
dan juga apa maksud dari mengeset parameter cursor_sharing = FORCE
Atas penjelasannya saya ucapkan terima kasih......
---------------------------------
Sekarang dengan penyimpanan 1GB
http://id.mail.yahoo.com/
[Non-text portions of this message have been removed]
