admin's blog

Oracle layoffs

articles: 

According to the Enterprise System Spectator's website Oracle is busy laying off a large number of employees. According to the article, 8000 people or 10-15% of the company's workforce will lose their jobs today. Apparently similar layoffs are happening at SAP, Infor and possibly several other companies.

OraFAQ Forums "well attended" - author of Expert Oracle PL/SQL

articles: 

I recently stumbled across a sample chapter of Expert Oracle PL/SQL where the authors (Ron Hardman and Michael McLaughlin) mentioned that OraFAQ.com is a good place to post Oracle questions.

Connecting Oracle with MS-Access

articles: 

This article shows how Oracle's Heterogeneous Services can be configured to allow a database to connect to a Microsoft Access database using standard databases links. The method described can be used to connect to MS-Access from about any platform - Unix/ Linux or Windows.

Oracle 10g New Features: Changes to dbms_stats

articles: 

With Oracle Database 10g, there are some new arguments available for the dbms_stats package subprograms. Those parameters are as follows:

  • granularity
  • degree

Oracle 10g New Features: Advisory Framework - ADDM

Advisors are the server components that provide you with useful feedback about resource utilization and performance. The most important of all advisors is the Automatic Database Diagnostic Monitor (ADDM). ADDM does analysis of the system, identifies problems and their potential causes, and comes up with recommendations for fixing the problems. It can call all other advisors also.

Oracle 10g New Features: DML Enhancements

articles: 

In this article (chapter) we will look at new features surrounding the DML commands INSERT, UPDATE, and DELETE.

Oracle 10g New Features: Flashback and RMAN

articles: 

Two improvements have been made in the backup and recovery areas in Oracle 10g. When user errors and logical corruptions occur in the database, flashback functionalities provide fast and flexible data recovery. When physical or media corruption occurs in the database, RMAN delivers an improved and simplified recovery method.

Candidate keys: Choosing the right primary key

articles: 

It is the business that has the knowledge about their entities (things of importance) and what kind of unique information that separate them (invoice numbers, customer IDs, and so on).

Your role as an analyst/designer is to validate such properties, and to fit them into a normalized database model that reflects the needs of the business.

Oracle 10g New Features: Globalization Support

articles: 

Oracle Database 10g has expanded the ability to globalize Oracle databases dramatically. As you can see by looking over the following list of globalization improvements, Oracle has attempted to make Database 10g the database of choice for all globally supported and utilized databases.

Oracle 10g New Features: Audit Enhancements

articles: 

Oracle databases have many types of auditing features. In mandatory auditing, certain actions are always audited, regardless of the other audit options or parameters. Database activities, such as system startup and shutdown, are always recorded.

Pages

Subscribe to RSS - admin's blog