Forum Stats

  • 3,824,946 Users
  • 2,260,442 Discussions
  • 7,896,356 Comments

Discussions

Veryuseful show command to know variables or status.

Raul.Alvarenga
Raul.Alvarenga Member Posts: 98 Bronze Badge
edited Nov 1, 2019 11:14AM in Database Ideas - Ideas

Hi, ithink, will be very useful  an existance of show commands  in sqlplus o any database client connection in or order to know, several status, without type a robust query  for example

actually there are commands:

show sga

show user

show con_name

archive log list

why could not have

show role ,  in order to know database role in a standby environment.

show fra , in order to know flash or fast recovery area usage

show status, in order to know , status for instance

and now, this command could be executed on rman o sqlplus prompt.

Regards

Saludos.

Raul.Alvarenga
2 votes

Active · Last Updated