Oracle Database 11g – Features and Advantages

The latest version of the Oracle Database systems is the 11g which was released both for both Linux and Windows in 2007. Oracle has drastically improved their Database Management Systems since they burst onto the scene. Developing an application has become that much easier and the effort and cost behind it has also gone down significantly. Therefore Oracle Database 11g or simply Oracle 11g has several advantages as are listed below.

It provides a real life testing analyzer which basically tests an application in a variety of circumstances which may come out in real life. This helps in shielding the application from going down when it goes live. This is of a great benefit to the companies who experience lesser and lesser unplanned downtime and consequently, they lose less money.

 

11g also has new data compression which increases support for compression of all kinds of data. Providing more capability to sort unstructured and backup data, it reduces storage costs of the company. Because of this advanced storage compression, the impact on the performance of the system is also increased as the pressure on memory and bandwidth is greatly reduced.

Another major improvement for Oracle 11g is the deployment of new Data Security which is stronger and more secure than before. It protects against internal espionage by controlling who can access what data and when. It has a high network encryption as well as SSL-based encryption.

 

Besides the above main features, there is also a significant increase in the performance in Oracle 11g. The new business intelligence applications are speeding up by use of new partitioning methods. It also provides additional administrative support control which helps reduce the operational cost of maintain the database. In short, the Oracle 11g upgrade should be obtained by all users because the cost of upgrading the system is well worth the benefits obtained from it.

There are lots of new features added in Oracle 11g including security and performance improvement. High availability and scalability is main concern in new version of Oracle. Off course, nowadays company and people require these all features in database. Use of database is increasing including locally and globally and due to these reasons, security is most important for database support. Oracle specialists and remote dba experts are able to maintain critical databases with these new features.

 

To Ask for a Salary Increment or To Not?

You are currently happy with your work, but unhappy with pay?  Do you need a rise in pay to assist your relatives and family?  Otherwise, you may be interested in your supervisor asking for a raise.  If this is the case, you will want to continue reading on. Some of the many factors that should be taken into account before you decide to ask your employer for a raise are outlined below for your convenience.

One of the many factors you want to consider when trying determining if you should ask for a raise, it is your duty.  Have recently taken more functions on the job?  If you have been compensated for these additional duties?  If not, you may be within your rights to ask the pay raise.  With this in mind, it is also necessary to examine the other aspect of duties.  If you recently had the reduced workload, you want to refrain from asking for a pay raise, how can give off an unpleasant impression of yourself.

Age is another factor that you want to consider when trying to determine if you should ask for a pay raise.  The duration of employment can play a huge role in if you are not able to receive a raise they hoped.  Generally speaking, the longer working for a company, the more likely it is you will be able to get a raise.  In fact, before asking for a raise, you might want to refer to your employee manual, how your company may already have a pay raise plan in place.

The minimum wage for your state is another of the many factors you want to consider when considering pay raises.  In recent years, States have made the decision to increase their rates of pay the minimum wage. In fact, some of these wage increases were quite high.  You want to make sure that you are making more than minimum wage.  If your State has recently increased its minimum wage, your employer must have done so as well, but there is no harm in checking.  It might also want to see on request for a pay raise that will increase your salary in conjunction with any increases in the minimum wage in the State.  For example, you want to make sure that you are doing at least a few dollars more than an hour over all new hires.

Talking about the starting salary for your company, we recommend that you verify this information.  Generally, long-term employees should make more money than new hires, particularly in similar positions.  You may be able to examine the average starting pay for new hires in your business by examining any company job listings that you're able to meet. You may also be able to obtain information from other employees about their salary. With this in mind, many companies require confidentially when bound to pay.  Therefore, if you are aware of an employee's income, you will want to refrain from citing that as an example with the supervisory authority.

The factors listed above are just some of the many factors that you will want to consider before making the decision to ask for a raise.  If you decide to ask for a raise, you want to adopt a positive approach, friendly, when in this way.

Off course, everyone is needing to get higher salary in job. Present trend is if existing management doesn't pay more then leave job and pick up new job. For fetching new job is not easy in nowadays because technical interview becomes very strong. Only Oracle DBA success kit like Oracle DBA Interview Questions book can help at this time and you are able to get job very easily.

Query Rewrite in Oracle for Data Warehousing Application

Query Rewrite in Oracle for Data Warehousing Application

There are several ways that you can affect the optimizer’s logic in rewriting a query. First using the QUERY_REWRITE_ENABLED parameter, you can enable or disable the ability of the entire database to do query rewrites. This feature is very useful to maintain data warehouse database. Oracle supports so many good features and those are very useful in data warehousing database.

The QUERY_REWRITE_INTEGRITY parameter determines the freshness that is required of a materialized view. The options for this parameter are

ENFORCED:

The default setting for the QUERY_REWRITE_INTEGRITY parameter, this setting tells the optimizer to use only materialized views that contain fresh data. This setting also instructs the optimizer to use relationships that are based on enforced constraints like NOT NULL and Foreign key.

TRUSTED:

In this mode, the optimizer trusts that the data in the materialized views is correct and the relationships are correct. The optimizer also trusts declared but not enforced relationships and constraints, and it will use relationships specified by dimensions

STALE_TOLERATED:

In this mode, the optimizer trusts that the data in the materialized views is correct even if the views aren’t current and fresh. This mode offers the greatest flexibility in terms of rewrite capabilities but with the risk of returning incorrect results.

The safest level if rewrite integrity is ENFORCED. This setting guarantees that no data returned y the materialized view will be out of sync with a similar query against the base tables the base tables of the materialized view.

We can change above parameters in session level too using following commands.

Alter session set QUERY_REWRITE_ENABLED=true;

Alter session set QUERY_REWRITE_INTEGRITY=stale_tolerated;

This kind of questions can be asked during Oracle DBA interview questions and you can also need to take care for performance tuning during database services activities.