Dear Karthi, If you need other than metalink solution, I wish it will be good to explain the reason, because otherwise it looks like you do not have access to metalink or the product license and this type of support will come under ILLEGAL support. Professionals on this forum must avoid such a practice to defend the product and other professionals and profession. If you do such practice it will bite you. > Nisar Tareen karthi keyan <puni_kar@xxxxxxxxx> wrote: Hi all, I need patch for redHat AS3.0 for oracle 18.104.22.168 please give any link other than oracle metalink Karthikeyan --- dba_gurus@xxxxxxxxxxxxxxx wrote: > > There are 23 messages in this issue. > > Topics in this digest: > > 1. 1z0-033 doubts-urgent! > From: "Roshini M." <reach_rosh@xxxxxxxxx> > 2. rply wth QUERY TO WSTIMATE ACTUAL SIZE OF > DATABASE > From: amit vaghela > <vaghela_dba@xxxxxxxxxxx> > 3. export dump with last 7 days data > From: srikant76 > 4. Cleaning Shared Memory area > From: raj aggarwal > <raz_forever@xxxxxxxxx> > 5. (disc.) Helping each other survive in > Silicon Valley: Part 2 > From: Charles Jo <cjo@xxxxxxxxxxxxxxxxxx> > 6. hi gurus > From: Ananth Antony > <ananth_a_75@xxxxxxxxx> > 7. Exciting Opening with an IT Giant in > Chennai > From: "singhsagarsk" > <singhsagarsk@xxxxxxxxx> > 8. Re: export dump with last 7 days data > From: "gitesh" <giteshtrivedi@xxxxxxxxx> > 9. Doubt > From: Kannan P <kannanlp@xxxxxxxxx> > 10. RE: hi gurus > From: "Justin Cave \(DDBC\)" > <jcave@xxxxxxxxxxx> > 11. RE: export dump with last 7 days data > From: "Justin Cave \(DDBC\)" > <jcave@xxxxxxxxxxx> > 12. Re: rply wth QUERY TO WSTIMATE ACTUAL SIZE > OF DATABASE > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 13. Re: export dump with last 7 days data > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 14. Re: Cleaning Shared Memory area > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 15. Re: hi gurus > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 16. Re: Doubt > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 17. Re: Cleaning Shared Memory area > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 18. Urgent: Network, Wireless, Optical > Professionals in SEI CMM 5 Company - Chennai > From: "Network: Telecom: Wireless" > <jobs@xxxxxxxx> > 19. index problem > From: Laly <lspel@xxxxxxxxx> > 20. doubts > From: "Roshini M." <reach_rosh@xxxxxxxxx> > 21. RE: help related recovery > From: "Gopinath Murali" > <gopinath.murali@xxxxxxxxxx> > 22. Re: Doubt > From: Sunil Bhola <oraclebhola@xxxxxxxxx> > 23. Re:restore table > From: madhavi latha > <madhavilatha99@xxxxxxxxx> > > > ________________________________________________________________________ > ________________________________________________________________________ > > Message: 1 > Date: Mon, 7 Feb 2005 19:49:23 -0800 (PST) > From: "Roshini M." <reach_rosh@xxxxxxxxx> > Subject: 1z0-033 doubts-urgent! > > Hi all, > HAve some doubts in the last OCP exam.Please help! > > > 37.Which two statements about row migration are > true? (Choose two) > A. Row migration is caused by a PCTREE value set too > low. > B. Row migration can be resolved using the ANALYZE > command. > C. Row migration can be reduced by choosing a larger > block size. > D. Row migration means that row pieces are stored in > different blocks. > E. Queries that use an index to select migrated rows > perform additional I/O. > Is A,B correct or A,E. > 84. Which statement about the LOG_BUFFER > initialization parameter is true? > > A. The LOG_BUFFER parameter can be changed > dynamically. > B. The minimum value for the LOG_FILE parameter is > 512KB. > C. The LOG_BUFFER parameter value must be a multiple > of the database block size. > D. The LOG_BUFFER parameter value must be a multiple > of the operating system block size. > 186. Which two statements are true regarding the use > of DB_CACHE_ADVICE init.ora parameter? (Choose two) > A. Setting the parameter to READY reserves space in > the buffer cache to store information about > different buffer cache sizes, but no CPU overhead is > incurred. > B. Setting the parameter to READY reserves space in > the shared pool to store information about different > buffer cache sizes, but no CPU overhead is incurred. > > C. Setting the parameter to ON reserves space in the > buffer cache to store information about different > buffer cache sizes, and CPU overhead is incurred as > statistics are collected. > D. The V$DB_CACHE_ADVICE view contains information > that predicts the estimated number of physical reads > for different cache sizes for each buffer cache > setup in the SGA. > IS there any CPU overhead when the mode is set to > "Ready"? > > 188. You are considering Operating System striping > for your tablespaces. Which two statements are true? > (Choose two) > A. The stripe is dependent on the Oracle block size. > > B. Controller based striping will usually perform > better than O/S based striping. > C. O/S based striping will usually perform better > than controller bases striping. > D. You should choose a stripe size that will give > you one physical read for each Oracle server read. > > QUESTION NO: 189 > While you were on vacation, several new applications > were added to a database that you manage. > Another DBA did his best to tune the database while > you were gone, and increased the buffer cache > hit ratio from 85 percent to 94 percent after > increasing the size of the DB_CACHE_SIZE from 96 MB > to 128 MB. > As a result, the size of the SGA is now 256 MB, > which is the maximum amount of memory that can be > allocated for this database. You have set the > init.ora parameter SGA_MAX_SIZE = 256 MB to meet > that restriction. In addition, the init.ora > parameter SHARED_POOL_SIZE is set to 48 MB. > Your problem is that the OLTP applications are not > performing with their normal 3-second response > time as they did in the past. > What can you do to try to get the response time for > OLTP applications to less than three seconds? > A. Check the buffer cache hit ratio to make sure > that it is greater than 95 percent. > If it is not greater than 95 percent, decrease the > SHARED_POOL_SIZE to 32 MB and allocate the > remaining 16 MB to the buffer cache by setting the > DB_CACHE_SIZE parameter to 144 MB. > B. Check that the percentage of misses in the entire > data dictionary cache is less than two percent by > querying the V$ROWCACHE view. > If it is not less than two percent, then decrease > the DB_CACHE_SIZE to 112 MB and allocate the > remaining 16 MB to the shared pool by setting the > init.ora parameter SHARED_POOL_SIZE to 64 > MB. > C. Query the V$LIBRARYCACHE view to obtain the > number of RELOADS and PINS that have taken > place. > If the number of reloads is greater than 1 percent > of the pins, de-allocate 16 MB from the buffer > cache by setting the DB_CACHE_SIZE parameter to 112 > MB and add the 16 MB to the shared pool > by setting the init.ora parameter SHARED_POOL_SIZE > to 64 MB. > D. Query the V$LIBRARYCACHE view and look at the > GETHITRATIO column. > If the GETHITRATIO is less than 99 percent for the > SQL AREA namespace, de-allocate 16 MB from the > buffer cache by setting the DB_CACHE_SIZE parameter > to 112 MB and add the 16 MB to > the shared pool by setting the init.ora parameter > SHARED_POOL_SIZE to 64 MB. > QUESTION NO: 192 > To minimize fragmentation of your shared pool space, > when is the best time for you to pin objects > with the DBMS_SHARED_POOL package? > A. When the object is used for the first time. > B. At instance startup; load the object into memory > and pin it. > C. Immediately after instance startup, before > loading anything into memory. > D. When the V$LIBRARYCACHE view contains higher > values in the RELOADS column than in the > PINS column. > E. When the sum of values in the SHARABLE_MEMORY > column of the V$DB_OBJECT_CACHE > view exceeds the value of the SHARED_POOL_SIZE > initialization === message truncated === ===== C.Karthikeyan, Senior Lecturer,School of Computing,SASTRA Deemed University, Tirumalaisamudram,Tanjavur-613402. Ph:91-4362-264101&102,Extn:266&112. Resi:3A,Kalyanam Nagar,Municipal Colony,Tanjavur-613 007.INDIA. ph:91-4362-247056. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups SponsorADVERTISEMENT document.write(''); --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/dba_gurus/ To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@xxxxxxxxxxxxxxx Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'