Skip to main content

Home/ Groups/ eDBA Services - Oracle & MySQL
Rss Feed
Sort By: Most Recent | Popular Filter: All | Bookmarks | Topics Simple Middle
Dariusz Owczarek

RAC One Node tips - 0 views

www.dba-oracle.com/t_rac_one_node.htm

dba oracle rac

shared by Dariusz Owczarek on 10 Nov 09 - Cached
  • This instance relocation uses a new featured dubbed Oracle Omotion.
  • This instance relocation uses a new featured dubbed Oracle Omotion.
  • This is a similar approach to instance relocation that was first introduced by Savantis Systems with their DB-Switch invention, an offshoot of the Database Area Network (DAN) approach.
  • ...1 more annotation...
  • In Oracle RAC One Node, it appears that the Omotion software component uses VMware for the high speed instance relocation.  See here for details on how Oracle instance relocation works using DAN and SAN technology.
  • Dariusz Owczarek on 10 Nov 09
     
    In Oracle 11g r2, we see a new feature dubbed "RAC One Node". RAC One Node claims to be a multiple instances of RAC running on a single node in a cluster, and has a fast "instance relocation" feature in cases of catastrophic server failure."
Dariusz Owczarek

Oracle Database Health Recommendations Catalog - 0 views

metalink2.oracle.com/...f

dba oracle

shared by Dariusz Owczarek on 04 Nov 09 - Cached
  • Oracle Database Availability Configure Install Patching Performance Security
  • Enterprise Manager Configure Patching
  • Dariusz Owczarek on 04 Nov 09
     
    This catalog contains a complete list of all health recommendations available in My Oracle Support.
Dariusz Owczarek

Oracle SQL Tuning tricks - 0 views

www.dba-oracle.com/t_sql_tuning_tricks.htm

dba oracle tuning

shared by Dariusz Owczarek on 28 Oct 09 - Cached
  • Dariusz Owczarek on 28 Oct 09
     
    Oracle SQL tuning experts use an endless number of techniques, but there are some common tricks that can be used to optimize all SQL.
Dariusz Owczarek

Oracle Critical Patch Update - October 2009 - 0 views

www.oracle.com/...cpuoct2009.html

dba oracle

shared by Dariusz Owczarek on 21 Oct 09 - No Cached
  • Dariusz Owczarek on 21 Oct 09
     
    A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches. Critical Patch Updates are cumulative, except as noted below, but each advisory describes only the security fixes added since the previous Critical Patch Update. Thus, prior Critical Patch Update Advisories should be reviewed for information regarding earlier accumulated security fixes.
Dariusz Owczarek

Oracle OS statistics - 0 views

www.dba-oracle.com/t_os_statistics.htm

dba oracle

shared by Dariusz Owczarek on 16 Oct 09 - Cached
  • Dariusz Owczarek on 16 Oct 09
     
    The speed of disk access, the backlog of CPU enqueues, network latency and RAM swapping can all be the root cause of an Oracle performance problem, and no amount of tuning can fix a problem that is at the OS layer, external to Oracle. Oracle has two main ways to collect OS information...
Dariusz Owczarek

How To Configure Dispatchers For RAC Environment - 0 views

metalink.oracle.com/...flash.html

dba oracle rac

shared by Dariusz Owczarek on 07 Oct 09 - Cached
  • Doc ID: 578524.1
  • Note: It is very important to use entire address string in order to configure dispatchers on RAC and host name used in it should be a VIP hostname, otherwise connection may suffer intermittent ORA-12545 errors. Refer metalink note <333159.1>
  • alter system set dispatchers='(address=(protocol=tcp)(host=node1-vip))(dispatchers=2)' scope=both   sid='racdb1';
  • ...3 more annotations...
  • If you have a firewall present between client and the server, then it may block connections on the randomly selected dispatchers ports. If this is the case for your setup then set the dispatcher with PORT clause as below and configure the firewall to allow the communication on these ports along with the listener port.
  • alter system set dispatchers='(address=(protocol=tcp)(host=<vip address>)(port=<port_number>))' scope=both sid='racdb1';
  • Note - If the port clause is not used in the dispatchers configuration then port numbers will be chosen randomly which could be blocked in the firewall resulting redirected connection to dispatchers getting time out errors. For more details refer note <125021.1>:Oracle Connections and Firewalls
  • Dariusz Owczarek on 07 Oct 09
     
    This document would guide you to configure dispatchers for Real Application Cluster (RAC) database.
Dariusz Owczarek

Understanding and Troubleshooting Instance Load Balancing - 0 views

metalink.oracle.com/...showdoc

dba oracle

shared by Dariusz Owczarek on 02 Oct 09 - Cached
  • Dariusz Owczarek on 02 Oct 09
     
    This document is intended for use by DBA's and support analysts attempting to understand and troubleshoot Load Balancing issues.
Dariusz Owczarek

Configuration of TAF (Transparent Application Failover) and Load Balancing - 0 views

metalink.oracle.com/...flash.html

dba oracle development

shared by Dariusz Owczarek on 02 Oct 09 - Cached
  • The client load balancing feature enables clients to randomize connection requests among the listeners. Tnsnames Parameter: LOAD_BALANCE
  • The connect-time failover enables clients to connect to another listener if the initial connection to the first listener fails. The number of listener protocol addresses determines how many listeners are tried. Without connect-time failover, Oracle Net attempts a connection with only one listener. The default is on. Tnsnames Parameter: FAILOVER
  • The listener connection load balancing feature improves connection performance by balancing the number of active connections among multiple dispatchers and instances. In a single-instance environment, the listener selects the least loaded dispatcher to handle the incoming client requests. In an Oracle Real Application Clusters (RAC) environment, connection load balancing also has the capability to balance the number of active connections among multiple instances. 1. Least-loaded node 2. Least-loaded instance 3. Least-loaded dispatcher for that instance (in case of Shared server configuration)
  • ...2 more annotations...
  • Transparent Application Failover (TAF) is a feature of the Oracle Call Interface (OCI) driver at client side. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. In this case, the active transactions roll back. Tnsnames Parameter: FAILOVER_MODE
  • Doc ID: 453293.1
  • Dariusz Owczarek on 02 Oct 09
     
    This note explains the configuration in 10g & 11g for: Client Side Connect Time Load Balance; Client Side Connect Time Failover; Server Side Listener; Connection Load Balance; Transparent Application Failover (TAF)
Dariusz Owczarek

lsnrctl Tracing Oracle Listener Connections - 0 views

www.praetoriate.com/teas_prae_util25.htm

dba oracle

shared by Dariusz Owczarek on 28 Aug 09 - Cached
  • LSNRCTL> set trc_level ADMIN
  • Format Trace File with the trcasst utility
  • Dariusz Owczarek on 28 Aug 09
     
    Network connections can be traced to provide a detailed description of the operations performed by Oracle's internal components. The trace data is stored in an output trace file that can then be analyzed.
Dariusz Owczarek

eDBA Searche - Search Oracle and MySQL Documentation - 0 views

www.google.com/cse

dba oracle mysql documentation

shared by Dariusz Owczarek on 16 Aug 09 - Cached
  • Dariusz Owczarek on 16 Aug 09
     
    Search online Oracle and MySQL using Google engine
Dariusz Owczarek

eDBA Search - Oracle and MySQL Documentation search - 0 views

www.google.com/cse

dba oracle mysql documentation

shared by Dariusz Owczarek on 16 Aug 09 - Cached
  • Dariusz Owczarek on 16 Aug 09
     
    Search online Oracle and MySQL using Google engine
Dariusz Owczarek

Critical Patch Updates and Security Alerts - July 2009 - 0 views

www.oracle.com/...alerts.htm

dba oracle

shared by Dariusz Owczarek on 06 Aug 09 - Cached
  • Critical Patch Update - July 2009 No MetaLink copy Rev 2, 15 July 2009
  • 13 October 2009
  • Dariusz Owczarek on 06 Aug 09
     
    This page lists security patches, in the form of Critical Patch Updates (CPUs) and Security Alerts, that Oracle has released. The page is updated when new Critical Patch Updates and Security Alerts are released.
Dariusz Owczarek

Oracle 11g Database Online Documentation - 0 views

www.oracle.com/homepage

dba oracle documentation

shared by Dariusz Owczarek on 30 Jul 09 - Cached
  • Reference HTML
  • Concepts HTML
  • SQL Language Reference HTML
Dariusz Owczarek

ShutdownAbort.com - Oracle reference - 0 views

www.shutdownabort.com

dba oracle reference

shared by Dariusz Owczarek on 30 Jul 09 - Cached
  • Ruud Schilders on 30 Jul 09
     
    Handy Oracle reference site, with queries for everyday DBA work
  • Dariusz Owczarek on 30 Jul 09
     
    Handy Oracle reference site, with queries for everyday DBA work
Ruud Schilders

ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, ... - 0 views

www.oracle-base.com

oracle manuals reference howto

shared by Ruud Schilders on 30 Jul 09 - Cached
  • Ruud Schilders on 30 Jul 09
     
    Contains easy step-by-step manuals for installing Oracle on Linux, vmware etc.
Dariusz Owczarek

Oracle's V$ Views - Dynamic Performance Views - 1 views

www.adp-gmbh.ch/...dynamic_performance_views.html

dba oracle v$ dictionary

shared by Dariusz Owczarek on 27 Jun 09 - Cached
  • v$database This view lets you access database information.
  • v$datafile This view contains an entry for each datafile of the database.
  • v$dataguard_status Shows error messages in a data guard environment.
  • ...11 more annotations...
  • v$flash_recovery_area_usage See also v$recovery_file_dest
  • v$lock This view stores all information relating to locks in the database.
  • v$mystat This view records statistical data about the session that accesses it.
  • v$parameter Lists the name-value pairs of the init.ora file (or their default, if not in the init.ora).
  • v$session
  • v$session_longops Use v$session_longops if you have a long running pl/sql procedure and want to give feedback on how far the procedure proceeded.
  • v$session_wait This views shows what wait event each session is waiting for, or what the last event was that it waited for.
  • v$session_wait_history This view is new in Oracle 10g and allows improved timing and statistics.
  • v$sqlarea Join v$sqlarea's address with v$session's sql_address.
  • v$sql_bind_capture New with Oracle 10g This view captures bind variables for all sessions and is faster than setting 10046 on level 4.
  • v$version Use this view to find out what version you actually work on: select * from v$version;
  • Dariusz Owczarek on 27 Jun 09
     
    Oracle's data dictionary provides information that Oracle needs to perform its tasks. The data dictionary is stored in table structures owned by SYS. Their content is exposed through dictionary views. Dynamic performance views (so called v$ views) are part of Oracle's data dictionary.
Dariusz Owczarek

collectl system monitoring tool - 0 views

collectl.sourceforge.net/index.html

dba unix performance

shared by Dariusz Owczarek on 25 Jun 09 - Cached
  • Dariusz Owczarek on 25 Jun 09
     
    Unlike most monitoring tools that either focus on a small set of statistics, format their output in only one way, run either interatively or as a daemon but not both, collectl tries to do it all. You can choose to monitor any of a broad set of subsystems which currently include buddyinfo, cpu, disk, inodes, infiniband, lustre, memory, network, nfs, processes, quadrics, slabs, sockets and tcp.
Dariusz Owczarek

Oracle RAC 11g Administration and Maintainance Tasks Utilities - 0 views

www.oracledba.org/...11g_RAC_Admin_Utilities.html

dba oracle rac

shared by Dariusz Owczarek on 25 Jun 09 - Cached
  • Dariusz Owczarek on 25 Jun 09
     
    CRSCTL SRVCTL OCRCONFIG Changing Public IPs and VIP
Dariusz Owczarek

awk - 0 views

www.adp-gmbh.ch/...index.html

dba unix scripts

shared by Dariusz Owczarek on 12 Jun 09 - Cached
  • Dariusz Owczarek on 12 Jun 09
     
    awk Very Quick Reference
Dariusz Owczarek

SQL SELECT Syntax - 0 views

download.oracle.com/...statements_10002.htm

dba oracle sql

shared by Dariusz Owczarek on 12 Jun 09 - Cached
  • Dariusz Owczarek on 12 Jun 09
     
    SQL SELECT statement or subquery is used to retrieve data from one or more tables, object tables, views, object views, or materialized views.
‹ Previous 21 - 40 of 44 Next ›
Showing 20▼ items per page