tag:blogger.com,1999:blog-317104312011-12-14T18:37:01.845-08:00All about Oracle 9i. It contains information about Oracle fundamentals. It also includes some tutorial about how to connect to oracle 9i, how to create database, tablespace, managing control file in Oracle 9i with some example.Gaurang Patelhttp://www.blogger.com/profile/05996192719055562736noreply@blogger.comBlogger11100tag:blogger.com,1999:blog-31710431.post-1153936720109530612006-07-26T10:57:00.000-07:002006-07-27T16:05:21.843-07:00<a style="color: rgb(102, 0, 0); font-weight: bold;" href="http://patelgaurang.blogspot.com">Back to Home Page</a><br /><br /><br /><div style="text-align: center;"><span style="font-weight: bold; color: rgb(0, 0, 102);">Oracle 9i Tutorial<br /><br /></span><div style="text-align: left;"><span style="font-weight: bold; color: rgb(0, 0, 102);"></span><span style="font-weight: bold; color: rgb(0, 0, 102);font-family:georgia;" >1. What is Oracle? What are the primary compotnents of Oracle Architecture Database.</span><br /><span style="font-size:85%;">Oracle is a database which is developed by a company called Oracle Corporation Ltd.<br />Primary Components of Oracle architecture.<br /><span style="font-weight: bold;"><span style="color: rgb(0, 0, 102);">Oracle Server</span> </span></span><br /><span style="font-size:85%;">A Database management system that provides an open, comprehensive and integrated approach to information management. There are several files, processes and memory structures in Oracle server. Some are used for SQL processing, some are for performance and some to ensure the recovery of database incase of error. It consists of Oracle Instance and an Oracle Database.</span><br /><span style="color: rgb(0, 0, 0);font-size:85%;" ><span style="font-weight: bold;"><span style="color: rgb(0, 0, 102);">Oracle Instance:</span> </span></span> <span style="font-size:85%;">A combination of memory structure and background processes. Instance must be started to access the oracle database. When it starts SGA (System Global Area or called Shared Global Area is allocated and oracle background processes are also stared. Background processes perform input/output and monitor other oracle processes for better performance and reliability. It always open one and only one database at a time.<br /> <br /></span> <span style="font-weight: bold; color: rgb(0, 0, 102);font-size:85%;" >Oracle Database:</span> <span style="font-size:85%;">Is a collection of data which consist of three types of files. Datafiles, Control files, redo log files.<br /></span><br /><span style="color: rgb(0, 0, 102);font-size:85%;" ><span style="font-weight: bold;">Other Key files: </span> </span> <span style="font-size:85%;">Non database files such as password file, parameter file, archived redo log files are used to authenticate privileged users to start up and shut dow, to configure the instance and for recovery from media failures respectively.</span><br /><span style="font-size:85%;"><br />User and Server Processes and Ohter Processes like Advance queuing, Real Application Clusters, Shared Server, Advance Replication. </span> <br /><br /><span style="font-weight: bold; color: rgb(0, 0, 102);">2. How to eastablish connection to oracle server? What are different ways to connect to an Oracle server?</span><br /><span style="font-size:85%;">When user starts a tool such as SQL plus or runs any application user process is executed. When user logs on to Oracle server a process is created on the server. This process is called server process. Now this server process will communicated with oracle instance on behalf of the user process that runs on client.<br />In short, server process runs sql statements on behalf of user.</span><br /><span style="font-size:85%;">Connections:<br />There are three ways to establish a connetion with oracle server.<br /></span><ul><li><span style="font-size:85%;">User can log on to the OS on which oracle Instance is running and starts and application or tool which access the database on the same system. Interprocess communication is used to establish a communication pathway between oracle server and Host operating system.</span></li><li><span style="font-size:85%;">User starts an application or sql tool on one machine(client machine) and connects over a network to a machine running oracle instance. This configuation is also called Client-Server.</span></li><li><span style="font-size:85%;">Three Tiered Connection. Here user's computer communicates over Network to an application or N/w server which is connected to a network to the machine running the oracle instance.</span><br /></li></ul><span style="font-weight: bold; color: rgb(0, 0, 102);">3. What is a Session? When it starts and when it terminates?</span><br /><span style="font-size:85%;"> Session is a specific connection of a user to an oracle server. It starts when user is validated by oracle server and teminates when user logs out or when there is an abnormal termination occures.</span><br /><br /><span style="font-weight: bold; color: rgb(0, 0, 102);">4. What is Memory Structure in Oracle? </span><br /><span style="font-size:85%;"> Oracle consists of Two memory structures</span><br /><ul><li style="font-weight: bold; color: rgb(0, 0, 102);"><span style="font-size:85%;">SGA ( System Global Area )</span></li><ul><li><span style="font-size:85%;">Allocated when Oracle Instance starts. Fundamental Component of an Oracle Instace.</span><br /></li></ul><li style="font-weight: bold; color: rgb(0, 0, 102);"><span style="font-size:85%;">PGA ( Program Global Area )</span></li><ul><li><span style="font-size:85%;">Memory reserved for each user process connecting to Oracle database</span></li><li><span style="font-size:85%;">Allocated when a process is created.</span></li><li><span style="font-size:85%;">Deallocated when a process is terminated.</span></li><li><span style="font-size:85%;">Used by only one process.</span><br /></li></ul></ul><span style="font-weight: bold; color: rgb(0, 0, 102);font-size:100%;" >5. Oracle Instance</span><br /><br />Memory Structures<br /><br />Shared Pool<br />Database Buffer Cache<br />Redo log buffer Cache<br />Large Pool<br />Java Pool<br /><br />Backgroung Process Stuctures<br /><br />PMON<br />SMON<br />DBWR<br />LGWR<br />CKPT<br /><br /><div style="text-align: center;"><span style="font-weight: bold;">// Under Construction </span><br /></div><br /><span style="font-weight: bold; color: rgb(0, 0, 102);"></span></div></div><div class="blogger-post-footer"><script type="text/javascript"><!-- google_ad_client = "pub-5854221744164635"; google_ad_width = 160; google_ad_height = 600; google_ad_format = "160x600_as"; google_ad_type = "text_image"; google_ad_channel =""; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/31710431-115393672010953061?l=ora9i.blogspot.com' alt='' /></div>Gaurang Patelhttp://www.blogger.com/profile/05996192719055562736noreply@blogger.com2