SQL & PL/SQL

Hi,

I am facing a very serious problem here , I have Oracle 11g R2 x64 for my product and one of my client using that product
, but the size of the data base is going to be very large day by day.Because of that my product is running very slow and our client having lots of problem because of that. So I have to solve this problem.

Please tell me how to manage large database why it is running very slow, my DB has total 800 tables with lots of constraints dependencies.

To make it work fast I have run some alter commands as fallows:

alter system set processes=300 scope=spfile;
alter system reset sessions scope=spfile sid='*';
alter system set sessions=300 scope=spfile;
alter system set open_cursors=900 scope=both;
alter system set sga_max_size=3439329280 scope=spfile;
alter system set sga_target=2147483648 SCOPE=BOTH;
alter system set statistics_level = TYPICAL Comment='Compiere' SCOPE=BOTH;

but after running these commands i felt no difference in speed or performance. Please tell me how to increase performance of my currently running database.

Now in oracle 11g R2 some new features has included like while running exp command it will not export those tables who has empty rows, so because of this my constraints rules get violated while restoring.

I search the solution for this in google and i found that there is a globe variable called:
"deferred_segment_creation"

alter system set deferred_segment_creation=false;

I ran this command but still its exp command is not exporting tables with empty rows.

I got stuck over here please tell me the solution for this will be really helpful for me.

Thanks & Regards,
Manu Sijaria.