DBA Blogs

Oracle Materialized View Fast refresh on remote database

Tom Kyte - Tue, 2016-08-23 16:06
GM Tom, In my current db implementation, we do not have any data/tables in our db and gets all data from two other data sources. To do so we have created Materialized Views using dblinks to get data from these two other db sources. We use to COMPL...
Categories: DBA Blogs

Force Query to use a hash plan

Tom Kyte - Tue, 2016-08-23 16:06
Hi Tom, I have SQL HC for a SQL ID which shows the query have two Hash Plans one is Optimal and another which elapse a lot. And my query is taking long time to run which means that it is using the worst plan. I want to force my query to use the O...
Categories: DBA Blogs

a sql query which pulls all the record with the same first name and email and if one row has email and other has no email but i have same phone number in cluster

Tom Kyte - Mon, 2016-08-22 21:46
a sql query which pulls all the record if one cluster has same first name ,last name and one (i.e 22 )has email and other has no email but i have same Phone number There are about million of records,i have to fetch all the records according to the...
Categories: DBA Blogs

Slow select after bulk insert-remove

Tom Kyte - Mon, 2016-08-22 21:46
I have the problem, that I could describe in several steps: 1. Insert 160K into table t_reg_account. Here I use simple insert statement without any hints. I_ACC_PK index on participant_code, account_type, account_value, account_sequence. 2. Execu...
Categories: DBA Blogs

Kindly guide for Oracle DBA self learning methods,

Tom Kyte - Mon, 2016-08-22 21:46
Hi, At present am working as PLSQL developer, I want to Learn DBA but I am not interested in Institute learning,believe I could learn more through self learning. Kindly guide me with the books to learn from scratch to advanced DBA. Thanks! R...
Categories: DBA Blogs

RMAN duplication fails.

Tom Kyte - Mon, 2016-08-22 21:46
Hi I am trying to duplicate database . When I do do that , at the end of the process , I am getting RMAN-06025 . why does it try to apply the non exisiting log imn the auxillary db? Thanks RMAN> run { 2> 3> allocate auxili...
Categories: DBA Blogs

PLSQL Code type native compilation

Tom Kyte - Mon, 2016-08-22 21:46
Hi Tom, what are the pros and cons if I convert my plsql code type to Native? I have package bodies, procedures & functions where most of my code runs. I do have lot of data extractions taken from DB & number of PLSQL programs that run for hours....
Categories: DBA Blogs

Copying data from one environment to other

Tom Kyte - Mon, 2016-08-22 21:46
Hi, what is the best way to copy data from one environment (PRD) to other environment (NON-PRD) in oracle installed on UNIX server? Thanks, DIPU
Categories: DBA Blogs

Uncommited changes in data files?

Tom Kyte - Mon, 2016-08-22 21:46
Hi, While i was studying "Instance Recovery" topic in the "Oracle 11g Concepts" document, i read something something like this; "When a transaction is committed, log writer (LGWR) writes both the remaining redo entries in memory and the transac...
Categories: DBA Blogs

Sequence.nextval not working in sqlldr

Tom Kyte - Sun, 2016-08-21 09:06
sequence.nextval not working when i am using in sqlldr , sqlldr loading null value in DB Snapshot of my control file load data append into table Selectiotab WHEN (1:2) <> 'H|' and (1:2) <> 'T|' fields terminated by "|" trailing nullcols ( ...
Categories: DBA Blogs

As a DBA how to verify if private database link is functional

Tom Kyte - Sun, 2016-08-21 09:06
Hi, Being a DBA, how can we verify if private database link created in application schema is working fine? If application schema's password is not known to DBA. We can verify public database link using select * from dual@public_db_link; How pri...
Categories: DBA Blogs

HOW TO TAKE BACKUP OF A TABLE WHICH IS BELONGS TO DBF FILE. AND IS IT SAFE TO DO THAT FOR APPLICATION

Tom Kyte - Sun, 2016-08-21 09:06
HELLO SIR, my name is bhargav reddy from Bangalore, actually i am a student, i want to know how to take backup of .DBF file which is belongs to live application, so please tell me the process to do that and one more thing that is it safe to take ...
Categories: DBA Blogs

Notification mail from database server

Tom Kyte - Sun, 2016-08-21 09:06
Hi team, I have manually check the tablespace size daily basis now i want to configure the script which check the tablespace size and if the size is less than 10GB then it will send a mail to mai Id So, Which things we need to configure on ser...
Categories: DBA Blogs

Error while trying to retrieve text for error ORA-01804 12c occi c++ application on ubuntu

Tom Kyte - Sat, 2016-08-20 14:46
Hello every one please help me after installing oracle 12c in ubuntu 16.04. I am try to check by simple c++ occi connection code,but from my code at create environment :- env = Environment::createEnvironment(Environment::DEFAULT); display error like:...
Categories: DBA Blogs

Migration from 9i to 12c Pro*C server application.

Tom Kyte - Sat, 2016-08-20 14:46
We are migrating or legacy 32 9i Pro*C server code over on to a new Oracle Solaris 11 Unix and Oracle 12c server. Can we run the legacy 32 legacy code running on the 32 bit server pointing to the new 12c database server? Oracle will be doing the ...
Categories: DBA Blogs

ORA-04052: error occurred when looking up remote object FPL.COIMREGI@FPL

Tom Kyte - Sat, 2016-08-20 14:46
Hi, I have a problem when I try to compile a function in a database oracle 9.2.0.8, and I got this error: PL/SQL: ORA-04052: error occurred when looking up remote object FPL.COIMREGI@FPL ORA-00604: error occurred at recursive SQL level 1 OR...
Categories: DBA Blogs

Recieving error ORA-01460: unimplemented or unreasonable conversion requested when running sp to update a clob field.

Tom Kyte - Sat, 2016-08-20 14:46
I have written an SP, based on the posts I have read on your site, which is designed to take the text (originally from script files) and update an existing record containing a CLOB field. This works fine with the text from smaller files, but when I t...
Categories: DBA Blogs

Setting up lower environment

Tom Kyte - Sat, 2016-08-20 14:46
Hi, I'm looking for a solution/best approach to set up my lower environments from Production with pared down version, say 90-100% data for UAT, 30% for SIT and 10% for Dev environments. Can you suggest an approach to achieve this at schema level? ...
Categories: DBA Blogs

Using SYS.REFCURSOR out variable as a source for classic report in ORACLE APEX.

Tom Kyte - Sat, 2016-08-20 14:46
Hi , I have a urgent requirement, I have been struggling through it alot. WE have a package created in database which is having a procedure with (5 input variables and 1 out variable (which is a sys refcursor). Now the rason why we have used...
Categories: DBA Blogs

Links for 2016-08-19 [del.icio.us]

  • Access Denied
    via Oracle Partner Hub: ISV Migration Center Team http://ift.tt/1AAiVSD
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs