Title: RE: driving me crazy
I think that you will get a better answer if you
post the script and the structure of the tables that are used in the
view.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent:
side but they do their
functions.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:58 PM
Hi
That's true. You should at least have the option to use (usable;) GUI tools.
Just yesterday, I had a developer
I think that you better delete all indexes that are not used in the
selection of the records.
Updating the indexes will add a long time to the run.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 4:03 PM
Use the KISS principle.
Define asynchronous replications on their machines and when they come back
and connect to the network the updates will be applied.
TEST TEST TEST
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday
You also have to consider the OS overhead.
Putting 20 instances means hundreds of processes.
Just managing all this at the system level can be resource consuming.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 02
(once upon a time) application that inserted
control characters into the output stream.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 7:38 PM
Hi
I have used Text_io to export a datablock to csv
user input between them.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 12:41 AM
Anybody have any experience with Microsoft Txn Server? I am running into
issues with a few Windows2000 servers running
Use OEM
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 3:08 AM
-Isn't that an admin's dream? Having all desktops and servers administer
themselves?
My dumn ass NT admins don't need
Every confession you make goes directly into Microsoft database
and will used against you in a court of law.
Only internal Microsoft confessions will we written to null
but, since null is a Unix invention they will come out
if Microsoft will NOT buy the USA.
Yechiel Adar
Mehish
- Original
I think that you need to check also on char(10).
End of line usually includes chr(10) and chr(13).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 8:17 PM
try
select translate(string,','''||chr(13
Hello all
We are looking on programming and scripting tools
for DBA team on NT.
Can you, oracle DBA's on NT, tell me off the list
what tools you are using for these functions
and, if you be so kind, why you choose them.
TIA
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ
to the application people
an earth shuttering KABOOM :-) ).
We need idea how to do it. We thought about auditing
of writing a trigger that will log each access to the
table but we fear the overhead.
Any suggestions, ideas, whatever are welcome.
TIA
Yechiel Adar
Mehish
--
Please see
the
network time added.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 6:24 PM
Hi all,
I write a script to update 10,000 records in my database and noticed it
took
more than an hour to update 10,000
10 blocks.
This is just from the top of my head but will assist greatly for full
table scan of big tables. Also remember that in Oracle before 9i blocks
used in FTS are put at the end of lru so are great candidates to be
overwritten
and you will read them again and again.
Yechiel Adar
Mehish
Hello David
Define index on all fields in the where clause.
Full table scan or reading a lot of records by index
for each sql statement can cause this.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 6:24
extra block read into the controller memory when
the computer is doing other jobs.
Since tables have usually extents bigger then 27 blocks the saving
can be much bigger.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August
Check the doc: SQL reference, basic elements of
Oracle SQL
pseudocolumns.
The explanation on rownum gives you examples for your
problem.
Yechiel AdarMehish
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 14,
on.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 2:08 PM
Hi List,
I want to put my databse in archive mode(Presently it is non archive
mode).I want to estimate
space that will be required for archive
Allow me to disagree with your opinion on oracle support
with regards to the Israel oracle support.
We get good advice andgood response time.
Yechiel AdarMehish
- Original Message -
From:
Rodd
Holman
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August
Well, read this poem:
99 bugs in the programs
99 bugs
fixed some bugs
install a patch
101 bugs in the program
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 5:08 AM
I guess you are not using
Hello Jared
I do not know Perl but it seems to me that your script will put a comma
(',')
before the first value, which will add a first blank column on input.
Feel free to correct me if I am wrong but do not RTFM because I
do not have the manuals.
Yechiel Adar
Mehish
- Original Message
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
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 filled
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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
Enterprise version. We
are on standard version so it did not worked for us.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 11:58 PM
Gurus,
Oracle Version: 8.0.4 (I know we are way behind)
OS: Windows NT
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:03
Hello Aleem
This is not a boundary. It is a problem if you use autoextend and the file
grows from less then 4Gb to more then 4GB.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 1:48 PM
Where can I find
did you solved it?
I also opened a TAR and will send the results when I get them.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
Thanks Raj
I know that I can import/export. I want to convert the existing DB.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 8:48 PM
We are upgrading from 8161 to 92. You can export from 8161
components we are using.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 10:23 PM
You have that right. :(
Thankfully their much less inclined to check than on the database side.
Dick Goulet
We are using TOAD for the DBA team.
For the developers we got PlSqlDeveloper and it works fine.
You can check also www.quest.com for the new sql editor that they developed
recently.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
In NT and win2000 you can set Os priorities to the different tasks.
If you have the sane facility on aix you can give this db a lower priority
so whenever the other databases will need CPU they will get it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Title: Configuring 734 and 817 on same machine.
We have 7.3.4 and 8.1.6 working on the same machine
with no problems.
7.3.4 was installed first and then 8.1.6.
Listener is 8.1.6.
Do not forget to shut down ALL 7.3.4 services and
processes before installing 8.1.6.
Yechiel AdarMehish
I heard that there is a network switch or router that does dynamic
translation
of IP addresses. So you can always connect to one address and change the
translation in the switch/router in case of fail over.
This should be transparent to your thin jdbc client.
Yechiel Adar
Mehish
- Original
Hello
I think that the amount of records you read is also taken
into account.
If you run a query that selects ALL the records in the
tables
it is ALWAYS more efficient to do full table scan then to
access
by index.
Yechiel AdarMehish
- Original Message -
From:
Marul Mehta
and finally did the right thing.
Called Oracle support and paid for in site consulting.
The guy came over and after 6-7 hours had a script that generate
replication for a schema.
I put it in production about 1 year ago and no problems since.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
://bneo15.sba.com/ew/ioug/index3.cfm?clientsess_id=07332332nextpage=cal
lpapersconference_id=71
MAYBE (not shouting but a big maybe) I will convince management to spring
for
one of the two.
Which one you recommend?
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Check out the statspack viewer at http://www.statsviewer.narod.ru.
I played with it a little and it gives you graphs of the performance
data gathered by statspack.
I plan to check it more thoroughly in the near future.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
Hello Joe
I implemented today Tom's trigger in one of our
test databases and it works fine.
I am using it to track which users / applications
are connecting so we can notify them
in case of scheduled down time or
problems.
You need to run dbmsrand.sql to add dbms_random
package to the
If I remember correctly from the OT list it better be a male hand.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 10:48 AM
I think it depends on whose hand you have to shake as
you enter
Title: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based training)
You should call your sales persons and start
applying pressure for them to provide a correction to 9ir2.
I am doing this right now.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
There is also a copy table command in SQL.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 12:30 AM
How do I copy all data in one user's table to another user's table?
Regards,
David
Old stuff. Happens all the time.
Start stopping services on the machine and do retry until it works.
You get to services via: startsettingscontrol paneladministrative
toolsservices.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
.
This thread helped me a lot in telling them to go bark up another tree.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 11:16 PM
Jared,
What version of the database does this book refer to? I do
When the row is moved to another block.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 5:28 AM
what are the cases for a rowid to be changed ?
Regards,
Prakash.
--
Please see
Murphy's law expansion for writers:
When a writer receive his new book from print, he will always open it in the
place with the worst errata.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 4:08 AM
If I remember correctly netbackup can restore oracle DB only to the original
machine.
By setting this environment variable you trick it to think that this is the
original machine.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
Use map network drive on your target machine and define the drive as a
directory on your recovery machine.
I mean: map drive K on the target machine as f:\backup on the recovery
machine.
Then backup to drive K.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
Hello Chetan
I think that you need to have administrator permission on the NT domain to
be able to logon as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 2:38 PM
Hi List ,
I have
NO
Yechiel AdarMehish
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 09, 2002 5:18
PM
Subject: RE: test - please ignore
Can
you hear me now
Good
;o)
-Original
Check out the number of processes init.ora
parameter against open connections.
You may have run out of available processes.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 12, 2002
You are not, but you can call his highness and then HE can kill the
sessions.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 5:13 PM
How are you going to kill another session without a DBA role
for implementation parameters.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 1:23 AM
Hi List,
If anybody can explain to me what sort of change I have to do on y sql*net
it would be a big help:
I got
To change the character set to another that is not recognized as a superset
use:
Alter database db-name character set INTERNAL_USE new_character_set
This parameter is active for oracle 8.1 and above.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
If you will search Metalink you will see that this bug is generic and not
specific to a certain system.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 16, 2002 7:58 PM
Guys, the 2429929 apply for Sun Solaris
Hello Willie
We are using startup trigger that calls a Java function that sends an
MQSeries message to the mainframe.
Maybe you could use a Java function that will close and open the scheduler.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Sorry for the late post.
I did some research some time ago and found that when connecting as sysdba
you are working under user SYS no matter what user you used to logon.
So, connect system as sysdba and you are sys. problem solved.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
tables in the schema.
No guarantee. Works fine for me. Use as you wish but please keep to
copyright notice.
First script:
/* Copyright: Yechiel Adar, Mehish computer services */
/*THIS SCRIPTS ASSUMES THAT THE TARGET DB IS FULL.
DO AN EXPORT AND IMPORT TO TARGET DB.
TO AVOID CONSTRAINT
Hello Ramon
I think that you have an error in your
parameters.
As far as I know (not much) the second network card have a
different TCP/IP address.
You have to put this address in the added line in
listener.ora and add (load_balance=on).
(ADDRESS_LIST
=
(load_balance=on) (ADDRESS =
?
Tks for your help
TIA
Ramon
- Original Message -
From:
Yechiel
Adar
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, September 18, 2002
4:09 AM
Subject: Re: Listener load
balance
Hello Ramon
I think that you
Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK
Hello
I noticed that your sqlplus logon connects to an idle
instance.
That's mean that you are NOT connected to the
remote database.
You need to set oracle_sid or use connect
system/password@database.
Also
I want to add another point.
After 7 years your tapes can be unreadable.
If you use exports you can periodically restore them and
backup them to a new tape.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 19
Use map network drive and then use the new drive letter for files.
Of course, do not forget sharing on the receiving drive.
Yechiel Adar
Mehish
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 19
Tried this. The field length is still 56.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 6:43 PM
select substr(ename,1,length(ename)), job from emp;
From: Bob Metelsky [EMAIL PROTECTED]
Reply
Chris
You wrote I just want to call it and get the one value it returns.
I think that procedure does not return values, functions does.
If you want to get value from a procedure you have to pass
a parameter that the procedure will return the value in.
Yechiel Adar
Mehish
- Original Message
to the gate to be judged.
As Osama awaits his journey to his final very hot destination, he
screams This is not what I was promised!
An angel replies I told you there would be 72 Virginians waiting for
you. What did you think I said?
Yechiel Adar
Mehish
- Original Message
At last something that I have experience in.
Just do the following:
On the target database issue the following:
Alter database rename global_name to donot_trigger;
We had the same problem. This solves it.
The global name has no other influence.
Yechiel Adar
Mehish
- Original Message
Title: Message
None
It is an option (Means you pay).
Yechiel AdarMehish
- Original Message -
From:
Cunningham, Gerald
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, May 22, 2002 6:38
PM
Subject: partitioning
Hi
all,
Does anybody know
with
the users ( parameter in the
application)
to the backup machine and they worked without problems, although the global
name was different.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 7:28 PM
Yechiel
I think that this db will be among the last to upgrade.
Any bugs and (wolla) no more OEM or no more backups and restore. !
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
How about using external table?
You define the table as external having one field.
I think that select * from such table will bring you the lines in order
and then you can do whatever you want with the data.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE
IBM mainframe. Nothing beats these dinosaurs.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 6:08 AM
Our data warehouse box is nearing it's max capacity so we are looking for
options for an upgrade
Upgrade to 9iR2 today.
Rename column does not work in 9.0.1.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 9:30 PM
If those times are right... its a functionality you
should not live without, its
I am looking for the address of oracle news server.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Been there, Done that, Works in production.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3:33 PM
I'd never have thought that this was possible
in Advanced Replication
Hemant K Chitale
That's not panicking, just common sense.
Too many data warehouse projects went down the drain
so you need to learn all you can before starting such project.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3
Hello Joe
I think that the main reason is response
time.
An NT machine can get only 4 CPUs.
If you have all the CPUs and memory and the NT does
not carry the load
then it is time to consider a change.
A change can be to Unix or to
clustering.
If you are all NT shop then I would consider
Sorry, I wish that e-mails had a way to attach what I wanted
to say.
I meant news group on the subject of oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3:53 PM
On 2002.05.23 07:08 Yechiel
Thanks Joe
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 6:23 PM
comp.databases.oracle.server
comp.databases.oracle.tools
comp.databases.oracle.misc
comp.databases.oracle.marketplace
I access
Title: RE: Database backup question.
You missed the last one. He is PHB
again.
Yechiel AdarMehish
- Original Message -
From:
Whittle Jerome Contr NCI
To: Multiple recipients of list ORACLE-L
Sent: Friday, May 24, 2002 11:43 PM
Subject: RE: Database backup
question.
Hello All
How can I covert all the names from tnsnames.ora to OID?
I do not feel like entering all this data again, by hand, one by one.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network
working
with machines that are less then P4.
Make them prove their point. !!!
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 10:18 AM
We have outsourced implementation and setup of a scaled down
replaced the three IN with 3 = select count() where month in
(2,3,4)
and it works, but I would like to know why the original didn't.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
Hello
Very simple. Select sample_size from all_tables.
The field contain NULL for unanalyzed tables,
0 (zero) for compute statistics
and sample size from estimate statistics.
Oracle 8.1.6.3.4
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
and put them on low resource group so one Cartesian select will
not bring the production to halt.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 12:25 AM
Hi folks -
I have received a stream of requests
TED]
618-622-4145
-Original
Message- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Hello list
I need help in solving ORA-918:
Ambiguous field reference. All the fields are
schema.tablename.fieldname. The SQL has 3 inline queries that are the same but with
Hello Gurus
I got this link through SAG-L. Have a try.
www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
before the update:
Select count(*) from table where ...
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 3:48 PM
Hi All!
My client run big update 20,000 statements. I need to know how many rows
Title: how can listener list on two ports for the same db?
Hello Helmut
You need to configure the listener to listen on ONE host
with 2 ports.
The machine name is the same.
You separate the connections via tnsnames.ora on the
client side.
I got a call today that one of our application
.
Boy was he suprised.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 6:51 PM
Gene - C'mon ya gotta give us more details. I have heard that most DBAs
either come from developers or sys admins, but I can't
I am the one that started it.
I saw that each select from dual cost about 4-5 buffer gets.
Define view on x$dual and select from that view, no buffer gets.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 7
OPS, sorry
I thought that you mean one update that updates about 20,000 rows.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 5:04 PM
before the update:
Select count(*) from table where
Salary !
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 8:08 PM
Hello:
Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a
Sr. DBA? I know how our HR department makes
senior DBA's maxing out at infinity? :)
-Original Message- From:
Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Jr.DBA, Mid level DBA, Sr.DBA
Salary !
Yechiel Adar Mehish - Original
So, If I am working a long time why should I now quit and move to work with
them?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 4:19 PM
Great Company located in Greater Dallas, Texas area (Richardson
Hello Itiu
You wrote: Most people use it :
We have a saying: zillions flies can not be wrong, eat shit.
BTW - We use NT servers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 2:43 AM
What's wrong
Look in v$database column log_mode.
Tested on 7.3.4 on NT.
Work also in 8.1.6 and 9.0.1
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 05, 2002 7:13 PM
Anybody knows how to get status of archiver process
.
TIA
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 4:32 PM
(online redo logs)
NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no
matter what default i set!
Hi lists,
I am using
that some of you are using Quest Shareplex.
Can you share your reasons, success stories etc?
Benchmarks results will be very welcome.
TIA
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 06
101 - 200 of 505 matches
Mail list logo