Description:
Oracle database administration/server topics.
|
|
|
What exception catching methods should be used with Pro*C?
|
| |
My application assembles SQL queries at run time, using C++ (a language which is very good at error handling, based on the try...catch statement) and executes them in C, more specifically using Oracle Pro*C. I have doubts about the error handling methods to be applied. I am trying to figure out how to catch any error while the Pro*C code is... more »
|
|
|
performance issue after upgrade to oracle 11.2.0.1 linux 32 bit
|
| |
Hi Friends, I have one insteresting performance issue about 11.2.0.1. Any comments are appreciated. When I use A JOIN B and A JOIN C, the optimizer choose index scan on table C. When I use A JOIN B and B JOIN C, the optimizer choose full table scan on table C. Below is test case: Case 1: When I use A JOIN B and A JOIN C, the optimizer choose index... more »
|
|
|
Lacoste T-Shirt paypal wholesaler
|
| |
Hot Summer Hot Sell Fashion&Brand T-Shirt paypal wholesaler [link] POLO,Lacoste,A&F,Armani,BBC,Ba pe,Burberry,D&G,Coogi,Ecko,ED Hardy,Evisu,Juicy,G-Star,Versa ce,Nike,LV,etc.All On Site paypal wholesaler [link] Paypal Payment online store paypal wholesaler [link]... more »
|
|
|
Selecting Particular List of Table Partitions
|
| |
Hi, For selecting rows of a table partition, we can use the following query : SELECT * FROM TABLE_NAME PARTITION(ID_P_20070800A) But if i want to select a particular list of partitions from same table, how can i do that ? Eg : I want to select partitions : ID_P_20070800A, ID_P_20080800A, ID_P_20090800A, from a particular table, how can i do that ?... more »
|
|
|
Oracle 9i NLS_CHARACTERSET
|
| |
Hi, In the table NLS_DATABASE_PARAMETERS, if I see that the value of NLS_CHARACTERSET has been set to a particular value (let's say to « WE8ISO8859P1 »), is it possible to change or to override it in some way ? Thank you.
|
|
|
Which options in 11g have to be licensed?
|
| |
Hello. Product is Oracle 11g Enterprise Edition. I am creating an database using the Database Configuration Assistant. During the install, the following products are automatically checked off for installation: Oracle JVM Oracle Text Oracle XML DB Oracle Multimedia Oracle OLAP Oracle Spatial Oracle Ultra Search... more »
|
|
|
Can anyone suggest a better way to write this query?
|
| |
Table dir_size stores the mbytes of storage used in a given directory. Table directories stores various directory names which may or may not exist in table dir_size. For every directory in table directories, report the cumulative storage in that directory and all its subdirectories. This solution uses a cartesian join. I imagine it will not scale... more »
|
|
|
Small TNS packages
|
| |
Hello, I'm transferring a sizeable amount of data from an Oracle 11 DBMS over a VPN tunnel; the client software is also Oracle 11. Both client and server are running Linux. There row widths in the involved tables vary somewhat, but BLOBs aren't involved. When inspecting the data in Wireshark, I see TNS packages with sizes... more »
|
|
|
|
