Connecting to LinkedIn...

W1siziisijiwmtuvmdqvmtuvmdgvntqvmzgvnzi1l01ptlrbu0hfqkxpr19vtljftkrfukvex0lnqudfx3jlc2l6zwrfyw5kx3jlbmrlcmvklmpwzyjdlfsiccisinrodw1iiiwimtkymhgxmjuwiyjdxq

Blog

Doing more for less with your Oracle database

12/05/2014 by

W1siziisijiwmtqvmtavmjgvmtuvndivmjuvmza3l2zpbguixsxbinailcj0ahvtyiisijywmhg0mdbcdtawm2uixv0


Workshop Database services are constantly increasing in demand, but while demand might be expanding, budgets in general aren’t. The Independent Oracle User Group’s 2013 Database Manageability survey showed that data volumes – along with the business demand for database services to manage them – grew by more than 20 per cent on average throughout the year. And yet most organisations reported budgets that were flat, or in decline.

As a database administrator, you are likely facing the challenge of doing more with less in terms of your database and its operations. But you do have options in terms of shaving costs here and there to improve your database function on an even tighter budget. Here are several ways that you can do more with less.

Standardise your database hardware

It’s a common problem for database managers: Over the years, as hardware and software evolves, different pieces are added to the database infrastructure to suit various business needs, usually by different managers, leaving you with a mishmash of parts forming your data center ecosystem.

While each addition or removal may have seemed like a sound idea at the time, no one may have realised the overall inefficiencies that they introduced into the system. In fact, according to Oracle, you could be spending as much as 30 per cent of your IT budget simply on getting the different components to interact correctly with each other.

Consolidate

Don’t just manage individual systems, which are often over-provisioned with spare processing and storage capacity and thus both inefficient and costly, Instead, you can standardise the platform used for all business applications with a consolidated data processing and storage infrastructure, which can now exist in shared environments.

According to Oracle, its software enables significant commoditisation of consolidated environments, greatly reducing the cost of hardware, often by a factor of 4x to 6x. It’s no surprise that around 40 per cent of organisations in that IOUG survey are considering moving to private cloud infrastructures to squeeze more performance out of their systems for less money, or already have.

By using Oracle Real Application Clusters, for example, you can integrate low-cost commodity servers in a single shared database grid or private cloud to enable consolidation, faster performance, higher availability and scalability on demand. Correcting such inefficiencies with this improved architecture can save you a noticeable amount on your annual budget.

Toad for Oracle, one of the most popular third party administration tools for Oracle, has an edition specifically for the RAC environment. In the Oracle parameters window, for example, you can see an additional instance column showing you that you’re connected to a RAC connection, as opposed to an instance connection. It is also RAC-aware in the way that it collects information, showing information from the GV$ view, for example, which monitors information across all instances in a RAC configuration.

Toad also handles the management of virtualised systems pretty well. For example, its health check screen includes a whole section of tests purely focused on virtualised systems.

This article has been extracted from http://www.theregister.co.uk, please click on this link to read the article in full http://www.theregister.co.uk/2014/05/12/oracle_dba_workshop/

Montash is a multi-award winning, global IT recruitment firm. Specialising in permanent and contract positions across mid-senior appointments which cover a wide range of industry sectors and IT functions, including:

ERP, BI & Data, Information Security, IT Architecture & Strategy, Scientific Technologies, Demand IT and Business Engagement, Digital and E-commerce, Infrastructure and Service Delivery, Project and Programme Delivery.

With offices based in London, Montash has completed assignments in over 30 countries and has appointed technical professionals from board level to senior and mid-management in permanent and contract roles.

For more information please visit www.montash.com

comments powered by Disqus

Social Stream

Latest News

W1siziisijiwmtyvmtivmdivmtavmdcvntcvotkwl2j1c2luzxnzigludgvsbglnzw5jzs5qcgcixsxbinailcj0ahvtyiisijm4mhgxmdajil1d

Annual growth rate for BI market set at 8.4%

2016-12-02 10:00:00 +0000

A new report has suggested that the compound average growth rate (CAGR) for the business intelligence (BI) market between 2016 and 2021 is likely to be around 8.4 per cent. The latest publication, named Global Business Intelligence Market by Mobile BI, Cloud BI, and Other Applications: Global Industry Perspective, Comprehensive Analysis and Forecast, 2015-2021, said that 2015 saw the global BI sector valued at $16.33 billion. By 2021, this is expected t...

W1siziisijiwmtyvmtevmzavmtavmjavntuvndgzl09jbcbyawcgc2vhlmpwzyjdlfsiccisinrodw1iiiwimzgwedewmcmixv0

Crisis in oil and gas industry nears turning ...

2016-11-30 10:00:00 +0000

A new report has suggested that the current crisis being experienced by the gas and oil industry is nearing a turning point. As part of the 25th Oil and Gas Survey, it was found that although two-thirds of firms had cut employment levels in 2015, the speed at which these cuts are occurring has slowed. In addition, other methods of saving have been utilised to drive operational costs down. Amongst the firms questioned, it was found that 67 per cent of bu...