| sri |
Posted: Dec 27, 2007 06:13:17 AM |
Total Post: 13
Joined: Sep, 2007
|
Hi all
what is the difference between statspack and AWR report
can we have statspack report in oracle 10g?
|
|
|
 Babu |
| Posted: Dec 27, 2007 06:23:25 AM |  |
|
Total Post: 92
Joined: Oct, 2007
|
Yes you use statspack in 10g also.
AWR - It's new feature in oracle 10g.
Babu
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 27, 2007 11:16:46 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
As babu said,
AWR report is new option in 10g. and it is easy to read and look.
AWR report available in HTML or TEXT format.
http://dbataj.blogspot.com/2007/10/awr-reportsnapshot.html
|
|
|
|
|
| MOH_DBA |
| Posted: Dec 27, 2007 01:25:13 PM | |
|
Total Post: 124
Joined: Nov, 2007
|
as mentioned above yes you can.
the difference between them is that the staspack calculate statistics for you between the snapshots you specify which make it easy to see and read and compare statistics results.
and if you want to make awr report you must execute the (awrrpt.sql) file in the rdbms in your oracle home.
to view statspack reports you must execute the (spreport.sql) file in the rdbms in your oracle home.
|
|
|
|
|
| sri |
| Posted: Dec 28, 2007 01:15:34 AM | |
|
Total Post: 13
Joined: Sep, 2007
|
Hi MOH_DBA
thanks for your response
i am able to get the awr report in my 10g database
but i am unable to get the statspack report in the same
i am getting the following error
SQL> @$ORACLE_HOME/rdbms/admin/spreport.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
310852860 ****** 1 *****
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from stats$database_instance
*
ERROR at line 7:
ORA-00942: table or view does not exist
Using 310852860 for database Id
Using 1 for instance number
from stats$database_instance
*
ERROR at line 5:
ORA-06550: line 5, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 4, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 11, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 10, column 6:
PL/SQL: SQL Statement ignored
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
|
|
|
|
|
| Murtuja |
| Posted: Dec 28, 2007 01:37:17 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Sri,
You need to follow certain steps before generating statspack report.You will find steps from below link.
http://www.akadia.com/services/ora_statspack_survival_guide.html
But Statspack report is not required in Oracle 10g.AWR is the best in Oracle 10g.
|
|
|
|
|
| sri |
| Posted: Dec 28, 2007 01:59:03 AM | |
|
Total Post: 13
Joined: Sep, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
