梦到别人吵架自己劝架:To Show SGA Parameters and Statistics
来源:百度文库 编辑:偶看新闻 时间:2024/04/29 03:12:39
Script: To Show SGA Parameters and Statistics [ID 1020076.6]
修改时间 30-JAN-2011 类型 SCRIPT 状态 ARCHIVED
Checked for relevance on 21-Dec-2007
Abstract
Reports parameters and statistics related to the System Global Area.
Product Name, Product Version
Oracle Server, 7.3.x to 9.x
Platform Platform Independent
Date Created 15-Jun-2000
Instructions
Execution Environment:Access Privileges: Requires select privileges on privileges on V$SGA, V$LIBRARYCACHE.Usage: sqlplus / @[SCRIPTFILE] [report_comment] where report_comment is a Text String to display at the beginning of the report to help identify the system.Instructions: Run the script from SQL*Plus connected as a user with select privileges views V$SGA, V$LIBRARYCACHE.PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and operating systems handle text formatting (spaces, tabs, and carriage returns), this script may not be in an executable statewhen you first receive it. Check over the script to ensure that errors ofthis type are corrected.
Description
The script generates a report of the current values of thedatabase initialization parameters and statistics related to theSGA.Sample Output============= Current SGA Parameters Page: Date - Saturday 27th July 1996 13:18:26 At - TFTS_TEST Username - SYS Parameter Name Value ----------------------------- ----------------------------- async_write Boolean FALSE audit_file_dest Character ?/rdbms/audit audit_trail Character NONE background_core_dump Character full background_dump_dest Character /u02/oracle/V7.1.6/rd ... Current SGA Storage Summary Page:1 Size Size SGA Segment (Bytes) (Kb) -------------------- ----------- --------- Fixed Size 49,852 48.7 Variable Size 10,266,904 10,026.3 Database Buffers 6,553,600 6,400.0 Redo Buffers 8,192 8.0 ----------- --------- sum 16,878,548 16,483.0 Current SGA Library Summary Library Get Hit Pin Hit Name Gets Ratio Pins Ratio Reloads Invalid ------------ ------ ------- ---------- ------- ------- ------- Sql Area 8,879 0.94 30,140 0.96 116 93 Table/Proc. 4,201 0.86 3,704 0.80 23 0 Body 45 0.64 46 0.43 0 0 Trigger 5 0.40 6 0.50 0 0 Index 64 0.30 64 0.30 0 0 Cluster 27 0.44 15 0.33 0 0 Object 0 1.00 0 1.00 0 0 Pipe 0 1.00 0 1.00 0 0 The pin hit rate should be high (close to 1)
References
Script
SET ECHO off REM NAME: TFSSGAPR.SQL REM USAGE:"@path/tfssgapr" REM ------------------------------------------------------------------------ REM REQUIREMENTS: REM SELECT on V$SGA, V$LIBRARYCACHE REM ------------------------------------------------------------------------ REM AUTHOR: REM G. Godart-Brown REM Copyright 1991, Oracle Corporation REM ------------------------------------------------------------------------ REM PURPOSE: REM Reports parameters affecting the SGA and stats on effectiveness. REM REM REM ------------------------------------------------------------------------ REM DISCLAIMER: REM This script is provided for educational purposes only. It is NOT REM supported by Oracle World Wide Technical Support. REM The script has been tested and appears to work as intended. REM You should always run new scripts on a test instance initially. REM ------------------------------------------------------------------------ REM Main text of script follows: SET ECHO OFF spool tfssgapr.lst ttitle cen 'Current SGA Parameters' - right 'Page:' format 999 sql.pno skip skip set feedback off btitle off column nline newline set pagesize 54 set linesize 78 set heading off set embedded off set verify off accept report_comment char prompt 'Enter a comment to identify system: ' select 'Date - '||to_char(sysdate,'Day Ddth Month YYYY HH24:MI:SS'), 'At - '||'&&report_comment' nline, 'Username - '||USER nline from sys.dual / prompt set embedded on set heading on set feedback 6 column name format a36 heading 'Parameter Name' wrap column val format a36 heading 'Value' wrap select name ,lpad(decode(type,1,'Boolean',2,'Character',3,'Integer',4,'File',null),9) ||' '||value val from v$parameter order by 1; set embedded off set newpage 2 pagesize 16 lines 78 ttitle cen 'Current SGA Storage Summary' - right 'Page:' format 999 sql.pno skip skip set newpage 2 pagesize 16 column name format a20 heading 'SGA Segment' column value format 9,999,999,990 heading 'Size|(Bytes)' column kbval format 9,999,990.9 heading 'Size|(Kb)' break on report compute sum of value kbval on report set newpage 0 select name ,value ,round(value/1024,1) kbval from v$sga / ttitle cen 'Current SGA Library Summary' set newpage 3 set pagesize 60 column library format A15 heading 'Library|Name' column gets format 9,999,999 heading 'Gets' column gethitratio format 990.99 heading 'Get Hit|Ratio' column pins format 9,999,999 heading 'Pins' column pinhitratio format 990.99 heading 'Pin Hit|Ratio' column reloads format 99,999 heading 'Reloads' column invalidations format 99,999 heading 'Invalid' select initcap(namespace) library, gets, gethitratio, pins, pinhitratio, reloads, invalidations from v$librarycache / prompt prompt The pin hit rate should be high (close to 1) prompt prompt End of Report spool off; set termout off; clear break column sql ttitle off btitle off set newpage 0 pagesize 56 lines 78 set termout on feedback 6
Disclaimer
EXCEPT WHERE EXPRESSLY PROVIDED OTHERWISE, THE INFORMATION, SOFTWARE,PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. ORACLE EXPRESSLY DISCLAIMSALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOTLIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULARPURPOSE AND NON-INFRINGEMENT. ORACLE MAKES NO WARRANTY THAT: (A) THE RESULTSTHAT MAY BE OBTAINED FROM THE USE OF THE SOFTWARE WILL BE ACCURATE ORRELIABLE; OR (B) THE INFORMATION, OR OTHER MATERIAL OBTAINED WILL MEET YOUREXPECTATIONS. ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE DOWNLOADED OROTHERWISE OBTAINED IS DONE AT YOUR OWN DISCRETION AND RISK. ORACLE SHALL HAVENO RESPONSIBILITY FOR ANY DAMAGE TO YOUR COMPUTER SYSTEM OR LOSS OF DATA THATRESULTS FROM THE DOWNLOAD OF ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE.ORACLE RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THE SOFTWARE AT ANYTIME WITHOUT NOTICE.
Limitation of Liability
IN NO EVENT SHALL ORACLE BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE,DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION INCONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THE SOFTWARE.SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY.ACCORDINGLY, SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
修改时间 30-JAN-2011 类型 SCRIPT 状态 ARCHIVED
Checked for relevance on 21-Dec-2007
Abstract
Reports parameters and statistics related to the System Global Area.
Product Name, Product Version
Oracle Server, 7.3.x to 9.x
Platform Platform Independent
Date Created 15-Jun-2000
Instructions
Execution Environment:
Description
The script generates a report of the current values of thedatabase initialization parameters and statistics related to theSGA.Sample Output============= Current SGA Parameters Page: Date - Saturday 27th July 1996 13:18:26 At - TFTS_TEST Username - SYS Parameter Name Value ----------------------------- ----------------------------- async_write Boolean FALSE audit_file_dest Character ?/rdbms/audit audit_trail Character NONE background_core_dump Character full background_dump_dest Character /u02/oracle/V7.1.6/rd ... Current SGA Storage Summary Page:1 Size Size SGA Segment (Bytes) (Kb) -------------------- ----------- --------- Fixed Size 49,852 48.7 Variable Size 10,266,904 10,026.3 Database Buffers 6,553,600 6,400.0 Redo Buffers 8,192 8.0 ----------- --------- sum 16,878,548 16,483.0 Current SGA Library Summary Library Get Hit Pin Hit Name Gets Ratio Pins Ratio Reloads Invalid ------------ ------ ------- ---------- ------- ------- ------- Sql Area 8,879 0.94 30,140 0.96 116 93 Table/Proc. 4,201 0.86 3,704 0.80 23 0 Body 45 0.64 46 0.43 0 0 Trigger 5 0.40 6 0.50 0 0 Index 64 0.30 64 0.30 0 0 Cluster 27 0.44 15 0.33 0 0 Object 0 1.00 0 1.00 0 0 Pipe 0 1.00 0 1.00 0 0 The pin hit rate should be high (close to 1)
References
Script
SET ECHO off REM NAME: TFSSGAPR.SQL REM USAGE:"@path/tfssgapr" REM ------------------------------------------------------------------------ REM REQUIREMENTS: REM SELECT on V$SGA, V$LIBRARYCACHE REM ------------------------------------------------------------------------ REM AUTHOR: REM G. Godart-Brown REM Copyright 1991, Oracle Corporation REM ------------------------------------------------------------------------ REM PURPOSE: REM Reports parameters affecting the SGA and stats on effectiveness. REM REM REM ------------------------------------------------------------------------ REM DISCLAIMER: REM This script is provided for educational purposes only. It is NOT REM supported by Oracle World Wide Technical Support. REM The script has been tested and appears to work as intended. REM You should always run new scripts on a test instance initially. REM ------------------------------------------------------------------------ REM Main text of script follows: SET ECHO OFF spool tfssgapr.lst ttitle cen 'Current SGA Parameters' - right 'Page:' format 999 sql.pno skip skip set feedback off btitle off column nline newline set pagesize 54 set linesize 78 set heading off set embedded off set verify off accept report_comment char prompt 'Enter a comment to identify system: ' select 'Date - '||to_char(sysdate,'Day Ddth Month YYYY HH24:MI:SS'), 'At - '||'&&report_comment' nline, 'Username - '||USER nline from sys.dual / prompt set embedded on set heading on set feedback 6 column name format a36 heading 'Parameter Name' wrap column val format a36 heading 'Value' wrap select name ,lpad(decode(type,1,'Boolean',2,'Character',3,'Integer',4,'File',null),9) ||' '||value val from v$parameter order by 1; set embedded off set newpage 2 pagesize 16 lines 78 ttitle cen 'Current SGA Storage Summary' - right 'Page:' format 999 sql.pno skip skip set newpage 2 pagesize 16 column name format a20 heading 'SGA Segment' column value format 9,999,999,990 heading 'Size|(Bytes)' column kbval format 9,999,990.9 heading 'Size|(Kb)' break on report compute sum of value kbval on report set newpage 0 select name ,value ,round(value/1024,1) kbval from v$sga / ttitle cen 'Current SGA Library Summary' set newpage 3 set pagesize 60 column library format A15 heading 'Library|Name' column gets format 9,999,999 heading 'Gets' column gethitratio format 990.99 heading 'Get Hit|Ratio' column pins format 9,999,999 heading 'Pins' column pinhitratio format 990.99 heading 'Pin Hit|Ratio' column reloads format 99,999 heading 'Reloads' column invalidations format 99,999 heading 'Invalid' select initcap(namespace) library, gets, gethitratio, pins, pinhitratio, reloads, invalidations from v$librarycache / prompt prompt The pin hit rate should be high (close to 1) prompt prompt End of Report spool off; set termout off; clear break column sql ttitle off btitle off set newpage 0 pagesize 56 lines 78 set termout on feedback 6
Disclaimer
EXCEPT WHERE EXPRESSLY PROVIDED OTHERWISE, THE INFORMATION, SOFTWARE,PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. ORACLE EXPRESSLY DISCLAIMSALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOTLIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULARPURPOSE AND NON-INFRINGEMENT. ORACLE MAKES NO WARRANTY THAT: (A) THE RESULTSTHAT MAY BE OBTAINED FROM THE USE OF THE SOFTWARE WILL BE ACCURATE ORRELIABLE; OR (B) THE INFORMATION, OR OTHER MATERIAL OBTAINED WILL MEET YOUREXPECTATIONS. ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE DOWNLOADED OROTHERWISE OBTAINED IS DONE AT YOUR OWN DISCRETION AND RISK. ORACLE SHALL HAVENO RESPONSIBILITY FOR ANY DAMAGE TO YOUR COMPUTER SYSTEM OR LOSS OF DATA THATRESULTS FROM THE DOWNLOAD OF ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE.ORACLE RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THE SOFTWARE AT ANYTIME WITHOUT NOTICE.
Limitation of Liability
IN NO EVENT SHALL ORACLE BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE,DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION INCONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THE SOFTWARE.SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY.ACCORDINGLY, SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
how to show off
show us how to read
show it to your partner
1.to show 2.show 3.showing 4.showed
Market Prior to the Show 怎样翻译?
show sb to somewhere啥意思
Press [TAB] To Show Post Screen,[Del] To Enter Setup.
press tab to show post screen ,del to enter setup
They offend us free tickets to the show.
To show you more clearly what I mean
Fat lady forgets to show怎么翻译啊》?
you have come to show you go on
just show the wind how to fly是什么意思啊
Let me show you how to do it
Can you show me the way to the library ?(英译中)
Press TAB to show post screen,Del to enter SETUP这句话是什么意思?
We have no chance but to show devotion to the life,taking along with fretful wails
电脑每次开机时总是停在press[TAB]to show POST screen [DEL]to enter SETUP
开机显示Press TAB to show POST screen. DEL TO enter SETUP.怎么办啊.
出现Press TAB to show post screen,Del to enter SETUP之后没任何反应
who used peas to show how physical characteristics are passed from parents to their children?
出现Press TAB to show post screen,Del to enter SETUP之后没任何反应
They hold a dog show-----the Westminster Dog Show to name the nation's top dog.是什么意思?
SGA Expenses 会计中是什么意思呢?包括哪些东西?