Skip to main content

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

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."
3More

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.
1More

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.
1More

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.
1More

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...
7More

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.
2More

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.
6More

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)
3More

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.
1More

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
1More

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
3More

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.
3More

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
2More

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
1More

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.
15More

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.
1More

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.
1More

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
1More

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
18More

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