Skip to main content

Home/ eDBA Services - Oracle & MySQL/ Group items tagged applications

Rss Feed Group items tagged

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

Oracle EBS Key Business Cycle - YouTube - 0 views

youtu.be/tEw47Dr1ks4

#EBS #oracle EBs

shared by sonalchawhan on 15 Feb 19 - No Cached
Dariusz Owczarek

Oracle ASSM Performance - 0 views

www.dba-oracle.com/...t_assm_performance.htm

dba oracle performance edba

shared by Dariusz Owczarek on 13 Sep 10 - No Cached
  • Cons of ASSM: §         Slow for full-table scans: Several studies have shown that large-table full-table scans (FTS) will run longer with ASSM than standard bitmaps. ASSM FTS tablespaces are consistently slower than freelist FTS operations. This implies that ASSM may not be appropriate for decision support systems and warehouse applications unless partitioning is used with Oracle Parallel Query. §        Slower for high-volume concurrent inserts: Numerous experts have conducted studies that show that tables with high volume bulk loads perform faster with traditional multiple freelists. §         ASSM will influence index clustering: For row ordered tables, ASSM can adversely affect the clustering_factor for indexes. Bitmap freelists are less likely to place adjacent tows on physically adjacent data blocks, and this can lower the clustering_factor and the cost-based optimizer's propensity to favor an index range scan.
  • Pros of ASSM: §          Varying row sizes: ASSM is better than a static pctused. The bitmaps make ASSM tablespaces better at handling rows with wide variations in row length. §         Reducing buffer busy waits: ASSM will remove buffer busy waits better than using multiple freelists. When a table has multiple freelists, all purges must be parallelized to reload the freelists evenly, and ASSM has no such limitation. §         Great for Real Application Clusters: The bitmap freelists remove the need to define multiple freelists groups for RAC and provide overall improved freelist management over traditional freelists.
  • Cons of ASSM: §         Slow for full-table scans: Several studies have shown that large-table full-table scans (FTS) will run longer with ASSM than standard bitmaps. ASSM FTS tablespaces are consistently slower than freelist FTS operations. This implies that ASSM may not be appropriate for decision support systems and warehouse applications unless partitioning is used with Oracle Parallel Query. §          Slower for high-volume concurrent inserts: Numerous experts have conducted studies that show that tables with high volume bulk loads perform faster with traditional multiple freelists. §          ASSM will influence index clustering: For row ordered tables, ASSM can adversely affect the clustering_factor for indexes. Bitmap freelists are less likely to place adjacent tows on physically adjacent data blocks, and this can lower the clustering_factor and the cost-based optimizer's propensity to favor an index range scan.
  • Dariusz Owczarek on 13 Sep 10
     
    Oracle ASSM Performance pros and cons
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.
donaldjmarshal

Zero Cost Cloud Migration Services | Migration Of Workloads to Cloud | Suneratech - 0 views

www.suneratech.com/...zero-cost-cloud-migration

Zero cost Migration services Of Workloads to Cloud

shared by donaldjmarshal on 27 Mar 20 - No Cached
  • donaldjmarshal on 27 Mar 20
     
    Zero Cost Cloud Migration CLOUD-FIRST is a captivating concept around which the emerging businesses are predominantly dependent upon. While it aligns with the digital transformation strategies built for enterprises, migrating workloads to cloud comes with its own challenges like flexibility, application performance and budgets. more details visit Zero cost cloud Migration services In a data-driven world, you need a comprehensive business model to accelerate your IT transformation with cloud services and offering you the advantages of a cloud. Suneratech improves your business agility, security, cost-efficiency, and simplicity, with a 4-step strategy to move you to cloud while reaping the benefits. ZCCM Advantage for Customers When a customer withdraws from other service providers like IBM or OMCS, and opt for a new provider, a customer must pay for both the providers until the migration is completed. ZCCM program is a great choice for such customers, as it saves this double cost by paying all the Oracle costs until the customer's contract terminates with other cloud service providers. Suneratech migrates all workloads in scope to Oracle Cloud Infrastructure (OCI), at ZERO Cost, and will not invoice until all workloads are successfully migrated to Cloud.
ethanedwards123

Oracle Fusion Financials Training | Oracle Fusion Financials - 0 views

smconsultant.com/...cle-fusion-financials-training

shared by ethanedwards123 on 18 Dec 20 - No Cached
  • ethanedwards123 on 18 Dec 20
     
    Oracle Fusion Financials Training course at SMC is facilitated by oracle certified, experienced professional and real-time expert trainers. Oracle Fusion Financials Online Training course will help you to explore all Oracle Fusion Financials modules required for the better financial management of an organization. This Oracle Fusion Financials Online Training course will help you learn how to implement and manage Oracle Fusion Cloud Enterprise Resource Planning application which includes Oracle Financials Cloud, Oracle Expenses Cloud, Oracle Accounting Hub Cloud, Oracle Fusion Accounts Receivables, Oracle Fusion Accounts Payables, Oracle Fusion Cash Management, Oracle Procurement Cloud, and Oracle Fusion Tax.
Dariusz Owczarek

Meaning of Oracle Key Statistics - 0 views

skillport.books24x7.com/...viewer.asp

dba edba oracle performance

shared by Dariusz Owczarek on 08 Jun 10 - Cached
  • Statistics are somewhat fallible in that they are seldom 100 percent accurate, but in most cases they do sufficiently indicate what was intended. Be sure you understand what each statistic represents and the units used (there is a big difference between microseconds and centiseconds).
  • Time-breakdown statistics (Time Model) make it significantly easier to determine the type of operations that are consuming resources in the database.
  • DB time: Time spent by all user processes in the database (that is,. non-idle wait time + CPU time).
  • ...11 more annotations...
  • DB CPU: Time spent by all user processes on the CPU, in Oracle code. On most systems, the majority of time will be spent in DB CPU, SQL execute elapsed time, or PL/SQL execution elapsed time (and possibly Java). Time spent in parse and connection management should be low, so if the levels indicate a high percentage of DB time, a problem exists in the relevant area. You can use this data to correlate with Top 5 Timed Events and Load Profile.
  • Database time (DB time) is an important time-based statistic: it measures the total time spent in the database by active sessions (that is, foreground user processes either actively working or actively waiting in a database call). DB time includes CPU time, I/O time, and other non-idle wait time.
  • Because DB time represents the sum of the time that all sessions spend in database calls, it can easily exceed the elapsed wall-clock time.
  • The objective of tuning an Oracle system could be stated as reducing the time that users spend in performing actions in the database, or simply reducing DB time.
  • Wait time is artificially inflated when the host is CPU bound because the wait time includes the actual time spent waiting (for example, waiting for a disk I/O), as well as the time spent by the process in the OS run-queue waiting to be rescheduled.
  • Therefore, when the host is CPU bound, it is important to reduce CPU utilization before addressing wait-related problems, because otherwise you may be addressing the wrong problem.
  • You can use ASH data to estimate DB time when the actual DB time is not available—for example, if a session has exited. Because ASH samples active sessions every second, you can estimate DB time (in seconds) to be the number of ASH samples counted.
  • V$OSSTAT is OS-related resource utilization data that the Oracle server collects. The statistics available vary by platform. You can use V$OSSTAT to determine CPU utilization (BUSY_TICKS and IDLE_TICKS), and also compare this to the host's CPU utilization statistics. Also look for high OS_CPU_WAIT_TIME, which may indicate the host is CPU bound.
  • V$OSSTAT statistics can be compared with the Time Model statistics, for example to determine how much of the total CPU used on the host is attributable to this instance: DB CPU / BUSY_TICKS.
  • note that the units for these two statistics differ.
  • In 10g, each wait event (V$SYSTEM_EVENT) is classified into one of nine wait classes: Application, Commit, Concurrency, Configuration, Network, Other, System I/O, User I/O, and Idle. The class names are reasonably self-explanatory except Other, which is a catchall bucket for wait events that should not ever contribute any significant wait time.
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.
1 - 9 of 9
Showing 20▼ items per page