Your Databases in Your Hand!

EXMobileDBA Enterprise is a collaborative tool that helps database administrators and consultants to execute remote operations over a database from tablets and smartphones in an easy, fast and dynamic way. EXMobileDBA has a large number of pre-configured administrative tools, and also relevant reports and performance database dashboards, that easily address problem diagnosis and improve administrative tasks productivity. It´s available in Android, iOS and Web platforms.

What is it?

EXMobileDBA is an application that helps on database monitoring and administration of Oracle databases. It´s easy, interactive, non-intrusive (almost queries only) and muti task. EXMobileDBA is the only application that allows database modifications for DBA roles, such as extend tablespace and kill session. It delivers many performance graphics and analytic reports that will help you diagnose problems in your database environment.

Working Everywhere

If you can reach your database, you can manage it. It can be done in the same network, VPN or through WebService. You can monitor and interact with your database everywhere.

Target

EXmobileDBA is easy to use. However, it´s for database administrators, operational systems administrators and project managers.

Productivity

Access

The basic idea that drive application development was the ability to manager and administer a database everywhere. To reach it, we developed direct access to database (Android) and through WebService (Android, iOS, Windows Phone, Web).

Increase Produtivity

Database administrators use a toolbox of queries to diagnose and monitor their databases. Those are their aces.
In ExMobileDBA we have careful developed over 150 queries that gives you reports, graphical information, charts and sheets. That information allows the database administrator to orchestrate the production environment.

Fast Diagnose and Fix

With your suite, database administrators can easy and fast diagnose problems and even fix it in some cases, through mobile. Here some example: a full tablespace
Analyze: Database Report > Database Erros – administrator can check an error from alert log.
Solution: Adminstrative Tools > Tablespace – administrator can query the problem tablespace and raise database size or add a datafile

Safety

Your suite was designed regarding data access safety. WebService must be located in a safe environment. With a safe and encrypted conde, WebService connects directly to database.
All connections go through a WebService port, based on a user and password, to ensure security.

Design

This application was developed using Google´s best practices “Material Design”. Size of icons, colors, fonts were careful studied and the result was a clean, interactive, intuitive app.
At web version we got explaining text for each screen. For iOS, we adapt the app core to fit Apple´s “Material Design”.

All Tablespaces
TOP 10 – Size
TOP 10 – Full
Search By Name

Other Schemas
Other Users
Roles
Sys Privs
Profiles

Active Sessions
Lock
Kill Sessions
Long Operations

Alert Log Last 100 rows
Alert Log Last 10 errors

Show Backup Status
Last Backups Errors

User Tables
All Tables

List of Invalid Objects
List of Invalid Objects grouped by owner and object type
Compile Invalid Objects

View all scheduled Jobs and their logs
View all running Jobs

Status of ansynchronous IO
Size of the flashback log buffer
Buffer busy waits by buffer type
Buffer busy waits by segment
Direct path IO and buffered IO
Hit rates for direct and cached IOs
Buffer pool IO statistics
DB Cache advise
Show SGA
SGA Resize Ops
PGA/UGA parameters
Top PGA
SQL workarea statistics
PGA target advice report
PGA target advide histogram
Memory Dynamic Components
Memory Target Advice
Shared Pool Advice

Compatibility
Attribute
Fail Group
Space Used in ASM Disk Groups

Tables
Indexes
Segments
Complete Report

List Redo Log Files Information
View Redo Log switches per Day
View Redo Log Volume Size in MB per Day
Archived log generation Volume and count report

SQL ordered by Elapsed Time (TOP 10)
SQL ordered by CPU Time (TOP 10)
SQL ordered by User I/O Wait Time (Last 60 minutes)
SQL ordered by CPU usage, wait time and IO time (last 60 minutes)
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Executionss

Concurrency by Buffer Busy Waits
Concurrency by Global Cache Buffer Busy Waits
Concurrency by ITL Waits Event

CPU Usage
Memory Usage
SGA
GPI (Global Performance Indicator)

Bytes per second (last 60 seconds)
Average latency for I/O waits (last 60 seconds)
Size of the I/O
Response-time Metrics
Types of User Activities
Wait Classes
Individual Wait Events (last 60 minutes)
Current Session Wait Activity
User I/O Waits
Top Five Statements With The Highest User I/O Waits
IOStat by Filetype summary
Tablespace IO Stats
File IO Stats

Diskgroup Performance
ASM Disk Performance
ASM Operations
ASM Files
ASM Templates

Segments by Physical Reads
Segments by UnOptimized Reads
Segments by Table Scans
Segments by DB Blocks Changes
Segments with the highest lock waits

Network Time Series
CPU Usage per DB Host % Time Series
OS Load per CPU per DB Host Time Series
Memory Usage per DB Instance % Time Series

Database Instances information
Database High Watermarks
Database Total Space
Database Memory
OS Stats
Database SysStat
Applications by CPU Usage
Objects by Waits
Sessions By Waitclass
Database Waitclass
Analytic Reports Charts

exmobilesuiteEXMobileDBA