|
Solution Search:
Most Popular
|
Related Expert Advice
Add or drop inactive online redo log files
Can we add or drop (inactive) online redo log files at the open stage?
I have been known to do this from time to time. On occasion, I have been required to move the online redo logs from one disk volume to another. Not wanting to schedule downtime for this action, I... More... Aug 15, 2007
Getting ORA-01000 error when all statements and result sets are closed
I am getting ORA-01000 error, although I have properly closed all the statements and result sets. Also OPEN_CURSOR is set to 500. I am using Oracle 8.1.7. Please help! Check your code again; you may still have cursors and/or result sets that are not being closed. You can use...
More...
Jan 19, 2006
Optimizing query performance
code = :comp_code and a.vc_comp_code=b.vc_comp_code and a.vc_item_code=b.vc_item_code and nvl(a.nu_year_open_balance,0)<>0 and b.vc_item_group=:item_group and dt_fin_start_date=:start_date
Mst_item has 4 lakhs rows and mst_month_summary has 8 lakh rows. There is primary key index on mst_item(vc_comp_code,vc_item_code) and on mst_month_summary it's... More... Mar 22, 2004
Related Solution Center
Mobile middleware vendors are a strong alternative to high-profile partnerships like RIM and SAP
Even as RIM focuses on encouraging more third-party BlackBerry development, middleware specialists still play an important enterprise role...
More...
May 28, 2008
Oracle further unwraps Fusion, nips at SAP
Fusion project this week, outlining what the company has done over the last year to launch middleware components and develop new applications using technology from its nearly $19 billion in acquisitions.
Oracle put nearly a dozen executives on stage during an event in San Francisco designed... More... Jan 19, 2006
Oracle-BEA deal gets the green light
the BEA stockholders, who on Friday morning will vote on Oracle's $17 per share offer for the middleware giant -- an offer that was initially rejected but ultimately accepted by BEA's board of directors under pressure from Carl Icahn, a major technology investor and BEA's biggest stockholder.
... More... Feb 28, 2008
|