Description:
Oracle database administration/server topics.
|
|
|
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 »
|
|
|
Newbie question on user rights
|
| |
A user corresponds to a schema. I am working on a database in which something strange happens: A user, can select or update records in another schema. How can I be sure that, no user other than the one with same name (as the schema name), can sonnect to that schema? Thanks very much for answering this newbie question..... more »
|
|
|
Patch Set Update doesn't increase version number
|
| |
Hello, I recently installed the second PSU for Oracle 10gR2 but I noticed that, although the patch set update installed fine, my database version number hasn't increased in dba_registry and opatch lsinventory. Is this the expected behavior or did something go wrong during the psu installation? Matthias... more »
|
|
|
|
