Recent content by Feodorit

2 Alex Thank you for your reply. But in this case problem was in 9.2.0.5 patch, in catpatch.sql simply no call to catcio.sql. Manualy run catcio.sql fix this problem.

Oracle 9.2.0.5 Unusable indexes after loading data using SQL Loader. I know this is a known bug (for direct=true). How to fix this bug?

If there any restrictions on pipelined functions as object methods? TYPE number_t AS TABLE OF number; dummy pipelined function: FUNCTION pipe_test2(Dat_Spr date) RETURN number_t PIPELINED is BEGIN PIPE row(32); RETURN; END; SELECT * FROM table(pipe_test2(trunc(sysdate)))...

Hi AOLEURO Thank You for Your posts > As I see it, you still got a problem in parsing. Excuse me, I didn't post to forum, that problem was solved by analyzing tables with DBMS_STATS. Problem appear when partitions were added to the tables and no analyzing statistics on tables - only analyze...

Allan> In generally - partition do not increase performance - the idea is to minimize contention between concurrent sessions and increase availability. "Index range scans – Partitioning physically sequences rows in index-order causing a dramatic improvement (over 10x faster) in the...

SQL> select (1-(sum(getmisses)/ sum(gets)))*100 2 "Hit Ratio" from v$rowcache; Hit Ratio ---------- 99,2230576 Thank You for spending your valuable time, but I need some time to thoroughly verify my data dictionary.

TKPROF: Release 9.2.0.2.1 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved...

Thank You, with your help we at last have precisely stated problem: results from tkprof EXPLAIN PLAN SET statement_id = 'firstquery' FOR select * from t2_main where data = trunc(sysdate-156) call count cpu elapsed disk query current rows ------- ------...

sem> Measuring times on client side doesn't take into account client and network problems Question is comparison two queries, in same conditions. Test repeated many times during 4 days. Now I will try to compare explain plan statements for this queries.

sem> Does tkprof show the same (13 seconds) time? Maybe it is lack of my knowledge in Oracle, but I don't know where tkprof show time for parsing, time for executed is 0.8 second, but if I send statement, and for a period time tkprof not show that session execute statement. Adding some where...

sem> Do you experince such problems with all partitioned tables? No, for 3 from 7 in this schema. sem> BTW, how large is it? Appr. number of rows and partitions? Medium size, I will take this table for test (Rows near 6 millions. Partitions 760).

select * from v$waitstat; CLASS COUNT TIME data block 4798 415 sort block 0 0 save undo block 0 0 segment header 28 0 save undo header 0...

select * from v$sgastat; fixed_sga 456092 buffer_cache 763363328 log_buffer 656384 shared pool errors 193316 shared pool subheap 50816 shared pool KGK heap 3756...

targis> I'm not sure if targis is my Host. If you have Windows OS simply lool at your host file to verify Your host targis> How do you find out what the service name is??? Service Name I am quickly verify by looking on windows service name (sorry if You are Linux-man), it is OracleServiceXXX...

sem> And how have you measured these intervals? Execution time I get from front-end Oracle tools and parsing time intervals is my own based primary on "Prepare statement..." and tkprof and getting statement differences. sem> Are you really talking about seconds, not about...