Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jcote
  • Order by date
  1. jcote

    Startup time of an Instance

    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
  2. jcote

    Connecting to Oracle from SQL*PLUS

    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
  3. jcote

    Constraints

    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...
  4. jcote

    Appropriate Database Creation Steps

    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...
  5. jcote

    Novice Oracle User needs Urgent Help

    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...
  6. jcote

    Could you please help me to check how much freespace

    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...
  7. jcote

    Difference between the KEEP BUFFER and default BUFFER

    Thank you.
  8. jcote

    Difference between the KEEP BUFFER and default BUFFER

    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...
  9. jcote

    Could you please help me to check how much freespace

    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...
  10. jcote

    How to improve performance "Oracle 8i on Linux"

    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...
  11. jcote

    How to improve performance "Oracle 8i on Linux"

    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...
  12. jcote

    Increased Write Speed with Oracle 8i

    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...
  13. jcote

    Pageing

    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.
  14. jcote

    On Backup strategy

    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...
  15. jcote

    Urgent ... Connection Problem

    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...
  16. jcote

    Urgent ... Connection Problem

    Here is a sample of my listener.ora file. You would need to change "yourhost" by the name of your computer (the one knowed by the network), or its IP address. Also, change the yourSID by the SID of your database. You specified this when you created it, although in the case of...
  17. jcote

    Database users

    I think you should rather use the auditing facility of Oracle. I haven't tested it but I think the syntax that would help you would be: audit session by username;
  18. jcote

    Access FE to Oracle

    I have seen several application where Access was the front end and Oracle the back end. I don't recall "horror" story. There was surely bugs (that I can't really remember), but nothing to bad. The only advice I could tell you would be to avoid creating your tables from Access in...
  19. jcote

    Oracle Server Configuration

    I would suggest that you do a search in Metalink with the keywords "raid" and "configuration". The are a lot of very good documents that is aimed at answering the kind of questions you are asking resulting from that search (97597.1,227460.999 for example). I don't know the...
  20. jcote

    addon to my last question

    select segment_name, bytes from user_segments where segment_type = 'TABLE'; Take into account that this number represent the number of bytes allocated for inserting rows. This space might be 10%, 20% or 90% free. To have a better idea of the space used by your table, you would have to use the...

Part and Inventory Search

Back
Top