Estimate in progress using

是慢,慢的离谱,就是问题

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA parfile=exp_cps_1.par 

Estimate in progress using STATISTICS method...


后来做了调整,就好了:

userid='/ as sysdba'
DIRECTORY=ggpump
dumpfile=exphj_cps_userdba01_%u.dmp
logfile=exphj_cps_00userdba01.log
parallel=4
EXCLUDE=STATISTICS
CLUSTER=N
ESTIMATE=STATISTICS
FLASHBACK_SCN=446961807653
SCHEMAS=userdba


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."CPS33":  /******** AS SYSDBA parfile=exp_cps_3.par job_name=cps33 
Estimate in progress using BLOCKS method...


处理的时候从等待上分析问题:无果

expdp attach= 问题分析很慢!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
To estimate the ordered probit model using Maximum Likelihood Estimation (MLE), you can use the "VGAM" package in R. Here is an example code: ```R # Load the "VGAM" package library(VGAM) # Load the data (in this example, we use the "Prestige" dataset) data(Prestige) # Define the dependent and independent variables y <- Prestige$prestige x1 <- Prestige$education x2 <- Prestige$income # Define the log-likelihood function for the ordered probit model loglik <- function(theta, y, X) { mu <- X %*% theta p <- pnorm(c(-Inf, mu[-length(mu)], Inf)) lp <- diff(p) lp[y == length(p)] <- p[y == length(p)] ll <- sum(log(lp)) return(-ll) } # Estimate the ordered probit model using MLE op <- vglm(y ~ x1 + x2, family = cumulative(parallel = TRUE), weights = rep(1, length(y)), control = list(maxit = 1000, trace = TRUE), initdata = data.frame("estimate" = c(0, 0, 0)), coef = TRUE, method = "BFGS", crit = 1e-6, loglik = loglik, X = cbind(1, x1, x2)) # Print the summary of the model summary(op) ``` In this example, we define the log-likelihood function for the ordered probit model, which takes the parameter vector `theta`, the dependent variable `y`, and the independent variables `X` as input and returns the negative log-likelihood. We then use the `vglm` function to estimate the model using MLE. The `family` argument specifies the cumulative link function, and the `weights` argument specifies the weighting scheme. The `initdata` argument specifies the initial values for the optimization procedure. The `loglik` argument specifies the log-likelihood function, and the `X` argument specifies the design matrix. Finally, we print the summary of the model using the `summary` function. Note that the exact code may vary depending on the dataset and software package used. Also, it is important to note that MLE can be more computationally intensive than other methods for estimating the ordered probit model.

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值