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

Re: alter system dump logfile

Title: alter system dump logfile Please check : oradebug DUMPLIST as given below... SQL oradebug

Re: get sid (session id) and serial#?

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

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

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

Re: MAXTRANS ignored

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

Re: Oracle DBA e-books , must read E-books

(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

Re: Firewall -- ORA-12535: TNS:operation timed out

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

tracing

-- 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

Re: Bug in Execute Immediate clause???

, 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

Re: Redo Copy Latch contention ??

). 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

Re: Thanks!! What are the type#'s in obj$ ?

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

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

Re: Thanks!! What are the type#'s in obj$ ?

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

Re: Thanks!! What are the type#'s in obj$ ?

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

Duplicate column

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

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