durgaprasad1538
New Member
Need Help on generating promon report
i'm working on Database analysis report using Promon.But i'm not able to get details properly for each option.
$DLC/bin/promon -zn $DBPATH/$DB -NL </dbawork/hit_amon>> /dbawork/
input file:
more hit_amon
echo " "
echo "m
1
99999
1
1
q
4
1
q
4
1
q
4
1
q
4
1
q
5
q
6
q
7
q
R&D
1
4
3
q
R&D
1
4
3
r
r
r
q
q"
But i'm receiving output for only first page for all the Database otion
recording locking table
User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 0 0 203544 0 0 04/03/18 02:00
1 pgresdba SERV -- 0 0 131022 0 0 04/03/18 02:16
2 pgresdba SERV -- 0 0 202138 0 0 04/03/18 10:35
3 APW -- 250 0 590156 0 0 04/03/18 02:00
4 WDOG -- 0 0 384964 0 0 04/03/18 02:00
5 BIW -- 436 0 110456 0 0 04/03/18 02:00
6 pgresdba MON -- 0 0 174106 0 0 04/03/18 19:57
1044 y290exg REMC -- 0 0 0 4 2 04/03/18 17:22
1045 asilva REMC -- 0 0 0 4 2 04/03/18 11:40
1046 egarcia REMC -- 5264576 0 0 4 2 04/03/18 11:40
1047 y280dxd REMC -- 0 0 0 4 2 04/03/18 16:21
1048 jcruz2 REMC -- 0 0 0 4 1 04/03/18 19:24
1049 joperez REMC -- 0 0 0 4 1 04/03/18 17:41
1050 y290exg REMC -- 0 0 0 4 1 04/03/18 19:44
1052 nsandova REMC -- 0 0 0 4 1 04/03/18 18:48
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
i'm working on Database analysis report using Promon.But i'm not able to get details properly for each option.
$DLC/bin/promon -zn $DBPATH/$DB -NL </dbawork/hit_amon>> /dbawork/
input file:
more hit_amon
echo " "
echo "m
1
99999
1
1
q
4
1
q
4
1
q
4
1
q
4
1
q
5
q
6
q
7
q
R&D
1
4
3
q
R&D
1
4
3
r
r
r
q
q"
But i'm receiving output for only first page for all the Database otion
recording locking table
User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 0 0 203544 0 0 04/03/18 02:00
1 pgresdba SERV -- 0 0 131022 0 0 04/03/18 02:16
2 pgresdba SERV -- 0 0 202138 0 0 04/03/18 10:35
3 APW -- 250 0 590156 0 0 04/03/18 02:00
4 WDOG -- 0 0 384964 0 0 04/03/18 02:00
5 BIW -- 436 0 110456 0 0 04/03/18 02:00
6 pgresdba MON -- 0 0 174106 0 0 04/03/18 19:57
1044 y290exg REMC -- 0 0 0 4 2 04/03/18 17:22
1045 asilva REMC -- 0 0 0 4 2 04/03/18 11:40
1046 egarcia REMC -- 5264576 0 0 4 2 04/03/18 11:40
1047 y280dxd REMC -- 0 0 0 4 2 04/03/18 16:21
1048 jcruz2 REMC -- 0 0 0 4 1 04/03/18 19:24
1049 joperez REMC -- 0 0 0 4 1 04/03/18 17:41
1050 y290exg REMC -- 0 0 0 4 1 04/03/18 19:44
1052 nsandova REMC -- 0 0 0 4 1 04/03/18 18:48
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L