call procedure from htp.formopen in oracle portal
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 advance Alvaro Quintero -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wait Event Calculation
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-for.html for details, including a specific case we've solved with 10046 data that was exactly the "not enough CPU/memory" case. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Sent: Saturday, June 15, 2002 7:18 AM To: Multiple recipients of list ORACLE-L 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 the background processes). Then you should consider a couple of events like: SQL*net message from client pipe get etc. Session level The only thing to consider here is the wait events listed before. Now we have the big BUT: What about waits that are not accounted for ? Like OS waits (waiting for a memory page, waiting for CPU, etc). How can you see them ? And how do know where the problem is ? So you will get a level of detail that will contain errors/holes. And as long as the holes are not big enough, it doesn't matter. But what if you are really running out of CPU ? The hole will get bigger and your wait events don't really matter that much. I will make a list of idle events available through oraperf.com. That list is used by the report generator also. Anjo. Erik Williams wrote: > I am trying to break the response time of my system into the wait and > service times. I am able to determine the service time by the "CPU used by > this session" line in the statspack report. The wait time I am having > trouble with. I am working from the 'Yet Another Performance Profiling > Method' document. The document lists a number of events that should not be > included in the calculation because they are caused by background process > waits. I am tuning an 8.1.6 databases and want to be sure I am only counting > the appropriate events in this calculation. How can I get the list of events > to include for my version of the database (the doc is quite old)? > > Thanks > Erik > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Erik Williams > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORCL stock is down...
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 DB2 and SQL*Server.All of these tech and biotech companies probably have another 3 to 9 months before their stock prices bottom and another 1 to 2 years before you see them rise again.I have been shorting stocks like ORCL CSCO JDSU JNPR and all the rest of them for a couple years now and the pay off has been good. I you want to buy a stock, stick with stocks that have good fundamentals in a bull market. At the present time there are not to many of those and we are NOT in a bull market. Save your money.\ Mike -Original Message- Sent: Wednesday, May 01, 2002 11:34 AM To: Multiple recipients of list ORACLE-L OFF TOPIC... Oracle stock is down 11% today. What gives? Over-reaction to executive departures and decreased revenues? Is it a good time to invest? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SAN - Oracle - Pitfalls - Adv/Disadvantages??
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 affect me as DBA. Also we are thinking about how we >can use OS level block replication between two database servers located in different >cities(SF and LA). > > any suggestion about pitfalls? > > TIA > Mandar > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandar A. Ghosalkar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wait Event Calculation
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 the background processes). Then you should consider a couple of events like: SQL*net message from client pipe get etc. Session level The only thing to consider here is the wait events listed before. Now we have the big BUT: What about waits that are not accounted for ? Like OS waits (waiting for a memory page, waiting for CPU, etc). How can you see them ? And how do know where the problem is ? So you will get a level of detail that will contain errors/holes. And as long as the holes are not big enough, it doesn't matter. But what if you are really running out of CPU ? The hole will get bigger and your wait events don't really matter that much. I will make a list of idle events available through oraperf.com. That list is used by the report generator also. Anjo. Erik Williams wrote: > I am trying to break the response time of my system into the wait and > service times. I am able to determine the service time by the "CPU used by > this session" line in the statspack report. The wait time I am having > trouble with. I am working from the 'Yet Another Performance Profiling > Method' document. The document lists a number of events that should not be > included in the calculation because they are caused by background process > waits. I am tuning an 8.1.6 databases and want to be sure I am only counting > the appropriate events in this calculation. How can I get the list of events > to include for my version of the database (the doc is quite old)? > > Thanks > Erik > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Erik Williams > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot connect to DB error
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: Cannot connect to DB error > > > Joe: > > Good question. I checked services and it was not running. > So I started it. But I still get these errors. > > PARTS database - ORA-12541: TNS: no listener > > KEN database - ORA-12154: TNS: could not resolve service name. > > Any idea what the problem is? > > Thanks, > Ken > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, June 13, 2002 8:03 PM > > > > ok i'll ask the obvious, is the listener running? > > if so you better go and catch it. > > > > joe > > > > > > KENNETH JANUSZ wrote: > > > > > I have installed 9.0.1 on my Dell PC with XP Prof. > > > > > > > > > > > > When I installed it I installed the demo DB and everything worked > > > fine. Now I have installed a second DB and I cannot connect. I > > > made changes to listener.ora and tnsnames.ora as recommended by > > > others on this list. > > > > > > > > > > > > I also added the IP addresses to the HOSTS file as such: > > > > > > 127.0.0.1localhost (original entry) > > > > > > 127.0.0.1DC0X4411 (Oracle generated name for KEN db > manually added) > > > > > > 127.0.0.1PARTS (new DB name manually added) > > > > > > > > > > > > Here is what I get when I try to connect. > > > > > > > > > > > > KEN database - Oracle generated name is DC0X4411 > > > > > > ORA-12154: TNS: could not resolve service name > > > > > > > > > > > > PARTS database > > > > > > ORA-12541: TNS: no listener > > > > > > > > > > > > Any help I can get to solve this problem will be greatly > > > appreciated. > > > > > > > > > > > > Thanks much, > > > > > > Ken Janusz, CPIM > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joe Testa > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may > also send > > the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: KENNETH JANUSZ > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Message logging in stored procedures
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 features in the newer Oracles to support this requirement? > > TIA > Autonomous transactions. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Extremely slow query
"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 the system. > > I'm attempting to run the query below. (Got it from Metalink.) This script > takes 3 to 4 minutes to run (regardless of whether it returns any rows). > The same script runs in less than 1 second on the test database on the same > box, as well as other databases on different Solaris and VMS databases. > > This is particularly curious. Thought I'd run an explain plan for grins. > The explain plan is identical on this database as on the others. However, > there's a 3 to 4 minute wait before the explain plan shows up. (It's > instantaneous on other databases.) In other words, if I type in "set > autotrace traceonly explain" and then @find_locks, the explain plan does not > appear for several minutes. > > I'm not sure where to start looking. My other health/status scripts run in > normal amounts of time. It's only this 1 script that's a difficulty. > > Any ideas? I'm not sure where to start looking. I'm certainly curious to > know if this is in any way related to other problems we're having with this > database, but I don't see the connection. > > Thanks for any help. > > Barb > > SET ECHO off > REM NAME: TFSLKILL.SQL > REM USAGE:"@path/tfslkill" > > set linesize 132 pagesize 66 > break on Kill on username on terminal > column Kill heading 'Kill|String' format a9 > column res heading 'Resource Type' format 999 > column id1 format 990 > column id2 format 990 > column lmode heading 'Lock Held' format a20 > column request heading 'Lock|Requested' format a10 > column serial# format 9 > column username format a8 heading "Username" > column terminal heading Term format a7 > column tab format a21 heading "Table Name" > column owner format a9 > column Address format a18 > select nvl(S.USERNAME,'Internal') username, > nvl(S.TERMINAL,'None') terminal, > L.SID||','||S.SERIAL# Kill, > U1.NAME||'.'||substr(T1.NAME,1,20) tab, > decode(L.LMODE,1,'No Lock', > 2,'Row Share', > 3,'Row Exclusive', > 4,'Share', > 5,'Share Row Exclusive', > 6,'Exclusive',null) lmode, > decode(L.REQUEST,1,'No Lock', > 2,'Row Share', > 3,'Row Exclusive', > 4,'Share', > 5,'Share Row Exclusive', > 6,'Exclusive',null) request > fromV$LOCK L, > V$SESSION S, > SYS.USER$ U1, > SYS.OBJ$ T1 > where L.SID = S.SID > and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2) > and U1.USER# = T1.OWNER# > and S.TYPE != 'BACKGROUND' > order by 1,2,5 > ; > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=154 Card=6698 Bytes= > 1024794) >10 SORT (ORDER BY) (Cost=154 Card=6698 Bytes=1024794) >21 NESTED LOOPS (Cost=1 Card=6698 Bytes=1024794) >32 NESTED LOOPS (Cost=1 Card=82 Bytes=10086) >43 NESTED LOOPS (Cost=7 Card=1 Bytes=80) >54 NESTED LOOPS (Cost=6 Card=1 Bytes=60) >65 NESTED LOOPS (Cost=2 Card=1 Bytes=40) >76 FIXED TABLE (FULL) OF 'X$KSUSE' (Cost=1 Card=1 > Bytes=20) >86 FIXED TABLE (FIXED INDEX #1) OF 'X$KSUSE' (Cost=1 > Card=1 Bytes=20) >95 VIEW OF 'GV$_LOCK' > 109 UNION-ALL > 11 10 VIEW OF 'GV$_LOCK1' (Cost=2 Card=2 Bytes=40) > 12 11 UNION-ALL > 13 12 FIXED TABLE (FULL) OF 'X$KDNSSF' (Cost=1 > Card=1 Bytes=20) > 14 12 FIXED TABLE (FULL) OF 'X$KSQEQ' (Cost=1 > Card=1 Bytes=20) > 15 10 FIXED TABLE (FULL) OF 'X$KTADM' (Cost=1 Card=1 > Bytes=20) > 16 10 FIXED TABLE (FULL) OF 'X$KTCXB' (Cost=1 Card=1 > Bytes=20) > 174 FIXED TABLE (FIXED INDEX #1) OF 'X$KSQRS' (Cost=1 > Card=100 Bytes=2000) > 183 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' (Cost=1 Card=8168 > Bytes=351224) > 19 18 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) > 202 TABLE ACCESS (CLUSTER) OF 'USER$' (Cost=1 Card=8168 > Bytes=245040) > 21 20 INDEX (UNIQUE SCAN) OF 'I_USER#' (CLUSTER) > Barbara, Queries on V$ views (and the underlying X$ tables) are not very easy to tune, because they operate on memory structures, very volatile information, that the optimizer proceeds by guesswork (no stats) and that it doesn't necessarily do a good job at it. Add to this that looking deep inside the database puts yourself in a p
RE: Strange Bug
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 To: Multiple recipients of list ORACLE-L Subject: RE: Strange Bug Not actualy, The data already exists but not retreived till i recreate the table with same data. When I rebuild table the correct data will be retreived. Few tables always corrupted for no reason!!! -Original Message- Sent: Friday, June 14, 2002 10:41 AM To: Multiple recipients of list ORACLE-L Are you executing two sql's from two different sessinons . Because it may happen that you might not have commited the records you inserted in tableA , as soon as you create a temp table oracle does commit by itself and you start finding records . Can you try issuing a commit and then doing select on tableA without creating temp table. -Bp - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 5:28 PM > List, > > I have a table when I run a query on this table return nothing(no record > returns!!!), but when I create a temp table from this table return the > records > E.G: > > select cola,colb,colc from tableA where cola=1 and colb='A' > 0 records return > > Now: create table a_temp as select * from tableA > then > > select cola,colb,colc from tableA where cola=1 and colb='A' > > cola colb colc > 1 A xx > 1 A > 1 A mmm > > Any Idea? what's wrong and what's cause a problem? > I appreciate any recommendation. > > > > > Hamid Alavi > Office 818 737-0526 > Cell 818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from