Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 1: Understanding the Oracle Environment
In Oracle world each connected user with oracle
server is considered as session. If there are three connected users with
oracle server, we can say that there are three sessions with oracle
server. If one person logs off then the number of sessions drops to two.
SQL commands are very simple and very easy to master, as it is comprised
of all full-length English words with no or very little abbreviations.
For example lets have a look on following SQL command
SELECT name, phone
FROM address_book;
Once Oracle Instance will receive this command, it will retrieve all the “name” and “phone” information from the address_book table and send it to the user who had asked for it. If there are 1000 records or rows in that table; all of them get sent to user computer.
Figure 2: Oracle Instance can hear you from any corner
of globe whether its LAN or internet.
________________________________________
Chapter 1: Understanding the Oracle Environment
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: