PDA

View Full Version : Oracle Database

  1. Why is "select distinct" faster than "select" ?
  2. A hierarchical query - how do I do
  3. [JDBC] StoredProcedure cursor returned is not TYPE_SCROLL_INSENSITIVE
  4. Patch 10.1.0.5 for AIX - any issues ?
  5. Problem with a view: table from it contains wrong number of rows
  6. RAC hardware requirement
  7. Oracle's shopping spree
  8. username/pass --> security issue
  9. Interfacing with MQ Series or Secured Web Service(web service with a digital certificate) using Oracle
  10. Copying the PL/SQL web toolkit
  11. Problem with 10g listener getting hung
  12. A grant to grant a role without granting the grant to the role
  13. connect by ora-01436
  14. resource utilization / hardware selection
  15. PL/SQL statements caching in a Dedicated Server mode
  16. PL/SQL stored procedure in a Dedicated server format
  17. Loss of datafile which was never backed up
  18. How many tables does Oracle Applications have?
  19. CONVERT(desc, 'AL16UTF16', 'AL32UTF8') seems to return invalid Unicode chars
  20. Limit a role to a schema...
  21. Archiving the SYS.AUD$ (audit) table
  22. OCP
  23. Accessing Oracle OID from ASp.NET
  24. INSERT...SELECT...FROM TABLE(object-collection) slow
  25. Left Outer Join question
  26. multiple TWO_TASK???
  27. Oracle 10GR2 and PL/SQL Web Toolkit -- Configurability?
  28. oracle 9.2 rtsora build problem
  29. [Q] import several users at same time????
  30. Data Transfer from MS Access to Oracle
  31. query slower using order by asc (default index order) than oder by desc
  32. How to calculate the FF(filtering factor) of an index?
  33. Oracle 10Gr2 and EM(agent) problem(s)
  34. Replicating large tables
  35. Table Join Help Needed...
  36. Number of rows updated
  37. LANG and NLS_LANG for utf8
  38. LANG and NLS_LANG for UTF8
  39. Influence of index structure to insert performance
  40. Index Tablespaces on ALTER TABLE ADD PARTITION
  41. Running Interconnect on XE?
  42. why my dynamic sql statement failed?
  43. can't type in DBCA
  44. Recovering database in NT
  45. Search for text
  46. converting oracle script to db2 (hr_main.sql)
  47. Use of INSTR to strip directory and extension from file
  48. outer join not responding as expected
  49. Help: Hundreds of connections PHP->Oracle
  50. Library cache
  51. Library cache
  52. Conversion to RAC/QFS
  53. Xg for 10g: Crack your DBA's password for 99 cents! www.oracleXg.com
  54. TCP Window Size
  55. DECODE V/s CASE
  56. DBVERIFY gives an error
  57. sub-position counter
  58. Whats Fuzzy in v$datafile_header
  59. Oracle 10g and PHP
  60. corruption of index ?: ora-600
  61. DBMS_DATAPUMP.ADD_FILE and network drives
  62. Another one bites the dust: Oracle buys Sleepycat Database
  63. Oracle RAC for scalability or High Availability only
  64. Free space and extents [ora8i]
  65. Insufficient privileges (ORA-01013) "connect / as sysdba"
  66. Tons of free memory, but getting ORA-4033.
  67. Large pool
  68. Problem in UTF8 migration from monolingual characterset
  69. less than, index and string
  70. XML Transformation: Insert schema reference in output doc ( Beginners question )
  71. XML Transformation: Insert schema reference in output doc ( Beginners question )
  72. How many Oracle9i Cluster manager required?
  73. ORACLE RDB to Oracle 10g migration
  74. Free Oracle Server for intranet?
  75. Free Oracle Server for intranet?
  76. freelists and dba_free_space
  77. QCOM is hiring Oracle Professionals
  78. Trigger & Sequence
  79. How can I further reduce physical read for this query short of throwing memory at it?
  80. updating clients when migrating from Oracle names to Internet Directory(LDAP)
  81. How to calculate the total of a varchar column?
  82. Generic schema design
  83. What does EXCHANGE PARTITION WITH TABLE really do underground ?
  84. SUNWsprox, oracle 10.2 on Solaris 10
  85. tablespace usage query, ts$, v$filespace_usage
  86. lsnrctl status gives wrong hostname
  87. ODBC Connection to 8i and 10g database
  88. Oracle Replication
  89. ora-06502 and ora-06512.
  90. Internals: selection of column data within a row
  91. protocol problem
  92. ODP .Net Connection Pool Problem on Web Application
  93. triggers
  94. Are you a NO waiting to be KATrinized?
  95. Query creation and Toad
  96. Are you a NO waiting to be Katrinized?
  97. Oracle 9i RAC Setup
  98. Order of execution of Select clauses
  99. Displaying rows as columns
  100. Another tricky SQL
  101. Oracle Install - WTF?
  102. Help with performance with a view
  103. ORACLE PAGING PERFORMANCE
  104. Hidden Oracle Files during Install?
  105. license
  106. Parallel query monitoring
  107. String search and replace in pl/sql
  108. ORA-38301: can not perform DDL/DML over objects in Recycle Bin
  109. Oracle Service Module Architect needed in Fullerton, CA. (Direct Client)
  110. grid control issue
  111. connect to 7i
  112. Max. Connection & Connection Time out parameters
  113. Oracle 10g Upgrade Issue
  114. Why does a SELECT query needs REDO?
  115. Designing indexes
  116. RAC: oracle services set up
  117. Uses of The 4th Dimension ( New Discovery by The Human Race !)
  118. set oracle workflow server of 10g
  119. Oracle 9i PGA Memory
  120. non-unique index enforcing pk
  121. Creating a corrupt block(s)
  122. OEM Error during 10g R2 install on Solaris 9
  123. Issue upgrading to 10g
  124. Issue upgrading to 10g
  125. Upgrade to 10g Issue
  126. ORACLE on Linux - IO bottleneck
  127. ORA-06540: PL/SQL: compilation error
  128. 10.2 Bug?
  129. how to use getdate() in user defined function
  130. DBMS Job not running (time change)
  131. Use a trigger to remove NULL values?
  132. restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
  133. NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET both set to UTF8 ?
  134. Oracle 7 downloads
  135. hi all plz help me
  136. dynamically add partition
  137. I have trouble with RECYCLE-BIN in 10g
  138. create duplicate copy of database but with a differnt name???
  139. For All My Oracle DBA Friends: The Supreme Progneer
  140. ORACLE 10G
  141. Import oradata files
  142. Database or store to handle 30 Mb/sec and 40,000 inserts/sec
  143. Statspack report
  144. Dual or 8 core CPU
  145. equivalent SQL Server statements
  146. renumbering with rownum
  147. one for the SQL experts - dare I say TRICKY SQL!
  148. OUI problem
  149. Great Job Board
  150. Unable to list control files
  151. can i delete the trace files in the bdump folder
  152. oracle 10g RAC installation on windows 2003 server
  153. Best Job Search Site...
  154. Web Services Implementation in Oracle 9i and Oracle 10G
  155. tkprof explain=user/password password exposed?
  156. os users, sessions, and connections.
  157. Oracle 9i - Oracle nameserver deprecated in favour of LDAP + proxy
  158. Date Insert Problem
  159. Oracle 8i to 9i migration
  160. Oracle Installer Question
  161. In Memoriam Lex de Haan
  162. Installing AS10g on standalone
  163. Installing AS10g on standalone
  164. error while installing
  165. How to tell ARCHIVE LOG make it to the BACKUP SET (RMAN) or not?
  166. Newbie question
  167. PA-RISC versus Itanium with Oracle
  168. Upgrade Question
  169. In Vs Like
  170. Oracle Databse Server Installation
  171. Oracle install for access over LAN...
  172. Security hole in Oracle?
  173. Oracle Partitions & Global Indexes
  174. Steve Adams
  175. Rebuilding a table with smaller columns
  176. Moving from 8173 to 10gR2
  177. Any Data Guard gotchas?
  178. LINUX RAC Test System Using One System
  179. ODM: Oracle9i + Veritas storage foundation 4 - Install issue
  180. Oracle 9i, 10g Admin Books
  181. Are you a NO waiting to be Katrinized?
  182. Cannot connect to database
  183. how to install oracle in suse enterprise linux 9 with dhcp enabled
  184. pb with Occi
  185. Q:versioning of DB 10g
  186. Simple fga question.
  187. BULK BIND question
  188. change location of local bin directory
  189. how often a table is updated/selected
  190. Oracle Upgrade Question
  191. Fine-grained access stuff and preventing wrong inserts/updates...
  192. Identifying Application Spawned Connections
  193. ETL between 2 Oracle 9i databases?
  194. How to install oracle 9 and 10g on one system
  195. Users identified externally Problem with workgroup installation?
  196. Attempting to get Result as "%"
  197. Supported Configuration ?
  198. Oracle 10g RAC w/Different Time zones
  199. Does selecting a primary key column in select , from a table do an automatic order by
  200. Interleave factor performance impact
  201. Oracle 10g New Features Info
  202. SQL Performance Problem
  203. Warn on login failure
  204. General Purpose or Data Warehouse?
  205. where is OEM Grid Control Rel2 for Solaris ?
  206. Oracle 10g (release1), AIX, Pro-COBOL, Problems building sample programs
  207. Oracle 9i Patches without metalink account
  208. oci7 and AIX 5
  209. Intelligent Agent running in a cluster
  210. Some characters are not indexed
  211. oracle output to excel
  212. Xg: the Ultimate Oracle 10g Security Product of 2006
  213. Command to free unused space in a data file
  214. Restart DBMS_JOBS
  215. Oracle IO tuning tips/practices on Windows
  216. Enterprise Manager on 10gR2
  217. Shared pool
  218. UPPER in a WHERE gives me a 00936 errror
  219. oracle 10g express edition
  220. Stored Procedure/Package Returning Recordset to C# application.
  221. Compute Statistics during Index Creation
  222. Oracle10 Express Database on Debian Linux
  223. UPPER in a WHERE gives me a 00936 errror
  224. Refreshing Alerts in 10g Database Control
  225. Referencing table in another schema via database link
  226. UGA - session specific information
  227. Strange CBO Behaviour with a Bitmap Index
  228. Oracle 10g on Sun T1000 server
  229. Query performance dramatically different
  230. DBCA Memory notification threshold exceed
  231. Custom Data in a CDC table
  232. Access privileges for PUBLIC User
  233. log all sql commands
  234. Simple SQL question
  235. RMAN and DAT72 tapes
  236. LIST partioning better than RANGE one here ?
  237. System Modes QUIESCE / SUSPEND
  238. Oracle 8i - turning the partitioning option
  239. Oracle SQL
  240. Oracle error (Ora-15500)
  241. Exclude MVs from full export
  242. Extents and Segment space management
  243. Java to C on win32
  244. Get Rich
  245. Using RAC for 25+ small to medium sized database
  246. How do I change the servername that XE HTTP is listening for?
  247. EM 10G Agents on Veritas Cluster
  248. After Oracle Express - now DB2 Express :-)
  249. Constraints validated
  250. Install Oracle 8i 8.1.6 on Windows 2000 SP4