Home » RDBMS Server » Performance Tuning » How can I do like this?
How can I do like this? [message #229791] Tue, 10 April 2007 01:26 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
When I read tuning document from my friend company, I found that some informations, then I ask myself how did they do it?

Please reply me..Thank you very much!
Re: How can I do like this? [message #229795 is a reply to message #229791] Tue, 10 April 2007 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Windows perf stat in registry?
Windows monitor?
Statpack?
Query v$ views?
Many ways to do it.
Many ways to get different numbers. Evil or Very Mad

Regards
Michel
Re: How can I do like this? [message #229876 is a reply to message #229791] Tue, 10 April 2007 03:55 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thanks for your reply!

I would like to retrieve them using query dynamic view (V$)

Thanks again!
Re: How can I do like this? [message #229881 is a reply to message #229876] Tue, 10 April 2007 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
v$filestat
disk utilization is not available from Oracle.

Regards
Michel

Re: How can I do like this? [message #229886 is a reply to message #229791] Tue, 10 April 2007 04:23 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thanks so much!
How about disk utilization would I like to retrieve info?
Re: How can I do like this? [message #229902 is a reply to message #229886] Tue, 10 April 2007 05:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Windows performances counter I think.
Regards
Michel
Re: How can I do like this? [message #229932 is a reply to message #229791] Tue, 10 April 2007 06:05 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Michel! Thank you very much...
And, would I like to ask you one question : "What is city the Louver museum is in?" Smile
Re: How can I do like this? [message #229947 is a reply to message #229932] Tue, 10 April 2007 06:40 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Le Louvre is in Paris. Razz

Regards
Michel
Previous Topic: decode
Next Topic: can any one tell what is the order of execution of a query
Goto Forum:
  


Current Time: Wed Nov 27 01:53:14 CST 2024