I know I used to set up RPT and do all sorts of complex updating things. At the State
and with things coming from mainframes, the data organization seemed to lend itself
well to RPT.
Since the organization was like of loops within loops, I could take the high order
update and then loop through
This may be more on that parallel being set too high, but looking for ways to improve
insert speed. I've seen the "APPEND" hint mentioned, but not sure if that speeds
things up or simply says "Insert at the end".
Also, a co-worker found a PL/SQL on a "degree=4" table that has a cursor, then one
I've inherited a system that has a whole lot of indexes set to degree 10 and many
tables set to 2 & 4.
The users are complaining that Precise is showing a whole lot of time in "Parallel
Sync Wait".
It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy.
Are there
I found myself working with some "larger" databases in the 500-800 GB range that also
spawn into multiple test databases.
I take a "df -k" or "bdf" and bring that into excel. Then I take a query on all
"autoextend" and break that out by disk.
then I put that all together and tell what's left on
We have a data warehouse around 850gb.
I have a question on procedure.
We only keep 2 months data in several groupings by month, with 3 months "ready"..
So, say Nov is in M1 and Dec is in M2.
At the end of December, we will create an empty January which will go back into M1 and
we will be tunc
I've got a perfect application for partitioning by date. Each "month" is a new batch
of data and everything is set for the last date of the month.
But they asked me today, if we drop a partition of old data, and then add a new
partition for the next month, load it, what needs analyzed?
Is it en
Below was the closest I got, but it still pretty much shows everything "empty" sort
of. Guess it's okay, I'll monitor. This is a warehouse so it's hard to say. So close
to the holidays, it's possible they aren't using a lot of temp.
set linesize 162
set pagesize 30
column tablespace_name forma
It appears one database I can not query the temp tablespace.
It's local, unform extents, but nothing shows up in dba_segments or any where I have
found thus far.
Has this progressed to a "trust me" type of situation?
Even TOAD gives me nothing but blanks on objects in TEMP yet on other database
Anyone change character sets recently?
I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it
was.
It sounds like they have all the steps down pat and are pretty much ready to go, but
are there any "gotchas" they may have missed?
Will this affect the RMAN backup