| Number of db_files too high [message #247036] |
Sat, 23 June 2007 01:15  |
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
|
Senior Member |
|
|
Hi
I m using oracle 9 release with latest patch on windows
in Toad i getting the warning msg number of db_fils too high
what's that mean? how can we avoid that
kindly suggest
Regards
TM
|
|
|
|
| Re: Number of db_files too high [message #247038 is a reply to message #247036] |
Sat, 23 June 2007 01:50  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
It could be a number of things, since you didn't post the ORA-XXXXXX error code.
Also, what command were you running at that time.
My guess into the blue would be you were creating new datafiles and the db_files parameter which can be set to limit the number of data files is to low for that.
What's the result of the following :
SELECT * FROM v$parameter WHERE NAME = 'db_files';
SELECT Count(*) FROM v$datafile;
|
|
|
|
|
|
| Re: Number of db_files too high [message #247042 is a reply to message #247038] |
Sat, 23 June 2007 02:30 |
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
|
Senior Member |
|
|
SQL> SELECT * FROM v$parameter WHERE NAME = 'db_files';
NUM NAME TYPE VALUE
---------- ---------------------------------------------------------------- ---------- ---------
377 db_files 3 200
SQL> SELECT Count(*) FROM v$datafile;
COUNT(*)
----------
12
I m not getting any error but in Toad it shows the same
|
|
|
|
|
|
| Re: Number of db_files too high [message #247297 is a reply to message #247036] |
Mon, 25 June 2007 07:37 |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
|
Senior Member |
|
|
Michel,
Throwing away a useful tool is not the answer. If you give a hammer and nails and a saw to a chimpanzee and put him in a room full of windows along with a stack of lumber, odds are you will end up with broken glass everywhere.
However in the hands of a carpenter who knows how to use them, the end result will be something useful.
So tools such as TOAD and PL/SQL Developer do have a place and serve a function and in fact speed up code development.
I came from the old school where a text editor and sqlPlus were the only tools, however resistant I was to use the GUI's, I find them very useful.
Just my two cents.
|
|
|
|
| Re: Number of db_files too high [message #247373 is a reply to message #247297] |
Mon, 25 June 2007 13:09 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
I totally agree with MarcL, but...
I do think that all people should learn using only those basic tools like vi/notepad and sqlplus. Add to that the obligation to install a database locally (and install it yourself)
That more or less ensures that you got the slightest idea what it is you are working with.
Once you are comfortable using these tools, then step up and go to GUI-based tools. Especially for developers these add greatly to productivity, if used correctly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
