Main Entry:
1du·al
Pronunciation: 'dü(-)l also 'dyü-lFunction:
adjectiveEtymology: Latin dualis, from duo two -- more
at TWODate: 16071 of grammatical number
: denoting reference to two2 a : consisting of two
parts or elements or having two like parts : DOUBLE b : having a double
Hi
Can autobackup of control file be NOT enabled?
If you do full database backup using RMAN you get the controlfile like it
or not, isn't it?
So i'd say a because with b you don't automatically get the controlfiles
Jack
Hello All:
I am using Oracle Forms 6i. I have a Form where I have to send an email of
the data entered in the Form using Lotus Notes email.
Does anyone know how this can be done ?
Please guide me. If possible please send me the code for doing this.
Regards,
Faiz
Check at the following website, there is code for ending e-mail through
outlook, but I suppose you could modify it to use with Lotus Notes.
http://ourworld.compuserve.com/homepages/Peter_Koletzke/
HTH!
Aleem
-Original Message-
Sent: Monday, June 24, 2002 3:23 PM
To: Multiple
I am trying to alternate host to a point in time of 01-01-2002.
I restore current controlfile then run
run {
set until time to_date('01-JAN-2002 03:00:01','DD-MON- HH24:MI:SS');
allocate channel ch1 type 'sbt_tape';restore database;
recover database;
}
The netbackup log asks for a cold
On performance of triggers blocking update of primary keys.
There are two aspects to performance. First, that which impacts on cpu
cycles etc, and secondly, that which impacts on the integrity of the
fundamental database design. I regard the latter as crucial - and
non-negotiable. The former is
The log buffer is one meg right now. The application uses many, very small
transactions. There is no possibility of combining the statements into a
larger single transaction. There are no waits to allocate log buffer space.
I have also considered setting the _log_io_size to less than 1/3 a meg
Thanks to everyone who made suggestions on training courses.
Looking at my skill set and the requirements of my current
position, I am thinking about taking a course in capacity planning.
Does anyone have any recommendations?
Thanks,
Peter Schauss
--
Please see the official ORACLE-L FAQ:
Madhu,
I would have two snapshots and one synonym. Have the
webpages point to the synonym, and the synonym point
to one of the snapshots while the other is refreshing.
When the other is finished refreshing, recreate the
synonym to point to the refreshed one and start the
refresh on the other.
Faiz,
I'll make the assumption that your using an Oracle 8i (8.1.6 or better) as
the database server. In which case you can use the DBMS_SMTP package in Jserver
to send the mail to any mail client you want, especially since you obviously can
get Internet mail. Here is a wrapper I've
9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell
-Original Message-
Sent: Friday, June 21, 2002 12:07 PM
To: Multiple recipients of list ORACLE-L
in pure client-server mode?
if so:
quick, someone tell oracle tech support !!! :)
what versions of the database?
Hello,
probably I have littlebit strange question: can I physicaly transfer database created
under EE 8.0.5 (no advanced option of EE installed) to SE 8.0.5? Can I expect any
problems, should I use export/import? OS platform is Alpha Open VMS.
Thanks
Michal
--
Please see the official ORACLE-L
Madhu,
What are the problems?
Dick Goulet
Reply Separator
Author: Reddy; Madhusudana [EMAIL PROTECTED]
Date: 6/23/2002 9:03 PM
Jack , DG and ALL,
I Have problem in creating the Fast Refresh MVs, from the existing code ,
which i can not change
If you haven't used any of the EE features, you should be able to just
shutdown, change the ORACLE_HOME to point to the SE installation and
then startup the database.
I would do that, having first either done a full database export (if
the database is relatively small) or a backup of the
Ok, how is this pronounced? Is the G in GNU slient or
not?
mkb
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mkb
Check out the courses offered by Craig Shallahammar (sp?) at
www.orapub.com
--- Schauss, Peter [EMAIL PROTECTED] wrote:
Thanks to everyone who made suggestions on training courses.
Looking at my skill set and the requirements of my current
position, I am thinking about taking a course in
Hello Sam
Why do not restore the archive logs manually?
Ask RMAN to restore the database and then issue
the recover until yourself.
Then you have time to explore RMAN behavior.
BTW - did you backup the 2 weekly archive logs with RMAN
or was it a separate netbackup file backup?
Yechiel Adar
Check out www.orapub.com. Craig Shallahamer conducts Capacity Planning
course. I have not yet attended one but I have heard from others that the
course is very good.
- Kirti
-Original Message-
Sent: Monday, June 24, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Thanks to
General Restrictions on
Fast Refresh
The materialized view's defining query is restricted
as follows:
The
FROM list must contain base tables only (that is, no views).
It
cannot contain references to non-repeating expressions like SYSDATE and
ROWNUM.
It
cannot contain
Title: RE: GNU or [G]NU (Pronunciation of...)
I wish I knew since we do have a new problem with gnats on the gnus at our local zoo.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: mkb [SMTP:[EMAIL PROTECTED]]
Hi mkb125
AFAIK, it is silent, as in Gnome ;).
And as I was told, it's pronounced almost
like the American way of pronouncing new.
So I guess it's supposed to be a word play,
even though it's old software ;).
Have a nice and sunny day ... at work,
Stefan
-Ursprüngliche Nachricht-
The G sounds like the G in Good question
On Mon, 24 Jun 2002, mkb wrote:
Ok, how is this pronounced? Is the G in GNU slient or
not?
mkb
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
So.., is the w in Wildebeest, pronounced as a w or a v ??
-Original Message-
Sent: 24 June 2002 16:13
To: Multiple recipients of list ORACLE-L
The G sounds like the G in Good question
On Mon, 24 Jun 2002, mkb wrote:
Ok, how is this pronounced? Is the G in GNU slient or
not?
We've had problems with BO (hmmm...) against our 8.1.7.2.0 DBs. Sometimes,
when the user cancels a particularly bad BO report, the server process on
the DB loops infinitely.
Also, from a design aspect, it seems that it's difficult to join tables in
multiple ways for multiple reports. Not
Run at SYS and make sure that there are no users in the database when
running...
Regards,
Melanie
-Original Message-
Sent: Saturday, June 22, 2002 8:48 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have upgraded two databases from 8.1.6 to 8.1.6.3. After upgrade I ran
catalogand
Title: RE: Virtual drive on Solaris
Here is the command sample:
mount -f tmpfs -o size=800m swap /ramdisk
We use it to run a small database totally in memory. We decided that staying within the Oracle product suite was better for us vs. using a real memory-only rdbms. The mounting of
DG,
I am getting the following error :
ERROR at line 13:
ORA-12015: cannot create a fast refresh snapshot from a complex query
I have executed the following
CREATE MATERIALIZED VIEW GENRELOB_TEST
NOLOGGING
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
DISABLE QUERY REWRITE
Hi all,
Trying to deal with SHARED_POOL sizing and perf tuning for an 8.1.6.0.0 DB
that's used by 3rd party software. I can't seem to find if higher values of
SESSION_CACHED_CURSORS adversely affects the shared pool in any way.
Specifically, I'm wondering if the higher number of cached cursors
My understanding is that the developer mode is still client-server, but to do the
deployment
(more or less runtime?), you have to also have 9iAS set up and running.
Can you execute a form in client-server mode in the same manner as a user would (in
other
words, not in developer mode)?
Hi
Which patch # is for upgradation from 8.1.7.2 to 8.1.7.4 on sun solaris OS?
Thx
-Seema
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ:
Hi,
We are trying to make duplicate database on same machine (WIN2K) using RMAN.
so we created the entry for SID in listener.ora and tnsnames.ora..
Also we created password file as:
orapwd file=PWDV901DUP.ora password=manager entries=10
But when we try to connect to database we get error as:
Jared,
Just to clear my thoughts, doubts and keep learning from the list.
What implications can cause having a big log buffer.
As I can remember, LGWR copy data from the log buffer to the redo logs when
log buffer is 1/3 full, timeout, commit and a few more.
So it will fire when the first one
Mahud,
I don't think the database appreciates the 'distinct' clause in the select,
or the order by.
Dick Goulet
Reply Separator
Author: Reddy; Madhusudana [EMAIL PROTECTED]
Date: 6/24/2002 8:04 AM
DG,
I am getting the following error :
Ramon,
For one thing, LGWR will write the log buffer when it is 1/3 full, or if
it reaches 1MB. So, its useless to have the log buffer more than 3MB.
The space beyond 3MB could never possibly be used.
My .02
Beth
-Original Message-
Sent: Monday, June 24, 2002 1:28 PM
To: Multiple
Hi Ramon,
On Mon, 24 Jun 2002 09:28:21 -0800, Ramon E. Estevez
[EMAIL PROTECTED] said:
What implications can cause having a big log buffer.
You want to check the tip from Steve Adams to understand how log buffer
works and the implications of a big log buffer
Ramon, along the lines of Beth's idea here, how large are the archive logs
you are producing?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 24, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
Ramon,
For one thing, LGWR will write
Hi
I have a data server which is running several 8i instances (8.1.7) with
Jservers
on Solaris8. I installed 9i version 9.0.1 and created a 9i database
instance.
All instances and listeners were shut down when I did this. So far all went
well.
Then I used the database config assistant to clone
A new paper by Sun BluePrints called Drill-Down Monitoring of Database
Servers is at
http://www.sun.com/solutions/blueprints/0602/816-7191-10.pdf.
Looks good... well, until Step 5 where it talks about tuning using
Buffer Cache Hit Ratio's. Anjo, Cary, Mogens... any comments ? ;-)
--
Please
Craig Shallahamer, www.orapub.com.
I've taken the class, it's excellent.
Two things you will learn:
* There's more to capacity planning than you thought
* It's not that hard to do, given the tools and techniques.
Jared
On Monday 24 June 2002 06:43, Schauss, Peter wrote:
Thanks to
Dear All,
In my tkprof output rows values under explain plan
section are not getting printed, is there any
parameter to be set?
Thanks,
Ravi
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music
How can Values Set by a previously Issued ALTER SYSTEM SET Command be Found ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
On Mon, Jun 24, 2002 at 08:48:19AM -0800, Seema Singh wrote:
Hi
Which patch # is for upgradation from 8.1.7.2 to 8.1.7.4 on sun solaris OS?
Thx
-Seema
ID:1697372 Patchset::2376472 README
8.1.7.4 PATCH SET FOR ORACLE DATA SERVER
Product:Oracle Database
Platform:Sun Solaris OS (SPARC)
Vladimir Barac - posao wrote:
Good day to everyone...
I have two questions related to Linux and Solaris...
* I need do find memory usage (physical, virtual...) of a particular
proccess. PID is given by by ps, but what aditional parameters I have to
provide? At a first glance, output
I've always pronounced it, and heard it pronounced: Guh-noo.
Like the animal, which is the GNU logo.
Jared
On Monday 24 June 2002 08:13, Stefan Jahnke wrote:
Hi mkb125
AFAIK, it is silent, as in Gnome ;).
And as I was told, it's pronounced almost
like the American way of pronouncing
Oppps, Typo... vmstat should read: vmstat -S 5 1000
Suzy Vordos wrote:
Vladimir Barac - posao wrote:
Good day to everyone...
I have two questions related to Linux and Solaris...
* I need do find memory usage (physical, virtual...) of a particular
proccess. PID is given by by
If that's one of my scripts, RCS says it's from 1997.
Here's a newer one. It gets *everything* in the database, so
a little tweaking may be in order.
Jared
===
-- showspace_all.sql
-- use dbms_space to show exact amount
-- of space consumed by
Look ma, a 0% Buffer Cache Hit Ratio...
Some databases (for example, Oracle and Informix) avoid the buffer cache
entirely when carrying out table or index scans. *Top of page 23 in the
document.
Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456
-Original Message-
Sent: Monday,
H... http://www.m-w.com would seem to think that the G is gsilent.
And they have a pretty picture of a gnu, too, for your review, Cindy Lou
Who.
Don't practice your alliteration on me! -- Monty Python
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Dennis,
100MB archive log size.
Ramon
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 2:03 PM
Ramon, along the lines of Beth's idea here, how large are the archive logs
you are producing?
Dennis Williams
DBA
Lifetouch,
Is there NO Other Way to find How ?
In Particular :-
ALTER SYSTEM SET USE_STORED_OUTLINES=RBOCAT;
NOTE USE_STORED_OUTLINES does NOT appear in v$parameters NOT in x$ksppinm
Thanks
-Original Message-
Sent: Tuesday, June 25, 2002 12:15 AM
To: LazyDBA.com Discussion; VIVEK_SHARMA
In
Has anyone used dbms_session.free_unused_user_memory;
in a production environment?
Comments and experiences?
Thanks.
Saul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Solomon, Saul M.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
According to gnu.org, it's guh-new.
Jesse, Rich wrote:
H... http://www.m-w.com would seem to think that the G is gsilent.
And they have a pretty picture of a gnu, too, for your review, Cindy Lou
Who.
Don't practice your alliteration on me! -- Monty Python
:)
Rich Jesse
Don't forget,
LGWR also flushes the buffer every 3 seconds. Think about your transaction
rate and whether you will make use of a large buffer space.
My $0.02,
Andy.
--
Andrew Sit
Systems Engineer
DataMirror Corporation
+ 1 905 415 0310 (O)
+ 1 416 839 9908 (M)
-Original Message-
From www.gnome.org
Q: GNOME: "nome" or "guh-nome"?
A: In English, the word "gnome" is pronounced with a silent "g".
However, GNOME itself is generally pronounced as
"guh-nome", just as GNU is pronounced "guh-noo" when
referring to the GNU Project
Q: So what is GNOME?
A: The initials
Title: RE: SESSION_CACHED_CURSORS and shared_pool sizing.
I don't recall where I read this but I remember a few things about it. As you noted, the use of SESSION_CAHED_CURSORS has an impact on the UGA. If you are using MTS then that becomes part of the SGA in the shared pool (or large pool
Tks Dennis, Beth, Madhavan for your answer.
Now I get it. Learned something new today about Oracle, that's my goal.
Ramon
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 1:53 PM
Hi Ramon,
On Mon, 24 Jun 2002 09:28:21
VIVEK_SHARMA wrote:
How can Values Set by a previously Issued ALTER SYSTEM SET Command be Found ?
SQL desc v$parameter
Name Null?Type
-
NUM
Hi Tim
Yes, I have tried the _disable_logging, does not work on all platforms. DB
starts up fine, but redo log is generated, evidenced by log switching going
on.
Also if I do a normal DML (large-ish one to verify), then dump the redo log,
I see my transaction there, so for a 420R, running
From the GNU web site
Welcome to the GNU Project web server, www.gnu.org.
The GNU Project was launched in 1984
to develop a complete Unix-like operating system which is free software: the GNU system. (GNU is
a recursive acronym for ``GNU's Not Unix''; it is
That was my point.
It doesn't matter that log_buffer = 100MB, if every 3 seconds LGWR will fire
anyway even the buffer had only used 1k.
tks Andrew
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 3:23 PM
Don't forget,
Its unlikely that you'll get any real benefit from
it..The routine frees up pga memory for reuse, but
since the PGA is a heap (ie little bits all over the
place) so the stuff freed up is unlikely to be 'at the
end'. Maybe under MTS you'd see some benefit (?) but
for dedicated sessions, the freed
Hi:
There is no direct way to find out from the V$/X$ tables since the session
modified parameter settings are kept in the PGA and it is not visible to
external sessions.
Technically there is a way, you have to dump the PGA and you can get the
session parameter values.
Best Regards,
K
Yes, I know I need to RTFM, but if some kine soul has a quick
answer for me, I'd appreciate it.
startup
ORACLE instance started.
Total System Global Area 168788768 bytes
Fixed Size 729888 bytes
Variable Size 100663296 bytes
Database Buffers 33554432
Hi All,
Hi Charlie,
Variable Size 100663296 bytes
Database Buffers 33554432 bytes
Redo Buffers 33841152 bytes
Which initSGA.ora parameters control the Variable Size piece of
the 9i SGA? I'd like to shrink this total to around 32MB.
You could change both the
I hesitated mentioning that parameter in this forum, but I figured what the
heck? Could be fun, in a sick way... :-)
Once I was teaching a DBA class and mentioned _DISABLE_LOGGING.
Immediately, I saw every head in the class look down, scribbling furiously!
I had to backtrack very quickly and
Mike,
Shazzam. Back to 2 minutes. Huh? But Optimizer-mode is RULE!!
How? Why? I look stupid and so does my whole DBA group.
Does anybody have any insights about this behavior?
Contrary to common understanding, the Cost based optimizer is 'forced' in
certain situations even if the mode
well ora600 errors you cant fix but before i lay claim that its a bug, i
have everything support will ask for including multiple test cases
before i get them on the horn.
joe
Yechiel Adar wrote:
- Original Message -
i call support usually AFTER 2 weeks of working on an issue
my
I have just been moved to a group with several hundred developers, and to
say the least the environment is chaotic.
Without putting limits on my developers (such as via READONLY user, etc.),
is there some way that every command that a developer executes using SQLPlus
gets recorded (by userid
John:
OH! D'OH! expletives deleted
I missed your paper at IOUG. Probably shouldn't have. This
particular query had an index hint in it. We did not try
running the query without the hint until the tables were
almost all analyzed.
Can you shoot me a copy of your paper? Or point me towards
Ray - A couple of things come to mind. First, does each developer have their
own Oracle login? If not, you probably will not be able to tell who did what
anyway.
What version of Oracle?
I would consider running the database in ARCHIVELOG mode. Not a bad
idea in a heavy development
Try shared_pool_size, large_pool_size, java_pool_size and
shared_pool_reserved size.
This is from 8i, there may be additional ones on 9i, or 1 or 2
of those I mentioned may be deprecated.
Jared
On Monday 24 June 2002 15:05, Charlie Mengler wrote:
Yes, I know I need to RTFM, but if some
Title: RE: recording SQLPlus activity
Ray,
Why would you want to record every SQL statement that your developers issue? Are they just using SQL*Plus or some other language?
Cheers,
Craig.
-Original Message-
From: Ray Gordon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 25 June 2002
--- Forwarded message follows ---
re: client-server support on database 9.x
Looks like database 9.0.1.x will probably die (without *any* EAS) a
lot sooner
than 8.1.7.
since there is no evidence at this time that database 9.2.x, or
later, will
ever support client-server,
Also,
you probably thought of this, but have you looked at v$sga (which seems to be the info
you get on startup) and v$sgastat - which has details of each of the sections.
On 81714 on NT,
v$sga shows:
Fixed Size
Variable Size
Database Buffers
Has anyone tried exporting a 9i database using 8.1.6 exp utility on Windows? A user
here tried it and got ECP-56 (andno other error messages). I tried this on Solaris and
had no problem.
Long
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
Hamid,
I believe the problem is in your 'to_number(a.MSC_SERVICE_CODE)' section in
your where clause. This is trying to do a to_number on a field that could
have a non numeric value in the field.
Hope this helps,
Bryan Rodrigues
-Original Message-
Sent: Monday, June 24, 2002 7:23 PM
Title: RE: Virtual drive on Solaris
Tony
Ever
since I first worked with you, I've always regarded you as best amongst the best
(and I don't give that title lightly), and you have substantiated it once again.
Thanks for the info, this is great ! Can't wait to freak out some minds :-)
!
Charlie,
all of the following control the variable size.
db_block_buffers ( Of course db_cache_size in 9i) and
sharedpool_size and log_buffer_size.
The thing to note is you have your log_buffer_size set
to way higher than necessary. IMHO For such a small(
test ? ) system few KBs would suffice.
Sorry for the late reply,
thx a lot all of u for the help
Regards
Sameer
--- Godlewski, Melissa
[EMAIL PROTECTED] wrote:
Sam,
Que1:
If you have statistics on the table then the cost
based optimizer is used.
If you have out of data statistics you could be
sending bad information to
the
Of course, if anyone has some queries to help identify buffer
pool pinning candidates, they would be more than welcome.
Thanks,
Lou Avrami
From the article Oracle8i Buffer Cache: New Features, identifying
hot blocks (DEFAULT cache?) can be done with the query:
PCSS:SYS select obj object,
Sorry if this is a repeat, I received a message that my original
message was being return because of locking problems
=
Hi all,
I'm in an environment where we're running RDBMS 8.1.7.2 on multiple
Solaris 2.8 servers.
I would like to set up multiple buffer pools in several of
On Mon, 24 Jun 2002, John Kanagaraj wrote:
Contrary to common understanding, the Cost based optimizer is 'forced' in
certain situations even if the mode is RULE. Examples are: Use of hints
other than RULE, Partitioned tables and indexes, Index-organized tables,
Reverse key indexes,
On Mon, 24 Jun 2002, Ray Gordon wrote:
I have just been moved to a group with several hundred developers, and to
say the least the environment is chaotic.
Without putting limits on my developers (such as via READONLY user, etc.),
is there some way that every command that a developer
84 matches
Mail list logo