Oracle
in [SQL]
|
Ocopy and Archived Logs What command can be used to show which archive log files needed to restore from the most recent ocopy backup? Is there such a command? Thanks in advance. ... 14 Dec 2009 13:12
Documentation Why does Oracle make things so difficult. We are looking for the documentation for Standard Edition 1 for 11g r2 on Linux x86. Cannot find it anywhere. Lot's of links to mane SE 1 things, but no real documentation. Does anyone have that link? Thanks! ... 9 Dec 2009 12:08
multi-column indexes, statistics and selectivity Can anyone tell me (or point me at information) about how statistics are generated/used for multi-column indexes? We have a 2 column status model (major and minor status, if you like). This is key to our application. "Naturally" we have put a 2 column index on these two columns. But we have "doubts" about wh... 11 Dec 2009 11:19
createing db 11gr1 on grid 11gr2 Hello list, is it possible to create a 11gr1 rac database on grid 11gr2? i thought it is possible but i get errors while trying it. dbca fails while trying to start the instance: ORA-29702: error occurred in Cluster Group Service operation the alert.log: Mon Nov 30 18:13:03 2009 Starting ORACLE instance ... 30 Nov 2009 14:42
stored outlines set? How can I determine if "alter system set use_stored_outlines.." has been issued? Steven Rosenthal databases etc Columbia University IT ... 18 Nov 2009 11:09
Latch / Wait Events Hi, I've been reading some documentation on latches to try and see if our database can be improved. While the concept is rather simple, I cannot really find information on which latches are really important and what numbers may indicate a problem. We have many, many events "rdbms ipc message". Some values ... 14 Nov 2009 18:51
performance issue after upgrade to oracle 11.2.0.1 linux 32 bit. Hi All, I have one performance issue after upgrade to oracle 11.2.0.1 linux 32 bit. The optimizer always choose index of "order by column", not use index of "where clause columns". Any comments are appreciated. Below are three test cases: Case 1: TEST on 11.2.0.1 DBs with ORDER BY ORDER BY gf_fee_apply_da... 20 Nov 2009 10:03
ttf2tfm file conversion pcl on Reports 10.1.2.3 Hello! I need to print by Oracle Reports using pcl language so i need to convert my ttf font to tfm file for laserjet 4 printer any idea? Regards.- hehehe ... 17 Nov 2009 07:14
Oracle Spatial/Locator issue I'm learning Oracle Locator and I've created 2 tables that each have a field of type SDO_GEOMETRY that represents a lat/long value. I'm writing a query to join the tables and find the distance between the two points. I'm using the example in the Oracle Locator doc, so I know the syntax is correct. However, I kee... 1 Nov 2009 13:16 |