HI Maverick and NDT,
I am just starting it now and would like you and all the other guys to join and share the knowledge
Hope this will be like B & R.
All the best.
Gd_1976
Printable View
HI Maverick and NDT,
I am just starting it now and would like you and all the other guys to join and share the knowledge
Hope this will be like B & R.
All the best.
Gd_1976
Well... I'll hang around here to have a look at some questions being asked. I'm going to try and FOCUS and remember what the questions were like when I sat it.... hmmmmm. Back later.
Alright Maverick, let me do some studying before you post the real questions :) ...make sure that you post it before I do the test j/k...
ok guys, I heard PT is the hardest of the five so study hard guys we did it before, we should do it again. Good luck everyone
Admittely PT is harder than Backup and Recovery... but I don't think it's as hard as Admin and Arch. I used primarily the Sybex text for this one. It is VERY WELL written for 8i.
hahaha =) If i can another set of those for Tuning, sure! Ill post it for you guys. But for now, its review time for me. see ya tomorrow!Quote:
Originally posted by NDT
let me do some studying before you post the real questions :) ...make sure that you post it before I do the test j/k...
The Maverick signing in.
Welcome Maverick.
GD_1976.
Hello!
What study guide will you be using? Ill be using the Student Guide and Sybex.
Yep Me TOO!!! I am going to be using Sybex along with the ILT book to study for Performance Tuning. Couchman's book I am not so sure about. They always have too many errors.
Yep, the SYBEX book for this one is a great option.
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
Congratulations NDT!!!
:) how's everybody doing with Tuning Prep?
Still studying...but getting there. I want one more week to look it over...planned to write the last week of Nov.
HI NDT,, Maverick & all,
I just started today and completed 1 unit.i was very busy in work as well as at home for the past 2 weeks. but +vely writing on November 21st. I Just want all of you to be aware
of that if you use "OPP" promotional code , you get 35% discount.
Rookie,
"PT Cruiser" is a nice one.
Thanks.
Gd_1976
Guys,
Im still studying, there are lots of v$ views & other stuff to remember. The subject is quite easy to understand, but the question is "how well you can remember all the views and parameters (even values) in checking for contention and tuning the different areas"
I started my review about 2 weeks ago, and ill propabably give it another week. I might take the test this coming Thursday (tentative).
I hope there will be more information sharing in this thread. Thanks!
Good Luck everybody who plans to write pt this week. I am doing the 8 track so the mark is higher. It doesn't leave too much room for error. I hate those views !!! Sysstat or Sesstat!!! or is it Session_wait????
LOL! Same here. It also drives me nuts to remember those performance views.Quote:
Originally posted by Rookie
I hate those views !!! Sysstat or Sesstat!!! or is it Session_wait????
Ill be taking the exam this coming thursday (November 22), after almost a month of preparation. im really looking forward to pass this exam.
[Edited by D Maverick on 11-19-2001 at 10:29 AM]
Hm it´s not that hard to remember sysstat, sesstat, system_event, session_event, session_wait, I think the trick may be
views with *SYS* talsk about cumulative, *SES* talks about individual sessions
session_wait is the real time waits
Anyway the STS questions I have seen for perfomance tuning exam is not that complicated, actually, probably only 50% of exam is relevant in real tuning.... well thass my opinion =)
There is a free e-seminar on http://www.oracle.com/education/oln about understanding bstat and estat report, may be that could help
[Edited by pando on 11-19-2001 at 10:35 AM]
Thanks Pando!
I also have the same opinion. The exam is quite basic and one might have problems with it, only if he has never tuned a database.Quote:
Anyway the STS questions I have seen for perfomance tuning exam is not that complicated, actually, probably only 50% of exam is relevant in real tuning.... well thass my opinion =)
I agree with you one hundred percent. I have never tuned or seen a true Oracle Database running in the RealWorld. That's why I am a Rookie. (new to the field). But there doesn't seem to be too many Oracle DBA's that are willing to show new people to the field what Oracle truly looks like whereas MCSE's they talk and share stuff all the time.
So in the real world do you actually use Oracle Expert. From the books its looks like a pretty good tool to have around?
No, I do not use it. I have my own scripts and by now, I know what to check for. In the books, utlbstat/utlestat is also overrated.Quote:
So in the real world do you actually use Oracle Expert. From the books its looks like a pretty good tool to have around?
Dunno, used Oracle Expert once and I think it's really crap (specially the index wizard), I think nothing is better than customized scripts, statspack is pretty good as well, then ultbstat and utlestat.. Oracle Expert pffft I dont think peeps in Oracle Support use them neither
Customzied scripts simply takes too much time to do the reasearch on tuning... good but takes ages
And using Oracle Expert you wont be able to understand the tuning concepts, again my opinion :o
Never needed Oracle Expert, probably never will.
If you have a fundamental understanding of the database and how it works, you will not need a GUI for performance tuning. bstat/estat were good in 7, and statspack is pretty good for 8i.
Thought so -oracle expert tool reminds me of a lazy dba concept.
I did not read the entire chapter for Oracle Expert. i personally feel that it's a waste of time.
its a good thing only 1 question on Oracle Exams was included in the exam. of course i missed the answer. =)
I remember that the 1 question about Oracle Expert was very, very basic. Something like: If you wanna tune Oracle using a GUI, you would use:Quote:
Originally posted by D Maverick
I did not read the entire chapter for Oracle Expert. i personally feel that it's a waste of time.
its a good thing only 1 question on Oracle Exams was included in the exam. of course i missed the answer. =)
1. Oracle Expert
2. Oracle Wizard
3. Tuning Expert
4. Tuning Wizard
:-))
The question that i encountered for Oracle Expert goes something like:
What types of analysis can be performed on Oracle Expert, choose three (something like that)
A. Structure
B. User
C. Process
E. Instance
D. Schema
Tough luck, since its hard to guess 3 of 5. =)
Thats a pretty tough question even if you've studied the Oracle Expert. I automatically picked two but the third I really had to look at:
The answers are: Schema, Instance and Structure. I almost went for User as a distractor.
This is a tough, meaningless question .-)Quote:
Originally posted by Rookie
Thats a pretty tough question even if you've studied the Oracle Expert. I automatically picked two but the third I really had to look at:
The answers are: Schema, Instance and Structure. I almost went for User as a distractor.