Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Where is the location for this commmand, I do not have it in the path environment
vxlicense -p
252 7abcc000 a178 326 1 fdd (VxQIO 5.0_REV-5.0A55_sol quick)
Please provide the output of the below OS command :
modinfo -l | grep -i fdd
vxlicense -p
With the uploaded information of "vfstab" i am not able to confirm does the "Quick I/O" option enabled at the filesystem level.
Hence please check with your Veritas vendor does the Quick I/O option enabled at the Filesystem level
Data Gathered:
DISK_ASYNCH_IO = FALSE
FILESYSTEMIO_OPTIONS = SETALL
DBWR_IO_SLAVES=4
Filename : awr_report_16247_16248.html
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 16247 19-يناير -11 08:00:41 871 36.6
End Snap: 16248 19-يناير -11 09:00:03 1244 45.4
Elapsed: 59.37 (mins)
DB Time: 3,427.21 (mins)
..
..
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 3,687,641 72,396 20 35.2 User I/O
db file scattered read 3,395,634 31,766 9 15.4 User I/O
CPU time 28,024 13.6
read by other session 1,205,393 19,519 16 9.5 User I/O
log file sync 171,321 5,874 34 2.9 Commit
...
...
SQL ordered by Reads
* Total Disk Reads: 44,032,565
* Captured SQL account for 46.6% of Total
Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
6,802,316 0 15.45 322.50 3545.11 28fkg7xv8z38n DECLARE job BINARY_INTEGER := ...
6,802,316 0 15.45 322.50 3545.11 a0nzfy5za0a1b SELECT CURRENT$."APV_NO", CURR...
6,802,300 8 850,287.50 15.45 322.35 3544.28 amxan5fz9mkku UPDATE "MEMEX_MVS"."TR_APP_VEH...
6,277,648 13 482,896.00 14.26 386.34 6846.59 05bhkbbrdpsjx oracleipay@Gateway2.auh-police (TNS V1-V3) UPDATE TR_TIC_GATEWAY_OUT_QUEU...
Problem Sqlid :
=========
1. Sqlid : 28fkg7xv8z38n
SQL :
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MEMEX_MVS"."TR_APP_VEHICLES"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2. Sqlid : a0nzfy5za0a1b
SQL :
SELECT CURRENT$."APV_NO", CURRENT$."APV_DATE", CURRENT$."APV_TIME", CURRENT$."APV_CHK_REGISTER", CURRENT$."APV_CHK_RE_REGISTER", CURRENT$."APV_CHK_RENEW", CURRENT$."APV_CHK_SALE", CURRENT$."APV_CHK_DAMAGED_CARD", CURRENT$."APV_CHK_LOST_CARD", CURRENT$."APV_CHK_CHANGE_DATA", CURRENT$."APV_CHK_CHANGE_COLOR", CURRENT$."APV_CHK_TRANSFER", CURRENT$."APV_CHK_EXPORT", CURRENT$."APV_CHK_TOUR", CURRENT$."APV_CHK_CANCEL", CURRENT$."APV_CHK_LOST_PLATE", CURRENT$."APV_CHK_DAMAGED_PLATE", CURRENT$."APV_CHK_CHANGE_PLATE", CURRENT$."APV_CHK_CERTIFICATE", CURRENT$."APV_CHK_CLEARANCE", CURRENT$."APV_PNO", CURRENT$."APV_PNO_ORG", CURRENT$."APV_PCOLOR_CODE", CURRENT$."APV_PKIND_CODE", CURRENT$."APV_PTYPE_CODE", CURRENT$."APV_PSOURCE_CODE", CURRENT$."APV_TCF_NO_OWNER", CURRENT$."APV_TCF_NO_BUYER", CURRENT$."APV_CHK_VEH_INVOICE", CURRENT$."APV_CHK_REG_CERTIFICATE", CURRENT$."APV_CHK_INSURANCE", CURRENT$."APV_CHK_INSPECTION", CURRENT$."APV_CHK_REGISTRATION", CURRENT$."APV_CHK_OLD_PLATES", CURRENT$."APV_CHK_MORTGAGE_RELEASE", CURRENT$."APV_CHK_MORTGAGE", CURRENT$."APV_CHK_WORK_LETTER", .
...
...
"APV_DATE_POSTED", "TR_APP_VEHICLES"."APV_PLATE_RESERVE_PERIODS_CODE" "APV_PLATE_RESERVE_PERIODS_CODE", "TR_APP_VEHICLES"."APV_DEFAULT_SCT_CODE" "APV_DEFAULT_SCT_CODE", "TR_APP_VEHICLES"."APV_REF_NO" "APV_REF_NO", "TR_APP_VEHICLES"."APV_REF_DATE" "APV_REF_DATE", "TR_APP_VEHICLES"."APV_CANCEL_REASON_CODE" "APV_CANCEL_REASON_CODE", "TR_APP_VEHICLES"."APV_IS_CLASSIC" "APV_IS_CLASSIC", "TR_APP_VEHICLES"."APV_TRANSFER_DRV_TCF" "APV_TRANSFER_DRV_TCF", "TR_APP_VEHICLES"."APV_TRANSFER_COM_TCF" "APV_TRANSFER_COM_TCF", "TR_APP_VEHICLES"."APV_USER_CHECKED" " APV_USER_CHECKED", "TR_APP_VEHICLES"."APV_DATE_CHECKED" "APV_DATE_CHECKED", "TR_APP_VEHICLES"."APV_USER_SCANNED" "APV_USER_SCANNED", "TR_APP_VEHICLES"."APV_DATE_SCANNED" "APV_DATE_SCANNED", "TR_APP_VEHICLES"."APV_RELATIVE_RELATION_CODE" "APV_RELATIVE_RELATION_CODE" FROM "TR"."TR_APP_VEHICLES" "TR_APP_VEHICLES") CURRENT$, (SELECT DISTINCT MLOG$."APV_NO" FROM "TR"."MLOG$_TR_APP_VEHICLES" MLOG$ WHERE "SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."APV_NO" = LOG$."APV_NO"
3. Sqlid : amxan5fz9mkku
SQL :
UPDATE "MEMEX_MVS"."TR_APP_VEHICLES" SET "APV_NO" = :1, "APV_DATE" = :2, "APV_TIME" = :3, "APV_CHK_REGISTER" = :4, "APV_CHK_RE_REGISTER" = :5, "APV_CHK_RENEW" = :6, "APV_CHK_SALE" = :7, "APV_CHK_DAMAGED_CARD" = :8, "APV_CHK_LOST_CARD" = :9, "APV_CHK_CHANGE_DATA" = :10, "APV_CHK_CHANGE_COLOR" = :11, "APV_CHK_TRANSFER" = :12, "APV_CHK_EXPORT" = :13, "APV_CHK_TOUR" = :14, "APV_CHK_CANCEL" = :15, "APV_CHK_LOST_PLATE" = :16, "APV_CHK_DAMAGED_PLATE" = :17, "APV_CHK_CHANGE_PLATE" = :18, "APV_CHK_CERTIFICATE" = :19, "APV_CHK_CLEARANCE" = :20, "APV_PNO" = :21, "APV_PNO_ORG" = :22, "APV_PCOLOR_CODE" = :23, "APV_PKIND_CODE" = :24, "APV_PTYPE_CODE" = :25, "APV_PSOURCE_CODE" = :26, "APV_TCF_NO_OWNER" = :27, "APV_TCF_NO_BUYER" = :28, "APV_CHK_VEH_INVOICE" = :29, "APV_CHK_REG_CERTIFICATE" = :30, "APV_CHK_INSURANCE" = :31, "APV_CHK_INSPECTION" = :32, "APV_CHK_REGISTRATION" = :33,
..
..
"APV_SERVICE_KIND_CODE" = :101, "APV_SCT_CODE" = :102, "APV_FLS_CODE" = :103, "APV_USER_CREATED" = :104, "APV_DATE_CREATED" = :105, "APV_USER_MODIFIED" = :106, "APV_DATE_MODIFIED" = :107, "APV_USER_APPROVED" = :108, "APV_DATE_APPROVED" = :109, "APV_USER_POSTED" = :110, "APV_DATE_POSTED" = :111, "APV_PLATE_RESERVE_PERIODS_CODE" = :112, "APV_DEFAULT_SCT_CODE" = :113, "APV_REF_NO" = :114, "APV_REF_DATE" = :115, "APV_CANCEL_REASON_CODE" = :116, "APV_IS_CLASSIC" = :117, "APV_TRANSFER_DRV_TCF" = :118, "APV_TRANSFER_COM_TCF" = :119, "APV_USER_CHECKED" = :120, "APV_DATE_CHECKED" = :121, "APV_USER_SCANNED" = :122, "APV_DATE_SCANNED" = :123, "APV_RELATIVE_RELATION_CODE" = :124 WHERE "APV_NO" = :1
4. Sqlid : 05bhkbbrdpsjx
SQL : UPDATE TR_TIC_GATEWAY_OUT_QUEUE SET TOQ_FLS_CODE = 88 WHERE TOQ_FLS_CODE IN ( 16, 29) AND TOQ_PCOLOR_CODE = 7
=== ODM Data Collection ===
Solution:
The below command is to check the Quick I/O license is validity
vxlicense -p
Please discuss with OS vendor on how to enable the Quick IO options for the filesystem level and then check with the below parameter setting :
DISK_ASYNCH_IO = FALSE
FILESYSTEMIO_OPTIONS = SETALL
DBWR_IO_SLAVES=4
Also it is suggested to check the status of the issue by setting the above parameters in the database before enabling the Quick IO options to see do you get better performance.
Note: If you have any test database , please enable the Quick IO for filesystem in the test server and then set the above parameter and monitor do you have performance improvement
No comments:
Post a Comment