Skip to main content

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

Oracle PL/SQL Examples - 1 views

www.java2s.com/...CatalogOracle.htm

dba oracle pl_sql sql

shared by Dariusz Owczarek on 10 Jun 09 - Snapshot
Dariusz Owczarek

SQL Plan Management - 0 views

www.pythian.com/...nagement-be-the-11g-killer-app

dba oracle sql

shared by Dariusz Owczarek on 25 Nov 09 - Snapshot
  • Dariusz Owczarek
    Dariusz Owczarek on 25 Nov 09
     
    The SQL Plan Management new feature of Oracle 11g completes (replaces ?) the outlines by providing a new plan stability capability to Oracle 11g Enterprise Edition.
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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Doc ID:
    578524.1
  • alter system set dispatchers='(address=(protocol=tcp)(host=node1-vip))(dispatchers=2)' scope=both   sid='racdb1';
  • 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>
  • ...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
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Doc ID:
    453293.1
  • 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
  • ...2 more annotations...
  • 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)
  • 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
  • Dariusz Owczarek
    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

Oracle announces availability of Oracle Database 11g Release 2 - 0 views

www.oracledatabase11g.com/...NewsEvents_w.html

dba oracle

shared by Dariusz Owczarek on 10 Sep 09 - Snapshot
  • The combination of Oracle Database 11g Release 2 Advanced Compression and Partitioning support the reduction of storage costs by compressing data as much as 2-4x and simplifying use of lower cost storage tiers.
  • In this release, Oracle Automatic Storage Management is extended to support a general-purpose cluster file system to help customers reduce their storage management costs.
  • In this release, Edition-based Redefinition is introduced to allow customer database applications to be upgraded online; this removes the need for separate upgrade environments.
  • ...1 more annotation...
  • This release also delivers enhanced query performance with the ability to transparently execute a query against data stored in memory across all the servers in a grid.
  • Dariusz Owczarek
    Dariusz Owczarek on 10 Sep 09
     
    Oracle® Database 11g Release 2 is Now Generally Available
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 - Snapshot
  • LSNRCTL> set trc_level ADMIN
  • Format Trace File with the trcasst utility
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
  • Dariusz Owczarek
    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 - Snapshot
Dariusz Owczarek

ShutdownAbort.com - Oracle reference - 0 views

www.shutdownabort.com

dba oracle reference

shared by Dariusz Owczarek on 30 Jul 09 - Snapshot
  • Ruud Schilders
    Ruud Schilders on 30 Jul 09
     
    Handy Oracle reference site, with queries for everyday DBA work
  • Dariusz Owczarek
    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, 10g,... - 0 views

www.oracle-base.com

oracle manuals reference howto

shared by Ruud Schilders on 30 Jul 09 - Snapshot
  • Ruud Schilders
    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 - 0 views

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

dba oracle v$ dictionary

shared by Dariusz Owczarek on 27 Jun 09 - Snapshot

  • 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
    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.
1 - 20 of 28 Next ›
Showing 20▼ items per page
Join this group