Recent content by rwozniak71

OK Dima, Here's the query (generated by Hyperion EIS): SELECT AM.ACCT_MEMBER , LM.LOC_MEMBER , SFD.DEPARTMENT , SFD.CATEGORY , SFD.JE_SOURCE , SFD.SL_BATCH , SFD.JE_JEADER_DESC , SFD.POSTED_AMT , TM.TIME_MEMBER , SFD.POSTED_DATE , SFD.ACCOUNTING_PERIOD , SFD.COMPANY , SFD.ACCRUAL...

Thanks Everyone, The problem is we're using a third party tool to generate the queries and we can't customize the query at all. So using hints and avoiding use of 'IN' to specify ranges won't work. I get the error when I run an explain plan using the cost based optmizer. We are on an AIX...

I think it's a problem with the number of rows in the table we're querying. I have a smaller table (fewer rows and fewer columns) but all the same keys so I can "replace" it in my queries. Typically I get no problems. I'm thinking some setting in the SGA is not large enough. We tried changing...

Thanks Dima, I found this white paper on otn that suggests looking at the SORT_AREA_SIZE parameter when working with these types of errors: http://www.oracle.com/technology/oramag/oracle/02-jul/o42tuning.html I've updated the Statistics to no avail. I'm not able to perform an explain plan-the...

Hey Folks, Does anyone have experience with this error (I pulled a posting off an Oracle site): ORA-04030 ORA-04030: out of process memory when trying to allocate string bytes (string,string) Cause: Operating system process private memory has been exhausted. Action: See the database...

Thanks sem, but what does this mean? Is this a parameter to set on the optimizer? My query looks like this: SELECT DISTINCT ac."ACCT_MEMBER", aa."DEPARTMENT", aa."CATEGORY", ai."LOC_MEMBER", aa."POSTED_AMT", ae."TIME_MEMBER", al."STYL_MEMBER", al."STYL_MEMBER_DESC", am."VNDR_MEMBER"...

Thanks Santa, I guess it's back to the drawing board, then! I'll try playing with the order of the columns in the where clause. Anything else you can think of? R

Hi Folks, I'm working with a client that uses a third party tool (Hyperion EIS) to generate "drill-through" queries against a very large Oracle table (approx. 150,000,000 rows). We have a partition and an index defined on the table to help query performance. For the most part, performance is...

Hello Folks, I need to delete and reload a small subset of data (3-4,000,000 rows) from a very large table (140,000,000 rows). The large table had indexes and a partition (that cannot be truncated for this purpose). Any advice on an approach? Most of what I found seems to take forever (cursor...

Thanks. That's actually the strategy I've decided on but am having trouble explaining to the DBA's why I need (temporarily) all that extra disk space (I estimate about 40GB).

Thanks, but I don't want to truncate this table, just delete a small number of rows.

The admins (you mean DBA's, right?) should get enterprise manager which has some good GUI features for viewing session activity, database configuration info., and the like. If you buy the full DBA version of Toad, you'll probably find their DBA features easier to use.

Hi Folks, I have a very large table with approximately 150 million rows at 300 kb each. I need to delete 4.3 million or so "junk" transactions and the deletes are taking so long the delete process would need to run for a week or so. Any suggestions on how to speed things up? Here are some...