AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10 years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 10gR2) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
Expert: Peter Choi Date: 6/3/2008 Subject: dba questions
Question Can one load data into multiple tables at once?
What tuning indicators can one use?
. What should you do when you find a stacktrace in the server errorlog ?
Answer HI Shanthiavari,
1. Generally, Oracle DBA perfer to load tables one at a time. While it is possible to load multiple tables at a time, this tend to decrease your database performance, thus increase the time it takes to complete loading your data.
2. Tuning Indicators. This depends what you're looking for. If you're looking to improve SELECT queries, run an EXPLAIN plan to see how efficient is your SQL. Most often than not, you may be missing an index or that your query is not efficient.
3. Stack Trace Error. Like any program, it may encounter problems from time to time. DBAs usually investigate by reviewing the log file and determining the criticality of the nature of the problem. It is critical if the database is down and no one can access it. If it is not down, then take a look at what the error message is and look it up in the Oracle manual.
