Saturday, October 13, 2007

Oracle Configurations

There are many different types of Oracle configurations and uses. Let's look at some of these different types of systems and analyze their usage and characteristics.
OLTP
The Online Transaction Processing (OLTP) system is probably the most common of the RDBMS configurations. OLTP systems have online users that access the system. These systems are typically used for order-entry purposes, such as for retail sales, credit-card validation, ATM transactions, and so on.
Characteristics of OLTP Systems
OLTP systems typically support large numbers of online users simultaneously accessing the RDBMS. Because users are waiting for data to be returned to them, any excessive response time is immediately noticeable. OLTP systems are characteristically read and write intensive. Depending on the specific application, this read/write ratio might vary.
DSS
The Decision Support System (DSS) is used to assist with the decision-making process. These decisions might be based on information such as how sales in a particular region are doing, what cross-section of customers is buying a particular product, or to whom to send a mailing. The DSS system is used to help make decisions by providing good data.
Characteristics of a DSS
The DSS is characterized by long-running queries against a large set of data. Unlike the OLTP system, where users are waiting for data to return to them online, here users expect the queries to take minutes, hours, or days to complete. The data is typically generated from a different source and loaded onto the DSS computer in bulk. Except for during the load, the DSS system is characterized by being read intensive (with very few writes).
Data Warehouse
A data warehouse is typically considered to be a large-scale system that consists of both DSS and OLTP components. These systems are typically hundreds of gigabytes in size and support many users.
Characteristics of a Data Warehouse
Data warehouses have some of the attributes of a DSS system, such as long-running queries and a possible online component. In many cases, this component is the source of the data used in the DSS queries.
Data Mart
A data mart, which is a smaller-scale version of a data warehouse, serves many of the same functions as a data warehouse.
Characteristics of a Data Mart
A data mart is typically 100GB or less in size. As with a data warehouse, a data mart supports many online users as well as a decision-support function.
Video Server
A video server can support large numbers of video data streams. These video streams can be used for purposes such as video on demand for entertainment as well as training functions.
Characteristics of a Video Server
The video server system must support a high network bandwidth in order to support multiple data streams. The video server must also be able to support a high I/O bandwidth. These disk accesses are typically of a very large block size and sequential in nature.
Web Server
The Oracle Web server is designed to support both static and dynamic Web pages. These pages can be simple Web pages or complex database-generated pages. Oracle Web server systems are also typically used in Web commerce applications. These installations can allow the customer to browse online catalogs, which might feature graphics or even video. The customer can then purchase items online.
Characteristics of an Oracle Web Server The Oracle Web server typically supports many online users. There is typically a large amount of data that has been accessed frequently and other data that is less frequently accessed. A large amount of memory can help improve performance in this type of configuration.
OLAP
The term OLAP (Online Analytical Processing) is usually used in relation with multidimensional data. OLAP users might be financial analysts or marketing personnel looking at global data.
Characteristics of an OLAP System
An OLAP system typically involves a large amount of disk space with heavy I/O and memory requirements. An OLAP system might support only a few or many users. This depends on your type of configuration.

Oracle Terms

Oracle Terms


Many different terms and concepts will be used throughout. I've introduced them here to make it easier for you to grasp many of the concepts and lessons to follow.
Ad Hoc Query
This use of the Latin term means an impromptu, simple query.
Block
A block is the smallest unit of storage in an Oracle database. The database block contains header information concerning the block itself as well as the data or PL/SQL code. The Oracle block size is configurable with the minimum size being 2KB and the maximum size being 16KB.
Bottleneck
In computer terms, a bottleneck is a system component that limits the performance of the system.
Buffer
This term refers to an amount of memory used to store data. A buffer stores data that is about to be used or that has just been used. In many cases, buffers are in-memory copies of data that is also on disk. Buffers can be used as a copy of data for quick read access, they can be modified and written to disk, or they can be created in memory as temporary storage.
In Oracle, database buffers of the SGA store the most recently used blocks of database data. The set of database block buffers is known as the database buffer cache. The buffers used to temporarily store redo entries until they can be written to disk are known as redo log buffers.
Cache
A cache is a storage area used to provide fast access to data. In hardware terms, the cache is a small (relative to main RAM) amount of memory that is much faster than main memory. This memory is used to reduce the time it takes to reload frequently used data or instructions into the CPU. CPU chips themselves contain small amounts of memory built in as cache.
In Oracle, the block buffers and shared pool are considered caches because they are used to store data and instructions for quick access. Caching is very effective in reducing the time it takes to retrieve frequently used data.
Caching usually works using a least recently used algorithm. Data that has not been used for a while is eventually released from the cache to make room for new data. If data is requested and is in the cache (a phenomenon called a cache hit), the data is retrieved from the cache, preventing it from having to be retrieved from memory or disk. After the data has been accessed again, it is marked as recently used and put on the top of the cache list.
Checkpoint
A checkpoint is an operation that forces all changed, in-memory data blocks to be written out to disk. This is a key factor in how long the database takes to recover in the event of a failure. This concept is discussed in depth on Day 2, "Exploring the Oracle Architecture."
Clean Buffer
A clean buffer is a buffer that has not been modified. Because this buffer has not been changed, it is not necessary for the DBWR to write this buffer to disk.
Concurrency
This term refers to the capability to perform many functions at the same time. Oracle provides for concurrency by allowing many users to access the database simultaneously.
Database
A database is a set of data, organized for easy access. The database is the actual data. It is the database that you will be accessing when you need to retrieve data.
Data Dictionary
The data dictionary is a set of tables Oracle uses to maintain information about the database. The data dictionary contains information about tables, indexes, clusters, and so on.
DBA (Database Administrator)
The DBA is the person responsible for the operation, configuration, and performance of the database. The DBA is charged with keeping the database operating smoothly, ensuring that backups are done on a regular basis (and that the backups work), and installing new software. Other responsibilities might include planning for future expansion and disk space needs, creating databases and tablespaces, adding users and maintaining security, and monitoring the database and retuning it as necessary. Large installations might have teams of DBAs to keep the system running smoothly; alternatively, the tasks might be segmented among the DBAs.
DBMS or RDBMS
The Database Management System is the software and collection of tools that manages the database. Oracle software is the DBMS. A Relational Database Management System is a DBMS that is relational in nature. This means that the internal workings access data in a relational manner. Oracle is an RDBMS.
DDL (Data Definition Language) Commands
These commands are used in the creation and modification of schema objects. These commands provide the ability to create, alter, and drop objects; grant and revoke privileges and roles; establish auditing options; and add comments to the data dictionary. These commands are related to the management and administration of the Oracle database. Before and after each DDL statement, Oracle implicitly commits the current transaction.
Dirty Buffer
A dirty buffer is a buffer that has been modified. It is the job of the DBWR to eventually write all dirty block buffers out to disk.
DML (Data Manipulation Language) Commands
These commands allow you to query and modify data within existing schema objects. Unlike the DDL commands, a commit is not implicit. DML statements consist of DELETE, INSERT, SELECT, and UPDATE statements; EXPLAIN PLAN statements; and LOCK TABLE statements.
Dynamic Performance Tables
These tables are created at instance startup and used to store information about the performance of the instance. This information includes connection information, I/Os, initialization parameter values, and so on.
Function
A function is a set of SQL or PL/SQL statements used together to execute a particular function. Procedures and functions are identical except that functions always return a value (procedures do not). By processing the SQL code on the database server, you can reduce the number of instructions sent across the network and returned from the SQL statements.
IM (Information Management)
This term is usually used to describe the department that handles your corporate data.
IS (Information Systems)
This term is also used to describe the department that handles your corporate data.
IT (Information Technology)
This term is used to describe the business of managing information.
Network Computing Architecture (NCA)
The Network Computing Architecture is a standard for computing over the network. The NCA was developed in conjunction with Oracle.
Physical Memory
This term refers to the actual hardware RAM (Random Access Memory) available in the computer for use by the operating system and applications.
Procedure
A procedure is a set of SQL or PL/SQL statements used together to execute a particular function. Procedures and functions are identical except that functions always return a value (procedures do not). By processing the SQL code on the database server, you can reduce the number of instructions sent across the network and returned from the SQL statements.
Program Unit
In Oracle, program unit is used to describe a package, a stored procedure, or a sequence.
Query
A query is a read-only transaction against a database. A query is generated using the SELECT statement. Users generally distinguish between queries and other transaction types because a query does not the change data in the database.
Schema
A schema is a collection of objects associated with the database.
Schema Objects
Schema objects are abstractions or logical structures that refer to database objects or structures. Schema objects consist of such things as clusters, indexes, packages, sequences, stored procedures, synonyms, tables, views, and so on.
System Global Area (SGA)
The SGA is a shared-memory region that Oracle uses to store data and control information for one Oracle instance. The SGA is allocated when the Oracle instance starts; it is deallocated when the Oracle instance shuts down. Each Oracle instance that starts has its own SGA. The information in the SGA is made up of the database buffers, the redo log buffer, and the shared pool; each has a fixed size and is created at instance startup.
Transaction
A transaction is a logical unit of work consisting of one or more SQL statements, ending in a commit or a rollback. Performance measurements often use the number of transactions per second or per minute as the performance metric.
Trigger
A trigger is a mechanism that allows you to write procedures that are automatically executed whenever an INSERT, UPDATE, or DELETE statement is executed on a table or view. Triggers can be used to enforce integrity constraints or automate some other custom function.
Virtual Memory
This term refers to the memory that can be used for programs in the operating system. To overcome the limitations associated with insufficient physical memory, virtual memory allows programs to run that are larger than the amount of physical memory in the system. When there is not enough physical memory in the system, these programs are copied from RAM to a disk file called a paging or swap file. This arrangement allows small systems to run many programs. You pay a performance penalty when the computer pages or swaps.
Storage Units
Data is stored in the computer in a binary form. The units used to refer to this binary data are as follows:

bit :The smallest unit of data storage A bit is either a 1 or a 0.
nibble :4 bits This term is not commonly used.
byte : 8 bits The most commonly used storage unit.
word :This term is architecture On some systems, a word is 16 bits;
dependent on others, a word is 32 or 64 bits.
kilobyte (KB):Even though kilo usually means 1,000, a kilobyte in computer terms is actually 1,024 bytes (because we like powers of 2).

megabyte (MB):The term megabyte denotes 1,024KB or 1,048,576 bytes.
gigabyte (GB):A gigabyte is 1,024 megabytes or 1,073,741,824 bytes.
terabyte (TB):A terabyte is 1,024 gigabytes or 1,099,511,627,776 bytes.

It is not uncommon to hear large data warehousing sites talk in terms of terabytes. In the next few years, you will probably hear of systems using storage in the tens and hundreds of terabytes

History of Oracle

History of Oracle

Being an Oracle database operator or administrator can be a demanding but rewarding career that carries with it a great deal of responsibility as well as authority. This book is intended to help you embark on this exciting path. I hope that within the pages of this book I can convey some of the enthusiasm and excitement I feel when working with state-of-the-art hardware and software such as Oracle8.
I think the best way to grasp a concept is to fully understand why actions are taken and the consequences of those actions. If you understand how Oracle works and its interactions with the operating system and hardware, you can more easily predict and anticipate the result of actions you take. In this book, I attempt to fully explain the workings of Oracle and the supporting software and hardware.
A Brief History of Oracle
In 1977, Larry Ellison, Bob Miner, and Ed Oates formed a company called Relational Software Incorporated (RSI). This company built an RDBMS called Oracle. Ellison, Miner, and Oates made a key decision: to develop their RDBMS using C and the SQL interface. Soon after, they came out with version 1, a prototype. In 1979, RSI delivered its first product to customers. The Oracle RDBMS version 2 worked on the Digital PDP-11 running the RSX-11 operating system and was soon ported to the DEC VAX system.
1983 heralded the release of version 3, which touted changes in the SQL language as well as performance enhancements and other improvements. Unlike earlier versions, version 3 was written almost entirely in C. At this point, RSI changed its name to Oracle Corporation.
Oracle version 4 was released in 1984. This version supported both the VAX system and the IBM VM operating system. Version 4 was the first version to incorporate read consistency. Version 5, introduced in 1985, was a milestone because it introduced client/server computing to the market with the use of SQL*Net. Version 5 was also the first MS-DOS product to break through the 640KB barrier.
In 1988, Oracle presented version 6, which introduced low-level locking as well as a variety of performance improvements and functionality enhancements, including sequence generation and deferred writes. I was introduced to Oracle6 back in the days when we ran the TP1, TPC-A, and TPC-B benchmarks. At this point, Oracle was running on a large variety of different platforms and operating systems. In 1991, Oracle introduced the Oracle Parallel Server option on version 6.1 of the Oracle RDBMS on the DEC VAX platform. Soon the Parallel Server option was available on a variety of platforms.
Oracle7, released in 1992, included many architectural changes in the area of memory, CPU, and I/O utilization. Oracle7 is the full-featured RDBMS to which you are accustomed, the one you've been using for many years. Oracle7 introduced many advances in the area of ease of use, such as the SQL*DBA tools and database roles.
Finally, in 1997 Oracle introduced Oracle8, which added object extensions as well as a host of new features and administrative tools.
For more information about the history of Oracle (specifically about the Oracle server), check out the two-part article by Ken Jacobs in the January/February and March/April 1995 issues of Oracle Magazine.
For more information about the Oracle corporation, its products, and about working with Oracle, check out www.oracle.com. This Web site contains a wealth of information about Oracle parterships and products as well as information about the Oracle Developer Program, which specifically assists developers.

Friday, October 12, 2007

HARRY POTTER BOOK DOWNLOAD











Harry Potter and the Sorcerers Stone

http://w4.media-convert.com/convert/?xid=jwanrdoi

Harry Potter and The Chamber of Secrets

http://w4.media-convert.com/convert/?xid=wmkcvpwh

Harry Potter and the Prisoner of Azkaban

http://w4.media-convert.com/convert/?xid=chnjgrsl

Harry Potter and The Goblet of Fire

http://w4.media-convert.com/convert/?xid=gpowmyjr

Harry Potter and the Order of the Phoenix

http://w4.media-convert.com/convert/?xid=hicbwvxw

Harry Potter and the Half-Blood Prince.

http://w4.media-convert.com/convert/?xid=ovzofeox

Harry Potter and the Deathly Hallows

http://w4.media-convert.com/convert/?xid=davttmal


happy days songs
  1. Ye Cheekati

http://w10.media-convert.com/convert/?xid=uqriston

2. Ya Kundendu

http://w10.media-convert.com/convert/?xid=vhjbtcpl

3.Jill Jill Jinga

http://w7.media-convert.com/convert/?xid=eoldsdvi

4.Happydays Rock

http://w10.media-convert.com/convert/?xid=vreapxzc

5.Arey rey

http://w10.media-convert.com/convert/?xid=hkkkwfqb

6.Happy Days

http://w10.media-convert.com/convert/?xid=fyyxwwyv

7.Oh my friend

http://w10.media-convert.com/convert/?xid=vhjbtcpl

haleem common procedure

Take 1/2 kilo vanspathi or ghee and 1/2 kilo oil mix them together and heat them

Fry cashew and onion in the mixture of oil and remove them and keep it aside.

In that oil put cloves cinnonam slicks sageera cinnamon peper ginger garlic paste curd mint leaf corinder leafcurd and wait till the mixture leaves the oil out

seperate the oil from the mixture

seperate the rosted part into two add one part to the boneless meat and

the other part to mixture of wheat rava(soaked for 4-5 hrs) green moong dal, kassori dal and rice and cook both of these seperately

mash them seperatelythen mix them and cook it again for 5 min serve them with the removed oil fried onion cashew

MUTTON HALEEM

MUTTON HALEEM

Ingredients :
250 gms Mutton.
1 cup Wheat soaked overnight, drained, pounded & husked.
A handful of channa dal, soaked for 1/2 hour.
A handful of moong dal, soaked for 1/2 hour.
A handful of masoor dal, soaked for 1/2 hour.
1 tsp Chili powder.
1/2 tsp Haldi.
2 Onions, sliced and fried crisp.
1 tsp Dhania powder.
2 tsp Ginger-garlic paste.
4 tbsp Ghee.
Salt to taste.


Preparation :



Take a wide mouthed heavy-bottomed vessel and heat 6-8 cups of water in it.
When the water starts to boil put in the drained dal, wheat and mutton along with the ginger garlic paste, dhania powder, haldi, red chili powder and salt.
Cook over slow fire till the mutton is tender then mash the mutton.
To this mixture add the crushed fried onion.
Heat the ghee and pour it over the Haleem.
Sprinkle lemon-juice if you want before serving - serve hot. Top


vegetable haleem

Vegetarian Haleem

1 C wheat, soaked overnight
1/2 C channa daal, soaked overnight
2 tsp haleem masala
4 C water
3/4 tsp garlic
3/4 tsp ginger
1 tsp oil
1 tsp salt

Cook all of the above together on low heat until the wheat is cooked through. Mash with a potato masher. If cooking in a pressure cooker, cook 15-20 minutes.

For the Khorma:

3/4 C onion
1 tsp lal mirchi
1/4 tsp haldee
1 tsp garlic
1 tsp ginger
1/2 tsp dhaniya powder *
16 almonds, ground fine **
1 C yogurt
1 C water
1 tsp salt
1/2 tsp bhojwar masala ***
3/4 tsp haleem masala ***

Cover onion with oil and fry on medium high heat until it gets brown (not brown all the way through). Add lal mirchi, haldee, garlic, ginger, and dhaniya powder. Fry a little, then add yogurt and almonds. Add water and salt. Bring to boil, then add bhojwar and haleem masalas (if using).

* add 1 tsp if making khorma to eat plain and not to mix into haleem
** use extra almonds if making khorma to eat plain and not to mix into haleem
*** omit if making khorma to eat plain and not to mix into haleem

Mix khorma into haleem and heat through. When serving haleem, serve with lemon juice, fried onions, chopped fresh onion, cilantro, chopped fresh ginger, mint, and green chilis.

haleem prepration


Haleem
Ingredients :


1. Wheat - 1/2kg
2. Water - 3litre
3. Sliced Onion - 1
4. Salt - to taste
5. Clove, Cinnamon, Cardamom - 1 or 2 each
6. Cashew nuts, Raisins, Onion - to decorate
7. Chicken or Mutton - 150gm
8. Ghee - 30 gm



Method of Preparation :


Cut the chicken or mutton into small pieces. Cook the meat with wheat, sliced onion, spices and salt in water. Cook on slow fire till the meat is tender. Remove from fire. Take out the mutton and chicken pieces and grind the rest (wheat, onions and spices). Mash the mutton or chicken pieces and add it to the ground mixture. Fry cashew nuts and raisins in ghee and pour it over the haleem. Decorate with fried onion and serve hot.