An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • Oracle White Papers
  • Disclosure
  • About

Tag: create_stat_table

September 7, 2009January 23, 2017 Alex Lima

How to backup and restore statistics using dbms_stats?

Follow Me

  • Twitter
  • LinkedIn
  • YouTube

Categories

  • 18c (2)
  • 19c (3)
  • AIX (1)
  • Archivelog (3)
  • Auditing (2)
  • AWR (10)
  • Backup (4)
  • Backup & Recovery (35)
  • Batch (1)
  • Big Data (1)
  • Built-in stored procedures (1)
  • Connections (1)
  • Control file (3)
  • Cursor (3)
  • Database (12)
  • Dataguard (3)
  • Dataguard (3)
  • Datatypes (6)
  • Date (2)
  • Docker (1)
  • exp (2)
  • Export (6)
  • Flashback (5)
  • General DBA (268)
  • Globalization (6)
  • GoldenGate (27)
  • Grant (5)
  • Initialization (4)
  • install (2)
  • Internal (4)
  • JDBC (5)
  • Jobs (4)
  • Linux (1)
  • Listener (4)
  • LOB (2)
  • Lock (3)
  • Log Miner (1)
  • mac (2)
  • Microservices (12)
  • Monitor (1)
  • MySQL (2)
  • NetApp for Oracle (2)
  • OCI (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • oradebug (9)
  • OS (2)
  • osql (1)
  • Parameters (8)
  • partition (1)
  • Password (3)
  • performance (1)
  • PL/SQL (4)
  • postgres (1)
  • Power Shell (2)
  • Primavera (3)
  • Profiler (1)
  • Project Management (3)
  • REST API (1)
  • RMAN (36)
  • role (3)
  • Scheduler (9)
  • Scripts (26)
  • Security (7)
  • sga (4)
  • Shared Pool (3)
  • Shell (15)
  • snapshot (1)
  • SQL – DDL (4)
  • SQL Developer (2)
  • SQL Server (69)
  • SQL*Plus (17)
  • SQLcl (2)
  • startup (4)
  • Statistics (14)
  • Statspack (3)
  • Table (3)
  • tablespace (2)
  • trace (32)
  • Transaction (5)
  • Tuning (35)
  • Tuning (6)
  • Undo (1)
  • Unix (33)
  • Upgrade (1)
  • vi (5)
  • windows (9)

Follow Alex's Blog

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 597 other subscribers

Twitter Updates

  • Oh boy... twitter.com/ajtourville/st… 17 hours ago
  • Posts from the past... Purge Trail File manually from OGG #OCI oraclespin.com/2021/11/21/pur… #sqldeveloper #oracle… twitter.com/i/web/status/1… 18 hours ago
  • 2 people followed me // automatically checked by fllwrs.com 1 day ago
  • Posts from the past... #GoldenGate Add Extract – (Part 3 Rest API Series) oraclespin.com/2021/10/10/gol… #oci… twitter.com/i/web/status/1… 1 day ago
  • Ooh La La! We’ve added our 38th #cloud region in Paris! 🇫🇷☁️ social.ora.cl/6016ziZQu social.ora.cl/6017ziZQR social.ora.cl/6018ziZQr 2 days ago
Follow @aoflima

Recent Posts

  • GoldenGate Microservices Initial Load Instantiation with WebUI
  • How can we build our REST API calls from Goldengate adminclient?
  • Quick GoldenGate WebUI HUB Replication Configuration
  • SQL Developer / SQLcl “info+” command
  • Demo – How to Quick Automate GoldenGate Microservices Replication

Top Posts

  • How to find jobs currently running or history about the jobs?
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to find the NLS_LANG to set for a database?
  • How to delete archive logs already archived to backup device?
  • How to see current utilization of processes/sessions and max utilization?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to lock/unlock statistics on a table?
  • ALTER DATABASE BEGIN/END BACKUP
  • How to create cold backup using RMAN?
  • How to extract the DB LINKS DDL with the password
Powered by WordPress.com.
 

Loading Comments...