can anyone give me the architecture of Oracle database?
353144
One of the best articles i referred for the same question is the following link:\nhttp://www.craigsmullins.com/edgesu95.htm\n\nIts explained in simple & easy language...\nCheckout!
285429
I do not know but I hate Oracle I use it at work!!\nGood Luck
77222
You just have to know the basics of the database structre and how the data is stored. Belive me its not difficult.
725368
Both SQL Server and Oracle are Relational Database Management Systems. Microsoft Access is not; it is run by a jet engine instead.\n\nMicrosoft created Access in an attempt to compete with FoxPro (a product similar to Access). When Access failed to do compete with FoxPro, Microsoft bought the FoxPro company.\n\nNow for the Oracle and SQL Server, both are Relational Database Management Systems. A Relational Database Management System is capable of supporting concurrency (concurrent access to data), transactions (ablity to excute queries as an atomic block with rollback capability) so it can handle more concurrent users and it is for sure more reliable in a multiuser environment.\n\nIt is very hard to say which (Oracle or SQL Server) is better because there are so many factors that have to be taken into consideration, however SQL Server enjoyes a remarkable growth rate because it is easier to use and more cost-effective than the competing enterprise Database systems like Oracle and IBM DB2. Of course oracle and IBM DB2 have been entrenched in the enterprise for some time now , unlike SQL Server.\n\nOne last point. You can use any of the above products to handle 1000 records, However since you are still learning about Database programming, I suggest you learn either SQL Server or Oracle so that you learn some Database programming concepts like the use of Database objects such as stored procedures, triggers, transactions and so on.
361517
well thats a huge question.....there are literally books on this topic....\n\nread oracle 9i performance tuning tips and techniques by richard niemiec\n\nbut u can start with this...\n\nrun statspack on ur database for the high load periods\nrun tracing on the main sessions at level 12 \nsee explain plans of the queries those sessions are executing.\nsee v$session_wait for any waits
171196
http://www.orafaq.com/\n\nhttp://www.peoplesoft.com/corp/en/public_index.jsp\n\nhttp://www.db.cs.ucdavis.edu/teaching/sqltutorial/\n\nhttp://en.wikipedia.org/wiki/Oracle_database
829063
Business database software. Similar to Oracle. Originally from Germany.
109303
Tom Kyte is a Oracle Guru and has site which you can check for any pl-sql questions - http://asktom.oracle.com/pls/ask/f?p=4950:1:\nAlso he has some books published regarding pl-sql which I have and are highly useful. Oracle has online documentation which is completely searchable and downloadable - http://www.oracle.com/pls/db92/db92.homepage \nThis has lot of details regarding commands with examples.\nFor sample code check this out -\nhttp://www.oracle.com/technology/sample_code/tech/pl_sql/index.html\n\nHope this gets you going. Let me know if you need more help. \n\nGood Luck !!
268492
Here are links:\nOracle Real Application Clusters Quick Installation Guide\nfor Oracle Database Standard Edition 10g Release 1 (10.1.0.2.0) for Windows\nhttp://download-uk.oracle.com/docs/html/B13829_01/toc.htm\n\nOracle Real Application Clusters Installation and Configuration Guide\nhttp://download-uk.oracle.com/docs/html/B10766_08/toc.htm\n\nAnd here is the complete list of Oracle documentation:\nhttp://www.oracle.com/technology/documentation/database10g.html\n\nServer will ask you to enter your login at Oracle Technology Network. Register there if you aren't yet. It's free and very useful.\n\nGood luck!
196431
Oracle is a Client/Server database system. Where do you live?
937881
these links can help\n\nhttp://www.dba-oracle.com/oracle_tips_db_copy.htm\nhttp://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci979078,00.html
1088663
Place in the first CD and start the Oracle Installer. What you'll need to install on your computer is not only the Oracle database but also the Oracle server (which from wht I've heard can be configured and installed only on the same partition windows is installed...). Then you'll be prompted for what kind of database do you want to configure on your system (depends..). After this Oracle will copy all the files needed... You'l have a hard time configuring users password, group id's in Oracle 9i...
278932
Object Management Group holds trademarks to several similar terms including Model Driven Application Development, Model Based Application Development, Model Based Programming, and others\n\nA database that is managed by an object-oriented database management system (ODBMS). Object databases are closely aligned with a particular object-oriented programming language and enable the data in the objects to be persistently stored without requiring conversion to a relational database (see O-R mapping). A fair amount of tedious code is eliminated, and the object data are stored much faster.\n\nComplex Structures\n\nObject databases are also suited for applications that are not necessarily based on an object model, but use a large number of in-memory indexes that are difficult to store in a relational database. Object databases may be used for realtime applications whereby they can extend memory beyond the operating system's own virtual memory limit.\n\nObject Vs. Relational\n\nExamples of object-oriented databases are ObjectStore (www.progress.com/realtime) and Versant VDS (www.versant.com). Some relational databases have added object-oriented features, but for the most part, object databases and relational databases are separate products. UniSQL was one of the first products to support both database types
339810
Use the link below to visit the download server of Oracle...\nhttp://www.oracle.com/technology/software/index.html\n\nAll downloads are FREE under the Developer License which allows you to use full versions of the products only while developing and prototyping your applications....\n\nRead the License Agreement for more information about licensing...
957966
click here:http://en.wikipedia.org/wiki/Database_management_system
240957
A distributed database system allows applications to access data from local and remote databases. In a homogenous distributed system, each database is an Oracle database. In a heterogeneous distributed system, at least one of the databases is a non-Oracle database. Distributed databases use a client/server architecture to process information requests. \n\nAn Oracle distributed database system can incorporate Oracle databases of different versions. All supported releases of Oracle can participate in a distributed database system. Nevertheless, the applications that work with the distributed database must understand the functionality that is available at each node in the system--for example, a distributed database application cannot expect an Oracle7 database to understand the object SQL extensions that are only available with Oracle8i. \n\nDistributed Databases Vs. Distributed Processing\nThe terms distributed database and distributed processing are closely related, yet have distinct meanings. \n\nDistributed database \n A set of databases in a distributed system that can appear to applications as a single data source.  \n \nDistributed processing \n The operations that occurs when an application distributes its tasks among different computers in a network. For example, a database application typically distributes front-end presentation tasks to client computers and allows a back-end database server to manage shared access to a database. Consequently, a distributed database application processing system is more commonly referred to as a client/server database application system. \n \n \n\n\nOracle distributed database systems employ a distributed processing architecture. For example, an Oracle database server acts as a client when it requests data that another Oracle database server manages. \n\nDistributed Databases Vs. Replicated Databases\nThe terms distributed database system and database replication are related, yet distinct. In a pure (that is, non-replicated) distributed database, the system manages a single copy of all data and supporting database objects. Typically, distributed database applications use distributed transactions to access both local and remote data and modify the global database in real-time.
133576
the database + the management softwares