DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Server

  1. #1
    Join Date
    May 2006
    Posts
    41

    Server

    1. How to find IP address of Oracle server from oracle client?

    2. How to find the Server model & no of CPUs of that server from oracle client?

    3. Is it possible to find the total storage capacity of that server from oracle client?

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    uhhh don't you think it would be much easier to gain that information by logging onto the Oracle server directly?
    But anyway.

    1. tnsping
    2. can't do
    3. can't do
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    2 and 3 you cant, 1 you can get the hostname

  4. #4
    Join Date
    May 2006
    Posts
    41
    By being in server,which command do i've to
    use to know answer for the 2nd question?

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you cant find that out from the database (cpu_count might give you a good guess on the number of CPU's though)

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    "server" is a universal term! There is no single command for all servers !! Please understand how to ask questions!!!
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width