DB Usage Oracle
Stable Version 1.0.0
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
DB Usage Oracle has no consumers.
Weekly Downloads 
Related Components
Discovery
Architecture Team
A tool to discover and measure your architecture and understand how to improve
2992
OutSystems Now
OutSystems R&D
OutSystems Now brings your OutSystems experience to any device.
7163
Google Drive Connector
OutSystems R&D
Google Drive Connector allows your OutSystems Applications to use the Google Drive REST API to interact with your files.
990
More from Acácio Porta Nova
DBCleaner
Ricardo Silva
The component to help you keep your database neat and tidy.
3252
Sleep
Acácio Porta Nova
Ever needed to add a sleep to your OutSystems logic (e.g. for testing purposes, or just because an integration requires that you throttle it)? Always re-implementing this yourself? Not anymore! Just download this component and use Sleep action whenever you need! The application includes a basic example of its use.
881
QR-Code and Barcode Generator
www.LxIS.pt
Provides web blocks to generate QR-Codes and Barcodes images.  This component isJava only for the time being. Volunteers wanted for a .NET implementation!  
380