Home » RDBMS Server » Server Administration » How to see or what is query to see all parameter on Orcle DB
How to see or what is query to see all parameter on Orcle DB [message #196366] Thu, 05 October 2006 02:32 Go to next message
saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore
Junior Member
Hi all

I Installed oracle sofoware only,after that some other created DB(Instance)

Now i want see parameter on that db using sqlplus
parametrs like .dat file size,log file size,etc...


can some help me in this issue


thanks in advance
sreenivasarao


Re: How to see or what is query to see all parameter on Orcle DB [message #196440 is a reply to message #196366] Thu, 05 October 2006 06:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm
Re: How to see or what is query to see all parameter on Orcle DB [message #196598 is a reply to message #196366] Fri, 06 October 2006 02:27 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
sql> show parameters;

Kr
Karel

[Updated on: Fri, 06 October 2006 02:27]

Report message to a moderator

Re: How to see or what is query to see all parameter on Orcle DB [message #196818 is a reply to message #196598] Sat, 07 October 2006 21:21 Go to previous messageGo to next message
easonmy
Messages: 1
Registered: September 2006
Junior Member
select ..
from v$parameter
where ....
Re: How to see or what is query to see all parameter on Orcle DB [message #196824 is a reply to message #196366] Sun, 08 October 2006 00:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Plus above method.
see also v$spparameter views.
Re: How to see or what is query to see all parameter on Orcle DB [message #196934 is a reply to message #196366] Mon, 09 October 2006 04:40 Go to previous messageGo to next message
saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore
Junior Member
Thanks Every one,I get what i want
Re: How to see or what is query to see all parameter on Orcle DB [message #197028 is a reply to message #196366] Mon, 09 October 2006 11:05 Go to previous message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

to see all parameter
sql>sho parameter;

to check the size of db

1.SQL> SELECT SUM(BYTES)/1024/1024/1024 "GB" FROM DBA_DATA_FILES;

2.SQL> select nvl(sum(bytes),0)/1024/1024/1024 "gb"
from dba_temp_files;

3.SQL> select sum(bytes)/1024/1024 "meg" from sys.v_$log;
Previous Topic: Dropping datafile
Next Topic: How to recover 9i UNDO datafile damage?
Goto Forum:
  


Current Time: Fri Dec 02 20:55:13 CST 2016

Total time taken to generate the page: 0.11376 seconds