Scribd
Upload
57 views10 pages

Cursor Comparison

The document appears to contain test results for different cursor types and locking options in a database. It includes results for local and global cursors with various fetch orientations and cursor types, under different isolation levels and locking strategies like read-only, scroll locks and optimistic. The results include average durations and individual duration values in milliseconds.

Uploaded by

Bonala Praveenkumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
57 views10 pages

Cursor Comparison

The document appears to contain test results for different cursor types and locking options in a database. It includes results for local and global cursors with various fetch orientations and cursor types, under different isolation levels and locking strategies like read-only, scroll locks and optimistic. The results include average durations and individual duration values in milliseconds.

Uploaded by

Bonala Praveenkumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 10

LOCAL/GLOBAL FORWARD_ONLY/SCROLL

set based
set based
default
default

STATIC/KEYSET/DYNAMIC/FAST_FORWARD
set based
default

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD

READ_ONLY/SCROLL_LOCKS/OPTIMISTIC Avg Duration


Individual durations (ms)
set based
187.6 190 186 186 190 186
default
6914.8 6876 6906 6936 6920 6936
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3290.8
Incompatible
3303
5213
6015.4
6200.4
3729.6
7427.6
6937
3740.8
Incompatible
Incompatible

3300 3266 3296 3296 3296

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3307.2
Incompatible
3300.2
5209
6070.4
6180.8
3727
7440.2
6920.4
Incompatible

3283 3330 3330 3313 3280

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3315
Incompatible
3319
5218.4
6029.8
6208.4
3737
7440.6
6975
3728.8
Incompatible
Incompatible

3280 3313 3343 3313 3326

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3293.8
Incompatible
3319.6
5212.8
6012.2
6228
3765
7455.6
6974.2
Incompatible

3280
5186
5986
6190
3703
7403
6936
3736

3266
5186
6060
6156
3703
7406
6893

3296
5186
5983
6170
3703
7373
6923
3703

3263
5203
6016
6186
3716
7453
6940
3733

3313
5233
6093
6186
3716
7440
6923

3313
5220
6030
6250
3703
7470
6936
3736

3346
5190
6016
6203
3763
7423
6966
3766

3296
5216
6076
6156
3750
7466
6936

3360
5220
6060
6186
3780
7440
6970
3736

3330
5236
6013
6220
3733
7453
6920
3736

3330
5220
6030
6203
3703
7453
6940

3313
5233
6030
6233
3733
7450
7000
3736

3296
5250
6046
6203
3733
7406
6923
3733

3296
5190
6093
6203
3763
7436
6910

3313
5233
6046
6203
3766
7470
7046
3733

3280 3283 3326 3300 3280


3283
5173
5983
6200
3733
7406
6966

3346
5236
6033
6220
3736
7483
6966

3330
5236
6013
6220
3780
7466
7000

3326
5203
6016
6250
3750
7470
6956

3313
5216
6016
6250
3826
7453
6983

LOCAL/GLOBAL FORWARD_ONLY/SCROLL
default
default

STATIC/KEYSET/DYNAMIC/FAST_FORWARD
default

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD

READ_ONLY/SCROLL_LOCKS/OPTIMISTIC Avg Duration


Individual durations (ms)
default
9030.8 8983 9093 9046 9016 9016
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3359.6
Incompatible
3345.6
5256.2
6078.4
6239.2
5381
9883.6
9034.4
3515.6
Incompatible
Incompatible

3326 3330 3376 3423 3343

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3347
Incompatible
3336.2
5243.8
6085.2
6186.4
5375
9865.8
9027.6
Incompatible

3343 3330 3376 3326 3360

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3352.2
Incompatible
3372.2
5258.4
6112.4
6216.6
5413
9888.4
9065.6
3537
Incompatible
Incompatible

3356 3346 3373 3343 3343

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3390.4
Incompatible
3372.2
5274.8
6084.4
6215.8
5390.4
9839.6
9028.2
Incompatible

3296
5203
6063
6200
5343
9843
9000
3516

3296
5220
6033
6140
5340
9830
8986

3343
5216
6063
6173
5360
9830
9046
3513

3390
5266
6080
6250
5373
9923
9046
3500

3376
5250
6110
6216
5393
9873
9060

3406
5280
6156
6190
5406
9910
9063
3533

3343
5250
6093
6233
5423
9906
9050
3533

3326
5250
6110
6203
5376
9860
9016

3423
5250
6110
6250
5470
9890
9080
3560

3356
5236
6093
6263
5360
9920
9030
3513

3343
5233
6110
6233
5390
9860
9030

3343
5296
6140
6250
5406
9906
9063
3516

3343
5326
6063
6250
5406
9826
9046
3516

3340
5266
6063
6140
5376
9906
9046

3346
5250
6093
6220
5423
9906
9076
3563

3326 3390 3360 3376 3500


3330
5236
6080
6203
5360
9826
8986

3376
5296
6093
6220
5390
9826
9046

3373
5266
6093
6190
5406
9843
9030

3406
5296
6093
6233
5406
9860
9046

3376
5280
6063
6233
5390
9843
9033

LOCAL/GLOBAL FORWARD_ONLY/SCROLL
default
default

STATIC/KEYSET/DYNAMIC/FAST_FORWARD
default

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL
LOCAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL
GLOBAL

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
FAST_FORWARD

READ_ONLY/SCROLL_LOCKS/OPTIMISTIC Avg Duration


Individual durations (ms)
default
6397 6360 6376 6403 6453 6393
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3440.6 3500 3390


Incompatible
3424.6 3390 3390
5587 5560 5596
6418.4 6393 6420
6406.2 6373 6406
Not the requested type
3462.2 3453 3466
Incompatible
Incompatible

3453 3440 3420

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3406.2 3373 3406


Incompatible
3419.6 3373 3423
5573 5546 5550
6443.2 6373 6453
6437.2 6390 6420
Not the requested type
Incompatible

3393 3423 3436

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

3453 3436 3436


Incompatible
3438.4 3440 3406
5609 5610 5623
6434.4 6423 6450
6399.8 6376 6390
Not the requested type
3494.4 3470 3496
Incompatible
Incompatible

3483 3440 3470

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

3459 3390 3546


Incompatible
3425.6 3393 3436
5637.6 5643 5623
6433 6390 6466
6406.4 6360 6373
Not the requested type
Incompatible

3456 3453 3450

3423
5576
6406
6423

3500
5610
6453
6406

3420
5593
6420
6423

3453 3486 3453

3423
5596
6420
6500

3466
5580
6440
6390

3456
5593
6500
6423

3440
5606
6423
6423

3423
5580
6470
6453

3440
5626
6436
6420

3500 3503 3503

3436
5640
6420
6440

3470
5626
6436
6453

3393
5656
6453
6406

FOR UPDATE/FOR UPDATE OF column


set based
default

FORWARD_ONLY/SCROLL KEYSET/DYNAMIC
set based
set based
default
default

FOR UPDATE

default

default

FOR UPDATE
FOR UPDATE
FOR UPDATE
FOR UPDATE

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

KEYSET
KEYSET
DYNAMIC
DYNAMIC

FOR UPDATE
FOR UPDATE
FOR UPDATE
FOR UPDATE

SCROLL
SCROLL
SCROLL
SCROLL

KEYSET
KEYSET
DYNAMIC
DYNAMIC

FOR UPDATE OF column

default

default

FOR UPDATE OF column


FOR UPDATE OF column
FOR UPDATE OF column
FOR UPDATE OF column

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

KEYSET
KEYSET
DYNAMIC
DYNAMIC

FOR UPDATE OF column


FOR UPDATE OF column
FOR UPDATE OF column
FOR UPDATE OF column

SCROLL
SCROLL
SCROLL
SCROLL

KEYSET
KEYSET
DYNAMIC
DYNAMIC

SCROLL_LOCKS/OPTIMISTIC Avg Duration


Individual durations (ms)
set based
387.8
390
393
390
373
393
default
16602.2 16546 16593 16626 16606 16640
default

16591 16593 16580 16640 16486 16656

SCROLL_LOCKS
OPTIMISTIC
SCROLL_LOCKS
OPTIMISTIC

9521.8 9470 9516 9610 9483 9530


11108.4 11043 11140 11093 11156 11110
10051 10033 10033 10063 10033 10093
16624.8 16486 16686 16560 16736 16656

SCROLL_LOCKS
OPTIMISTIC
SCROLL_LOCKS
OPTIMISTIC

9518.4 9483 9500 9513 9533 9563


11126.2 11093 11143 11126 11143 11126
10119 10093 10126 10080 10186 10110
16597.2 16580 16640 16593 16563 16610

default

16581.6 16486 16546 16610 16656 16610

SCROLL_LOCKS
OPTIMISTIC
SCROLL_LOCKS
OPTIMISTIC

9524.4 9470 9560 9513 9563 9516


11110.4 11126 11110 11126 11080 11110
10058.6 10013 10110 10060 10080 10030
16557 16550 16483 16596 16560 16596

SCROLL_LOCKS
OPTIMISTIC
SCROLL_LOCKS
OPTIMISTIC

9539.4 9483 9576 9546 9546 9546


11082.8 11093 11076 11106 11063 11076
10091 10063 10093 10093 10096 10110
16585.6 16466 16640 16576 16623 16623

FORWARD_ONLY/SCROLL
default

STATIC/KEYSET/DYNAMIC/FAST_FORWARD
default

FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY
FORWARD_ONLY

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD
FAST_FORWARD
FAST_FORWARD

SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL
SCROLL

STATIC
STATIC
STATIC
KEYSET
KEYSET
KEYSET
DYNAMIC
DYNAMIC
DYNAMIC
FAST_FORWARD

READ_ONLY/SCROLL_LOCKS/OPTIMISTIC Avg Duration


Individual durations (ms)
default
7621 7590 7623 7640 7626 7626
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC

5077.6
Incompatible
5072.4
6384.4
7287.8
7351
5193.6
8093
7661.6
5209
Incompatible
Incompatible

5046 5093 5093 5110 5046

READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY
SCROLL_LOCKS
OPTIMISTIC
READ_ONLY/SCROLL_LOCKS/OPTIMISTIC

5074.4
Incompatible
5041
6347.2
7296.2
7311.6
5176.4
8086.4
7617.8
Incompatible

5060 5093 5046 5080 5093

5033
6360
7250
7313
5173
8046
7606
5173

5000
6313
7283
7263
5140
8063
7610

5093
6343
7313
7330
5186
8080
7686
5203

5050
6330
7266
7343
5170
8093
7590

5063
6376
7283
7346
5186
8106
7670
5250

5046
6330
7326
7296
5216
8093
7623

5080
6390
7330
7360
5220
8093
7673
5216

5046
6373
7280
7343
5170
8090
7610

5093
6453
7263
7406
5203
8140
7673
5203

5063
6390
7326
7313
5186
8093
7656

You might also like