Display Oracle parameters

Last update on July 3, 2009 10:28 AM by jak58
Published by jak58

Display Oracle parameters






In addition to the file init.ora, it is possible for you to consult the database to be check out parameters such as max_open_cursors ,size of a block ...

Simply run the following command: 

SELECT name, value
FROM v$parameter
Best answers for « Display Oracle parameters » in :
Display name of the Oracle database Show Display name of the Oracle database To view the name of the Oracle databases and data related to them, simply run the command: SELECT * FROM V$DATABASE;
[Bash]Parameters Show [Bash]Parameters Intro Example 1 Example 2 Initialize parameters Examples Example 3 Intro You can provide a script on the command line and arguments also known as parameters for its implementation. There are two categories of...
Managing SQL parameters Show Managing SQL parameters SQL has a number of parameters at Oracle level that can be viewed it through the command: SHOW ALL To change the value of a parameter you can use the command: SET NAME_PARAM VALUE
Displaying video from a PC on a television screen ShowDisplaying video from a PC on a television screen TV output S-Video output Configuration under Windows FAQ You can display the output from the computer on a television (or even the sound on an amplifier). But that implies that the...
Displaying images in web browser ShowDisplaying images in web browser The Flash / Shockwave not displayed When surfing on the internet, you have surely come across small rectangles with red crosses replacing images on the web pages. This may be due to several images on...
Outlook- No image display ShowOutlook- No image display Under Windows XP Service Pack 2, you can no more open attachment because of virus infection You can disable the feature by following below procedure: (Valid for Outlook Express) Go to Menu Tools and...
Download MSN Pictures Displayer Show
Download Linux Display Driver - x86 Show
Download Desktop Album Display ShowThe access to an album (of music) of one’s choice is slow because of the music multitudes on one’s PC. Desktop Album Display is a software which allows to display on the Windows desktop the cover of your favorite albums. By clicking a cover, you...
UNIX Commands ShowTable of the main UNIX commands Unix Commands Description Options ls lists the content of a directory -a Displays all files, including hidden files -I Displays a...
Managing images in HTML ShowHow do you display images on a web page? Having a few images on a website can make it more attractive and user-friendly. However, it is important not to go overboard, since images can take a long time to load, and in some cases can make a document...
Computer screen or monitor ShowIntroduction to computer monitors A monitor (or screen) is a computer display unit. There are generally said to be two families of monitors: Cathode-ray tube monitors (or CRT for short), which are used with most desktop computers. They are...
They need your help