How to show OSPF Intra routes metric calculation in database?

Hi All,

I would like to ask, how to identify the metric calculation for intra area routes using show ip ospf database command?

​

Example:

 R6 (C1) 155.1.9.0/24 -| | - R1 R7(C100) 

In this case, I have modified the ospf cost on the interface facing R7.

R1# sh ip ospf interface brief Interface PID Area IP Address/Mask Cost State Nbrs F/C Lo0 1 0 150.1.1.1/32 1 LOOP 0/0 Gi1/0.146 1 0 155.1.146.1/24 1 DROTH 2/2 Gi1/0.13 1 0 155.1.13.1/24 100 BDR 1/1 <--- R7 

My question:

1. How R1 can we identify the best path from subnet sent by R6 and R7 ? What show commands to see the comparison between calculation via R6 and Via R7?
2. Should this subnet have 2 entries on ospf database ? since R6 and R7 is sending that route?

​

R1#sh ip ospf database internal OSPF Router with ID (150.1.1.1) (Process ID 1) Stub Link States (Area 0) Link ID ADV Router Age Seq# Checksum Mask 150.1.1.1 150.1.1.1 388 0x0 0x0009AB /32 150.1.2.2 150.1.2.2 1242 0x0 0x00E6C9 /32 150.1.3.3 150.1.3.3 1167 0x0 0x00C4E7 /32 150.1.4.4 150.1.4.4 1166 0x0 0x00A206 /32 150.1.5.5 150.1.5.5 1155 0x0 0x008024 /32 150.1.6.6 150.1.6.6 1202 0x0 0x005E42 /32 150.1.7.7 150.1.7.7 1166 0x0 0x003C60 /32 150.1.8.8 150.1.8.8 1163 0x0 0x001A7E /32 150.1.9.9 150.1.9.9 1149 0x0 0x00F79C /32 150.1.10.10 150.1.10.10 1165 0x0 0x00D5BA /32 155.1.5.255 150.1.5.5 1155 0x0 0x007133 /24 155.1.7.255 150.1.7.7 1166 0x0 0x00415D /24 155.1.8.255 150.1.8.8 1163 0x0 0x002972 /24 155.1.9.255 150.1.9.9 1149 0x0 0x001187 /24 <------ Subnet 155.1.10.255 150.1.10.10 1165 0x0 0x00F89C /24 155.1.13.255 150.1.1.1 9164 0x0 0x004D57 /24 155.1.23.255 150.1.3.3 6985 0x0 0x00C4D1 /24 155.1.37.255 150.1.3.3 6985 0x0 0x002A5E /24 155.1.67.255 150.1.6.6 6986 0x0 0x00B7AC /24 155.1.146.255 150.1.1.1 9165 0x0 0x00908E /24 Router Link States (Area 0) Link ID ADV Router Age Seq# Checksum Link count 150.1.1.1 150.1.1.1 389 0x80000007 0x001D06 3 150.1.2.2 150.1.2.2 1245 0x80000006 0x008659 2 150.1.3.3 150.1.3.3 1169 0x80000007 0x002DAC 4 150.1.4.4 150.1.4.4 1168 0x80000006 0x0086AD 3 150.1.5.5 150.1.5.5 1158 0x80000006 0x00AC80 4 150.1.6.6 150.1.6.6 1204 0x80000007 0x008A6F 3 150.1.7.7 150.1.7.7 1173 0x80000006 0x00C868 5 150.1.8.8 150.1.8.8 1167 0x80000007 0x009BFC 4 150.1.9.9 150.1.9.9 1153 0x80000006 0x00315C 3 150.1.10.10 150.1.10.10 1170 0x80000006 0x007ECD 3 Net Link States (Area 0) Link ID ADV Router Age Seq# Checksum 155.1.13.2 150.1.3.3 1169 0x80000004 0x00872F 155.1.23.2 150.1.3.3 1169 0x80000004 0x003476 155.1.37.2 150.1.7.7 1173 0x80000004 0x00CCBD 155.1.45.2 150.1.5.5 1159 0x80000004 0x008305 155.1.58.2 150.1.8.8 1168 0x80000004 0x00214C 155.1.67.2 150.1.7.7 1174 0x80000004 0x00D293 155.1.79.2 150.1.9.9 1154 0x80000004 0x0075DA 155.1.108.2 150.1.10.10 1170 0x80000004 0x0056D6 155.1.146.3 150.1.6.6 1205 0x80000005 0x004837 R1#sh ip ospf database router 150.1.9.9 internal OSPF Router with ID (150.1.1.1) (Process ID 1) Router Link States (Area 0) Distance: 3 Path: 155.1.146.3, GigabitEthernet1/0.146, parent: 2/155.1.79.2/150.1.9.9 <--- Single link Only?????????????????? Now in min table Table index: 18 min 43 sec LS age: 1399 Options: (No TOS-capability, DC) LS Type: Router Links Link State ID: 150.1.9.9 Advertising Router: 150.1.9.9 LS Seq Number: 80000006 Checksum: 0x315C Length: 60 Number of Links: 3 Link connected to: a Stub Network (Link ID) Network/subnet number: 150.1.9.9 (Link Data) Network Mask: 255.255.255.255 Number of MTID metrics: 0 TOS 0 Metrics: 1 Link connected to: a Transit Network (Link ID) Designated Router address: 155.1.79.2 (Link Data) Router Interface address: 155.1.79.2 Number of MTID metrics: 0 TOS 0 Metrics: 1 Link connected to: a Stub Network (Link ID) Network/subnet number: 155.1.9.0 (Link Data) Network Mask: 255.255.255.0 Number of MTID metrics: 0 TOS 0 Metrics: 1 

​

Please let me know if you need more output.

​

Thanks,