Home » SQL & PL/SQL » SQL & PL/SQL » how to get system Specification through pl/sql
how to get system Specification through pl/sql [message #305825] Wed, 12 March 2008 02:34 Go to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Hi everyone,

i would like to know that how we can get system specification through pl/sql e.g. harddisk size, ram size, network card etc

any help will be appreciated

Regards,
Kashif Ali

Re: how to get system Specification through pl/sql [message #305826 is a reply to message #305825] Wed, 12 March 2008 02:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why would you want to use PL/SQL for that?
Remember that PL/SQL runs on the server, inside the database, so it is impossible to get those data from the client.
Re: how to get system Specification through pl/sql [message #305830 is a reply to message #305826] Wed, 12 March 2008 02:47 Go to previous messageGo to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
we in a network environment want to know whats the specs of each system using pl/sql rather than going to each person individually, as we are talking about more than 500 pc's distributed

and we can use sys_context funtion in sql to get ip, loginid, pc name of each client from database then there must be someway i can get the mentioned one items from database side
Re: how to get system Specification through pl/sql [message #305832 is a reply to message #305830] Wed, 12 March 2008 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
then there must be someway i can get the mentioned one items from database side

No there is not.
The information you get in sys_context are sent by the client at connection time (and not got by the database). They are the only ones available.

Regards
Michel
Re: how to get system Specification through pl/sql [message #305858 is a reply to message #305830] Wed, 12 March 2008 04:01 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Of course you realize that "each system using pl/sql" is exactly one system: the server.

The client isn't using pl/sql, it is executed on the server.

Previous Topic: specified initialization parameter cannot be modified
Next Topic: count the number of 'I'
Goto Forum:
  


Current Time: Wed Dec 07 02:55:46 CST 2016

Total time taken to generate the page: 0.05049 seconds