Skip to main content

Home/ eDBA Services - Oracle & MySQL/ Contents contributed and discussions participated by Dariusz Owczarek

Contents contributed and discussions participated by Dariusz Owczarek

Simple Middle Filter: All | Bookmarks | Topics
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

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 - Cached
  • 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.
  • 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.
  • 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.
  • ...1 more annotation...
  • 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.
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
  • Dariusz Owczarek on 30 Jul 09
     
    Handy Oracle reference site, with queries for everyday DBA work
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.
Dariusz Owczarek

SQL GRANT Syntax - 0 views

download.oracle.com/...statements_9013.htm

dba oracle sql

shared by Dariusz Owczarek on 12 Jun 09 - Cached
  • Dariusz Owczarek on 12 Jun 09
     
    SQL GRANT statement is used to grant system or object privileges to users and roles. It is also used to grant roles to users and roles.
Dariusz Owczarek

SQL Functions Quick Reference - 1 views

download.oracle.com/...sqlqr02.htm

dba oracle sql

shared by Dariusz Owczarek on 12 Jun 09 - Cached
  • Dariusz Owczarek on 12 Jun 09
     
    This chapter of Oracle Database SQL Language Quick Reference presents the syntax for SQL functions.
‹ Previous 21 - 40 of 43 Next ›
Showing 20▼ items per page