Thanks for your reply Jonathan..Here is an update..
The update that i sent you yesterday is updating a column on which there
is a local bitmap index. There are also other local bitmsap indexes on
that partitions. Yesterday i made all the local indexes pertaining to
that partition UNUSABLE and we go
Hello All,
I have a strange problem...
I have a table on which i am doing an update. Its a partition table and
the local index on the column which is being updated is in an unusable
state.
I have a database trigger at statement level (before update of col_a for
) where i do an execute
Hello All,
I have a question on data file permissions.
When i add a new data file, it gets created as -rw-r-
Umask for oracle user is 022.
There is a unix user who wants read access to the data files since they
are read by fastunload process (syncsort).
When i do a touch on any file in that
Hello All,
We have a huge table both is terms of number of columns and rows. It is
list partitioned. it has 7 mill rows and its avg row length is 600
bytes. One of the developers has come up with a method of truncating
and reloading the table on a daily basis thorough sqlloader. everyday
-- Sorry the earlier post was incomplete.
We were running a serial update on a fact table (45 mill rows) using the
old tech of
declare
cursor ...table temp
begin
for c1rec in c1 loop
update fact
where period_key = c1rec.period_key and loan_key = c1rec.loan_key
commit every 10,0
We were running a serial update on a fact table (45 mill rows) using the
old tech of
declare
cursor ...table a
begin
for c1rec in c1 loop
update fact
where period_key = c1rec.period_key and loan_key = c1rec.loan_key
commit every 10,000 rows
end loop;
end;
fACT table partit
Thanks for your reply ...
I understand that it is a sql per row update but the same update on UAT
environment works at a rate of
about 2000 rows per sec. Though the data volume is definetly less
compared to PROD, still there is night and day difference between prod
and uat..In terms of the tables
Hello ALL,
Oracle ver is 9.2 running on EMC array. I am executing a pl/sql
procedure which does an update on a fact table. There is an unique
index on the fact, with clearly shows up in the explain plan for
udapte.
I ran 10046 event for a 18 min duration during this update process and
t
Hello All,
I am in the process of creating a bitmap index on a foreign key in a
fact table(partitioned) comprising of 10 mil rows.
The distinct count on the foreign key is 4 mil. This is to ensure
that star transformation works.
I have a degree of 8 for the table and when i am cre
Except for primay key constraint we dont have any other constraints or
indexes present during the load.
What does the sql * net wait events signify. Is there cause for concern
when we see those events. ??
Thanks,
Sathish.
On Wed, 23 Oct 2002 09:02:21 -0800, "Whittle Jerome Contr NCI"
<[EMAIL PROT
Hello All,
We are running oracle 9.2 on a sun box in a DW env.
Data loads are thorugh informatica.
During one such load of fact table, the load time per sec is about 300
rows per sec.
The table is suppose to load about 5 mil rows.
During the load i happen to do
sys.dbms_system.set_ev(
Thanks Kirti for the suggestion..it works now.
Sathish.
On Mon, 14 Oct 2002 19:53:23 -0800, "Deshpande, Kirti"
<[EMAIL PROTECTED]> said:
> Create logon triggers for these Informatica user id to alter session
> set...
>
> - Kirti
>
> -Original Message-
> Sent: Monday, October 14, 2
Thats what we exactly did except that iniformatica starts a separate
session when it is loading the target
which results in the error "unusable state" .
sathish
On Mon, 14 Oct 2002 15:44:02 -0800, "Khedr, Waleed"
<[EMAIL PROTECTED]> said:
> In Informatica there is a stored procedure transform (r
Hello All,
This problem pertains to local bitmap index in dw env.
We are using informatica to load our fact tables.
i have a fact table partitioned on period key (range partition).
We have built local bitmap indexes on the foreign keys.
During the loading of the fact table for month 1, we are ma
14 matches
Mail list logo
