I have been asked a couple of times for a script that would reproduce the results in the time series forecasting series. I finally managed to do it. In the process I found out that a couple of the queries needed to be tuned:In the airline example described in Part 2, the normalization shift and scale parameters were computed using the whole data. A better methodology would be to use only the
If you have application running on Oracle 220.127.116.11 and you are massively using CONTEXT indexes, you better analyse the queries where context indexes are involved, before you decide to migrate to 10.2.0.x.This is because execution paths might be way different in 10.2.0.x that may lead to performance degradation.Here is one example where you should consider query modification in order to avoid bad performances.Let assume that you have a query that has OR-condition where OR-predicates use CONTEXT operators.Example:select a.owner, a.object_name, b.subobject_name, c.object_idfrom all_objects_a a,
It’s been a long time since my last post on this blog.Ok, one of the reasons for this “absenteeism” was my new job. Honestly, I didn’t have too much time to write anything except reports, research papers, proof of concepts, etc.Although I commute more than I used to, I don’t mind since I use every chance to read something interesting while riding on CTA trains.In three months, only in train cars I’ve read three books, two for the first time and one for the second time (just because it is perfect).1.
Kernel işletim sisteminin bir parçasıdır. Process scheduling, memory management, thread management gibi management işleri ile uğraşır daha çok. Donanım( hardware ) ile kabuk ( shell ) arasında bağlantı oluşturur. Demek istediğim kullanıcılar direk olarak donanıma erişemezler. sistem çağrılarını kullanırlar. sistem çağrılarını kernele ulaşan fonksyonlar olarak düşünebiliriz. "Kernel attack" linuxte handle edilemeyen errorleri belirtir. ( %30 ingilizce yazıyorum :) ) bir process te bir hata olduğu zaman eğer bu hata fatal ise kernel attack oluşur.
In an AskTom thread about native compilation, a poster mentions that he is seeing some big CPU waits on his system and wonders whether native compilation would help. After some discussion of tracing and profiling and his 32 Tuxedo connections, he reports back that from talking to the programmer (possibly this guy), he might have narrowed the problem down to a procedure called DELAY():
According to www.identifiers.org, there are two classes of relational database: "Code Class" and "Identifier Class".
We hadn't heard of those either, but it's all made clear in this presentation (pdf, 1.2MB), in which the limitations of the conventional approach and a novel approach to schema design are explained without the aid of Powerpoint, in a series of pictures like this one:
I have just received this from Product Management:We are pleased to announce the newOracle Data Mining 10gR2 Code Generation releaseis now available for download (RTM) on OTN.This new ability to go directly from a data analyst building predictive models to having working in-database PL/SQL code for implementing a complete data mining solution is unrivaled in the industry. There is no data
I wont be posting or answering comments for the next week as I'm down by the banks of the Mississippi for the Arkansas Blues and Heritage Festival. Anyone else going? See y'all there (must be said with an English accent tinged with Arkansas). Otherwise, hope to see some of you at Oracle OpenWorld later in the month