DB Usage Oracle

Stable Version 1.0.0 (OutSystems 9)
Published on 23 March 2016 by 
Created on 23 March 2016
Details
Want to find out what is using space in your Oracle database? Want more detailed visibility on which tables are bigger? Wondering if you have more space in indexes than in actual data in your tables? This component may help. It makes use of some commodity queries in Oracle to allow you to find more about the data model. Use it as the base for your own needs!
Read More

How to install:


1. you need a user with the following privileges:

 
      GRANT CREATE SESSION, ALTER SESSION
      GRANT SELECT ANY DICTIONARY
      GRANT SELECT ON V$DATAFILE
      GRANT SELECT ON V_$SQL
      GRANT SELECT ON V_$SESSION
      GRANT SELECT ON V_$SQL_PLAN
      GRANT SELECT ON V_$SQL_BIND_CAPTURE
 
If you are using the OutSystems Platform Enterprise Cloud, you can ask OutSystems to provide a database user with those credentials.

--

2. Publish the app

--

3. Create a database connection with the needed elements (example below)
   
4. Configure the DBUsageOracle extension to use the database connection you just created (example below)
--

5. Login with your Service Center credentials.

--

6. Have fun!
 
Reviews (0)
Category
Components, Developer Tools
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Acácio Porta Nova who created this component.
Dependencies
DB Usage Oracle has no dependencies.
Requirements
Platform:
9.0.0.1
Database:
Oracle
Stack:
All
Component Consumers
No consumers yet.
Weekly Downloads