Thats what Metalink has to say ( dunno what the note
id is)..Expect '10i' sometime next year I'd say. For
similar reasons, 8.1.7 is supported longer than 9.0
(since 9.2 is the terminal release)
hth
connor
--- Grabowy, Chris [EMAIL PROTECTED] wrote:
Hello? 9.2 is the terminal release for
Hi All,
We have a production database that has a batch job running on it for months
now. Last night one part of the batch job that normally takes between 20-30
minutes took well over 6 hours.
The only difference I can see between today other days is that the Free
Buffer Wait event was the top
Hi Keith
To me it's the easily to understand underlaying relational model,
which is flexible enough to deal with a lot of (especially
business) problem domains ... if it only were implemented
correctly by most vendors ;).
Regards,
Stefan
-Ursprüngliche Nachricht-
Von: Keith Peterson
I'm no expert, but yes - by default, text indexes are case-insensitive (in
english at least). I believe its something to do with the Lexer preferences.
The default value of the mixed_case attribute of the basic lexer object is
NO.
HTH
David Lord
-Original Message-
From: Jonathan
Great question. Before answering myself, lets just be very careful to
distinguish between RDBMS and SQL-databases. Oracle falls into the latter
category, but not the former. Can anyone name a TRUE relational database
management system currently available today?? ;-)
peter
edinburgh
Sorry - I should have been more specific with earlier
versions - I was referring to 8.0 and (if memory
serves) one of the 8.1.x's. I was pondering whether
this had crept into 9 (although I would doubt it)
Keep us posted on what happens :-)
Cheers
Connor
--- Freeman, Robert [EMAIL PROTECTED]
From the OS
pmap
From the DB
select * from v$sesstat
where stat# in (
select stat# from v$statname
where name like '%ga%' )
hth
connor
--- CP [EMAIL PROTECTED] wrote: Hi Gurus,
How can I find out the amount of memory utilized
(grabbed from the
available memory of the OS) by a
Would it be possible that an alias has been defined on the production server ?
Type 'alias' to check if 'ls' has been redefined. Another possibility is an alternate
ls command found before the usual one in your path.
'which ls' or 'whereis ls' on the prod server might help you identify this.
This did work for us and is documented in the
following document:
Oracle Text Application Developers Guide
Case-Sensitive Indexing and Querying
By default, all text tokens are converted to uppercase
and then indexed. This results
in case-insensitive queries. For example, separate
queries on
From
sqlplus type the following
desc
user_objects
and
everything should become clear.
Regards
Lee
-Original Message-From: Jalil Zabourdine
[mailto:[EMAIL PROTECTED]]Sent: 13 June 2002 11:03To:
Multiple recipients of list ORACLE-LSubject: How to find out the
latest object
Try:
select object_name from dba_objects where created = (select max(created)
from dba_objects);
Jack
Jalil Zabourdine
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
m
How about something like:
select * from
(select object_name,
object_type,
created
from all_objects
order by created)
where rownum = 1;
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales
select owner,
object_type,
object_name,
to_char(created,'/mm/dd') created,
to_char(last_ddl_time,'/mm/dd') last_ddl_time,
status
from sys.dba_objects
where owner like upper('ow%')
and object_type like upper('ot%')
and object_name like upper('on%')
and status like
I thought the original question was what is more
stable 9.0 or 9.2.
If that is the basis for your decission stick with
9.0.1.3 or better until 9.2 gets a couple dot releases
on it.
With all the problems we have had with 9.0.1.x, I have
not had one support person recommend we go to 9.2 to
solve
Is there any PERFORMANCE Overhead on Setting DB_BLOCK_CHECKING = TRUE
in the init.ora .
Any Best practice on this parameter Setting ?
Thanks
-Original Message-
Sent: Wednesday, June 12, 2002 12:34 AM
To: Multiple recipients of list ORACLE-L
Resend.
-Original Message-
Sent:
It's in centiseconds (100th sec) in all versions
up to 9i. In 9i, some have changed to (1th sec) IIRC.
So, if you're not in 9i, each of your waits is one second
(100.8971 * 0.01) and it waited a total of around 22000 secs
(between 7 and 8 hours). Bad.
As for the reasons, they can be many
How
about :
select
owner, object_type, object_name from dba_objects where created = select
max(created) from dba_objects ;
That
ought to do it. Cheers :
Regards: Ferenc Mantfeld Senior Performance Engineer Siebel
Performance Engineering Melbourne, 3000, VIC,
Australia Please note 17
Thanks Jack and all who replied.
Best regards,
-Jalil
Jack van Zanen [EMAIL PROTECTED] wrote:
Try:select object_name from dba_objects where created = (select max(created)from dba_objects);JackJalil Zabourdine<[EMAIL PROTECTED] Multiplerecipients of list ORACLE-L <[EMAIL PROTECTED]>m cc: (bcc:
On Thu, 13 Jun 2002 01:08:29 -0800, Conner wrote:
I don't have Text installed on a db thats readily to
hand, but isn't this just a case of running the
following and seeing what happens:
snip
Well yes I could have tested it, but I don't have Text installed
either, and even if I did have it
Are Concurrently Accessible MOUNTED FILE SYSTEMS (NOT Raw FS) possible on AIX ?
If so which , on what machine platforms , AIX versions , Oracle versions ?
Thanks
-Original Message-
Sent: Tuesday, June 11, 2002 11:19 PM
To: Multiple recipients of list ORACLE-L
It is available on a
I got this error in my SIDAlert log yesterday. I found that this usually has to do
with triggers that keep calling itself. Is this recursive SQL level an internal
parameter that cannot be changed? I do not see this in my init.ora. Is this error
due more to coding error?
Thanks,
Dave
--
--
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-- Public Internet access / Mailing Lists
BP,
What you are asking falls somewhat into the realm of Black Magic. Will you
see a decrease in resource requirements from Multi Threaded Server (MTS) which
is what I believe your asking. Possibly. It depends on the total number of
connections to your database and the type of transaction
BP,
Error detection and handling are one of those subjects that I probably could
write a book on and is one of my pet peeves with the development guys/gals. But
to get started, please let us in on what the environment is, Operating system,
development environment, database version,
Thanks for the link Gints.
Dave
-Original Message-
Sent: Thursday, June 13, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
exceeded
I wrote something about it in my limitations page
http://www.itsystems.lv/gints/oracle_limits.htm
see No of cascading triggers = 32
Note1:
We are toying with the idea of crafting a policy that we only upgrade
to a terminal release of a given version (e.g. 8.1.7, 9.0.1.3) in most
cases, unless a different version is required by a vendor. It seems
that these terminal release versions tend to be the most stable. Anyone
else doing that?
Some VARRAY questions...
1. How do I determine a VARRAY data type within the
database--just simply an odd name for a datatype
(i.e. O_EXT_XYZ...) ?
2. If I have a VARRAY that has been stored as a LOB,
is there a way I can change the tablespace on the
underlying LOB via an ALTER
This is a limitation that appears in most industrial
strength databases. It over rides the bad coding that
allows a trigger to recursively call itself forever.
--- Farnsworth, Dave
[EMAIL PROTECTED] wrote:
Thanks for the link Gints.
Dave
-Original Message-
Sent: Thursday,
The ones I know:
http://www.google.com
http://metalink.oracle.com
- Kirti
-Original Message-
Sent: Thursday, June 13, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL
All,
Oracle
8.0.5.0.0
Tru64
v4.0f
We are running a job
and statspack reports show that our only problem (it is running like a dog) is
the following
SQL*Net more data from
client.
Done some reading
and still none the wiser. Anyone else had this sort of problem and if so how did
you
Title: RE: set sort_area_size, sort_retained_size,hash_area_size but still writing to temp
Have 12Gb RAM available , using parallel query with large mv joined to small code tables and setting session parameters to use Gb's of memory (have system to myself at the time) but system shows 12Gb
The database server is waiting for the client.
The client could be Oracle Reports --- thus you are running a report
which does some calculations in the report before executing the next
SELECT on the server.
Hemant
At 07:23 AM 13-06-02 -0800, you wrote:
All,
Oracle 8.0.5.0.0
Tru64 v4.0f
We are
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think Yechiel is referring to a statistical claim by Quest that only 30% of the redo stream is usable in re-assembling the SQL statement. The rest is like you suspect, index maintenance, rbs segment
Good Morning Everyone!
My management wants a chart that shows the performance of the
database. If this was your boss, what would you show them?
Thanks,
Mike
P.S. This is a repeat e-mail. I never saw my other one hit the
list.
---
Hi.
I have posted a question yesterday regarding a partial
database restore.This is sort of a fallout of that
restore. Because I was only interested in restoring
two tables which are very stable I decided not to
restore a rollback tablespace. But when my restore was
completed and the databse
How can I found a complete reference or book etc about oratcl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Title: RE: Any Good , Complete Docs , Source , Links on OUTLN ?
Chapter 11 in Tom Kyte's Oracle one-on-one Export (start here if you can and save yourself time)
Metalink Note 92202.1 How To Specify Hidden Hints in SQL
Oracle Corporation paper by David McElhoes, Stabilizing Query
Mike,
Get him the free version of Quests Spotlight on Oracle. Puts a pretty
interactive chart up on his screen. Green means good. Yellow means caution,
Pink means almost danger. Red means bad.
This should be a good start for him! :)
Tom Mercadante
Oracle Certified Professional
Lee,
This is an idle wait event, meaning that the query
process is waiting on instructions from the client.
Usually this process is benign, but sometimes can
indicate that the feeding process is not providing
data in a timely fashion.
hth,
jack silvey
--- Robertson Lee - lerobe [EMAIL
Ha ha, not quite but I think I know where the problem may lie. It does a lot
of OS file handling between inserts.
Thanks for that
Lee
-Original Message-
Sent: 13 June 2002 16:44
To: Multiple recipients of list ORACLE-L
The database server is waiting for the client.
The client
If your default shell is csh, check the .login file
in your $HOME directory.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, 13 June, 2002 8:09 AM
OS: Solaris 2.7
Database: 8.1.7
On dev server, !ls from sqlplus gives the files of
Title: RE: oratcl
I use TCL/TK Tools by Mark Harrison. It has a chapter on Oratcl. There's also good information in the OEM's Intelligent Agent Users Guide.
HTH
Tony Aponte
-Original Message-
From: Arslan Bahar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:29 AM
Title: RE: Management Reports
Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?)
Tony Aponte
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL
You may want to search the archives of the list as well, I seem to
recall Cary Millsap posting something not too long ago where they found
that this idle wait event was a real problem.
If you can't find it, I can try to dig it out of my files
Rachel
--- Jack Silvey [EMAIL PROTECTED] wrote:
The relational algebra foundation upon which RDBMS design rests.
I found it very enlightening to study RDBMS theory, starting with relational
algebra. Few other areas of computer science have this rock-solid foundation
upon which to build.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL
Paula,
what is the size of your hash_area_size,
sort_area_size, and sort_area_retained_size?
what does your explain plan look like? hashes,
sort/merge, or nested loops?
do you have a lot of parallel to parallel, parallel to
serial in your plans?
jack silvey
--- [EMAIL PROTECTED] wrote:
Anything looking resolutely optimistic. Seriously, it means nothing. A database is not
'performant' per se, it's just layers of software easing the coding work to access and
concurrently update data stored in file (sorry to be so down to earth). If developers
have done a bad job, it will be
Beware...DBA heresy
below...
I am in the process
of cleaining up parameter files and wonder why we still maintain an init.ora and
config.ora. The original rational was that one contained the database
configuration/creation parameters while the other was used for tuning.
Is there a good
Log switches. This is a pretty good indicator of database usage.
I haven't documented where I got this script but I've found it useful.
Multiply log switches by log size and you have a very rough indicator of
how many bytes per hour your database is doing. Management might
understand that
PL/SQL
Tips Techniques from Oracle Press hasa few sections that may
interest you. There's one on encapsulating exception blocks, with code to
set up an infrastructure for exception routines. Another good on is a
complete package to encapsulate UTL_FILE exception handling.
HTH
Tony
Aponte
Tom - I like your style! Hit 'em when they are asking for it. If he just
wants some color charts printed daily a creative solution from Don Burleson
in his Oracle High-Performance Tuning with STATSPACK book is to get the
statistics by doing queries on the STATSPACK tables and using grep and
We are currently planning to upgrade an 8.1.5 OPS
instance to 9i.
We had rejected the idea of upgrading to the first release
of 9i -- implementing a standing rule not to upgrade
to Release1 of any new version.
Therefore, we had always planned to wait for 9iRelease2.
Within two weeks of the
Hi All,
I am setting up a 9i instance and am wondering if there are any tablespaces that you
would not set up as locally managed. Would system and rollback tablespaces be set up
as dictionary managed or locally managed? Are there any guidelines when considering
lmt or dmt?
Thanks,
Michele
SQL*Net more data from client is a probable indication that your
application is passing huge SQL statements from the client to the server
(very hard on your database performance for a number of reasons) instead
of calling stored procedures.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL
Title: Cleanup of child records...
TIA List,
What is the most efficient way to remove child records from a table
that have no parent records in it's parent table. I want to build a FK,
to keep this from happening, but I need to do some cleanup first.
Title: RE: good documentation explaining sorts
I have explored all that it is available from metalink (that I could find) and various books. Anyone know where there is a good comprehensive explanation of sortings/sorts/temporary segments/sorting and buffer cache in one place/document?
Title: RE: Management Reports
Tony:
Scorecard/historical. My management would not know what to
make of a Spotlight screen if they sat on it.
Can I say that?
Mike
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 8:33
AMTo: [EMAIL
I tend to only use the init.ora file
--- Fink, Dan [EMAIL PROTECTED] wrote:
Beware...DBA heresy below...
I am in the process of cleaining up parameter files and wonder why we
still
maintain an init.ora and config.ora. The original rational was that
one
contained the database
Title: RE: Any Good , Complete Docs , Source , Links on OUTLN ?
Oracle High-Performance SQL Tuning
by Don Burleson608
pagesISBN 0-07-219058-2
The following excerpt is from Chapter 13 of this publication.
Tuning with Optimizer Plan Stability
This chapter discusses the use of optimizer plan
Hi List,
I have few tables with a lot of transaction by many users, I change the
Initrans from 1 to 5 and for some to 25, My question is what's the best way
to findout which value is the optimum value for INITRANS for each table?
Thanks for Help.
Hamid Alavi
Office 818 737-0526
Cell818
I think Rachel is referring following email from Carry Millsap.. It is a
really nice explanation of this issue
Regards
Rafiq
I have an example for you (Anjo, I hope you won't mind). A prospect we
visited once upon a time had been fighting a performance problem with an
Oracle Payroll
From MetaLink:
Error: ORA 36
Text: Maximum number of recursive sql levels (%s) exceeded
---
Cause: An attempt was made to go more than the specified number of
recursive
SQL levels was made.
Action:
free buffer waits waits indicate that your DBWR can't keep up with its
workload. Often caused by inefficient SQL competing with DBWR for an I/O
device.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original Message-
Zanen
Sent: Thursday, June 13, 2002
I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now
having problems with the database starting up automatically on system reboot. This is
on a Windows 2000 Pro machine. The error that I get when I try to connect with
SQL*Plus is ORA-27101: shared memory realm
...reminds me of the marketing slogan for a Mexican restaurant chain: On
de border -- off de map...
Sounds like Cabela's to me -- anyone like free hunting gear?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 2:48 PM
Huh.
I've just been elected to particiate in the candidate interview process for a SQL
Server DBA at one
of our satelite offices. After 10 years of working with Oracle, the only thing I know
about SQL
Server is the weekly security advisories for either it or Win 2k.
Any tips, links, flames, etc
LOL! But I'm already in the doghouse, so I don't think
they'd see it as funny!
-Original Message-
Sent: Thursday, June 13, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
hi!
select 1998, 'a lot to do' from dual;
select 1999, 'even more to do' from dual;
select 2000, 'ph
Title: Cleanup of child records...
delete
from child_table where fk_field not in
(select pk_field from parent_table);
or
delete from
child_table where not exists
(select pk_field from
parent_table
where
parent_table.pk_field =
child_table.fk_field);
not exists usually out
performs not
Can be useful on servers with multiple databases.
config.ora can contain parameters that you may wish to be
common among all databases on the server.
e.g.
NAME VALUE VAL? MOD? MOD?
-
--
alter child table add constraint foreign key ... references ...
exceptions into exception_table
then delete the rowids in the child table that are in the exception
table
--- Richard Huntley [EMAIL PROTECTED] wrote:
TIA List,
What is the most efficient way to remove child records from a
Hi Lee,
I'm investigating a very similar problem on 8.1.6.0.0 on Solaris. So far,
I've found out that the 3rd-party vendor who setup this debacle had inserted
invalid values for SDU/TDU in tnsnames.ora on the client and listener.ora on
the server. I'm correcting them now as we speak.
I would treat dmt's as obsolete. (In 9.2, all
tablespaces default to locally managed, and
furthermore, if you create system as lmt in 9.2, all
subsequent tablespaces must also be lmt)..
I would not be surprised to see dmt's disappear
altogether at some stage in future.
hth
connor
--- [EMAIL
Title: Message
delete
from childtable a
where not exists (select 1 from parenttable b where b.key1=a.key1 and
b.key2=a.key2...) ;
try it
as -
select
*from childtable a
where not exists (select 1 from parenttable b where b.key1=a.key and
b.key2=a.key2...) ;
to make sure it is going
Hmmm, but ls from unix command shows the current directory, just run it from
sqlplus, it does to the user's home directory. I am thinking something
related sqlplus setting.
-Li
-Original Message-
Faroult
Sent: Thursday, June 13, 2002 2:04 AM
To: Multiple recipients of list ORACLE-L
I always thought it was for separating
instance-specific parameters from database-specific parameters in an OPS
environment. At least, that's one place where it is very useful to have
separate files. Of course, it was a matter of style whether "config.ora"
was the database-level one or
I have installed 9.0.1 on my Dell PC with XP
Prof.
When I installed it I installed the demo DB and everything
worked fine. Now I have installed a second DB and I cannot connect.
I made changes to listener.ora and tnsnames.ora as recommended by others on this
list.
I also added the IP
Sure! One way is to use the UNIX pmap utility...
Here is 8.1.7.3 on Sol 2.8; my apologies if this output wraps and comes out
really ugly -- there's really no way to prettify this on the plain text
email formats enforced by the list server...
I've made notes indicating where the Oracle PGA/UGA
Ask them if they plan on using SQL Servers DTS to load data to/from your Oracle
databases?
Ask if they are planning on making a linked server to your Oracle databases and how
they plan to handle security on it?
I also do the SQL Server DBA crap here
Dave
-Original Message-
Sent:
Hi List ,
I want to create a sequence which will be used by
some external process to generate some unique number . since this sequence will
be used very frequently I would prefer to cache around 1 numbers . Am I
going to loose some numbers ?
what is SEQUENCE_CACHE_ENTRIES and how does it
We started with 9011 then had bunch of patches for the bugs we discovered
for Oracle, then we went to 9012 and some problems (like temp blobs leak,
xml parts crash, smon leak etc) still persisted. But the application is
holding itself better than first version. Due to world cup we have delayed
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
It shouldn't need to be a "theoretical" or
"statistical" claim at all. A prospective customer should be able to ship
a few archived redo log files (the more the better!) to Quest and have them run
it
This is never an idle event. The phrase more data from client indicates
that the individual SQL operation is larger than a single SQL*Net packet.
No big deal; it happens all the time, and SQL*Net handles it with
continuation packets. Only issue is that the client is taking a lot of
time
It is simple to learn, use and it works.
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 have facts,
yep, that's the one
--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
I think Rachel is referring following email from Carry Millsap.. It
is a
really nice explanation of this issue
Regards
Rafiq
I have an example for you (Anjo, I hope you won't mind). A prospect
we
visited once
Hi All,
Is anyone running versions 7.3.4 and 8.1.7 using
the SQLNet8 listener? Haven't tried with 8.1.7 and I don't
want to assume it works just like 8.1.6 . Been there, .
No MTS
Solaris 2.6
Also anyone running SUN T3 arrays? Advice?
I'm starting to believe SAME is a cult
New
No.
Only the quickly evaporating Tru64.
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
Are Concurrently Accessible MOUNTED FILE SYSTEMS
(NOT Raw FS) possible on AIX ?
If so which , on what machine platforms , AIX
versions , Oracle versions ?
Thanks
-Original Message-
Sent:
Carmen et al,
Did some testing on this. On solaris 2.8 there doesn't seem to be any
upper-limit on single, atomic disk I/O, probably because someone finally got
smart and started allocating memory buffers for I/O dynamically using the
malloc() package instead of hard-coding a fixed-length
Hi Rich,
I'm curious, what value did you decide on for SDU? Let us know how it
works out.
Thanks,
Beth
-Original Message-
Sent: Thursday, June 13, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Hi Lee,
I'm investigating a very similar problem on 8.1.6.0.0 on Solaris. So
You can Enable Parallel PML and Delete the Records on the child Table
that are not there in the Parent Table. You can use the Not Exists
instead of the Not In.
If you are going to use the In Caluse then ry enabling Parallel Optiuon
on the select also ...
HTH
Best Regards,
Ganesh R
Tel : +971
5/25 Sounds a Bit High.
Maybe you should check your waits and see if there is a contention for
Block Headers and if so then try increasing it till u get a Pretty low
number.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Short answer - yes you could loose some numbers.
Have a look at http://www.ixora.com.au/scripts/library.htm and the
unload_sequences.sql and keep_sequences.sql which mention that you can lose when:
Shutdown abort is done
the sequence gets aged out of the library cache
The
Title: catalog.sql takes forever after applying 8.1.7.4.0 patch
Hi!
I just installed the 8.1.7.4.0 patch on Sun Solaris. I followed the instructions closely and when it says to run catalog.sql, I started the script, but it just sits there and does seemingly nothing (for approx 30
Dennis,
I see your %OCP is growing!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, June 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Tom - I like your style! Hit 'em when they are asking for it. If he just
wants some color charts
You can evaluate his / her general attitude about work. Most people give
the right answers at first, but you can dig in a bit more to see if they
really believe in being organized, etc.
Re. SQL Server I don't know enough about it at this point to be helpful,
finding practical issues that aren't
I'm starting to believe SAME is a cult
You are absolutely right (i.e. SAME is a cult) according to these lines
from Monty Python's Life of Brian...
Brian (preaching to a crowd):You are all individuals!
Crowd (slowly, in unison): YES! WE ARE ALL INDIVIDUALS!
Lone man
List,
I have a table when I run a query on this table return nothing(no record
returns!!!), but when I create a temp table from this table return the
records
E.G:
select cola,colb,colc from tableA where cola=1 and colb='A'
0 records return
Now: create table a_temp as select * from tableA
Mike,
My suggestion was silly, I agree. But it forces management to come up with
a better question.
How's the database running? is as silly a question as you asking your
child How you feeling today?. Both answers are a flat fine.
I would suggest you have a dialogue to ask what kind of
REAL DBAs don't need comments?
:)
--- Tim Gorman [EMAIL PROTECTED] wrote:
I always thought it was for separating instance-specific parameters
from database-specific parameters in an OPS environment. At least,
that's one place where it is very useful to have separate files. Of
course, it
Dan,
I
agree with Rachel. I have one init.ora file for each database
instance. I personally *HATE* the "ifile" business. All that it does
is make me go searching in another directory to see what the parameters are set
to.
I like
to go to one directory/one file to set/review my init
Just to learn this thing , ..how can I corrupt a block in my test
environment .
o . but be ready to help me if I am not able to repair it .
Thanks ,
Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 4:23 AM
Is there
1 - 100 of 117 matches
Mail list logo