Description:
Oracle database administration/server topics.
|
|
|
500 million rows every (8 hour) day
|
| |
I've been asked to investigate how to best build an Oracle DB that will be able to handle the insertion of 500 million rows every 8 hour work day. The data will be batch inserted via sql loader every few seconds, into two main tables, distributed about 8:1. Each table is about 30 columns wide. Around 6 months of data will be retained.... more »
|
|
|
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 »
|
|
|
|
