Single Client Access Name (SCAN) for Oracle Database 11g RAC
One of the maintenance challenges with RAC is maintaining all of the client connection files (TNSNAMES.ora) every time a change is made to a cluster database configuration. A new feature of Oracle Database 11g RAC databases, and a primary benefit, is the Single Client Access Name (SCAN). Read on to learn more...
14 Useful DBA Tasks for Solving Database Performance Problems
A checklist of DBA tasks involved with keeping an Oracle Database running smoothly can be quite handy. This 14 point checklist, while not actual performance tuning activities are tasks that a DBA needs to know and they will often be part of a solution to remedy a database performance problem.
Generate TPC Workloads For Oracle Databases Using Benchmark Factory
Most Oracle DBAs have found that tuning the I/O performance of an Oracle Database (11gR2) is as much art as science. Jim Czuprynski explains how to use Quest’s Benchmark Factory tool to construct and execute TPC-E and TPC-H workloads against an Oracle Database and how to isolate the sources of I/O performance bottlenecks.
Installing the Oracle WebLogic Server Component
To install Oracle Enterprise Manager (OEM), you must have an existing, certified Oracle Database and an installation of Oracle WebLogic Server. This article looks at the steps performed for database preparation and for installation of Oracle WebLogic Server.
Using Proxy Authentication Methods in Oracle Database 11g
Oracle DBAs have many different areas of responsibility and accountability for the database that they maintain. With many applications using middle tier connections, DBAs face an interesting challenge in limiting access and auditing end user activities. Oracle offers an option called proxy authentication that can help to address these challenges.
Oracle Database I/O Performance Tuning Using Benchmark Factory
The real test of how heavily an Oracle database will tax its underlying I/O subsystem and related infrastructure is to actually tax that infrastructure using representative database application workloads. Jim Czuprynski tells you how to choose appropriate database schema(s) for realistic testing, how to create example TPC-E and TPC-H database schemas and how to perform initial loading of these schemas using Quest Benchmark Factory.
Connecting to SQL Server from Oracle Database
Setting up a connection from SQL Server to Oracle Database is fairly easy, but the opposite is not so true. The new and improved method for connecting Oracle Database to an external data source is named Database Gateways. Read on to learn more...
Oracle APEX: Doing More with Less
In the six plus years since its release as HTML DB, Application Express (APEX) has evolved into a robust rapid application development (RAD) tool. Lately, it seems that many Oracle products are merging with related (and formerly competitive) products and tools and APEX is improving and becoming more feature rich with each new release.
Moving to Oracle RAC One Node
To remain competitive in a rapidly changing global economy, businesses are increasingly demanding higher levels of service availability and IT cost reductions through server and storage consolidations. Oracle RAC One Node is well suited to meet such challenges. This article covers how to implement Oracle RAC One Node on Oracle Enterprise Linux 5.
The Buzz From the Oracle OpenWorld 2010 Exhibition Floor
OOW 2010 abounded with product announcements and knowledge but the real buzz was on the Exhibition Floor. Join Jim Czuprynski as he shares DBA's impressions from the keynotes and announcements and discusses the issues that concern them.
Book Review: Oracle SQL by Example
Oracle SQL by Example, Fourth Edition, is an excellent resource for both learning SQL and for serving as a reference book for experienced users. Read on to find out if this book is a keeper.
Oracle Application Express - A DBA Perspective
Oracle Application Express (APEX) is a product provided by Oracle that is used for rapid application development to create web enabled applications to run against an Oracle database. Being primarily a developer's tool, the question arises...should DBAs be overly concerned about APEX? And the short answer to this question is...YES!
Oracle Database: Flashback Vs. Recovery
Don't limit yourself when it comes to database recovery. Recovery isn't just recovery anymore; it's more like recovery plus various flashback options. Read on to learn the positive and negative options you have when it comes time to flash back some object.
Oracle Database 11g New Features for Table Partitioning
Table partitioning is an option available to DBAs that can help them manage key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. Oracle Database 11g adds some very powerful new table partitioning methods that can be implemented to help to achieve some of these goals.
Top 5 Oracle Database PL/SQL Job Interview Questions
It would be smart to brush up on your SQL when interviewing for a PL/SQL developer position. James Koopmann shares five questions that he has been asked when interviewing for both a DBA position and a PL/SQL developer position.
The Old and New of Oracle Business Intelligence
In the world of Business Intelligence, the day has arrived. Oracle recently announced the release of Oracle Business Intelligence 11g, and the goods are now available. Steve Callan provides a history, tracing the software back to its origins, and comparing 10g with the 11g version.
Oracle 
Advertisement
Advertisement
Advertisement
