Re:StoredProc SQL statistics

- Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

StoredProc SQL statistics

online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

pl/sql engine doubt

on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE:connecting session to sqlarea to find the sql_text

Welcome mate , Same question I posted a month back First get the select osuser,sid from v$session; then use sid in foll. query SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = sid_number) --- sam d

V. Urgent - Got Stuck with trigger

__ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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

RE: Why DDL is not allowed in PL/SQL

: 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

RE: Performance Tuning and Backup Recovery

. Are you using RMAN for backups. If so look into tablespace recover. If not restore your backups to a development/test server recover the tablespace and associated data. Export/Import to your other machine. -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: Once again : Oracle vs Sql Server

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

RE: Basic Question Again

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

RE: Can we find SQL user

Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Subject: Can we find SQL user Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect

RE: Can we find SQL user

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

[no subject]

- 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

Can we find SQL user

__ 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

RE: Archive log full

__ 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

Archive log full

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

RE: SQL -Can this be done in a single query

( select 1 from t2 where t2.c2=t1.c2 union select 1 from t4 where t2.c4=t4.c4 ) Regards Bhulu --- sam d [EMAIL PROTECTED] wrote: Bhulu,Amit your sol. is correct in the context ,But I forgot to mention(my apologies) that :if T1 has record which does not have corresponding entries

VAX float to IEEE float

Hi , Did any one of u faced the problem of migrating VAX/VMS files having - float datat(8-bytes) to oracle8i(windows NT) platform. When using sqlldr for the same, there is a problem that VAX/VMS has different format for storing float data, and sqlldr expects it to be in IEEE format. any help is