Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Need
bind variables, can't fix them yes will go with global temporary tables but
understand that this is going to place I/O on system that may not be
necessary.
-Original Message-From: Lord, David - CSG
[mailto
I have seen this exact behavior too.
FWIW. Mike
-Original Message-
Sent: Friday, July 26, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Lisa,
I've had problems with TEMPORARY tablespaces in Version 7.
Busy databases continually ran out of TEMP space, and it would
not get
Lisa,
I've had problems with TEMPORARY tablespaces in Version 7.
Busy databases continually ran out of TEMP space, and it would
not get released for use by other sessions.
We finally went back to PERMANENT temp TBS's on version 7
and the problems disappeared. I haven't experienced this on
]
cc:
Subject:Re: Help on Temp Space
put it offline and again online immediately...do it at off-peak time ,
tested solution...
Regards
rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 26 Jul 2002 08:09:14 -0800
Hi
put it offline and again online immediately...do it at off-peak time ,
tested solution...
Regards
rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 26 Jul 2002 08:09:14 -0800
Hi all,
Still on 7.3.4, and can't seem to free up the temp
Bunyamin Karadeniz£¬
ÔÚ 2002-07-12 01:48:00 You wrote:
Hi ,
You encounter log file sync and log file parallel write events .
This can be because of a slow device on which redo log files are on . OR
your redo log sizing is bad.
hi, you said the redo log size have something to do with this log
Connor McDonald£¬
ÔÚ 2002-07-12 02:33:00 You wrote:
Some suggestions
a) Check your commit frequency - if you're committing
like mad then this is a great way to over stress redo
logging operations.
Yes, i check the statspack report and find there is about 20 commits/second in may,
and now
Definitely there is a bottleneck in disks or the response time is very
high.
Since you are using Raid-5, I would suggest as a test to make your redo
groups one member only or to move the other members to another raid while
keeping the log_buffer at 2M.
Regards,
Waleed
-Original
Also, as Anjo taught me a couple years ago, log file sync is
particularly susceptible to long latencies if you simply have long CPU
runqueues.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Jul 23-25 Chicago
- Miracle Database Forum, Sep 20-22
Hi ,
You encounter log file sync and log file parallel write events .
This can be because of a slow device on which redo log files are on . OR
your redo log sizing is bad.
Bunyamin Karadeniz
Oracle DBA
Havelsan A.S. Eskisehir yolu 7.km
Ankara / Turkey
Tel : +90 535 3357729
- Original
Some suggestions
a) Check your commit frequency - if you're committing
like mad then this is a great way to over stress redo
logging operations.
b) Check the size of the average redo write. If
they're small, you might get some benefit by
allocation write cache in the T3 to the redo logs (if
You say your log files are on RAID 5?
On a busy database?
Are your log files all on the same RAID 5 volume?
I'm going to take a SWAG and say that you seriously
need to consider dedicating at least 3 RAID 1 volumes
to nothing but log file usage.
There's a 400-500% write penalty on RAID 5.
More infor for my previous posting:
I got ora-12560 for a 817 database on Win2000.
H:\set ORACLE_SID=dlylastg (SID set correctly)
H:\svrmgrl
ORA-12560: TNS:protocol adapter error
SVRMGR
SID is set correctly
entry correctly made in tnsnames.ora
The 817 db is on a database server (NT),
How about sqlplus? Does it give you the same error?
-Original Message-
Sent: Wednesday, July 03, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L
Hi,
I believe this has been posted many times, well, I
cannot fix it, and metalink doesn't help.
I got ora-12560 for a 817 database
Try this link out...
http://gethelp.devx.com/techtips/oracle_pro/10min/10min0402/10min0402.asp
It does not have your VB solution, but it does show you how to retrieve row
sets intelligently.
Also, I believe I saw something similiar on asktom.oracle.com, so go chat
with Thomas.
HTH
Chris
Connect as J2400 user then execute the grant.
Srinivas wrote:
I created a user J1416 with default, temp tablespaces
with password expire.
Then I granted CREATE SESSION to J1416
And then I tried to give select privs to the user
J1416. Got the following error message. I did this
On Tue, Jun 04, 2002 at 06:58:46PM -0800, Sergey V Dolgov wrote:
Hello Ferenc,
OK, just try this:
log in as root
rm -f /etc/*
reboot
And all will be fine :-)))
I tried this and now my oracle doesn't work.
===
Ray Stell
Are you serious?
Uh-oh!
-Original Message-
Sent: 05 June 2002 14:08
To: Multiple recipients of list ORACLE-L
On Tue, Jun 04, 2002 at 06:58:46PM -0800, Sergey V Dolgov wrote:
Hello Ferenc,
OK, just try this:
log in as root
rm -f /etc/*
reboot
And all will be fine :-)))
I
Perhaps we should let Ferenc know that when a 'help' message
shows up on the list, all heck breaks loose.
( take that, you ultra paranoid firewalls )
Ferenc, you need to send the 'help' to [EMAIL PROTECTED]
Jared
Ferenc Mantfeld [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/04/2002
Oh! Come on !! That's for idiots !! ;)
BTW, there is a separate OT list on yahoo groups for oracle-l members. I
forget the URL but I am sure Joe Testa will post it.
- Kirti
-Original Message-
Sent: Tuesday, June 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
help
--
Hello Ferenc,
OK, just try this:
log in as root
rm -f /etc/*
reboot
And all will be fine :-)))
Wednesday, June 05, 2002, 8:23:27 AM, you wrote:
FM help
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
Ferenc, feel free to join :
http://groups.yahoo.com/group/oracle-l-ot/
joe
Deshpande, Kirti wrote:
Oh! Come on !! That's for idiots !! ;)
BTW, there is a separate OT list on yahoo groups for oracle-l members. I
forget the URL but I am sure Joe Testa will post it.
- Kirti
-Original
:
edu Subject: RE: Help with SQL Aggregate
Functions
Sent
At the
risk of stating the obvious, is your tnsnames.ora file set up correctly
??
Regards
Lee
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: 29 April 2002 17:41To:
Multiple recipients of list ORACLE-LSubject: Help: could not resolve
service name error
This is hugely irritating, and I guess it may be a
version-dependent thing, but I can't get the exact
match for the quoted locks by setting up three
tables in the manner described.
The locking information varies between 8.1.7.3
and 9.0.1.3, but I can't get a PK/FK issue to
behave (mis-behave ?)
Jay
It looks like the application is locking the FIXED_ASSET_ACTIV
exclusive. Is the application written in Visual Basic and they are
issuing a SELECT FOR UPDATE clause?
The developers here loved the clause even if it wasn't the table they
were updating. It sounds reasonableI'm doing an
I had already checked that, but since you asked, I double checked. The primary key on
the FIXED_ASSET_ACTIV table has two columns - both are foreign keys from other tables.
I created a separate index for the 2nd column in the PK. This fixed my problem!
So, the foreign key was indexed, it
Cool! Happy querying...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with Locking Issue
I had already checked
Any bitmap indexes on the table ?
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
Jay ,
Thanks for the feedback. One to store in the memory back when you
inherit projects.
Ron
[EMAIL PROTECTED] 04/18/02 02:53PM
I had already checked that, but since you asked, I double checked. The
primary key on the FIXED_ASSET_ACTIV table has two columns - both are
foreign keys from other
Check the Alert log to see what's going on
Ali TOYGAR
What version of Oracle are you using, what is your operating system, and what happened to cause you to resart the server several times? I don't think that's going to help you, in fact it may make things worse. Looks like Oracle is trying to perform an instance recovery from a crash and applying
Always try to use a meaningful subject! When ny mail recipe rules ( my
consciuos) see a subject like this, its is interpreted for spam or virus mail
hence ignored/deleted - could have done better with:
Back to the topic:
Check the OS logs also for possible cause of loss of services.
A clip into
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 9:18 AM
HELP
Hi,
I am working with Oracle 8i version in our ERP applications. I have
Rakesh,
You have 2 options.
1. Either create the different partitions on different
tablespaces and take backup of selected tablespaces
2. You can take a logical backup using the export
utility by providing a query clause for the table.
HTH,
Naveen
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
Give each partition its own tablespace and back up the
tablespaces.
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
HELP
Hi,
I am working with Oracle 8i version in our ERP
applications. I have one
question regarding the backup of Oracle database. In
the database I am
designing it is
Rakesh,
Yes. You can certainly export a single partition at a time for logical
backups. If you put each partition in its own tablespace, you can
physically back up individual partions as well.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
script
so that it assigns the tablespace automatically. Waiting for ur reply.
With Regards
Rakesh Banerjee
From: Igor Neyman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
help received...
I was responding to the question about the tablespace partitioning
with text and examples. My email package (groupwise) is still randomly
limiting the size of the emails.
Thanks for helping.
Ron
[EMAIL PROTECTED] 04/03/02 01:43PM
Help given
-Original Message-
Sent:
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
]
cc: [EMAIL PROTECTED]
03/28/02 11:05 Subject: Re: Help in unix script(Document
link: Brian P MacLean)
AM
Hi Ashoke,
I see that you are using NORAD (I am the resident NORAD sales critter ;P).
Can't help you much on the script help, but one thing I can say:
Have you looked at the IAS agent of NORAD (the system monitoring agent)?
This will be able to do all that you want..
Under the standard rules
#!/bin/ksh
MAX=40
top -b -U norad | grep norad | awk '{ print $6, $11 }' | \
while read SIZE COMMAND
do
#echo working with ${SIZE}:${COMMAND}#DEBUG
WORK=${SIZE#*M}
#echo 1-${WORK} #DEBUG
if [[ ${#WORK} -eq 0 ]]
then
WORK=${SIZE%%M}
Get rid of select from dual! Hah, the next thing you will suggest is that we
convert to the metric system!
Marge: Now, I know you haven't liked some of my past suggestions, like
switching to the metric system --
Abe: The metric system is the tool of the devil! My car gets forty rods to
the
This will show you the compilation errors:
SQL show errors
Xiaohong Yang (Sharon) wrote:
I did try to use
alter type compile body, but I got an error:
SQL alter type CATINDEXMETHODS compile body;
Warning: Type Body altered with compilation errors.
Please help.
Thanks,
Sharon
The the() operator, which changed to the table()
operator in 8.1 takes a single value that has to be
a nested table or varray as its operand.
What you are casting is the single row and single
column that you select from dual, but that single
item is the result of casting a result set into
a
H Are these base tables or views? Have you explained both statements? Have
you looked at consistent gets and so forth.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 12, 2002 4:28 AM
To: Multiple recipients of list
The the() operator, which changed to the table()
operator in 8.1 takes a single value that has to be
a nested table or varray as its operand.
What you are casting is the single row and single
column that you select from dual, but that single
item is the result of casting a result set into
a
Get rid of select from dual! Hah, the next thing you will suggest is that we
convert to the metric system!
Marge: Now, I know you haven't liked some of my past suggestions, like
switching to the metric system --
Abe: The metric system is the tool of the devil! My car gets forty rods to
the
It's the way of the future -
From 8.1.7.2 (or maybe 3) PL/SQL at the
server no longer does
select sysdate from dual;
when your code reads:
m_date_var := sysdate;
One down, six to go.
Anyway, why do we need DUAL when we have X$DUAL
which does take up any space or latching ?
Jonathan
You indicate, that you are specifying max_opencursors (I assume you mean
maxopencursors) and that your program program is written in Pro*C (or another
precompiler) Do remember, that maxopencursors only influences implicit
cursors in the precompiler and you must code explicit cursors
Hi Bjorn,
Thanks for your reply.
Based on what you have said I think I might have come across what could be the
problem. We have common modules (the server side is microfocus cobol - oracle 7.3.4 on
NT) that are used by the online servers and also batch programs.
Normally the online programs
Ian,
I'll start with some easy questions:
What version of Oracle and what OS?
Can you show the SQL being run or some of it?
What does v$session_event and v$session_wait show?
Can you reproduce it when you run the SQL called by the program from SQLPlus?
I had a problem ion 815 / NT with really
If I understand correctly, it sounds like you need a *recursive* self-join.
Depending on the version of your db (certainly in 8i or later) you may be
able to use the CONNECT BY PRIOR syntax to get what you're after.
Have a look at the SQL reference for 'hierarchical queries'. Here's a link
to
As simple as:
select * from
(select 'ptMASTER' , 'Master' col2 from dual
union
select 'ptMKT' , 'Market' from dual
union
select 'ptOFFICE' , 'Office' from dual)
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Shishir [SMTP:[EMAIL PROTECTED]]
Thanx Adary !
I could not think in such simple way .
Anyway thanx again..
Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 2:13 PM
See the encryption article at www.cybcon.com/~jkstill
Jared
Prem J Khanna [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/08/02 06:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Help !! Password
Title: RE: Help !! Password Encryption/decryption ??
Here it is for any length.
SELECT RPAD('thestring',LENGTH('thestring') + 8 - DECODE(MOD(length('thestring'),8),0,8,MOD(length('thestring'),8)),' ') ||'' AS 12345678901234567890 FROM DUAL
Tony Aponte
-Original Message-
From
You could get creative by using RPAD() or LPAD() ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can
- Original Message -
I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and
DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods .
but as per the docs , this package requires the password ( which is to
be encrypted ) to be
in multiples of 8 bytes . i don't think this is possible always .
We use it and we have created all the encrypted fields with a length as
a multiple of 8 bytes. Then pad the data to the next multiple of 8
bytes before storing. Then trim it after retrieving the data and
decrypting it.
HTH,
Beth
-Original Message-
Sent: Friday, February 08, 2002
Title: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8
Thanx everybody .
Jp.
"Aponte, Tony" wrote:
How about right-padding the string to a multiple of 8
bytes. I think 8-MOD(LENGTH(string),8) will give you the number of
characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8 -
Hello Shreeni
I you are talking about Magic - application development tool, we are working
with it.
It is used in Israel and somewhat in Europe.
It usually use Btrieve but can use Oracle as a database.
In fact, the question that I posted about partitioning on part of a field is
converting
one
Yeah... It's a hidden init.ora parameter...
_enable_magic=TRUE
:-)
-Original Message-
Sent: Friday, January 18, 2002 1:31 PM
To: Multiple recipients of list ORACLE-L
Hi list,
Can any body tell me about magic for oracle?
TIA,
Shreeni
--
Please see the official ORACLE-L FAQ:
Check BMC Patrol.
- Kirti
-Original Message-
Sent: Friday, January 11, 2002 12:52 PM
To: Multiple recipients of list ORACLE-L
Dear listers:
Sorry for the 2nd soliciting mail.
Is there any commercial monitoring tools (other than OEM, Quest
Foglight/Iwatch) which can perform Oracle
BMC Patrol has an optional plug in to monitor systems in a SUN cluster
environment. They also offer Oracle database suite of tools. These are all
integrated into the BMC Patrol system monitoring console.
Michele
-Original Message-
Sent: Friday, January 11, 2002 1:52 PM
To: Multiple
David,
My understanding is that VCS itself can provide you with simple 'external'
scripts that can be run to monitor the process as well as to perform any
additional checks/stats gathering. Since this is ruin by VCS, it will be
able to understand that there has been a failover. Apologies - I
Lance,
I had the same proplem awhile ago. The two tables had a different
numbers of columns needed returned so I jioned them in a view and then
issued a select against the view with the proper where clause.
CREATE OR REPLACE VIEW camsview AS
SELECT a.saledate saledate,
a.retnbr retnbr,
: Deshpande, Kirti [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Help -- Your opinions on Oracle HA monitoring tool
Date: Fri, 11 Jan 2002 13:08:37 -0600
Check BMC Patrol.
- Kirti
-Original Message-
From: David Jones [mailto:[EMAIL PROTECTED]]
Sent: Friday
Kirti:
Do you have the same environment which been monitored by
BMC Patrol ?
DJ
From: Deshpande, Kirti [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Help -- Your opinions on Oracle HA monitoring tool
Date: Fri, 11 Jan 2002 13:08:37 -0600
Check BMC Patrol.
- Kirti
John:
I believe you are referring the VCS trigger, which is some
programming interface Veritas provided. Those triggers are mainly
used to incorporate certain user processes after failover and
are not for monitoring purposes.
DJ
-Original Message-
Kanagaraj
Sent: Friday, January 11,
David,
I believe you are referring the VCS trigger, which is some
programming interface Veritas provided. Those triggers are mainly
used to incorporate certain user processes after failover and
are not for monitoring purposes.
Ah - I understand what you are saying. However, if you perform
]
-Original Message-
From: Dharani Ravi [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 25, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Help - DBA interview questions I faced
Dear Rachel,
Thanks
Ramesh,
Don't be sorry, I just don't want people buying my book and expecting
Gaja and Kirti's wonderful stuff.
Thank you -- we tried hard to make the book a good one. We're in the
beginning stages of revising it for 9i and hope to make it even better.
Rachel
--- [EMAIL PROTECTED] wrote:
:
mpo.gc.ca Subject: RE: Help - DBA interview
questions I faced
Sent by:
[EMAIL PROTECTED
Thanks Patrice! That was an outstanding synopsis! And it explains why I am
behind the curve...I have been a little reluctant (such an understatement) to
make the time commitment. Guess there's nothing to it but to do it. Thanks
for the encouragement/push!
-D-
On Thursday 27 December
to:
Subject:RE: Help - DBA interview questions I faced
I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
Opinions vary, but often involve management fundament-snorkeling.
--Scott
Diver down!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 6:40 AM
I am wondering how such people get into positions where they are
PROTECTED]
mailto:[EMAIL PROTECTED]
-Original Message-
From: Dharani Ravi [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 25, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Help - DBA interview questions I faced
Dear Ramesh D Papnoi,
Thanks for the info. I will buy it.
Regards.
Dharan.
--- [EMAIL PROTECTED] wrote:
Dear Ravi
DBA 101 book - BY Gaja and kirti is available in
India (indian edition). I
already have one. Excelent book!!
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global
you can get the documentation online. read it.
according to the publishers, DBA 101 has been released in India.
and it is available on the internet at any of the online book stores
--- Dharani Ravi [EMAIL PROTECTED] wrote:
Dear Rachel,
Thanks for your reply and guidance. Also thanks to
and eventually, when they realize they can't find that omniscient
person, they come back to reality
--- Robert Chin [EMAIL PROTECTED] wrote:
I liked the interviews where they told me about their project, and
I told them how I could contribute - strengths and weaknesses.
I'm great at
Rachel,
I'm Sorry for quoting wrong book. Actually I have both books and both are
excellent!
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer)
http://www22.Brinkster.com/rpapnoi
--
Dear Rachel,
Thanks for your reply. Initially I felt demoralised
after reading your reply. Truth is always bitter.
You are correct. My Oracle concepts knowledge needs
to be improved. I read Oracle 8 concepts manual two
years ago. I am working for a small company where
there are no
Dear Rachel,
Thanks for your reply. Initially I felt demoralised
after reading your reply. Truth is always bitter.
You are correct. My Oracle concepts knowledge needs
to be improved. I read Oracle 8 concepts manual two
years ago. I am working for a small company where
there are no
Dear Rachel,
Thanks for your reply. Initially I felt demoralised
after reading your reply. Truth is always bitter.
You are correct. My Oracle concepts knowledge needs
to be improved. I read Oracle 8 concepts manual two
years ago. I am working for a small company where
there are no
I didn't mean to demoralize you but if you read the manual two years
ago, you need to re-read it. And I do suggest that you play with things
in Oracle and read the manuals to understand what is going on.
I still think you need to do research to get the answers to your
questions but here are some
What I have found is that interviewing for an Oracle DBA job is quite
different from doing the actual job. I've been a contractor - and had to
interview after each gig was over.
My job consisted of action -
entering the commands, people skills, collecting useful scripts just in
case - and
Dear Rachel,
Thanks for your reply and guidance. Also thanks to
Kirti Deshpande and Jenny Jacobson for their replies.
In India Oracle DBA 101 book is not yet released.
Once it is released I will defently purchase the book.
Regarding Question No.1, I told that Server Process is
the
Dear Ravi
DBA 101 book - BY Gaja and kirti is available in India (indian edition). I
already have one. Excelent book!!
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer)
I liked the interviews where they told me about their project, and
I told them how I could contribute - strengths and weaknesses.
I'm great at *. I don't know much about YYY, but I'm willing to
learn..We cannot know everything.
That worked in the good old days (pre-2001), not
-- Robert Chin [EMAIL PROTECTED] on 12/25/01 22:30:20 -0800
I told them how I could contribute - strengths and weaknesses.
I'm great at *. I don't know much about YYY, but I'm willing to
learn..We cannot know everything.
That worked in the good old days (pre-2001), not any
Dharan,
Answering just those questions will not give you enough knowledge to
truly be able to answer Oracle questions in an interview.
Based on the answers you gave, it seems to me that you do not
understand the concepts behind how Oracle works at all. I would
suggest you read the
FYI
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 11:22 AM
To: '[EMAIL PROTECTED]'
Scott,
The cache buffer chains issue, I'm pretty sure that I've seen that
The Patch for 1967363 on 8.1.7.2/8.1.7.2.1 has been out for some time now.
(the patch
will not be released for 8.1.7.1 or 8.1.7.0)
I do have an 8.1.7.1 instance running and am waiting for scheduled downtime
to upgrade
to 8.1.7.2.1 + 1967363 on Tru64.
This instance is only a test environment and,
Yep. According to Metalstink, its not fixed until 8.1.7.3 and that won't be
out until mid-January (I'm on HPUX). Or v9.0.2 if you like the bleeding
edge...
--Scott
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 20, 2001 11:55
201 - 300 of 485 matches
Mail list logo