LOBs deal with unstructured data, the ones which are the most difficult to store and retrieve in a relational database.
In this article, I am going to discuss extensively and manipulate the ORACLE
* LOBs that are stored in the database itself like BLOB,CLOB,NCLOB ,and
* LOBs like BFILE which are Stored outside the database as Operating System files.
First let us create a directory :
create or replace directory my_dir as 'D:\pics';
BFILEs act as a pointer and store the location of the external OS files in database tables.
For any company the most important asset is data and the most challenging job is to recovery the database with less downtime with out any data loss, in the event of database failure. In many situations users end up with incomplete recovery of the database with out knowing which data files backed and which data files need to backup. You should ensure that your database is backed up efficiently and should restore successfully when needed. The RMAN reporting provides effective and easy way to determine database backup for a successful recovery.
Suppose your boss calls you one day and tells you that there has been some unexpected changes in the employee database.Employee's designation, their salary are being manipulated illegally.Such things have been continuing from a past few days and he asks if you could help getting hold of the culprit.
Don't worry Oracle's DBMS_FGA package will save your day and earn you a raise in your job.
The Oracle DBMS_FGA package provides fine grained auditing on objects.
To have an overview of the summary of dbms_fga subprograms visit :
Often DBAs may look to tuning the UNDO* parameters as a solution towards the infamous "ORA-1555 snapshot too old" error. In most cases, before looking to tune UNDO* parameters, the best solution is to tune the query that's running into the ORA-1555 error so the query will not error out with ORA-1555 to begin with!
Hope this helps a fellow DBA or two trying to resolve the ORA-1555(s) !
Generic query generating a list of date time. You need to substitute required interval number.
I am sharing a nice article on RTF template design written by one of our senior consultant Mr. Venkat from Adiva Consulting.
The objective of this post is to explain the “sorting” capabilities available in the RTF. Many might
already be aware of the standard BI Publisher syntax for sorting in the RTF template:
The above construct sorts the data by the VENDOR_NAME in ascending order – an alphabetic sort
is performed. However, what if the requirement was to sort on a number field.
Summary: An index created on column that has many duplicated rows can be tuned to save space as well as I/O trips by compressing the index defined on it.
Details: By default when we create index in Oracle, the compression is disabled on it. What if we have an index defined on a column that contains last name of all the customers, some of the names are very common as a last name. We can take advantage of this duplicated data by compressing the index defined on it.
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
SQL> shutdown abort;
ORACLE instance shut down.
sQL>create pfile='c:/initnew.ora' from spfile;
The longer you've been working as a DBA, the more you've encountered things like these:
The time on a table changed and you don't remember doing it. You poke around but can't figure out who changed it.
There's someone you don't trust that you have to give access to. They are the kind of person that will look at things they are not supposed to, but you have to give them access.
There's someone who always messes things up when they get access. You know they'll do it again and you'll have to undo the damage. Would be nice to know what they are doing.
There's a contractor or a new employee that need access. You don't know them yet and not sure how reliable they are. It would be nice to be able to keep an eye on them.
Too many people have too much access and you're losing control. You try to figure out how to reduce the access they have or revoke some privileges, but this is pretty much what everyone claims they need to do their jobs.
You've been through an audit and the auditor wanted to know all sorts of things about the activity. Questions you just don't have the information needed to answer.
You probably spent many days chasing down the answers to these questions or try to find ways to collect it. The security in the database is set properly. The problem is that you need to know what people are doing with the access they have. This knowledge will give you more control.
Performance Improvement in Pro*C
Pro*C code compilation builds executable depends on the parameters passed while compiling a code on Linux OS. GCC compiler is widely used for compilation.
Parameters that it provides enables memory management and linking etc...
This means : Without changing Code GCC compilation parameter change can give significant improvement in performance without impacting functionality. Attached document contents details study of the same.
This document gives details about environment,deployment and pre-post change analysis.
Sanjay J. Sontakke