Oracle Command .... ?

[owenyuen]

Hello all:
Is any command that I can identify the instance name, database vesion, database name and the its block size?

 

[alexhu]

UNIX or NT ?

Alex

 

[owenyuen]

Sorry, it is NT!

 

[jee]

For version and instance:

SELECT * FROM v$instance;


For block size:

SELECT value
FROM v$parameter
WHERE name = 'db_block_size';

For database name:

SELECT value
FROM v$parameter
WHERE name = 'db_name';

Must be executed by a user who has access to these SYS views.

 

[owenyuen]

Thanks for your inputs.