| prash |
Posted: May 22, 2008 12:50:54 AM |
Total Post: 11
Joined: Mar, 2008
|
hi,
can anyone tell me which query we can use to check the frequently running queries so that we can create materialized view for that query so to avoid full table scans all the time, but we need to know which are those queries & i want that query thru which i can get the details of frequently running queries.plz tell me whats tat query is |
|
|
 Murtuja |
| Posted: May 22, 2008 01:37:07 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
You really don't need Materialized views for this purpose.Materialised view are useful when you have distributed environment.
Learn more about Materialised view
http://www.databasejournal.com/features/oracle/article.php/2192071
And if you want to optimize performance of Oracle database then you have to follow certain steps.
1. The Oracle RDBMS allows you to collect statistics of many different kinds as an aid to to improving performance.
execute dbms_stats.gather_schema_stats(ownname => ‘scott’,estimate_percent => dbms_stats.auto_sample_size,method_opt=>‘for all columns size auto’, cascade=>true);
2. Generate statspack report and upload your report to this site.
http://www.dbapool.com/analyzer/
Get free Database Tuning recommendations from instantly from our online analyzer. Just Upload your AWR or Statspack report and get recommendations. It is fast, free and easy
|
|
|
|
|
| prash |
| Posted: May 22, 2008 01:45:05 AM | |
|
Total Post: 11
Joined: Mar, 2008
|
yaaah thanks but in our company database we are not using materialized views which is ver important so that y how to use materialized views
|
|
|
|
|
| prash |
| Posted: May 22, 2008 01:48:06 AM | |
|
Total Post: 11
Joined: Mar, 2008
|
and another thing if u have that query i need that i want to check the frequently running queries
|
|
|
|
|
| Murtuja |
| Posted: May 22, 2008 01:54:03 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
You will get all top resource consuming query from statspack report.After getting all queries,You have to create proper indexes so you can avoid full table scan.
|
|
|
|
|
| prash |
| Posted: May 22, 2008 02:15:04 AM | |
|
Total Post: 11
Joined: Mar, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
