A list of Oracle related requests...

- As mentioned in another post it would be nice to have an option to open an individual sql editor for each new connection.

- Add Database Links and Scheduled Jobs in the listing of objects for each schema.

- Scrollable result set(past the max rows).

- The ability to alter Tablespaces and datafiles, not just view them.

- Provide a tab under the DBA Views->Storage->Tablespaces that shows the objects in that tablespace.

- Under DBA Views->Locks provide blocking lock information.  For instance is the session blocking another session and if so which one.

- Under DBA Views->Locks provide the action to kill a session just as you can under the Sessions View.

- Under DBA Views->Storage->Tablespaces provide the ability to create and modify tablespaces.  For example resizing and adding data files.

- It would be nice if the sql bookmarks were stored in a separate XML file.  This way I could create a list of standard Oracle related bookmarks and provide them to my coworkers or other DbVis users.

Thanks
Nathan

Hi Nathan,

For the objects in a tablespace you might try the following profile. It contains some changes to add the tab and see the objects in a tablespace.

Replace the existing oracle.xml in $DBVIS_HOME/resources/profiles with the attached one (you might keep a backup of the original one  ).

Regards,

Benny

This file provides the "objects in tablespace" functionality I was looking for.  Is there any other functionality that is added with this file?

Thank you so much for you help.
Nathan

Hi Nathan,

Within this file there is not more than the extra objects tab. I adjusted my setup to fill your needs with respect to objects per tablespace.

If interested I could make an overview of things I added myself. We could also take a look at your other requests, although I cannot provide them all.

Regards,

Benny

Thank you for the update.  It is nice to experience such customer service!

Nathan

Would it be possible to add the currently executed SQL to the session information?

For example:
1. click DBAViews->Sessions.
2. Choose a session from the object tree.
3. Show a new sub-tab in the Object View tab that provides the current sql statement that is being executed by the session.

It seems that sessions are sorted starting with active sessions.  It would be nice to be able to sort the Sessions object tree by UserName.

When viewing tablespace and datafiles for each tablespace it might be helpful to know what the maximum size of each are.  This can be accomplished by taking autoextend into consideration.

Thanks,
Nathan

Roger,

The active session information looks awesome!  I really appreciate you adding that!

BTW I am curious to know why the "objects in tablespace functionality" hasn't been promoted to 6.0.3 or 6.0.4?  It isn't a big deal.  I can just keep adding back to the profile.

Thanks,
Nathan

The objects in tablespace looks good. Thanks!

One other request...

It would be nice to be able to grant permission to objects by right-clicking a table/view or highlighting the table/view.  When right-clicking the table/view there could be an option named "Object Privileges" that would open a window that would have the same contents as the tab that would be displayed if the a user highlighted the object.  In the window/tab it would list all users as rows and the privileges as columns.  The column headings could be select, insert, update, delete, and alter.  Each row+column value would be a drop down with the values of no, yes, yes with grant.

Thanks again!
Nathan

Here's another one!  Hope this isn't too many.

The ability to "duplicate" a user.  This would create a new user like the user that is being duplicated.  It would need to also includes roles and privileges.

Nathan

Roger,

I posted something similar to this in the support forum.  Please ignore that one.

I finally got around to reading the documentation (afterseveral months of using DbVis). I was pleasantly surprised when I sawthe Plug-in Framework documentation. I am very excited about thisfunctionality. I would like to add all the features that I posted underthe Feature Request forum. One issue that I have is that there are noTypes defined for:

Database Links
Public Database Links
Jobs

Would it be possible for youto add these in the next release?

Also can you please describe what the variable "#cp.SystemTablePrefix" does?  I didn't see it described in the documentation.  Also what are the other commands associated with #cp. and #dm?  Are these methods in a class somewhere?

Also with conditional processing I want to do something along the following lines:
<If test="${schema} eq PUBLIC">
</If>
but it doesn't seem to work.  Can I use set variables in an If conditional statement?

Anymore information you can give me would be greatly appreciated.

Thanks,
Nathan Message was edited by: Nathan