Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rwozniak71
  • Content: Threads
  • Order by date
  1. rwozniak71

    ORA-04030 out of process memory error

    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...
  2. rwozniak71

    Is there a limit on the number of joins in a query?

    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...
  3. rwozniak71

    Delete of small subset on large table

    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...
  4. rwozniak71

    Delete of very large table

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

Part and Inventory Search

Back
Top