OraFAQ Forum: Server Administration » How to see or what is query to see all parameter on Orcle DB

Home » RDBMS Server » Server Administration » How to see or what is query to see all parameter on Orcle DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to see or what is query to see all parameter on Orcle DB [message #196366]

Thu, 05 October 2006 02:32

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm

Report message to a moderator

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

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

easonmy
Messages: 1
Registered: September 2006

Junior Member

select ..
from v$parameter
where ....

Report message to a moderator

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

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Plus above method.
see also v$spparameter views.

Report message to a moderator

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

saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore

Junior Member

Thanks Every one,I get what i want

Report message to a moderator

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

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;

Report message to a moderator

Previous Topic:	Dropping datafile
Next Topic:	How to recover 9i UNDO datafile damage?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 00:06:05 CST 2025