APEX

Hi all,

First time posting and only beginning to learn about Oracle so please forgive me if I am asking a stupid question. I've been given a college assignment to develop a tool that is capable of analysing Oracle DBMS. My lecturer pointed us in the direction of the V$SESSION table as being the main source of information needed to do this. We are using Oracle 10g Express as the working environment. As part of the project we have been asked to design the tool so that we can view both current and past session information, and represent some of the information in graphs.

In researching a way to do this I came across Oracle Application Express and it seemed to be a package I might be able to use to do this. I have built a virtual machine and initially installed Oracle 10g Express. As the SYSTEM user I then installed a copy of Oracle Application Express 4.1. I then created a workspace called PROJECT and as DBA I've installed the HR example schema so I have a working set of data to run general queries on.

My intention was to develop an app that could run a script that would pull all the info from the V$SESSION table into some new tables I had set up in the schema. I could store this info in the tables allowing historical views of past sessions. Then my app would be able to reference the tables and create graphs from the data. I still have to learn about APEX but my main assumption is that if I can get the info into a table I can do lots with it.

I had the HR schema installed in a copy of Oracle 10g Express before and could access the V$SESSION table but now I can't get to it through APEX. I'm aware that APEX has some reporting tools but I can't use these as the project is to develop the tool myself...I can however mimic what they do.

So my question is how do I access the V$SESSION table of my database as it is not visible in the SYSTEM or PROJECT workspace that I have through the object browser.

I appreciate any help.

Thanks.