Hi
Anyone here have the exam question breakdown for PT 8i ? It would be a great help to us if someone can post it on this thread. Thanks
Printable View
Hi
Anyone here have the exam question breakdown for PT 8i ? It would be a great help to us if someone can post it on this thread. Thanks
1. Tuning Overview (1)
2. Oracle Alert and trace files (2)
3. Utilities & Dynamic erformance Views (3)
4. Tuning the Shared Pool (7)
5. Tuning the Buffer Cache (7)
6. Tuning the Redo Log Buffer (3)
7. Database Configuratin and I/O issues (7)
8. Using Oracle Block Efficiency (4)
9. Optimizing Sort Operations (4)
10. Tuning Rollback segments (4)
11. Monitoring and Detecting Lock Contention (5)
12. SQL Issues and Tuning Considerations for (5)
Different applications
13. Managing a Mixed Workload (2)
14. Tuning with Oracle Expert (1)
15. Multithreaded server Tuning Issues (2)
http://www.dbasupport.com/forums/sho...threadid=15967
hey guys, when are you planning to take the PT test..next week?? ..or the week after ? I have to admit that there are alot of stuffs to cover here. I'm planning to take Net8 test next week (Tuesday or Weds) and probably PT test the week after. I spent about 3 or 4 nights on Net8 already and probably this weekend to review it all. I'll let you know how it turns out...any last words would be greatly appreciated. In the mean time study hard for PT guys (...poor me I've to also write the SQL and PL/SQL test as well...:) )
HI NDT & Maverick,
I was so busy for the past 2 weeks and couldn't concentrate on studies. I might start reading from tomorrow and write sometime next week.
all the best NDT, for Net admn.
GD_1976
Yep me too. I was going to write next week but decided I needed more time to concentrate. Lots and lots of views to look at. Makes ya dizzy!!!!
Yup, same here! i also planned to take the exam next thursday, but decided to move my exam the following week.
i have been reading for almost a week now, And there are lots of views, columns and row values to remember. im not really good in memorization so i think another week of preparation wont hurt.
Good luck NDT!
gd_1976 & Rookie i hope we can have more discussion on this thread. Ill try to look for sample questions. i hope you guys could also help. Thanks
Guys, i copied some practice questions from a previous thread.
http://dbasupport.com/forums/showthr...8&pagenumber=7
i hope we can help each other out by posting our answers. Thanks.
1. The most useful measure of database buffer cache performance is ______.
a. Consistent gets
b. Free buffer inspected
c. Buffer busy rates
d. Latch free
e. Cache hit ratio
f. Physical reads
2. To issue an alter system kill session statement, which two values would you retrieve from V$SESSION?
a. SID
b. PROCESS ID
c. USER_NAME
d. SESSION NAME
e. SERIAL#
3. In the analysis report generated by Oracle Expert for a tuning session, what information is included?
a. Recommendations.
b. All collected data to be analyzed.
c. Detailed information about the collected data in the repository for a tuning session.
d. Listing of all attributes for the instance for which you want tuning recommendations to be generated.
4. You suspect redo latch contention in the PROD instance and query V$LATCH and V$LATCHNAME to obtain statistics. The ideal percentage of latch contention time should be ______.
a. Less than 1%
b. Less than 5%
c. Less than 10%
d. Less than 90%
5. Given the following:
DB_BLOCK_LRU_EXTENDED_STATISTICS
What is the purpose of this parameter?
a. Increase the number of blocks in the database buffer cache.
b. Compute the cache hit ratio.
c. Allow evaluation of the effect of increasing the size of the buffers in the database buffer cache.
d. Allow evaluation of the effect of adding buffers to the database buffer cache.
6. Where are temporary segments created if a temporary table space is not specified for users?
a. RBS table space
b. SYSTEM table space
c. USERS table space
d. TEMP table space
e. INDEX table space
7. What is the minimum number of extends required in a rollback segment?
a. 1
b. 2
c. 5
d. 20
e. 100
8. Users are reporting slow response time on your system. You think that the problem can be solved by increasing the size database buffer cache. But you want to make sure your solution is correct. Which two steps are necessary to evaluate the impact of adding buffers to database buffer cache?
a. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS to the number of buffers you want to add.
b. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS=True.
c. Query the V$RECENT_BUCKET view.
d. Query V$FILESTAT.
9. You suspect there is I/O contention with the log files. Which view would you query for confirmation?
a. V$LOG_HISTORY
b. V$LOGFILE
c. V$SYSTEM_EVENT
d. V$ARCHIEVE
10. You are monitoring rollback segment usage for the PROD database to determine if you need to add additional rollback segments. Frequent queries of V$WAITSTAT during normal processing hours indicates an average value of 115 for the undo header column. What does the average value of this column indicate to you?
a. Rollback segment header blocks are being used efficiently.
b. Rollback segments are sized too large.
c. The largest rollback segment for the prod database is too small for normal transaction processing.
d. Contention exists for rollback segment header blocks in the transaction table.
11. Trace files for deadlock situations are recorded where?
a. USER_DUMP_DEST
b. BACKGROUND_DUMP_DEST
c. CORE_DUMP_DEST
d. TRACE_DUMP_DEST
12. When creating temporary table space, which two storage parameters should be set as integer multiples of SORT_AREA_SIZE?
a. MAXEXTENTS
b. INITIAL
c. NEXT
d. MINEXTENTS
e. OPTIMAL
13. When will the change to a storage parameter be used if you are changing the storage parameter for the EMP table by setting PCTUSED to 250?
a. Immediately
b. When the further queries are made on the table
c. When future DML activity occurs on the table
d. When the database is shut down and restarted
14. In your efforts to improve performance you altered several frequently accessed small tables with the CACHE clause. To prevent over-crowding in the buffer cache, which initialization parameter you can set?
a. CACHE_THRESHOLD
b. DB_BLOCK_BUFFERS
c. DB_BUFFER_CACHE
d. CACAHE_SIZE_THRESHOLD
15. The alert log file contains which type of information?
a. Default initialization parameter
b. Messages and errors
c. Name and location of all databases
d. SQL statement error messages generated by applications
16. The database includes tables with static data that are used for queries only. For this type of table to which size should you set PCTFREE?
a. 0
b. 10
c. 20
d. 50
17. When are packages loaded into library cache?
a. At instance startup
b. After all parts of the package have been accessed
c. As soon as any part of them is accessed
d. When an application using the packet is started
18. You have just implemented the new financials application and want to track usage of various modules. To track the usage of modules in the application, what should be used?
a. TKPROF
b. SQL* trace
c. EXPLAIN plan
d. ANALYZE
e. DBMS_APPLICATION_INFO
19. You have been asked to develop a tuning plan for an application that has been in production for a year. Your most important tuning goal should be to ______.
a. Tune the internal database structure so that you can see performance improvements.
b. Tune all elements necessary for users to see noticeable performance improvements.
c. Tune the database so that you can perform backups more quickly.
d. Reorganize the data files on the system to take advantage of available disk space.
20. Payroll application users are complaining about the length of time it takes to run the earnings calculation program, you have enabled tracing for this process and trace is now complete. To format information about the execution of the SQL statements for the process, what should be used?
a. SQL Plus Trace.
b. EXPLAIN
c. DBMS_APPLICATION_INFO
d. ANALYZE
21. To find out how a statement would be executed if you ran it at a particular moment what, what should be used in SQL*Plus?
a. TKPROF
b. SQL*TRACE
c. ANALIZE
d. EXPLAIN
22. You query INDEX_STAT because you suspect there is a problem with the ACCT_NO_IDX index. What information is returned?
a. Information about the current state of all indexes
b. Information about the current state of an index
c. Information about the index from the time of creation
d. Information from the last analyze index validate structure command issued
23. Performance for queries in your decision support system has degraded and you decide to create indexes for the relevant tables. The queries usually involve multiple predicates on a low cardinality column and tables are read only. Which index type should you create?
a. B-tree
b. Reverse key
c. Bit mapped
d. Concatenate
24. You have created keep, recycle and default buffer pools for the PROD instance. However when you start up the instance an error occurs and the database is not mounted. What could cause this?
a. Total allocation to the buffer pools has exceeded the allocation to the PGA.
b. Multiple buffer pools can only be created when a database is created.
c. Total allocation to the buffer pools is less than the value for DB_BLOCK_BUFFER.
d. Total allocation to the buffer pools has exceeded the DB_BLOCK_BUFFER and /or DB_BLOCK_LRU_LATCHES parameters.
25. Your company is planning to design and implement a custom payroll application. During this proces,s at which time is it most important for performance to be addressed?
a. Design
b. Testing
c. Application development
d. Production
26. What should you use as a sizing guideline when creating a recycle buffer pool?
a. It should be large enough to retain blocks for the duration of a session.
b. It should be large enough to retain blocks for the duration of the application process.
c. It should be large enough to retain blocks for the duration of all sessions.
d. It should be large enough to retain blocks for the duration of a transaction
27. You have determined that row migration is occurring for several tables in the PROD database. To prevent further migration for the involved tables and any other tables where you do not want this to occur, which storage parameter can you set?
a. PCTFREE
b. PCTUSED
c. MINEXTENTS
d. MAXEXTENT
28. What will a trace file contain if you have enabled SQL Tracing at the session level?
a. Statistics for buffer usage for the instance
b. Statistics for all processes during that time
c. Statistics for the user application process
d. Statistics for SQL statements for the session
29. You created a test database recently. You think you may not have made the redolog buffer large enough. Which view should be queried to see if waits are occurring for the event log buffer space?
a. V$PROCESS
b. V$ROWSTAT
c. V$TRANSACTION
d. V$WAITSTAT
e. V$ SYSTEM_EVENT
30. You are performing a direct load to the TEMP_DATATABLE using SQL*Loader. You issue this command prior to the task, ALTER TABLE temp_date NOLOGGING; which task is accomplished?
a. Redo log entries will not be generated for the load to the temp_data table.
b. Redo log entries will be generated but will not be archived for the load to temp_data.
c. Redo log entries will not be archived until the load to the temp_data table is complete.
d. Log entries will not be generated until the load to the temp_data table is complete.
Thanks Maverick. I haven't found any other questions yet.
Been trying to study some more. I am using examcram and Sybex as well as my ILT book. I hate Oracle's ILT book. It leaves out quite alot of detail that you'll likely need on the exam.
Guys, how's everybody doing, ready for Tuning?? well, took and passed Network Admin today (51/59)- thought i did better but...oh well, i'm quite happy with the results actually.
The test itself is not tough, it was very straight forward actually. Use the tips from Gee (thanx Gee!!), those are helpful. Concentrate a little time on the definition of connect descriptor and service name, also note that you cannot disable logging on client and Name servers. It's also true that you cannot turnoff audit trail for the listeners. Overall, the test is easy. I spent about 3-4 days ( about 15 hrs in total ) to prep for it. I would recommend that you guys spend about a week so that you have to cover it in details. Good luck guys...For me, Tuning is next on the menu. Thanks
HI NDT,
Congrats and Thanks for giving us some insights on the Net Admin exam
All the best for PT.
I am writing my PT exam on 21st November.
This threads are actually very useful for PT.
http://www.dbasupport.com/forums/sho...threadid=10940
http://www.dbasupport.com/forums/sho...threadid=10616
http://www.dbasupport.com/forums/sho...threadid=11772
Thanks
GD_1976