|
||||
|
Q: is it my possible to make my query to change from “select ‘what is my name’ from dual” to “select ‘you’r Geek DBA’ from dual” during execution. A: this feature is called “query equivalence”. query equivalence is declared using the dbms_advanced_rewrite.declare_rewrite_equivalence procedure, and uses the syntax: dbms_advanced_rewrite.declare_rewrite_equivalence(declaration_name,source_statement,target_statement); A typical day starts like this. 1) Application team complained about slowness in their job 2) DBA looking into this No clues or details from App team saying this particular sql is that we are running but the response time of the database server is bit slow, so obvious that app team reported slowness. […] Hello, Another issue came up today!!! Issue:- ORA-15036: disk ‘string’ is truncated The size of the disk, as reported by the operating system, was smaller than the size of the disk as recorded in the disk header block on the disk. Apparently the concerned disk group is not mounting, unfortunately this contains our OCR Disks […] Hello, A Simple readable format about “What is RAID?” RAID (Redundant Array of Independent Disks). A collection of disk drives that offers increased performance and fault tolerance. There are a number of different RAID levels. The three most commonly used are 0, 1, and 5: Level 0: striping without parity (spreading out blocks of each […] This time, impdp failing to create a job for import and failing with following error:- ORA-06512: at “SYS.KUPV$FT”, In many cases you sometimes stop data pump job or in case of an abnormal end of the Data Pump job (we call it the orphaned job) or using undocumented parameter KEEP_MASTER=Y, the master table remain in […]
We got a known issue with ASM not coming up in second and subsequently failed to start crs and other resources. Review grid alert log & os Logs $GRID_HOME/log/<nodename>/alert<nodename>.log oifcfg shows $oifcfg –getif eth0 192.168.2.10 global_clusterinterconnect eth1 192.168.10.2 global usb0 169.254.95.0 eth0:2 169.254.96.0 eth0:3 169.254.95.0
From 11g R2 (I believe 11.2.0.2 onwards) there […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!