 | | | Oracle List | | Hello List
We have solved log file sync issue and received another issue with
heavy concurrent inserts. We have couple of tables used for heavy
inserts and they are in tablespace which is LMT and ASFyi if you 're planning to come to this year 's Hotsos Symposium in
Dallas this Friday is the final day to register at the discounted rate.
Cary Millsap
Hotsos Enterprises Ltd.
http //www.hotsoI was just reading this white paper on tuning AIX 5L for Oracle
http //www-03.ibm.com/servers/enable/site/peducation/wp/9a46/9a46.pdf
and am curious about the section on Large Page Memory (page 1It seems to be breaking on 50k.
--
Regards
Ranko Mosic
Contract Senior Oracle DBA
B. Eng Oracle 10g 9i Certified Database Professional
Phone 416-450-2785
email mosicr@(protected)
http //ca.geocitThomas
>We 're doing an INSERET through a view. The insert statement is pretty
>straight-forward and doesn 't have any apparent subqueries. It works
>fine if I run it in SQLPlus. However we 're runnAll
We have a pair IBM P690 machines running AIX 5.3.
I was wondering if anyone is running RAC on these machines.
Is it true I would need to use RAW devices because of RAC? "Normal "
fileHi Paul
our application sometimes generates about 4-5MB per second. i use a log
buffer of 5MB..sometimes 6 MB. we get about 8-14% waits for log file sync
depending on what our application does.
soI had the same problem on Sun I found this guy 's tools in Perl
(specifically prusage). I doubt they work for RedHat but I presume the
same type of stuff must be out there. Have you checked sourceforgHi
any idea what version of Oracle that you are using -)
thanks for the info...
well there is a lot of debate on 'log file sync ' and 'log file parallel
write ' and there is timing bug too. Look aHello
I have a situation where a customer has "accidentally " dropped a datafile from a tablespace. The good news is that the datafile was empty since she just added it. The bad news is that there isHi All
Can anyone explain why the cardinality is way off from the expected
2Mil mark. Below query should return a count of 2million rows. However
both index and full scan give 133k.
Query with inde
Hi
I have heard that 9.2.0.8 will be the terminal release for Oracle9i and that
it is not too far off in the future. Anyone have any better info on when it
will be released?
I am trying to decide wheHi
We are about to move a small application from Windows / SQL Server to AIX / Oracle 9.2.0.6. Any thoughts on how to move the data over in as painless a manner as possbile? Of course there is nHas anybody seen a book on Oracle Text? I have already looked at the PDFs
from Oracle. I am wondering if there are any resources out there about
Oracle Text?
thanks.
I know it sounds a bit simplistic but how about
testing the patch in a test environment. Clone
production and patch away with no worries.
Good luck
Eddy Frances
--- "Allen Brandon " <Brandon.AlleMichael
If you have SQL Server in the mix why not use the free tool that comes with
it? Informatica is pretty impressive.
Dennis Williams
On 2/13/06 Wu Michael <xwu@(protected) > wrote
>Hi
Just like to add that
1) Gather histograms only if you are using literal SQL. i.e if you are
using Bind Variables in your queries then it doesn 't make much sense to
gather histograms because Can you tell what is the blocks
from dba_segments
for these segments.
Thanks
"Nahata Naveen (US - Glen Mills) " <nnahata@(protected) > wrote
I did a full compute see below
you need to learn about *shared* memory all these meomry tools dont deal
with it very well.
On 2/13/06 hitender chugh <chughhk@(protected) > wrote
>
> I am not sure whether it is the right forum buI am not sure whether it is the right forum but I want to know if any one
has experienced this kind of problem and may provide guidance/suggestions.
I have a new HP-UX server on which I have installeFYI I used DBMS_REPAIR to identify all corrupt blocks in the segment
then attempt to fix or skip them entirely. From this I was able to
retrieve 77K+ blocks of data skipping 110. This is good enoGREAT Company in the Bakersfield California area (100 miles north of Los
Angeles) has an opening for an for a Sr. Oracle DBA with 8i/9i and 11i
applications modules experience.
* Bakersfield is knoOkay I need some serious help here. I 've got a need to restore 1 table
from a large tablespace (2.5TB) back on Friday. The database is Oracle
9.2.0.6 with archiving on and backed up weekly level 0 OEM grid control v2
--
Ron Reidy
Lead DBA
Array BioPharma inc.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Simone Saravalli
SVivek wrote 1 Datafile ( as one datafile a datafile only one
datafile)
He didn 't write Datafile 1 (as the first datafile)
He also wrote it was added after the last HOT backup. Datafile 1 is
usualDid this get fixed? I frequently need to apply recovery from one of
the redo logs when cloning databases. I am not sure what causes this
but I know it works. I guess I ought to figure out why anyone
As a cross-check you need to compare the redo
from using a GTT with the redo from using a
normal table.
The answer to your puzzle is that changes to the
GTT do not generate redo but they do gener
Just a wild guess - but if you are running
in archivelog mode perhaps the archive
got confused when it got told to archive
a log file that hadn 't been written ?
Regards
Jonathan Lewis
http //wwwDoes Oracle have any product like Microsoft Data
Transformation Services(DTS) that is free? The
closest thing I 've seen is Oracle Warehouse builder
but it cost money.
Eddy
--
http //www.freelists.or |
|
|
