Author: Sriram Sanka
-
How not to Play With Oracle Dual-Magical Dual
Here is an Interesting topic about FAST DUAL and Full Table Scan on Dual table with some example about how not to play with Oracle Data Dictionary Objects. http://www.orafaq.com/forum/mv/msg/173068/515910/136607/#msg_515910 Happy reading…. Sriram 🙂
-
Password Hash In Oracle 11g
Let `s discuss about The Changes Of DBA_USERS Especially In PASSWORD Column In Oracle 11g and 10g. DBA_USERS Gives Us Information about all users of the database. And it contains password hash value In its PASSWORD Column Yes..It contains the encrypted value Based On Concatenation of Username and Password This Is How/why two Users with…
-
ORA-00059: maximum number of DB_FILES exceeded
This is all about the Relation B/W MAXDATAFILES and DB_FILES In Oralce Database. –This will Give Us db_files value. max no of data files that we can add. select value from v$parameter where name = ‘db_files’; This will give the MAXDATAFILES specified at Control file level while creating Database. select records_total from v$controlfile_record_section where type…
-
Spell number In Indian Currency System Using Function (Number into words)
As we all know We can convert number into words Using ‘Jsp’ format string in to_char function. ind> select to_char(to_date(‘250′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘ —————– TWO HUNDRED FIFTY 1 row selected. ind> select to_char(to_date(‘259′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘259’, ———————- TWO HUNDRED FIFTY-NINE 1 row selected. ind> select to_char(to_date(‘9999′,’J’),’JSP’) from dual; TO_CHAR(TO_DATE(‘9999′,’J’),’JSP’) ————————————– NINE THOUSAND NINE HUNDRED NINETY-NINE…
-
#1 Recovery from Loss of Non system datafile(In Archive log Mode)
In Order to Perform/Test this Scenario…..We should delete/Drop One Non system Datafile. But This not possible to drop/Delete files when Database is Up and running …… “The process cannot access the file because it is being used by another process.” here I `ll copy/Replace User datafile with an Old datafile. In shutdown mode I will…
-
How to read Oracle Explain Plan
The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer.A statement’s execution plan is the sequence of operations Oracle performs to run the statement.execution plans are read inside-out.if there are two statements at the same level, the first statement is executed first. You can use “Explain plan statement for this.” which should be…
-
Change In “Wrap” methods Of oracle Versions
As we all know , We can wrap the source code using wrapper utility.In the same way Oracle has wrapped some objects in Oracle Database By default. But there is some change in its wrapping methods. For Example.. In Oracle 10g CREATE OR REPLACE FUNCTION “SYSMAN”.”DECRYPT” wrapped 0 abcd abcd abcd abcd abcd abcd abcd…
-
All about the DUAL
The Magic table DUAL is owned by User SYS as its an dictionary object. ind> select object_name,owner,object_type 2 from dba_objects 3 where object_name like ‘%DUAL%’; OBJECT_NAME OWNER OBJECT_TYPE ———— ———————- ——————- DUAL SYS TABLE DUAL PUBLIC SYNONYM 2 rows selected. ‘Dual’ is a special table with 1X1 (1 row and 1 column) owned by sys…
-
Oracle Fixed(/Dynamic) views
“Oracle maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables.” Why the term “Fixed”? Because They are fixed ..One cannot perform any DML , DDL or any operation other than “SELECT“,thats why these views/Tables are known as Fixed. ind> select banner from v$version; BANNER —————————————————————- Oracle…
Sriram Sanka 