Search Discussions

252 discussions - 1,304 posts

  • Hi Team, My OEM shows buffer cache hit ratio as 28% and library cache as 99%. Another query shows different results for buffer cache. SQL SELECT NAME,100-PHYSICAL_READS/(DB_BLOCK_GETS + ...
    Chirag DBAChirag DBA
    Sep 13, 2005 at 1:58 pm
    Sep 15, 2005 at 6:11 pm
  • Has anyone used or tested Solid State Disks for Databases ? http://www.soliddata.com/cgi-bin/whitepaper.asp?wp=13 The paper seems to indicate that Solid State Disks are now well on the way to ...
    Hemant K ChitaleHemant K Chitale
    Sep 26, 2005 at 5:22 pm
    Oct 5, 2005 at 5:48 pm
  • Is anyone else out there running both a 10.2 and a 9.2 listener on the same port? Now that I've successfully upgraded my dev database from 10.1 to 10.2 I'm having listener issues (Solaris 2.9) ...
    Sep 19, 2005 at 7:53 pm
    Sep 22, 2005 at 4:17 pm
  • Hi, requirement: - input parameters are codes p_cd1, p_cd2, ... for these codes I get descriptions ( select descr1 into v_descr1 from lkp_table1 where cd = p_cd1; select descr2 into v_descr2 from ...
    Ranko MosicRanko Mosic
    Sep 28, 2005 at 5:05 pm
    Sep 30, 2005 at 7:53 am
  • I am trying to put together a *Newbie DBA Handbook* to be used for new hires at my company and thought I would poll the list for topic suggestions. So my question to you is, if you could give a new ...
    Sep 18, 2005 at 5:04 am
    Sep 27, 2005 at 8:33 am
  • Hi, We are considering using Oracle's HTML DB to do some web development. Does anyone who has experience in using this, have time to spare to make some comments about it? I am particularly interested ...
    Sep 28, 2005 at 10:18 am
    Oct 1, 2005 at 9:03 am
  • Does anyone know if Pete Finnegan still has his security website running? I just tried www.pete.finnegan.com and I get unresolved host name. Thx! Mark Strickland Seattle, WA -- ...
    Strickland, MarkStrickland, Mark
    Sep 14, 2005 at 2:17 pm
    Sep 16, 2005 at 10:20 am
  • We seem to be having troubles with some of our RBS segments. We are unable to create new segments or extend existing ones. This is an unusual pattern and we're trying to find a way to get people back ...
    Henslee, JeffHenslee, Jeff
    Sep 6, 2005 at 11:56 am
    Sep 7, 2005 at 9:12 am
  • Hi, I've a cursor which retrieves about 3 lakh recs from a table.(master) based on column value retrieved from cursor for each rec,there are other tables (detail) to be updated. The detail tables ...
    Sep 28, 2005 at 6:11 am
    Sep 28, 2005 at 11:35 pm
  • First time going to Open World this year... So excited. Taking the extreme weekend on Rac. Any other tips from you seasoned veterans on which sessions to attend. Are the mini lessions usually better ...
    Kathy duretKathy duret
    Sep 1, 2005 at 3:12 pm
    Sep 14, 2005 at 9:55 am
  • Hi list, i have an unusal question i think, but i am curios about your meaning about this. I am often in the situation to get a production database from an old db-server to a new one. In some cases i ...
    Sep 27, 2005 at 9:15 am
    Sep 28, 2005 at 1:49 pm
  • Hi List, Background: Oracle 9.2.0 w/ Auto Undo Management We have a huge table and it takes more than 24 hours to collect its statistics. But the undo_retention is set to 864000 i.e. 24 hours. As a ...
    Roger XuRoger Xu
    Sep 29, 2005 at 4:35 pm
    Oct 5, 2005 at 5:16 pm
  • Hi everyone, I'm working in a medium sized insurance company here in Canada and have been tasked to prepare and deliver 1/2 day of training for our developers who will be working against a new Oracle ...
    Sep 20, 2005 at 9:42 am
    Sep 21, 2005 at 9:57 am
  • I just noticed in a instance on Win2K3 that statspack is reporting a lot of rollback in the "transaction rollbacks" statistic, but a much more reasonable (smaller) value for "user ...
    Allen, BrandonAllen, Brandon
    Sep 8, 2005 at 6:12 pm
    Sep 22, 2005 at 2:10 pm
  • Hello Gurus, How to make a table read-only (even table owner should not be able to insert, update or delete) if at all possible? TIA Muru -- http://www.freelists.org/webpage/oracle-l
    Balakrishnan, MuruBalakrishnan, Muru
    Sep 15, 2005 at 1:45 pm
    Sep 20, 2005 at 10:28 am
  • Hi, I saw many users on my database connected for more than 6 days without any activity. I killed 1 user and still the status in v$session is showing as killed. but it it not getting removed from the ...
    Chirag DBAChirag DBA
    Sep 15, 2005 at 9:38 am
    Sep 15, 2005 at 1:45 pm
  • Is there somewhere on the internet a place where it is still possible to download Oracle version 6 or a lower version? Regards Marco -- http://www.freelists.org/webpage/oracle-l
    Marco GralikeMarco Gralike
    Sep 6, 2005 at 10:53 am
    Sep 8, 2005 at 12:25 pm
  • How will you change the ORACLE_SID in UNIX? export ORACLE_SID temp2 echo $ORACLE_SID temp What I m missing? Regards - Chirag -- http://www.freelists.org/webpage/oracle-l
    Chirag DBAChirag DBA
    Sep 7, 2005 at 3:25 pm
    Sep 7, 2005 at 4:19 pm
  • Hi All, I am new to Linux+Oracle. I would like to know a few things... 1 Can we import from the export dump taken from a Windows DB to Linux based Oracle DB? Are there any considerations for this? 2 ...
    DBA DeepakDBA Deepak
    Sep 22, 2005 at 11:13 pm
    Oct 14, 2005 at 4:04 am
  • Quick question, is anyone out there using Oracle's Automated System Storage Management software for production databases? Not the tablespace level stuff, but the create a mount point & let Oracle ...
    Goulet, DickGoulet, Dick
    Sep 12, 2005 at 7:58 am
    Sep 13, 2005 at 12:18 pm
  • Hi Guys, I think that even select statement will make the index split and require the rebuilding. Am I true? I think I am. And there is a view called index_stats with column height. I have read that ...
    Chirag DBAChirag DBA
    Sep 6, 2005 at 11:06 am
    Sep 6, 2005 at 2:40 pm
  • Hi All, How can I use a permamnent tablespace for sorting operation as does the Temporary tablespace? Is it possible? -- Regards, Deepak Oracle DBA -- http://www.freelists.org/webpage/oracle-l
    DBA DeepakDBA Deepak
    Sep 25, 2005 at 11:39 pm
    Sep 26, 2005 at 6:14 pm
  • My line manager grabbed me just as I was leaving today to say that one of our departments is thinking of implementing Oracle Names Server, currently they're using tnsnames.ora files on each desktop ...
    Stephen boothStephen booth
    Sep 21, 2005 at 2:28 pm
    Sep 26, 2005 at 1:08 pm
  • Hello! We are transitioning our database environment to a new SAN and I am trying to determine a good approach for allocating spindles to databases running on various boxes. This in turn will ...
    Murching, BobMurching, Bob
    Sep 13, 2005 at 6:11 pm
    Sep 16, 2005 at 6:19 am
  • I'm considering the purchase of a new laptop and want to make sure that it has enough power to run Oracle10g Enterprise Edition with reasonable zip. If you are running Oracle on your laptop and are ...
    Paul BaumgartelPaul Baumgartel
    Sep 15, 2005 at 8:29 am
    Sep 15, 2005 at 1:18 pm
  • What does spreport.sql save the statspack report? I cannot find it anywhere?? Statspack is installed on my Oracle 8i system. After creating a few snapshots, I ran spreport from sqlplus*. After it ...
    Larry KellyLarry Kelly
    Sep 8, 2005 at 9:18 am
    Sep 9, 2005 at 5:12 pm
  • I have a query that incorporates a view on a remote database. A straight query against the remote view works fine. select count(*) from remote_view_at_remote_db where value = 'ABC'; However, if I ...
    Dennis WilliamsDennis Williams
    Sep 7, 2005 at 9:15 pm
    Sep 9, 2005 at 9:03 am
  • Hi. I have a heap table with 3.3 million rows. When this table is analyzed with the old "analyze table .... estimate statistics." the num_rows is pretty accurate. But when I run the following command ...
    Arnon, YuvalArnon, Yuval
    Sep 29, 2005 at 4:18 pm
    Oct 5, 2005 at 12:14 pm
  • All, I'm looking for a way to measure the elapsed time (in milliseconds) of executing a bunch of functions within a PL/SQL package. I've written a "timer" function that records this by using ...
    Sep 30, 2005 at 9:32 am
    Oct 2, 2005 at 5:46 am
  • hi all, We have got one oracle 9i rel 2 on windows 2000 running in no-archive log mode. the problem is one of the dba of the other team has deleted some of the dbf files while the database was ...
    Onkar N TiwaryOnkar N Tiwary
    Sep 20, 2005 at 6:57 am
    Sep 20, 2005 at 11:49 pm
  • Hi All, Perhaps it's out of topic in Ora-DBA, but I need some help from you. I have trouble to insert PDF's file into oracle database. PDF's file will be inserted into BLOB data type. Would you ...
    Sony KristantoSony Kristanto
    Sep 5, 2005 at 4:07 am
    Sep 9, 2005 at 10:37 am
  • Hi, There is a trick to pause an import on Oracle 9i on windows. You go the command window if you would be copying it), and leave marked (white). The import process will pause until you end the ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Sep 30, 2005 at 11:27 am
    Oct 3, 2005 at 3:47 pm
  • Hi list, assuming the following scenario: No working Backup because of several reasons. Not all datafiles of the database Corrupt blocks in the datafiles we have So, as far as i know, there no way to ...
    Sep 5, 2005 at 11:02 am
    Sep 14, 2005 at 7:27 pm
  • Are we confusing a bug with an architecture issue? Personally, I don't put my cross-hairs on any product for bugs...only completely flawed architecture issues get my focused attention. Sorry, I'm ...
    Kevin ClossonKevin Closson
    Sep 13, 2005 at 1:02 pm
    Sep 14, 2005 at 3:01 am
  • All- I am running on AIX 5.3 currently. I plan to upgrade to but having some concerns. I was wondering if others have heard of this or experienced it. I queried the existing DB to ...
    LeRoy KemnitzLeRoy Kemnitz
    Sep 1, 2005 at 9:50 am
    Sep 1, 2005 at 3:37 pm
  • Hi, I need to keep track of history of data change in the live tables. Two methods are being compared. Create triggers on the live table. For each insert/update/delete insert a row in the audit ...
    Sandeep DubeySandeep Dubey
    Sep 21, 2005 at 2:54 pm
    Sep 25, 2005 at 2:25 pm
  • Hi All, I installed Oracle 10g R1 on my Linux (Redhat) AS4 box. The installation completed successfully. But when I started dbca it is giving the exception. UnsatisfiedLinkError exception loading ...
    DBA DeepakDBA Deepak
    Sep 14, 2005 at 10:32 pm
    Sep 16, 2005 at 11:43 am
  • i came across an advert on his web page for his new book due in november. weird evough neither apress not amazon has a listing for it . http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html  you want ...
    Fuad ArshadFuad Arshad
    Sep 15, 2005 at 8:03 am
    Sep 15, 2005 at 5:09 pm
  • Hi all: http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/2ff023ab050b7525 Why I pick it up is that I feel this utility is really useful in our environments, we have so ...
    Lou FangxinLou Fangxin
    Sep 8, 2005 at 12:13 am
    Sep 8, 2005 at 4:19 pm
  • What database objects are created in the default tablespace? If I create a table, is both the index and the table created in the default tabalespace? Platform is Oracle 9.2 John Dunn -- ...
    John DunnJohn Dunn
    Sep 27, 2005 at 4:14 am
    Sep 28, 2005 at 5:19 pm
  • Hi All, We need to keep 5 (small-ish / low-volume) tables on a remote database in sync with those in the local database. We want synchronous updates of the remote tables when the network allows but ...
    Charlotte HammondCharlotte Hammond
    Sep 23, 2005 at 9:58 am
    Sep 23, 2005 at 5:04 pm
  • Hi, I have three identical databases say A, B and C. I want to replicate from A and B to C. Meaning C will have its own data plus the data from A and B. I can not create a db link from A or B ...
    Sandeep DubeySandeep Dubey
    Sep 20, 2005 at 9:22 am
    Sep 20, 2005 at 4:17 pm
  • Hi, all. Oracle10g ( on Windows 2000. I have a set of traces that are puzzling. I had the traces done in controlled conditions, with a single user on the database; CPU usage on the DB ...
    Paul BaumgartelPaul Baumgartel
    Sep 9, 2005 at 11:20 am
    Sep 12, 2005 at 9:37 am
  • Hi, My index tablespace and undo tablespace are of almost 5 gbs and DB is only of 35 GB. How can I reduce the size of this TBs with 3 -4 datafiles of 1- 2 GB. Anyone can gimme some idea? Chirag -- ...
    Chirag DBAChirag DBA
    Sep 9, 2005 at 2:17 pm
    Sep 12, 2005 at 9:33 am
  • Does anyone know if there is a way to find out what values are in effect for the bind variables of a currently running query? I know how to find bind variable values with a trace, but that requires ...
    Allen, BrandonAllen, Brandon
    Sep 1, 2005 at 2:29 pm
    Sep 2, 2005 at 11:21 am
  • Dear list members, currently our company is in the process to evaluate a new backup software/hardware solution for backups with RMAN and I'm very interested in your experience and opinions. We are ...
    Manuela muellerManuela mueller
    Sep 29, 2005 at 7:57 am
    Sep 30, 2005 at 2:51 am
  • on Solaris 9 Am loading data into a staging database using a ETL tool (Informatica) and have done the following to improve the performance of the dataload process Database in no-archive log ...
    Zabair AhmedZabair Ahmed
    Sep 28, 2005 at 4:56 am
    Sep 28, 2005 at 8:16 am
  • * Hi, We are migrating our database on different hardware/location. We will get RMAN backup of the database. And we will have access to archive logs generated during shipping/restoration(It would be ...
    Navneet GuptaNavneet Gupta
    Sep 21, 2005 at 5:17 pm
    Sep 27, 2005 at 1:55 pm
  • Hi, I need to get rid of chained rows for some tables. Re-insert (delete and insert) the rows. Some of the tables have triggers so it is difficult. IS there a way to execute the delete and insert ...
    A JoshiA Joshi
    Sep 23, 2005 at 12:52 pm
    Sep 26, 2005 at 1:17 am
  • I took an RMAN backup of a database (just controlfile, no catalog) while the database was I then upgraded to In the mean time, the developers decided that the schema of things was ...
    Mladen GogalaMladen Gogala
    Sep 21, 2005 at 4:51 am
    Sep 23, 2005 at 8:59 am
Group Navigation
period‹ prev | Sep 2005 | next ›
Group Overview
grouporacle-l @

225 users for September 2005

Jared Still: 53 posts Gogala, Mladen: 46 posts Chirag DBA: 42 posts Allen, Brandon: 41 posts Goulet, Dick: 33 posts David Sharples: 30 posts Mladen Gogala: 27 posts Oracle-l-bounce_at_freelists.org: 27 posts Rjamya: 27 posts Lou Fangxin: 25 posts Niall Litchfield: 25 posts Dennis Williams: 23 posts Paul Drake: 23 posts Ranko Mosic: 21 posts Mark Bole: 20 posts Mercadante, Thomas F (LABOR): 20 posts Kevin Closson: 18 posts Paul Baumgartel: 18 posts JayMiller_at_TDWaterhouse.com: 17 posts Carel-Jan Engel: 16 posts
show more