SQL*Loader is a database tool that allows to load data from external files into database tables. SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting features as:
► Can load data from multiple data files into multiple tables in one load session.
► Can specify character set of the data.
► Can generate sophisticated error reports.
► Can load data directly to Oracle datafiles, bypassing normal record inserting process.
A DBA had to remove some Archivelogs to free up space in filesystem. Now when the RMAN job starts to backup Archivelogs, it complains about missing Archivelogs that were deleted by DBA. To resolve the issue and continue backing up remainder of Archivelogs, which RMAN command can be used so it wo not complain about missing Archivelogs.
Which RMAN command is used to create an exact replica of a database in new host?
How do you install Statspack?
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in order to improve the performance?)
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?
List five most important parameter in 9i affecting performance?
What is PGA_AGGREGATE_TARGET?
How do you analyze table partition using Oracle provided package?
You see a wait on LMS process in statspack, what does that mean?
Explain procedure to Change CHARACTERSET of a database.
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
