Utility | Description | Installed in |
---|---|---|
bcp Utility | Used to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format. | <drive:>Program FilesMicrosoftSQL ServerClient SDKODBC110ToolsBinn |
dta Utility | Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
dtexec Utility | Used to configure and execute an Integration Services package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility. | <drive>:Program FilesMicrosoft SQL ServernnnDTSBinn |
dtutil Utility | Used to manage SSIS packages. | <drive>:Program FilesMicrosoft SQL ServernnnDTSBinn |
Deploy Model Solutions with the Deployment Utility | Used to deploy Analysis Services projects to instances of Analysis Services. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinnVShellCommon7IDE |
osql Utility | Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
Profiler Utility | Used to start SQL Server Profiler from a command prompt. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
RS.exe Utility (SSRS) | Used to run scripts designed for managing Reporting Services report servers. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
rsconfig Utility (SSRS) | Used to configure a report server connection. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
rskeymgmt Utility (SSRS) | Used to manage encryption keys on a report server. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
sqlagent90 Application | Used to start SQL Server Agent from a command prompt. | <drive>:Program FilesMicrosoft SQL Server<instance_name>MSSQLBinn |
sqlcmd Utility | Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. | <drive:>Program FilesMicrosoftSQL ServerClient SDKODBC110ToolsBinn |
SQLdiag Utility | Used to collect diagnostic information for Microsoft Customer Service and Support. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
sqllogship Application | Used by applications to perform backup, copy, and restore operations and associated clean-up tasks for a log shipping configuration without running the backup, copy, and restore jobs. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
SqlLocalDB Utility | An execution mode of SQL Server targeted to program developers. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn| |
sqlmaint Utility | Used to execute database maintenance plans created in previous versions of SQL Server. | <drive>:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBinn |
sqlps Utility | Used to run PowerShell commands and scripts. Loads and registers the SQL Server PowerShell provider and cmdlets. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinn |
sqlservr Application | Used to start and stop an instance of Database Engine from the command prompt for troubleshooting. | <drive>:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBinn |
Ssms Utility | Used to start SQL Server Management Studio from a command prompt. | <drive>:Program FilesMicrosoft SQL ServernnnToolsBinnVSShellCommon7IDE |
tablediff Utility | Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology. | <drive>:Program FilesMicrosoft SQL ServernnnCOM |
Command Prompt Utilities Syntax Conventions
Convention | Used for |
---|---|
UPPERCASE | Statements and terms used at the operating system level. |
monospace | Sample commands and program code. |
italic | User-supplied parameters. |
bold | Commands, parameters, and other syntax that must be typed exactly as shown. |
See Also
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent
Home E-mail Us Oracle Articles New Oracle Articles Oracle Training Oracle Tips Oracle Forum Class Catalog Remote DBA Oracle Tuning Emergency 911 RAC Support Apps Support Analysis Design Implementation Oracle Support SQL Tuning Security Oracle UNIX Oracle Linux Monitoring Remote support Remote plans Remote services Application Server Applications Oracle Forms Oracle Portal App Upgrades SQL Server Oracle Concepts Software Support Remote Support Development Implementation Consulting Staff Consulting Prices Help Wanted! Oracle Posters Oracle Books Oracle Scripts Ion Excel-DB |
Donald K. Burleson |
Oracle and Expert Systems Technology
Oracle - Calculate the Data Buffer Hit Ratio
PROMPT HIT RATIO SECTION
PROMPT **********************************************************
PROMPT
PROMPT
PROMPT BUFFER HIT RATIO
PROMPT
PROMPT (should be > 70, else increase db_block_buffers in init.ora)
(sum(decode(name,'db block gets',value,0))+
(sum(decode(name,'consistent gets',value,0)))))
)* 100) 'Buffer Hit Ratio'
FROM v$SYSSTAT;
Method 2--calculating the buffer hit ratio.
Buffer2.sql
PROMPT HIT RATIO SECTION
PROMPT **********************************************************
PROMPT
PROMPT
PROMPT BUFFER HIT RATIO
PROMPT
PROMPT (should be > 70, else increase db_block_buffers in init.ora)
COLUMN 'phys_reads' FORMAT 999,999,999
COLUMN 'phy_writes' FORMAT 999,999,999
SELECT A.value + B.value 'logical_reads',
C.value 'phys_reads',
D.value 'phy_writes',
ROUND(100 * ((A.value+B.value)-C.value) / (A.value+B.value))
'BUFFER HIT RATIO'
FROM V$SYSSTAT A, V$SYSSTAT B, V$SYSSTAT C, V$SYSSTAT D
WHERE
A.statistic# = 37
AND
B.statistic# = 38
AND
C.statistic# = 39
AND
D.statistic# = 40;
**********************************************************
Hit Ratio Section
**********************************************************
BUFFER HIT RATIO
(should be > 70, else increase db_block_buffers in init.ora)
------------- ------------ ------------ ----------------
18,987,002 656,805 87,281 97
16K blocks db_block_size=16384 db_file_multiblock_read_count=4
If you like Oracle tuning, see the book 'Oracle Tuning: The Definitive Reference', with 950 pages of tuning tips and scripts.
Burleson is the American Team Note:This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience!Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just and include the URL for the page. Oracle Performance Tuning |