Hello Roland,
Check your system variables. You maybe miss it in your icon
application.
Friday, May 03, 2002, 9:48:30 PM, you wrote:
RSis> Hallo, anyone who has a good hint on this:
RSis> I have an appplication which goes against Oracle and when I am inthe application
and run VBA code which co
Dear Guru,
I want to know all the internal steps happen during opening database from
mount stage.
For e.g. SMON cleans temp segment, block corruption check, SCN check.. etc..
etc..
Where can I find these details..
Any suggestion/input?
TIA,
Best Regards,
Sandeep.
--
Please see the offic
Hello Lisa,
Null values are excluded from search list for "in" statement.
Saturday, May 04, 2002, 6:43:38 AM, you wrote:
KL> Slap me if this is a dumb question.
KL> Here's my pay methods
SQL>> SELECT ASCII(PAY_METHOD), PAY_METHOD, COUNT(*)
KL> 2 FROM LEISURE_PLAN_MASTER_TEMP
KL> 3 WHE
Hello Rajesh,
Since you use rule-based optimisation there is no need for analyzing.
Other benefits are:
-you can view several statistics like number of rows in table etc.
-with analyze command you can determine chained rows.
Friday, May 03, 2002, 10:48:34 PM, you wrote:
RRjc> Hello Folks,
RRjc
Hi All,
I was wondering if anyone has had problems with Oracle 9i
Agent starting up on Windows 2000 server.
The following entries are written in the log files. I would
really appreciate if anyone can shed some light on my problem so I can get the
Agent started :-(
Thanks
Ian
Hello Alex,
There are several books like "Java in 21 days"...
You need to learn just basics. You don't need to remember all classes
(I think it's not simple task). Therefore I think it's quite possible
to learn java even in week or two.
Thursday, May 02, 2002, 10:23:33 PM, you wrote:
A> It took
Anjo, you mentioned third party tool using instead of 10046 event trace
files. What is the tool and how it works - if you have this info of cource.
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anjo Kolk
> Sent: Sunday, May 05, 2002 8:
Hello kranti,
What about error handling?
Wednesday, May 01, 2002, 2:43:23 PM, you wrote:
kp> Hi list,
kp> I have writeen a stored procedure to execute a set of stored
kp> procedures. I want to know is there any way to stop the procedure after any
kp> of stoed procedure( from the set) re
-- [EMAIL PROTECTED]
> Dear Tom,
> Would you send me example of the script. Because I'm new with VMS
> environment.
>
> thanks in advance,
This is gonna be living hell to deal with in DCL.
Suggestion: grab a copy of perl5 and use Schedule::Cron
to cycle the jobs with the vms-ish file system t
Dear Tom,
Would you send me example of the script. Because I'm new with VMS
environment.
thanks in advance,
Ahmadsyah
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 11:43 PM
> Ahmadsyah,
>
> If I remember correctly (my
Tuning Gurus,
I am tuning one of our dayend batch jobs using the 10046
wait event (level 8).
I see a whole lot of direct path read/ write events (1000's)
in the trace file.
Also many SQL*NET messages from/ to client waits.
Not sure if this is the way PRO*C works, connects fetches
Next time include the release/version you're looking for, ya know!!! As
for what needs to be done as root, here's the doc's, now it's your turn to
dig.
HP-UX, 7.3.3
http://uisnt1.humboldt.edu/otn/library/doc/server73x/AR73/toc.htm
http://uisnt1.humboldt.edu/otn/library/doc/hp/server.733/a52813
Yes,
I think that we are talking about different things:
1) I don't feel that we are abusing the queue theory by borrowing terms like
service time and wait time.
Actually when I did the YAPP method, it was back in 1996 on a project that
involved Tuxedo and the
programmers on the projec
If someone were to ask me whether a TKPROF report tells you anything about
wait events, my first response would be No.
Yet what, if anything, can I learn from a quick glance at the totals for
"CPU time" and "elapsed time"? If...
response time = service time + wait time
then is it correct
>
> Sometimes it's a pity that a problem can be resolved
> without being understood, but that's the real world.
No kidding -- if some things "appear" to work, it would help to understand
the details to make sure a valid conclusion is being drawn. The test of
reverse vs. b-tree was simply performe
Na, I probably would have got a bonus
or something for that.
Jared
On Thursday 02 May 2002 12:13, Khedr, Waleed wrote:
> Hope it's not the program that triggered the whole Enron thing :)
>
> Regards,
>
> Waleed
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:14 PM
> To: Multiple
What are your paging statistics?
run 'vmstat 10 10' during a period of poor performace
and post the output back to the list.
Jared
On Friday 03 May 2002 05:38, Pradyut Mitra wrote:
> Hi,I am experiencing a massive performance problem due tohigh page-in
> operation In Sun OS 5.6/Oracle 8.1.
Yechiel - I did not mean to imply that SAS had not improved since the '80s.
They would be out of business otherwise. And of course every DW vendor is
"full solution" vendor. Just read their brochures if you don't believe me.
My point was that if you understand a company's roots, then often a lot o
James - I think that your system administrator is too much of a Microsoft
head. I can admit that to someone that knows nothing about Oracle, the
"official" method might sound safer. I have done the upgrades both ways for
many years, and I have never had a problem with the CreateDB/Import route. I
Anjo Kolk wrote:
>
> Stephane.
>
> The SQL statement is the right level, believe it or not. Basically the most
> expensive SQL statements (resource wise) will float to the top that way.
>
> Anji,
>
I disagree, with a strong feeling of not talking about the same thing.
My favorite method for
James,
Your plan is perfectly acceptable. In fact, if time allows, it may
be preferable. If there are structural issues in the database (i.e.
migrated rows, tables in index tablespace (and vice versa)), this is one
method of killing two birds with one stone. It does require that there
is s
Hello James
In the last 2 years I did about 5-6 migrations from 7.3.4 to 8.1.6.0
and 10-12 from 8.1.6.0 to 8.1.6.3.4.
All done on NT with upgrades.
No scratch and rebuild. No problems at all.
Sorry to disappoint you.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of li
Um, why not just install the software and then run that silly little
upgrade script they give you. Oh yeah, and change the oracle_home
parameter in the listener and change the compatible parameter in the
init.
Not that your way is wrong but seems to be a tad more then what you
need to do. Unles
http://docs.oracle.com/
I will let you do your own searching to find the proper one:-)
-Original Message-
Sent: Sunday, May 05, 2002 4:03 AM
To: Multiple recipients of list ORACLE-L
Hi !
As weird as it sounds - i could not locate the Oracle Installation guide for
HP-UX neither on Metali
Hello fellow Oracle DBAs,
I really need your opinion on this matter:
I routinely do upgrades of Oracle software and databases on all types of
systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to time).
On one Windows/NT 4 system where I am presently doing an upgrade from a
lower
go to http://technet.oracle.com/docs/products/oracle9i/content.html and
scroll down on the page to HPUX...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, May 05, 2002 5:03 AM
> Hi !
> As weird as it sounds - i could not locate the Oracl
Hi Yeichel,
It will, thanks for your reply. I ended up taking the route of cleaning up
the data. (I'm so anal)
Have a great day.
Lisa
> -Original Message-
> From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, May 05, 2002 8:43 AM
> To: Multiple recipients of list ORACLE-L
>
Sorry Yeichel... I had to laugh! I've been on both sides of this
situation.
I hope you showed him where his a$$ is for the next time he can't find it
with his own two hands.
:)
and developers wonder why they have been termed duh-veloper and Dom Phoc.
That's why every time someone gets upset
Hello Lisa
I think that using :
SQL> SELECT COUNT(*)
2 from leisure_plan_master_temp
3 where membership_class = 'D'
4 AND (pay_METHOD NOT IN ('C','P')
5 or pay_method is null)
will give you the correct result.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recip
Well , just to keep things jumping.
Last week I deviated from our rule and gave a responsible user
that needed truncate on tables the password for the owner of the schema.
Guess what? Today he comes to me to recreate 2 tables that he dropped.
Go figure.
Yechiel Adar
Mehish
- Original Mes
Hello Dennis
SAS has progressed a little in the last years and now offer a complete
DW solution, including ETL tools.
You can use their tools also to populate and query oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: S
Stephane.
The SQL statement is the right level, believe it or not. Basically the most
expensive SQL statements (resource wise) will float to the top that way.
Anji,
Stephane Faroult wrote:
> Greg Moore wrote:
> >
> > > But this is all on the server side, so in Oracle ..
> >
> > to get wh
Hi !
As weird as it sounds - i could not locate the Oracle Installation guide for
HP-UX neither on Metalink nor on Google.
The only one i was able to find was the "Quick start guide" , which is not a
replacement for the full one.
Could u please refer me to a URL where i can get one ?
I'm especiall
Actualy, I am confused, because this is my production environment and I
need to get sucess in this operation.
It is necessary, and i would like to keep the old name of instance, because
i will change the BD version.
I think the best way is :
1.) backup the software and datafiles
2.) Export all
Well ,
Depending on what you want:
1) The only way to see 'response times' on SQL statements is to use 10046, but
that adds overhead. There are third party tools out there that will do for you
without the
10046 trace.
2) v$sesstat will show the service component (cpu) on the session level,
Greg Moore wrote:
>
> > But this is all on the server side, so in Oracle ..
>
> to get what I apparently want it would be most accurate to use v$sesstat and
> v$session_wait ?
>
> - Greg
>
I do think so. My point was that the SQL statement level is the wrong
granularity.
--
Regards,
St
Larry,
|control all other factors. And I will not have the chance to do so.
As far
|as they are concerned, the production problem is resolved. So,
there's no
|need to more thoroughly investigate this -- let's move on to other
pressing
|matters. I'd like to have more details, but it's hard to jus
37 matches
Mail list logo
