I'm looking at a client's tkprof output, showing among other things
that the insertion of about 135,000 rows taking 450 seconds of CPU, and
with current mode buffer gets numbering almost 800,000. This is a
daily warehouse load process, and I know that indexes are left in place
during the load.
About a month ago we had a small group of remote users that started using
our 9IAS server to gain access to an online application. Previously these
users were like the rest of our remote users using our 6i forms and reports
servers. The group of users had to switch to 9ias because
JL,
When you describe the field type in the SQLLoader file set the
CHAR(4000)
as the field description. You are correct in saying that the default is
CHAR(255).
As an example;
col1 terminated by , ,
col2 CHAR(4000) terminated by ,
...
Ron
[EMAIL PROTECTED] 03/13/03 01:44PM
Hi...
I would like
Hi,
I'm currently
defining an optimization strategy for a reporting
environment.
The reporting
environment is refreshing 41 materialized views on a weekly
basis.
Some of the MV take
over an 1 hour to refresh.
During the MV
refresh, in Statspack, I can see that the top SQL are
Jonathon et al, is it really true that every session is waiting on the
others if as each session is spawned, it does its thing (i.e. issues some
set of queries) and then disconnects? There are never two sessions doing
something simultaneously really. The user logs in and only sees and works
with
All they wanted was to pair up those city codes.
DAL -- AUS followed by AUS -- DAL,
AUS -- HOU followed by HOU -- AUS
etc...
and on separate lines.
So, cross-tab did not have the right format.
I sent them Jacques Kilchoer's solution (he also sent me a simplified one, without the
UNION),
Vadim,
Apologies, I answered the question
you didn't ask - viz why does it take
so long, rather than the 'what are the
CR gets'.
Your second suggestion is the correct
one. It seems unreasonable, but when
you do the select for update, Oracle
seems to go through a load of read-
consistency work
Programming the Perl DBI from Oreilly is
really good for your need.
-Original Message-
From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003
8:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Perl Book
Usaually SAN and NAS is used for several good
reasons...the two main are...
1) High availability - When you have your database
files on SAN/NAS then you can bring ur database on another server when the
primary goes down. Obviously you have to use a cluster or Big IP (F5) on the
front.
2)
Dear List,
I have a table of size approx 10gig, and I need to partition based on the
YEAR. I have column in the table, REPORT_CYCLE_CD with VARCHAR2(7). The
data in the column of format MON . I need to partition the table based
on the year , that is, substr(report_cycle_cd, 4,4).
I've got
installed - my boss likes BMC so we bought it. I really don't use it too much.
It doesn't seem to have much different from OEM - a little better graphics, but
since I have my set of scripts that I've come to rely on I really don't use the
gui stuff a lot except for my freeware
Is this cheating?
1* select a.c1||' '||a.c2||CHR(10)||b.c1||' '||b.c2 RESULTS from crap a,
crap b where a.c2 = b.c1 and b.c2 = a.c1
SQL /
RESULTS
---
DAL AUS
AUS DAL
HOU AUS
AUS HOU
AUS DAL
DAL AUS
HOU DAL
DAL HOU
LIT DAL
DAL LIT
XYZ DAL
DAL XYZ
AUS HOU
HOU AUS
DAL HOU
HOU DAL
I am not suggesting that sessions are waiting
for each other, or reporting each others' wait
times. I am simply assuming that if the application
design was daft enough to spawn multiple sessions,
it probably was clever enough to have the parallel,
independent threads of execution making all
The Metalink description of this hint seems
a little obscure. My experience is that it
simply allows you to reference a nested
table directly without 'pseudo-joining' it to
its rightful parent.
Given the funny games (such as using
a thoroughly spurious /*+ cardinality() */
hint, and bypassing
Kirti,
What about solution suggested by Stephane Faroult:
select *
from (select *
from T
connect by col1 = prior col2
and col1 col2) x
where rownum = (select count(*) from T)
/
?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
Rahul,
This is personal opinion, but it looks to me like your concerned about the
database your creating for the client and may not have the total or corporate
wide view your client has. We're heading down the SAN road not because of any
specific database requirements but because disk
On HP, I believe that async I/O is only supported for raw filesystems. See
MetaLink for more details.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, March 13,
Babu
I don't think partitions are clearly documented anywhere. Here is some SQL
that works so you can see how to use a date function. It partitions on two
columns, but I wanted you to see something that works.
add partition sum_fy_28
values less than ('FY',
No, I think you will have to add a column to store '' separately in
order to partition on it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:14 PM
Dear List,
I have a table
Thanks Jared and Scott for your
replies. Scott: I ran your lslpp -L |grep -i dce,
but it did not produce any output. Which dbv did produce the expected output.
I had opened up a TAR with Oracle this
morning, and they set me straight in fairly short order. This problem is
due to a bug.
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original Message-
Sent: Thursday, March 13, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
??
Dear List,
I have a table of size approx 10gig, and I need to partition
I think you can relatively safely argue that Oracle is spending 90% of it's
time waiting for the client (by that a user pressing a button or the
application processing some logic) - and therefore even if you make Oracle
run infinitely fast you will only improve the application overall by 10%.
Hi,
Thank you to all those answering my java script
question.
As I said, all the html and java script are generated
by pl/sql package. I'd like to know can the onClick
method below call a pl/sql procedure? If it cann't, I
suppose onClick needs to call a java script function
first, and in that
Igor Neyman wrote:
Kirti,
What about solution suggested by Stephane Faroult:
select *
from (select *
from T
connect by col1 = prior col2
and col1 col2) x
where rownum = (select count(*) from T)
/
?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Igor,
I can
I am create database on ORACLE 9iR2 and fail on create
rollback segment.
SQL create tablespace rollback_space datafile
2 '/u4/oradata/TRAN/rbs01TRAN.dbf'
size 800M
3 default storage (
4 initial 256k
5 next 256k
6
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original
I am finding tons of "log buffer space" waits
in 10046 output . Does it necessarily means I should look for resizing
log_buffer ? What else can be done or looked at to reduce these waits
.
Thanks,
ak
Mike,
Check the setting for undo_management. It needs to be set to MANUAL.
mike mon wrote:
I am create database on ORACLE 9iR2 and fail on create
rollback segment.
SQL create tablespace rollback_space datafile
2 '/u4/oradata/TRAN/rbs01TRAN.dbf'
size 800M
3
Hi Listers,
I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to increment the fixed_date.
I did that dbms_job.submit(:job_num, 'myprocedure;',
sysdate, 'sysdate');
the dba_jobs table show me the right interval un
next_date:
Mike
The only way this would have worked under 8i is if you had already
created a dummy rollback segment in the SYSTEM tablespace. Something
like this should work (before or after the CREATE TABLESPACE
rollback_space)
SQL connect / as sysdba;
SQL CREATE ROLLBACK SEGMENT dummy;
Pete
There are many things I don't get in this life. One of them is the
statements about disk storage being an admin nightmare and way too
expensive. Aren't disks very cheap these days?!
Mogens
[EMAIL PROTECTED] wrote:
Rahul,
This is personal opinion, but it looks to me like your concerned
No
-Original Message-
Sent: Thursday, March 13, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
???
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy
Title: RE: Fixed_date and dbms_job
After calling dbms_job.submit, did you issue a commit?
-Original Message-
From: Kader Ben [mailto:[EMAIL PROTECTED]]
I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to
Title: RE: Create rollback segment under ORACLE 9ir2 failed
I see other people have already answered your question, but would it be presumptuous of me to ask why you are using ROLLBACK segments instead of an UNDO tablespace?
-Original Message-
From: mike mon [mailto:[EMAIL
Mike, et.al,
Mea Culpa. Please ignore my previous post. I failed to properly
context switch from my Automatic Undo mode.
IIRC, as of 7.3, the requirement for a second rollback segment in
SYSTEM was removed, with minor exceptions. I think the one that is
biting you is that a second RBS
Please ignore my silly comments about 3000 queries. My brain is waking up
and realising that 3000 is the number of SQL*Net messages. In essence,
ignore my message and listen to Jonathan.
- Forwarded by Mark Richard/TRANSURBAN on 14/03/2003 09:56 -
And what Pete said does work.
Here is a report from my testing of undo mode switching (AUM - MUM). Rollback
tablespace was already created.
SQL create rollback segment rbs01 tablespace rollback;
create rollback segment rbs01 tablespace rollback
*
ERROR at line 1:
ORA-01552: cannot use system
Unfortunately, it is.
- Kirti
-Original Message-
Sent: Thursday, March 13, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Is this cheating?
1* select a.c1||' '||a.c2||CHR(10)||b.c1||' '||b.c2 RESULTS from crap a,
crap b where a.c2 = b.c1 and b.c2 = a.c1
SQL /
RESULTS
Title: Message
All,
I would like to open
a discussion to solicit information regarding the support structure you utilize
in your Data Management department.
We currently have a
flat end-to-end approach whereby a dba adopts an application and subsequent
database in the early planning
Increasing log_buffer size is an option, if it is really small.
I
would also check if the redo logs are on a busy disk. If so, try moving those
(or other busy data fileson the same disk) to othernot-so-busy
disks.
-
Kirti
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
-Original Message-
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
There are many things I don't get in this life. One of them is the
statements about disk storage being an admin nightmare and way too
expensive. Aren't disks very cheap these days?!
Title: RE: monitor transactions over time
Today,
Oracle Support updated my TAR, stating that there won't be a patch released to
fix this bug (#2506774) in 9i R2.
Suggested workaround is to derive TXNCOUNT by
subtracting the numbersfrom theprevious sample
period.
And when you write one,
Disks are cheap until one asks for them ;)
- Kirti
-Original Message-
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
There are many things I don't get in this life. One of them is the
statements about disk storage being an admin nightmare and way
Title: RE: monitor transactions over time
Make
that bug #2506744.
Sorry..
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Thursday, March 13, 2003 7:20 PMTo:
'[EMAIL PROTECTED]'Subject: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was
-- RE: monitor transactions over
Babu,
On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'),
PARTITION P1999
AK,
If the log buffer is at least 4MB, then increasing
it will not help, rather it may hurt. The log buffer is flushed when any of the
the follwoing occur
(i) 1 MB is filled up
(2) 1/3rd is filled up
(3) every 3 seconds
(4) when a checkpoint occurs
(5) when a commit occurs.
Therefore, see
Hello,
are there any list of 5-10 questions
which we can 'generally' ask to judge the 'potential'
of a person to be an Oracle dba.
These questions may include questions on attitude also.
Cyril
PS: I am seriously looking at hiring some 6months to 1 year
experienced Oracle apps dba.
Hello,
are there any list of 5-10 questions
which we can 'generally' ask to judge the 'potential'
of a person to be an Oracle dba.
These questions may include questions on attitude also.
Cyril
PS: I am seriously looking at hiring some 6months to 1 year
experienced Oracle apps dba for my
101 - 148 of 148 matches
Mail list logo