- "select count('x') from BigTable" takes more than 1 minute !
- 10.2.0.2 RAC on AIX 5.3 ml03
- 10g field varchar size
- 10g RAC network failure behavior
- 10g Recycle Bin
- 2nd table
- 9i Client Against 10g and Upgrade Gotchas
- A hint on indexes to avoid table access full
- a user to use only import
- About HASH VALUE
- Adding a database to VCS cluster
- Adv. Queuing - Learning the Basics
- Advanced Rewrite Challenge
- Advice on calendar function
- All Sample Schemas Locked and Expired
- Amount of tablespaces in 10g
- Announcing Crapplet the ultimate cracking applet!
- Announcing Crapplet the ultimate cracking applet.
- ANSI syntax slower than old style?
- any ideas on why this pice of code dosnt work??
- anyone follow the cuddletech blog?
- Anyone know how overwrite or change the date format by default?
- Appending XMLELEMENTs to existing XMLType
- archive log maintenance on physical standby
- archiving records
- ASM on Linux with SAN : yes or no ?
- ASP/OO4O Problem: Unexpect result from package
- ASP/OO4O Problem: Unexpect results from package
- Auditing
- AUSOUG/OAUG 2006 Australian conference - database content
- Auto Datafile Creation - How to aktivate ?
- Autonomous Transactions
- AWR and SQL Tuning - 10gR1
- Basic question :)
- Better Oracle 10g Realtime Perf Monitoring Tools?
- block corruption during flashcopy on ibm fastt san storage
- BMC SQL Backtrack for Oracle on AIX 5.1
- Book on Offshore Outsourcing
- Business Process Management(BPM) Tutorial,Workflow
- Calculation of remaining space in LMT's...
- Can a DBA restrict privileges of a user that is the owner of a schema? We need to remove DDL privileges. Our DBA says it is impossible. Please help!
- Can a query reuse data???
- Can you hint a table from a 'Merged' view...?
- Cannot set up Metalink login information in 10g EM Database Control
- CATSEARCH understanding
- CBO Increase the Cost of Test tables.
- Change default Schema for a user automatically
- change english oracle to chinese
- Changing a stored procedure in a package (newbie)
- check if a command has failed
- CLOBS
- Cold Backups in NOMOUNT Stage
- column user_name format a10
- Compare a table to itself
- Composite index and data distribution
- configure service name in RAC
- Configuring Oracle for JDBC
- Connection problem through sqlplus
- considerations for rebuilding and coalescing
- consolidating deferred transaction queue
- convert contents of clob to a different charset
- Converting rows to columns.
- Copy a table from 1 schema to another
- Corrept Undo Tablespace and oracle internal problem
- Corrupt current redo log file
- Costs for RMAN
- Count with zero-results
- create dynamic variables
- Create Unique Constraint with Execute Immediate
- Create user with no privs but CREATE SESSION and he can see things in SYS?
- Creating an Oracle Database for the first Time
- Creating View with WITH clause
- Crystal Reports and Oracle Stored Procedure Insert statments
- Crystal Reports csv including report detail
- CURSOR_SHARING=SIMILAR
- data guard question
- data in Oracle
- data migration from SQL server to oracle9i
- Data provider for Oracle and SQL 2005 on 64bit windows.
- Database Load or Usage calculation
- Dataguard recovery - corrupted log files
- Datapump and read only database
- DB jobs wont run for longer periods
- DBAShell - Open Source project for Oracle DBA's
- dbms_job
- Declare multiple variables
- Delete records which has referance to the same able
- Denormalizing a database table
- DESCRIBE <table_name> in SQL*Plus
- Desperately need an SQL query for the following problem
- Disaster recovery
- Disk space usage issue related to Oracle 10g RAC with OCFS2 and ASM
- Do DB Links cause high execute and fetch stats?
- do disaster recovery without pfile
- Do I have to shutdown and startup Oracle Instance after having the default 1521 listen port modified?
- does unique constraints hurt insert performance
- Drop empty table and lms flush message acks
- During Installing Oralce 9il It throw Error
- Duties of an 11i System Administrator
- Dynamic sql
- EE Partitioning license
- Encrypt Data 10G environment!
- Encrypting data witth TDE Oracle 10g
- Encrypting tnsnames.ora Using OAS
- Error during 9.2.0.8 installation
- Error when calling Package/Procedure that Inserts a row
- Estimating rollback segment size
- etl issue
- ETL stuff, informatica
- exact replica
- Excellent opportunity to in ERP Careers!!
- EXCEPTION INTO table storage
- Export to PDF
- External tables. Security concerns.
- failover JDBC thin driver connection in 10.2 RAC
- Fast utility to transfer data from one database to another excluding IMP/EXP
- Fastest way to dump tables to flat file in 10gR2
- fooling EM setup into using a different host name
- Foriegn Key Question
- Forms 10g API: changes between R1 and R2
- Free Online Exams For All Certifications
- Frequency Count
- FRM-40202 fields must be entered.
- Function to check if something is number
- Gather IO stats
- getting closer.... with auto sql tuning w/o em
- Heiarchial Data in a SINGLE column
- help connecting to oracle via javascript with osauthent
- Help me to design this table
- help with my dataguard
- Help with Triggers
- help: append query results to cursor
- HELP: Inconsistent results from SQL query run on different servers
- Here you can read books free and buy all tickets
- Heterogenous Service much slower in Oracle 9 than in Oracle 8
- Hierarchical query
- high through put system
- high through put system]
- Hints in Practice
- Hints....where are they stored....
- How do you pronounce?
- How does Oracle do this?
- How is the design for this complex requirement ?
- How should I do the load testing?
- HOW TO AVOID NOT EXISTS IN THIS QUERY TO INCREASE PERFORMANCE
- How to clear alerts in Grid Control
- how to decide SHMMAX,SHMMNI and SHMMIN
- How to determine which is the master node in RAC cluster?
- how to download 8i
- How to escape hints in PL/SQL
- How to escape hints in PL/SQL and use results of a sort to limit comparisons
- how to explain plan to table other than plan_table?
- How to find out concrete ORACLE_HOME via SQL?
- How to migrate my oracle database to another server, pls
- how to release system tablespace space?
- How to restore an RMAN backup to a new Oracle 9i Server
- How to setup Backup Failure notifications in Oracle Enterprise Manager
- How to trigger Informatica from OAE ?
- How to update 2 records simultaneously on a self-join?
- HowTo - create user defined sequence with proper serialization
- If account is locked then users cannot log in with it correct?
- Immediate need !! Sr.Oracle DBA , South Bay Area, CA -1 year
- IMP-00010 not a valid export file, header failed verification
- imp-00015 for PK constraint
- Implied commit in dbms_sql...?
- In RAC envionment. NodeB will be crashdown? When restarting...raise ora-27506 error
- Inactive sessions in Oracle
- Index strategy for huge partitioned table
- informatica
- Insert-Select much slower than same select on its own
- Installation of 10.2.0.1 on Solaris 10/06 x86-64
- Installation Oracle 10g on Suse 9.3
- Installer bug:Message 2100 not found when running sqlldr 10.2.0.2;
- installing 9.2.0.4 x86_x64 on RedHat 4.0
- Installing Oracle 11.5.8 on Mandrake
- Installing OracleXE 10g on Win
- Installing RMAN
- InstantClient for x64
- Integrity constraint violated
- invalid qualified SQL name
- Is Database Up?
- Is there a way to delete a corrupted ASM diskgroup?
- It is time for eXtreme Garbage!
- It is time to Xg!
- Java Error Ora92 OEM WinXP Win2003
- JAZN, programmatic permission checks without SecurityManager
- Kernel parameters for Oracle 9i on HP-UX 11i
- Kerning
- Limit UPDATE statements to affect only one row
- Limiting Large Result Sets
- Listener configuration
- Listener goes down
- Listener problem
- load data
- locks
- mailx is not working
- Materialized view refresh and very long wait events
- materialized view rewrite
- Measuring wait time for openning a new connection
- Microsoft Dynamics CRM 3.0 Implementation For Large Corporation (August 2006)
- Migration Question: Rac 9i on Win2k --> 10g on RHEL4
- Missing listener.ora and tnsnames.ora file
- Monitoring of non production Databases
- More than 1 filed in Select *
- Move table sys.aud$ to another tablespace
- Multi-Master Replication
- multiple tables
- My Introduction
- Need assistance for tuning
- Need help with calculating differences in row values using cursor
- Need help with query which runs faster in SQL than ORACLE
- New to Oracle: DDL in EXECUTE IMMEDIATE question
- Newbie :)
- No more Oracle Standard Edition for VMS
- Noob Oracle Question
- NOWAIT exit from sqlplus when ORA-12545
- occi connection pooling not working as expected
- OCILobRead
- OCIServerAttach returns ORA-12514
- odd number of rollback segments
- OEM browsing
- OEM Console
- OEM GUI
- OLS script
- OMWB for image data?
- one lock statement
- Optimizer not pushing filters down into view
- ORA 10G -ORA-12546 Error [semi solved]
- Ora 10g Database Control in Chinese und English
- ORA-00920 error on simple sql query !
- ORA-07445 in Alert.log
- ORA-12638
- Ora-6502 Error in assigining value to varchar2 out param
- Ora10g installed...now what ? :-)
- ora_600
- Oracle 10g - price and expiration?
- Oracle 10g and dbca
- Oracle 10g Copy Blob
- Oracle 10g enterprise on windows xp pro - startup problems from time to time?
- Oracle 10g OCI based application talking to an Oracle 9i database
- Oracle 10g on W2k3 - 32 bit or 64 bit?
- Oracle 10g RAC
- Oracle 10g startup problem
- Oracle 10g webcache Linux SSL proxy
- oracle 10GR2 EM console how to set up
- Oracle 9.2.0.x Patches - Cnfused
- Oracle and datawarehouse
- Oracle Apps Requirement
- Oracle ASM Problem
- Oracle Backup to new SID
- Oracle connection problems (MS SQL Reporting Services)
- Oracle Data Mart
- Oracle database for Windows
- Oracle database not starting up after reboot on RedHat ES4 Linux !
- Oracle DBA Job Opening in Boston
- Oracle Diriver / DSN on UNIX system
- Oracle ERP (KPI) - Performance Matrice
- Oracle Files - Index OCR'd PDF documents
- Oracle Guidence
- Oracle Installation on Sun Solaris
- Oracle on Windows
- Oracle Patch Question
- Oracle PL/SQL requirement
- Oracle query
- Oracle RAC newbie
- Oracle RAC Stored Procedure scalability
- oracle Requirement
- Oracle security roadmap
- Oracle Stream and Migration
- Oracle Update Syntax
- Oracle Upgrade Question or Issue?
- Oracle Wallet and novell eDirectory?
- Oracle Windows Client Patches
- Oracle XE and the databases
- Oracle XML Type
- Oracle® Database Express Edition
- oradebug
- Outer join query problem
- Overall executions at DB level
- Partitioned Table Indexes
- Passing Table as Variable into Procedure
- Patching...
- Performance Courses
- Performance problem with deleteing large number of rows from a table
- performance problems on new function-based index
- perl connection "/ as sysdba" doesn't work for me on solaris
- PL/SQL proc dies without a trace
- PL/SQL question regarding nested loops
- PLS-00103:
- Pro c Call from JNI
- Problem installing Oracle 10g client on Windows 2k3 server
- Problem when WIndows 2000 Server is rebooted
- Problem with command prompt SqlPlus/Imp
- problem with creating a view translating rows to columns
- puzzling trigger activity/question...
- Query on 2 table while exp and imp (Join)
- Query takes 1min 15 secs and tables are indexed !
- query taking long time from java code
- Question
- Question: SQL, XPath and several namespaces
- Quick sqlplus cr/lf question
- Rac Backups....
- RAC nodes regularly freezes for about 10 seconds
- RAC: crs_start
- recovery aproach ...
- Recovery need help ... urgent.
- redirect listener log
- Refresh my Oracle Database
- Replication performance - how to measure it ?
- Reverse engineer CREATE DATABASE sql
- RHEL AS 4 + Oracle 10g : 32-bit or 64-bit ?
- RMAN / controlfile / TDPO issue
- rman and flash recovery area
- RMAN question, wont backup archive logs because some are not there.
- Row generator that doesn't use memory( was: Advice on calendar function)
- Row migrated in new data blocks
- SA_SESSION.SET_ACCESS_PROFILE does not work for PROXY connections, any idea why?
- Save Information to DB at Crawling
- Selective Replication
- Self-Join combined with Outer Join?
- Separating Tables and Indexes
- Serialization issue on Oracle 10g
- session registration is apparently open for oracle open world
- session wait on "control file sequential read" event ,performance was very slowed
- Setting up TCPS )TCP With SSL) - Oracle Wallet Manager
- shared pool and SGA issues
- silent oracle install HELP please
- Single Sign-on between Oracle AS Portal and BEA Weblogic App Server
- Slides and paper from talk I did at Collaborate 06 on tuning Peoplesoft and Oracle
- Slow response of forms
- Small Redo Log File Size
- Solaris 10 System Boot and Database Startup
- some question on response
- Sometimes Select External Table from CSV File Return No Rows
- sorry for duplicating this message (ORA-01422 when altering table)
- Specifying the CLOBs in SQLLOADER control files
- Speed between database and apps server
- SQL query help
- SQL query: how can I hide a column in output?
- sql question
- SQL script to insert user responsibilities
- Sql Tuning
- SQLDeveloper SSL
- Statspack 9.2
- Statspack io per tablespace/datafile
- Stopping Oracle Jobs
- Stored Proc Recieving XML doc (UTF-8) into Clob data type.
- Stored Procedures
- STREAMS capture and propagate to different schema
- SUM precision
- Survey: Enterprise Architecture and Software Development
- switchover_status in v$database
- syncronize two tables
- table design for customer rates.
- Table Partitioning Question
- TEMP tablespace
- test
- Top-N query using analytic functions
- Transfer data from oracle to oracle using sqlplus only
- Treating idle and active data separately
- TRIM and database inserts/update
- Trouble executing data found on TABLE: exe_sel_dttime_xml (COLUMN: QUERY)
- Truncate a range-list partitioned table
- Truncate and free space
- tuning advisor ... again
- ultrasearch: transfer metadata from one instance to another
- UNDOTBS
- unix shell script
- upgrade 9i to 10g --> issues with connecting as sysdba
- Upgrade rdbms home
- urg pls help... migrate problem.....
- Urgent req Oracle Financial Functional Consultant at Sunnyvale, CA
- Using indexes
- v$buffer_pool_statistics: How to interpret data?
- Version10.2.0.2.0
- Virus Warning
- VPD and/or Partitions, Performance Consideration ?
- What can cause nologging?
- what is use the parameter "adress_list" int the listener.ora
- What privilege needed to use Oracle Enterprise Manager
- Where to get Oracle 10g client for Fedora5
- why does a bitmap index grow so fast but shrinks after recreating it
- Workspace Manager Question
- XMLQuery bug?
- XMLType design implications
- Last message date: Fri Sep 01 2006 - 00:59:12 CDT
- Archived on: Sun Dec 30 2007 - 04:39:25 CST
|
