SQLPlus Hangs When I enter the credentials in SQL Plus, it hangs. This happens both in the server machine (Oracle 10.2.0) and the clients. But I am able to login using the command prompt in the server. Tnsping works correctly. Nothing is logged in the alert log for the login attempt. Any ideas? Here is an excerpt of the ... 27 Dec 2007 14:00
What is the difference between this two SQL? Group, I would like to update table test from test1. But I do not understand why we need to use where exists subquery SQL> select * from test; ID COL1 ---------- ---------- 1 a1 2 b1 3 c1 4 d1 SQL> select * from test2; ID COL1 ---------- -------... 9 Dec 2007 23:58
Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE Hello After Upgrading a commercial application from 9.2.0.5 to 10.2.0.3 we got a disastrous performance, even though the new server was at least 10 times faster (in terms of CPU). The application manager did not follow test procedures prior to the upgrade, which lead us to a crisis. After some investigation I... 9 Dec 2007 23:58
BULK UPDATE with FORALL Oracle 10.2.0.3, Windows Server 2003 Can anybody explain to me why I'm getting an error stating that element at index does not exist with the code below? I'm using INDICES OF which I thought was supposed to take care of that. DECLARE TYPE t_source_rec IS RECORD ( clm_src clm_hdr.clm_src%TYPE,... 9 Dec 2007 23:58
Sql*Loader, Bequeath and ulimit Hello, We just experienced the following ulimit event in a production Sql*Loader run, and I am looking for your help in understanding why it is as we saw. Oracle EE 817(a)AIX5L. Ulimit for Oracle for fsize is unlimited, ulimit fsize for user that calls sqlldr is 2 GB. We insert (not direct path) and connect using... 9 Dec 2007 23:58
SGA hello, my database has been shudwon. i would like to connect to my database(taping sqplus connect/ asystem............. ) it, but i have 2 errors : - ora-01034 : oraclenot available -ira-27101 shred memory realm does not exaist. wha can i do to connect on my dataabse? can you help me to configure my sga ,pleas... 9 Dec 2007 23:58
CBO choose full table scan, not index Hi All, I have one query SELECT * FROM GASSET_MASTER WHERE SERV_PROV_CODE = 'TEST' AND G1_ASSET_GROUP = 'LINE' AND ROWNUM < 101 ; ROWCNT is 1071973 INDEX: GASSET_MASTER_UIX (SERV_PROV_CODE, G1_ASSET_GROUP, G1_ASSET_TYPE) The query chooses table scan and not use index. The following are 10053 trace o... 9 Dec 2007 23:58
need 9.2.0.5 windows client I need to install the windows client 9.2.0.5 for version compatibility of a vendor software package. I'm looking through our old disks and all I can find is a disk for 9.2.0.1. I'm looking on OTN and metalink downloads and I can't find a patch number or a download for 9.2.0.5. Can someone point me in the right dire... 13 Nov 2007 08:27
UTL_FILE ORA-29280: invalid directory path I'm using 10g. I keep getting a ORA-29280: invalid directory path when trying to open a file (I have to login as sysdba to even see UTL_FILE, but that's another story). I created the directory D:\oracle files I added this line to the end of init.ora: UTL_FILE_DIR = 'D:\oracle_files' Then, this happen... 15 Nov 2007 11:23
orion tool errors (storax_aiowait) All, I'm unable to get orion (oracle i/o numbers tool) to run a test to completion on a Dell PowerVault MD3000i unit, and would appreciate any pointers you can provide (perhaps I'm missing a magic rpm??) NOTE: orion on this server runs fine against other storage, such as HP StorageWorks MSA-1000 Platform De... 23 Oct 2007 11:26 |