Oracle
in [SQL]
|
Hash join order Hi, We are using Oracle 10.2.0.3.0. I have a simple query like this - select * from large_table, small_table where small_table.col = large_table.col (+) large_table has 140 million rows. Small table can have any number of rows.I am posting the execution plan for different scenarios where small table has di... 27 Jun 2008 18:19
WPG_DOCLOAD Package RE: wpg_docload / Oracle 10g / Windows XP / IE7 We have an Oracle 10g application, built using Oracle PL/SQL Toolkits and PSPs, using an Oracle database with an HTML front-end (hosted by an Apache web server). We use the WPG_DOCLOAD package to upload and download attachments to/from the database (i.e. Excel and W... 25 Jun 2008 16:02
MWA question Hello. I am in the middle of an oracle e-business suite implementation. I have a "HandHeld" barcode scanner that is running Windows mobile 5. So far, I have tried a free JVM called mysaifu but have been unable to connect, although I can connect from my pc using an emulator. I have also tried running putty f... 25 Jun 2008 17:04
Huge Execution Plan Cost Change For Fixed Tables Hi, We are using certain sql to get the column information for a group of tables (in Oracle 10gR2 database). The sql is based on the underline Oracle data dictionary tables/views and it is taking a huge amount of time to execute only after the recent restoration of our development database. The sql being used... 25 Jun 2008 15:00
Please DON'T Vote for AMIN!! EVER!!!! On Jun 24, 9:28 pm, vote4amin <vote4a...(a)gmail.com> wrote: Dear frens, No one is your 'fren' here, especially after this wanton display of total disregard to this newsgroup. Oh, and also for your dismal spelling. Need your help to spend a minute of your time to vote for my little boy in Cutefam 2008... 25 Jun 2008 11:54
sol 10 3 disks and 10G ASM Hello, Have a development box to get together. Later a production box will be provided. Idea is to craete a scalable solution for say 18 months worth of data say 400Gb, but initially on a oldish Sun 440 with 3 X 18 GB disks which migh hold 1--2 months data - it grows linearly. So anyway we have 3 disks, disk1 f... 26 Jun 2008 01:16
student question: incremental backups (level 0 and level 1) Hi so far my oracle experience has been on 8i with only PL/SQL development on 9 and later. I'm just going through some questions in preparation for a 10g Admin 1 exam and find (among others) a question for which the answer seems to be less than right. Of course I can simply memorize the answer, but in the ... 27 Jun 2008 12:08
ORA-01801: date format is too long for internal buffer (stored procedure called from Java using decode) They are Oracle date datatype. Maija-Leena "Frank van Bortel" <frank.van.bortel(a)gmail.com> wrote in message news:7bb63$4861f2f8$524b5c40$13949(a)cache2.tilbu1.nb.home.nl... Maija-Leena wrote: Hi, I'm calling a database procedure from Java and I sometimes get ORA-0180 from this update: ... 25 Jun 2008 04:43
ORA-01801: date format is too long for internal buffer (stored procedure called from Java using decode) Hi, I'm calling a database procedure from Java and I sometimes get ORA-0180 from this update: UPDATE table1 SET date1=DECODE(date1,NULL,SYSDATE,date1), date2=SYSDATE WHERE ... What makes this difficult is that most of the time this works even with the very same row (it has a valid datevalue in date1). I... 25 Jun 2008 15:00
Usability Evaluators Sought for IBM Data Modeling and DBA Tools This is part time only. As part of IBM's User-Centered Design group. We are currently looking for database architects/modelers and administrators with a minimum of 5 years of enterprise experiences, to evaluate the usability of IBMs Data Studio products. If you are chosen as a participant, you will be asked t... 25 Jun 2008 01:40 |