Graphical interface..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Graphical interface..

  1. #1
    Join Date
    Oct 2003
    Posts
    65

    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
    Location
    greenwich.ct.us
    Posts
    9,092
    Perl has lots of graphing modules...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    http://www.geocities.com/alexdabr/sppro.html

    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