0
Oracle Database
Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.
500 Questions
What prophecy of the oracle turned out to be true for Zoe?
Asked by Wiki User
the goddest in chains shall be one's salvation
What is the different version of oracle?
Asked by Wiki User
Early versions of the oracle did not bear the latest features added to the latest version of the oracle. There are series of new features implemented in the newer version of the oracle.
new features are:
New "pivot" SQL clause - The new "pivot" SQL clause will allow quick rollup, similar to an MS-Excel pivot table, where you can display multiple rows on one column with SQL. MS SQL Server 2005 also introduced a pivot clause. Laurent Schneider notes that the new SQL "pivot" syntax is great for converting rows-to-columns and columns-to-rows.
The /*+result_cache*/ SQL hint - This suggests that the result data will be cached in the data buffers, and not the intermediate data blocks that were accessed to obtain the query results. You can cache SQL and PL/SQL results for super-fast subsequent retrieval. The "result cache" ties into the "scalable execution" concept. There are three areas of the result cache:
The SQL query result cache - This is an area of SGA memory for storing query results.
The PL/SQL function result cache - This result cache can store the results from a PL/SQL function call.
The OCI client result cache - This cache retains results from OCI calls, both for SQL queries or PL/SQL functions.
Scalable Execution - This 11g feature consists of a number of features, the first of which is query results caching; this feature automatically caches the results of an SQL query as opposed to the data blocks normally cached by the buffer cache, and works both client (OCI) and server side - this was described as "buffer cache taken to the next level". The DBA sets the size of the results cache and turns the feature on at a table level with the command "alter table DEPT cache results", the per-process cache is shared across multiple session and at the client level, is available with all 11g OCI-based clients. Mark Rittman
XML SQL queries - Oracle11g will support query mechanisms for XML including XQuery and SQL XML, emerging standards for querying XML data stored inside tables.
- SQL Replay - Similar to the previous feature, but this only captures and applies the SQL workload, not total workload. Source: Dr. Tim Hall
- Improved optimizer statistics collection speed - Oracle 11g has improved the dbms_stats performance, allowing for an order of magnitude faster CBO statistics creation. Oracle 11g has also separated-out the "gather" and "publish" operations, allowing CBO statistics to be retained for later use. Also, Oracle 11g introduces multi-column statistics to give the CBO the ability to more accurately select rows when the WHERE clause contains multi-column conditions or joins.
- SQL execution Plan Management - Oracle 11g SQL will allow you to fix execution plans (explain plan) for specific statements, regardless of statistics or database version changes. See Inside the 11g SQL Performance Advisor.
Dynamic SQL. DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations. Source: Lewis Cunningham
- SQL Performance Advisor - You can tell 11g to automatically apply SQL profiles for statements where the suggested profile give 3-times better performance that the existing statement. The performance comparisons are done by a new administrative task during a user-specified maintenance window.
- Improved SQL Access Advisor - The 11g SQL Access Advisor gives partitioning advice, including advice on the new interval partitioning. Interval partitioning is an automated version of range partitioning, where new equally-sized partitions are automatically created when needed. Both range and interval partitions can exist for a single table, and range partitioned tables can be converted to interval partitioned tables.
- Oracle 11g SQL tuning transformations
Why did Shang king scratch questions on oracle bones?
Asked by Wiki User
Shang Kings have questions scratched on oracle bones so the ancestors to answer the question
How do you install Oracle 10g in Windows XP?
Asked by Wiki User
http://oracledba-vinod.blogspot.com/2009/12/install-oracle-10g-on-windows-xp-using.HTML
Thanks
Vdhan
Installing Oracle 10g - step by step guideIntroduction:This article is a step-by-step instruction for those who want to install Oracle 10g database on their computer. This document provides guidelines to install Oracle 10g database on Microsoft Windows environment. If you use other operating system other than Microsoft Windows, the process is not too much different from that of Microsoft Windows, since Oracle uses Oracle Universal Installer to install its software.
For more information about installing Oracle 10g under operating systems other than Microsoft Windows, please refer to this URL :
http://www.oracle.com/pls/db102/homepage
How to get Oracle 10g :You can download Oracle 10g database from www.oracle.com. You must registered and create an account before you can download the software. The example in this document uses Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows. How to uninstall Oracle database software :- Uninstall all Oracle components using the Oracle Universal Installer (OUI).
- Run regedit.exe and delete the HKEY_LOCAL_MACHINE/ SOFTWARE/ORACLE key. This contains registry entire for all Oracle products.
- Delete any references to Oracle services left behind in the following part of the registry: HKEY LOCAL MACHINE/ SYSTEM/ CurrentControlsSet/ Services/Ora*. It should be pretty obvious which ones relate to Oracle
- Reboot your machine.
- Delete the C: \Oracle directory, or whatever directory is your Oracle_Base.
- Delete the C:\Program Files \Oracle directory.
- Empty the contents of your c:\temp directory.
- Empty your recycle bin.
- Insert Oracle CD , the autorun window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder.
- The Oracle Universal Installer (OUI) will run and display the Select Installation Method Window.
- Choose Basic Installation:
Select this option to quickly install Oracle Database 10g. This method requires minimal user input. It installs the software and optionally creates a general-purpose database based on the information you provide.
For basic installation, you specify the following:
Oracle Home Location - Enter the directory in which to install the Oracle Database 10g software. You must specify a new Oracle home directory for each new installation of Oracle Database 10g. Use the default value, which is :
c:\oracle\product\10.2.0\db_1
Installation Type - Select Enterprise Edition :
If you have limited space, select standard edition. Personal edition installs the same software as the Enterprise Edition, but supports only a single-user development and deployment environment.
Create Starter Database - Check this box to create a database during installation. Oracle recommends that you create a starter database for first Create Starter Database - time installations. Choose a Global Database Name, like cs157b, or just use the default value.
Type a password. Don't lose this password, since you will need it to connect to the database server.
Click next
- The Product-Specific Prerequisite Checks window appears: Click next
- A summary screen appears showing information such as your global settings, space requirements and the new products to be installed. Click Install to start the installation..
- The Install window appears showing installation progress.
- At the end of the installation phase, the Configuration Assistants window appears. This window lists the configuration assistants that are started automatically.
If you are creating a database, then the Database Configuration Assistant starts automatically in a separate window.
At the end of database creation, you are prompted to unlock user accounts to make the accounts accessible. The SYS and SYSTEM accounts are already unlocked. Click OK to bypass password management.
Note: Oracle 10g still keeps Scott / tiger username and password (UID=Scott, PWD=tiger) from the old version of oracle. In the old version of oracle, Scott/tiger user ID is available by default, but not in oracle 10g. If you want to use Scott /tiger account, you must unlock it by clicking "Password Management" at the last window.
Password Management window will appear like the one shown below. Find the user name "Scott" and uncheck the "Lock Account?" column for the user name.
- Your installation and database creation is now complete. The End of Installation window displays several important URLs, one of which is for Enterprise Manager.
- You can navigate to this URL in your browser and log in as the SYS user with the associated password, and connect as SYSDBA. You use Enterprise Manager to perform common database administration tasks
Note : you can access Oracle Enterprise Manager using browser by typing the URL shown above in your browser. Instead of typing the IP address, you can also access the Enterprise Manager by typing http://localhost:1158/em or "http://[yourComputerName]:1158/em" or by clicking "Start >> All Programs >> Oracle - [YourOracleHome_home1] >> Database Control - [yourOracleID]" in Windows menu.
By default, use user ID "SYSTEM", with the password that you have chosen at the beginning of installation, to connect to database, SQLPlus, etc. If you want to use other user ID, you may create a new user .
How is a database view different from tables?
Asked by Wiki User
A database view is a dynamic table compared to the 'fixed' ones.
A view contains a select statement, which dynamically updates the table everytime the view is looked at and the data has changed. Since these queries are compiled they will be faster than normal queries.
Example:
Table A:
ID, Integer
FullName, String
Table B:
AID, Integer
Address, String
You would like to find the address for each person.
Instead of making a long select each time you want a specific address for a specific person. You could make a select, that joins the data, make it into a view, and then use the View afterwards. Like:
SELECT a.id, a.fullname, b.address FROM a, b WHERE a.id = b.aid;
This will be your view, tView. Now the data:
SELECT * FROM tView WHERE fullname = 'John Randomness'.
What is the Difference between oracle apps technical and functional consultant?
Asked by Wiki User
At a very high level
Oracle Apps Functional Consultant -> One who understands business flows/processes and ways to do setup/tweak in oracle application to suite business needs.
Oracle Apps Technical Consultant -> One who understands the oracle application architecture and table-relations etc.
Whose is the owner of oracle and his shares?
Asked by Wiki User
Oracle Corporation is a publicly traded company on the NASDAQ (symbol ORCL). Larry Ellison owns about 22.7 percent of the outstanding shares.
What kind of threats can affect the database system?
Asked by Wiki User
hackers, viruses, users who don't know what they are doing
What are disadvantages of database approach?
Asked by Wiki User
The advantages of a relational database are that they contribute to sound logical design, are easy to understand and program, and should be amenable to change as business requirements change. The main earlier systems include file-based systems and Codasyl databases. File-based systems were complex and tended to be inherently restrictive and quickly reached the point where a complete rewrite became necessary if business requirements changed. Codasyl databases were a vast improvement on the old file-based systems, but required a high level of expertise to design properly and, once again, tended to be unable to support changes to business requirements. Because a properly designed relational database reflects business entities and the relationships among those entities, they should be more logical and easier to understand. If the business structure or requirements change in any logical way, the database can be changed in a parallel way, to support those requirements. Relational databases are designed at two levels. First, there is a logical design, normalised at third normal form - where there should not be duplicate data values. Then, there is a physical design, where any necessary denormalisation is carried out.
Oracle 8 Oracle 9 version?
Asked by Wiki User
Oracle Fusion Financials Online Training, Rainbow Training Institute having best instructors for Oracle Fusion Financials Online training and it is well known for providing all
Kinds of oracle fusion technologies through online and it is stepping forward in providing best Oracle Cloud Financials Online Training in Hyderabad, Bangalore, Chennai, Noida, Delhi, USA, UK, UAE, Saudi, Europe, India, Canada. Complete Suite of oracle fusion
financials training videos.
Where can one download the oracle client 10g?
Asked by Wiki User
Go to Oracle's webpage for a free download of Oracle 10g for Windows 7, and every other software need you have from Oracle! Oracle will help solve all your software needs!
What is difference between function and stored procedure in sql server?
Asked by Wiki User
A stored procedure is like a miniture program in SQL Server. It can be as simple as a select statement, or as complex as a long script that adds, deletes, updates, and/or reads data from multiple tables in a database. (Stored procedures can also implement loops and cursors which both allow you to work with smaller results or row by row operations on data.) The SQL Server functions are option for doing certain operations in SQL Server. They can not be used to update, delete, or add records to the database. They simply return a single value or a table value. They can only be use to select records. However, they can be called very easily from within standard SQL, such as: SELECT dbo.functionname('Parameter1') OR SELECT Name, dbo.Functionname('Parameter1') FROM sysObjects For simple reusable select operations, functions can simply your code. Just be wary of using JOIN clauses in your functions. If your function has a JOIN clause and you call it from another select statement that returns multiple results, that function call with JOIN those tables together for EACH line returned in the result set. So though they can be helpful in simpling some logic, they can also be a performance bottleneck if they're not used properly.
What is dba?
Asked by Wiki User
A DBA is a Database Administrator. It is the person who looks after the Database Management System. They may be part of the design team. They can look after who has access to the system and what levels of privilege. They will help people with any problems they are having. They may get the database to do more things and redesign it. They will maintain the database to make sure it works efficiently and it does not crash and no data is lost.
How can you view all the existing Databases in Oracle?
Asked by Wiki User
Database is one thing and tables another. If your trying to view data from a table, you should contact your database admin and or if you have connectivity, use A tool called Toad ( http://www.toadsoft.com) This tool will allow you to browse the data.
Disadvantages of file management system?
Asked by Wiki User
We may say its disadvantages are:
1. Unauthorized user can find your files easily.
2. Hacker can take advantage your computer file system if it is not password protected or encrypted.
What is static table in oracle?
Asked by Wiki User
A Dynamics chart is used to recreate, after the fact, essential elements of I"ll give the most familiar example, automobile accidents. This is essentially a limited use map with symbols and direction angles markers indicating vehicles involved, impact velocities, traffic direction ( normal and off-flow) and so on. as these are all quantities in motion, they are dynamic, hence the name. Most frequently used with courtroom investigations of automobile accidents.
What is an oracle and what does it do?
Asked by Wiki User
Oracle is one of the popular database. It grows by adding many supporting tools like client tools (Developer 2000), Enterprise manager (admin), Designer tools,ERP etc.
In simple, it stores your data, manipulate.
You may check my profile there is a link to my oracle faq site. It will give you some idea about oracle. Also google to more information.
What are Different types of keys in DBMS?
Asked by Wiki User
* Alternate key - An alternate key is any candidate key which is not selected to be the primary key
* Candidate key - A candidate key is a field or combination of fields that can act as a primary key field for that table to uniquely identify each record in that table.
For Eg:
The table:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
In the above example Ssn no. and employee identity are ccandidate keys.
* Compound key - compound key (also called a composite key or concatenated key) is a key that consists of 2 or more attributes.
* Primary key - a primary key is a value that can be used to identify a unique row in a table. Attributes are associated with it. Examples of primary keys are Social Security numbers (associated to a specific person) or ISBNs (associated to a specific book).
In the relational model of data, a primary key is a candidate key chosen as the main method of uniquely identifying a tuple in a relation.
For Eg:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
* Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.
For Eg:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
<Ssn,Name,Address>
<Ssn,Name>
<Ssn>
All the above are super keys.
* Foreign key - a foreign key (FK) is a field or group of fields in a database record that points to a key field or group of fields forming a key of another database record in some (usually different) table. Usually a foreign key in one table refers to the primary key (PK) of another table. This way references can be made to link information together and it is an essential part of database normalization.
For Eg:
For a Student....
School(Name,Address,Phone,School_Reg_noprimary_key
Who are Oracle's Competitors?
Asked by Wiki User
If you are talking about Oracle Database then some of them are:
Microsoft SQL Server
IBM UDB
Mysql (Which is also owned by Oracle)
If you meant Oracle as a company then the list is huge, Oracle Corporate have many solutions in many areas, Software (Databases, Security, Monitoring and more) and Hardware (Sun).
