Re: Client hangs on some key values
Try this, Tkae a backup of this table and truncate this table with reuse staorage. And drop and re-create the the index. Insert the records in this table back. And try to run this query again. - Original Message - From: Shelly Butterfield To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 9:44 AM Subject: Client hangs on some key values New DBA on the block and already ran into my first problem: We have an Oracle Database (8.1.7.0) running on Clustered HP-UX. Oracle client running on a HP-UX (11) B2000 machine. The query looks like select col1, col2, col3, 0, col4, col5, 0, 0, col100 from table 1 where col1 = '123' This query works for most everytime except certain selected col1 values. col1 a primary key. For the unfortuante col1 values, the client just hangs. I looked under v$session_wait, don't see anthying unusual. Only following events I have noticed: Message to/from SQL*CLient, more data to SQL*Client, file open The values for the wait were not any different from the sessions when the SQL got executed. Although the query never makes to V$SQL view. No locks on the table. verified with V$lock views. No corrupt blocks: verified with analyze ...cascade command. TNSPING normal It is interesting that these queries only fail from this one client. It works fine on the server or any other client. Network guru says he doesn't see any problem with network either. Changed the machine but still didn't help. Memory, CPU looks good on the client and server. Do you have any idea what might be wrong here? Is there a view I can refrence to show that the sever never recived the client request? TIA SB This is going to be a great day!!! Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: alter system dump logfile
Title: alter system dump logfile Please check : oradebug DUMPLIST as given below... SQL oradebug dumplistEVENTSTRACE_BUFFER_ONTRACE_BUFFER_OFFHANGANALYZELATCHESPROCESSSTATESYSTEMSTATEINSTANTIATIONSTATEREFRESH_OS_STATSCROSSICCONTEXTAREAHEAPDUMPHEAPDUMP_ADDRPOKE_ADDRESSPOKE_LENGTHPOKE_VALUEPOKE_VALUE0GLOBAL_AREAMEMORY_LOGREALFREEDUMPERRORSTACKHANGANALYZE_PROCTEST_STACK_DUMPBG_MESSAGESENQUEUESSIMULATE_EOVKSFQP_LIMITKSKDUMPTRACEDBSCHEDULERGRANULELISTGRANULELISTCHKSCOREBOARDGES_STATEADJUST_SCNNEXT_SCN_WRAPCONTROLFFULL_DUMPSBUFFERSRECOVERYSET_TSN_P1BUFFERPIN_BLOCKSBC_SANITY_CHECKFLUSH_CACHELOGHISTARCHIVE_ERRORREDOHDRLOGERROROPEN_FILESDATA_ERR_ONDATA_ERR_OFFBLK0_FMTCHGTR_SET_BLOCKTR_SET_ALL_BLOCKSTR_SET_SIDETR_CRASH_AFTER_WRITETR_READ_ONE_SIDETR_CORRUPT_ONE_SIDETR_RESET_NORMALTEST_DB_ROBUSTNESSLOCKSGC_ELEMENTSFILE_HDRSKRB_CORRUPT_INTERVALKRB_CORRUPT_SIZEKRB_PIECE_FAILKRB_OPTIONSKRB_SIMULATE_NODE_AFFINITYKRB_TRACEKRB_BSET_DAYSDROP_SEGMENTSTREEDUMPLONGF_CREATEROW_CACHELIBRARY_CACHESHARED_SERVER_STATEKXFPCLEARSTATSKXFPDUMPTRACEKXFPBLATCHTESTKXFXSLAVESTATEKXFXCURSORSTATEWORKAREATAB_DUMPOBJECT_CACHESAVEPOINTSOLAP_DUMP - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 9:09 PM Subject: alter system dump logfile Hi all, as mentioned in Metalink article, one can use "ALTER SYSTEM DUMP LOGFILE ... LAYER 11 OPCODE 3" to dump deleted rows from archived logs. does anyone know 1. what others layers are and what they correspond to? 2. what other opcodes are and what they relate to? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
Re: get sid (session id) and serial#?
Homes this may work select distinct s.sid,s.serial# from v$session s, V$MYSTAT m where s.sid=m.sid / - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 10:04 AM DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: How to keep root out?
Title: Re: How to keep "root" out?
Have u checked the usage of config.s
($ORACLE_HOME/rdbms/lib)
This can be use to define a dba groub at os level
which can use connect as internal..
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 29, 2003 11:54
AM
Subject: Re: How to keep "root"
out?
Hi!
But how would you restrict an user from logging
on based on OSUSER value? If you create an unhandled exception, then this
works only for users without ADMINISTER DATABASE TRIGGER privilege. The
oneswho have this priv(like sysdba priv provides)will be
able to log on without problems...
Tanel.
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 29, 2003 3:14
AM
Subject: Re: How to keep "root"
out?
Couldn't you just retrieve the column OSUSER
from V$SESSION?Perhaps something like the following:
SQL create or replace trigger
osusertrg2
after
logon3
on
database4 declare5
v_osuser
varchar2(30);6
begin7
dbms_output.enable(2);8
select distinct
decode(osuser, 'root', 'root', 'not root')9
into
v_osuser10
from
v$session11
where
audsid = userenv('SESSIONID');12
dbms_output.put_line('osuser
is "'||v_osuser||'"');13 end osusertrg;14
/Trigger created.SQL show errorsNo
errors.SQL SQL connect
scott/tigerConnected.SQL variable buffer
varchar2(100)SQL variable status numberSQL exec
dbms_output.get_line(:buffer, :status)PL/SQL procedure
successfully completed.SQL print
bufferBUFFERosuser
is "not root"Be aware that when
you are connected as SYS then all sessions have the same AUDSID and
USERENV(SESSIONID) values of 0...Hope this
helps...-Timon 8/28/03 2:34 PM, Diego Cutrone at
[EMAIL PROTECTED] wrote: I
don't know if this will work. But I'd write an external procedure (a
shell) that checks the OS userid that's logging into the
database... (may be "who am i", it works even with "su")
--- bash-2.04# id uid=0(root)
gid=0(root) groups=0(root),48(apache) bash-2.04# su - oracle
oracle::/home/oracle who am i costos!root
pts/1 Aug 28 16:45
oracle::/home/oracle --- I'd
put this code in the logon trigger. I'm not sure if this will
work with "internal" user... Greetings Diego
Cutrone Just for grins, I'll ask this question... Is
there any way to keep the Unix "root"
user from logging into the database (i.e. connect internal or /
as sysdba)? Currently using 8.1.7.4 on Solaris 8
here. We have a couple
people in our Unix admin group that vfeel
the need to "help" by writing their own DB monitoring scripts. Of course, they don't know
what they're talking about. They do not have
formal logins for the database, but
since they are root users they are connecting via "connect
internal". This is not only counterproductive but actually
a potential security issue--just because someone has
root doesn't necessarily entitle them to see the data in the
database. What if it is a payroll database? So, I'm curious, is there any way to
prevent access via "connect internal" or "/ as
sysdba"? Thanks in advance. W Internet
GRATIS es Yahoo! Conexión 4004-1010 desde Buenos Aires. Usuario:
yahoo; contraseña: yahoo Más ciudades:
http://conexion.yahoo.com.ar
Re: perl/shell script for alert log
check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993 - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 10:44 PM Subject: perl/shell script for alert log I am sure you guys might have some nice perl/shell script to analyze alert log for errors or potential problem . Can you share it with me /list . Ohh thanks in advance guys . -ak
Re: MAXTRANS ignored
Hi, You are right upto some extend. Actually while you create a table with initrans 1 and maxtrans 1. It will create table and don't show any problem. And when you try to update a record of this table lying in same block it should not let the second update transaction on same block according to your specified maxtrans( i.e. 1). But acctually the minimum value of max transaction is (2). if you set this 1 during creation of table, it will not give error , but actually it should give. If you try the 3rd update statement on record of same block it will give hang. You can try with some higher value of maxtrans value and issued total maxtrans+1 update transaction from the nth+1 transaction will hang till other transaction not commit or update. Thus it seems a bug of Oracle9i. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 2:49 AM In testing, I found that MAXTRANS seems to be ignored in 9.2.0.3. I created a table with a MAXTRANS setting of 1. I inserted some rows and committed. In one session, I updated a row, but did not commit. In another session, I updated a different row (in the same block). I expected to see a wait, but the transaction completed immediately. I dumped the block header and, sure enough, there were 2 entries in the ITL. There should be only 1 entry (as defined by MAXTRANS). Am I missing something? or have I hit an 'undocumented feature'? Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Oracle DBA e-books , must read E-books
1)Expert One-on-One (Thomas Kyte) 2) Oracle doc. performance tuning guide. 3) High Performance tuning with Statpacks. (Don Burleson) 4) Scaling Oracle8i 4) Oracle Internals Locks,latche,waits,memory (Steve Adams). And finally this mail group... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 13, 2003 5:49 PM Dear Friends, I am from India , looking for some good books on Oracle DBA , especially performance oriented. I was trying to get 1. Practical oracle 8i by jonathan 2. Oracle 9i DBA 101 3. Any good oracle Performance books. But I failed to buy in indian market. I have many Oracle Books , Oracle Press books with me , all OCP oracle corp books and STS ,Test KNIG with me. Please reply this mail if you have any of the above mentioned books for exchange. Only for exchange. Pls do not reply If you do not have the above mentioned books. Thanks Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Firewall -- ORA-12535: TNS:operation timed out
also check the value of CONNECT_TIMEOUT_lsnr, its default value is 10 (secs). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 11:04 AM Oh boy! You need to fix that firewall. You should a) allow your local nodes to go out on Oracle*Net port (and I advise against 1521, 1526 and 1527). b) allow certain IP addresses to go in your LAN by using Oracle*Net port. Second thing to do would be to have a SSL firewall and use Advanced Networking or, alternatively, configure Oracle*Net to tunnel through firewalls by using ssh. The latter is described on in the following article by R. Schrag: http://www.dbspecialists.com/presentations/net8_security.html There are tons of options for you and I could easily write an article about Oracle*Net and firewalls (Thermopilae in Greek). The best thing to do is to read a few articles about firewalls and Oracle*Net until you find something that fits your needs. It's half past midnight and I'm tired. May gods be with you. There was a guy named Leonidas who was the original security administrator at the original firewall. Be brave, your work is much easier then his was. On 2003.07.10 00:44, Bob Robert wrote: Could someone share with me if you come across similar kind of configuration. --- Mladen Gogala [EMAIL PROTECTED] wrote: You obviously do need special configuration. You are welcome. On 2003.07.08 17:09, Bob Robert wrote: All, I am getting following error message when I try to connect though firewall (from DMZ to Network). ORA-12535: TNS:operation timed out Do I need to do special configuration (like cman) around firewall? Thanks In Advance, Bob __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
tracing
Hi All, Suppose there two layer a(global ) and b(local). I have a process running on layer b. This process access both Layer b and a. and execute some sql-statement on both layer. Is there any way to identify the corresponding trace on layer a if I know the sql-tracefile on layer b? Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Bug in Execute Immediate clause???
First session:
SQL CREATE OR REPLACE procedure testing authid
current_user is 2 sql_stmt VARCHAR2(4000); 3 c
number; 4 n number; 5 a
varchar2(1000); 6 Begin 7 sql_stmt := 'Alter
Session Set Current_Schema = scott'; 8 Execute Immediate
sql_stmt; 9 Dbms_output.put_line(sys_context('userenv',
'Current_schema'));10 sql_stmt := 'Select count(*) From
temp';11 Execute Immediate sql_stmt into c;12
Dbms_output.put_line(c);13 END;14 /
Procedure created.
Second Session:
-
SQL conn test1Enter password:
*Connected.SQL exec test1.testing;
PL/SQL procedure successfully
completed.
SQL set serveroutput onSQL exec
test1.testing;SCOTT0
PL/SQL procedure successfully
completed.
SQL
in second session when you execute the procedure
the schema changed and not find the procedure in that schema
try this one.
With Regards,
Manoj Kumar Jha
- Original Message -
From:
Ranganath K
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 02, 2003 9:00
PM
Subject: Bug in Execute Immediate
clause???
Hi Listers,
The below procedure gets created
successfully in TEST Schema. But
when I execute the procedure by starting a fresh session connecting as TEST
schema I get the below error and when I execute the procedure for the second
time it executes successfully. I
have granted the dba privileges and explicit granted
select on TEMP1 to TEST Schema.
Inspite of that I am getting the below
errors. I tried this 8.1.7 and
9.2.1.0. Is it a bug in the code
or the database?
CREATE OR REPLACE procedure test
authid current_user
is
c
number;
n
number;
a
varchar2(1000);
Begin
Execute Immediate 'Alter Session
Set Current_Schema =
SCOTT';
Dbms_output.put_line(sys_context('userenv', 'Current_schema'));
Select count(*) into c From temp1;
Dbms_output.put_line(c);
End;
ERROR at line
1:
ORA-00942: table or view does not
exist
ORA-06512: at "TEST.TEST", line
9
ORA-06512: at line
1
Can anybody help me out? Any help in this regard is very much
appreciated.
Thanks and
Regards,
Ranganath
Re: Redo Copy Latch contention ??
Please see the link... Steve Adams has given lots of information on it. http://www.ixora.com.au/ Yes you have contention problem and that may be causing high CPU Utilizxation. It is not simple to analyse redo copy contention problem and soln with below data... detail investigation, you have to performed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 1:50 AM Thanks Kirti, We have HP Openview implemented on our database and hence got some alert on redo copy latch. When I have queried the database I found the contention on this latch. Yes we have other performance issues ( HIGH CPU utilization , because of lotta bad code ). and We are checking every possible contention on the database. Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Madhu Reddy X13944 -Original Message- Sent: Wednesday, July 02, 2003 1:56 PM To: Multiple recipients of list ORACLE-L According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 9433506468862115 00 redo copy 22097497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Thanks!! What are the type#'s in obj$ ?
-- Author: Manoj Kumar Jha 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).
Re: ora-4030 out of memory error
Title: RE: ora-4030 out of memory error PGA grows by using the malloc() or sbrk() system calls to extend the heap data segment for process. The new operating system vertual memory is then added to the PGA heap as a new extent. These extents are only a few kilobytes in size , and Oracle may allocate thousands of them if necessary. There are, however, operating system limits on the growth of the heap data segment of a process. In most cases the default limit is set by an OS kernel parameter(MAXDSIZ). In some cases the default can be changewd on a per-process basis. There is also system-wide limit on the total virtual memory size of all processes. That limit is related to the amount of swap space available. If either of these limit is exceeded, then the Orcale process concerned will return an ORA-4030 error. This error is only rarely dua to the per-process resource limit, and normally indicates a shortage of swap spce. To diagnose the problem use the OS facility to report swap space usage. On some OS Oracle includes a small utility called maxmem which can be used to check the maximum heap data segment size that a process can allocate, and which which limit is being hit first. If the problem is shortage of swap space, and if paging activity is moderate or heavy, then attempt to reduce the system-wide virtual memory usage. either by reducing the process count or by reducing the per-process memory usage. Otherwise, if paging activity is light or nill, you should increase the swap space or if OS supports it, enable the the use of virtual or pseudo swap space. - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 24, 2003 2:30 AM Subject: RE: ora-4030 out of memory error LeRoy, Post the query to the list. Just maybe it could tuned or give us an idea of what's going on. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: LeRoy Kemnitz [SMTP:[EMAIL PROTECTED] All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy
Re: Thanks!! What are the type#'s in obj$ ?
you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Thanks!! What are the type#'s in obj$ ?
, 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.net -- Author: Manoj Kumar Jha 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).
Duplicate column
Hi All, There is duplicate column on table 'X$KSFMLIB' and duplicate column is 'CAP_ELEM' Can any one tell me that why this so and what is significant of this table. SQL desc X$KSFMLIB Name Null?Type - ADDR RAW(4) INDX NUMBER INST_IDNUMBER LIB_IDXNUMBER VERSION_NUMVARCHAR2(32) VENDOR_NAMEVARCHAR2(64) PATH_NAME VARCHAR2(1024) PROTOCOL_NUM NUMBER LIB_NAME VARCHAR2(256) CAP_FILE NUMBER CAP_ELEM NUMBER CAP_ELEM NUMBER CAP_OTHER NUMBER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production With Regards, Manoj Kumar Jha -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha 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).
Re: Performance Problems Solaris Vs Windows
Your query is not written properly Try this one.. and try to use count(a.column_name) or count(b.column_name) instead of count(*) whatever is ur requirement. SELECT COUNT(*) FROM mam_assets a, mam_asset_attr_domain_values dmv65549 WHERE a."ID" = dmv65549.asset_id AND dmv3.domain_value_id = 71 AND dmv3.asset_attribute_xid = 3 AND dmv3.domain_xid = 7; - Original Message - From: Munish Bajaj To: Multiple recipients of list ORACLE-L Sent: Thursday, June 12, 2003 11:44 AM Subject: RE: Performance Problems Solaris Vs Windows Both the Tables have been analyzed. I'm trying to find the difference between init parameters. Regards Munish Bajaj -Original Message-From: Ishwar Tewari [mailto:[EMAIL PROTECTED]Sent: Thursday, June 12, 2003 00:30To: Multiple recipients of list ORACLE-LSubject: RE: Performance Problems Solaris Vs Windows Do u analyze both sets of tables on the different platforms at the same regular intervals? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Munish BajajSent: Wednesday, June 11, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Performance Problems Solaris Vs Windows Hi Gurus, I'm facing a weird problem. I'm running a same query on windows as well as on Solaris both having Oracle 8.0.5 database using CBO optimizer. The Query runs fine on Windows (takes 20-30 Secs) while the same hangs on Solaris and takes 4-6 hrs to return the results. Both the databases have approx same number of rows and indexes. The Query is : SELECT COUNT(*) FROM mam_assets a, mam_asset_attr_domain_values dmv65549 WHERE a."ID" = dmv65549.asset_id AND a."ID" IN (SELECT dmv3.asset_id FROM mam_asset_attr_domain_values dmv3 WHERE dmv3.domain_value_id = 71 AND dmv3.asset_attribute_xid = 3 AND dmv3.domain_xid = 7) AND a."ID" IN (SELECT dmv3.asset_id FROM mam_asset_attr_domain_values dmv3 WHERE dmv3.domain_value_id = 71 AND dmv3.asset_attribute_xid = 3 AND dmv3.domain_xid = 7) Explain Plan on Solaris 16 SELECT STATEMENT 15 SORT (AGGREGATE) 14 NESTED LOOPS 12 NESTED LOOPS 10 MERGE JOIN (CARTESIAN) 4 VIEW 3 SORT (UNIQUE) 2 TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) 1 INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) 9 SORT (JOIN) 8 VIEW 7 SORT (UNIQUE) 6 TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) 5 INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) 11 INDEX (UNIQUE SCAN), AST_PK (GMASTER) 13 INDEX (RANGE SCAN), ATRVALDOM_AST_FK_I (GMASTER) Explain Plan on Windows 15 SELECT STATEMENT 14 SORT (AGGREGATE) 13 NESTED LOOPS 11 HASH JOIN 4 VIEW 3 SORT (UNIQUE) 2 TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (QUARKDMS) 1 INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (QUARKDMS) 10 NESTED LOOPS 8 VIEW 7 SORT (UNIQUE) 6 TABLE ACCESS (BY INDEX ROWID),
