Oracle DBA(10g&11g)


Oracle is the not the most elegant database, and it’s not always the fastest platform. Oracle rose to the pinnacle of the IT world on other virtues. Rather than wait for the end-user community to react to market changes, Oracle took a proactive approach and often introduced features far-ahead of the market demand. I remember when Oracle 7 was undergoing beta testing and we wondered about the new “cost based optimizer,” “hash joins,” and bitmap indexes. In Oracle 8, we replaced EBU with RMAN and learned about partitioning and star transformations. And so on-high anticipation with every release. 

“Why Oracle?” this question is frequently asked. And answer to this may lie in the what an organization need the best from database management system. Even though there are many more database management systems then how come Oracle database administration is the only one that can accommodate each and every need? There are many features that we find in other databases too, which oracle offers, so where the difference does lies? And how can we say that Oracle database administration is primary requirement for every company? 

Oracle has wide range of products: business-intelligence, business applications, Virtual Box and so on. But Oracle’s primary expertise is in database products. Oracle database have pursuit of features that not only provide best performance for database, security for data in databases, good database administration but also many that are related with database like storage cost, redundant service for high-availability etc. some of the highlighted features include : 

1. Most efficient use of IT budget ie organizations need not worry of hardware cost much and can invest in core business. 
2. Reduces Server cost. 
3. Reduces Storage cost. 
4. Eliminate idle redundancy in data centers. 
5. Improve System Performance. 
6. Increases productivity of DBA. 

Oracle provides the choice to select database product as per requirements. These products are available in various editions – Standard Edition, Express Edition and Enterprise Edition. Also oracle database products are available for wide range of operating systems from MS windows to various flavor of Unix like IBM AIX,HP UX, Solaris etc. Here organization can get best security for their databases by selecting any Unix OS for databases. 

As mentioned earlier Oracle provides functionality that is beneficial at various level of 

management like storage, networks or you can say complete IT infrastructures. It also has lot more for application developers. For developers Oracle PL/SQL is native language for highly scalable applications. It has various analytical functions that work very efficiently with huge amount of data. The list of features is in non-ending. Let us have glance at the bottom line feature that make Oracle outstanding: 

Strictly business. 
Built-in Transparency. 
Internationalization (oracle comes in number of languages). 
Reduces cost of operations and always gives positive returns on investments, the thing that every organization is concern about. 
High performance.