Geek Answers Handbook

SQL statement to display all current database properties

I tried several different ways to list db properties and got a little shorter.

SQL> SHOW DATABASE VERBOSE emp; SP2-0158: unknown SHOW option "DATABASE" SP2-0158: unknown SHOW option "VERBOSE" SP2-0158: unknown SHOW option "emp"

Here is another one that I don’t understand why its not working

  SQL> show database; SP2-0158: unknown SHOW option "database" SQL> DGMGRL SP2-0042: unknown command "DGMGRL" - rest of line ignored.

Does anyone have any ideas as to what I am missing.

+4
source share
3 answers

There's a table called database_properties - you should request that

 select property_name, property_value, description from database_properties

If this is not what you are looking for, you should be more specific.

+6
source

If you want to get full version information for your database, follow these steps:

 SELECT * FROM v$version;

If you need your database parameters, then:

 SELECT * FROM v$parameter;

If you need more information about your database instance, follow these steps:

 SELECT * FROM v$database;

If you want the database properties to be as follows:

 SELECT * FROM database_properties;

If you want the "size" of your database, this will give you a fairly close calculation:

 SELECT SUM(bytes / (1024*1024)) "DB Size in MB" FROM dba_data_files;

You will need DBA permissions to view these views, or you can request data from your database administrator, and he will (probably) oblige.

Hope this helps ...

+5
source

SHOW DATABASE not a valid SQL * Plus command.

The correct syntax is the SHOW option , where the option is one of the following:

 system_variable ALL BTI[TLE]ERR[ORS] [ { FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS } [schema.]name] LNO PARAMETERS [parameter_name] PNO RECYC[LEBIN] [original_name] REL[EASE] REPF[OOTER] REPH[EADER] SGA SPOO[L] SPPARAMETERS [parameter_name SQLCODE TTI[TLE] USER XQUERY
+1
source

More articles:


All Articles