RE: Strange Bug

2002-06-15 Thread Amar Kumar Padhi
Title: RE: Strange Bug Just a thought... check for FGAC (Fine grain access control). May be there is a data level restriction put on the user. rgds amar http://amzone.netfirms.com -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 11:15 PM

Re: Extremely slow query

2002-06-15 Thread Stephane Faroult
"Baker, Barbara" wrote: > > > * Solaris 2.6 > > * Oracle RDBMS v8.0.5.2.1 > > > List: > We are (still) having difficult with a production database. (Users > experiencing severe slowness at times.) I'm constructing a series of > queries to run at intervals to check the health/status of th

Re: Message logging in stored procedures

2002-06-15 Thread Stephane Faroult
Robert Monical wrote: > > Hello, > > Finally moving from Oracle 7 to 8 or 9 (probably 9). > > We currently use DBMS_PIPE and a scheduled job to empty the pipe and store > the messages. > Works fine in our application but I need to eventually make some improvements. > > Are there any new featu

RE: Cannot connect to DB error

2002-06-15 Thread BELOV
cat $ORACLE_HOME/network/admin/listener.ora cat $ORACLE_HOME/network/admin/tnsnames.ora and mail to list, will see > -Original Message- > From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 6:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Canno

Re: Wait Event Calculation

2002-06-15 Thread Anjo Kolk
Erik, The doc may be old but the method still stands ;-) You can dice and slice the wait events in anyway you want. But basically what you are interested in is the wait events for the foreground (system wide), so you do some thing like this: System wide: v$system_event - (v$session_event for

Re: SAN - Oracle - Pitfalls - Adv/Disadvantages??

2002-06-15 Thread Anjo Kolk
James Morle wrote a paper about this called Sane SAN. You can download it from www.oraperf.com. Anjo. "Mandar A. Ghosalkar" wrote: > Hello Guys, > > any guys here who have SAN. We are inviting a SAN vendor for possible solutions for >our enterprise. > > i am unaware about how SAN would affec

RE: ORCL stock is down...

2002-06-15 Thread Johnson, Michael
I invest in stocks all the time .. long and short. I would not touch Oracle stock with a 10 foot pole. The company has major problems , excesses that need to be worked off and cleaned out, a business plan that is outdated, and MSFT and IBM are now starting to cut into Oracle's market share with DB

RE: Wait Event Calculation

2002-06-15 Thread Cary Millsap
Erik, You can detect all the unaccounted-for time in 10046 data (and v$ data too, but not nearly so easily). It turns out that the ability to measure this "gap" is exactly what you need to positively identify the types of problems you've described. See www.hotsos.com/dnloads/1/kevents/unaccounted

call procedure from htp.formopen in oracle portal

2002-06-15 Thread AlvQn
Hi I need to call a procedure that his name is login. this procedure open a new page I read in the documentation that the way was htp.formopen('schema.login'), but it doesn't works. What can i do?, I need create a form for procedure login?, I can't call this procedure only?. Thanks in adv