OBIEE WHAT DOES IT MEAN?

Oracle Business intelligence Enterprise edition (OBIEE)  According to Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is a comprehensive business intelligence platform that delivers a full range of analytic and reporting capabilities. Designed for scalability, reliability, and performance, Oracle Business Intelligence Enterprise Edition 11g delivers contextual, relevant and actionable insight to everyone in an organization, resulting in improved decision-making, better-informed actions, and more efficient business processes....

Read More

LAUNCHING SOON! A NEW TUTORIAL On ORACLE DATABASE 11G OCA!

Get your OCA CERTIFICATION ITS EA...

Read More

HOW TO DOWNLOAD ORACLE 11G FOR FREE

Check but a free tutorial on how to download oracle for f...

Read More

TYPES OF DATATYPES FOUND IN AN ORACLE DATABASE!

Types of Oracle Database Datatypes varchar2 this is the most common  datatype it allows you to store  alphanumeric characters. The length of varchar2 is 4000 bytes or characters. This was what set Oracle apart from other databases in prior years. While other databases had lengths up to 2000 Oracle had its character length set at 4000 Number  datatype: allows you to store an interger as well as decimal values date datatype not to be confused with the time stamp datatype stores the date value - the default way of...

Read More

WHAT IS THE SGA IN ORACLE AND WHAT IS IN IT??

Oracle memory is called the SGA: there are different components of the SGA. Every database will have a section within the memory (SGA) referred to as the database buffer cache!  It is split up into little blocks in memory called the oracle data blocks. Each one of these blocks will be 8k in size. There is an algorithm that gets applied to the database buffer pool, it is the LRU (least recently used).. As the blocks get touched they get placed toward the LRU to get written to disk, Oracle keeps the most used in memory for easier access. Another...

Read More

HOW DO YOU CREATE THE ORACLE PASSWORD FILE?

Oracle password file  is created using a utility called ORAPWD! You will also use this utility to make changes...

Read More

WHAT ARE YOUR ONLINE REDO LOGS?

An online redo log tracks all of your changes to your tables.  In order to get started, you need a minimum of  two to get started on your online database; this redo log group is like a recorder, that records changes going on in your oracle database. However, you will end up having more than one group. You could end up with three groups or more. Oracle  recommends that you multiplex your redo logs. When this redo log gets filled oracle does what is called a check point and then it writes to the next group. This redo logs are used...

Read More

THREE MOST IMPORTANT PARTS OF AN ORACLE DATABASE!

Before understanding the oracle database in depth, it is important to know the most important pieces in any database. This time we are discussing the oracle database. Storage - Think of it this way, your data needs to be stored in a table, which belongs to a logical area called table space and  a table space gets mapped to a physical file called a data file. (which essentially uses disk storage). Memory - This is called the System global Area (SGA) in Oracle. Processes - The third piece in an Oracle...

Read More

TYPES OF DATABASE ADMINISTRATORS!

Here is breakdown structure of the various types of database administrators! Can you tell which one fits your personality? Systems or Operational DBA Architect Applications DBA Data DBA Internet DBA  also a web dba! ...

Read More

HOW THE DBA EVALUATES HARDWARE!

The DBA evaluates hardware resources  by checking whether or not there are enough disk drives available to install the oracle database software.  What exactly does this mean, but first off, welcome you have just gotten hired as the new Database Administrator. Your first task as directed  in this small shop is to install the newly acquired oracle database software. What do you need to do? You are given a server and told go ahead...

Read More

WHO IS THE ORACLE DBA?

This is my first major post before delving into what exactly the Oracle DBA is required to do. Let us first simplify who an Oracle DBA is and what roles and responsibilities come with the position. photo myfootpath An database administrator (DBA) is the one who administers the Oracle database server. Responsibilities may vary depending on the size of the company the Oracle DBA works for. For instance,  a small company in most...

Read More

WHAT KIND OF A DBA ARE YOU?

So earlier today I took a test on basically figuring out what kind of DBA I am and here is the result! The scientist DBA is brilliant and sometimes shy, hates disorder, chaos and conundrums, and greatly enjoys diving into the internals of their database. The scientist DBA tends to have a love of music and gravitates towards degrees in “pure” majors such as History, English, Math, or Physics. Scientist DBAs usually keeps their offices neat and orderly, with everything in its proper place.   Their motto is “Prove it,” and they...

Read More