[no subject]
HELP
[no subject]
Hi, Well, since I can't sleep, I may as well try solving a problem. This is a bit odd, and I'm trying to think of the most efficient way to do it. I've set up some bitmaps in my app. Consider we have documents that we want to sell. In order to be able to sell a given doc, we need to have it stored in the vault and we also need to have negotiated the proper contract w/ the publisher. So, I've got two bitmaps, STORAGE and PERMISSIONS. But, here's the hook. There are 8 different types of storage, so I have an 8 bit mask. However, for every storage type, there are two types of permission. So, I have a 16 bit permissions mask. What I'd like to do is take my 8-bit STORAGE mask, say it's 10110011 and convert it to 1100. Note that all I did there was take each bit in the input mask, and make the same value repeat. So, 0 would become 00, 1 would become 11, 10 would become 1100. Does that make sense? Once I've done that, I can take my STORAGE mask that's now stretched to 16 bits, and directly AND it with my PERMISSIONS mask. So, my question is: Is there a nice, scalable way to take my 8 bits and expand them into 16 bits, in the way that I'm describing? A clever bit twiddling expression would be perfect, but anything that's efficient and scalable will do. (The end product will be hidden behind a view or stored procedure.) Any thoughts, anyone? Thanks in advance, -Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Any body having Oracle Dev/2000 6i CBT's . If any Can you please send ? Thanks in Advance ... Kirtish P. Gaonkar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtish P Gaonkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hello! It's me else one :) When I setup Email Notifications to sysman (sender's email, smtp server, etc) it cannon send report to me cause of VD-4280 error: The SMTP Server could not be connected to. Email server is working properly, configured too. Mail client from the same machine works fine. Alert logs are clean. Where am I wrong? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
HELP Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui conteúdo informativo e não transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponíveis: Internet Banking , BankBoston por telefone ou agência/representante de atendimento de sua conveniência. Agradecemos sua colaboração. This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels: Internet Banking , BankBoston by phone or branch/relationship manager at your convenience. Thank you for your cooperation.
[no subject]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L DIGEST
[no subject]
__ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Subject: problem with TextArea /JTextArea (JAR File - Simple Archive )
Hello Experts, I am using Jdeveloper 9i to make a simple Application which reads data from a binary file and displayes it in a TextArea or JTextArea. This application works fine when i run test it through the JDeveloper 9i Environment. But when i deploy this application into a JAR File - Simple Archive , and execute the jar file no text is displayed in the TextArea or JTextArea . Has any one faced this problem? any tips? web links? TIA, Mubarak Ali -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mubarik Ali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
help __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Benny Pei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James PEARSON INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
help
(no subject)
help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L NOMAIL -- - Software Engineering Vattmannstraße 7, 33100 Paderborn Phone: (+49) 52 51 / 30 1 6333 Fax: (+49) 52 51 / 30 16 399 eMail: [EMAIL PROTECTED] http://www.unitrade.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joerg Jost INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
We have two servers: Server A running iAS ; Server B running IDS 9 and serving files. We map one drive from server B to server A and we are trying to access the forms on the remote driver: http://host:port/forms90/f90servlet?form=f:\form_name.fmx But we receive an error saying that the servlet could not read the form file. If we copy the file from f:\ to a local drive , ie , c:\temp , the form can be executed succesfully. We are aware of a known bug issue in the old OAS that prevent using forms apps running on remote drivers . but we think that it could (and should) be fixed on iAS. Does anyone facing the same problem or trying to do something similar on IAS ?? Both server are running Win2K. Thanks in advance, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
(no subject)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Radu Deliu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi, I have been grappling with this for sometime I have a table a_user_groups USER_ID SECURITY_GROUP_ID GROUP_ID -- - -- 1005 1012 1010 1005 1012 1011 1006 1013 1010 1007 1017 1016 1008 1018 1010 1008 1018 1011 The security_group_id currently is uniquely generated every time a user is added and a group_id is associated with the user_id. For eg: user_id 1005 is associated with groups 1010 and 1011. User 1008 has the same combination but the security_group_id is generated differently. The generation happens from C code and there is an option to correct the problem in the C code but I am trying to see if I can prevent that The requirement is that user_id 1008 and any other users with the same group_id combination should have the same security_group_id 1012, basically the first occurrence for the combination. In the case of user_id 1006 the value for security_group_id is 1013 and the group_id the user_id belongs to is 1016. So all the user_ids with a group_id association of 1016 (1016 in a combination does not count) down the line will have to be updated to 1013. I found a solution for the case where I associate a group to a user_id in this existing table by creating another table that converted the above table into a hierarchy Table b_hier_user_groups USER_ID CGID PARENT_VALUE CHILD_VALUE -- -- --- 1005 1012 1010 1005 1012 10101011 1006 1013 1010 1007 1017 1016 1008 1018 1010 1008 1018 10101011 Then using a PL/SQL script I generated the tree using sys_connect_by_path I determined if the user had a path that already. For eg: in the above case if the user 1006 was being associated with group_id 1011, then I would check the exsiting trees to see if there was a path already as in 1010,1011. In this case it does exist and the cgid (equivalent to security_group_id in the above table) is 1012 and update the user_id 1006 to cgid 1012. But I am not for some reason able to apply this solution to the existing rows. I have a feeling that I am missing something simple The requirement that I am grappling with is to update the values in the existing table. I can get the table b_hier_user_groups created from the a_user_groups. Please let me know if you need more information The table structures are as below a_user_groups Name Null?Type - USER_ID NOT NULL NUMBER SECURITY_GROUP_ID NOT NULL NUMBER GROUP_ID NOT NULL NUMBER Table b_hier_user_groups Name Null?Type - USER_IDNUMBER CGID --- same as security_Group_id from above) NUMBER PARENT_VALUE NUMBER CHILD_VALUENUMBER Thanks for your time and help in advance. Regards, Madhavan http://www.dpapps.com -- Madhavan Amruthur DecisionPoint Applications -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
My oracle using version is 8.0.0.5. Now , I'm programming proc . When I precompile them and fail. But I cant see what happened .and where the errors are. So I look carefully for errors in large file. Is there some way to show where the error is .and what the error is . Can you give me your hand . Thanks in advance!
[no subject]
They have been removed due to my rman framework scripts taking the disk space. Sorry. Joe I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? John Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L NOMAIL SET RMOUG-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schafer, Connie J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
HELP
[no subject]
bio oracle-l
begin 666 bio.txt
[EMAIL PROTECTED]%M:6QT;VX-D]R86-L92!$0D$-E%60R!);F,N#0H-D)OFX@
M,3$M,CM,3DU. T*2EG:!38VAO;VPZ(%-U;[EMAIL PROTECTED],L($%S=]N
M(%!!#0I#;VQL96=E.B!-87AW96QL($ENW1I='[EMAIL PROTECTED]FES=]W;B!0
M02P@,3DW. T*#0I)(%M(AA'!I;'D@;6%RFEE9!W:71H(#,@8VAI;1R
M96XN#0H-E!R;V9EW-I;VYA;!86-K9W)O=6YD#0H]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/0T*22=V92!B965N(%N($]R86-L92!$0D$@VEN8V4@,3DY
[EMAIL PROTECTED]')I;W(@=[EMAIL PROTECTED]AA=!)('=AR!A;B!A'!L:6-A=EO;B!PF]GF%M
M;65R(]N('1H92!0:6-K($1A=%B87-E(9OB Q-2!Y96%R[EMAIL PROTECTED];'-O
M(1I9!PF]GF%M;6EN9R!O;B!7:6YD;W=S(#,N,2!B86-K(EN('1H92 Y
M,=S+B -@T*3W1H97(@26YT97)EW1S#0H]/3T]/3T]/3T]/3T]/3T-D-H
MFES=EA;FET0T*0FEB;4@W1U9'D-G-K:6EN9PT*8V%N;V5I;F-FMA
;6%K:6YG#0IH:6MI;F-F)O=VQI;F-@T*
`
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
[no subject]
set oracle-l nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L DIGEST signature -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi, I was wondering how DBAs are coping with these new large disks that are availableyou can purchase 36gb, 72gb, etc. You can fit a whole database on one of these. But with all the performance and redundancy considerations, you wouldn'tso what do you do with the free space? Or how do you tell your bean counter that out of that 72gb you are only going to use 10gb so you need a couple of these? Rgds, Ken Heng -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Heng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
set oracle-l digest
[no subject]
hi, can i use a database link inside a procedure to refresh data from a AS/400 system into oracle ?? this is the sample of the code that i am using ... and it hangs endlesly... CREATE OR REPLACE PROCEDURE PRC_TABLE_REFRESH AS BEGIN execute immediate 'alter session set global_names=false'; execute immediate 'TRUNCATE TABLE x'; execute immediate 'TRUNCATE TABLE yy'; execute immediate 'TRUNCATE TABLE xxx'; INSERT INTO x SELECT * FROM [EMAIL PROTECTED]; COMMIT; INSERT INTO xxx SELECT * FROM [EMAIL PROTECTED]; COMMIT; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Raj, Another consideration is a potential for a buffer busy waits. the larger the block size is, the more the number of rows in an average block. Thsi increases the possibility of a buffer busy wait. HTH. Arup An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The 8.0 database had an block size of 2k. Multiblock read count is 8. This is an OLTP database, all transactions almost always work on a single row. None of the row sizes exceed the block size. Hardly any chained or migrated rows. Now, during this migration, it was recommended to change the block size to 8k. And my concerns are: 1. Would this not increase pinging across the instances? With 9i and interconnect and cache fusion, this should be reduced considerably, so, is it a mute point? 2. This could alter the execution plans of some statements. Would some, maybe a very few of the statements not prefer a full table scan? Any other positive or negative effects of this increase in block size? Thanks One Paranoid DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi Listers, I'm new in DBA's job. I want to ask what is 'statspack' ? does it a third party program from oracle or a script. Where I can find the information about 'statspack' ? or if it is a script would you please to share with me ? Thank you in advance for your help. Every comments and clues would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be refreshed. It is only the new data on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi Stephane, Thanks for the attempt. When I saw the O7_DICTIONARY_ACCESSIBILITY I thought it would be the answer. Unfortunately Dennis Williams is right in saying that this parameter only allows users with SELECT ANY TABLE privileges to also see SYS tables. Short of changing my scripts for different version of Oracle due to obsolete columns and values, I was trying to see how OEM could easily just nominate a minimum database version and ensure that the script still works against a higher version of Oracle. Unfortunately I haven't been able to find a way of doing so :-( Leng. -- From: Stephane Faroult[EMAIL PROTECTED] Date: Wed, 15 Jan 2003 09:06:26 UT Subject: RE: Re: Run obsolete Oracle 7 scripts against Oracle 8i databas= e? v$instance changed a lot. Otherwise Jared is right about #, which was mos= tly appended to (number) columns named 'TYPE' (became a reserved word in = 8.x, thanks to the $=A3=F9=E0=E7?%* object option) (in sys.obj$, sys.user= $ most notably, possibly sys.seg$ too - perhaps sys.con$ or sys.cdef$ as = well, can't remember).=20 To answer the original question more precisely, there is a O7_DICTIONARY_ACCESSIBILITY init.ora parameter (in 8 and 8i at least), bu= t I am still unclear about its exact meaning and purpose. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion. Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
[no subject]
hi, Wish u a very New Year Sudhakar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sudhakar Reddy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SETORACLE-L DIGEST EDOUARD DORMIDONTOV
[no subject]
SET ORACLE-L NOMAIL Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L NOMAIL
[no subject]
which -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
HELP
[no subject]
Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
set no-mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi, How can I complie PRO*C code.Please Thnks
[no subject]
Hello fokls. First, I do not and have never worked for Oracle. I thought I'd show you some funny and interesting comments from the Oracle source tree that I've been made privy to. Here is today's installment. /* retch, gag, choke. If this bit is off, oracle doesn't break/reset the ttc pipe in the event of an error. When oracle is running an NPI execution, there may well be data left in the pipe when an error occurs at type-check time since the current crop of bind variables are sent along with the execute function block . Since this bit is always cleared, the data stays in the pipe and fouls things up on the next transmit. So...don't clear the bit here if executing an OEXEC (or an OALL, which may execute an OEXEC). Instead, let opiobv clear it. This means that any execute error will mean a break/reset, even if there is no data left in the pipe. Tough luck, campers */ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraclegeek INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi, I've installed Application Server Infrastructure 9i Release 2, but i skipped the configuration assistants. The Enterprise Manager Console doesn't discover the Oracle HTTP Server even if was started with the dcmctl utility. Are there configuration tools that configure the HTTP server and integrate it with the other components? Levente Bodrogi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Levente Bodrogi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hey Guys, I used FGAC for a small application a year ago without problems/issues. I have reread the docs and now I would like to know the experiences of those using FGAC for larger systems. I am now working on an OLTP system that will have tables in the 4+ million range with 100+ concurrent users. It is 8.1.7.4 on HPUX 11 with WebLogic 7. Are there any performance issues with using FGAC in this configuration and with this amount of data? Is there anything I should avoid other than the obvious? Thanks, Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246
[no subject]
Hi I have unpartitioned table with aroung 2 million rows. When I was creating an index on the table, it failed as it was not able to extend the temp segment. I added a temp segment and recreated the index. But now i see the index is created on some columns which cannot be seen in the DESCRIBE TABLE command. The columns created are : SYS_NC00022$ SYS_NC00023$ SYS_NC00024$ SYS_NC00025$ SYS_NC00026$ SYS_NC00027$ What are these columns. When I do a describe on the table, I cannot see these columns but when I do a select as follows, I see some data in these columns : SELECT SYS_NC00022$,SYS_NC00023$,SYS_NC00024$,SYS_NC00025$,SYS_NC00026$,SYS_NC00027 $ FROM TABLENAME ; SYS_NC00022$SYS_NC00023$SYS_NC00024$SYS_NC00025$SYS_NC00026$ SYS_NC00027$ AFD2BAFFC8FFC7CCFF CFFF CFFFCEFF AFD2BAFFC8FFC7CFFF CFFF CFFFCEFF AFD2BAFFCAFFCCCAFF CFFF CFFFCEFF BAB3BAFFC8FFC9CFFF CFFF CFFFCEFF ACBABCFFC8FFCDCAFF C8FF C8FFC9FF AFD2BAFFC8FFC7CBFF CFFF CFFFCEFF .. What are these columns and what is the data contained in it? TIA -rM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
What is the syntax to delete multiple objects, or more specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1. Thanks Clint
[no subject]
Hello, Could you explain me how to deal with folowing error: select * from sysaudit@tg.big * ERROR at line 1: ORA-28509: unable to establish a connection to non-Oracle system ORA-02063: preceding line from TG.BIG (HP-UX 11, Oracle 8.1.6, tg4ifmx 8.1.6, Informix 9.2) Tnsnames.ora: tg.big.lv = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bigboy.konts.lv)(PORT = 1521)) ) (CONNECT_DATA = (SID = tg4ifmx) ) (HS=OK) ) Listener.ora: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bigboy)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bigboy)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = tg4ifmx) (ORACLE_HOME = /app/oracle/gateway/901) (PROGRAM = /app/oracle/parex_gateway/bin/tg.sh) ) ) tg.sh: #!/bin/sh export ORACLE_HOME=/app/oracle/parex_gateway export GATEWAY_SID=tg4ifmx export INFORMIXDIR=/d11/informix/parex_informix export INFORMIXSERVER=informix export LD_LIBRARY_PATH=/usr/lib:/app/oracle/parex_gateway/lib:/d11/informix/parex_i nformix/lib:/d11/informix/parex_informix/lib/esql export SHLIB_PATH=/app/oracle/parex_gateway/lib:/usr/lib:/d11/informix/parex_inform ix/lib:/d11/informix/parex_informix/lib/esql export PATH=/app/oracle/parex_gateway/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/local/bin echo /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out chmod 777 /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out exec /app/oracle/parex_gateway/bin/tg4ifmx $* 2 /app/oracle/parex_gateway/tg4ifmx/log/testtrace.out inittg4ifmx.ora: HS_FDS_CONNECT_INFO=sysmaster@informix HS_FDS_TRACE_LEVEL=5 #HS_FDS_RECOVERY_ACCOUNT=RECOVER #HS_FDS_RECOVERY_PWD=RECOVER HS_FDS_TRANSACTION_MODEL=READ_ONLY HS_DB_NAME=TG HS_DB_DOMAIN=BIG set INFORMIXDIR=/d11/informix/parex_informix set INFORMIXSERVER=informix set DELIMIDENT=y testtrace.out is empty tg4ifmx_agt_4470.trc: hoagprd(2); Entered. [Transparent gateway for INFORMIX] version: 2.0.4.0.0009 connect string is: YEAR2000_POLICY=-1;CTL_DEBUG=T;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSE R_- DEPTH=2000;EXEC_FLAGS = 131080;defTdpName=tg4ifmx;binding=(tg4ifmx,INFORMIX,sysmaster@informix); ORACLE INFORMIX GATEWAY Log File Started at 14-Oct-02 14:41:05 Class version: 73 hoagprd(2); Exited with retcode = 0. hoainit(3); Entered. hoainit(3); Exited with retcode = 0. hoalgon(7); Entered. name = informix. Silent DB Function!! (Last message occurred 2 times) hoalgon(7); Exited with retcode = 0. hoaulcp(4); Entered. hoaulcp(4); Exited with retcode = 0. hoauldt(5); Entered. hoauldt(5); Exited with retcode = 0. hoabegn(9); Entered. formatID = 306206, hoagttid =TST.BIGBOY.KONTS.LV.80278506.1.5.36, hoagtbid = ., tflag = 0, initial = 1 DB_INF EXECUTE_IMMEDIATE: BEGIN WORK SET ISOLATION TO COMMITTED READ SET LOCK MODE TO NOT WAIT (Last message occurred 3 times) hoabegn(9); Exited with retcode = 0. hoadtab(26); Entered. Silent DB Function!! Listener.log: 14-OCT-2002 14:41:05 * (CONNECT_DATA=(SID=tg4ifmx)) * (ADDRESS=(PROTOCOL=tcp)(HOST=159.148.42.8)(PORT=52994)) * establish * tg4ifmx * 0 Bruno Vanters Junior DBA TietoEnator Financial Solutions 41 Lacplesa str., Riga, LV-1011, Latvia phone: +371 7286660, fax: +371 7243000 Mob. phone: +371 6337831 www.tietoenator.lv -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruno Vanters INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hello all, I have a client who will be doing the data capture and give me the data in a flat file. what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP Thanks and regards,Santosh
[no subject]
set nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
[no subject]
Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh
[no subject]
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
SET ORACLE-L NOMAIL _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Subject: Hash Cluster Statistics
List, Does anyone know of some good resources about gathering statistics on Hash Clusters. I am particularly interested in finding out how full our buckets are and any chained links we have currently. Thanks before hand for you help. Tim Boles DBA Lockheed Martin Information Systems [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
NOMAIL ORACLE-L __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[no subject]
Hi friends
I am using following command to call report from
report
srw.run_report ('report=d:\test.rdf destype=file desname=try.out
desformat=dflt batch=yes');
I have tested this using After Report /Before Report/Action Trigger.
But this is not calling the report.
Any solution will be appreciated.
Syed
[no subject]
Please don't sent any more mail to this ID Please take it as a request Please ignore my name Mail ID : [EMAIL PROTECTED] Thanks System Admin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RO-Hosur 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).
[no subject]
Hi, I would like to know which datatype is best to use for storing text data of around 50 lines.The data is basically a variable length user feedback.I am in confusion whether to go for VARCHAR2 or LONG type. Also in CLOB and NCLOB, can somebody clarify me about CLOBS store single-byte character set data and NCLOBs store fixed-width and varying-width multibyte national chararcter set data(NCHAR data). Which one is the best to use among VARCHAR2,LONG,CLOB,NCLOB for my requirement Thanks Regards, Sankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar 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).
[no subject]
Oracle 8.0.5 AIX 4.3.3 I Have following statement, which takes forever and does lots of physical reads ** insert into test_table SELECT v1.engagement, v1.YEAR, v1.period, MAX (v2.net_fee_earned_ptd) , MAX (v2.exp_wip_val_ptd) FROM (SELECT MAX (wstat.eng_numb) engagement, MAX (wstat.fnancl_year) YEAR, MAX (wstat.prd_numb) period, SUM (NVL (wstat.time_wip_val_ptd, 0)) + SUM (NVL (wstat.gnrl_w_on_ptd, 0)) - SUM (NVL (wstat.gnrl_w_off_ptd, 0)) - SUM (NVL (wstat.time_wip_val_w_off_ptd, 0)) - SUM (NVL (wstat.wip_prvsn_ptd, 0)) - SUM (NVL (wstat.exp_wip_val_w_off_ptd, 0)) - SUM (NVL (dstat.dbtrs_w_off_ptd, 0)) - SUM (NVL (dstat.dbtrs_prvsn_ptd, 0)) net_fee_earned_ptd, SUM (NVL (wstat.exp_wip_val_ptd, 0)) exp_wip_val_ptd FROM eng_wip_stats wstat, eng_dbtrs_stats dstat WHERE wstat.eng_numb(+) = dstat.eng_numb AND wstat.fnancl_year = dstat.fnancl_year AND wstat.prd_numb = dstat.prd_numb AND wstat.eng_numb = '101' GROUP BY wstat.eng_numb, wstat.fnancl_year, wstat.prd_numb) v1, (SELECT MAX (wstat.eng_numb) engagement, MAX (wstat.fnancl_year) YEAR, MAX (wstat.prd_numb) period, SUM (NVL (wstat.time_wip_val_ptd, 0)) + SUM (NVL (wstat.gnrl_w_on_ptd, 0)) - SUM (NVL (wstat.gnrl_w_off_ptd, 0)) - SUM (NVL (wstat.time_wip_val_w_off_ptd, 0)) - SUM (NVL (wstat.wip_prvsn_ptd, 0)) - SUM (NVL (wstat.exp_wip_val_w_off_ptd, 0)) - SUM (NVL (dstat.dbtrs_w_off_ptd, 0)) - SUM (NVL (dstat.dbtrs_prvsn_ptd, 0)) net_fee_earned_ptd, SUM (NVL (wstat.exp_wip_val_ptd, 0)) exp_wip_val_ptd FROM eng_wip_stats wstat, eng_dbtrs_stats dstat WHERE wstat.eng_numb(+) = dstat.eng_numb AND wstat.fnancl_year = dstat.fnancl_year AND wstat.prd_numb = dstat.prd_numb AND wstat.eng_numb = '101' GROUP BY wstat.eng_numb, wstat.fnancl_year, wstat.prd_numb) v2 WHERE v1.engagement = v2.engagement(+) AND TO_DATE ( v2.YEAR(+) || v2.period(+), 'MM') = ADD_MONTHS (TO_DATE ( v1.YEAR || v1.period, 'MM'), -12) AND TO_DATE ( v2.YEAR(+) || v2.period(+), 'MM') = TO_DATE ( v1.YEAR || v1.period, 'MM') GROUP BY v1.engagement, v1.YEAR, v1.period / ** Here is the explain plan: ** ID PID QUERY_PLAN - - 0 INSERT STATEMENT Cost = 106 1 0 SORT GROUP BY Card=1 2 1 NESTED LOOPS OUTER Card=1 3 2 VIEW Card=1 4 3 SORT GROUP BY Card=1 5 4 HASH JOIN Card=1 6 5 TABLE ACCESS BY INDEX ROWID ENG_DBTRS_STATS Card=19 7 6 INDEX RANGE SCAN IDX_EG10_ENGNUMB_CRNTFLAG Card=19 8 5 TABLE ACCESS BY INDEX ROWID ENG_WIP_STATS Card=21 9 8 INDEX RANGE SCAN IDX_EG09_ENGNUMB_CRNTFLAG Card=21 10 2 VIEW Card=1 1110 SORT GROUP BY Card=1 1211 HASH JOIN Card=1 1312 TABLE ACCESS BY INDEX ROWID ENG_DBTRS_STATS Card=19 1413 INDEX RANGE SCAN IDX_EG10_ENGNUMB_CRNTFLAG Card=19 1512 TABLE ACCESS BY INDEX ROWID ENG_WIP_STATS Card=21 1615 INDEX RANGE SCAN IDX_EG09_ENGNUMB_CRNTFLAG Card=21 17 rows selected. ** If I just run the select part (not insert into) it's really quick With the following explain plan: ** ID PID QUERY_PLAN - - 0 SELECT STATEMENT Cost = 106 1 0 SORT GROUP BY Card=1 2 1 NESTED LOOPS OUTER Card=1 3 2 VIEW Card=1 4 3 SORT GROUP BY Card=1 5
[no subject]
I just found a Korn shell script on-line to Delete RMAN backupsets older than a specified number of days. It has syntax in it that RMAN doesn't like, and I can't find a reference to what the script is trying to do anywhere. OS: HPUX 11i Production DB: Oracle 8.1.7.4 Recovery Catalog DB: Oracle 8.1.7.4 The syntax in the script is this: (rman catalog rman/password@RCAT target sys/password@HOST - EOF list backupset of database from time 'SYSDATE-1000' until time 'SYSDATE-$DAYSTOKEEP'; exit; EOF ) | grep RMAN-06233 | while read filler key filler filler date rest do echo # Delete backupset $key dated $date... $CMDFILE echo CHANGE BACKUPSET $key DELETE; $CMDFILE done The syntax I am confused about is the list . from time until time part. I cannot find reference to that syntax anywhere. Is there actually a way to make this work? When I run the script, it gets to this point and gives me the following error messages: RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found from: expecting one of: archivelog, completed, controlfile, database, datafile, device, like, recoverable, ;, skip, tablespace, tag RMAN-01007: at line 2 column 1 file: standard input Thanks in Advance! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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).
[no subject]
Hello All, We are trying to install Oracle9i on RED HAT linux 7.2 and getting following message: THE JAVA RUNTIME ENVIRONMENT WAS NOT FOUND AT TEMP/BIN/JAVA THE ORACLE UNIVERSAL INSTALLER CAN NOT BE RUN. I have looked through metalink but could not find anything satisfying. I would like to hear from someone who has an idea about overcoming this error. Thanks. Santiago. Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Santiago=20Argibay=20Molina?= 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).
[no subject]
SET ORACLE-L NOMAIL __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa 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).
[no subject]
Oracle releasing clustered file system code The move is designed to allow better management of databases on Linux server clusters. http://computerworld.com/newsletter/0%2C4902%2C73404%2C0.html?nlid=AM -- 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).
[no subject]
Hello,
I have a question regarding method of index access(full vs. range) that
oracle uses when I use different join methods (Hash vs. Nested loop).
Here are the some details about the environment.
Server : Oracle Server EE ver 8.1.7.2
OS : HP UX 11.0
hash_area_size : 4194304
hash_join_enabled : TRUE
hash_multiblock_io_count: 64
The tables, indexes are all analyzed fully (no estimates) with dbms_stat.
The following two scenarios are executed back-to-back and are reproducable.
The parameter value to the SQL could be any month in a format like 200207,
200201 etc..
When I use nested loop join the index on large table is ranged scaned, but
when I use the hash join the full scan on the index is done. My question is
why is the behviour of index scan different? Why there is no partition
pruning when the table is hash-joined?
The details related to the objects is at the end of the message.
Thanks for your help.
Regards
Viral.
NESTED LOOP SQL
===
select --+use_nl(cm fd) index(fd)
fd.*
from copa_mdo_srce_sys_map cm
,fact_dmnsn_q3 fd
where fd.srce_sys_id = cm.srce_sys_id
and cm.mdo_id = 'NA'
and fd.due_perd = LAST_DAY(TO_DATE('1', 'MM'))
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1333 Card=54869 Bytes5925852)
1 0 NESTED LOOPS (Cost=1333 Card=54869 Bytes=5925852)
2 1 TABLE ACCESS (FULL) OF 'COPA_MDO_SRCE_SYS_MAP' (Cost=1 Card=9 Bytes=54)
3 1 PARTITION RANGE (ITERATOR)
4 3 TABLE ACCESS (BY LOCAL INDEX ROWID) OF 'FACT_DMNSN_Q3'
(Cost=148 Card=73158 Bytes=7462116)
5 4 INDEX (RANGE SCAN) OF 'FACT_DMNSN_Q3_IDX1' (NON-UNIQ
UE) (Cost=30 Card=73158)
HASH JOIN SQL
===
select --+use_hash(cm fd) index(fd)
fd.*
from copa_mdo_srce_sys_map cm
,fact_dmnsn_q3 fd
where fd.srce_sys_id = cm.srce_sys_id
and cm.mdo_id = 'NA'
and fd.due_perd = LAST_DAY(TO_DATE('1', 'MM'));
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=13103 Card=54869 Byt
es=5925852)
1 0 HASH JOIN (Cost=13103 Card=54869 Bytes=5925852)
2 1 TABLE ACCESS (FULL) OF 'COPA_MDO_SRCE_SYS_MAP' (Cost=1 C
ard=9 Bytes=54)
3 1 PARTITION RANGE (ALL)
4 3 TABLE ACCESS (BY LOCAL INDEX ROWID) OF 'FACT_DMNSN_Q3'
(Cost=13101 Card=73158 Bytes=7462116)
5 4 INDEX (FULL SCAN) OF 'FACT_DMNSN_Q3_IDX1' (NON-UNIQU
E) (Cost=11693 Card=73158)
Table/index designs
===
desc fact_dmnsn_q3
Name Null?Type
- -
FACT_ID NOT NULL NUMBER(15)
CAPTL_ID VARCHAR2(15)
CUST_IDVARCHAR2(15)
FUNC_IDVARCHAR2(15)
GENRC_DMNSN_1_ID VARCHAR2(15)
GENRC_DMNSN_1_TYPE_ID NUMBER(4)
GENRC_DMNSN_2_ID VARCHAR2(15)
GENRC_DMNSN_2_TYPE_ID NUMBER(4)
GENRC_DMNSN_3_ID VARCHAR2(15)
GENRC_DMNSN_3_TYPE_ID NUMBER(4)
GEO_ID VARCHAR2(15)
LEGAL_ENT_ID VARCHAR2(15)
MEASR_ID VARCHAR2(15)
MM_HYBRD_IDVARCHAR2(15)
ORG_ID VARCHAR2(15)
PROD_IDVARCHAR2(15)
PROFT_CTR_ID VARCHAR2(15)
SITE_IDVARCHAR2(15)
TIME_PERD_ID NOT NULL VARCHAR2(15)
TRADE_CHANL_ID VARCHAR2(15)
FACT_TYPE_CODENOT NULL VARCHAR2(2)
ISO_CRNCY_CODE_CHARVARCHAR2(3)
SRCE_SYS_ID NOT NULL NUMBER(15)
LYOUT_ID NUMBER(4)
FACT_QLTY_CODE VARCHAR2(1)
MKT_CLASS_CODE VARCHAR2(1)
DEMND_PLAN_CUST_GRP_CODE VARCHAR2(10)
TIME_PERD_TYPE_CODE NOT NULL VARCHAR2(4)
TIME_PERD_END_DATENOT NULL DATE
DUE_PERD NOT NULL DATE
ROW_ORIGN VARCHAR2(1)
PRTTN_CODE VARCHAR2(15)
PARNT_FACT_ID NUMBER(15)
DELIV_RCVD_ID NUMBER(10)
ORIG_UNIT_ID NUMBER(11)
SQL:idwsp3 - desc copa_mdo_srce_sys_map
Name Null?Type
Subject: List archives on line?
Hi, there is a Geman server offering a list archive http://www.doag.org/orafaq/afl-oral.htm they have a lot more links on http://www.doag.org/orafaq/faq2.htm Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).
[no subject]
Guys , my insert statement is below . explain shows 828 for redo size . does it mean the no of blocks ? what should be the ideal value for the same ? what does the value for redo size = 828 indicate ? kindly explain me. insert into MSG_History (Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_Age,S_Hight,S_Style,S_BloodType,S_LooksLike,Name,Age,Hight,Style,BloodType,LooksLike,REFERER,MSGID,DelFLG,RefCNT,EntPC,Opt1) values (:RTEL,:RMEMNO,:SID,:op_sex,SYSDATE,:MESSAGE,:NAME,:AGE,:HIGHT,:STYLE,:BLOODTYPE,:LOOKSLIKE,:RNAME,:RAGE,:RHIGHT,:RSTYLE,:RBLOODTYPE,:RLOOKSLIKE,'¿¿¿',GetMSGID.NextVal,0,0,:EntPC,:POSTNO) Elapsed: 00:00:00.69 Execution Plan - 0 INSERT STATEMENT Optimizer=CHOOSE (Cost=39185 Card=6800153 B ytes=1523234272) 10 SEQUENCE OF 'GETMSGID' Statistics - 0 recursive calls 8 db block gets 1 consistent gets 1 physical reads 828 redo size 858 bytes sent via SQL*Net to client 1520 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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).
[no subject]
Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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).
[no subject]
i have oracle 8i on windows 2000 server. i have installed developer 6 . Now i can not connect database. Now I get the message on startup: Could not start ORACLEORAHOME81AGENT service on local computer error 3221356553. When i want to start svrmgrl i got sp1 lang.msb not found. what can i do to start the oracle? Thank you for any help. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ismail nural 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).
[no subject]
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAHUL GAJANAN MEHENDALE 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).
[no subject]
CONFIRM L-ORACLE Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat
[no subject]
CONFIRM ORACLE-L Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat
[no subject]
SET ORACLE-L REPRO END Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat
Subject: Re: [Fwd: Please Advise--Your Reaction to Ellison Comme
Hi, as you were discussing that the message was sent to recent posters I guess you are right. I am twice assigned to the list, once at home and once with my office mail account. As I did recent postings to the list from my office account I only received the Ellison Comment mail at my office mail account. Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).
[no subject]
no application server involved. thx Sameer -- We can definitely find the user , but considering my scenario 'all the people are logged in with the same oracle user' , I want to know:From what machine the SQL statement was fired. thx Sam name--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: Have a look at v$session In particular the osuser, terminal and machine fields - these may help Also look at the listener log file - this may help Or do you have an application server sitting in the middle? HTH, Bruce Reardon -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 June 2002 15:18 Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect to the server. As all the people are logged in with the same user name ,Can we find which user(or machine) has issued which SQL statement. Thanks Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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).
[no subject]
Hi, I am facing a very strange problem. Oracle 7.3.4.4.1 and HP 10.2 I do an analyze of a huge table (more than 46 million records) . The query which hits this table and 2 other table has an RULE hint . On the day analyze fails on the big table, performance is very very slow . But with analyze performance is ok. 1) With RULE shouldn't oracle overrule the statistics and take the hint only. Why does it seem to be checking statistics . The init.ora value is choose . shreepad -- 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).
[no subject]
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- 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).
[no subject]
HELP
[no subject]
How much memory is allocated to each login to Oracle? Is it not 20-30mb? I have heard people mention of 300mb? Surely this would bring most servers down if it was true. Clint Currency.gif Description: GIF image
[no subject]
Hi all! I need a solution about calling sql*loader from pl/sql. I have a version now with external dlls, but actually I don't know the platform so it not seems a good choice. I would like something native oracle solution with oracle's packages or something like that. -- 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).
[no subject]
Qs Why is elapsed Time so HIGH in the following SELECT ? NOTE - 1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table 2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object (GENERAL_ACCT_MAST_TABLE) 3) There is a UNIQUE Index on the field of the Where Clause (i.e. acid) for the Object (GENERAL_ACCT_MAST_TABLE) 4) This Table has a Total of 10 indexes of which 5 are present in 1 Tablespace 5 are present in a 2nd Tablespace . 5) This Table is a Highly Accessed Table day-to-day Working of the Application Select ,TO_CHAR(notional_rate) ,notional_rate_code ,TO_CHAR(fx_clr_bal_amt) , TO_CHAR(fx_bal_on_purge_date) ,fd_ref_num ,TO_CHAR(fx_cum_cr_amt) , TO_CHAR(fx_cum_dr_amt) ,crncy_code ,source_of_fund ,anw_non_cust_alwd_flg , acct_crncy_code ,TO_CHAR(lien_amt) ,acct_classification_flg , system_only_acct_flg ,single_tran_flg ,TO_CHAR(utilised_amt) , inter_sol_access_flg ,purge_allowed_flg ,purge_text ,TO_CHAR(min_value_date, 'DD-MM- HH24:MI:SS') ,acct_mgr_user_id ,schm_type , TO_CHAR(last_frez_date,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_unfrez_date, 'DD-MM- HH24:MI:SS') ,TO_CHAR(bal_on_frez_date) ,swift_allowed_flg , TO_CHAR(dacc_lim_pcnt) ,TO_CHAR(dacc_lim_abs) ,chrg_level_code , acct_cls_chrg_pend_verf ,partitioned_flg ,partitioned_type , pbf_download_flg ,TO_CHAR(pbf_delink_date,'DD-MM- HH24:MI:SS') , wtax_flg ,wtax_amount_scope_flg ,int_adj_for_deduction_flg ,operative_acid , phone_num ,native_lang_name ,nat_lang_title_code ,lang_code ,NVL(ts_cnt,0) , rowid into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14, :b15,:b16,:b17,:b18,:b19,:b20,:b21,:b22,:b23,:b24,:b25,:b26,:b27,:b28,:b29, :b30,:b31,:b32,:b33,:b34,:b35,:b36,:b37,:b38,:b39,:b40,:b41,:b42,:b43,:b44, :b45,:b46,:b47,:b48,:b49,:b50,:b51,:b52,:b53,:b54,:b55,:b56,:b57,:b58,:b59, :b60,:b61,:b62,:b63,:b64,:b65,:b66,:b67,:b68,:b69,:b70,:b71,:b72,:b73,:b74, :b75,:b76,:b77,:b78,:b79,:b80,:b81,:b82,:b83,:b84,:b85,:b86,:b87,:b88,:b89, :b90,:b91,:b92,:b93,:b94,:b95,:b96,:b97,:b98,:b99,:b100,:b101,:b102,:b103, :b104,:b105,:b106,:b107,:b108,:b109,:b110,:b111,:b112,:b113,:b114,:b115, :b116 from TBA_GENERAL_ACCT_MAST_TBL where acid=:b117 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 6928 3.99 999.46 0 0 0 0 Fetch 6928 4.47 5.57 2171 27717 0 0 --- -- -- -- -- -- -- total13857 8.461005.03 2171 27717 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).
[no subject]
hi there, I want tips regarding 1z0-023 architecture exam.. please help, Thanks Rohit
[no subject]
Hi A developer is getting a sporadic errors when trying to access ORacle database via a Cold Fusion screen. The messages on the screen are Oracle Error Code = 0 Timeout while obtaining an Oracle statement lock. I turned tracing on in his session and found this in the trace file: update seg$ set type=:3,ts#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9, extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:1 4, 65535, NULL, :14) where file#=:1 and block#=:2 END OF STMT PARSE :c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=3,tim=0 EXEC 2:c=0,e=0,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=3,tim=0 STAT #2 id=1 cnt=1 pid=0 pos=0 obj=13 op='TABLE ACCESS CLUSTER SEG$ ' STAT #2 id=2 cnt=1 pid=1 pos=1 obj=8 op='INDEX UNIQUE SCAN 'EXEC #1:c=0,e=0,p=9985,cr=61653,cu=432587,mis=0,r=0,dep=0,og=3,tim=0 ERROR #1:err=3113 tim=0 STAT #1 id=1 cnt=60082 pid=0 pos=0 obj=1147 op='INDEX RANGE SCAN ' Looks like ORA-03113, but no mentinong of it in the alert.log What should be my next step. any ideas? thanks Gene = __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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).
[no subject]
Hi all, I've got a query that returned more rows than needed. Here is the query: SELECT distinct m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char MSNO, M.RECEIVED_DATE RECEIVED DATE, M.EDITOR_NO EDITOR NUMBER, S.STATHIST_CODE STATUS CODE, ST.STATUS_DESC STATUS DESCRIPTION, count(*) REVIEWER COUNT FROM mscript m, stathist s, reviewms r, statcode st WHERE M.JOURNAL_ID = 'ES' AND M.EDITOR_NO = 31 AND S.STATHIST_CODE 'z' AND S.STATHIST_CODE = ST.STATUS_CODE AND M.JOURNAL_ID = s.shist_ms_jcode --- primary key AND M.YR_OF_ISSUE = s.shist_ms_yrissue --- primary key AND M.MS_SEQUENCE_NO = s.shist_ms_ms_seqno --- primary key AND M.CHECK_CHAR = s.shist_ms_ckchar --- primary key AND s.shist_ms_jcode = r.msnumber_jcode --- primary key and s.shist_ms_yrissue = r.msnumber_yrissue --- primary key and s.shist_ms_ms_seqno = r.msnumber_ms_seqno --- primary key and s.shist_ms_ckchar = r.msnumber_ckchar --- primary key GROUP BY m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char, M.RECEIVED_DATE, M.EDITOR_NO, S.STATHIST_CODE, ST.STATUS_DESC order by 1 / And the query displays this : ES9507372 10/03/199531 b accepted with one revision 01/10/2002 ES9507372 10/03/199531 d author revision returned ES9507372 10/03/199531 e all reviews returned ES9507372 10/03/199531 f sent to editor ES9507372 10/03/199531 g proofs sent to author ES9507372 10/03/199531 j Cols receipt and processing ES9507372 10/03/199531 l acceptance pending materials ES9507372 10/03/199531 m manuscript initially received ES9507372 10/03/199531 p sent to Cols. journals office ES9507372 10/03/199531 q sent for review I only want it to select the first record all the way on top because it has the most current data with the most corrent DATE. Records in STATHIST TABLE ARE LIKE where stathist_date and stathist_code are the last 2 columns. ES9507372 01/10/2002 b ES9507372 01/05/2002 d ES9507372 01/02/2002 e Unique for each row. I know I am missing something in the query, but I've got a brain freeze; I basically need to have the query select only records that have LATEST stathist_date and NOT repating all recs there are. Thanks so much in advance!!! __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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).
[no subject]
SET ORACLE_L DIGEST
[no subject]
SET ORACLE-L MAIL * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar 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).
(no subject)
I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out? Thanks! Bill Johnson
RE: (no subject)
I'm also a brand new student of Oracle. The EXACT same thing happened to me in class a couple of weeks ago when I created a 2nd database. The reason it happened was that I didn't create the DB all in one day...and when I went in on the 2nd day to finish it, I did notstartup the 2nd database before continuing to run the scripts, etc. So, the default database started and then some of the commands/scripts actually modified the default database's control files, etc. It was a real mess. We couldn't mount to delete certain files, yet we couldn't delete certain files in nomount, etc. The teacher had me run the attached script, and that fixed it. And I learned some more lessons, hahaha! I don't know if this is what happened to you, but since your situation is EXACTLY like mine, error messages, etc., I would suspect this. So check out the attached script and maybe it'll help. You'll have to modify the .sql file to replace with your database names. In the existing file, "will" is the default database and "test" is the database I was creating. Check through and fix up filenames, paths, etc. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, February 20, 2002 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: (no subject)I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.nbs! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out?Thanks!Bill Johnson CONTROL.SQL Description: Binary data
RE: (no subject)
One more thing about the script I sent -- that was for 8i, not 9i, so check it out in that respect, as well. Cheers, JoJo
[no subject]
INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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).
[no subject]
hi, Anybodygot some oracle question dumps or resources for oracle certified internet database administrator exam ?? (exam #1Z0 -411). Thanks in advance :) rgds sunil
[no subject]
Nah, Zen in the Art of Archery was the real deal - it predates ZATAOMM by quite a few years... Mohan, Ross [EMAIL PROTECTED] wrote: you oughta apologize to Robert Pirsig, the guy who started the whole thing. -Original Message- Sent: Tuesday, January 15, 2002 12:35 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: oh, now I owe you a royalty for naming a new book Zen and the Art of Database Administration (my apologies to the author of Zen and the Art of Archery) somehow i don't think he'll mind.;-) _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Evan Tate 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).
[no subject]
Good morning everyone, Can anyone give me the command to analyze a partitioned tabled? To analyze this table unpartitioned I use: analyze table schema.table_name compute statistics; I am partitioning it into 6 partitions and want to compute statistics on each partition. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
[no subject]
SET ORACLE-L DIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MILLER, DAVID L (CONTRACTOR) 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).
[no subject]
SET ORACLE_L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc 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).
[no subject]
Hello Gurus,
I am working on a little project using the package utl_http, so far I have
had limited success using this package.
The below http call fails for some reason, it is supposed to download a
page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not
sure why...
Any ideas ?? is it because that site is trying to plant/read a cookie or
something on those lines ??
any help on this is much appreciated.
declare
v_htm_pieces utl_http.html_pieces ;
begin
pv_htm_pieces :=
utl_http.request_pieces('http://table.finance.yahoo.com/t?a=01b=01c=01d=01e=31f=01g=ds=ADCTy=0z=%5Eixic');
end;
Peace,
James Reddi
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James
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).
[no subject]
LISTS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koniszewski, Mike 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).
