tag:blogger.com,1999:blog-755542794415995865.post6961093356655616730..comments2023-09-23T07:13:10.004-07:00Comments on DB Optimizer: New Oracle Monitor - what language would you use?Kyle Haileyhttp://www.blogger.com/profile/13586511268045480856noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-755542794415995865.post-31525546088474830342010-12-20T16:23:52.194-08:002010-12-20T16:23:52.194-08:00Radoslav - Turbogears looks pretty cool. I want to...Radoslav - Turbogears looks pretty cool. I want to try it out<br />Charles - interested in seeing your UserForms. That's nice the can be exported to web pages. I'm wondering how the interact works.<br />My biggest question is, can UserForms stream in data - can I create a graph that automatically updates with new data from the database?<br />Sounds intriguing.Kyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-79710376405892811942010-12-20T07:18:47.165-08:002010-12-20T07:18:47.165-08:00Hi Kyle,
Excel supports what is known as UserForm...Hi Kyle,<br /><br />Excel supports what is known as UserForms, which are very similar to the types of form objects that are found in Visual Basic 6 and below. The UserForms go a long way toward making Excel a friendly environment for the project. I don't think that I have many examples on my blog that demonstrate using UserForms in Excel, but I can provide access to you of a much larger example that I put together for a presentation (just shoot me an email). <br /><br />You can even have Excel push the information to a web page, if you don't mind that the tool is limited to Windows, Excel, and Internet Explorer. Excel's macro programming language is quite a bit like Visual Basic and VBS (Visual Basic Scripting) - I have several examples on my blog that show VBS grabbing information from the database (some of it is performance related) and displaying the information to web pages - most of that code will work as is within an Excel macro. See the Working with the Oracle Time Model series on my blog for an example of a VBS script generating an interactive web page.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-29590327673619027712010-12-19T23:35:11.829-08:002010-12-19T23:35:11.829-08:00Python has turbogears for web. I think, it's s...Python has turbogears for web. I think, it's similar to ruby on rails<br />http://turbogears.org/2.1/Radoslav Golianhttps://www.blogger.com/profile/11089830721619663885noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-390701449981993802010-12-19T20:23:30.837-08:002010-12-19T20:23:30.837-08:00Hi Gary,
I'm thinking of something I give th...Hi Gary,<br /> I'm thinking of something I give the customers. They can install it where the want. My first goal is just to collect info to be reviewed later. My second goal would be to see information real time.<br />Web and graphics are optional but at least for graphics, it's something I really want and if I have all the above, then why not target a web application. I think I can get all the above with Delphi pretty easily. Delphi doesn't run on *NIX though it is targeted to in 2011. On the other hand, since the web is so important and ubiquitous these days, why not try and invest the time in a web enabled platform? Maybe Flex which runs in a browser and with Air runs as an application? Is Ruby a viable alternative? Maybe it's worthwhile investing in Ruby or HTML5 as that is where the future seems to be.<br />I want to start right away, so I'm thinking of just doing it in SQL and anonymous PL/SQL and then in the future adding a graphics and/or web enabling.<br />Yes, I've definitely seen Tanel's stuff. His snapper is much more along the lines of what I'm thinking for now. I have also seen the Excel stuff and the user interaction seems a bit difficult, but I'd want a more user friendly and interactive UI.<br /><br />- KyleKyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-25713711219940875882010-12-19T19:11:24.124-08:002010-12-19T19:11:24.124-08:00This might be too high-level, but where do you see...This might be too high-level, but where do you see the tool being installed ? This partly goes to the web-enabled thing.<br /><br />If you, as a consultant, are expecting to turn up to a client with a laptop running this stuff then your main problem will be in them allowing your laptop to connect to their internal network / DB. The complexity of the install and web-enabled seem secondary here.<br /><br />Alternatively, are you seeing this as a product that would be installed by the DB 'owner'. In the latter, given they've managed to get Oracle installed, the installation shouldn't technically be an issue. The underlying platform might be, possibly depending on whether you expect this to be installed on the database server itself or as a client. Security comes into play there. Except for XE, the Oracle software includes perl which might be a bonus if you want some components running on the server.<br /><br />If this is software that a DBA is going to install on a spare desktop style PC then consider delivering a virtual appliance. Linux, drivers, database, web/app server etc. Removes a lot of the install headaches.<br /><br />If this is software that the DBA will install on their PC, I think you can forget the web stuff and any exotic installs. Have you checked out Tanel's PerfSheet ? Excel is even more of a given than SQL*Plus<br /><br />http://tech.e2sn.com/oracle-scripts-and-tools#TOC-Visualize-Statspack-AWR-data-and-anSydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.com