This page is dedicated to collect important Oracle learnings.
- Coding standards PL/SQL SQL 2022
- create table as select and NULL columns
- converting LONG to CLOB
- deterministic functions
- finding partition name based on HIGH_VALUE using TBL$OR$IDX$PART$NUM in SQL, PL/SQL, keyword “PARTITION FOR”
- CUBE,ROLLUP,GROUPING SETS,GROUPING_ID,GROUPING,GROUP_ID
- Join operation in Oracle
- Hints to control join operations 11g
- Sqldeveloper debugger
- Sqldeveloper remote debugger
- NLS_NUMERIC_CHARACTERS as easy as possible
- Options, Features and Properties of your Database
- Oracle metrics from AWR tables using sqldeveloper report
- Hints to control access path 11g
- Visualize your query in sqldeveloper
- Calling unix command or windows command from PL/SQL
- NULL in SQL and PL/SQL
- Detect duplicates in primary key constraints
- Autonomous transaction
- Authid definer, authid current_user
- Oracle instead of trigger on view – non preserved key
- Oracle – generate rows as INSERT statements from table, view using PL/SQL
- Loading files as CLOB or BLOB column using sqlldr
- How to trace session – event sql_trace
- DBMS_PARALLEL_EXECUTE
- Oracle user defined aggregate function
- Compare objects in Oracle with DBMS_METADATA_DIFF
- Duplicate records based on a column value in Oracle
- Oracle SYS_OP_MAP_NONNULL function
- DML Error Logging in Oracle Database 11G release 2 (11.2)
- Partition outer join in Oracle (data densification)
- Modify sqlplus prompt in Oracle Database
- Kill session in Oracle
- Oracle password reset
- Oracle proxy database connection
- NOLOGGING and recovery in Oracle
- Finding source code in Oracle
- Patch terminology in Oracle databases
- Status in AUD$ ACTION#
- Constraints on views in Oracle
- ORA_ROWSCN, NOROWDEPENDENCIES, ROWDEPENDENCIES in Oracle
- String concatenation aggregation methods
- String split methods
- ORA_HASH and CLOB problem
- Oracle GANTT report in SQL
- WITH clause and hints MATERIALIZE and INLINE
- Transform SQL to XML in Oracle
- QB_NAME – control execution plans in views
- Dump Upload CLOB to, from file in Oracle
- SYS.USER$ table in Oracle – last password change time, last locked, last expired, creation time, failed logon
- Oracle clone schema using PL/SQL
- Oracle dump SQL as CSV files
- Create drop database link in another schema Oracle
- Set autotrace in sqlplus
Performance
- Measure storage performance in Oracle
- Oracle estimate index size for create rebuild operation
- Effective parallel execution for DML, DDL in Oracle
- Oracle virtual index – nosegment index
- Indexing NULL for Oracle
Oracle bugs ORA-XXX explanations
- ORA-01795, limit on in clause
- Exchange partitions compressed table and unused columns ORA-39726, ORA-14097
- ORA-12526 TNS:listener: all appropriate instances are in restricted mode
- Loading data in direct mode and unique index ORA-26026
- Hakan factor ORA-14642, ORA-14643
- ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
- ORA-01000: maximum open cursors exceeded
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- ORA-00845: MEMORY_TARGET not supported on this system
- Using CLOB in external tables – KUP-04026
- ORA-22992, ORA-64202 cannot use LOB locators selected from remote tables
Hi ,
I am new in DBA line so can you please guide me from where i can start learning from dba so i can able to solve the problems easily.
There are many pages where you can find many informations about Oracle. However the best source is Oracle help. There is DBA in 2-day tutorial. i think it’s good start. Juts type “oracle help 12c 2 day dba” in google and you should get link to video tutorial plus link to 12c help.
Hi,i am so glad to find your article about installing oracle database on fedora 21. Actually, i have been trying so hard to install oracle 11g r2 on fedora 12, because i used to be taught to do that. The joke (we may call it) is that i had tried three times seriously to make it, but each time there were different problems either concerning linux itself or the packages and software compatibility and version.In fact, nearly two years ago, i had classes for linux and oracle, which were taught at the same time and only lasted for one semester.What’s worse, it was very easy for me to mix them .And believe it or not, because my teacher tended to be so serious and a kind of rigid that i used to be full of awe for oracle and linux.Now i am in my graduate school.i want to make it and conquer my fears for them.And after more than ten times installation and mistakes,i know that it is only a matter of time and patience,though i am still on the way to make it.Thanks for your sharing. For me, sharing is virtue.Thanks a lot.
good
excellent outstanding website.,sir add partition quotas installation detailed post.
Pingback: Tips for Oracle SQL Query Writing and Performance Tuning – Asit Acharya
This is a great source of information