Oracle DBA Workshop

Oracle journey. Technical information and real world scenarios. Have Fun!!!.

Showing posts with label INTERVIE QUESTIONS. Show all posts

Sunday, March 3, 2019

at March 03, 2019 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: INTERVIE QUESTIONS

Older Posts Home

Subscribe to: Posts (Atom)

Blog Archive

▼ 2019 (44)
- ▼ April (5)
- ► March (39)

Labels

APEX
Datapump
Exadata
INTERVIE QUESTIONS
Middleware
ORA Errors
Oracle General
Restore and Recovery
RMAN
Shell Scripts
Tuning
Unix

Send Message

Name

Email *

Message *

Total Pageviews

Map

>

Today

Search This Blog

Popular Posts

ORA-00959: tablespace 'XXX' does not exist - imp or impdp

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and ...
ORA-27154: post/wait create failed, ORA-27300: OS system dependent operation:semget failed with status: 28, ORA-27301: OS failure message: No space left on device, ORA-27302: failure occurred at: sskgpcreates - When creating new instance

Today I see below errors when trying to create new instance in DEV environment (It has already 3 instance, I was trying to create 4th one). ...
Data Pump impdp/expdp : Extract DDL and DML from dump file using SQLFILE option

Using data pump IMPDP utility we can generate SQL or DDL/DML from the dump file using SQLFILE option. When you execute IMPDP with SQLFILE o...
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout KUP-11024: This external table can only be acce...
Cleaning Oracle SYSAUX Tablespace Usage - SYSAUX tablespace is 97.51%

Normally the SYSAUX tablespace is more or less stable so it would be smart to check what is eating the space in there. Connected as a DBA...
ORA-01653 error while upgrading APEX from 4.2 to 5.0 and Application Express is already installed (APEX_050000)

Trying to upgrading from 4.2 to 5.0 Steps followed - Initiated @apexins.sql APEX SYSAUX TEMP /i/ - In the middle of the upgrade I got faile...
HUNG IN AUTO SQL TUNING TASK

Issue- In 11.2.0.3 database , we get alert in EM related to metric “Generic Operational Error” or "Generic Operational Error Status ...
How to check ORA error or Viewing Errors with the oerr Utility?

Many Oracle products on UNIX have a utility called "oerr" that can be used to aid error investigation. The "oerr" u...
Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-19758136241&id=2118136.2
Don't Forget System Level Statistics

If you do any work with performance tuning, you know the importance of Object Level statistics. Oracle uses this information to estimate how...

Live Traffic

Live Traffic Feed

My Blog List

DBA Scripts for Oracle

About Me

balla

View my complete profile

Simple theme. Powered by Blogger.