Recent content by jcote

I am pretty shure that there is a dba or v$ view that has the time an inistance was started. I searched for it without success. Does anyone knows this one? Thanks

Have you tried to do a PING on the machine hosting the database? That will tell you if you are allowed to see the machine. If not, it is a network problem. I doubt that it is a problem with your tnsnames.ora file. You would get a message of the form ORA-... something. jcote

What kind of constraint was it? Disabling constraints, to let an update run, that would not run when the constraint was on, only defers the problem in time. And the worst of it is that now, other update that does not follow the constraint rule might be done on your data while it is disabled...

First of all, from what I understand, I am not shure you need another "database". If your need is to have a database for this "employee" system, you should use an existing database, and just create a owner under which the database objects of this employee database will be...

When you installed Oracle for NT, it must have installed a couple of program that you can start. You should see something under Oracle/Database Administration/Database configuration Assistant. That tool lets you create a database. You could also use the "old" method, which consist...

I think there is a little bug in carp's SQL, but I might be wrong. The SQL takes for granted that all the tablespaces where there is a temporary segment in it is used exclusively for temporary segments. In every well set up instance, that should be the case. But If only one user is badly...

Thank you.

Here is the definition of the KEEP BUFFER: "A keep pool is used for storing buffers for database objects you definitely want to have persist in your buffer cache. Objects in the keep pool will not be eliminated from memory." This definition comes from an Oracle Book (Certification...

First question you should answer is, do you have a tablespace named 'TEMP'. Check in the dba_tablespaces view. If you do have one named 'TEMP', and you do not see it in the dba_free_space, it might be because not a single byte of free space is available in it, that is that the extents in that...

First of all, in a data warehouse environment, you will want to use a big db_block_size (at least 8k). I don't know what is the maximum you can set, but I would go even higher that 8k. The idea is this: since you use the DB for data warehouse, you will get lots of information each time you do...

I don't know of specific things for Oracle on Linux to improve performance. I would start with all the basics of good Oracle tuning (which is valuable for all platforms), like a big enough buffer pool, proper SGA, good re-utilsation of SQL statement, etc. The first question I would have for...

First of all, is the program running on the same machine as the DB. If not, you will have a tremendous gain of performance by putting them on the same machine and getting rid of the network. If your program is in fact running on the DB server, does it issues 25,000 inserts? If that is the...

I can't help you with that problem, but since your using Oracle software to be paged, I would suggest you open an issue with them.

At the shop where I work, we ONLY take online backups (even though in some situations, I think cold backup would be appropriate). We use online backup on all of our instances mostly because in most of the instances, we need 24/7, and we use the same strategy for the other instances, to have a...

You have 2 ORACLE_HOME defined in your system. Check you properties (RUN regedit, go into HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE and you should see multiple ORACLE_HOME defined). I hope you are familiar with properties. Now, there must be, in all of the program that you can start (under the...