answersLogoWhite

0


Best Answer

there can as many as the operating system will supports

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How many Maximum Datafiles can there be in an Oracle Database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between oracle and oracle erp?

Oracle is a database corporation that has many products such as Database, BI and ERP


How much data store in oracle database?

Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.


How many max data files can there be in an Oracle Database?

There can as many as the Operating System will support. The limitation of "how many" is set by the OS and not the database. Two Oracle parameters to research that are related to your question however.... db_files, and maxdatafiles


What is Toad for Oracle used for?

Toad the Oracle is a database tool. It is probably the most well known and commonly used Oracle DBA software that you will find. You can find many websites devoted to Toad for Oracle.


Who are Oracle's Competitors?

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).


What is an oracle and what does it do?

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 can you use to create a database for customers in a supermarket?

Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.


How many maximum Redo Logfiles one can have in a Database?

In a database we can create 255 maximum redo log files Depends on what you specified for MAXLOGFILES during database creation (manually) or what you specified for "Maximum no. of redo log files" with DBCA. sri


Where can one download Oracle 11i?

To get Oracle 9i, go to www.oracle.com. Go to the downloads page for 11g, scroll to the bottom, and select Previous database releases, Oracle 9i.


What is the differences between altibase and oracle?

Oracle has many products, but presumably you are referring to either 11g or 12c. The difference between Oracle and Altibase is that Oracle is a traditional disk-based database while Altibase is an in-memory database. As an in-memory database, Altibase is significantly faster than Oracle. One way to look at this is Oracle's buffer cache. Oracle uses the buffer cache to significantly increase read speeds by keeping the data in memory. However, this has no impact on updates, deletes, or inserts, whereas Altibase enjoys these performance enhancements across the board. Altibase differentiates itself from other in-memory databases by marketing itself as a hybrid. This allows it utilize both an in-memory database and disk database using a single engine, which allows it enjoy the speed benefits of in-memory databases while also utilizing cheaper disk-based storage for rarely queried data. In many ways however, the two databases are very similar as they are both ACID compliant relational databases.


How many records can Oracle Database hold?

It depends how much space you have left on your server; the more space you have, the more records it can hold.


Specialization Means Money?

The Oracle database administrator is responsible for supporting the Oracle databases of a company, which means ensuring their top quality performance, security, and availability.The Oracle database is an ORDBMS, or an object relational database management system. It has, since its inception in 1977, become the industry standard in its field. As many companies have already chosen the Oracle software to handle its databasing needs, the administrator position holds a very large and central role within the information technology aspects of many top companies.The average Oracle database administrator makes US $100,000 as a starting salary.The responsibilities of an Oracle database administrator can include -Ensuring the ongoing peak performance and availability of the databases supporting the core system.The responsibility for releasing and implementing changes to the database as they are submitted to the developersWork with an interdepartmental team to ensure that the resources associated with the hardware are properly allocated to databases.Ensuring the optimum performance and availability of said hardware.Final responsibility for maintenance and improvement of databases, including upgrades and rollout.Monitoring the databases to ensure implementation of security measures.Monitoring the databases to ensure minimum downtime.Final responsibility for problem escalation to third parties and to the Oracle Development Team as found appropriate.Providing the service management team with trend analysis so thay they can make informed decisions about the allocation of resources.Oracle provides official certification in its products, which can help tremendously with employment as an Oracle database manager. Many times this is a required attribute for an application. Oracle database administrators are also expected to develop interdepartmental project management skills and be able to communicate with a wide variety of professionals, not just other engineers or information technologists.General experience in SQL systems is often a desired trait, as many times a company running Oracle will have to communicate with a company running a database system that is not Oracle. The database manager will have to know how to make the systems work together.In short, the Oracle database administrator is in high demand because of his or her technical expertise, but anyone wishing to advance their career must really learn how it affects the entire company.