Monday, January 25, 2010

Optimize I/O and disk utilization in Oracle Databases - Space Manager with LiveReorg.


Managing exploding growth of Oracle databases requires a strategy to optimize I/O and available disk space while still meeting SLAs for application performance.

This is especially useful for business critical ERP applications such as SAP, Siebel, Oracle e-Business and Cerner. Such environments have high transaction volumes which require large database storage capacity and routine archiving of data. Inefficient storage can lead to poor I/O performance.
How do you fix this issue with no downtime to the applications or the database?

Space Manager with LiveReorg offers a simple yet comprehensive solution for space reclamation and reorganization, partitioning and capacity management for Oracle databases. DBAs can visualize and plan space use, detect and resolve space fragmentation, reclaim wasted space and project database growth for future planning.

•Perform online reorganizations to minimize downtime to applications and the database
•Support for Oracle database environments running ERP applications such as SAP, Oracle E-Business, PeopleSoft, Siebel and Cerner Millenium
•Resolve database performance issues due to fragmentation from archiving Oracle data
•Predict disk space growth needs to plan for hardware expenditures
•Eliminate unnecessary disk space purchases by reclaiming wasted space


Know more about Quest's Space Manager with LiveReorg,

http://www.quest.com/space_manager_with_livereorg/

Regards,

Shafiulla Syed

2 comments:

  1. Saw your 3 post on Toad :
    1. Performance Analysis for Oracle
    2. SPOTLIGHT on ORACLE
    3. Space Manager with LiveReorg

    Good Post, Nice Info.

    Is there any free trainings, where i can learn these QUEST tools ?

    ReplyDelete
  2. Hi Raja,

    Thanks for your comment,

    Actually the above tools including TOAD are the tools from QUEST Softwares,
    These tools are very simple to install and you will get related documents from the www.quest.com,and you can go for product demo on this website , this is enough, no need to go for a training if you are well know of Oracle Database, you can download trial version and check out their usage..

    Regards,
    Shafiulla Syed

    ReplyDelete

Oracle RAC node unavailable with error: Server unexpectedly closed network connection6]clsc_connect: (0x251c670) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_node2_))

 Early midnight I received a call from the monitoring team that one of the critical production database node is not available. As I am aware...