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.

Automatic Oracle Instance Registration

A feature called automatic Oracle instance registration is the ability of an instance to register itself automatically with the listener at startup. Before Oracle 8i, an instance had to be configured via the listener.ora file. Now Oracle provides automated instance registration with the associated listener. Database instance registration enables load balancing and failover features as well.

When started, the database will register itself with the default listener without any additional configuration requirements. If you use multiple listener configurations, then you will need to add some additional parameters to the parameter file or spfile file for that instance. Configuration for listeners other than the default listener will require the inclusion of the SERVICE_NAME and LOCAL_LISTENER optional parameters in the init.ora file of the instance you want registered. Note that the LOCAL_LISTENER parameter also overrides other parameters of Shared server configuration. This is most important thing and as Oracle DBA you should need to aware of this.

If you use multiple listeners, you will need to modify your parameter file or you will find your database registering itself with both the listener you have defined for it and the default listener.