Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: oracle-11g-r2

What could be the possible reasons for cardinality estimates being very inaccurate in an execution plan?

By adminPosted on February 6, 2023

Question : I have a query that is selecting some data out of a table. The execution plan shows that […]

ORA-01017: invalid username/password; logon denied

By adminPosted on February 2, 2023

Question : I’ve come across the abnormal situation, and can’t understand what happens. I am connecting databases using PL/SQL Developer […]

Eclipse data source explorer not showing Inserted table records (Oracle)

By adminPosted on January 31, 2023

Question : After I installed Oracle database 11g, I went to Eclipse Database Development Perspective and successfully created a new […]

Unable to remove a user in Oracle 11g

By adminPosted on January 30, 2023

Question : I have a streams replication related user in Oracle 11g. I see the user in dba_users table and […]

Is wrapping only possible for package bodies?

By adminPosted on January 29, 2023

Question : I am using oracle 11gR2 database in which I was trying to wrap my scripts. I read the […]

How to make stored procedure with outputs OUT sys_refcursor, OUT varchar2, and OUT number, then use in c#.net app

By adminPosted on January 26, 2023

Question : What is the syntax for a stored procedure that outputs a refcursor, a varchar2, and a number? I […]

RMAN Recovery In Oracle 11g : Backup Database To Tape

By adminPosted on January 25, 2023

Question : On issuing this command: RMAN> backup device type sbt tablespace <tablespace_name>; we are getting the following error: ORA-19554: […]

Does using “qb_name()” hint (query block name) in a query have significant effect on performance?

By adminPosted on January 25, 2023

Question : I’ve just become familiar with the hint “qb_name” (query block name) in Oracle and below you can see […]

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

By adminPosted on January 24, 2023

Question : In our data feeds, we have a stack of XML files as well as numerous flat files to […]

Force number precision in a view with Union

By adminPosted on January 23, 2023

Question : I am using Entity Framework and Oracle. Oracle’s ODAC seems to have a known bug where data of […]

  • 1
  • 2
  • 3
  • …
  • 56

Recent Posts

  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege
  • Native checksum table says there’s a difference, pt-table-checksum does not

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding