RE: ExamSheets.Net

Title: RE: ExamSheets.Net Buy it from SelfTestSoftware.com . It is official preparation software recommended by oracle and covers most of the question from the test. Brijesh -Original Message- From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] Sent: Monday, August 05, 2002 4:08 PM To:

RE: Users reading from rollback segments

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gupta, Brijesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Library Cache wait -- Who is holding this latch

Title: Message Hi All I have a session which is waiting for Library Cache latch for 6 hours. How can I find who is holding this latch. This session is executing a pl/sql script ( Not package ). Latch# 60 is library cache latch. Here is from v$session_wait 1 select * from

RE: Database Hangs -- System shows latch contentions

contentions What is in V$LATCH. If its shared pool and library cache contention I'd be tempted to: a) upgrade to 8.1.6+ where the algorithm is better b) reduce the size of your shared pool hth connor --- Gupta, Brijesh [EMAIL PROTECTED] wrote: Hi all My database almost hangs and when I

High parse to execution Ratio on database

Hi all, I am seeing very high parse/execution ratio. These statements are using bind variable. Can somebody help me understand why this is high. Database : 8.0.5 Using Oracle Application 10.7 SGA = 8.5 GB Shared pool : 1.5 GB Lately I have stated seeing the sqlarea miss and some

RE: Explain Plan different on TEST and PRODUCTION instance

click on the fixed font above the heading for the note) you should find what's causing the CBO to be used on Test. HTH, -- Anita --- Gupta, Brijesh [EMAIL PROTECTED] wrote: Hi ALL I have a query with was running fast during the test in the test instance and now when moved to production

RE: select on v$ tables

Title: RE: select on v$ tables Specific Privilege is SELECT ANY DICTIONARY . -Original Message- From: Jon Walthour [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 6:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: select on v$ tables Prasad: Grant the user

RE: temp problem when rebuilding Index

Title: RE: temp problem when rebuilding Index You can increase the SORT_AREA_SIZE for that particular session only. Alter session set SORT_AREA_SIZE= ; You don't have to change the init.ora just for rebuilding index. But if index is large , I still prefer dropping and recreating it.

Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is

RE: Why this sql is running in parallel ??

?? interesting.something is off about the query data. are the tables partitioned, by chance? -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql

RE: Why this sql is running in parallel ??

PROTECTED]] Sent: Friday, June 29, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why this sql is running in parallel ?? What does v$pq_sysstat show? What does v$pq_sesstat show? (If session is still connected). - Kirti -Original Message- From: Gupta, Brijesh [SMTP

RE: Why this sql is running in parallel ??

in parallel ?? select from parameters where is_session_adjusted is TRUE. is there anything? -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql is running

RE: Rule base optimizer selecting different execution path ( Tuni

in the code ? Does your session change the optimizer_goal at the session level by any chance ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Gupta, Brijesh" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTE

RE: ORA-09782 ORA-09783

Here is the problem . Use SET instead of REUSE CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG instead use CREATE CONTROLFILESET DATABASE "PROD" RESETLOGS ARCHIVELOG Brijesh -Original Message-From: Catherine LeBlanc [mailto:[EMAIL PROTECTED]]Sent: Sunday,

RE: WILLING_TO_WAIT_COPY 1%

Title: RE: WILLING_TO_WAIT_COPY 1% I had the same problem. Its shows 56% on 8.0.5 database. But here is a thought. When I upgraded to 8.1.6 it shows 0%. I still have one database on 8.0.5 where it shows 57% Also this parameter LOG_SIMULTANEOUS_COPIES is gone in 8.1.6 Brijesh

RE: URGENT..not importing previous export!!!!!!!!

" import the exported files after making the same structue(tablespace and users) as there were in previous install." You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old