Title: RE: MS Access
ACCESS-L. For subscription/signoff info and archives, see
http://peach.ease.lsoft.com/archives/access-l.html .
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: viraj2 [SMTP:[EMAIL PROTECTED]
Title: RE: alter table rename error
Eric,
No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: eric king
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Raj,
If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Should we stop analyzing?
I'll see your 'analyzed every 4 hours' and raise you one. We have some tables that are analyzed every time they are used! They are 'work' tables that are sometimes empty, very full, or somewhere in between. Running something when the statistics say the
Title: RE: SQL CASE Statement
I prefer the milk and candle method but that only works with flat panel displays. ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Poras, Henry R. [SMTP:[EMAIL PROTECTED]
You
Title: RE: Good news from Oracle
More like
ora-600 [x] Spam spam spam spam. Lovely spam! Wonderful spam!
I'm sure Jared will soon agree.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED]
Title: RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
A six pack of beer per person sitting outside near a swamp on a hot summer night watching a bug-zapper. Now that's entertainment!
Jerry Whittle ( born and somewhat raised in Kentucky )
ASIFICS DBA
NCI Information
Title: RE: 24 x 7 x 365
As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]
Title: RE: analyze after truncate
I once took over an old database which hadn't been analyzed in nearly a year, so I started analyzing it every two weeks. For the most part things stayed the same or got faster; however, one procedure would sometimes, only sometimes, take a lot longer. Come
Title: RE: Any articles/books that take relational theory and make it english?
Ryan,
I often recommend Database Design for Mere Mortals by Michael J. Hernandez for my students, new database developers, and especially for programmers that I work with. It's a step above something like
Title: RE: datamodelling question: updating foreign keys
Ryan,
You'll probably like my solution less, but it worked for me. You don't have a parent-child relationship as a Truck can have more than one Cargo and Cargo can be loaded on more than one Truck. Rather you have a many to many
Title: RE: How do you genrate primary keys?
SSAN are not reused by the government at least on purpose. Check it out below:
http://tinylink.com/?WCzYP7kRi2
However there are many other problems with SSANs.
- Sometimes they are accidentally duplicated. Stuff happens when you issue 6 million
Title: IMP using the same DMP file
Hi,
We were just wondering if you can IMP into two instances using the same dmp file at the same time? We need to refresh both our development and test instances with data from our production database and doing both at once might save some time. 8.1.7 and
Title: RE: anyone have opinions on the future of the 'grid'?
Oracle will probably think so with their per CPU pricing.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: AK [SMTP:[EMAIL PROTECTED]
S Does
Title: RE: What happened to Howard Rogers ?
I once worked for an excellent company, Southwest Research Institute, in the USA. As part of my employment agreement, I had to sign a paper saying ANY patent I was granted belonged to the company. It didn't matter if it was on my own time or not
Title: RE: dba interview questions
1. 40 hours a week max, right?
2. Bermuda shorts and Hawaiian shirts are considered business casual?
3. What's the daily donut allotment?
4. Health club benefits? (See #3 above)
5. Stock options?
6. Is it OK that my emergency, after-hours phone
Title: RE: Database just stops
Where do we send the flowers? I'm assuming that you killed or at least severely wounded him.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]
Title: RE: OT - Microsoft Security Bulletin MS03-040 (828750)
Can you get to the Windows Update web page? If so does it freeze at 0% or 33%? If so there are some fixes available. If you can get to the web page, there's a button towards the bottom left for help with Windows Update. Check in
Title: RE: Sql query : select max timestamp value from table
select ip, max(timestamp) from table
group by ip;
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Johan Muller [SMTP:[EMAIL PROTECTED]
I have
Title: RE: archive old data
Hi Nancy,
Unless you are having serious performance / storage problems or another valid option would be just to delete the data, don't do it.
I inherited a database where we archive data yearly. I started working on the checklist and scripts last month and we
Title: RE: [Q] SQLPLUS help on distinct
Mike,
Try one of these:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
order by (rpad(employee_id,6,' ')) ||';'|| ssn;
or
select distinct employee_id, (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
order by employee_id;
Title: RE: How can I measure my DB performance.
I thought that would be for a bad database. Of course you need to throw the server out of a 20th floor window or higher to hit terminal velocity.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Title: RE: tables and views
You need to look into all_objects also. It tells you if it is a table or view.
SELECT DISTINCT c.owner, c.table_name, o.object_type
FROM all_tab_columns c, all_objects o
WHERE c.table_name = o.object_name
AND c.owner = o.owner
AND o.object_type = 'TABLE'
Title: RE: How do I find out the size of a index
Roger,
Try DBA_EXTENTS instead. Something like below:
SELECT SUBSTR(TABLESPACE_NAME,1,16) Tablespace,
SUBSTR(OWNER,1,9) Owner,
SUBSTR(SEGMENT_NAME,1,30) Index,
SUBSTR(sum(BLOCKS * 8),1,16) Size K
FROM DBA_EXTENTS
WHERE
Title: RE: Redo Logs Problem
This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).
Clients lie.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: ora-4030 out of memory error
LeRoy,
Post the query to the list. Just maybe it could tuned or give us an idea of what's going on.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: LeRoy Kemnitz
Title: RE: World premier performance of the BAARF party logo
Putting on my futuristic thinking hat, I see a day not too far off when there won't be any Ds. RAID, as we know it, will go away.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Title: RE: Cost info in Explain Plan
Eric,
Don't you hate it when that happens!
You also won't see cost info if you are using the Rule hint naturally enough.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
Title: RE: query run time vs IN list elements
Guang,
1. Just because you created an index doesn't necessarily mean Oracle is using it especially if using CBO and you haven't analyzed the table and index after the index creation. Try using a hint.
2. If IN isn't meeting your needs, try
Title: RE: how to find INDEX CORRUPTION ???
analyze table MSG_HISTORY validate structure cascade;
If there is a problem with the table or any indexes, you should receive an error message. Rebuild that object.
Validating the structure of the table locks it up so don't do this while anyone
Title: RE: alert log file
We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
April,
I'll go one better. We don't even have unique indexes much less primary keys and foreign keys. Only about 20 percent of the tables have unique indexes. A few others do have primary keys but they are used really just as
Title: RE: ERWIN vs Designer
Check out Total Access Analyzer at
http://www.fmsinc.com/Products/access.asp
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: IT - Database (Do Not Use) [SMTP:[EMAIL PROTECTED]
I
Title: RE: A SQL Question
SELECT table.Col1, table.Col2
FROM table
UNION
SELECT table.Col2, table.Col1
FROM table
ORDER BY table.Col1;
Actually you might not even need the ORDER BY
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Title: RE: A SQL Question
Kirti,
It's impossible to have a primary key as you have duplicate values. C-D and E-F both have dupes. If there should be D-C and F-E, a simple Order By Col1 would do the trick.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Title: RE: Is Anybody Out There - Pink Floyd
Only on the dark side of the moon.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 3:50 PM
Title: RE: Oracle position on hints
Hi,
We recently upgraded from 7.3.4 to 8.7 (management plans on getting to that Y2K problem shortly ;-) We had an SQL statement that really needed a hint in 7.3.4. After upgrading to 8.7, I removed the hint and it runs much faster without it. I spend
Title: RE: Analyzing indexes
Chuck,
Do you think these indexes are corrupt? Validate structure doesn't give you statistics like Compute Statistics or Estimate Statistics does.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Date format is unreadable
David,
It's not a date column. Rather it's a number column that's reading as scientific notation. Some databases, like Access, actually store dates as numbers; however, AFAIK Oracle does not.
Those are some large numbers. 1.0397E+12 = 10397
Title: RE: Big SGA...
... applied to the parent who spoiled the child ...
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Kevin Lange [SMTP:[EMAIL PROTECTED]
... large burlap sack and a small bat
Title: RE: What to check?
David,
I'd check that they are using the same exact script on all three machines.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Nguyen, David M [SMTP:[EMAIL PROTECTED]
Someone
Title: RE: Is there any user group forum for SQL Server?
Jared,
STEP AWAY FROM THE KEYBOARD!
It's certainly a dangerous weapon when you can't even spell you're own name! ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Purely for your amusement
Barbara,
I just gotta know: How long does it take to run?
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Barbara Baker [SMTP:[EMAIL PROTECTED]
And you thought your job
Title: RE: MetaLink on the blink
Jared,
Must be just you. ;-) I just got on it at 7:20 PM Central time and did a search. REALLY fast for once. Maybe they did an upgrade or just that the majority of users have gone home.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL
Title: RE: trace (get) sql script
Hi,
If you've asked nicely; tried reasoning with the developer; and talked to management without success, use this:
REVOKE CONNECT from developer_user_name;
Works for me!
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Title: RE: RE: Third Party Application Madness
Dick,
Is that aspirin first then the Jim Beam or Jim Beam first and aspirin the next morning?
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED]
Title: RE: Oracle TEMPORARY SEGMENT
Hi,
This is what I use to clean up a temp tablespace. The tablespace is named 'temp' and it is normally set to PCTINCREASE of 10. You will need to insert the correct values for your temp tablespace. Altering the tablespace a little wakes us SMON which
]]
Whittle Jerome Contr NCI,
I think your sql should not work on a really TEMPORARY tablespace, and temporary tablespace do not need to be cleaned either.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-11 06:49:00 ,you wrote£º
Title: RE: RE: Oracle TEMPORARY SEGMENT
Rafiq,
I'm not using locally managed tablespaces just yet. If the definition of 'truly temporary' includes locally managed tablespace, then you are correct.
Thanks for keeping me on the straight and narrow.
Jerry Whittle
ASIFICS DBA
NCI
Title: RE: Full table scan
Venu,
How may records? If it's just a few hundred, a full table scan might be faster.
Throw a RULE hint at it and see what happens then.
What version of Oracle? CBO in 7.3.4 wasn't all that smart.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
Title: RE: why these tables can not be seen from user_segments?
Hi,
I found this out the hard way to: dba_tables, all_tables, and user_tables also include views. Of course, views don't have segments.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Title: RE: Take Care of your DBAs
Dennis,
Or on our looks including this guy I see in the mirror every morning!
I do ride my bicycle quite a bit. Over 5000 miles last year including one 204 mile ride in under 15 hours on a 95 degree day. Enough of my braggingfor now.
Jerry Whittle
Title: RE: comparing null values
Gary,
Null has no value. It can't be like or not like anything. If you want to see the null you'll need to add OR IS NULL to your Where clause.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Last access in table
Adriano,
To see what happens from now on, turn on auditing for that table. To see what has already happened in the table, you aren't going to have too much luck unless auditing is already on. You could try running the statement below. It won't actually show
Title: RE: SQL question
Joshi,
SELECT count(*)
FROM (SELECT count(*)
FROM flight_legs
GROUP BY d_actual_time, event_type);
SELECT count(*)
FROM (SELECT DISTINCT d_actual_time, event_type
FROM flight_legs );
The first one took about 37 seconds in returning a count of 357331.
Title: RE: Americas Cup
There's a difference? ;-)
Just think: US Postal Service has been catching heck for spending about $3 million on the Postal team in the Tour de France and Lance Armstrong has been winning. Uncle Larry spends $95 million to come in second place. Of course USPS is a
Title: RE: Oracle DBA Profession hard?
Hard? Ha! Before getting into computers, I was an aircraft mechanic for 24 years. Nothing like changing 250 pound wheel and tire assemblies (12 was my record) on midnight shift outside in the cold and rain for LESS money than I got in my first job in
Title: RE: Orawomen
My youngest is in high school and is the only woman taking mechanic drawing. She is the best in the class. The instructor was berating the boys that a 'girl' was beating them until my daughter told the instructor to keep gender out of it! She also wanted to join the Chess
Title: RE: FULL TABLE SCAN?
A Where clause in your SQL and indexes that support the Where clause are a good place to start.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
Title: RE: Which side of the road?
Mike,
Thanks for the link. I lived in England for 4 years so I have driven on both sides of the road including a LHD vehicle in the UK. Also my old BL Princess had a manual transmission so I can now shift with either hand.
The first day I drove in the UK
Title: RE: ORA-1410 Silliness
Actually if you had a clone of your SA, you might have twice as many problems.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
If I had a
Title: RE: Restoring DB from specific RMAN backup set.
Jared,
LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED]
Title: RE: OT: Guidelines/Standards for supporting non-oracle
Yechiel,
Access 1 had a limit of 100MB. Access 97 had a limitation of 1GB per mdb file. Newer versions are up to 2GB per mdb file. There are ways around it like compacting or splitting the database into multiple MDB files. Of
Title: RE: Function-based Index
Cherie,
AFAIK, a plain old index works just fine with Min and Max functions. However, you might need tran_dt first in the index or have its own index.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
Title: RE: Oracle FM interpretation of locking behavior
I like the term liquid laughter better.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Jeremy Pulcifer [SMTP:[EMAIL PROTECTED]]
From: Jesse, Rich
Title: RE: OT: Guidelines/Standards for supporting non-oracle
Hi,
I've made a lot of money over the years fixing Access databases as a consultant. They usually called me after being painted into a corner with a non-normalized, Excel spreadsheet looking thing. I have to diplomatically tell
Title: RE:
Red Buttons is a fine comedian and actor. He won an Academy Award and Golden Globe. Still I can't see how he can HELP in this case.
Oh - you said Button not Buttons.
Nevermind.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Title: RE: SQL tuning help
Sergei,
How many records in each table? What indexes are in these tables? What version of Oracle?
What do you mean by 'began to hang'?
I'd try making the attempts in the WHERE clause into a Between. I'd also try grouping by f.subsite_id.
You could always
Title: RE: Primary Key Constraints
SELECT owner, table_name
FROM DBA_TABLES t
WHERE NOT EXISTS
(SELECT 'X'
FROM DBA_CONSTRAINTS c
WHERE c.owner = t.owner
AND c.table_name = t.table_name
AND c.constraint_type = 'P')
ORDER BY 1,2
Take off the ORDER BY to speed things up.
Title: RE: How to check/show long SQL statement?
First find the ADDRESS from v$sqlarea. Then run the following:
select sql_text from v$sqltext
where address = '8758'
order by piece;
It's ugly but all there.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL
Title: RE: RE: dumping microsoft desktop?
Mladen,
Actually the Boston Tea Party happened for the opposite reason. The tea on the ships was of LOWER price because it was not taxed. The 'patriots' owned tons of tea stored in warehouses that they could only sell at a profit with higher prices
Title: RE: RE: RE: CONSISTANT GETS
I've seen worse. My programmers don't know how to use NOT EXISTS even though I've explained it many times. And that's the least of my problems. Look at this mess:
SELECT *
FROM sar.pax_header_suspense_err_temp
WHERE manifest_type
||
clause is really a piece of work.
Jared
Whittle Jerome Contr NCI [EMAIL PROTECTED]
I've seen worse. My programmers don't know how to use NOT EXISTS even
though I've explained it many times. And that's the least of my problems.
Look at this mess:
SELECT *
FROM
Title: RE: Data Purging Strategy
And finding something to play that CD in 50 years, much less understand the data format, will be like finding something to play an old 78 now.
78. How's that for showing my age! I even had a 16 once. And a 4-track (pre 8-track).
Jerry Whittle
ACIFICS DBA
Title: RE: Changing column format
David,
I suggest that you don't. There are many Jim Jones in the world. How are you going to handle that? Is this field really your primary key and related to other tables or do you just need to make sure there are no duplicate names? If so, create a
2
6 2 3 folder 2 item 3
7 1 2 3rd subfolder
5 7 0 folder 3 item 1
9 rows selected.
-Original Message-
From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
select *
from treenode
order by translate(description || 0, '0123456789abcdefghijklmnopqrstuvwxyz
', '0123456789
Title: RE: SQL Brain Teaser Challenge
select *
from treenode
order by translate(description || 0, '0123456789abcdefghijklmnopqrstuvwxyz ', '0123456789')
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Orr,
Title: RE: QUERY?
Without a clearer description of what it isn't doing, my WAG is missing permissions on the views or tables.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Title: RE: Insert too slow...
How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might want to drop the indexes, except for the primary key or unique constraints, insert the records, rebuild the dropped indexes, and analyze those indexes.
Jerry Whittle
ACIFICS DBA
NCI
Title: RE: Urgent problem with query in CBO Vs RBO
What happens if you use the Rule hint? Inquiring minds would like to know
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Jamadagni, Rajendra [SMTP:[EMAIL
Title: RE: Determine process of index build - HOW
George,
Doing some big index rebuilding myself on this fine weekend. If you know about how big the index will be and the tablespace, you can see how large the temporary segment is at the moment. That can give you a rough idea of how far
Title: RE: Another Case Insensitive Question
Julie,
Get a copy of Find and Replace by Rick Fisher. The url is below. With it you CAN change all those queries and reports in the Access FE. It's one of the best $37 an Access developer can spend.
http://www.rickworld.com/products.html
You
Title: RE: mixed case text
SELECT INITCAP('mccoy') McCoy FROM DUAL;
McCoy
-
Mccoy
Better hope your name isn't Hatfield!
(Alluding to the famous Hatfield-McCoy feud in the USA a few years ago).
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Title: Missing Redo Log Files and Control File
Hi,
We were almost done setting up a new server for the developers when a hard drive crashed. MTBF sure took a hit on that one! We had a replacement drive installed.
Fortunately we really only lost a control file and redo logs on that disk
Title: RE: Index move
Seema,
The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance.
As far as moving the index to another tablespace without considering the table, it depends on what else that
Title: RE: Where are bill rates going?
Sure with a $50,000 signing bonus!
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Johan Muller [SMTP:[EMAIL PROTECTED]]
I just received the following email from a
Title: RE: Simple favor from the guru's
Stephen,
1. Pay for bad training.
2. Pay for test.
3. Fail test and pay for more training.
4. Pay for second test
5. etc.
Probably not true but would make Oracle more money.
As an instructor of things as diverse as aircraft maintenance to
Title: RE: what is wrong with this idea ...
Gene,
You would be denormalizing to hopefully improve performance. The only way to tell is to test and test some more. Personally I don't see how putting the info in the parent table with either method will improve things. I bet updates and
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Ha! I use to bang rocks together in sea water so that the sand could be used to make the first silicon chip 1,000,000 years later.
Of course that was in my younger days..
Jerry Whittle
ACIFICS DBA
NCI Information
Title: RE: Converting Longs
Jay,
Well since he says Oracle recommends not using Longs but Oracle itself uses Longs, have the luser submit a TAR or give him Uncle Larry's email address. Should be good for a laugh or two.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL
Title: RE: Index performance
Seema,
It would really help to see your index scripts also. If you have an index that includes emp_id, reg_date, emp_st, last_access, emp_status, and match, that index should work best. Use a hint on that index.
You say that this query hits a number of
Title: RE: Had to get this off my chest
Jay,
Just have fun with it. Make the old location look like the Arctic and the new a sunny beach somewhere. Better yet print it up like a comic book with you as the superhero DBA-Man.
Then move to a new company.
Jerry Whittle
ACIFICS DBA
NCI
Title: RE: Rant-Rant
I once was contracted to fix an Access database that was created by the Sociology department of a major university. The forms and reports all looked very, very nice. Unfortunately the database didn't work just right...
Jerry Whittle
ACIFICS DBA
NCI Information
Title: RE: a couple of questions
Nope. Been happening for years. Where ignorance is bliss 'tis folly to be wise. Thomas Gray (1716-1771)
Damagement likes to be happy.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
Title: RE: To create a new datafile or to increase a existing datafile.
Denham,
You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the
Title: RE: Unindexed foreign key
Shishir,
If there are only a few records in the table, very little. However, if the table is nicely populated, it can make a tremendous difference. You could always do a little testing to find out in your particular case, but I wouldn't bother. I ALWAYS
Title: RE: When was analyze run last?
Ron,
Others have mentions the LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES. Sorry but no such columns in 7.3.4.
You could look at the LAST_ANALYZED column of DBA_TAB_COLUMNS. It will tell you when the table was last analyzed and you might assume
Title: RE: Count rows in textfile
If the room is dark, you may need to step on tails and count the YRss you hear. Of course, duplicates could still be a problem.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
, it must be observed from the outside. As such, from this observation point, it contains no rows. Thus, the method is irrelevant as the answer will always be 'NONE'.
-Original Message-
From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]
If the room is dark, you may need to step on tails
Title: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
After a few spy scandals, it has become VERY difficult and time consuming to get a TS security clearance. It might even be cheaper and faster to get someone with a TS and train them to become a DBA. I know of one instance
1 - 100 of 143 matches
Mail list logo