DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Graphical interface..

    Anyone suggest me to plot the statistics in a graph.

    A shell script trapes all the oracle process and logs on to respective database and collects the below information for each process thatz bad.i am collecting some statistics in a flat file.The following is collected.

    # time unix_pid cpu_index username machine osuser remote_process client_info action module program cpu_sess sql_rndtrip
    bytes_rec_dblink bytes_send_dblink cgets block_gets parse_cnt_hard parse_cnt_tot parse_time_cpu parse_time_elap phys_reads phys_writes ses_conn_time sorts_disk sorts_mem sorts_rows table_scans_long oracle_s.sid app_cmd

    The below is an sample of the output.

    14:38:22 56048 120 EC_PROMISE ASIA-PAC\SER-D-383 Balaraman.Na 1612:1308 UNKNOWN UNKNOWN SQL*Plus SQLPLUSW.EXE 0 0 0 0 100380330 1668 6 44 0 0 115 0 0 0 15065 1596673 0 27

    14:48:22 43028 103 EC_PROMISE ASIA-PAC\SER-D-383 Balaraman.Na 1612:1308 UNKNOWN UNKNOWN ECNOTE pacer.exe 0 0 0 0 100380330 1228 6 56 0 0 105 0 0 0 12365 1596673 0 27

    Now i need to improve the same in a graphical mode.I need to see the modules & the cpu utilisation for a working day.In the info gathered the 1st column is time,3rd is cpu index & 10th column is module.

    The statistic runs every 10 mins.
    Can any one suggest me how do i do it from the gathered informatio.
    I dont get any idea as i am not well in web technologies.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2000
    Perl has lots of graphing modules...
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2003
    over the hill and through the woods

    Here this may help you out. I've used it in the past and it's ok.
    Oracle it's not just a database it's a lifestyle!
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.