Home » SQL & PL/SQL » SQL & PL/SQL » Statspack (merged by MHE)
Statspack (merged by MHE) [message #275597] Mon, 22 October 2007 00:31 Go to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

hii

i have run the following report in the database

@$ORACLE_HOME/rdbms/admin/spreport.sql

can anyone provide me where this report is stored after it is
executed.

thanks in advance
Re: Statspack report [message #275604 is a reply to message #275597] Mon, 22 October 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It can be:
- in the path you give when you was asked
- in the current directory
- in the directory of your sqlplus
- in $ORACLE_HOME/bin or database or dbs

Regards
Michel
statspack [message #275658 is a reply to message #275597] Mon, 22 October 2007 04:19 Go to previous messageGo to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

hii everyone

i have configured statspack in the database

1.conn /as sysdba
2 created tablespace perfstat
3$O_H/rdbms/admin/spcreate.sql
4.conn perfstat/perfstat


after this i have run this report

@$O_H/rdbms/admin/spreport.sql
this report is succefully running but i want to know where this
report will be stored

please reply to me
thanks in advance


Re: statspack [message #275664 is a reply to message #275658] Mon, 22 October 2007 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See my previous answer.

Regards
Michel
Re: statspack [message #275674 is a reply to message #275664] Mon, 22 October 2007 05:28 Go to previous messageGo to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

sorry i dnt see your answer

ya i have chk tht bin,database & dbs directory the

report which i specified is not there.

thanks for your reply
Re: statspack [message #275675 is a reply to message #275674] Mon, 22 October 2007 05:30 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And the current directory? The one from where you fired SQL*plus?

MHE

PS: dnt? chk? Try to use real words in your replies. IM speak is not very polite. Wink
Re: statspack [message #275683 is a reply to message #275675] Mon, 22 October 2007 06:05 Go to previous message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

yep i got the report
many thanks....I try to be more clear & polite
Best regards
mujtaba
Previous Topic: Dynamic declaration of %rowtype
Next Topic: want solution of date format
Goto Forum:
  


Current Time: Mon Dec 05 08:57:40 CST 2016

Total time taken to generate the page: 0.07883 seconds