Depends mostly on your users needs. If most of the time your users would want monthly
sum of measures, you give them a
materialized view for that.
You can also use the summary advisor feature of oracle (dbms_olap) to find out which
mviews oracle thinks is needed based on
usage.
=)
Chuan Zhang
Hi, All,
Just wonder what's tool or methodology you are using to select materialized view in
Oracle data warehouse environment?
Many thanks in advance,
Chuan
Unless otherwise stated, this e-mail does not represent the views of
TransACT Communications Pty Limited. This text and any attac
Mladen,
Read http://www.hotsos.com/dnloads/1.Holt2000.02.01-Backwards.pdf (by
Jeff Holt) for complete details about the difference between Oracle's
"scattered" and "sequential" reads.
Read http://www.ixora.com.au/tips/tuning/redo_latches.htm (by Steve
Adams) for details on the redo latch questio
On 2002.08.18 23:48 Cary Millsap wrote:
> >
> > 4. 'db file sequential read' does *not* typically indicate a
> > full-table scan, because 'db file sequential read' events, since
> > Oracle8.0 are almost always single-block read calls (before that, the
> > event could indicate multi-blocks rea
>
> 4. 'db file sequential read' does *not* typically indicate a
> full-table scan, because 'db file sequential read' events, since
> Oracle8.0 are almost always single-block read calls (before that, the
> event could indicate multi-blocks reads of sort segment blocks into a
> PGA).
[DM] Doe
[EMAIL PROTECTED] wrote:
> >Grant,
> >I agree with Lewis, things are tight here. Very hard to find work and you
> >have to compete hard on rate to have a chance.
> >You have to work as a ltd company - does not cost much to set up , or use
> an
> >umbrella company.
> >I would recommend joing the Pr
Hi Cary
Thanks for the feedback, comments inline
Cary Milsap wrote
>
> Some questions and a couple of comments regarding Dave's note:
>
> 1. RE the "tuning from a blue collar DBA perspective," is it accurate to
>
> paraphrase the described method as: "No matter what might be causing the
> per
Thanks.
On Sunday 18 August 2002 13:43, you wrote:
> Don't forget about the relink script in $ORACLE_HOME/bin. This is new
> starting with 8.1.7 (I think).
>
> From the script...
> #!/bin/sh
> #
> #NAME
> # relink
> #
> #DESCRIPTION
> # performs manual relinking of Oracle pro
Don't forget about the relink script in $ORACLE_HOME/bin. This is new starting with
8.1.7 (I
think).
>From the script...
#!/bin/sh
#
#NAME
# relink
#
#DESCRIPTION
# performs manual relinking of Oracle product executables based
# on what has been installed in the ORACL
Thanks.
On Sunday 18 August 2002 12:03, you wrote:
> Huge symbol tables, slow PCI 133 RAM, insufficient L2 cache, weak CPU,
> an enormous library that you're trying to produce.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Net
Thanks.
On Sunday 18 August 2002 12:23, you wrote:
> "genclntsh" is a UNIX shell script run by the Oracle installer, so you can
> debug it like you would any shell script. It is located in
> "$ORACLE_HOME/bin", so go to that directory while logged in as the Oracle
> software owner in UNIX and si
Thank you very much for your informative little tutorial.
I appreciate it a lot.
I will give it a shot.
Thanks.
ltiu
On Sunday 18 August 2002 12:03, you wrote:
> The error message in the "install.log" or "make.log" files should narrow
> your choices down, but in general...
>
> Underneath "$OR
Huge symbol tables, slow PCI 133 RAM, insufficient L2 cache, weak CPU,
an enormous library that you're trying to produce.
On 2002.08.18 14:18 ltiu wrote:
> If linking is stuck at genclntsh, 100% cpu utilization, no disk activity,
> what could be the possible reasons for this?
>
> Thanks.
>
> l
"genclntsh" is a UNIX shell script run by the Oracle installer, so you can
debug it like you would any shell script. It is located in
"$ORACLE_HOME/bin", so go to that directory while logged in as the Oracle
software owner in UNIX and simply run the script. Maybe it will duplicate
the problem yo
The error message in the "install.log" or "make.log" files should narrow
your choices down, but in general...
Underneath "$ORACLE_HOME" there are several ".mk" files, which are scripts
for the venerable UNIX "make" command. To find them, you can run the UNIX
"find" command as follows:
$ fin
Oracle9i hasn't introduced such a parameter; the best way to achieve what
you want below 9i is to resize redo logs to be smaller (which several
replies have already mentioned)...
With 9i Data Guard, you have options where you can set LGWR to ship redo log
files to the standby, and there is even
If linking is stuck at genclntsh, 100% cpu utilization, no disk activity,
what could be the possible reasons for this?
Thanks.
ltiu
On Sunday 18 August 2002 10:18, ltiu wrote:
> There is apparently two stages to the Oracle installation on Unix. A file
> copying installation where all the requi
There is apparently two stages to the Oracle installation on Unix. A file
copying installation where all the required binaries are copied from cdrom to
hard disk and a linking install where the binary/object files are linked.
If the first stage succeeds but the second stage does not. How do I s
I am not sure if 9i has introduced any such parameter.
Other than sizing smaller redo log files [but that still doesn't guarantee
that you get a log-switch every X minutes], you'd have to write
a DBMS_JOB or a CRON job to do an ALTER SYSTEM SWITCH LOGFILE.
Hemant
At 06:08 AM 18-08-02 -0800, you
Andrey, I assume, version < 9.x of the database?(if i'm wrong let me
know and we can talk about 9i features of data guard).
How about a job(via dbms_job) to do what you want?
joe
Andrey Bronfin wrote:
>Dear gurus !
>It's either a Sunday's dead brain or ..
>Is there an init.ora parameter
Ron , thanks a lot !
I know this solution , but:
there are certain pick-times when there are many activities going on against
the DB. Therefore making the redo logs smaller will cause performance
problems. So , i'd have this solution as a last resort, in case i will not
find an init.ora solution.
The ADABAS/Natural/Predict list server that I know about:
http://www.uark.edu/sag-l/faq.html
You can also contact me directly and I will help if I can.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 6:0
Dear gurus !
It's either a Sunday's dead brain or ..
Is there an init.ora parameter to force redo logs switch every 3 minutes or
so ?
( the reason is that I need frequent log switches in order for the standby
database to pickup changes frequently , i.e. to be "almost" in sync with the
primary
Hello Bob
We had the same thing an it was because the current connections + oracle SGA
used up to 2GB limit of memory available for oracle on NT. The solution for
us was to lower the size of the block_buffers so the SGA used less memory.
The solution that Chaim talks about works only on NT Enterp
I'm sure that each source is accompanied by some type of explanation?
Surely neither would make such a bald sweeping statement without some
substantiation?
I would agree with your summarization of Mr. Lewis's position. The type of
I/O activity associated with online redo log files (i.e. high vol
Another thing to consider is this:
>From OraPerf:
The LGWR needs to scan all processes to find each process that is
waiting for the commit to be written.
So when you have an excess of process LGWR works harder.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
Hello Antje
Pay close attention to the type of windows version they install on the
server.
I got into a situation where I wanted to use 3GB for Oracle and it turns
out that we have the standard NT edition instead of Enterprise edition
and a single process is limited to use 2GB memory.
Yechiel Ad
I sit corrected.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 4:43 PM
> yechiel,
>
> I didn't miss the comment, it's not relevant. Archived logs are merely
> copies of redo logs that have been fi
Title: RE: DBA tools on NT - PERL
I am going to buy Jared book.
He wrote to me that the book is currently available on
Amazon.
You can use www.perl.com
to supplement tour needs.
Yechiel AdarMehish
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list
Hi,
please give your opinion.
I am reading Jonathan Lewis book Practical Oracle 8i.
He says redo log definitly should be placed on raw devices.
On the other hand I have a couple of years old document by Oracle
stating redo logs definitly do not belong on raw devices.
So who is right?
Antje Sackw
I don't know if anyone has implied that it *was* unnecessary for Windows;
it's just not done. But hard lessons have proved it necessary on UNIX;
it's not only Oracle that does this...
...as Freud is reported to have said, "Sometimes a cigar is just a cigar"...
- Original Message -
To: "
31 matches
Mail list logo