DBA Blogs

SGA memory dynamic change

Tom Kyte - Fri, 2017-03-03 23:46
hi Tom, there is a question We have DB with following SGA info: SQL> select * from v$sgainfo; NAME BYTES RESIZEABLE -------------------------------- ---------- ---------- Fixed SGA Size 22...
Categories: DBA Blogs

Script to allow specific users the ability to kill a session

Tom Kyte - Fri, 2017-03-03 23:46
Hi, Is there a script available that can kill a session but will only allow specific users (pre-defined in the script) the capability to perform the kill? If not, how can this be performed?
Categories: DBA Blogs

Compile procedure automatically -- how to avoid cascading invalidations

Tom Kyte - Fri, 2017-03-03 23:46
I've two procedures: A calls B to do something. If I compile B, then A will become invalid. Can I have any setting in the database in order to compile A automatically when B is compiled? Thank you for your sincere help!
Categories: DBA Blogs

SQL Tuning advisor from SQL Developer throws ORA-00942 table or view does not exist error

Tom Kyte - Fri, 2017-03-03 05:26
Hi Tom, I tried to execute SQL tuning advisor for an sql id from back end (PUTTY session). It was keep on executing and never completing. Command: EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => 'g49yug9c4aar1_tuning'); I created a tunin...
Categories: DBA Blogs

Update parallelization

Tom Kyte - Fri, 2017-03-03 05:26
I need to do a heavy operation on each row of a big table. In order by paralelize this work I've created a table taking the rowid(C1) from the original table and adding a numeric field 'C2'. If C2=0 this row has not been proccessed and if 2C=1, th...
Categories: DBA Blogs

dynamically assign a collection value to variable

Tom Kyte - Fri, 2017-03-03 05:26
emp table create table emp(empno number,ename,varchar2(30),sal number deptno number); dept table create table dept(deptno number,deptname,varchar2(30); declare type ty_test(emp emp%rowtype,dept dept%rowtype); type ty_table is table of ty_tes...
Categories: DBA Blogs

users and security

Tom Kyte - Fri, 2017-03-03 05:26
i have create the one test user with default tablespace users, now i need to access to test user to access the other schema such as hr, and test user able to create the table in hr schema as well, how to solve this issue??
Categories: DBA Blogs

Protection from database server crashes using DB_ULTRA_SAFE

Tom Kyte - Fri, 2017-03-03 05:26
Good Morning, In the last four years, all of our block corruptions have occurred after the database server has crashes. In total, this has occurred three times, we have about 12 prod databases and each database has experienced about 4 crashes eac...
Categories: DBA Blogs

How to get SQL text for session blocked and which session blocked it

Tom Kyte - Fri, 2017-03-03 05:26
I tried finding out ways to get SQL text for blocked and blocker session's sql. I am not able to get to it. V$SESSION contains either currently executing SQL ID or previous one only. But the session for which the other session is blocked may issue mu...
Categories: DBA Blogs

DB 12.2 online table move with TDE

Tom Kyte - Fri, 2017-03-03 05:26
With 12.2 out and it's new online move feature, is it supported to do an online move of a table from an un-encrypted table space to an encrypted table space?
Categories: DBA Blogs

dbmssml.sql dbca error during container & pluggable database creation

Tom Kyte - Fri, 2017-03-03 05:26
Hi Tom, Dear Tom. As per my correspondence to you at 12:19 p.m. est. please see attached screenshots of the Oracle 12c 12.1.0.2 install error. Please see the following error file pics for the Oracle 12c 12.1.0.2. database install on Window...
Categories: DBA Blogs

How do I access data from a Foxpro(6.0) database

Tom Kyte - Fri, 2017-03-03 05:26
Dear Sir, How do I access data from a Foxpro(6.0) database from Oracle 11g in Linux platform? I have already installed oracle Gateway, but still I need a Linux 64bit ODBC driver for FoxPro. I have tried accessing your old posts but failed (http://...
Categories: DBA Blogs

Links for 2017-03-02 [del.icio.us]

Categories: DBA Blogs

Oracle Database HA and DR Cloud

The Database High Availability and Disaster Recovery needs of customers traditionally have required significant capital investment in the infrastructure that provides the redundant capabilities that...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Merge Statement

Tom Kyte - Thu, 2017-03-02 11:06
Hi, I am working on Merge statement. I know Merge is used to update/insert/delete the data. In my program,for new record do insert and existing record,do nothing.But when using merge statement 'ON' clause we are checking the data with the source ...
Categories: DBA Blogs

SQL to find gaps in date ranges

Tom Kyte - Thu, 2017-03-02 11:06
Hi All, I would like to get the gaps between date range and needed it to separate the gaps by MM ID. could you please someone help me to resolve below INPUT: ID | MM Number | From | To 12345|4444444 |2015-01-03 |2015-02-02 123...
Categories: DBA Blogs

Index types in oracle

Tom Kyte - Thu, 2017-03-02 11:06
Hi Tom, Could you please explain what are all the types of indexes available in oracle. I am confused with the google summary as on one site they mention b-tree, bit map, functional based index.... on on other as clustered and non c...
Categories: DBA Blogs

SQL loader not loading if column value in multiple lines and value enclosed in double quotes.

Tom Kyte - Thu, 2017-03-02 11:06
hi , when I am loading data for one column value speeded in multiple columns and its failed. Here is the example and syntax for control file,record failing due to values in multiple lines for DESCRIPTION column "0","test0","123235","testitem0"...
Categories: DBA Blogs

In APEX, I am trying to write an output text file.

Tom Kyte - Thu, 2017-03-02 11:06
In APEX, I am trying to write an output text file. I keep getting ORA-29280 Invalid directory path even though I specify paths where I do have write access. *Maybe* I need to have a file browse to find the output directory. Is there a file browse ...
Categories: DBA Blogs

Connecting MS Access to Oracle

Tom Kyte - Thu, 2017-03-02 11:06
I have a Windows 8.1 machine with Access 2013. I am trying to connect to an Oracle database. I installed Oracle instant client 12.1.0.2.0. When I create a data source using Microsoft ODBC for Oracle (driver: MSORCL32.dll), I get an ORA-01019 error. W...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs