SQL Syntax differences between Oracle - MS-SQL. 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? And include the URL for the page. Copyright © 1996 - 2014 All rights reserved by Burleson Oracle © is the registered trademark of Oracle Corporation.
Magazine Online. XtraReports. Pense-bête du DBA Oracle. Il est ici question de rappeler quelques paramètres de la base de données (choisis complètement arbitrairement :-D) ainsi que les paramètres d'arrêt/démarrage de la base. J'ai voulu rappeler aussi les différentes commandes possibles sur les redo logs et enfin la gestion des tablespaces. Il existe toute une série de vue dynamique dont v$fixed_table qui contient le nom de toutes les vues disponibles. Les principales sont : v$parameter Contient des informations sur les paramètres d'initialisation.N.B. : la commande SHOW PARAMETER CONTROL équivaut à : SELECT name,type,value FROM v$parameter WHERE name LIKE '%control%'; v$system_parameter Contient des informations sur les paramètres d'initialisation et leurs modifications éventuelles.
V$sga Contient des infos sur la SGA. V$option Contient la liste des options installées sur le serveur Oracle. V$process Contient des informations sur les process actifs courant. Pour trouver les paramètres modifiés: NAME Nom du paramètre. ORACLE - DBA Tips Corner. Oracle. Menu 11G top news features. Database Replay. Learn how to use the Database Replay, the shiny new tool in Oracle Database 11g that captures complete database workload so you can "replay" it at will.
See Series TOC What is your biggest concern when you need to make a change in the database—be it some minor change, such as altering initialization parameters and database attributes, or major but inevitable ones such as applying patchsets? What about for your upgrade to Oracle Database 11g itself? For me, the biggest concern is the risk of the change "breaking" something. Even the most minor changes can have a domino effect, eventually producing a visible impact. To minimize this risk, most shops make the change in a control environment similar to the production one, apply a workload similar to your production system's, and observe the impact. Most organizations attempt to do that using some third-party load generation tool that can run automatically to simulate real user activity. Enter Database Replay Capturing Pre-processing Replaying.