CDD Logo
PDA Programming: MobileDBA - Wireless Database Administration Tool.

   

MobileDBA solves this problem through a complete Oracle database administration utility loaded onto a wireless handheld device. Mobile-DBA allows your database administrators and support workers the ability to respond to problems from anywhere. Mobile-DBA is the ultimate real-time remote database notification, diagnosis, and implementation solution. Manage database objects, users, sessions, storage, performance, and execute SQL/Commands to name a few of the capabilities. All from a wireless device that fits in your pocket.

MobileDBA takes database administration to the next level. First, it provides DBAs with a remote wireless connection to their database from any location using PocketPC or Palm devices. Next, the device is loaded with Proactive Technologies’ leading edge software application that allows DBAs to completely administer their database as if they were in the office. Finally, the application is extremely easy to use, being an entirely “stylus” only driven application.

The MobileDBA software package includes server software that resides on an organization’s LAN, behind the firewall and thin client. MobileDBA was designed with security in mind. It has several layers of security and can seamlessly work with VPN, SSL, DESX and other encryption protocols.


Space Manager

  • Monitor and manager tablespace size.
  • View and alter all tablespace parameters.
  • Add data files to a tablespace.
  • Manage rollback segments.
  • Place objects online or offline.
Example: You are driving to the airport with no phone jack available. You receive a page from the Help Desk that a user received error message saying that Oracle cannot allocate new extent for index, and no other DBA is available. With MobileDBA you can pull onto a safe shoulder and resize the tablespace in minutes.

Object Manager
MobileDBA Object Manager is a innovative administration option that allows the administrator among other things to explore database objects by schema or by object type from a common entry point.
  • View complete information for all object types in the database.
  • Create, modify, or drop critical database objects.
  • Monitor database objects and change storage parameters.
  • Drill down to information related to the object.
  • Manage partitioned tables and indexes.
  • Grant or revoke object privileges.
  • Recompile stored procedures.
Example: From the Table Details screen under Object Manager, the user can click on “Tablespace” for a specific table and view all relevant tablespace statistics and information.

Session Manager
  • Monitor user connections.
  • View active or inactive session separately.
  • View session statistics and details.
  • View last SQL.
  • View session locks.
  • Kill session.
Example: Friday night family dinner doesn’t have to be canceled because DBA received a pager message that job runs for 6 hours instead of 30 min. Using Session Manager DBA can quickly check for deadlocks and resolve it by killing locking session, or looking at user’s SQL statement realize that table index is not used, then DBA can create and analyze index, using MobileDBA Object Manager.

Security Manager
  • View, create, modify or drop user.
  • View, create, modify or drop role.
  • Grant or revoke system privileges.
  • Grant or revoke object privileges.
  • View profile details.
  • Grant or revoke object privileges.
  • Recompile stored procedures.
Example: You are in an important planning meeting and receive a page that a newly hired manager needs immediate access to the corporate data warehouse. You can quickly add the new user without leaving your important meeting.

Performance Manager
Proactive performance monitoring and resolution functionality.
  • View system resource utilization statistics.
  • View memory and CPU usage.
  • View I/O statistic reports.
  • Monitor current “Top 10 Resource Users”.
  • Monitor current “Top 10 Expensive SQL”. 
Example: While using Performance Manager to remotely monitor available tablespace and tablespace allocation, an administrator can drill down to tablespace details and resize or change default storage parameters.

Instance Manager
  • View main instance information.
  • View instance memory allocation.
  • Modify instance parameters.
Example: While troubleshooting slow performance issue, a DBA of e-commerce company noticed frequent redo log switch. By changing initialization parameter for log_checkpoint_interval DBA reduces overhead for log switch improving performance for on-line application.

Jobs Manager
  • View currently running jobs and their details. Cancel Jobs.
  • View scheduled jobs and modify various parameters. Submit job for execution.
  • Create new Oracle Job.

SQL Commander
SQL Commander is an interactive interface for a user to run any database command or query as if they were at their desk.

Example: A user can remotely create and run a customized report for a Business Manager from whom they have received an urgent cell phone call.
Previous projectClose WindowNext project