Просторы интернета

19 Февраль 2015
Earlier
Сб, Сен 14, 2019

Use ORAMDS for all XSD / WSDL files on the project (oramds:...) in all composite.xml and wrappers in location tag. Doing that you will guarantee that you can deploy anywhere even when you don't have remote access to a environment.

Also, in this way it is not necessary to change [...]
Source: oracleanil.blogspot.ru
Сб, Сен 14, 2019
Background Transaction context between different BPEL services are controlled by mainly two properties/attributes. Those are Delivery and Transaction attributes.
Details Case 1 : If BPEL Process is Async or one-way process then, Delivery policy attribute can have three values. Those are 1)- async.persit 2)- async.cache 3)- sync
meaning: - async.persit: Delivery [...]
Source: oracleanil.blogspot.ru
Пт, Сен 13, 2019

Bobby Durrett recently published a note about estimating the volume of non-logged blocks written by an instance with the aim of getting some idea of the extra redo that would be generated if a database were switched to “force logging”.

Since my most recent blog notes have included various extracts [...]

Source: jonathanlewis.wordpress.com
Пт, Сен 13, 2019

At the UKOUG TechFest 2019 event in Brighton this year I'll be chairing the CBO Panel session on Monday 2nd December at noon. The panellists will be Maria Colgan, Nigel Bayliss, Christian Antognini and Richard Foote.

It will be possible to propose questions on the day – written or spoken, but [...]

Source: jonathanlewis.wordpress.com
Пт, Сен 13, 2019
Первоначально проблема представлялась просто как запрос с нестабильным временем выполнения на Read-Only Standby , при более внимательном рассмотрении выяснилось, что запрос не просто небыстро выполняется, а периодически-трагически гибнет: с сообщениями в alert.log: LMHB trace file: *) обращает на себя внимание, что ожидание LGWR library cache lock не превышает max=5.500000 sec [...]
Source: iusoltsev.wordpress.com
Вт, Сен 10, 2019

Somewhere I think I've published a note about an anomaly that's been bugging me since at least Oracle 10g – but if it is somewhere on the Internet it's hiding itself very well and I can't find it, though I have managed to find a few scripts on my laptop [...]

Source: jonathanlewis.wordpress.com
Пн, Сен 09, 2019

Upgrades cause surprises – here's a pair of results from a model that I constructed more than 15 years ago, and ran today on 12.2, then modified and ran again, then ran on 11.2.0.4, then on 12.1.0.2. It's very simple, I just create a table, gather stats, then update every [...]

Source: jonathanlewis.wordpress.com
Ср, Сен 04, 2019
Аналогично описанному для версий 11-12.1 — JPPD в присутствии удалённой таблицы и View Merging — и справедливому до 19.3 включительно (тесткейс там есть — можно проверить) наблюдению, CBO версии 12.2 также может полностью блокировать применение Join Predicate Push Down с резолюцией JPPD bypassed: Remote table referenced — в этот раз [...]
Source: iusoltsev.wordpress.com
Вт, Авг 27, 2019

This is another of the blog notes that have been sitting around for several years – in this case since May 2014, based on a script I wrote a year earlier. It makes an important point about “inconsistency” of timing in the way that Oracle records statistics of work done. [...]

Source: jonathanlewis.wordpress.com
Пн, Авг 26, 2019

A recent thread on the Oracle Developer Community starts with the statement that a query is taking a very long time (with the question “how do I make it go faster?” implied rather than asked). It's 12.1.0.2 (not that that's particularly relevant to this blog note), and we have [...]

Source: jonathanlewis.wordpress.com
Пт, Авг 23, 2019

I've got a number of examples of clever little tricks the optimizer can do to transform your SQL before starting in on the arithmetic of optimisation. I was prompted to publish this one by a recent thread on ODC. It's worth taking note of these tricks when you spot one [...]

Source: jonathanlewis.wordpress.com
Ср, Авг 21, 2019

This note is a short follow-up to a note I wrote some time ago about validating foreign key constraints where I examined the type of SQL Oracle generates internally to do the validation between parent and child tables. In that article I suggested (before testing) that you could [...]

Source: jonathanlewis.wordpress.com
Ср, Авг 21, 2019
In this article we will see how to stop a running SOA composite process. It is normal to stop from Enterprise Manager (http: // {hostname}: {port number} / em), but I thought this was not "user friendly".

How can I use the API to identify the SOA composite instance ID? [...]
Source: oracleanil.blogspot.ru
Ср, Авг 21, 2019
This content has already been introduced in many entries, but I will keep it personally as many people still ask me.
Log in to Enterprise Manager Fusion Middleware Control.
http: // {host name or IP}: {port number} / em Open the SOA folder, right click on the soa_infra (soa_server1) folder and [...]
Source: oracleanil.blogspot.ru
Ср, Авг 21, 2019
Two new Oracle Service Bus samples have been registered on the Oracle Technology Network site. The first sample project is osb-205-SimpleREST. This demonstrates how to fully implement a REST service in OSB. “Complete” means that the following HTTP methods are implemented using OSB.
GET POST PUT DELETE HEAD OPTIONS Another REST sample is now over. This is [...]
Source: oracleanil.blogspot.ru
Ср, Авг 21, 2019
Error

When starting the SOA server, the following exception may occur.




log is opened. All server side log events will be written to this file.> cation for user weblogic denied weblogic.security.SecurityInitializationException: Authentication for user weblogic denied at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceM at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDel [...]
Source: oracleanil.blogspot.ru
Ср, Авг 21, 2019

I faced the problem that it took a long time to execute select in DB Adapter. There were three tables that contained a large amount of data and contained many columns, and these tables were being handled by the DB Adapter.

The database side configured a primary key / foreign key [...]
Source: oracleanil.blogspot.ru
Вт, Авг 20, 2019

It's strange how one thing leads to another when you're trying to check some silly little detail. This morning I wanted to find a note I'd written about the merge command and “stable sets”, and got to a draft about updatable join views that I'd started in 2016 in [...]

Source: jonathanlewis.wordpress.com
Ср, Авг 14, 2019

What happens when you execute dbms_stats.gather_system_stats() with the ‘Exadata' option ?

Here's what my system stats look like (12.2.0.1 test results) after doing so. (The code to generate the two different versions is at the end of the note).

System Stats ============ Status: COMPLETED Timed: 13-Aug-2019 15:00:00 - 13-Aug-2019 15:00:00 -------------------------------------------------- CPUSPEED [...]
Source: jonathanlewis.wordpress.com
Вт, Авг 13, 2019

Here's a problem (and I think it should be called a bug) that I first came across about 6 years ago, then forgot for a few years until it reappeared some time last year and then again a few days ago. The problem has been around for years [...]

Source: jonathanlewis.wordpress.com
Пн, Авг 12, 2019

Here's a question to provoke a little thought if you've got nothing more entertaining to do on a Sunday evening. What threats do you think of when you see a statement like the following in (say) an AWR report, or in a query against v$sql ?

update tableX set [...]
Source: jonathanlewis.wordpress.com
Пт, Авг 09, 2019

An anecdote with a moral.

Many years ago – in the days of Oracle 7.2.3, when parallel query and partition views were in their infancy and when RAC was still OPS (Oracle Parallel Server), I discovered a bug that caused parallel queries against partition views to crash (Maxim – mixing two [...]

Source: jonathanlewis.wordpress.com
Пт, Авг 09, 2019

This is a little case study on “pre-emptive trouble-shooting”, based on a recent question on the ODC database forum asking about splitting a range-based partition into two at a value above the current highest value recorded in a max_value partition.

The general principle for splitting (range-based) partitions is that if [...]

Source: jonathanlewis.wordpress.com
Чт, Авг 08, 2019

Several years ago I wrote a note about reporting dba_free_space and dba_extents to produce a map of the space usage in a tablespace in anticipation of messing about with moving or rebuilding objects to try and reduce the size of the files in the tablespace. In the [...]

Source: jonathanlewis.wordpress.com
Вт, Авг 06, 2019

In the “Parse Puzzle” I posted a couple of days ago I showed a couple of extracts from an AWR report that showed contradictory results about the time the instance spent in parsing and hard parsing, and also showed an amazing factor of 4 difference between the DB Time [...]

Source: jonathanlewis.wordpress.com
Вс, Авг 04, 2019

Here are some details from an AWR report covering a few minutes in the lifetime of an instance of 18.3. It's a carefully constructed demonstration and all I've done is take an AWR snapshot, execute a single SQL statement, then take another snapshot, so the only thing captured by the [...]

Source: jonathanlewis.wordpress.com
Пт, Авг 02, 2019

This is a blog note that started life in September 2001 (which was before I started blogging, I think), got drafted as a blog in January 2014 because of a question on the Oracle-L list server, and has finally got to publication following a question on the ODC database [...]

Source: jonathanlewis.wordpress.com
Ср, Июл 31, 2019
Тесты с простым тестовым запросом проводились на версии 18c — там трассировка и комментарии Oracle полнее, хотя описываемые особенности известны и наблюдаемы, как минимум, с версии 12.1 Итак, для запроса одновременно созданы два элемента SPM — SQL Patch и SQL Plan Baseline: , Baseline фиксирует индексный доступ: , в то [...]
Source: iusoltsev.wordpress.com
Вс, Июл 28, 2019
Обсуждая с Юрием Пудовченко длительный разбор/long parse запроса, обратили внимание на расхождения отображение длительности процесса parsing-а в отчётах tkprof и V$ACTIVE_SESSION_HISTORY, в то время как tkprof показывает: , данные ASH говорят о том, что в течение этих 14 секунд запрос был как бы одновременно IN_SQL_EXECUTION, IN_PARSE, IN_HARD_PARSE с нулевым SQL_EXEC_ID, [...]
Source: iusoltsev.wordpress.com
Пт, Июл 12, 2019

If you've been wondering why I resurrected my drafts on the opt_estimate() hint, a few weeks ago I received an email containing an example of a query where a couple of opt_estimate() hints were simply not working. The critical features of the example was that the basic structure of the [...]

Source: jonathanlewis.wordpress.com
Комментирование отключено.