| Performance [message #385929] |
Wed, 11 February 2009 23:24  |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Hi All,
The database is created normally.In our database daily millions of data is getting loaded into the tables. If I want to retrive the data from tables it is taking lot of time to get the data.
Please suggest me How to improve my database performance.
|
|
|
|
|
|
|
|
| Re: Performance [message #386154 is a reply to message #385971] |
Thu, 12 February 2009 21:54  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
What the other two guys are trying to say is that Oracle Performance Tuning is a HUGE subject on which hundreds of books and millions of words have been written.
You might as well ask: I got married in the normal way; how do I understand my wife?
The answer is that you either need to help yourself (by starting to train yourself in the vast subject of Oracle Performance Tuning - you could start with the link provided above); or you need to hire a professional.
Ross Leishman
|
|
|
|
| Re: Performance [message #386164 is a reply to message #385929] |
Thu, 12 February 2009 22:51 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
In our database,I have 35 tables and using only one tablespace with the one datafile. If the data is growing more in one of the table so retrieving data to the table is taking more time. Daily millions of records are inserting.
Which one is correct option to retrieve data fastly from that table?
1) If I want to create one tablespace with the datafile and assigns new tablespace to that table?
2) If I do Hash-Partition, what is the criteria to do Hash-Partition?
|
|
|
|
|
|
| Re: Performance [message #386173 is a reply to message #385929] |
Fri, 13 February 2009 00:12 |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Thank you for your suggestion.
I have production database in other place and I am not able to access the database and not able analyze the database. I have primary key and index on that table also but it is taking more time.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
